use NDIRC::Misc;
use ND::DB;
-my $DBH = DB();
-my $TICK = $DBH->selectrow_array('SELECT tick()');
-
sub irc_public {
my ($sender, $heap, $who, $where, $msg) = @_[SENDER, HEAP, ARG0 .. ARG2];
my ($nick,$username,$address) = ( split /[!@]/, $who );
my $irc = $sender->get_heap();
#$irc->yield(privmsg => $channel, "Authed? " . $irc->is_nick_authed($nick));
+ my $dbh = DB();
+ my $seen = $dbh->prepare_cached(q{UPDATE users SET laston = NOW() WHERE hostmask = ?});
+ $seen->execute($address);
if ($msg =~ /^(\S+): (.+)$/ && $heap->{disp}->has_command('anon',$channel)){
my $_ = $1;
}
}
- if (parseCommand($msg,$irc,$nick,$address,$channel,$heap->{disp},DB())){
+ if (parseCommand($msg,$irc,$nick,$address,$channel,$heap->{disp},$dbh)){
#Command parsed and run successfully
}
}
my ($nick,$username,$address) = ( split /[!@]/, $who );
my $irc = $sender->get_heap();
- if (parseCommand($msg,$irc,$nick,$address,'pm',$heap->{disp},DB())){
+ my $dbh = DB();
+ my $seen = $dbh->prepare_cached(q{UPDATE users SET laston = NOW() WHERE hostmask = ?});
+ $seen->execute($address);
+
+ if (parseCommand($msg,$irc,$nick,$address,'pm',$heap->{disp},$dbh)){
#Command parsed and run successfully
+ }else{
+ $irc->yield(notice => $nick, "unknown command");
}
}
my ($nick,$username,$address) = ( split /[!@]/, $who );
my $irc = $sender->get_heap();
+ my $dbh = DB();
+ my $seen = $dbh->prepare_cached(q{UPDATE users SET laston = NOW() WHERE hostmask = ?});
+ $seen->execute($address);
+
if($heap->{disp}->has_command('voice',$channel)){
- my $dbh = DB();
my $flags = $dbh->prepare_cached(q{
SELECT DISTINCT flag
FROM users u
sub refresh {
my ($kernel,$heap) = @_[KERNEL,HEAP];
- print 'Time: ' . time() . ' Lag: ' . $heap->{connector}->lag() . "\n";
$kernel->delay( refresh => 60 );
+ print 'Time: ' . time() . ' Lag: ' . $heap->{connector}->lag() . "\n";
+
+ my $dbh = DB();
+ my $scans = $dbh->prepare(q{SELECT s.scan_id
+ ,array_agg(sr.nick) AS nick
+ ,array_agg(sr.id) AS id
+ FROM scan_requests sr
+ JOIN scans s USING (pid,type)
+ WHERE sr.time > NOW() - '30 min'::INTERVAL
+ AND s.tick >= sr.tick AND NOT sr.sent
+ GROUP BY scan_id
+ });
+ my $sentscan = $dbh->prepare(q{UPDATE scan_requests
+ SET sent = TRUE WHERE id = ANY($1)
+ });
+ $scans->execute;
+ while (my $scan = $scans->fetchrow_hashref){
+ $heap->{irc}->yield(notice => $scan->{nick}, "http://game.planetarion.com/showscan.pl?scan_id=$scan->{scan_id}");
+ $sentscan->execute($scan->{id});
+ }
return;
}