code snippet: alphabetical listing of pages

[N1l3Z]

Hello All!

I just made a small snippet for displaying all the public pages alphabetically.. This is a nice supplement to sitemap.

Here's some code to put into a code-module and put on any page..

Code:

$private_sql = "";
$private_where_sql = "NOT visibility = 'private'";
global $database;
global $private_sql;
global $private_where_sql;
global $shown;
$shown="z";
// Query pages
$query_menu = $database->query("SELECT page_id,parent,link,page_title,menu_title,description,keywords,modified_when,modified_by,link,target,visibility FROM ".TABLE_PREFIX."pages WHERE $private_where_sql ORDER BY page_title ASC");

// Check if there are any pages to show
if($query_menu->numRows() > 0) {
echo '<h1>Pages index</h1>';


while($page = $query_menu->fetchRow()) {

$firstletter = substr($page['page_title'], 0, 1);
if ($firstletter != $shown){

echo $firstletter;
echo'<br />';
$shown = $firstletter;
}

echo '<a href="';
echo page_link($page['link']);
echo '">';
echo $page['page_title'];
echo'</a>';
echo '<br />';

}

}

The code can be modified to look into the modules also, but here it just lists the pages..

Cheers!

/N1L3Z

[xiff]

hi all

another version of this code

Code:

$private_sql = "";
$private_where_sql = "NOT visibility = 'private'";
global $database;
    global $private_sql;
    global $private_where_sql;
    global $shown;
$shown="z";

   
    //SELECT distinct LEFT(nom, 1) AS firstletter FROM t_pilote order by firstletter ASC
   
    // Check if there are any pages to show
    echo '<h1>Pages A to Z</h1>';
       
    $alpha = array("A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z");
   
    $query_menu = $database->query("SELECT distinct LEFT(page_title, 1) AS firstletter FROM ".TABLE_PREFIX."pages order by firstletter ASC");
   
    $page = $query_menu->fetchRow();
    for($i=0;$i<count($alpha);$i++){
        if($page['firstletter']!=$alpha[$i]){
            echo'&nbsp; | &nbsp;'.$alpha[$i].'';
        }else{
            echo'&nbsp; | &nbsp;<a href="#'.$alpha[$i].'">'.$alpha[$i].'</a>';
            $page = $query_menu->fetchRow();
        }
       
    }
    echo"&nbsp; |<br><br>";

    // Query pages
    $query_menu = $database->query("SELECT page_id,parent,link,page_title,menu_title,description,keywords,modified_when,modified_by,link,target,visibility FROM ".TABLE_PREFIX."pages WHERE $private_where_sql ORDER BY page_title ASC");
   
    if($query_menu->numRows() > 0) {
        while($page = $query_menu->fetchRow()) {

            $firstletter = substr($page['page_title'], 0, 1);
            if ($firstletter != $shown){
                echo '<h2><a name="'.strtoupper($firstletter).'" id="'.strtoupper($firstletter).'">'.$firstletter.'</a></h2>';
                echo'<br />';
                $shown = $firstletter;
            }
           
            echo '<a href="';
                echo page_link($page['link']);
                echo '">';
                echo $page['page_title'];
                echo'</a>';
                echo '<br />';        
        }
    }