From f5e09716d092aacf77204e666a676049dcc89f1a Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Tue, 7 Apr 2009 19:44:07 +0200 Subject: [PATCH] Only show member fleets --- Usermgm.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Usermgm.pm b/Usermgm.pm index 2663e35..6771d65 100644 --- a/Usermgm.pm +++ b/Usermgm.pm @@ -201,14 +201,14 @@ sub getShips { WHERE mission = 'Full fleet' AND name <> 'Unit' ORDER BY planet,tick DESC,fid DESC) f USING (planet) JOIN fleet_ships fs USING (fid) - WHERE ship ILIKE ? + WHERE ship ILIKE ? AND uid IN (SELECT uid FROM groupmembers WHERE gid = 2) GROUP BY username ORDER BY amount DESC }); if ($command eq 'shipshome'){ $f = $ND::DBH->prepare(q{ SELECT username,SUM(amount) AS amount FROM available_ships -WHERE ship ILIKE ? +WHERE ship ILIKE ? AND uid IN (SELECT uid FROM groupmembers WHERE gid = 2) GROUP BY username ORDER BY amount DESC }); } -- 2.39.2