Mercurial > hg > fapweb
diff usrajax.php @ 762:539bfbdd43ec
Add timestamps to votes, bump database version.
author | Matti Hamalainen <ccr@tnsp.org> |
---|---|
date | Thu, 20 Nov 2014 11:43:34 +0200 |
parents | 17820305bc77 |
children | 62a98cb255f7 |
line wrap: on
line diff
--- a/usrajax.php Thu Nov 20 11:42:29 2014 +0200 +++ b/usrajax.php Thu Nov 20 11:43:34 2014 +0200 @@ -22,15 +22,15 @@ { // Didn't exist, insert it $sql = stPrepareSQL( - "INSERT INTO votes (key_id,entry_id,value) VALUES (%d,%d,%d)", - $key_id, $entry_id, $vote); + "INSERT INTO votes (key_id,entry_id,value,utime) VALUES (%d,%d,%d,%d)", + $key_id, $entry_id, $vote, time()); } else { // Existed, thusly update - $sql = stPrepareSQL( - "UPDATE votes SET value=%d WHERE key_id=%d AND entry_id=%d", - $vote, $key_id, $entry_id); + $sql = stPrepareSQLUpdate( + "UPDATE votes SET value=%d,utime=%d WHERE key_id=%d AND entry_id=%d", + $vote, time(), $key_id, $entry_id); } return stExecSQL($sql);