$extra_columns FROM current_planet_stats_full ORDER BY $order LIMIT 100 OFFSET ?});
$query->execute($offset) or $error .= p($DBH->errstr);
my @planets;
$extra_columns FROM current_planet_stats_full ORDER BY $order LIMIT 100 OFFSET ?});
$query->execute($offset) or $error .= p($DBH->errstr);
my @planets;
while (my $planet = $query->fetchrow_hashref){
for my $type (qw/size score value xp/){
#$planet->{$type} = prettyValue($planet->{$type});
while (my $planet = $query->fetchrow_hashref){
for my $type (qw/size score value xp/){
#$planet->{$type} = prettyValue($planet->{$type});
$planet->{$type} =~ s/(^[-+]?\d+?(?=(?>(?:\d{3})+)(?!\d))|\G\d{3}(?=\d))/$1,/g; #Add comma for ever 3 digits, i.e. 1000 => 1,000
}
}
$planet->{$type} =~ s/(^[-+]?\d+?(?=(?>(?:\d{3})+)(?!\d))|\G\d{3}(?=\d))/$1,/g; #Add comma for ever 3 digits, i.e. 1000 => 1,000
}
}