2 |
use strict; |
use strict; |
3 |
$|++; |
$|++; |
4 |
|
|
5 |
|
use POE qw(Component::IRC Component::Server::HTTP); |
6 |
|
use HTTP::Status; |
7 |
|
use DBI; |
8 |
|
use Regexp::Common qw /URI/; |
9 |
|
use CGI::Simple; |
10 |
|
use HTML::TagCloud; |
11 |
|
use POSIX qw/strftime/; |
12 |
|
use HTML::CalendarMonthSimple; |
13 |
|
use Getopt::Long; |
14 |
|
use DateTime; |
15 |
|
use URI::Escape; |
16 |
|
use Data::Dump qw/dump/; |
17 |
|
use DateTime::Format::ISO8601; |
18 |
|
use Carp qw/confess/; |
19 |
|
use XML::Feed; |
20 |
|
use DateTime::Format::Flexible; |
21 |
|
|
22 |
=head1 NAME |
=head1 NAME |
23 |
|
|
24 |
irc-logger.pl |
irc-logger.pl |
52 |
|
|
53 |
my $NICK = 'irc-logger'; |
my $NICK = 'irc-logger'; |
54 |
$NICK .= '-dev' if ($HOSTNAME =~ m/llin/); |
$NICK .= '-dev' if ($HOSTNAME =~ m/llin/); |
55 |
my $CONNECT = |
my $CONNECT = { |
56 |
{Server => 'irc.freenode.net', |
Server => 'irc.freenode.net', |
57 |
Nick => $NICK, |
Nick => $NICK, |
58 |
Ircname => "try /msg $NICK help", |
Ircname => "try /msg $NICK help", |
59 |
}; |
}; |
60 |
my $CHANNEL = '#razmjenavjestina'; |
my $CHANNEL = '#razmjenavjestina'; |
61 |
$CHANNEL = '#irc-logger' if ($HOSTNAME =~ m/llin/); |
$CHANNEL = '#irc-logger' if ($HOSTNAME =~ m/llin/); |
62 |
my $IRC_ALIAS = "log"; |
my $IRC_ALIAS = "log"; |
63 |
|
|
64 |
|
if ( $HOSTNAME =~ m/lugarin/ ) { |
65 |
|
$CONNECT->{Server} = 'irc.carnet.hr'; |
66 |
|
$CHANNEL = '#riss'; |
67 |
|
} |
68 |
|
|
69 |
|
warn dump( $HOSTNAME, $CONNECT ); |
70 |
|
|
71 |
my $DSN = 'DBI:Pg:dbname=' . $NICK; |
my $DSN = 'DBI:Pg:dbname=' . $NICK; |
72 |
|
|
73 |
my $TIMESTAMP = '%Y-%m-%d %H:%M:%S'; |
my $TIMESTAMP = '%Y-%m-%d %H:%M:%S'; |
86 |
|
|
87 |
## END CONFIG |
## END CONFIG |
88 |
|
|
|
use POE qw(Component::IRC Component::Server::HTTP); |
|
|
use HTTP::Status; |
|
|
use DBI; |
|
|
use Regexp::Common qw /URI/; |
|
|
use CGI::Simple; |
|
|
use HTML::TagCloud; |
|
|
use POSIX qw/strftime/; |
|
|
use HTML::CalendarMonthSimple; |
|
|
use Getopt::Long; |
|
|
use DateTime; |
|
|
use URI::Escape; |
|
|
use Data::Dump qw/dump/; |
|
|
use DateTime::Format::ISO8601; |
|
|
use Carp qw/confess/; |
|
|
use XML::Feed; |
|
|
use DateTime::Format::Flexible; |
|
|
|
|
89 |
my $use_twitter = 1; |
my $use_twitter = 1; |
90 |
eval { require Net::Twitter; }; |
eval { require Net::Twitter; }; |
91 |
$use_twitter = 0 if ($@); |
$use_twitter = 0 if ($@); |
346 |
|
|
347 |
my @where; |
my @where; |
348 |
my @args; |
my @args; |
349 |
|
my $msg; |
350 |
|
|
351 |
if (my $search = $args->{search}) { |
if (my $search = $args->{search}) { |
352 |
$search =~ s/^\s+//; |
$search =~ s/^\s+//; |
353 |
$search =~ s/\s+$//; |
$search =~ s/\s+$//; |
354 |
push @where, 'message ilike ? or nick ilike ?'; |
push @where, 'message ilike ? or nick ilike ?'; |
355 |
push @args, ( ( '%' . $search . '%' ) x 2 ); |
push @args, ( ( '%' . $search . '%' ) x 2 ); |
356 |
_log "search for '$search'"; |
$msg = "Search for '$search'"; |
357 |
} |
} |
358 |
|
|
359 |
if ($args->{tag} && $tags->{ $args->{tag} }) { |
if ($args->{tag} && $tags->{ $args->{tag} }) { |
360 |
push @where, 'id in (' . join(',', @{ $tags->{ $args->{tag} } }) . ')'; |
push @where, 'id in (' . join(',', @{ $tags->{ $args->{tag} } }) . ')'; |
361 |
_log "search for tags $args->{tag}"; |
$msg = "Search for tags $args->{tag}"; |
362 |
} |
} |
363 |
|
|
364 |
if (my $date = $args->{date} ) { |
if (my $date = $args->{date} ) { |
365 |
$date = check_date( $date ); |
$date = check_date( $date ); |
366 |
push @where, 'date(time) = ?'; |
push @where, 'date(time) = ?'; |
367 |
push @args, $date; |
push @args, $date; |
368 |
_log "search for date $date"; |
$msg = "search for date $date"; |
369 |
} |
} |
370 |
|
|
371 |
$sql .= " where " . join(" and ", @where) if @where; |
$sql .= " where " . join(" and ", @where) if @where; |
379 |
eval { $sth->execute( @args ) }; |
eval { $sth->execute( @args ) }; |
380 |
return if $@; |
return if $@; |
381 |
|
|
382 |
|
my $nr_results = $sth->rows; |
383 |
|
|
384 |
my $last_row = { |
my $last_row = { |
385 |
date => '', |
date => '', |
386 |
time => '', |
time => '', |
401 |
|
|
402 |
return @rows if ($args->{full_rows}); |
return @rows if ($args->{full_rows}); |
403 |
|
|
404 |
my @msgs = ( |
$msg .= ' produced ' . ( |
405 |
"Showing " . ($#rows + 1) . " messages..." |
$nr_results == 0 ? 'no results' : |
406 |
|
$nr_results == 0 ? 'one result' : |
407 |
|
$nr_results . ' results' |
408 |
); |
); |
409 |
|
|
410 |
|
my @msgs = ( $msg ); |
411 |
|
|
412 |
if ($context) { |
if ($context) { |
413 |
my @ids = @rows; |
my @ids = @rows; |
414 |
@rows = (); |
@rows = (); |
669 |
} elsif ( $link !~ m!^http! ) { |
} elsif ( $link !~ m!^http! ) { |
670 |
$link = $args->{url} . $link; |
$link = $args->{url} . $link; |
671 |
} |
} |
|
$link =~ s!//+!/!g; |
|
672 |
|
|
673 |
my $msg; |
my $msg; |
674 |
$msg .= prefix( 'From: ' , $args->{name} || $feed->title ); |
$msg .= prefix( 'From: ' , $args->{name} || $feed->title ); |
945 |
$channel = $nick if $sub eq 'private'; |
$channel = $nick if $sub eq 'private'; |
946 |
|
|
947 |
my $sql = { |
my $sql = { |
948 |
add => qq{ insert into feeds (url,name,channel,nick,private) values (?,?,?,?,?) }, |
add => qq{ insert into feeds (url,name,channel,nick,private) values (?,?,?,?,?) }, |
949 |
# remove => qq{ delete from feeds where url = ? and name = ? }, |
# remove => qq{ delete from feeds where url = ? and name = ? }, |
950 |
start => qq{ update feeds set active = true where url = ? }, |
start => qq{ update feeds set active = true where url = ? }, |
951 |
stop => qq{ update feeds set active = false where url = ? }, |
stop => qq{ update feeds set active = false where url = ? }, |
979 |
rss_check_updates( $_[KERNEL] ); |
rss_check_updates( $_[KERNEL] ); |
980 |
}, |
}, |
981 |
irc_477 => sub { |
irc_477 => sub { |
982 |
_log "# irc_477: ",$_[ARG1]; |
_log "<< irc_477: ",$_[ARG1]; |
983 |
$_[KERNEL]->post( $IRC_ALIAS => privmsg => 'nickserv', "register $NICK" ); |
$_[KERNEL]->post( $IRC_ALIAS => privmsg => 'nickserv', "register $NICK" ); |
984 |
}, |
}, |
985 |
irc_505 => sub { |
irc_505 => sub { |
986 |
_log "# irc_505: ",$_[ARG1]; |
_log "<< irc_505: ",$_[ARG1]; |
987 |
$_[KERNEL]->post( $IRC_ALIAS => privmsg => 'nickserv', "register $NICK" ); |
$_[KERNEL]->post( $IRC_ALIAS => privmsg => 'nickserv', "register $NICK" ); |
988 |
# $_[KERNEL]->post( $IRC_ALIAS => privmsg => 'nickserv', "set hide email on" ); |
# $_[KERNEL]->post( $IRC_ALIAS => privmsg => 'nickserv', "set hide email on" ); |
989 |
# $_[KERNEL]->post( $IRC_ALIAS => privmsg => 'nickserv', "set email dpavlin\@rot13.org" ); |
# $_[KERNEL]->post( $IRC_ALIAS => privmsg => 'nickserv', "set email dpavlin\@rot13.org" ); |
990 |
}, |
}, |
991 |
irc_registered => sub { |
irc_registered => sub { |
992 |
_log "## registrated $NICK"; |
_log "## registrated $NICK, /msg nickserv IDENTIFY $NICK"; |
993 |
$_[KERNEL]->post( $IRC_ALIAS => privmsg => 'nickserv', "IDENTIFY $NICK" ); |
$_[KERNEL]->post( $IRC_ALIAS => privmsg => 'nickserv', "IDENTIFY $NICK" ); |
994 |
}, |
}, |
995 |
irc_disconnected => sub { |
irc_disconnected => sub { |
996 |
_log "## disconnected, reconnecting again"; |
_log "## disconnected.. sleeping for $sleep_on_error seconds and reconnecting again"; |
997 |
$_[KERNEL]->post($IRC_ALIAS => connect => $CONNECT); |
sleep($sleep_on_error); |
998 |
|
$_[KERNEL]->post( $IRC_ALIAS => connect => $CONNECT); |
999 |
}, |
}, |
1000 |
irc_socketerr => sub { |
irc_socketerr => sub { |
1001 |
_log "## socket error... sleeping for $sleep_on_error seconds and retry"; |
_log "## socket error... sleeping for $sleep_on_error seconds and retry"; |
1002 |
sleep($sleep_on_error); |
sleep($sleep_on_error); |
1003 |
$_[KERNEL]->post($IRC_ALIAS => connect => $CONNECT); |
$_[KERNEL]->post( $IRC_ALIAS => connect => $CONNECT); |
1004 |
}, |
}, |
1005 |
# irc_433 => sub { |
# irc_433 => sub { |
1006 |
# print "# irc_433: ",$_[ARG1], "\n"; |
# print "# irc_433: ",$_[ARG1], "\n"; |
1007 |
# warn "## indetify $NICK\n"; |
# warn "## indetify $NICK\n"; |
1008 |
# $_[KERNEL]->post( $IRC_ALIAS => privmsg => 'nickserv', "IDENTIFY $NICK" ); |
# $_[KERNEL]->post( $IRC_ALIAS => privmsg => 'nickserv', "IDENTIFY $NICK" ); |
1009 |
# }, |
# }, |
1010 |
|
# irc_451 # please register |
1011 |
|
irc_snotice => sub { |
1012 |
|
_log "<< snotice",$_[ARG0]; |
1013 |
|
if ( $_[ARG0] =~ m!/(QUOTE)\s+(PASS\s+\d+)!i ) { |
1014 |
|
warn ">> $1 | $2\n"; |
1015 |
|
$_[KERNEL]->post( $IRC_ALIAS => lc($1) => $2); |
1016 |
|
} |
1017 |
|
}, |
1018 |
_child => sub {}, |
_child => sub {}, |
1019 |
_default => sub { |
_default => sub { |
1020 |
_log sprintf "sID:%s %s %s", |
_log sprintf "sID:%s %s %s", |