/[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 54 by dpavlin, Sun Mar 18 17:14:52 2007 UTC revision 58 by dpavlin, Sat Apr 7 21:08:34 2007 UTC
# Line 550  POE::Session->create( inline_states => Line 550  POE::Session->create( inline_states =>
550                  save_message( channel => $channel, me => 1, nick => $nick, msg => $msg);                  save_message( channel => $channel, me => 1, nick => $nick, msg => $msg);
551    
552                  if ( $use_twitter ) {                  if ( $use_twitter ) {
553                          if ( my $twitter = meta( $nick, $channel, 'twitter' ) ) {                          if ( my $twitter = meta( $nick, $NICK, 'twitter' ) ) {
554                                  my ($login,$passwd) = split(/\s+/,$twitter,2);                                  my ($login,$passwd) = split(/\s+/,$twitter,2);
555                                  _log("sending twitter for $nick/$login on $channel ");                                  _log("sending twitter for $nick/$login on $channel ");
556                                  my $bot = Net::Twitter->new( username=>$login, password=>$passwd );                                  my $bot = Net::Twitter->new( username=>$login, password=>$passwd );
# 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.54  
changed lines
  Added in v.58
  ViewVC Help
Powered by ViewVC 1.1.26