From f44e8a9bba8f51381eed83f1dcd2925cfa9d8370 Mon Sep 17 00:00:00 2001
From: timriker <timriker@c11ca15a-4712-0410-83d8-924469b57eb5>
Date: Fri, 22 Aug 2003 00:42:11 +0000
Subject: [PATCH] use count(*) for unrequested

git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk/blootbot@809 c11ca15a-4712-0410-83d8-924469b57eb5
---
 src/Modules/Factoids.pl | 11 +++--------
 1 file changed, 3 insertions(+), 8 deletions(-)

diff --git a/src/Modules/Factoids.pl b/src/Modules/Factoids.pl
index da553b3..c163edb 100644
--- a/src/Modules/Factoids.pl
+++ b/src/Modules/Factoids.pl
@@ -669,7 +669,7 @@ sub CmdFactStats {
 	for (@list) {
 	    my $factoid = $_;
 	    my $val = &getFactInfo($factoid, "factoid_value");
-	
+
 	    next unless ($val =~ /^see( also)? (.*?)\.?$/i);
 
 	    my $redirf	= lc $2;
@@ -728,14 +728,9 @@ sub CmdFactStats {
 
     } elsif ($type =~ /^unrequest(ed)?$/i) {
 	# todo: use sqlSelect()
-	my @list = &sqlRawReturn("SELECT factoid_key FROM factoids WHERE requested_count IS NULL");
-
-	for (@list) {
-	    s/([\,\;]+)/\037$1\037/g;
-	}
+	my $count = &sqlRawReturn("SELECT COUNT(*) FROM factoids WHERE requested_count = '0'");
 
-	my $prefix = "Unrequested factoids ";
-	return &formListReply(0, $prefix, @list);
+	return "Unrequested factoids: $count";
     }
 
     return "error: invalid type => '$type'.";
-- 
2.39.2