X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=Delling.pm;h=4f779848a476bdddfe74ee2a95f89a5fe0f8fb62;hb=4c2994d62294e1ea2232627b09eb2254ef82f264;hp=c6d06fa1ac500ccaf92e14c5efed3476c99bb5b1;hpb=d43083661d814e3ef6d92a29fb2501515e429d71;p=NDIRC.git

diff --git a/Delling.pm b/Delling.pm
index c6d06fa..4f77984 100644
--- a/Delling.pm
+++ b/Delling.pm
@@ -149,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});
@@ -164,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 = ?});