#218471 by pwolanin: exclude unpublished nodes from menus and books (critical)
--- includes/menu.inc 2008/02/06 12:11:22 1.255.2.1
+++ includes/menu.inc 2008/02/07 09:39:39 1.255.2.2
@@ -949,7 +949,7 @@
// Use db_rewrite_sql to evaluate view access without loading each full node.
$nids = array_keys($node_links);
$placeholders = '%d'. str_repeat(', %d', count($nids) - 1);
- $result = db_query(db_rewrite_sql("SELECT n.nid FROM {node} n WHERE n.nid IN (". $placeholders .")"), $nids);
+ $result = db_query(db_rewrite_sql("SELECT n.nid FROM {node} n WHERE n.status = 1 AND n.nid IN (". $placeholders .")"), $nids);
while ($node = db_fetch_array($result)) {
$nid = $node['nid'];
foreach ($node_links[$nid] as $mlid => $link) {