Don't output seperate lines for each sublist.

[moira.git] / gen / confluence.gen

diff --git a/gen/confluence.gen b/gen/confluence.gen
index b39011a4114b38165520d67505992f382157afbc..333a500fa6c6a720245aa70f80c432f35b0b0c57 100755 (executable)
--- a/gen/confluence.gen
+++ b/gen/confluence.gen
@@ -28,7 +28,7 @@ while (($root_list_id, $hostname) = $sth0->fetchrow_array) {
     $sth = $dbh->prepare("SELECT l.name FROM list l, imembers i " .
                         "WHERE i.list_id = " . $dbh->quote($root_list_id) .
                         "AND i.member_type = 'LIST' " .
-                        "AND i.member_id = l.list_id " .
+                        "AND i.member_id = l.list_id AND i.direct = 1 " .
                         "ORDER BY l.name") || exit $MR_DBMS_ERR;
     $sth->execute;