Remove the old stats automatically when parsing

[ndwebbie.git] / scripts / parsealliances.pl

diff --git a/scripts/parsealliances.pl b/scripts/parsealliances.pl
index 02e9a495987a0abb768072fbc3a12c3689fd22e1..f42414ba53f3d755a04188fb8ebb2c9102c17592 100755 (executable)
--- a/scripts/parsealliances.pl
+++ b/scripts/parsealliances.pl
@@ -35,8 +35,6 @@ use ND::DB;
 
 our $dbh = ND::DB::DB();
 
-$ND::DBH = $dbh;
-
 my $tick = $ARGV[0];
 my $hour;
 $dbh->begin_work;
@@ -83,6 +81,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;