X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=scripts%2Ffetchdumps.pl;h=4a7ae1b6b774dd5b6226614b812a63dc0cad5bbb;hb=HEAD;hp=65942b76951038003058f3f7f8e9bb892259b374;hpb=07a56574757b4eca5c4711f819359daab81d2f11;p=ndwebbie.git diff --git a/scripts/fetchdumps.pl b/scripts/fetchdumps.pl index 65942b7..4a7ae1b 100755 --- a/scripts/fetchdumps.pl +++ b/scripts/fetchdumps.pl @@ -22,18 +22,20 @@ q{ use strict; use warnings; +use local::lib; use DBI; use DBD::Pg qw(:pg_types); -use LWP::Simple; +use LWP::Simple qw/head get $ua/; +$ua->agent("Stupid user agent check is stupid"); + +use FindBin; +use lib "$FindBin::Bin/../lib"; -use lib qw{/var/www/ndawn/}; use ND::DB; our $dbh = ND::DB::DB(); -$dbh->do("SET CLIENT_ENCODING TO 'LATIN1';"); - my $insert = $dbh->prepare("INSERT INTO dumps(tick,type,modified,dump) VALUES(?,?,?,?)"); my $select = $dbh->prepare("SELECT 1 FROM dumps WHERE type = ? AND modified = ?"); my $updated = 0; @@ -50,11 +52,12 @@ for my $type ("planet","alliance","galaxy"){ $select->finish; } -if ($updated > 36){ - `/var/www/ndawn/scripts/parsedumps.pl $updated`; - `/var/www/ndawn/scripts/ndrank.pl`; +if ($updated){ + system("$FindBin::Bin/parsetick.sh", $updated); + system("$FindBin::Bin/ndrank.pl"); $dbh->do(q{UPDATE misc SET value = ? WHERE id = 'TICK'}, undef, $updated); - $dbh->do(q{VACUUM ANALYZE}); + system 'killall','-USR1', 'ndbot.pl'; + local $dbh->{Warn} = 0; }