X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FWeb%2FPages%2FPlanetRankings.pm;h=d40fa3356844ede716e74fa596c9500b694be68e;hb=58280165c887482295b1bed42bd8436449cfcf4a;hp=813c9f64f1fe1097c894ce22a1aa3f8c78eeb163;hpb=d5ac9e6c6116e89a74b9cf48eefbcd549a75397d;p=ndwebbie.git diff --git a/ND/Web/Pages/PlanetRankings.pm b/ND/Web/Pages/PlanetRankings.pm index 813c9f6..d40fa33 100644 --- a/ND/Web/Pages/PlanetRankings.pm +++ b/ND/Web/Pages/PlanetRankings.pm @@ -66,7 +66,7 @@ sub render_body { if ($self->isHC){ $extra_columns = ",planet_status,hit_us, alliance,relationship,nick"; } - my $query = $DBH->prepare(qq{SELECT coords(x,y,z),((ruler || ' OF ') || planet) as planet,race, + my $query = $DBH->prepare(qq{SELECT x,y,z,((ruler || ' OF ') || planet) as planet,race, size, size_gain, size_gain_day, score,score_gain,score_gain_day, value,value_gain,value_gain_day,