$order .= 'p.x,p.y,p.z';
}
- my $targetquery = $dbh->prepare(qq{SELECT r.id,coords(x,y,z),comment,size,score,value,race,planet_status AS planetstatus,relationship,comment,r.planet, s.scans
+ my $targetquery = $dbh->prepare(qq{SELECT r.id,coords(x,y,z),comment,size
+ ,score,value,race,planet_status,relationship,comment,r.planet, s.scans
FROM raid_targets r
JOIN current_planet_stats p ON p.id = r.planet
LEFT OUTER JOIN ( SELECT planet, array_accum(s::text) AS scans
$c->forward('log',[$raid, "BC opened raid"]);
$c->model->commit;
- $c->res->redirect($c->req->referer);
+ $c->forward('/redirect');
}
sub close : Local {
$c->forward('log',[$raid, "BC closed raid"]);
$c->model->commit;
- $c->res->redirect($c->req->referer);
+ $c->forward('/redirect');
}
sub remove : Local {
$c->forward('log',[$raid, "BC removed raid"]);
$c->model->commit;
- $c->res->redirect($c->req->referer);
+ $c->forward('/redirect');
}
sub showcoords : Local {
$c->forward('log',[$raid, "BC released coords"]);
$c->model->commit;
- $c->res->redirect($c->req->referer);
+ $c->forward('/redirect');
}
sub hidecoords : Local {
$c->forward('log',[$raid, "BC hid coords"]);
$c->model->commit;
- $c->res->redirect($c->req->referer);
+ $c->forward('/redirect');
}
sub create : Local {