2 # User Command Extension Stubs
3 # WARN: this file does not reload on HUP.
8 $babel_lang_regex = "fr|sp|es|po|pt|it|ge|de|gr|en|zh|ja|jp|ko|kr|ru";
10 ### COMMAND HOOK IMPLEMENTATION.
11 # addCmdHook("SECTION", 'TEXT_HOOK',
14 # CheckModule => 1, # ???
15 # Module => 'blah.pl' # preload module.
16 # Identifier => 'config_label', # change to Config?
17 # Help => 'help_label',
18 # Cmdstats => 'text_label',)
23 my ($hashname, $ident, %hash) = @_;
25 if (exists ${"hooks_$hashname"}{$ident}) {
26 ### &WARN("aCH: cmd hooks \%$hashname{$ident} already exists.");
30 &VERB("aCH: added $ident",2); # use $hash{'Identifier'}?
31 ### hrm... prevent warnings?
32 ${"hooks_$hashname"}{$ident} = \%hash;
37 my ($hashname, $line) = @_;
38 $line =~ /^(\S+)( (.*))?$/;
39 my $cmd = $1; # command name is whitespaceless.
41 my @args = split(/\s+/, $flatarg || '');
46 if (!defined %{"hooks_$hashname"}) {
47 &WARN("cmd hooks \%$hashname does not exist.");
52 &WARN("cstubs: cmd == NULL.");
56 foreach (keys %{"hooks_$hashname"}) {
57 # rename to something else! like $id or $label?
60 next unless ($cmd =~ /^$ident$/i);
63 &WARN("pCH: Multiple hook match: $ident");
67 &status("hooks($hashname): $cmd matched '$ident'");
68 my %hash = %{ ${"hooks_$hashname"}{$ident} };
70 if (!scalar keys %hash) {
71 &WARN("CmdHook: hash is NULL?");
75 if ($hash{NoArgs} and $flatarg) {
76 &DEBUG("cmd $ident does not take args ('$flatarg'); skipping.");
80 if (!exists $hash{CODEREF}) {
81 &ERROR("CODEREF undefined for $cmd or $ident.");
86 foreach (keys %hash) {
87 &VERB(" $cmd->$_ => '$hash{$_}'.",2);
91 if (exists $hash{'Help'} and !scalar(@args)) {
92 &help( $hash{'Help'} );
97 if (exists $hash{'Identifier'}) {
98 return 1 unless (&hasParam($hash{'Identifier'}));
102 if (exists $hash{'UserFlag'}) {
103 return 1 unless (&hasFlag($hash{'UserFlag'}));
106 ### FORKER,IDENTIFIER,CODEREF.
107 if (exists $hash{'Forker'}) {
108 $hash{'Identifier'} .= "-" if ($hash{'Forker'} eq "NULL");
110 if (exists $hash{'ArrayArgs'}) {
111 &Forker($hash{'Identifier'}, sub { \&{ $hash{'CODEREF'} }(@args) } );
113 &Forker($hash{'Identifier'}, sub { \&{ $hash{'CODEREF'} }($flatarg) } );
117 if (exists $hash{'Module'}) {
118 &loadMyModule($myModules{ $hash{'Module'} });
121 # check if CODEREF exists.
122 if (!defined &{ $hash{'CODEREF'} }) {
123 &WARN("coderef $hash{'CODEREF'} don't exist.");
125 &msg($who, "coderef does not exist for $ident.");
131 if (exists $hash{'ArrayArgs'}) {
132 &{ $hash{'CODEREF'} }(@args);
134 &{ $hash{'CODEREF'} }($flatarg);
139 if (exists $hash{'Cmdstats'}) {
140 $cmdstats{ $hash{'Cmdstats'} }++;
143 &VERB("hooks: End of command.",2);
153 ### START ADDING HOOKS.
155 &addCmdHook("extra", 'd?bugs', ('CODEREF' => 'DBugs::Parse',
156 'Forker' => 1, 'Identifier' => 'debianExtra',
157 'Cmdstats' => 'Debian Bugs') );
158 &addCmdHook("extra", 'dauthor', ('CODEREF' => 'Debian::searchAuthor',
159 'Forker' => 1, 'Identifier' => 'debian',
160 'Cmdstats' => 'Debian Author Search', 'Help' => "dauthor" ) );
161 &addCmdHook("extra", '(d|search)desc', ('CODEREF' => 'Debian::searchDescFE',
162 'Forker' => 1, 'Identifier' => 'debian',
163 'Cmdstats' => 'Debian Desc Search', 'Help' => "ddesc" ) );
164 &addCmdHook("extra", 'dnew', ('CODEREF' => 'DebianNew',
165 'Identifier' => 'debian' ) );
166 &addCmdHook("extra", 'dincoming', ('CODEREF' => 'Debian::generateIncoming',
167 'Forker' => 1, 'Identifier' => 'debian' ) );
168 &addCmdHook("extra", 'dstats', ('CODEREF' => 'Debian::infoStats',
169 'Forker' => 1, 'Identifier' => 'debian',
170 'Cmdstats' => 'Debian Statistics' ) );
171 &addCmdHook("extra", 'd?contents', ('CODEREF' => 'Debian::searchContents',
172 'Forker' => 1, 'Identifier' => 'debian',
173 'Cmdstats' => 'Debian Contents Search', 'Help' => "contents" ) );
174 &addCmdHook("extra", 'd?find', ('CODEREF' => 'Debian::DebianFind',
175 'Forker' => 1, 'Identifier' => 'debian',
176 'Cmdstats' => 'Debian Search', 'Help' => "find" ) );
177 &addCmdHook("extra", 'insult', ('CODEREF' => 'Insult::Insult',
178 'Forker' => 1, 'Identifier' => 'insult', 'Help' => "insult" ) );
179 &addCmdHook("extra", 'kernel', ('CODEREF' => 'Kernel::Kernel',
180 'Forker' => 1, 'Identifier' => 'kernel',
181 'Cmdstats' => 'Kernel', 'NoArgs' => 1) );
182 &addCmdHook("extra", 'listauth', ('CODEREF' => 'CmdListAuth',
183 'Identifier' => 'search', Module => 'factoids',
184 'Help' => 'listauth') );
185 &addCmdHook("extra", 'quote', ('CODEREF' => 'Quote::Quote',
186 'Forker' => 1, 'Identifier' => 'quote',
187 'Help' => 'quote', 'Cmdstats' => 'Quote') );
188 &addCmdHook("extra", 'countdown', ('CODEREF' => 'Countdown',
189 'Module' => 'countdown', 'Identifier' => 'countdown',
190 'Cmdstats' => 'Countdown') );
191 &addCmdHook("extra", 'lart', ('CODEREF' => 'lart',
192 'Identifier' => 'lart', 'Help' => 'lart') );
193 &addCmdHook("extra", 'convert', ('CODEREF' => 'convert',
194 'Forker' => 1, 'Identifier' => 'units',
195 'Help' => 'convert') );
196 &addCmdHook("extra", '(cookie|random)', ('CODEREF' => 'cookie',
197 'Forker' => 1, 'Identifier' => 'factoids') );
198 &addCmdHook("extra", 'u(ser)?info', ('CODEREF' => 'userinfo',
199 'Identifier' => 'userinfo', 'Help' => 'userinfo',
200 'Module' => 'userinfo') );
201 &addCmdHook("extra", 'rootWarn', ('CODEREF' => 'CmdrootWarn',
202 'Identifier' => 'rootWarn', 'Module' => 'rootwarn') );
203 &addCmdHook("extra", 'seen', ('CODEREF' => 'seen', 'Identifier' =>
205 &addCmdHook("extra", 'dict', ('CODEREF' => 'Dict::Dict',
206 'Identifier' => 'dict', 'Help' => 'dict',
207 'Forker' => 1, 'Cmdstats' => 'Dict') );
208 &addCmdHook("extra", 'slashdot', ('CODEREF' => 'Slashdot::Slashdot',
209 'Identifier' => 'slashdot', 'Forker' => 1,
210 'Cmdstats' => 'Slashdot') );
211 &addCmdHook("extra", 'uptime', ('CODEREF' => 'uptime', 'Identifier' => 'uptime',
212 'Cmdstats' => 'Uptime') );
213 &addCmdHook("extra", 'nullski', ('CODEREF' => 'nullski', ) );
214 &addCmdHook("extra", '(fm|freshmeat)', ('CODEREF' => 'Freshmeat::Freshmeat',
215 'Identifier' => 'freshmeat', 'Cmdstats' => 'Freshmeat',
216 'Forker' => 1, 'Help' => 'freshmeat') );
217 &addCmdHook("extra", 'verstats', ('CODEREF' => 'do_verstats' ) );
218 &addCmdHook("extra", 'weather', ('CODEREF' => 'Weather::Weather',
219 'Identifier' => 'weather', 'Help' => 'weather',
220 'Cmdstats' => 'Weather') );
221 &addCmdHook("extra", 'bzflist', ('CODEREF' => 'BZFlag::list',
222 'Identifier' => 'bzflag', 'Cmdstats' => 'BZFlag',
224 &addCmdHook("extra", 'bzfquery', ('CODEREF' => 'BZFlag::query',
225 'Identifier' => 'bzflag', 'Cmdstats' => 'BZFlag',
226 'Forker' => 1, 'Help' => 'bzflag') );
229 ### END OF ADDING HOOKS.
231 &status("CMD: loaded ".scalar(keys %hooks_extra)." EXTRA command hooks.");
234 if (!defined $message) {
235 &WARN("Modules: message is undefined. should never happen.");
239 # babel bot: Jonathan Feinberg++
242 (?:babel(?:fish)?|x|xlate|translate)
244 ($babel_lang_regex)\w* # from language?
246 ($babel_lang_regex)\w* # to language?
248 (.+) # The phrase to be translated
250 return unless (&hasParam("babelfish"));
252 &Forker("babelfish", sub { &babel::babelfish(lc $1, lc $2, $3); } );
254 $cmdstats{'BabelFish'}++;
258 my $debiancmd = 'conflicts?|depends?|desc|file|info|provides?';
259 $debiancmd .= '|recommends?|suggests?|maint|maintainer';
261 if ($message =~ /^($debiancmd)(\s+(.*))?$/i) {
262 return unless (&hasParam("debian"));
265 if (defined $package) {
266 &Forker("debian", sub { &Debian::infoPackages($1, $package); } );
274 # google searching. Simon++
275 if ($message =~ /^(?:search\s+)?(\S+)\s+for\s+['"]?(.*?)["']?\s*\?*$/i) {
276 return unless (&hasParam("wwwsearch"));
278 &Forker("wwwsearch", sub { &W3Search::W3Search($1,$2); } );
280 $cmdstats{'WWWSearch'}++;
284 # text counters. (eg: hehstats)
286 $itc = &getChanConf("ircTextCounters");
287 $itc = &findChanConf("ircTextCounters") unless ($itc);
289 $itc =~ s/([^\w\s])/\\$1/g;
290 my $z = join '|', split ' ', $itc;
292 if ($msgType eq "privmsg" and $message =~ / ($mask{chan})$/) {
293 &DEBUG("ircTC: privmsg detected; chan = $1");
297 if ($message =~ /^_stats(\s+(\S+))$/i) {
302 if ($message =~ /^($z)stats(\s+(\S+))?$/i) {
306 # even more uglier with channel/time arguments.
308 # my $c = $chan || "PRIVATE";
309 my $where = "type=".&dbQuote($type);
310 $where .= " AND channel=".&dbQuote($c) if (defined $c);
311 &DEBUG("not using chan arg") if (!defined $c);
312 my $sum = (&dbRawReturn("SELECT SUM(counter) FROM stats"
313 ." WHERE ".$where ))[0];
315 if (!defined $arg or $arg =~ /^\s*$/) {
316 # this is way fucking ugly.
318 my %hash = &dbGetCol("stats", "nick,counter",
319 $where." ORDER BY counter DESC LIMIT 3", 1);
323 # unfortunately we have to sort it again!
324 # todo: make dbGetCol return hash and array? too much effort.
326 foreach $i (sort { $b <=> $a } keys %hash) {
327 foreach (keys %{ $hash{$i} }) {
328 my $p = sprintf("%.01f", 100*$i/$sum);
330 push(@top, "\002$_\002 -- $i ($p%)");
334 &DEBUG("*stats: tp => $tp");
336 $topstr = ". Top ".scalar(@top).": ".join(', ', @top);
340 &pSReply("total count of \037$type\037 on \002$c\002: $sum$topstr");
342 &pSReply("zero counter for \037$type\037.");
345 my $x = (&dbRawReturn("SELECT SUM(counter) FROM stats".
346 " WHERE $where AND nick=".&dbQuote($arg) ))[0];
348 if (!defined $x) { # !defined.
349 &pSReply("$arg has not said $type yet.");
354 my @array = &dbGet("stats", "nick",
355 $where." ORDER BY counter", 1);
358 for($i=0; $i<scalar @array; $i++) {
359 next unless ($array[0] =~ /^\Q$who\E$/);
365 my $total = scalar(@array);
367 if ($total and $good) {
368 my $pct = sprintf("%.01f", 100*(1+$total-$i)/$total);
369 $xtra = ", ranked $i\002/\002$total (percentile: \002$pct\002 %)";
372 my $pct1 = sprintf("%.01f", 100*$x/$sum);
373 &pSReply("\002$arg\002 has said \037$type\037 \002$x\002 times (\002$pct1\002 %)$xtra");
380 &DEBUG("regex failed: $@");
385 # list{keys|values}. xk++. Idea taken from #linuxwarez@EFNET
386 if ($message =~ /^list(\S+)(\s+(.*))?$/i) {
387 return unless (&hasParam("search"));
392 $thiscmd =~ s/^vals$/values/;
393 # $args =~ s/\s+$//g;
394 return if ($thiscmd ne "keys" && $thiscmd ne "values");
397 if (!defined $args or $args =~ /^\s*$/) {
398 &help("list". $thiscmd);
402 # suggested by asuffield and \broken.
403 if ($args =~ /^["']/ and $args =~ /["']$/) {
404 &DEBUG("list*: removed quotes.");
405 $args =~ s/^["']|["']$//g;
408 if (length $args == 1) {
409 &msg($who,"search string is too short.");
413 &Forker("search", sub { &Search::Search($thiscmd, $args); } );
415 $cmdstats{'Factoid Search'}++;
419 # Nickometer. Adam Spiers++
420 if ($message =~ /^(?:lame|nick)ometer(?: for)? (\S+)/i) {
421 return unless (&hasParam("nickometer"));
423 my $term = (lc $1 eq 'me') ? $who : $1;
425 &loadMyModule($myModules{'nickometer'});
427 if ($term =~ /^$mask{chan}$/) {
428 &status("Doing nickometer for chan $term.");
430 if (!&validChan($term)) {
431 &msg($who, "error: channel is invalid.");
437 foreach (keys %{ $channels{lc $term}{''} }) {
440 &WARN("nickometer: nick in chan $term undefined?");
444 my $value = &nickometer($str);
445 $nickometer{$value}{$str} = 1;
449 ### TODO: compact with map?
451 foreach (sort {$b <=> $a} keys %nickometer) {
452 my $str = join(", ", sort keys %{ $nickometer{$_} });
453 push(@list, "$str ($_%)");
456 &pSReply( &formListReply(0, "Nickometer list for $term ", @list) );
462 my $percentage = &nickometer($term);
464 if ($percentage =~ /NaN/) {
465 $percentage = "off the scale";
467 $percentage = sprintf("%0.4f", $percentage);
468 $percentage =~ s/\.?0+$//;
472 if ($msgType eq 'public') {
473 &say("'$term' is $percentage lame, $who");
475 &msg($who, "the 'lame nick-o-meter' reading for $term is $percentage, $who");
481 # Topic management. xk++
482 # may want to add a userflags for topic. -xk
483 if ($message =~ /^topic(\s+(.*))?$/i) {
484 return unless (&hasParam("topic"));
486 my $chan = $talkchannel;
487 my @args = split / /, $2 || "";
490 &msg($who,"Try 'help topic'");
494 $chan = lc(shift @args) if ($msgType eq 'private');
495 my $thiscmd = shift @args;
498 if ($msgType eq 'public' && $thiscmd =~ /^#/) {
499 &msg($who, "error: channel argument is not required.");
500 &msg($who, "\002Usage\002: topic <CMD>");
504 # topic over private:
505 if ($msgType eq 'private' && $chan !~ /^#/) {
506 &msg($who, "error: channel argument is required.");
507 &msg($who, "\002Usage\002: topic #channel <CMD>");
511 if (&validChan($chan) == 0) {
512 &msg($who,"error: invalid channel \002$chan\002");
516 # for semi-outsiders.
517 if (!&IsNickInChan($who,$chan)) {
518 &msg($who, "Failed. You ($who) are not in $chan, hey?");
523 &loadMyModule($myModules{'topic'});
524 &Topic($chan, $thiscmd, join(' ', @args));
525 $cmdstats{'Topic'}++;
530 if ($message =~ /^wingate$/i) {
531 return unless (&hasParam("wingate"));
533 my $reply = "Wingate statistics: scanned \002"
534 .scalar(keys %wingate)."\002 hosts";
535 my $queue = scalar(keys %wingateToDo);
537 $reply .= ". I have \002$queue\002 hosts in the queue";
538 $reply .= ". Started the scan ".&Time2String(time() - $wingaterun)." ago";
546 # do nothing and let the other routines have a go
554 if (!defined $query) {
556 &msg($who, "I have \002".&countKeys("freshmeat")."\002 entries.");
560 &Freshmeat::Freshmeat($query);
566 &msg($who, "- Uptime for $ident -");
567 &msg($who, "Now: ". &Time2String(&uptimeNow()) ." running $bot_version");
569 foreach (&uptimeGetInfo()) {
571 my $time = &Time2String($1);
574 &msg($who, "$count: $time $2");
581 my($person) = lc shift;
584 if (&whatInterface() !~ /IRC/) {
585 &status("seen disabled in CLI.");
589 if (!defined $person or $person =~ /^$/) {
592 my $i = &countKeys("seen");
593 &msg($who,"there ". &fixPlural("is",$i) ." \002$i\002 ".
594 "seen ". &fixPlural("entry",$i) ." that I know of.");
601 &seenFlush(); # very evil hack. oh well, better safe than sorry.
603 ### TODO: Support &dbGetColInfo(); like in &FactInfo();
604 my $select = "nick,time,channel,host,message";
605 if ($person eq "random") {
606 @seen = &randKey("seen", $select);
608 @seen = &dbGet("seen", $select, "nick=".&dbQuote($person) );
611 if (scalar @seen < 2) {
613 &DEBUG("seen: _ => '$_'.");
615 &performReply("i haven't seen '$person'");
621 ### TODO: multi channel support. may require &IsNick() to return
622 ### all channels or something.
623 my @chans = &getNickInChans($seen[0]);
625 $reply = "$seen[0] is currently on";
629 next unless (exists $userstats{lc $seen[0]}{'Join'});
630 $reply .= " (".&Time2String(time() - $userstats{lc $seen[0]}{'Join'}).")";
633 if (&IsParam("seenStats")) {
635 $i = $userstats{lc $seen[0]}{'Count'};
636 $reply .= ". Has said a total of \002$i\002 messages" if (defined $i);
637 $i = $userstats{lc $seen[0]}{'Time'};
638 $reply .= ". Is idling for ".&Time2String(time() - $i) if (defined $i);
641 my $howlong = &Time2String(time() - $seen[1]);
642 $reply = "$seen[0] <$seen[3]> was last seen on IRC ".
643 "in channel $seen[2], $howlong ago, ".
644 "saying\002:\002 '$seen[4]'.";
651 # User Information Services. requested by Flugh.
653 my ($arg) = join(' ',@_);
655 if ($arg =~ /^set(\s+(.*))?$/i) {
658 &help("userinfo set");
662 &UserInfoSet(split /\s+/, $arg, 2);
663 } elsif ($arg =~ /^unset(\s+(.*))?$/i) {
666 &help("userinfo unset");
670 &UserInfoSet($arg, "");
676 # cookie (random). xk++
680 # lets find that secret cookie.
681 my $target = ($msgType ne 'public') ? $who : $talkchannel;
682 my $cookiemsg = &getRandom(keys %{ $lang{'cookie'} });
685 ### WILL CHEW TONS OF MEM.
686 ### TODO: convert this to a Forker function!
688 my @list = &searchTable("factoids", "factoid_key", "factoid_value", $arg);
689 $key = &getRandom(@list);
690 $val = &getFactInfo("factoids", $key, "factoid_value");
692 ($key,$value) = &randKey("factoids","factoid_key,factoid_value");
696 s/##KEY/\002$key\002/;
699 s/\$who/$who/; # cheap fix.
700 s/(\S+)?\s*<\S+>/$1 /;
704 if ($cookiemsg =~ s/^ACTION //i) {
705 &action($target, $cookiemsg);
707 &msg($target, $cookiemsg);
712 my $arg = join(' ',@_);
713 my ($from,$to) = ('','');
715 ($from,$to) = ($1,$2) if ($arg =~ /^(.*?) to (.*)$/i);
716 ($from,$to) = ($2,$1) if ($arg =~ /^(.*?) from (.*)$/i);
718 if (!$to or !$from) {
719 &msg($who, "Invalid format!");
724 &Units::convertUnits($from, $to);
730 my ($target) = &fixString($_[0]);
732 my $chan = $talkchannel;
734 if ($msgType eq 'private') {
735 if ($target =~ /^($mask{chan})\s+(.*)$/) {
740 &msg($who, "error: invalid format or missing arguments.");
746 my $line = &getRandomLineFromFile($bot_data_dir. "/blootbot.lart");
748 if ($target =~ /^(me|you|itself|\Q$ident\E)$/i) {
749 $line =~ s/WHO/$who/g;
751 $line =~ s/WHO/$target/g;
753 $line .= ", courtesy of $who" if ($extra);
755 &action($chan, $line);
757 &status("lart: error reading file?");
762 my $idx = "debian/Packages-sid.idx";
767 $error++ unless ( -e $idx);
768 $error++ unless ( -e "$idx-old");
771 $error = "no sid/sid-old index file found.";
772 &ERROR("Debian: $error");
778 open(IDX2, "$idx-old");
792 next if (exists $pkg{$_});
798 &::pSReply( &::formListReply(0, "New debian packages:", @new) );
804 if (!defined $chan) {
809 if (!&validChan($chan)) {
810 &msg($who, "chan $chan is invalid.");
814 if (scalar @vernick > scalar(keys %{ $channels{lc $chan}{''} })/4) {
815 &msg($who, "verstats already in progress for someone else.");
819 &msg($who, "Sending CTCP VERSION to #$chan...");
820 $conn->ctcp("VERSION", $chan);
821 $cache{verstats}{chan} = $chan;
822 $cache{verstats}{who} = $who;
823 $cache{verstats}{msgType} = $msgType;
825 $conn->schedule(30, sub {
826 my $c = lc $cache{verstats}{chan};
829 foreach (keys %{ $channels{$c}{''} } ) {
830 next if (grep /^\Q$_\E$/i, @vernick);
831 push(@vernicktodo, $_);
837 $conn->schedule(60, sub {
839 my $c = lc $cache{verstats}{chan};
840 my $total = keys %{ $channels{$c}{''} };
842 $who = $cache{verstats}{who};
843 $msgType = $cache{verstats}{msgType};
844 delete $cache{verstats}; # sufficient?
846 foreach (keys %ver) {
847 $vtotal += scalar keys %{ $ver{$_} };
851 my $unknown = $total - $vtotal;
852 my $perc = sprintf("%.1f", $unknown * 100 / $total);
854 $sorted{$perc}{"unknown/cloak"} = "$unknown ($perc%)" if ($unknown);
856 foreach (keys %ver) {
857 my $count = scalar keys %{ $ver{$_} };
858 $perc = sprintf("%.01f", $count * 100 / $total);
859 $perc =~ s/.0$//; # lame compression.
861 $sorted{$perc}{$_} = "$count ($perc%)";
864 ### can be compressed to a map?
866 foreach ( sort { $b <=> $a } keys %sorted ) {
868 foreach (sort keys %{ $sorted{$perc} }) {
869 push(@list, "$_ - $sorted{$perc}{$_}");
873 &pSReply( &formListReply(0, "IRC Client versions for $c ", @list) );
875 # clean up not-needed data structures.
885 last unless (scalar @vernicktodo);
887 my $n = shift(@vernicktodo);
888 $conn->ctcp("VERSION", $n);
891 return unless (scalar @vernicktodo);
893 $conn->schedule(3, \&verstats_flush() );
899 # even more uglier with channel/time arguments.
901 # my $c = $chan || "PRIVATE";
902 my $where = "channel=".&dbQuote($c) if (defined $c);
903 &DEBUG("not using chan arg") if (!defined $c);
904 my $sum = (&dbRawReturn("SELECT SUM(counter) FROM stats"
905 ." WHERE ".$where ))[0];
907 if (!defined $arg or $arg =~ /^\s*$/) {
908 # this is way fucking ugly.
909 &DEBUG("_stats: !arg");
911 my %hash = &dbGetCol("stats", "nick,counter",
912 $where." ORDER BY counter DESC LIMIT 3", 1);
916 # unfortunately we have to sort it again!
917 # todo: make dbGetCol return hash and array? too much effort.
919 foreach $i (sort { $b <=> $a } keys %hash) {
920 foreach (keys %{ $hash{$i} }) {
921 my $p = sprintf("%.01f", 100*$i/$sum);
923 push(@top, "\002$_\002 -- $i ($p%)");
928 &DEBUG("*stats: tp => $tp");
930 $topstr = ". Top ".scalar(@top).": ".join(', ', @top);
934 &pSReply("total count of \037$type\037 on \002$c\002: $sum$topstr");
936 &pSReply("zero counter for \037$type\037.");
939 my %hash = &dbGetCol("stats", "type,counter",
940 "$where AND nick=".&dbQuote($arg) );
942 foreach (keys %hash) {
943 &DEBUG("_stats: hash{$_} => $hash{$_}");
945 my @array = &dbGet("stats", "nick",
946 $where." ORDER BY counter", 1);
949 for($i=0; $i<scalar @array; $i++) {
950 next unless ($array[0] =~ /^\Q$who\E$/);
956 my $total = scalar(@array);
957 &DEBUG(" i => $i, good => $good, total => $total");
962 if (!defined $x) { # !defined.
963 &pSReply("$arg has not said $type yet.");
968 if ($total and $good) {
969 my $pct = sprintf("%.01f", 100*(1+$total-$i)/$total);
970 $xtra = ", ranked $i\002/\002$total (percentile: \002$pct\002 %)";
973 my $pct1 = sprintf("%.01f", 100*$x/$sum);
974 &pSReply("\002$arg\002 has said \037$type\037 \002$x\002 times (\002$pct1\002 %)$xtra");
978 sub nullski { my ($arg) = @_; return unless (defined $arg);
979 foreach (`$arg`) { &msg($who,$_); } }