Get rid of child pages

This excessively complicated bit of code should do what you’re asking for:

<?php
global $wp_query, $wpdb;
$pageid = $wp_query->post->ID;

$subpages = $wpdb->get_results("SELECT ID, post_parent FROM $wpdb->posts WHERE post_status = 'static' AND post_parent != ''");
foreach($subpages as $subpage) :
if(!($subpage->post_parent == $pageid)) :
$exclude = $subpage->ID . ',';
endif; endforeach;

wp_list_pages("exclude=$exclude");
?>

The above first performs an object query to collect the current Page’s ID. Then it queries the database to gather every Page with a parent. It adds each (child) Page ID to $exclude as long as the parent Page ID does not match the current one. Finally, $exclude is passed as the value for the wp_list_pages() ‘exclude’ parameter.

In future, please don’t post entire templates in the forums. It’s difficult to read, and only the relevant portion is necessary (in this case, the part setting up your wp_list_pages() display).

Here is the section in your sidebar you probably want to replace:

<?php /* Creates a menu for pages beneath the level of the current page */
if (is_page() and ($notfound != '1')) {
$current_page = $post->ID;

…down to…

Back to <?php echo $parent_title; ?>
<?php } ?>
</div>
<?php } } ?>

In its place add this version of the code I provided above (fixes a tiny bug and incorporates your features):

<?php
global $wp_query, $wpdb;
$pageid = $wp_query->post->ID;

$subpages = $wpdb->get_results("SELECT ID, post_parent FROM $wpdb->posts WHERE post_type = 'page' AND post_parent != ''");
foreach($subpages as $subpage) :
if(!($subpage->post_parent == $pageid)) :
$exclude .= $subpage->ID . ',';
endif; endforeach;
echo $exclude;
?>

<div class="sb-pagemenu"><h2>Pages</h2>
<ul>
<?php wp_list_pages("sort_column=menu_order&title_li=&exclude=$exclude"); ?>
</ul>
</div>

This should work as is, though you may want to alter the <h2> content, div class, etc.

Post your sidebar template here:

http://paste.uni.cc

and reply back with the url to it.

EDIT: My goof. Playing around with too many versions of WordPress right now. Change the $subpages line in the code above to:

$subpages = $wpdb->get_results("SELECT ID, post_parent FROM $wpdb->posts WHERE post_status = 'static' AND post_parent != ''");

Note for the future: Previous coding of that line will most likely work in WordPress version 2.1. So when you upgrade and things go bonkers… ;)

That long list of numbers is unfortunately a bit of debugging (the echo command) I forgot to remove.

Anyway, here’s a revise of your sidebar.php:
http://paste.uni.cc/8747

Note my code works (correctly) ONLY IF one has a single layer of Pages/subPages, which is what I assumed your request involved. Having something like Page/subPages/subPages(/etc.) will get lost in my code’s parent Page tracking, which can only maintain a list of *all* Pages with a parent. It would require a more complex solution than my few lines above.

(By the way, this thread is an example of my code pasting habits at their laziest. Sorry about that.)

Thanks Kafkaesqui

Works a treat.

dexter, the difference in sidebars is due to the theme used. All you (and most others) need be concerned with is this portion of your sidebar.php:

<?php wp_list_pages(); ?>

And here’s my hack-y replacement for that line:

http://paste.uni.cc/8790

Note I’ve slightly improved things so that now ‘siblings’ under a parent Page will continue to be listed when one is viewing one of them (before they just dropped back into the $exclude list).

Note: If you–or anyone–is doing a bit of fancy post querying on Pages (using query_posts() or the like), this can scramble things as far as my code is concerned. In that case, add this to the very beginning of the code statement:

rewind_posts();