Sitemap
".chr($i).""; } echo ''; echo '
'; echo "
"; $pages = array(); // Pages $sql="SELECT file_name,link_name FROM pages WHERE is_link != 't' AND hide = 'f' AND file_name != '404'"; $result=mysql_query($sql); while ($row = mysql_fetch_array($result)){ $pages['/'.$row['file_name'].'.php'] = $row['link_name']; } // Internal Links $sql="SELECT file_name,link_name FROM pages WHERE is_link = 't' AND LEFT(file_name,1) = '/'"; $result=mysql_query($sql); while ($row = mysql_fetch_array($result)){ if (empty($pages[$row['file_name']])) $pages[$row['file_name']] = $row['link_name']; } // CMS Listings $sql="SELECT id,title FROM _listings"; $result=mysql_query($sql); while ($row = mysql_fetch_array($result)){ $pages['idx/cms/'.$row['id'].'/details.html'] = $row['title']; } natcasesort($pages); $letter = 'A'; echo ""; echo "
- ";
foreach ($pages as $file => $link)
{
if (strtoupper(substr($link,0,1)) > $letter) {
$letter = strtoupper(substr($link,0,1));
echo "
"; echo ""; echo "
- ";
}
echo "
- ".$link." "; } echo '