(uid,channel,message) VALUES($1,$2,$3)
});
$query->execute($c->user->id,$c->req->param('channel'),$c->req->param('message'));
+ system 'killall','-USR1', 'irssi';
$c->flash(reply => "Msg sent to: ".$c->req->param('channel'));
$c->res->redirect($c->uri_for('ircrequest'));
use LWP::Simple;
-use lib qw{/var/www/ndawn/lib/};
+use FindBin;
+use lib "$FindBin::Bin/../lib";
+
use ND::DB;
our $dbh = ND::DB::DB();
}
if ($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`;
+ `perl $FindBin::Bin/parsealliances.pl $updated`;
+ `perl $FindBin::Bin/parseplanets.pl $updated`;
+ `perl $FindBin::Bin/parsegalaxies.pl $updated`;
+ `perl $FindBin::Bin/ndrank.pl`;
$dbh->do(q{UPDATE misc SET value = ? WHERE id = 'TICK'}, undef, $updated);
+ system 'killall','-USR1', 'irssi';
local $dbh->{Warn} = 0;
$dbh->do(q{VACUUM ANALYZE});
}
use LWP::Simple;
-use lib qw{/var/www/ndawn/lib/};
+use FindBin;
+use lib "$FindBin::Bin/../lib";
+
use ND::DB;
our $dbh = ND::DB::DB();
use LWP::Simple;
-use lib qw{/var/www/ndawn/lib/};
+use FindBin;
+use lib "$FindBin::Bin/../lib";
use ND::Include;
use ND::DB;
use LWP::Simple;
-use lib qw{/var/www/ndawn/lib/};
+use FindBin;
+use lib "$FindBin::Bin/../lib";
use ND::Include;
use ND::DB;
use LWP::Simple;
-use lib qw{/var/www/ndawn/lib/};
+use FindBin;
+use lib "$FindBin::Bin/../lib";
use ND::Include;
use ND::DB;
use DBD::Pg qw(:pg_types);
use LWP::Simple;
-use lib qw{/var/www/ndawn/lib/};
+
+use FindBin;
+use lib "$FindBin::Bin/../lib";
+
use ND::DB;
our $dbh = ND::DB::DB();
$newscans->execute or die $dbh->errstr;
$dbh->pg_savepoint('scans') or die "No savepoint";
+my $parsedscans = 0;
+
while (my $scan = $newscans->fetchrow_hashref){
$dbh->pg_release('scans') or die "Couldn't save";
$dbh->pg_savepoint('scans') or die "Couldn't save";
}
$parsedscan->execute($tick,$type,$planet,$scan->{id}) or die $dbh->errstr;
#$dbh->rollback;
+ ++$parsedscans;
};
if ($@) {
warn $@;
#$dbh->rollback;
$dbh->commit;
+system 'killall','-USR1', 'irssi' if $parsedscans;
+
sub addfleet {
my ($name,$mission,$ships,$sender,$target,$tick,$eta,$back,$amount,$ingal) = @_;
use DBD::Pg qw(:pg_types);
use LWP::Simple;
-use lib qw{/var/www/ndawn/lib/};
+
+use FindBin;
+use lib "$FindBin::Bin/../lib";
+
use ND::DB;
our $dbh = ND::DB::DB();
use LWP::Simple;
-use lib qw{/var/www/ndawn/lib/};
+use FindBin;
+use lib "$FindBin::Bin/../lib";
+
use ND::DB;
our $dbh = ND::DB::DB();
my $update = $dbh->prepare("UPDATE misc SET value = value::int + 1 WHERE id = 'TICK'");
$update->execute();
+system 'killall','-USR1', 'irssi';
$dbh->disconnect;