From 65de9655c6002bbfee76f1c3c45b312615fb375a Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Sun, 4 Oct 2015 17:03:34 -0700 Subject: BUGFIX: fix mysql insert statements (null values for timestamps didn't work anymore) a dreamhost update to a newer sql version changed the default behavior for null inserts for timestamps. They don't insert the current timestamp anymore when a config option for mysql is set (which seems to be the case). solution: instead of inserting null always insert current_timestamp --- include/newgame.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'include/newgame.php') diff --git a/include/newgame.php b/include/newgame.php index 1dd056d..eb0dbdb 100644 --- a/include/newgame.php +++ b/include/newgame.php @@ -128,7 +128,7 @@ else } if($session) - DB_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1',NULL,'pre',". + DB_query("INSERT INTO Game VALUES (CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '$randomNRstring', 'normal', NULL,NULL,'1',NULL,'pre',". "'$ruleset','$session' ,NULL)"); else { @@ -136,7 +136,7 @@ else $max = DB_get_max_session(); $max++; DB_query("UPDATE Game SET session='".$max."' WHERE id=".DB_quote_smart($followup)); - DB_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1',NULL,'pre',". + DB_query("INSERT INTO Game VALUES (CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '$randomNRstring', 'normal', NULL,NULL,'1',NULL,'pre',". "'$ruleset','$max' ,NULL)"); } } @@ -153,7 +153,7 @@ else $max = DB_get_max_session(); $max++; - DB_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1',NULL,'pre', ". + DB_query("INSERT INTO Game VALUES (CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, '$randomNRstring', 'normal', NULL,NULL,'1',NULL,'pre', ". "'$ruleset','$max' ,NULL)"); } $gameid = DB_insert_id(); -- cgit v1.2.3-18-g5258