diff options
| -rw-r--r-- | modules/book.module | 2 | ||||
| -rw-r--r-- | modules/book/book.module | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/modules/book.module b/modules/book.module index b6bace0c6..161e84e16 100644 --- a/modules/book.module +++ b/modules/book.module @@ -496,7 +496,7 @@ function book_tree_recurse($nid, $depth, $children) { function book_tree($parent = 0, $depth = 3) { - $result = db_query("SELECT n.nid, n.title, b.parent FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.status = '1' ORDER BY b.weight, n.title"); + $result = db_query("SELECT n.nid, n.title, b.parent FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.status = '1' AND n.moderate = '0' ORDER BY b.weight, n.title"); while ($node = db_fetch_object($result)) { $list = $children[$node->parent] ? $children[$node->parent] : array(); diff --git a/modules/book/book.module b/modules/book/book.module index b6bace0c6..161e84e16 100644 --- a/modules/book/book.module +++ b/modules/book/book.module @@ -496,7 +496,7 @@ function book_tree_recurse($nid, $depth, $children) { function book_tree($parent = 0, $depth = 3) { - $result = db_query("SELECT n.nid, n.title, b.parent FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.status = '1' ORDER BY b.weight, n.title"); + $result = db_query("SELECT n.nid, n.title, b.parent FROM node n LEFT JOIN book b ON n.nid = b.nid WHERE n.status = '1' AND n.moderate = '0' ORDER BY b.weight, n.title"); while ($node = db_fetch_object($result)) { $list = $children[$node->parent] ? $children[$node->parent] : array(); |