my $error = '';
$offset = 0 unless $offset;
+ $c->detach('/default') if $offset < 0;
$c->stash(offset => $offset);
- $c->stash( comma => \&comma_value);
-
if (defined $order && $order =~ /^(scorerank|sizerank|valuerank|xprank|hit_us)$/){
$order = $1;
}else {
$extra_columns = ",planet_status,hit_us, alliance,relationship,nick";
}
- my $query = $dbh->prepare(qq{SELECT id,x,y,z,ruler,planet,race,
+ my $query = $dbh->prepare(qq{SELECT pid AS id,x,y,z,ruler,planet,race,
size, size_gain, size_gain_day,
score,score_gain,score_gain_day,
value,value_gain,value_gain_day,
while (my $planet = $query->fetchrow_hashref){
push @planets,$planet;
}
+ $c->detach('/default') unless @planets;
$c->stash(planets => \@planets);
}
my $error = '';
$offset = 0 unless $offset;
+ $c->detach('/default') if $offset < 0;
$c->stash(offset => $offset);
- $c->stash( comma => \&comma_value);
-
if (defined $order && $order =~ /^(scorerank|sizerank|valuerank|xprank|planets)$/){
$order = $1;
}else{
while (my $galaxy = $query->fetchrow_hashref){
push @galaxies,$galaxy;
}
+ $c->detach('/default') unless @galaxies;
$c->stash(galaxies => \@galaxies);
}
my $error = '';
$offset = 0 unless $offset;
+ $c->detach('/default') if $offset < 0;
$c->stash(offset => $offset);
- $c->stash( comma => \&comma_value);
-
if (defined $order && $order =~ /^(scorerank|sizerank|valuerank|xprank|avgsize|avgscore|members)$/){
$order = $1;
}else{
if ($order =~ /rank$/){
$browse = qq{WHERE $order > ? ORDER BY $order ASC LIMIT 100};
}
- my $query = $dbh->prepare(qq{SELECT a.name,a.id,
+ my $query = $dbh->prepare(qq{SELECT alliance AS name,aid AS id,
size, size_gain, size_gain_day,
score,score_gain,score_gain_day,
avgsize,avgsize_gain,avgsize_gain_day,
while (my $alliance = $query->fetchrow_hashref){
push @alliances,$alliance;
}
+ $c->detach('/default') unless @alliances;
$c->stash(alliances => \@alliances);
}