From 597e3723132f93e345a83c4596459f24bb9f7b0e Mon Sep 17 00:00:00 2001
From: timriker <timriker@c11ca15a-4712-0410-83d8-924469b57eb5>
Date: Sat, 7 Dec 2002 06:43:32 +0000
Subject: [PATCH] TODO

git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk/blootbot@743 c11ca15a-4712-0410-83d8-924469b57eb5
---
 src/CommandStubs.pl | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/src/CommandStubs.pl b/src/CommandStubs.pl
index 7e5ccb6..d2e8691 100644
--- a/src/CommandStubs.pl
+++ b/src/CommandStubs.pl
@@ -340,6 +340,7 @@ sub Modules {
 	    if (!defined $arg or $arg =~ /^\s*$/) {
 		# this is way fucking ugly.
 
+		# TODO convert $where to hash
 		my %hash = &sqlSelectColHash("stats", "nick,counter",
 			{ },
 			$where." ORDER BY counter DESC LIMIT 3", 1
@@ -368,6 +369,7 @@ sub Modules {
 		    &pSReply("zero counter for \037$type\037.");
 		}
 	    } else {
+		# TODO convert $where to hash and use a sqlSelect
 		my $x = (&sqlRawReturn("SELECT SUM(counter) FROM stats".
 			" WHERE $where AND nick=".&sqlQuote($arg) ))[0];
 
@@ -377,6 +379,7 @@ sub Modules {
 		}
 
 		# defined.
+		# TODO convert $where to hash
 		my @array = &sqlSelect("stats", "nick", undef,
 			$where." ORDER BY counter", 1
 		);
@@ -961,6 +964,7 @@ sub textstats_main {
 	    &pSReply("zero counter for \037$type\037.");
 	}
     } else {
+	# TODO add nick to where_href
 	my %hash = &sqlSelectColHash("stats", "type,counter",
 		$where_href, " AND nick=".&sqlQuote($arg)
 	);
@@ -973,6 +977,7 @@ sub textstats_main {
 	foreach (keys %hash) {
 	    &DEBUG("_stats: hash{$_} => $hash{$_}");
 	    # ranking.
+	    # TODO convert $where to hash
 	    my @array = &sqlSelect("stats", "nick", undef,
 		$where." ORDER BY counter", 1);
 	    $good = 0;
-- 
2.39.2