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);