});
$query->execute($x,$y);
- $c->stash(g => $query->fetchrow_hashref );
+ my $g = $query->fetchrow_hashref;
+ $c->detach('/default') unless $g;
+ $c->stash(g => $g);
+
my $extra_columns = '';
if ($c->check_user_roles(qw/stats_intel/)){
my $p = $dbh->selectrow_hashref(q{SELECT id,x,y,z FROM current_planet_stats
WHERE id = $1},undef,$id);
+ $c->detach('/default') unless $p;
+
$c->forward('galaxy',[$p->{x},$p->{y},$p->{z}]);
$c->stash(p => $p);
my $dbh = $c->model;
local $_ = $find || $c->req->param('coords');
+ $c->stash(searchterm => $_);
if (/(\d+)(?: |:)(\d+)(?: |:)(\d+)(?:(?: |:)(\d+))?/){
my $planet = $dbh->selectrow_array(q{SELECT planetid($1,$2,$3,$4)}
$c->res->redirect($c->uri_for('planet',$planet));
}elsif (/(\d+)(?: |:)(\d+)/){
$c->res->redirect($c->uri_for('galaxy',$1,$2));
+ }elsif($c->check_user_roles(qw/stats_find_nick/)) {
+ my $query = $dbh->prepare(q{SELECT id,coords(x,y,z),nick
+ FROM current_planet_stats p
+ WHERE nick ilike $1
+ });
+ $query->execute($_);
+ my $planets = $query->fetchall_arrayref({});
+ if (@{$planets} == 1){
+ $c->res->redirect($c->uri_for('planet',$planets->[0]->{id}));
+ }else{
+ $c->stash(planets => $planets);
+ }
}
-
}