# HG changeset patch
# User Matti Hamalainen <ccr@tnsp.org>
# Date 1416476614 -7200
# Node ID 539bfbdd43ec5bf808346300af40cda23a1c62f8
# Parent  1be30385e9d4e6efb8c0fbdc9f72c1c76cc764ae
Add timestamps to votes, bump database version.

diff -r 1be30385e9d4 -r 539bfbdd43ec dbdefs.inc.php
--- a/dbdefs.inc.php	Thu Nov 20 11:42:29 2014 +0200
+++ b/dbdefs.inc.php	Thu Nov 20 11:43:34 2014 +0200
@@ -1,6 +1,6 @@
 <?
 
-$dbVersion = 21;
+$dbVersion = 22;
 
 //
 // Site settings and defaults we put in
@@ -297,6 +297,7 @@
     array("entry_id"     , "INT", "DEFAULT NULL"),
     array("key_id"       , "INT", "DEFAULT 0"),
     array("value"        , "INT", "DEFAULT 0"),
+    array("utime"        , "INT", "DEFAULT 0"),
   ),
 
 
diff -r 1be30385e9d4 -r 539bfbdd43ec usrajax.php
--- 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);