1 #**************************************************************************
2 # Copyright (C) 2006 by Michael Andreen <harvATruinDOTnu> *
4 # This program is free software; you can redistribute it and/or modify *
5 # it under the terms of the GNU General Public License as published by *
6 # the Free Software Foundation; either version 2 of the License, or *
7 # (at your option) any later version. *
9 # This program is distributed in the hope that it will be useful, *
10 # but WITHOUT ANY WARRANTY; without even the implied warranty of *
11 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
12 # GNU General Public License for more details. *
14 # You should have received a copy of the GNU General Public License *
15 # along with this program; if not, write to the *
16 # Free Software Foundation, Inc., *
17 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. *
18 #**************************************************************************/
21 use warnings FATAL => 'all';
27 $ND::TEMPLATE->param(TITLE => 'Create/Edit Raids');
29 die "You don't have access" unless isBC();
31 my @alliances = alliances();
32 $BODY->param(Alliances => \@alliances);
35 if (param('raid') =~ /^(\d+)$/){
36 my $query = $DBH->prepare(q{SELECT id,tick,waves,message,released_coords,open FROM raids WHERE id = ?});
37 $raid = $DBH->selectrow_hashref($query,undef,$1);
39 if (defined param('cmd') && param('cmd') eq 'submit'){
40 my $query = $DBH->prepare(q{INSERT INTO raids (tick,waves,message) VALUES(?,?,'')});
41 if ($query->execute(param('tick'),param('waves'))){
42 $raid = $DBH->last_insert_id(undef,undef,undef,undef,"raids_id_seq");
43 my $query = $DBH->prepare(q{SELECT id,tick,waves,message,released_coords,open FROM raids WHERE id = ?});
44 $raid = $DBH->selectrow_hashref($query,undef,$raid);
46 $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
50 if ($raid && defined param('cmd')){
51 if (param('cmd') eq 'remove'){
52 $DBH->do(q{UPDATE raids SET open = FALSE, removed = TRUE WHERE id = ?},undef,$raid->{id});
53 }elsif (param('cmd') eq 'Open'){
54 if($DBH->do(q{UPDATE raids SET open = TRUE, removed = FALSE WHERE id = ?},undef,$raid->{id})){
58 }elsif (param('cmd') eq 'Close'){
59 if ($DBH->do(q{UPDATE raids SET open = FALSE WHERE id = ?},undef,$raid->{id})){
62 }elsif (param('cmd') eq 'showcoords'){
63 if($DBH->do(q{UPDATE raids SET released_coords = TRUE WHERE id = ?},undef,$raid->{id})){
64 $raid->{released_coords} = 1;
66 }elsif (param('cmd') eq 'hidecoords'){
67 if($DBH->do(q{UPDATE raids SET released_coords = FALSE WHERE id = ?},undef,$raid->{id})){
68 $raid->{released_coords} = 0;
70 }elsif (param('cmd') eq 'comment'){
71 $DBH->do(q{UPDATE raid_targets SET comment = ? WHERE id = ?}
72 ,undef,escapeHTML(param('comment')),param('target'))
73 or $error .= p($DBH->errstr);
75 }elsif (param('cmd') eq 'change'){
77 my $message = escapeHTML(param('message'));
78 $raid->{message} = $message;
79 $raid->{waves} = param('waves');
80 $raid->{tick} = param('tick');
81 unless ($DBH->do(qq{UPDATE raids SET message = ?, tick = ?, waves = ? WHERE id = ?}
82 ,undef,$message,param('tick'),param('waves'),$raid->{id})){
83 $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
86 if (param('sizelimit') =~ /^(\d+)$/){
87 $sizelimit = "AND p.size >= $1";
88 unless ($DBH->do(qq{DELETE FROM raid_targets WHERE id IN (SELECT t.id FROM current_planet_stats p
89 JOIN raid_targets t ON p.id = t.planet WHERE p.size < ? AND t.raid = ?)},undef,$1,$raid->{id})){
90 $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
93 my $targets = param('targets');
94 my $addtarget = $DBH->prepare(qq{INSERT INTO raid_targets(raid,planet) (
95 SELECT ?, id FROM current_planet_stats p WHERE x = ? AND y = ? AND COALESCE(z = ?,TRUE) $sizelimit)});
96 while ($targets =~ m/(\d+):(\d+)(?::(\d+))?/g){
97 unless ($addtarget->execute($raid->{id},$1,$2,$3)){
98 $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
101 if (param('alliance') =~ /^(\d+)$/ && $1 != 1){
102 $LOG->execute($ND::UID,"BC adding alliance $1 to raid");
103 my $addtarget = $DBH->prepare(qq{INSERT INTO raid_targets(raid,planet) (
104 SELECT ?,id FROM current_planet_stats p WHERE alliance_id = ? $sizelimit)});
105 unless ($addtarget->execute($raid->{id},$1)){
106 $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
109 my $groups = $DBH->prepare('SELECT gid,groupname FROM groups WHERE attack');
110 my $delgroup = $DBH->prepare(q{DELETE FROM raid_access WHERE raid = ? AND gid = ?});
111 my $addgroup = $DBH->prepare(q{INSERT INTO raid_access (raid,gid) VALUES(?,?)});
113 while (my $group = $groups->fetchrow_hashref){
115 if (param($group->{gid}) eq 'remove'){
117 }elsif(param($group->{gid}) eq 'add'){
121 unless ($query->execute($raid->{id},$group->{gid})){
122 $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
126 unless ($DBH->commit){
127 $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
131 if ($raid && param('removeTarget')){
133 unless($DBH->do(q{DELETE FROM raid_targets WHERE raid = ? AND id = ?}
134 ,undef,$raid->{id},param('removeTarget'))){
135 $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
139 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});
140 $groups->execute($raid ? $raid->{id} : undef);
144 while (my $group = $groups->fetchrow_hashref){
146 push @remgroups,{Id => $group->{gid}, Name => $group->{groupname}};
148 push @addgroups,{Id => $group->{gid}, Name => $group->{groupname}};
151 $BODY->param(RemoveGroups => \@remgroups);
152 $BODY->param(AddGroups => \@addgroups);
157 $BODY->param(Raid => $raid->{id});
159 $BODY->param(Open => 'Close');
161 $BODY->param(Open => 'Open');
163 if($raid->{released_coords}){
164 $BODY->param(ShowCoords => 'hidecoords');
165 $BODY->param(ShowCoordsName => 'Hide');
167 $BODY->param(ShowCoords => 'showcoords');
168 $BODY->param(ShowCoordsName => 'Show');
170 $BODY->param(Waves => $raid->{waves});
171 $BODY->param(LandingTick => $raid->{tick});
172 $BODY->param(Message => $raid->{message});
174 my $order = "p.x,p.y,p.z";
175 if (param('order') && param('order') =~ /^(score|size|value|xp|race)$/){
179 my $targetquery = $DBH->prepare(qq{SELECT r.id,coords(x,y,z),raid,comment,size,score,value,race,planet_status AS planetstatus,relationship,comment
180 FROM current_planet_stats p JOIN raid_targets r ON p.id = r.planet
183 $targetquery->execute($raid->{id}) or $error .= $DBH->errstr;
185 while (my $target = $targetquery->fetchrow_hashref){
186 push @targets,$target;
188 $BODY->param(Targets => \@targets);
190 $BODY->param(Waves => 3);
191 $BODY->param(LandingTick => $ND::TICK+12);
193 $BODY->param(Error => $error);