# HG changeset patch
# User Matti Hamalainen <ccr@tnsp.org>
# Date 1315393627 -10800
# Node ID f0694e61ae45c407f6c0b8a047697eb9df4563d7
# Parent  965b728c2a9dbc1d06e713676c00af61532fb6f3
Change one local variable name.

diff -r 965b728c2a9d -r f0694e61ae45 quotedb.tcl
--- a/quotedb.tcl	Wed Sep 07 14:06:01 2011 +0300
+++ b/quotedb.tcl	Wed Sep 07 14:07:07 2011 +0300
@@ -209,10 +209,11 @@
   }
 
   set uresults 0
-  set usql "SELECT total(${utable}_votes.vote) AS uvalue, ${utable}.id AS quoteID, ${utable}.utext AS utext, ${utable}.utime AS utime,${utable}.user AS uuser, ${utable}.id AS uid FROM ${utable}_votes INNER JOIN $utable ON ${utable}_votes.urlid = ${utable}.id ORDER BY uvalue,utime DESC LIMIT $unum"
+  set usql "SELECT total(${utable}_votes.vote) AS rating, ${utable}.id AS quoteID, ${utable}.utext AS utext, ${utable}.utime AS utime,${utable}.user AS uuser, ${utable}.id AS uid FROM ${utable}_votes INNER JOIN $utable ON ${utable}_votes.urlid = ${utable}.id GROUP BY ${utable}.id ORDER BY rating DESC LIMIT $unum"
+#  putlog "s=$usql"
   quotedb eval $usql {
     incr uresults
-    qdb_msg $upublic $unick $uchan "${uresults}. #${quoteID}: $utext ($uuser, $uvalue)"
+    qdb_msg $upublic $unick $uchan "${uresults}. #${quoteID}: $utext ($uuser, $rating)"
   }
 
   return 0