X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=scripts%2Ffetchdumps.pl;h=2579f38532688463e9b3a7a4ad07f0c6da32f7eb;hb=5b6c3c7d0003d636c1c3da6d25734e4aad5736a5;hp=b8be1c36ca111561d5054337d18ecba75fc84b9b;hpb=8ce23c2d82afd4382c05a8bdc81e850a1fb16346;p=ndwebbie.git diff --git a/scripts/fetchdumps.pl b/scripts/fetchdumps.pl index b8be1c3..2579f38 100755 --- a/scripts/fetchdumps.pl +++ b/scripts/fetchdumps.pl @@ -27,7 +27,7 @@ use DBD::Pg qw(:pg_types); use LWP::Simple; -use lib qw{/var/www/ndawn/}; +use lib qw{/var/www/ndawn/lib/}; use ND::DB; our $dbh = ND::DB::DB(); @@ -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,13 @@ 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); + local $dbh->{Warn} = 0; + $dbh->do(q{VACUUM ANALYZE}); }