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 ); |