X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=Delling.pm;h=f19bf2a366271e06525641a03ffbe6115be75874;hb=effc5281e94e0fa16f1fd08bf848f607a306d0c0;hp=dc4a0b09b02dbc8049708ab02bded2272029be70;hpb=827dca1b13ddf19dce2dee7406888c676ca1fd8a;p=NDIRC.git

diff --git a/Delling.pm b/Delling.pm
index dc4a0b0..f19bf2a 100644
--- a/Delling.pm
+++ b/Delling.pm
@@ -127,7 +127,7 @@ FROM users u WHERE hostmask = ?
 			if ($user->{password} eq ''){
 				$irc->yield(privmsg => $disp->targets->{members}, "$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 > 36 && not defined $user->{pid}){
+			if ($tick > 12 && not defined $user->{pid}){
 				$irc->yield(privmsg => $disp->targets->{members}, "$nick: go to https://nd.ruin.nu/ and enter your coords.");
 			}
 
@@ -207,7 +207,7 @@ FROM users u
 	JOIN fleets f USING (fid)
 	JOIN fleet_ships fs USING (fid)
 	JOIN defense_missions dm ON f.fid = dm.fleet
-	JOIN ship_stats ss ON fs.ship = ss.name
+	JOIN ship_stats ss USING (ship)
 WHERE NOT dm.announced
 GROUP BY username,call,tick,dm.fleet,p.value
 		});