]> ruin.nu Git - ndwebbie.git/blobdiff - scripts/parsealliances.pl
Use local::lib properly
[ndwebbie.git] / scripts / parsealliances.pl
index 36a80306cab15da43a4479b3bbd0a562d48fdb03..551dcad1866f1d7c104c4c2583b71c4df03c213c 100755 (executable)
@@ -22,6 +22,7 @@ q{
 
 use strict;
 use warnings;
+use local::lib;
 use DBI;
 use DBD::Pg qw(:pg_types);
 
@@ -81,6 +82,8 @@ my $findalliance = $dbh->prepare(q{SELECT tick,aid,members,
        members_gain,members_gain_day
 FROM alliance_stats WHERE aid = $1 AND tick < $2 ORDER BY tick DESC LIMIT 1}) or die $dbh->errstr;
 
+$dbh->do(q{DELETE FROM alliance_stats WHERE tick = $1},undef,$tick);
+
 for my $alliance (@alliances) {
 
        $findalliance->execute($alliance->[1],$tick) or die $dbh->errstr;