X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=scripts%2Fndrank.pl;h=eff1d380cc07a6c9d82ac6e69a92b07c1de561ff;hb=6772ec335287679e8837ebe85b8b1218cc2be8ff;hp=cc7c12767e190b8681de3b72f44cdc663703998d;hpb=c643b311c8f134a59625192b900aa28b3f12d4f1;p=ndwebbie.git

diff --git a/scripts/ndrank.pl b/scripts/ndrank.pl
index cc7c127..eff1d38 100755
--- a/scripts/ndrank.pl
+++ b/scripts/ndrank.pl
@@ -27,18 +27,15 @@ use DBD::Pg qw(:pg_types);
 
 use LWP::Simple;
 
-our $dbh;
-for my $file ("/home/whale/db.pl")
-{
-	unless (my $return = do $file){
-		warn "couldn't parse $file: $@" if $@;
-		warn "couldn't do $file: $!"    unless defined $return;
-		warn "couldn't run $file"       unless $return;
-	}
-}
+use FindBin;
+use lib "$FindBin::Bin/../lib";
+
+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;