/includes/build_sitemap.php
PHP | 132 lines | 49 code | 72 blank | 11 comment | 10 complexity | f19a714dc7ed618046c22acb34ee8095 MD5 | raw file
Possible License(s): LGPL-2.1, BSD-2-Clause
- <?php
- defined( '_INDM' ) or die( 'POSSIBLE HACK ATTEMPT!' );
- $main = read_file($default_url . $templates_dir . "sitemap.tpl");
- /*===========================================================================
- Propogate the site map
- ===========================================================================*/
- //generate list with links for modifying category
- foreach($all_tables as $value){
- $tables_list = '';
- $sql_query = mysql_query("SELECT * FROM `" . $db_table_prefix . "core_structure` WHERE `table` = '$value'");
- while($sql_result = mysql_fetch_array($sql_query)){
- $type = $sql_result[type];
- $media_library_default_view = $sql_result[media_library_default_view];
- $num_slideshow_images = $sql_result[num_slideshow_images];
- $imagebox_type = $sql_result[imagebox_type];
- $display_in_margin = $sql_result[display_in_margin];
- $display_in_sitemap = $sql_result[display_in_sitemap];
- $allow_comments = $sql_result[allow_comments];
- $category = $sql_result[category_lan_ . $language];
- }
- //get highest order page
- $sql_query = mysql_query("SELECT * FROM `" . $db_table_prefix . 'cat_' . "$value` WHERE `id` > 0 ORDER BY `order` LIMIT 1");
- if($sql_result = mysql_fetch_array($sql_query)){
- $id = $sql_result[id];
- $link_url = $sql_result[link_url];
- }
- /*===========================================================================
- Get main heading
- ===========================================================================*/
- switch ($type) {
- case 'list';
- case 'normal';
- if (isset($link_url) && $link_url <> '') {
- $tables_list .= str_replace($value, "<HR size='1px' color='#ddd' class='clear_both'><img class='icon' title='$type' src='$default_url".$templates_dir."images/icons/$type.gif'>  <a class='sitemap_item' href='" . $link_url . "'>" . $category . "</A>", $value);
- } else {
- $tables_list .= str_replace($value, "<HR size='1px' color='#ddd' class='clear_both'><img class='icon' title='$type' src='$default_url".$templates_dir."images/icons/$type.gif'>  <a class='sitemap_item' href='$default_url"."index.php?page=" . $value . "'&id=$id>" . $category . "</A>", $value);
- }
- break;
- case 'media';
- $tables_list .= str_replace($value, "<HR size='1px' color='#ddd' class='clear_both'><img class='icon' title='$type' src='$default_url".$templates_dir."images/icons/$type.gif'>  <a class='sitemap_item' href='$default_url"."index.php?page=" . $value . "'>" . $category . "</A>", $value);
- break;
- }
- /*===========================================================================
- Get sub heading
- ===========================================================================*/
- $sql_query = mysql_query("SELECT * FROM `" . $db_table_prefix . 'cat_' . "$value` ORDER BY `order`");
- while ($sql_result = mysql_fetch_array($sql_query)){
- $title = $sql_result[title_lan_ . $language];
- $id = $sql_result[id];
- $link_url = $sql_result[link_url];
- if ($type == 'normal'){
- $tables_list .= str_replace($value, "<ul><img class='icon' title='$type' src='$default_url".$templates_dir."images/icons/page.gif'> <a class='sitemap_item' href='$default_url"."index.php?page=" . $value . "&id=$id'>" . $title . "</A></span></ul>", $value);
- }
- }
- $tables_list = str_replace(' ', '', $tables_list);
-
- if (isset($display_in_sitemap) && $display_in_sitemap <> ''){
- $sitemap_list .= $tables_list;
- }
- }
- ?>