Change database structure for planets and alliances + PG 8.4 changes

[ndwebbie.git] / scripts / ndrank.pl

diff --git a/scripts/ndrank.pl b/scripts/ndrank.pl
index acb1405d3a282ede1bcd1adf73e1746b1dcbdebf..eff1d380cc07a6c9d82ac6e69a92b07c1de561ff 100755 (executable)
--- a/scripts/ndrank.pl
+++ b/scripts/ndrank.pl
@@ -35,7 +35,7 @@ use ND::DB;
 our $dbh = ND::DB::DB();
 
 $dbh->begin_work;
-my $st = $dbh->prepare(q{SELECT uid FROM current_planet_stats p JOIN users u ON p.id = u.planet WHERE alliance_id = 1 ORDER BY score DESC});
+my $st = $dbh->prepare(q{SELECT uid FROM current_planet_stats p JOIN users u USING (pid) WHERE alliance = 'NewDawn' ORDER BY score DESC});
 my $update = $dbh->prepare(q{UPDATE users SET rank = ? WHERE uid = ?});
 $st->execute;
 my $rank = 1;