use DBI;
use DBD::Pg qw(:pg_types);
-use LWP::Simple;
+use FindBin;
+use lib "$FindBin::Bin/../lib";
-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 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;