Mercurial > hg > egg-tcls

changeset 44:f0694e61ae45

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Change one local variable name.
author Matti Hamalainen <ccr@tnsp.org>
date Wed, 07 Sep 2011 14:07:07 +0300
parents 965b728c2a9d
children 18eb2f6d6c3e
files quotedb.tcl
diffstat 1 files changed, 3 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- 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