X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=scripts%2Fparsealliances.pl;h=f42414ba53f3d755a04188fb8ebb2c9102c17592;hb=d6b15c14f164e7150ffcaed86e8aa79795b2d89a;hp=02e9a495987a0abb768072fbc3a12c3689fd22e1;hpb=b6d8351387cf06b88e362a458aad1e0982e575dd;p=ndwebbie.git diff --git a/scripts/parsealliances.pl b/scripts/parsealliances.pl index 02e9a49..f42414b 100755 --- 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;