ND/Web/Pages/EditRaid.pm

   1 #**************************************************************************
   2 #   Copyright (C) 2006 by Michael Andreen <harvATruinDOTnu>               *
   3 #                                                                         *
   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.                                   *
   8 #                                                                         *
   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.                          *
  13 #                                                                         *
  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 #**************************************************************************/
  19 package ND::Web::Pages::EditRaid;
  20 use strict;
  21 use warnings FATAL => 'all';
  22 use ND::Include;
  23 use CGI qw/:standard/;
  24 use ND::Web::Include;
  25
  26 $ND::PAGES{editRaid} = {parse => \&parse, process => \&process, render=> \&render};
  27
  28 sub parse {
  29         my ($uri) = @_;
  30         #if ($uri =~ m{^/.*/(\w+)$}){
  31         #       param('list',$1);
  32         #}
  33 }
  34
  35 sub process {
  36
  37 }
  38
  39 sub render {
  40         my ($DBH,$BODY) = @_;
  41         my $error;
  42
  43         $ND::TEMPLATE->param(TITLE => 'Create/Edit Raids');
  44
  45         return $ND::NOACCESS unless isBC();
  46
  47         my @alliances = alliances();
  48         $BODY->param(Alliances => \@alliances);
  49
  50         my $raid;
  51         if (defined param 'raid' and param('raid') =~ /^(\d+)$/){
  52                 my $query = $DBH->prepare(q{SELECT id,tick,waves,message,released_coords,open FROM raids WHERE id = ?});
  53                 $raid = $DBH->selectrow_hashref($query,undef,$1);
  54         }
  55         if (defined param('cmd') && param('cmd') eq 'submit'){
  56                 my $query = $DBH->prepare(q{INSERT INTO raids (tick,waves,message) VALUES(?,?,'')});
  57                 if ($query->execute(param('tick'),param('waves'))){
  58                         $raid = $DBH->last_insert_id(undef,undef,undef,undef,"raids_id_seq");
  59                         my $query = $DBH->prepare(q{SELECT id,tick,waves,message,released_coords,open FROM raids WHERE id = ?});
  60                         $raid = $DBH->selectrow_hashref($query,undef,$raid);
  61                 }else{
  62                         $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
  63                 }
  64         }
  65
  66         if ($raid && defined param('cmd')){
  67                 if (param('cmd') eq 'remove'){
  68                         $DBH->do(q{UPDATE raids SET open = FALSE, removed = TRUE WHERE id = ?},undef,$raid->{id});
  69                 }elsif (param('cmd') eq 'Open'){
  70                         if($DBH->do(q{UPDATE raids SET open = TRUE, removed = FALSE WHERE id = ?},undef,$raid->{id})){
  71                                 $raid->{open} = 1;
  72                                 $raid->{removed} = 0;
  73                         }
  74                 }elsif (param('cmd') eq 'Close'){
  75                         if ($DBH->do(q{UPDATE raids SET open = FALSE WHERE id = ?},undef,$raid->{id})){
  76                                 $raid->{open} = 0;
  77                         }
  78                 }elsif (param('cmd') eq 'showcoords'){
  79                         if($DBH->do(q{UPDATE raids SET released_coords = TRUE WHERE id = ?},undef,$raid->{id})){
  80                                 $raid->{released_coords} = 1;
  81                         }
  82                 }elsif (param('cmd') eq 'hidecoords'){
  83                         if($DBH->do(q{UPDATE raids SET released_coords = FALSE WHERE id = ?},undef,$raid->{id})){
  84                                 $raid->{released_coords} = 0;
  85                         }
  86                 }elsif (param('cmd') eq 'comment'){
  87                         $DBH->do(q{UPDATE raid_targets SET comment = ? WHERE id = ?}
  88                                 ,undef,escapeHTML(param('comment')),param('target'))
  89                                 or $error .= p($DBH->errstr);
  90
  91                 }elsif (param('cmd') eq 'change'){
  92                         $DBH->begin_work;
  93                         my $message = escapeHTML(param('message'));
  94                         $raid->{message} = $message;
  95                         $raid->{waves} = param('waves');
  96                         $raid->{tick} = param('tick');
  97                         unless ($DBH->do(qq{UPDATE raids SET message = ?, tick = ?, waves = ? WHERE id = ?}
  98                                         ,undef,$message,param('tick'),param('waves'),$raid->{id})){
  99                                 $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
 100                         }
 101                         my $sizelimit = '';
 102                         if (param('sizelimit') =~ /^(\d+)$/){
 103                                 $sizelimit = "AND p.size >= $1";
 104                                 unless ($DBH->do(qq{DELETE FROM raid_targets WHERE id IN (SELECT t.id FROM current_planet_stats p
 105                                                 JOIN raid_targets t ON p.id = t.planet WHERE p.size < ? AND t.raid = ?)},undef,$1,$raid->{id})){
 106                                         $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
 107                                 }
 108                         }
 109                         my $targets = param('targets');
 110                         my $addtarget = $DBH->prepare(qq{INSERT INTO raid_targets(raid,planet) (
 111                                 SELECT ?, id FROM current_planet_stats p WHERE x = ? AND y = ? AND COALESCE(z = ?,TRUE) $sizelimit)});
 112                         while ($targets =~ m/(\d+):(\d+)(?::(\d+))?/g){
 113                                 unless ($addtarget->execute($raid->{id},$1,$2,$3)){
 114                                         $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
 115                                 }
 116                         }
 117                         if (param('alliance') =~ /^(\d+)$/ && $1 != 1){
 118                                 log_message $ND::UID,"BC adding alliance $1 to raid";
 119                                 my $addtarget = $DBH->prepare(qq{INSERT INTO raid_targets(raid,planet) (
 120                                         SELECT ?,id FROM current_planet_stats p WHERE alliance_id = ? $sizelimit)});
 121                                 unless ($addtarget->execute($raid->{id},$1)){
 122                                         $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
 123                                 }
 124                         }
 125                         my $groups = $DBH->prepare('SELECT gid,groupname FROM groups WHERE attack');
 126                         my $delgroup = $DBH->prepare(q{DELETE FROM raid_access WHERE raid = ? AND gid = ?});
 127                         my $addgroup = $DBH->prepare(q{INSERT INTO raid_access (raid,gid) VALUES(?,?)});
 128                         $groups->execute();
 129                         while (my $group = $groups->fetchrow_hashref){
 130                                 my $query;
 131                                 next unless defined param $group->{gid};
 132                                 if (param($group->{gid}) eq 'remove'){
 133                                         $query = $delgroup;
 134                                 }elsif(param($group->{gid}) eq 'add'){
 135                                         $query = $addgroup;
 136                                 }
 137                                 if ($query){
 138                                         unless ($query->execute($raid->{id},$group->{gid})){
 139                                                 $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
 140                                         }
 141                                 }
 142                         }
 143                         unless ($DBH->commit){
 144                                 $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
 145                         }
 146                 }
 147         }
 148         if ($raid && param('removeTarget')){
 149                 $error .= "test";
 150                 unless($DBH->do(q{DELETE FROM raid_targets WHERE raid = ? AND id = ?}
 151                                 ,undef,$raid->{id},param('removeTarget'))){
 152                         $error .= "<p> Something went wrong: ".$DBH->errstr."</p>";
 153                 }
 154         }
 155
 156         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});
 157         $groups->execute($raid ? $raid->{id} : undef);
 158
 159         my @addgroups;
 160         my @remgroups;
 161         while (my $group = $groups->fetchrow_hashref){
 162                 if ($group->{raid}){
 163                         push @remgroups,{Id => $group->{gid}, Name => $group->{groupname}};
 164                 }else{
 165                         push @addgroups,{Id => $group->{gid}, Name => $group->{groupname}};
 166                 }
 167         }
 168         $BODY->param(RemoveGroups => \@remgroups);
 169         $BODY->param(AddGroups => \@addgroups);
 170
 171
 172         if ($raid){
 173
 174                 $BODY->param(Raid => $raid->{id});
 175                 if($raid->{open}){
 176                         $BODY->param(Open => 'Close');
 177                 }else{
 178                         $BODY->param(Open => 'Open');
 179                 }
 180                 if($raid->{released_coords}){
 181                         $BODY->param(ShowCoords => 'hidecoords');
 182                         $BODY->param(ShowCoordsName => 'Hide');
 183                 }else{
 184                         $BODY->param(ShowCoords => 'showcoords');
 185                         $BODY->param(ShowCoordsName => 'Show');
 186                 }
 187                 $BODY->param(Waves => $raid->{waves});
 188                 $BODY->param(LandingTick => $raid->{tick});
 189                 $BODY->param(Message => $raid->{message});
 190
 191                 my $order = "p.x,p.y,p.z";
 192                 if (param('order') && param('order') =~ /^(score|size|value|xp|race)$/){
 193                         $order = "$1 DESC";
 194                 }
 195
 196                 my $targetquery = $DBH->prepare(qq{SELECT r.id,coords(x,y,z),raid,comment,size,score,value,race,planet_status AS planetstatus,relationship,comment
 197                         FROM current_planet_stats p JOIN raid_targets r ON p.id = r.planet
 198                         WHERE r.raid = ?
 199                         ORDER BY $order});
 200                 $targetquery->execute($raid->{id}) or $error .= $DBH->errstr;
 201                 my @targets;
 202                 while (my $target = $targetquery->fetchrow_hashref){
 203                         push @targets,$target;
 204                 }
 205                 $BODY->param(Targets => \@targets);
 206         }else{
 207                 $BODY->param(Waves => 3);
 208                 $BODY->param(LandingTick => $ND::TICK+12);
 209         }
 210         $BODY->param(Error => $error);
 211         return $BODY;
 212 }
 213
 214 1;