X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FRankings.pm;fp=lib%2FNDWeb%2FController%2FRankings.pm;h=45f2a79959c59191a7b00201029a0b218aad7a0c;hb=b6d8351387cf06b88e362a458aad1e0982e575dd;hp=b34792b74b115876d26d79c98d36eef4bb92fd46;hpb=6c73f6ddd47b3274ee7fa784f74823591d19dbc6;p=ndwebbie.git

diff --git a/lib/NDWeb/Controller/Rankings.pm b/lib/NDWeb/Controller/Rankings.pm
index b34792b..45f2a79 100644
--- a/lib/NDWeb/Controller/Rankings.pm
+++ b/lib/NDWeb/Controller/Rankings.pm
@@ -56,7 +56,7 @@ sub planets : Local {
 		$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,
@@ -143,7 +143,7 @@ sub alliances : Local {
 	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,