PageRenderTime 46ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/includes/build_sitemap.php

https://bitbucket.org/mpercy/deeemm-cms
PHP | 132 lines | 49 code | 72 blank | 11 comment | 10 complexity | f19a714dc7ed618046c22acb34ee8095 MD5 | raw file
Possible License(s): LGPL-2.1, BSD-2-Clause
  1. <?php
  2. defined( '_INDM' ) or die( 'POSSIBLE HACK ATTEMPT!' );
  3. $main = read_file($default_url . $templates_dir . "sitemap.tpl");
  4. /*===========================================================================
  5. Propogate the site map
  6. ===========================================================================*/
  7. //generate list with links for modifying category
  8. foreach($all_tables as $value){
  9. $tables_list = '';
  10. $sql_query = mysql_query("SELECT * FROM `" . $db_table_prefix . "core_structure` WHERE `table` = '$value'");
  11. while($sql_result = mysql_fetch_array($sql_query)){
  12. $type = $sql_result[type];
  13. $media_library_default_view = $sql_result[media_library_default_view];
  14. $num_slideshow_images = $sql_result[num_slideshow_images];
  15. $imagebox_type = $sql_result[imagebox_type];
  16. $display_in_margin = $sql_result[display_in_margin];
  17. $display_in_sitemap = $sql_result[display_in_sitemap];
  18. $allow_comments = $sql_result[allow_comments];
  19. $category = $sql_result[category_lan_ . $language];
  20. }
  21. //get highest order page
  22. $sql_query = mysql_query("SELECT * FROM `" . $db_table_prefix . 'cat_' . "$value` WHERE `id` > 0 ORDER BY `order` LIMIT 1");
  23. if($sql_result = mysql_fetch_array($sql_query)){
  24. $id = $sql_result[id];
  25. $link_url = $sql_result[link_url];
  26. }
  27. /*===========================================================================
  28. Get main heading
  29. ===========================================================================*/
  30. switch ($type) {
  31. case 'list';
  32. case 'normal';
  33. if (isset($link_url) && $link_url <> '') {
  34. $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'>&nbsp&nbsp<a class='sitemap_item' href='" . $link_url . "'>" . $category . "</A>", $value);
  35. } else {
  36. $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'>&nbsp&nbsp<a class='sitemap_item' href='$default_url"."index.php?page=" . $value . "'&amp;id=$id>" . $category . "</A>", $value);
  37. }
  38. break;
  39. case 'media';
  40. $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'>&nbsp&nbsp<a class='sitemap_item' href='$default_url"."index.php?page=" . $value . "'>" . $category . "</A>", $value);
  41. break;
  42. }
  43. /*===========================================================================
  44. Get sub heading
  45. ===========================================================================*/
  46. $sql_query = mysql_query("SELECT * FROM `" . $db_table_prefix . 'cat_' . "$value` ORDER BY `order`");
  47. while ($sql_result = mysql_fetch_array($sql_query)){
  48. $title = $sql_result[title_lan_ . $language];
  49. $id = $sql_result[id];
  50. $link_url = $sql_result[link_url];
  51. if ($type == 'normal'){
  52. $tables_list .= str_replace($value, "<ul><img class='icon' title='$type' src='$default_url".$templates_dir."images/icons/page.gif'>&nbsp;&nbsp;<a class='sitemap_item' href='$default_url"."index.php?page=" . $value . "&amp;id=$id'>" . $title . "</A></span></ul>", $value);
  53. }
  54. }
  55. $tables_list = str_replace(' ', '', $tables_list);
  56. if (isset($display_in_sitemap) && $display_in_sitemap <> ''){
  57. $sitemap_list .= $tables_list;
  58. }
  59. }
  60. ?>