# HG changeset patch # User Matti Hamalainen # Date 1315509486 -10800 # Node ID dd4a5c0542c4cf66b6c63557176dd555a22ff6a6 # Parent ce327469582c79509f1b12edacf005e9039fa922 quotedb: Remove commented out dead statements. diff -r ce327469582c -r dd4a5c0542c4 quotedb.tcl --- a/quotedb.tcl Thu Sep 08 22:16:54 2011 +0300 +++ b/quotedb.tcl Thu Sep 08 22:18:06 2011 +0300 @@ -275,7 +275,6 @@ set uresults 0 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, $rating)" @@ -346,8 +345,6 @@ global quotedb set usql "SELECT total(${utable}_votes.vote) AS uvote, ${utable}.id AS quoteID, ${utable}.utext AS utext, ${utable}.user AS uuser FROM ${utable} LEFT JOIN ${utable}_votes ON ${utable}_votes.urlid = ${utable}.id" -# set usql "$usql GROUP BY ${utable}.id" -# set usql "SELECT id AS quoteID, utext AS utext, user AS uuser FROM $utable" if {$uindex >= 0} { set usql "$usql WHERE ${utable}.id=$uindex GROUP BY ${utable}.id" qdb_log "$unick searched $utable #$uindex"