PageRenderTime 77ms CodeModel.GetById 52ms RepoModel.GetById 1ms app.codeStats 0ms

/admin/includes/edit_categories.php

https://bitbucket.org/mpercy/deeemm-cms
PHP | 108 lines | 73 code | 21 blank | 14 comment | 25 complexity | 4519a46deeaa54900f1b575b9f680b90 MD5 | raw file
Possible License(s): LGPL-2.1, BSD-2-Clause
  1. <?php
  2. defined( '_INDM' ) or die( 'POSSIBLE HACK ATTEMPT!' );
  3. /*===========================================================================
  4. Check user priviledges
  5. ===========================================================================*/
  6. require VALIDATE;
  7. if ($user != 'ADMIN') header("Location: " . $default_url . "index.php");
  8. $javascript_onload = 'setup_categories_form();';
  9. $main = read_file("templates/edit_categories.tpl");
  10. /*===========================================================================
  11. Propogate the site map
  12. ============================================================================*/
  13. //generate list with links for modifying category
  14. foreach($all_tables as $value){
  15. $tables_list = '';
  16. $sql_query = mysql_query("SELECT * FROM `" . $db_table_prefix . "core_structure` WHERE `table` = '$value'");
  17. while($sql_result = mysql_fetch_array($sql_query)){
  18. $type = $sql_result[type];
  19. $media_library_default_view = $sql_result[media_library_default_view];
  20. $num_slideshow_images = $sql_result[num_slideshow_images];
  21. $imagebox_type = $sql_result[imagebox_type];
  22. $display_in_margin = $sql_result[display_in_margin];
  23. $display_in_sitemap = $sql_result[display_in_sitemap];
  24. $allow_comments = $sql_result[allow_comments];
  25. $category = $sql_result[category_lan_ . $language];
  26. }
  27. }
  28. $editing_category_message = $lan[editing_category_message];
  29. //check if category is being editied if so propogate text boxes
  30. $category = strtolower($_REQUEST['category']);
  31. if (isset($category) && $category <> '') {
  32. $sql_query = mysql_query("SELECT * FROM `" . $db_table_prefix . "core_structure` WHERE `table` = '$category'");
  33. while($sql_result = mysql_fetch_array($sql_query)){
  34. $display_in_margin = $sql_result[display_in_margin];
  35. $display_in_sitemap = $sql_result[display_in_sitemap];
  36. $media_library_default_view = $sql_result[media_library_default_view];
  37. $num_slideshow_images = $sql_result[num_slideshow_images];
  38. $imagebox_type = $sql_result[imagebox_type];
  39. $allow_comments = $sql_result[allow_comments];
  40. $category_lan_1 = $sql_result[category_lan_1];
  41. $tool_tip_lan_1 = $sql_result[tool_tip_lan_1];
  42. $category_lan_2 = $sql_result[category_lan_2];
  43. $tool_tip_lan_2 = $sql_result[tool_tip_lan_2];
  44. $category_lan_3 = $sql_result[category_lan_3];
  45. $tool_tip_lan_3 = $sql_result[tool_tip_lan_3];
  46. $category_lan_4 = $sql_result[category_lan_4];
  47. $tool_tip_lan_4 = $sql_result[tool_tip_lan_4];
  48. }
  49. if ($media_library_default_view == 'thumbnails') $sitemap_editor = str_replace('[var]thumbnails[/var]', 'checked="true"', $sitemap_editor);
  50. if ($media_library_default_view == 'list') $sitemap_editor = str_replace('[var]list_view[/var]', 'checked="true"', $sitemap_editor);
  51. if ($media_library_default_view == 'first') $sitemap_editor = str_replace('[var]first_image[/var]', 'checked="true"', $sitemap_editor);
  52. if ($media_library_default_view == 'last') $sitemap_editor = str_replace('[var]last_image[/var]', 'checked="true"', $sitemap_editor);
  53. if ($imagebox_type == 'slideshow') $sitemap_editor = str_replace('[var]slideshow[/var]', 'checked="true"', $sitemap_editor);
  54. if ($imagebox_type == 'random') $sitemap_editor = str_replace('[var]random[/var]', 'checked="true"', $sitemap_editor);
  55. if ($display_in_margin == 'on') $sitemap_editor = str_replace('[var]display_in_margin[/var]', 'checked="true"', $sitemap_editor);
  56. if ($display_in_sitemap == 'on') $sitemap_editor = str_replace('[var]display_in_sitemap[/var]', 'checked="true"', $sitemap_editor);
  57. if ($allow_comments == 'on') $sitemap_editor = str_replace('[var]allow_comments[/var]', 'checked="true"', $sitemap_editor);
  58. $old_category = $category;
  59. $editing_category_message = $lan[editing_category_message_1] . " '" . $category . "'";
  60. }
  61. /*===========================================================================
  62. Generate the category type drop down menu
  63. ===========================================================================*/
  64. $category_type = '';
  65. $type = 'normal'; //set default list type to display
  66. //get current type
  67. $sql_query = mysql_query("SELECT * FROM `" . $db_table_prefix . "core_structure` WHERE `table` LIKE '$category'");
  68. while ($sql_result = mysql_fetch_array($sql_query)){
  69. $type = $sql_result[type];
  70. }
  71. //get all possible types from database + active type
  72. $sql_query = mysql_query("SHOW COLUMNS FROM `" . $db_table_prefix . "core_structure` LIKE 'type'");
  73. $sql_result = mysql_fetch_row($sql_query);
  74. preg_match_all("/'(.*?)'/", $sql_result[1], $temp_array);
  75. $category_types = array_unique($temp_array);
  76. sort($category_types);
  77. //create drop down list
  78. $category_type = "<select class='w100pcnt' name='category_type' onchange='setup_categories_form()'>". $crlf . "<option value='$type'>$type</option>" . $crlf;
  79. foreach($category_types[0] as $value) {
  80. $value = str_replace('\'', '', $value);
  81. if ($value != $type){
  82. $category_type .= "<option value='$value'>$value</option>";
  83. }
  84. }
  85. $category_type = str_replace(' ', '', $category_type);
  86. $category_type .= '</select>';
  87. ?>