only output groups which have the nfsgroup bit set into a user's hesiod

grplist.

diff --git a/gen/hesiod.pc b/gen/hesiod.pc
index a44a9cc8ab15646c80b75db12017dccbdd61940a..6be3bb7ece0aec0452596f3a3d01dc80f1a5189a 100644 (file)
--- a/gen/hesiod.pc
+++ b/gen/hesiod.pc
@@ -418,8 +418,7 @@ int do_groups(void)
       EXEC SQL DECLARE u_cursor2 CURSOR FOR
        SELECT users_id, login
        FROM users
-       WHERE status = 1 OR status = 2
-       ORDER BY users_id;
+       WHERE status = 1 OR status = 2;
       EXEC SQL OPEN u_cursor2;
       while (1)
        {
@@ -435,10 +434,10 @@ int do_groups(void)
     }
 
   EXEC SQL DECLARE i_cursor CURSOR FOR
-    SELECT list_id, member_id
-    FROM imembers
-    WHERE member_type = 'USER'
-    ORDER BY list_id;
+    SELECT m.list_id, m.member_id
+    FROM imembers m, list l 
+    WHERE m.member_type = 'USER'
+    AND m.list_id = l.list_id AND l.grouplist = 1 AND l.nfsgroup = 1;
   EXEC SQL OPEN i_cursor;
   while (1)
     {