diff options
| author | Arun Persaud <arun@nubati.net> | 2013-02-25 22:04:21 -0800 |
|---|---|---|
| committer | Arun Persaud <arun@nubati.net> | 2013-02-25 22:04:21 -0800 |
| commit | 5116d22ed84db0f15a7f583bcbe243ee2cd606e1 (patch) | |
| tree | f0606717f34a65c874116e435638b19209e325fb /include/cancelgame.php | |
| parent | 94bbb934cb0bc65c72e2ab724f4bf99b3c7207be (diff) | |
| download | e-DoKo-5116d22ed84db0f15a7f583bcbe243ee2cd606e1.tar.gz e-DoKo-5116d22ed84db0f15a7f583bcbe243ee2cd606e1.tar.bz2 e-DoKo-5116d22ed84db0f15a7f583bcbe243ee2cd606e1.zip | |
mysql optimization: don't quote integers as strings in WHERE
Diffstat (limited to 'include/cancelgame.php')
| -rw-r--r-- | include/cancelgame.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/include/cancelgame.php b/include/cancelgame.php index d9b69b3..02b5a06 100644 --- a/include/cancelgame.php +++ b/include/cancelgame.php @@ -49,7 +49,7 @@ $gameid = DB_get_gameid_by_hash($me); $myname = DB_get_name('hash',$me); /* check if game really is old enough to be canceled */ -$r = DB_query_array("SELECT mod_date from Game WHERE id='$gameid' " ); +$r = DB_query_array("SELECT mod_date from Game WHERE id=".DB_quote_smart($gameid) ); if(time()-strtotime($r[0]) > 60*60*24*30) /* = 1 month */ { /* email to all players */ |