/[irc-logger]/trunk/bin/irc-logger.pl
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/bin/irc-logger.pl

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 56 by dpavlin, Sun Mar 18 17:14:52 2007 UTC revision 57 by dpavlin, Sat Apr 7 17:03:57 2007 UTC
# Line 602  POE::Session->create( inline_states => Line 602  POE::Session->create( inline_states =>
602    
603                          my $sth = $dbh->prepare(qq{                          my $sth = $dbh->prepare(qq{
604                                  select                                  select
605                                          nick,                                          trim(both '_' from nick) as nick,
606                                          count(*) as count,                                          count(*) as count,
607                                          sum(length(message)) as len                                          sum(length(message)) as len
608                                  from log                                  from log
609                                  group by nick                                  group by trim(both '_' from nick)
610                                  order by len desc,count desc                                  order by len desc,count desc
611                                  limit $nr                                  limit $nr
612                          });                          });

Legend:
Removed from v.56  
changed lines
  Added in v.57

  ViewVC Help
Powered by ViewVC 1.1.26