$extra_columns = ",planet_status,hit_us, alliance,relationship,nick";
}
$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,
size, size_gain, size_gain_day,
score,score_gain,score_gain_day,
value,value_gain,value_gain_day,
size, size_gain, size_gain_day,
score,score_gain,score_gain_day,
avgsize,avgsize_gain,avgsize_gain_day,
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;
}
while (my $alliance = $query->fetchrow_hashref){
push @alliances,$alliance;
}