X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FRoot.pm;h=f1b020a0779eada5a0f203add13251ec975c5bf4;hb=25cfbba80f992bd251751782e30cb8c3d57b53d3;hp=bc422a6fcd6619b331bb206a45e9951624f6efa8;hpb=30944296c478d5d6cec82d8e7c7a62b60deb4fb4;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/Root.pm b/lib/NDWeb/Controller/Root.pm index bc422a6..f1b020a 100644 --- a/lib/NDWeb/Controller/Root.pm +++ b/lib/NDWeb/Controller/Root.pm @@ -95,18 +95,25 @@ sub smsconfirm : Local { my ($self, $c) = @_; my $dbh = $c->model; + $c->stash(template => 'default.tt2'); + + return unless $c->req->param('apiMsgId'); + my $sms = $dbh->prepare(q{ UPDATE sms SET status = $2, cost = $3 ,time = TIMESTAMP WITH TIME ZONE 'epoch' + $4 * INTERVAL '1 second' WHERE msgid = $1 }); - $sms->execute($c->req->param('apiMsgId') - ,$clickatellstatus{$c->req->param('status')} - ,$c->req->param('charge') - ,$c->req->param('timestamp')); + my $apiMsgId = $c->req->param('apiMsgId'); + my $status = $c->req->param('status'); + my $charge = $c->req->param('charge'); + my $timestamp = $c->req->param('timestamp'); + $sms->execute($apiMsgId + ,$clickatellstatus{$status} + ,$charge + ,$timestamp); - $c->stash(template => 'default.tt2'); } @@ -126,8 +133,8 @@ sub listTargets : Private { my $dbh = $c ->model; - my $query = $dbh->prepare(q{SELECT t.id, r.id AS raid, r.tick+c.wave-1 AS landingtick, - (released_coords AND old_claim(timestamp)) AS released_coords, coords(x,y,z),c.launched,c.wave,c.joinable + my $query = $dbh->prepare(q{SELECT t.id, r.id AS raid, r.tick+c.wave-1 AS landingtick, + released_coords, coords(x,y,z),c.launched,c.wave,c.joinable FROM raid_claims c JOIN raid_targets t ON c.target = t.id JOIN raids r ON t.raid = r.id @@ -217,6 +224,10 @@ sub end : ActionClass('RenderView') { $c->stash->{template} = 'access_denied.tt2'; $c->res->status(403); $c->clear_errors; + }elsif ($c->error->[0] =~ m/No logged in user, and none supplied as argument/){ + $c->stash->{template} = 'access_denied.tt2'; + $c->res->status(403); + $c->clear_errors; } } @@ -240,10 +251,7 @@ AND mission = 'Full fleet' AND name IN ('Main','Advanced Unit'); newposts => $newposts, unreadposts => $unread }); - $c->stash->{user}->{attacker} = $c->check_user_roles(qw/attack_menu/) - && (!$c->check_user_roles(qw/member_menu/) - || ($c->user->planet && (($c->stash->{TICK} - $fleetupdate < 24) - || $c->check_user_roles(qw/no_fleet_update/)))), + $c->stash->{user}->{attacker} = $c->check_user_roles(qw/attack_menu/); $c->forward('listTargets'); } my $birthdays = $dbh->prepare(q{SELECT username