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 "'; ?>

Sign up for email updates