X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FRoot.pm;fp=lib%2FNDWeb%2FController%2FRoot.pm;h=6099db5805cda9a266914728cc52463f179e3ce1;hb=7d478421939145912a4155865ad6b521e1bff08f;hp=09ace65bb2ac708d886df6c5b0375329918b5a5e;hpb=7782222a680e2752239bd7f9a853630412d47c74;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/Root.pm b/lib/NDWeb/Controller/Root.pm index 09ace65..6099db5 100644 --- a/lib/NDWeb/Controller/Root.pm +++ b/lib/NDWeb/Controller/Root.pm @@ -188,8 +188,9 @@ sub end : ActionClass('RenderView') { if ($c->user_exists){ my $fleetupdate = 0; if ($c->check_user_roles(qw/member_menu/)){ - $fleetupdate = $dbh->selectrow_array(q{SELECT tick FROM fleets WHERE sender = ? - AND mission = 'Full fleet' AND tick > tick() - 24 + $fleetupdate = $dbh->selectrow_array(q{ +SELECT tick FROM fleets WHERE planet = ? AND tick > tick() - 24 +AND mission = 'Full fleet' AND name IN ('Main','Advanced Unit'); },undef,$c->user->planet); $fleetupdate = 0 unless defined $fleetupdate; }