This is a list of all our internal pages.

global $db_prefix;

error_reporting(E_ALL);
require_once ‘./includes/bootstrap.inc’;

$result = db_query(“SELECT * FROM ” . $db_prefix . “node WHERE ( type=’page’ ) and not (status=0 and moderate=0) order by title ASC”);
while ( $node = db_fetch_object($result)) {
$n = “/node/”. $node->nid;
if ( substr($n,0, 1) == ‘/’ ) {
$n = substr( $n, 1);
}
$links[] = l($node->title, drupal_get_path_alias($n));
}
echo theme_item_list($links);

?>