X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FJSRPC.pm;h=bf7e5940256f6bf056d3cfbb3d268e4f77b86175;hb=816fe5105ca7111b535a2729094e65a2ad83718a;hp=6e21a9446014b30288cc0786604c41401fe00998;hpb=bfb863664b89cece691ad13b1b84470392584664;p=ndwebbie.git

diff --git a/lib/NDWeb/Controller/JSRPC.pm b/lib/NDWeb/Controller/JSRPC.pm
index 6e21a94..bf7e594 100644
--- a/lib/NDWeb/Controller/JSRPC.pm
+++ b/lib/NDWeb/Controller/JSRPC.pm
@@ -41,12 +41,12 @@ sub update : Local {
 		my ($timestamp) = $dbh->selectrow_array(q{SELECT MAX(modified)::timestamp AS modified
 			FROM raid_targets WHERE raid = $1},undef,$raid->{id});
 		$c->stash(timestamp => $timestamp);
-		$targets = $dbh->prepare(q{SELECT r.id,r.planet FROM raid_targets r
+		$targets = $dbh->prepare(q{SELECT r.id,r.pid FROM raid_targets r
 			WHERE r.raid = ? AND modified > ?
 		});
 		$targets->execute($raid->{id},$from);
 	}elsif($target){
-		$targets = $dbh->prepare(q{SELECT r.id,r.planet FROM raid_targets r
+		$targets = $dbh->prepare(q{SELECT r.id,r.pid FROM raid_targets r
 			WHERE r.raid = $1 AND r.id = $2
 		});
 		$targets->execute($raid->{id},$target);
@@ -219,6 +219,39 @@ sub assertTarget : Private {
 	}
 }
 
+sub addscans : Local {
+	my ( $self, $c ) = @_;
+	my $dbh = $c->model;
+
+	my $findscan = $dbh->prepare(q{SELECT scan_id FROM scans
+		WHERE scan_id = LOWER(?) AND tick >= tick() - 168 AND groupscan = ?
+		});
+	my $addscan = $dbh->prepare(q{INSERT INTO scans (scan_id,tick,uid,groupscan)
+		VALUES (LOWER(?),tick(),?,?)
+		});
+	my $addpoint = $dbh->prepare(q{UPDATE users SET scan_points = scan_points + 1
+		WHERE uid = ?
+		});
+	my $message = $c->req->param('message');
+	my @scans;
+	while ($message =~ m{scan(_id|_grp)?=(\w+)}g){
+		my $groupscan = (defined $1 && $1 eq '_grp') || 0;
+		my %scan;
+		$scan{id} = $2;
+		$scan{group} = $groupscan;
+		$findscan->execute($2,$groupscan);
+		if ($findscan->rows == 0){
+			if ($addscan->execute($2,$c->stash->{UID},$groupscan)){
+				$addpoint->execute($c->stash->{UID}) unless $groupscan;
+				$scan{added} = 1;
+			}
+		}else{
+			$scan{message} = 'already exists';
+		}
+		push @scans,\%scan;
+	}
+}
+
 sub end : ActionClass('RenderView') {
 	my ($self,$c) = @_;
 	$c->res->content_type('application/xml');