X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FJSRPC.pm;h=80912c10732e5b53045de5e071b1f53cb7de2a3f;hb=b6d8351387cf06b88e362a458aad1e0982e575dd;hp=6e21a9446014b30288cc0786604c41401fe00998;hpb=6c73f6ddd47b3274ee7fa784f74823591d19dbc6;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/JSRPC.pm b/lib/NDWeb/Controller/JSRPC.pm index 6e21a94..80912c1 100644 --- a/lib/NDWeb/Controller/JSRPC.pm +++ b/lib/NDWeb/Controller/JSRPC.pm @@ -41,12 +41,12 @@ sub update : Local { 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 + $targets = $dbh->prepare(q{SELECT r.id,r.pid FROM raid_targets r WHERE r.raid = ? AND modified > ? }); $targets->execute($raid->{id},$from); }elsif($target){ - $targets = $dbh->prepare(q{SELECT r.id,r.planet FROM raid_targets r + $targets = $dbh->prepare(q{SELECT r.id,r.pid FROM raid_targets r WHERE r.raid = $1 AND r.id = $2 }); $targets->execute($raid->{id},$target);