&ircCheck();
next;
}
- push(@array, "$_ (".scalar(keys %{ $channels{$_}{''} }).")");
+ next if (/^_default$/);
+
+ my $str = sprintf("%s (%d)", $_, scalar(keys %{ $channels{$_}{''} }));
+ push(@array, $str);
}
- &pSReply($reply.": ".join(' ', @array));
+ &pSReply($reply.": ".join(', ', @array));
### total user count.
foreach $chan (keys %channels) {
push(@nicks, $_);
}
}
- &DEBUG("nicks => '".scalar(@nicks)."'...");
+
if (scalar @nicks != $uucount) {
&DEBUG("nicks != uucount...");
}
sub karma {
my $target = lc( shift || $who );
- my $karma = &dbGet("stats", "counter", "nick=".
- &dbQuote($target)." AND type='karma'") || 0;
+ my $karma = &sqlSelect("stats", "counter",
+ { nick => $target, type => "karma" }) || 0;
if ($karma != 0) {
&pSReply("$target has karma of $karma");
"Since $startString, there have been".
" \002$count{'Update'}\002 ".
&fixPlural("modification", $count{'Update'}).
- " and \002$count{'Question'}\002 ".
+ ", \002$count{'Question'}\002 ".
&fixPlural("question",$count{'Question'}).
- " and \002$count{'Dunno'}\002 ".
+ ", \002$count{'Dunno'}\002 ".
&fixPlural("dunno",$count{'Dunno'}).
- " and \002$count{'Moron'}\002 ".
+ ", \002$count{'Moron'}\002 ".
&fixPlural("moron",$count{'Moron'}).
" and \002$count{'Commands'}\002 ".
&fixPlural("command",$count{'Commands'}).
"kB of memory."
);
- # todo: use dbGetColNiceHash().
- my %hash = &dbGetCol("stats", "nick,counter", "type='cmdstats'".
-# " ORDER BY counter DESC LIMIT 3", 1);
- " ORDER BY counter DESC", 1);
+ return;
+
+ my %hash = &sqlSelectColHash("stats", "nick,counter",
+ { type => "cmdstats" }, 1);
+# ORDER won't be retained in a hash
+# " ORDER BY counter DESC", 1);
if (0) {
foreach (keys %hash) {