X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FJSRPC.pm;h=6e21a9446014b30288cc0786604c41401fe00998;hb=2a703f7250ea25f2f556eb25b644dcb7268f92ce;hp=3bea69a5405e5c14983503767410d1eaf2a28ea0;hpb=eb3bda37d084c0e6b13c97f88f06d5563c40d2fb;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/JSRPC.pm b/lib/NDWeb/Controller/JSRPC.pm index 3bea69a..6e21a94 100644 --- a/lib/NDWeb/Controller/JSRPC.pm +++ b/lib/NDWeb/Controller/JSRPC.pm @@ -38,7 +38,8 @@ sub update : Local { my $targets;; if ($from){ - my ($timestamp) = $dbh->selectrow_array("SELECT MAX(modified)::timestamp AS modified FROM raid_targets"); + my ($timestamp) = $dbh->selectrow_array(q{SELECT MAX(modified)::timestamp AS modified + FROM raid_targets WHERE raid = $1},undef,$raid->{id}); $c->stash(timestamp => $timestamp); $targets = $dbh->prepare(q{SELECT r.id,r.planet FROM raid_targets r WHERE r.raid = ? AND modified > ? @@ -174,7 +175,6 @@ sub joinable : Local { WHERE target = ? AND wave = ? }); $query->execute($joinable,$target,$wave); - $c->forward('/listTargets'); } $c->stash(template => 'jsrpc/update.tt2');