Need to pick channel before sending

[ndwebbie.git] / lib / NDWeb / Controller / JSRPC.pm

diff --git a/lib/NDWeb/Controller/JSRPC.pm b/lib/NDWeb/Controller/JSRPC.pm
index 3bea69a5405e5c14983503767410d1eaf2a28ea0..6e21a9446014b30288cc0786604c41401fe00998 100644 (file)
--- 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');