diff options
author | Arun Persaud <arun@nubati.net> | 2015-10-04 17:03:34 -0700 |
---|---|---|
committer | Arun Persaud <arun@nubati.net> | 2015-10-04 17:05:32 -0700 |
commit | 65de9655c6002bbfee76f1c3c45b312615fb375a (patch) | |
tree | cbaf2ae3fd9d5bf7db8425a8c2b6e809c77b56e2 /include/game.php | |
parent | a4cdb155b19c40d9b85a06d8aae0c6b291f439fc (diff) | |
download | e-DoKo-65de9655c6002bbfee76f1c3c45b312615fb375a.tar.gz e-DoKo-65de9655c6002bbfee76f1c3c45b312615fb375a.tar.bz2 e-DoKo-65de9655c6002bbfee76f1c3c45b312615fb375a.zip |
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
Diffstat (limited to 'include/game.php')
-rw-r--r-- | include/game.php | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/include/game.php b/include/game.php index 88158b9..9028364 100644 --- a/include/game.php +++ b/include/game.php @@ -1577,7 +1577,7 @@ switch($mystatus) if($party1 != $party2) DB_query("INSERT INTO Score". - " VALUES( NULL,NULL,$gameid,'$party1',$uid1,$uid2,'fox')"); + " VALUES(NULL,CURRENT_TIMESTAMP,$gameid,'$party1',$uid1,$uid2,'fox')"); } } @@ -1602,7 +1602,7 @@ switch($mystatus) $party1 = DB_get_party_by_gameid_and_userid($gameid,$uid1); DB_query("INSERT INTO Score". - " VALUES( NULL,NULL,$gameid,'$party1',$uid1,NULL,'karlchen')"); + " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'$party1',$uid1,NULL,'karlchen')"); }; }; }; /* end scoring Karlchen */ @@ -1622,7 +1622,7 @@ switch($mystatus) $party1 = DB_get_party_by_gameid_and_userid($gameid,$uid1); DB_query("INSERT INTO Score". - " VALUES( NULL,NULL,$gameid,'$party1',$uid1,NULL,'doko')"); + " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'$party1',$uid1,NULL,'doko')"); } /* @@ -1835,14 +1835,14 @@ switch($mystatus) for( $p=$call_contra;$p<=120; $p+=30 ) { DB_query('INSERT INTO Score'. - " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'against$p')"); + " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'re',NULL,NULL,'against$p')"); } for( $p=$call_contra; $p<120; $p+=30) { if( $re >= $p ) DB_query('INSERT INTO Score'. - " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'made$p')"); + " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'re',NULL,NULL,'made$p')"); } } if($winning_party!='re' and $call_re!= -1) @@ -1850,14 +1850,14 @@ switch($mystatus) for( $p=$call_re;$p<=120; $p+=30 ) { DB_query('INSERT INTO Score'. - " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'against$p')"); + " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'contra',NULL,NULL,'against$p')"); } for( $p=$call_re; $p<120; $p+=30) { if( $contra>=$p ) DB_query('INSERT INTO Score'. - " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'made$p')"); + " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'contra',NULL,NULL,'made$p')"); } } @@ -1865,7 +1865,7 @@ switch($mystatus) if($winning_party=='contra') { DB_query('INSERT INTO Score'. - " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'againstqueens')"); + " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'contra',NULL,NULL,'againstqueens')"); } /* one point each for winning and each 30 points + calls */ @@ -1879,14 +1879,14 @@ switch($mystatus) if($re>$p-$offset) DB_query('INSERT INTO Score'. - " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'".(240-$p)."')"); + " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'re',NULL,NULL,'".(240-$p)."')"); } /* re called something and won */ foreach(array(0,30,60,90,120) as $p) { if($call_re!= -1 && $call_re<$p+1) DB_query('INSERT INTO Score'. - " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'call$p')"); + " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'re',NULL,NULL,'call$p')"); } } else if( $winning_party=='contra') @@ -1899,14 +1899,14 @@ switch($mystatus) if($contra>$p-$offset) DB_query('INSERT INTO Score'. - " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'".(240-$p)."')"); + " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'contra',NULL,NULL,'".(240-$p)."')"); } /* re called something and won */ foreach(array(0,30,60,90,120) as $p) { if($call_contra != -1 && $call_contra<$p+1) DB_query('INSERT INTO Score'. - " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'call$p')"); + " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'contra',NULL,NULL,'call$p')"); } }; |