X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=scripts%2Fparsealliances.pl;h=4a41cd06da563c8bd0ba097939a43eea53539ac4;hp=36a80306cab15da43a4479b3bbd0a562d48fdb03;hb=36a13cae169413fc04fbf704d94a2ad797336e6e;hpb=f56f84ac1689330801afc9e25fcd998ef8b39f33

diff --git a/scripts/parsealliances.pl b/scripts/parsealliances.pl
index 36a8030..4a41cd0 100755
--- a/scripts/parsealliances.pl
+++ b/scripts/parsealliances.pl
@@ -22,11 +22,10 @@ q{
 
 use strict;
 use warnings;
+use local::lib;
 use DBI;
 use DBD::Pg qw(:pg_types);
 
-use LWP::Simple;
-
 use FindBin;
 use lib "$FindBin::Bin/../lib";
 
@@ -81,6 +80,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;