From: Michael Andreen <harv@ruin.nu>
Date: Tue, 7 Apr 2009 17:44:07 +0000 (+0200)
Subject: Only show member fleets
X-Git-Url: https://ruin.nu/git/?p=NDIRC.git;a=commitdiff_plain;h=f5e09716d092aacf77204e666a676049dcc89f1a

Only show member fleets
---

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
 			});
 		}