X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/blobdiff_plain/21214675c318cfb06828d0a534d437549759fa85..c2879786eb164e7e1521f06ba8c6e0dd0a313d45:/gen/postoffice.pc

diff --git a/gen/postoffice.pc b/gen/postoffice.pc
index 0a1fa20b..5d7cd7b2 100644
--- a/gen/postoffice.pc
+++ b/gen/postoffice.pc
@@ -183,10 +183,11 @@ void pobox(char *path)
 
       EXEC SQL DECLARE filsys_cursor CURSOR FOR
 	SELECT f.label, f.lockertype, p.dir, q.quota
-	FROM filesys f, nfsphys p, quota q
+	FROM filesys f, nfsphys p, quota q, users u
 	WHERE f.mach_id=:mid AND f.type='IMAP' AND f.createflg!=0
 	AND f.filsys_id=q.filsys_id
 	AND f.mach_id=p.mach_id AND f.phys_id=p.nfsphys_id
+	AND f.owner = u.users_id AND u.status != 3
 	ORDER BY f.label, p.dir, q.quota;
       EXEC SQL OPEN filsys_cursor;