From 014bbd32ee97f514fe7e953faff28108ce72ac6f Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 29 Sep 2004 14:15:44 +0000 Subject: - Fixed SQL query in book module. Patch by killes. --- modules/book.module | 2 +- modules/book/book.module | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) (limited to 'modules') diff --git a/modules/book.module b/modules/book.module index 0268329df..a9ce5c758 100644 --- a/modules/book.module +++ b/modules/book.module @@ -121,7 +121,7 @@ function book_block($op = 'list', $delta = 0) { else { // Only display this block when the user is browsing a book: if (arg(0) == 'node' && is_numeric(arg(1))) { - $result = db_query('SELECT n.nid, n.title, b.parent FROM {node} n '. node_access_join_sql() .' INNER JOIN {book} b ON n.nid = b.nid WHERE '. node_access_where_sql() .' n.nid = %d', arg(1)); + $result = db_query('SELECT n.nid, n.title, b.parent FROM {node} n '. node_access_join_sql() .' INNER JOIN {book} b ON n.nid = b.nid WHERE '. node_access_where_sql() .' AND n.nid = %d', arg(1)); if (db_num_rows($result) > 0) { $node = db_fetch_object($result); diff --git a/modules/book/book.module b/modules/book/book.module index 0268329df..a9ce5c758 100644 --- a/modules/book/book.module +++ b/modules/book/book.module @@ -121,7 +121,7 @@ function book_block($op = 'list', $delta = 0) { else { // Only display this block when the user is browsing a book: if (arg(0) == 'node' && is_numeric(arg(1))) { - $result = db_query('SELECT n.nid, n.title, b.parent FROM {node} n '. node_access_join_sql() .' INNER JOIN {book} b ON n.nid = b.nid WHERE '. node_access_where_sql() .' n.nid = %d', arg(1)); + $result = db_query('SELECT n.nid, n.title, b.parent FROM {node} n '. node_access_join_sql() .' INNER JOIN {book} b ON n.nid = b.nid WHERE '. node_access_where_sql() .' AND n.nid = %d', arg(1)); if (db_num_rows($result) > 0) { $node = db_fetch_object($result); -- cgit v1.2.3