X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=editRaid.pl;h=a1de374e59b81b597583d536b882b07c81b035fc;hb=e9725f0f2d11e349e3f3db752b46929a80a03c1d;hp=74c2c63f67f3814d97058cb3bcebe01acc1a8d75;hpb=191f4e2ff4e447b1219a4d49975a8cbc1039eb65;p=ndwebbie.git

diff --git a/editRaid.pl b/editRaid.pl
index 74c2c63..a1de374 100644
--- a/editRaid.pl
+++ b/editRaid.pl
@@ -18,10 +18,13 @@
 #**************************************************************************/
 
 use strict;
+use warnings FATAL => 'all';
+no warnings qw(uninitialized);
 use POSIX;
 our $BODY;
 our $DBH;
 our $LOG;
+my $error;
 
 $ND::TEMPLATE->param(TITLE => 'Create/Edit Raids');
 
@@ -35,6 +38,105 @@ if (param('raid') =~ /^(\d+)$/){
 	my $query = $DBH->prepare(q{SELECT id,tick,waves,message,released_coords,open FROM raids WHERE id = ?});
 	$raid = $DBH->selectrow_hashref($query,undef,$1);
 }
+if (param('cmd') eq 'submit'){
+	my $query = $DBH->prepare(q{INSERT INTO raids (tick,waves,message) VALUES(?,?,'')});
+	if ($query->execute(param('tick'),param('waves'))){
+		$raid = $DBH->last_insert_id(undef,undef,undef,undef,"raids_id_seq");
+		my $query = $DBH->prepare(q{SELECT id,tick,waves,message,released_coords,open FROM raids WHERE id = ?});
+		$raid = $DBH->selectrow_hashref($query,undef,$raid);
+	}else{
+		$error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
+	}
+}
+
+if ($raid){
+	if (param('cmd') eq 'remove'){
+		$DBH->do(q{UPDATE raids SET open = FALSE, removed = TRUE WHERE id = ?},undef,$raid->{id});
+	}elsif (param('cmd') eq 'Open'){
+		if($DBH->do(q{UPDATE raids SET open = TRUE, removed = FALSE WHERE id = ?},undef,$raid->{id})){
+			$raid->{open} = 1;
+			$raid->{removed} = 0;
+		}
+	}elsif (param('cmd') eq 'Close'){
+		if ($DBH->do(q{UPDATE raids SET open = FALSE WHERE id = ?},undef,$raid->{id})){
+			$raid->{open} = 0;
+		}
+	}elsif (param('cmd') eq 'showcoords'){
+		if($DBH->do(q{UPDATE raids SET released_coords = TRUE WHERE id = ?},undef,$raid->{id})){
+			$raid->{released_coords} = 1;
+		}
+	}elsif (param('cmd') eq 'hidecoords'){
+		if($DBH->do(q{UPDATE raids SET released_coords = FALSE WHERE id = ?},undef,$raid->{id})){
+			$raid->{released_coords} = 0;
+		}
+	}elsif (param('cmd') eq 'comment'){
+		$DBH->do(q{UPDATE raid_targets SET comment = ? WHERE id = ?}
+			,undef,escapeHTML(param('comment')),param('target'))
+			or $error .= p($DBH->errstr);
+
+	}elsif (param('cmd') eq 'change'){
+		$DBH->begin_work;
+		my $message = escapeHTML(param('message'));
+		$raid->{message} = $message;
+		$raid->{waves} = param('waves');
+		$raid->{tick} = param('tick');
+		unless ($DBH->do(qq{UPDATE raids SET message = ?, tick = ?, waves = ? WHERE id = ?}
+				,undef,$message,param('tick'),param('waves'),$raid->{id})){
+			$error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
+		}
+		my $sizelimit = '';
+		if (param('sizelimit') =~ /^(\d+)$/){
+			$sizelimit = "AND p.size >= $1";
+			unless ($DBH->do(qq{DELETE FROM raid_targets WHERE id IN (SELECT t.id FROM current_planet_stats p 
+	JOIN raid_targets t ON p.id = t.planet WHERE p.size < ? AND t.raid = ?)},undef,$1,$raid->{id})){
+				$error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
+			}
+		}
+		my $targets = param('targets');
+		my $addtarget = $DBH->prepare(qq{INSERT INTO raid_targets(raid,planet) (
+	SELECT ?, id FROM current_planet_stats p WHERE x = ? AND y = ? AND COALESCE(z = ?,TRUE) $sizelimit)});
+		while ($targets =~ m/(\d+):(\d+)(?::(\d+))?/g){
+			unless ($addtarget->execute($raid->{id},$1,$2,$3)){
+				$error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
+			}
+		}
+		if (param('alliance') =~ /^(\d+)$/ && $1 != 1){
+			$LOG->execute($ND::UID,"BC adding alliance $1 to raid");
+			my $addtarget = $DBH->prepare(qq{INSERT INTO raid_targets(raid,planet) (
+	SELECT ?,id FROM current_planet_stats p WHERE alliance_id = ? $sizelimit)});
+			unless ($addtarget->execute($raid->{id},$1)){
+				$error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
+			}
+		}
+		my $groups = $DBH->prepare('SELECT gid,groupname FROM groups WHERE attack');
+		my $delgroup = $DBH->prepare(q{DELETE FROM raid_access WHERE raid = ? AND gid = ?});
+		my $addgroup = $DBH->prepare(q{INSERT INTO raid_access (raid,gid) VALUES(?,?)});
+		$groups->execute();
+		while (my $group = $groups->fetchrow_hashref){
+			my $query;
+			if (param($group->{gid}) eq 'remove'){
+				$query = $delgroup;
+			}elsif(param($group->{gid}) eq 'add'){
+				$query = $addgroup;
+			}
+			if ($query){
+				unless ($query->execute($raid->{id},$group->{gid})){
+					$error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
+				}
+			}
+		}
+		unless ($DBH->commit){
+			$error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
+		}
+	}
+	if (param('removeTarget')){
+		$error .= "test";
+		unless($DBH->do(q{DELETE FROM raid_targets WHERE raid = ? AND id = ?}
+				,undef,$raid->{id},param('removeTarget'))){
+			$error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
+		}
+	}
+}
 
 my $groups = $DBH->prepare(q{SELECT g.gid,g.groupname,raid FROM groups g LEFT OUTER JOIN (SELECT gid,raid FROM raid_access WHERE raid = ?) AS ra ON g.gid = ra.gid WHERE g.attack});
 $groups->execute($raid ? $raid->{id} : undef);
@@ -51,12 +153,14 @@ while (my $group = $groups->fetchrow_hashref){
 $BODY->param(RemoveGroups => \@remgroups);
 $BODY->param(AddGroups => \@addgroups);
 
+
 if ($raid){
+
 	$BODY->param(Raid => $raid->{id});
 	if($raid->{open}){
-		$BODY->param(Open => 'Open');
-	}else{
 		$BODY->param(Open => 'Close');
+	}else{
+		$BODY->param(Open => 'Open');
 	}
 	if($raid->{released_coords}){
 		$BODY->param(ShowCoords => 'hidecoords');
@@ -74,12 +178,11 @@ if ($raid){
 		$order = "$1 DESC";
 	}
 
-	my $targetquery = $DBH->prepare(qq{SELECT p.id,coords(x,y,z),raid,comment,size,score,value,race,planet_status AS planetstatus,relationship,comment
+	my $targetquery = $DBH->prepare(qq{SELECT r.id,coords(x,y,z),raid,comment,size,score,value,race,planet_status AS planetstatus,relationship,comment
 		FROM current_planet_stats p JOIN raid_targets r ON p.id = r.planet 
-			LEFT OUTER JOIN covop_targets c ON p.id = c.planet
 		WHERE r.raid = ?
 		ORDER BY $order});
-	$targetquery->execute($raid->{id}) or print $DBH->errstr;
+	$targetquery->execute($raid->{id}) or $error .= $DBH->errstr;
 	my @targets;
 	while (my $target = $targetquery->fetchrow_hashref){
 		push @targets,$target;
@@ -89,5 +192,6 @@ if ($raid){
 	$BODY->param(Waves => 3);
 	$BODY->param(LandingTick => $ND::TICK+12);
 }
+$BODY->param(Error => $error);
 
 1;