X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=scripts%2Fparsegalaxies.pl;h=f9b6af758c2dbef6bbb56b9617503c6f4c9439a8;hp=0ba0f0cb160df372c08ed88ad182cc6ecb412e15;hb=6a03c42459329f8c3f6ddc96cf91e508a6d71c90;hpb=e2d21c8468811a7cdb1266f6972074e8547eb791 diff --git a/scripts/parsegalaxies.pl b/scripts/parsegalaxies.pl index 0ba0f0c..f9b6af7 100755 --- a/scripts/parsegalaxies.pl +++ b/scripts/parsegalaxies.pl @@ -77,6 +77,7 @@ my $insert = $dbh->prepare(q{INSERT INTO galaxies(tick, x, y, sizerank_gain_day, scorerank_gain_day, valuerank_gain_day, xprank_gain_day, planets,planets_gain,planets_gain_day ) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}); +$dbh->do(q{DELETE FROM galaxies WHERE tick = $1},undef,$tick); my $countplanets = $dbh->prepare(q{SELECT count(*) from planet_stats where x = $1 and y = $2 and tick = $3}); for my $galaxy (@galaxies) {