minor updates

[ndwebbie.git] / scripts / fetchdumps.pl

diff --git a/scripts/fetchdumps.pl b/scripts/fetchdumps.pl
index b8be1c36ca111561d5054337d18ecba75fc84b9b..a01b58e3ca3e71893cd08ce8bd3b1268136faf16 100755 (executable)
--- a/scripts/fetchdumps.pl
+++ b/scripts/fetchdumps.pl
@@ -42,7 +42,7 @@ for my $type ("planet","alliance","galaxy"){
        $select->execute($type,$head[2]);
        unless ($select->fetchrow){
                my $file = get("http://game.planetarion.com/botfiles/${type}_listing.txt");
-               if ($file =~ /Tick: (\d+)/){
+               if (defined $file && $file =~ /Tick: (\d+)/){
                        $updated = $1;
                        $insert->execute($1,$type,$head[2],$file);
                }
@@ -51,9 +51,12 @@ for my $type ("planet","alliance","galaxy"){
 }
 
 if ($updated){
-       `/var/www/ndawn/scripts/parsedumps.pl $updated`;
+       `/var/www/ndawn/scripts/parsealliances.pl $updated`;
+       `/var/www/ndawn/scripts/parseplanets.pl $updated`;
+       `/var/www/ndawn/scripts/parsegalaxies.pl $updated`;
        `/var/www/ndawn/scripts/ndrank.pl`;
-       $dbh->do("UPDATE misc SET value = ? WHERE id = 'TICK'", undef, $updated);
+       $dbh->do(q{UPDATE misc SET value = ? WHERE id = 'TICK'}, undef, $updated);
+       $dbh->do(q{VACUUM ANALYZE});
 }