X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=Commands%2FScans.pm;h=ed0def8dc5af3bd3adfafe4c23497ac377b41ea2;hb=5f3e2c69d303e9196a76dd10607b595cac6658a8;hp=11f3337308eeaef821ff59383f43764ccb918001;hpb=f4fda6de68d23833ffe61c81f29177cc210b3825;p=NDIRC.git

diff --git a/Commands/Scans.pm b/Commands/Scans.pm
index 11f3337..ed0def8 100644
--- a/Commands/Scans.pm
+++ b/Commands/Scans.pm
@@ -1,5 +1,5 @@
 #**************************************************************************
-#   Copyright (C) 2008 by Michael Andreen <harvATruinDOTnu>               *
+#   Copyright (C) 2009 by Michael Andreen <harvATruinDOTnu>               *
 #                                                                         *
 #   This program is free software; you can redistribute it and/or modify  *
 #   it under the terms of the GNU General Public License as published by  *
@@ -54,6 +54,10 @@ sub gs
 
 	my $planet = $c->model->selectrow_array(q{SELECT planetid($1,$2,$3,tick())}
 		,undef,$x,$y,$z);
+	unless ($planet){
+		$c->reply("There is no planet with coords $x:$y:$z, try again after the tick.");
+		return;
+	}
 
 	my $query = $c->model->prepare(q{SELECT scan_id
 		FROM scans
@@ -144,4 +148,104 @@ ORDER BY id
 	$c->reply($text || 'No unhandled requests.');
 }
 
+sub scan
+	: Help(syntax: scan type X:Y:Z [tick] | type is the first character in the scan name, like p for planet scan. Specify a tick if you want scans older than the specified tick.)
+	: ACL(irc_scan)
+	: Type(pm)
+{
+	my ($self, $c,$msg) = @_;
+
+	my ($t, $x, $y, $z, $tick)
+		= $msg =~ /^([pdunja]) (\d+)\D+(\d+)\D+(\d+)(?: (\d+))?/ or die 'ARGS';
+	my $type =$scantypes[$scanid{$t}-1];
+
+	my $scan = $c->model->selectrow_hashref(q{
+SELECT id, scan_id, tick FROM scans
+WHERE type = $1 AND planet = planetid($2,$3,$4,0) AND COALESCE(tick < $5,TRUE)
+ORDER BY tick DESC LIMIT 1
+			},undef,$type,$x,$y,$z,$tick);
+	unless ($scan->{id}){
+		$c->reply("No $type scan for $x:$y:$z. Planet might not exist.");
+		return;
+	}
+	my $text = '';
+	given ($t){
+		when(/[ua]/){
+			my $fid = $c->model->selectrow_array(q{
+SELECT fid FROM fleet_scans WHERE id = $1
+			},undef,$scan->{id});
+			my $ships = $c->model->prepare(q{
+SELECT ship,amount FROM fleet_ships WHERE fid = $1 ORDER BY num
+			});
+			$ships->execute($fid);
+			while (my $ship = $ships->fetchrow_hashref){
+				$text .= " $ship->{ship} $ship->{amount} |"
+			}
+		}
+		default {
+			$text = "http://game.planetarion.com/showscan.pl?scan_id=$scan->{scan_id}";
+		}
+	}
+	$c->reply("<b>$type</b> scan of $x:$y:$z "
+		. "($scan->{scan_id} pt: <b>$scan->{tick}</b>): $text");
+}
+
+sub anon
+	: Help(syntax: .anon nick message)
+	: Type(scan)
+	: ACL(irc_anonscan)
+{
+	my ($self, $c, $msg) = @_;
+	my ($target,$mess) = $msg =~ /^(\S+) (.*)$/ or die 'ARGS';
+
+	$c->message("msg $target", "<b>$mess</b> <c04>(reply with /msg "
+		.$c->channel.")</c>");
+	$c->message("msg ".$c->channel, "<c03>$target << $mess</c>");
+}
+
+sub addscan
+	: Help(syntax: .addscan list of scans)
+{
+	my ($self, $c, $msg) = @_;
+	my $dbh = $c->model;
+
+	my $oldscan = $dbh->prepare(q{
+SELECT scan_id FROM scans
+WHERE groupscan = $1 AND scan_id = LOWER($2) AND tick >= tick() - 168
+		});
+	my $addscan = $dbh->prepare(q{
+INSERT INTO scans (scan_id,tick,groupscan,uid) VALUES (LOWER($1),tick(),$2,COALESCE($3,-1))
+		});
+	my $user = $dbh->selectrow_hashref(q{SELECT uid,username, scan_points, tick()
+		FROM users WHERE hostmask ILIKE ? },undef,$c->host);
+	my $groupscans = 0;
+	my $scans = 0;
+	eval {
+		$dbh->begin_work;
+		while ($msg =~ m{/.+?scan(_id|_grp)?=(\w+)}g){
+			my $id = $2;
+			my $group = ($1 ~~ /_grp/ || 0);
+			unless($dbh->selectrow_array($oldscan,undef,$group,$id)){
+				$addscan->execute($id,$group,$user->{uid});
+				if ($group){
+					$groupscans++;
+				}else{
+					$scans++;
+				}
+			}
+		}
+		if ($user->{uid} && ($scans || $groupscans)){
+			$dbh->do(q{UPDATE users SET scan_points = scan_points + $2 WHERE uid = $1}
+				,undef,$user->{uid},$scans);
+			my $points = $user->{scan_points} + $scans;
+			$c->reply("Added $scans scans and $groupscans groupscans, $points in total.");
+		}
+		$dbh->commit;
+	};
+	if ($@){
+		$dbh->rollback;
+		die $@;
+	}
+}
+
 1;