X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=Delling.pm;h=4f779848a476bdddfe74ee2a95f89a5fe0f8fb62;hb=4c2994d62294e1ea2232627b09eb2254ef82f264;hp=545df2fdc8aeaab7b886ac415422ad42ff4882da;hpb=1e1f7cb4c3ae7c515d3541c5fd22ae0e2817e34b;p=NDIRC.git diff --git a/Delling.pm b/Delling.pm index 545df2f..4f77984 100644 --- a/Delling.pm +++ b/Delling.pm @@ -117,18 +117,6 @@ FROM users u WHERE hostmask = ? unless ($user->{password}) { $irc->yield(privmsg => $channel, "$nick: Get a new random password with /msg delling !getpass . If you don't know your username, then you can get it with .points"); } - if ($tick > 12 && not defined $user->{pid}){ - $irc->yield(privmsg => $channel, "$nick: go to https://nd.ruin.nu/ and enter your coords."); - } - - if (not defined $user->{last_forum_visit}){ - $irc->yield(privmsg => $channel, "$nick: Go read the forum! https://nd.ruin.nu/forum"); - }else { - my $unread = $dbh->selectrow_hashref(q{SELECT * FROM unread_posts($1)},undef,$user->{uid}); - if ($unread && $unread->{new}){ - $irc->yield(notice => $nick, "$unread->{new} posts since your last forum visit ($unread->{unread} unread posts in total) https://nd.ruin.nu/forum/allUnread"); - } - } } if (time - $last_announcement < 2){ $last_announcement = time; @@ -161,11 +149,19 @@ sub refresh { SET sent = TRUE WHERE id = ANY($1) }); $scans->execute; + my @scanreqs; while (my $scan = $scans->fetchrow_hashref){ $self->message("($scan->{coords} $scan->{type})" ." http://game.planetarion.com/showscan.pl?scan_id=$scan->{scan_id}" , @{$scan->{nick}}); $sentscan->execute($scan->{id}); + push @scanreqs, @{$scan->{id}}; + } + + if (scalar @scanreqs > 0) + { + my $scanreqs = join(', ', @scanreqs); + $self->toTarget(scan => "Handled the following requests: $scanreqs"); } my @row = $dbh->selectrow_array(q{SELECT tick(), max(tick) FROM planet_stats}); @@ -176,6 +172,11 @@ sub refresh { if (defined $row[1] && $stattick != $row[1]){ $stattick = $row[1]; $self->toTarget(spam => "New tick: $stattick"); + my $raids = $dbh->prepare(q{UPDATE raids SET open = true WHERE NOT open AND NOT removed AND open_tick <= $1 RETURNING id}); + $raids->execute($stattick); + while (my $raid = $raids->fetchrow_hashref) { + $self->toTarget(members => "\@everyone Raid is now open: https://nd.ruin.nu/raids/view/$raid->{id}"); + } } my $ircreqs = $dbh->prepare(q{SELECT id,username,message,channel FROM irc_requests NATURAL JOIN users WHERE not sent}); my $upircreq = $dbh->prepare(q{UPDATE irc_requests SET sent = TRUE WHERE id = ?}); @@ -220,8 +221,7 @@ after _start => sub { }; after discord_message_create => sub { - my $self = shift; - my $hash = shift; + my ($self, $gw, $hash) = @_; my $author = $hash->{author}; my $msg = $hash->{content}; @@ -240,6 +240,7 @@ after discord_message_create => sub { my $c = NDIRC::DiscordContext->new({ discord_id => $author_name, channel_id => $channel_id, + author_id => $author_id, channel => $channel, disp => $self->disp, model => DB(),