--- trunk/bin/irc-logger.pl	2007/03/18 17:14:52	54
+++ trunk/bin/irc-logger.pl	2007/04/07 21:08:34	58
@@ -550,7 +550,7 @@
 		save_message( channel => $channel, me => 1, nick => $nick, msg => $msg);
 
 		if ( $use_twitter ) {
-			if ( my $twitter = meta( $nick, $channel, 'twitter' ) ) {
+			if ( my $twitter = meta( $nick, $NICK, 'twitter' ) ) {
 				my ($login,$passwd) = split(/\s+/,$twitter,2);
 				_log("sending twitter for $nick/$login on $channel ");
 				my $bot = Net::Twitter->new( username=>$login, password=>$passwd );
@@ -602,11 +602,11 @@
 
 			my $sth = $dbh->prepare(qq{
 				select
-					nick,
+					trim(both '_' from nick) as nick,
 					count(*) as count,
 					sum(length(message)) as len
 				from log
-				group by nick
+				group by trim(both '_' from nick)
 				order by len desc,count desc
 				limit $nr
 			});