/photographer/menu_creator.php

https://github.com/GansukhB/phtstr · PHP · 231 lines · 206 code · 15 blank · 10 comment · 33 complexity · 0b671fcf6d7892d2edbc50d7751cf57d MD5 · raw file 

    

  1. <?PHP
    2. 

  2.   session_start();
    3. 

  3.   session_register("mgruser");
    4. 

  4.   $_SESSION['mgruser'] = 1;
    5. 

  5.   
    6. 

  6. 	include( "../database.php" );
    7. 

  7. 	include( "../config_public.php" );
    8. 

  8. 	include( "../functions.php" );
    9. 

  9. 	
    10. 

  10.   //$lang = $_SESSION['lang'];
    11. 

  11.   echo $_SESSION['lang'];
    12. 

  12.   
    13. 

  13.   $lang = explode(".", $_SESSION['lang'] );
    14. 

  14.   
    15. 

  15.   $lang = strtolower($lang[0]);
    16. 

  16.   
    17. 

  17. 	unset($_SESSION['mgruser']);
    18. 

  18. 

  19. 		 $cr = "\n";
    20. 

  20. 		 
    21. 

  21. 											if($setting->show_private != 1){
    22. 

  22. 												$extrasql = " and pub_pri = '0'";
    23. 

  23. 											} else {
    24. 

  24. 												$extrasql = "";
    25. 

  25. 											}
    26. 

  26. 											
    27. 

  27. 											if($setting->show_num == 1){
    28. 

  28. 												$show = 1;
    29. 

  29. 											} else {
    30. 

  30. 												$show = 0;
    31. 

  31. 											}
    32. 

  32. 											
    33. 

  33. 											$output = "var TREE_ITEMS = [";
    34. 

  34. 											$output.= $cr . "['". $left_select_cat . "', '', {'tt' : '" . $left_select_cat_hover . "', 'sb':'Select A Category','hte':{'oncontextmenu':'return h_context_menu_root(o_tree_item)','style':'color:" . $left_select_cat_color . "'}},";
    35. 

  35. 						// level one output (main category)----------------------------------------
    36. 

  36. 												//$ca_result = mysql_query("SELECT title,id,pub_pri,rdmcode FROM photo_galleries where active = '1' and nest_under = '0'" . $extrasql . " order by galorder", $db);
    37. 

  37.                         
    38. 

  38.                         $ca_result = mysql_query("SELECT * FROM photo_galleries where active = '1' and nest_under = '0'" . $extrasql . " order by galorder", $db);
    39. 

  39.                         
    40. 

  40.                         
    41. 

  41. 												$ca_rows = mysql_num_rows($ca_result);
    42. 

  42. 												while($ca = mysql_fetch_object($ca_result)){
    43. 

  43. 													$title1 = $ca->title;
    44. 

  44.                           
    45. 

  45.                           if($_GET['lang'] != "English" )
    46. 

  46.                           {
    47. 

  47.                             if($ca->{'title_'.$_GET['lang']} != "")
    48. 

  48.                               $title1 = $ca->{'title_'.$_GET['lang']};
    49. 

  49.                           }
    50. 

  50. 													//addslashes($title1);
    51. 

  51. 													htmlspecialchars($title1);
    52. 

  52. 												$output.= $cr . "['" . addslashes($title1);
    53. 

  53. 											if($setting->show_num == 1){ 
    54. 

  54. 												$output.= imgcount($ca->id,1,0,$item_id,0,$setting->show_private);
    55. 

  55. 												$output.= " (" .$photo_rows_final . ")', ";
    56. 

  56. 												$photo_rows_final = 0;
    57. 

  57. 											} else {
    58. 

  58. 												$output.= "', ";
    59. 

  59. 											}
    60. 

  60. 												if($ca->pub_pri == 1){
    61. 

  61. 													$output.= "'" . $setting->site_url . "/pri.php?gid=" . $ca->id . "&gal=" . $ca->rdmcode . "',,";
    62. 

  62. 												} else {
    63. 

  63. 													
    64. 

  64. 													if($setting->modrw){
    65. 

  65. 														$output.= "'" . $setting->site_url . "/" . mod_clean($ca->title) . "_g" . $ca->id . ".html',,";
    66. 

  66. 													} else {
    67. 

  67. 														$output.= "'" . $setting->site_url . "/gallery.php?gid=" . $ca->id . "',,";
    68. 

  68. 													}
    69. 

  69. 												}
    70. 

  70.             // level two output (sub category)------------------------------------------
    71. 

  71.                         $ca2_result = mysql_query("SELECT title,id,pub_pri,rdmcode FROM photo_galleries where active = '1' and nest_under = '$ca->id'" . $extrasql . " order by galorder", $db);
    72. 

  72. 												$ca2_rows = mysql_num_rows($ca2_result);
    73. 

  73. 												if($ca2_rows == 0){
    74. 

  74. 												 	$output.= "],";
    75. 

  75. 												} else {
    76. 

  76. 												while($ca2 = mysql_fetch_object($ca2_result)){
    77. 

  77. 													$title2 = $ca2->title;
    78. 

  78. 													//addslashes($title2);
    79. 

  79. 													htmlspecialchars($title2);
    80. 

  80. 												$output.= $cr . "['" . addslashes($title2);
    81. 

  81. 											if($setting->show_num == 1){ 
    82. 

  82. 												$output.= imgcount($ca2->id,1,0,$item_id,0,$setting->show_private);
    83. 

  83. 												$output.= " (" .$photo_rows_final . ")', ";
    84. 

  84. 												$photo_rows_final = 0;
    85. 

  85. 											} else {
    86. 

  86. 												$output.= "', ";
    87. 

  87. 											}
    88. 

  88. 												if($ca2->pub_pri == 1){
    89. 

  89. 													$output.= "'" . $setting->site_url . "/pri.php?gid=" . $ca2->id . "&gal=" . $ca2->rdmcode . "',,";
    90. 

  90. 												} else {
    91. 

  91. 													//$output.= "'" . $setting->site_url . "/gallery.php?gid=" . $ca2->id . "',,";
    92. 

  92. 													
    93. 

  93. 													if($setting->modrw){
    94. 

  94. 														$output.= "'" . $setting->site_url . "/" . mod_clean($ca2->title) . "_g" . $ca2->id . ".html',,";
    95. 

  95. 													} else {
    96. 

  96. 														$output.= "'" . $setting->site_url . "/gallery.php?gid=" . $ca2->id . "',,";
    97. 

  97. 													}
    98. 

  98. 												} 
    99. 

  99. 						// level three output (sub sub category)-----------------------------------
    100. 

  100. 						            $ca3_result = mysql_query("SELECT title,id,pub_pri,rdmcode FROM photo_galleries where active = '1' and nest_under = '$ca2->id'" . $extrasql . " order by galorder", $db);
    101. 

  101. 												$ca3_rows = mysql_num_rows($ca3_result);
    102. 

  102. 												if($ca3_rows == 0){
    103. 

  103. 												 	$output.= "],";
    104. 

  104. 												} else {
    105. 

  105. 												while($ca3 = mysql_fetch_object($ca3_result)){
    106. 

  106. 													$title3 = $ca3->title;
    107. 

  107. 													//addslashes($title3);
    108. 

  108. 													htmlspecialchars($title3);
    109. 

  109. 												$output.= $cr . "['" . addslashes($title3);
    110. 

  110. 											if($setting->show_num == 1){
    111. 

  111. 												$output.= imgcount($ca3->id,1,0,$item_id,0,$setting->show_private);
    112. 

  112. 												$output.= " (" .$photo_rows_final . ")', ";
    113. 

  113. 												$photo_rows_final = 0;
    114. 

  114. 											} else {
    115. 

  115. 												$output.= "', ";
    116. 

  116. 											}
    117. 

  117. 												if($ca3->pub_pri == 1){
    118. 

  118. 													$output.= "'" . $setting->site_url . "/pri.php?gid=" . $ca3->id . "&gal=" . $ca3->rdmcode . "',,";
    119. 

  119. 												} else {
    120. 

  120. 													//$output.= "'" . $setting->site_url . "/gallery.php?gid=" . $ca3->id . "',,";
    121. 

  121. 													
    122. 

  122. 													if($setting->modrw){
    123. 

  123. 														$output.= "'" . $setting->site_url . "/" . mod_clean($ca3->title) . "_g" . $ca3->id . ".html',,";
    124. 

  124. 													} else {
    125. 

  125. 														$output.= "'" . $setting->site_url . "/gallery.php?gid=" . $ca3->id . "',,";
    126. 

  126. 													}
    127. 

  127. 												}
    128. 

  128. 						// level four output (sub sub sub category)--------------------------------
    129. 

  129. 						            $ca4_result = mysql_query("SELECT title,id,pub_pri,rdmcode FROM photo_galleries where active = '1' and nest_under = '$ca3->id'" . $extrasql . " order by galorder", $db);
    130. 

  130. 												$ca4_rows = mysql_num_rows($ca4_result);
    131. 

  131. 												if($ca4_rows == 0){
    132. 

  132. 												 	$output.= "],";
    133. 

  133. 												} else {
    134. 

  134. 												while($ca4 = mysql_fetch_object($ca4_result)){
    135. 

  135. 													$title4 = $ca4->title;
    136. 

  136. 													//addslashes($title4);
    137. 

  137. 													htmlspecialchars($title4);
    138. 

  138. 												$output.= $cr . "['" . addslashes($title4);
    139. 

  139. 											if($setting->show_num == 1){
    140. 

  140. 												$output.= imgcount($ca4->id,1,0,$item_id,0,$setting->show_private);
    141. 

  141. 												$output.= " (" .$photo_rows_final . ")', ";
    142. 

  142. 												$photo_rows_final = 0;
    143. 

  143. 											} else {
    144. 

  144. 												$output.= "', ";
    145. 

  145. 											}
    146. 

  146. 												if($ca4->pub_pri == 1){
    147. 

  147. 													$output.= "'" . $setting->site_url . "/pri.php?gid=" . $ca4->id . "&gal=" . $ca4->rdmcode . "',,";
    148. 

  148. 												} else {
    149. 

  149. 													//$output.= "'" . $setting->site_url . "/gallery.php?gid=" . $ca4->id . "',,";
    150. 

  150. 													
    151. 

  151. 													if($setting->modrw){
    152. 

  152. 														$output.= "'" . $setting->site_url . "/" . mod_clean($ca4->title) . "_g" . $ca4->id . ".html',,";
    153. 

  153. 													} else {
    154. 

  154. 														$output.= "'" . $setting->site_url . "/gallery.php?gid=" . $ca4->id . "',,";
    155. 

  155. 													}
    156. 

  156. 												}
    157. 

  157. 					 // level five output (sub sub sub sub category)------------------------------
    158. 

  158. 					 			        $ca5_result = mysql_query("SELECT title,id,pub_pri,rdmcode FROM photo_galleries where active = '1' and nest_under = '$ca4->id'" . $extrasql . " order by galorder", $db);
    159. 

  159. 												$ca5_rows = mysql_num_rows($ca5_result);
    160. 

  160. 												if($ca5_rows == 0){
    161. 

  161. 												 	$output.= "],";
    162. 

  162. 												} else {
    163. 

  163. 												while($ca5 = mysql_fetch_object($ca5_result)){
    164. 

  164. 													$title5 = $ca5->title;
    165. 

  165. 													//addslashes($title5);
    166. 

  166. 													htmlspecialchars($title5);
    167. 

  167. 												$output.= $cr . "['" . addslashes($title5);
    168. 

  168. 											if($setting->show_num == 1){
    169. 

  169. 												$output.= imgcount($ca5->id,1,0,$item_id,0,$setting->show_private);
    170. 

  170. 												$output.= " (" .$photo_rows_final . ")', ";
    171. 

  171. 												$photo_rows_final = 0;
    172. 

  172. 											} else {
    173. 

  173. 												$output.= "', ";
    174. 

  174. 											}
    175. 

  175. 												if($ca5->pub_pri == 1){
    176. 

  176. 													$output.= "'" . $setting->site_url . "/pri.php?gid=" . $ca5->id . "&gal=" . $ca5->rdmcode . "'],";
    177. 

  177. 												} else {
    178. 

  178. 													//$output.= "'" . $setting->site_url . "/gallery.php?gid=" . $ca5->id . "'],";
    179. 

  179. 													
    180. 

  180. 													if($setting->modrw){
    181. 

  181. 														$output.= "'" . $setting->site_url . "/" . mod_clean($ca5->title) . "_g" . $ca5->id . ".html'],";
    182. 

  182. 													} else {
    183. 

  183. 														$output.= "'" . $setting->site_url . "/gallery.php?gid=" . $ca5->id . "'],";
    184. 

  184. 													}
    185. 

  185. 												}
    186. 

  186. 											}
    187. 

  187. 											$output.= $cr . "],";
    188. 

  188. 										}
    189. 

  189. 											}
    190. 

  190. 											$output.= $cr . "],";
    191. 

  191. 										}
    192. 

  192. 										
    193. 

  193. 											}
    194. 

  194. 											$output.= $cr . "],";
    195. 

  195. 										}
    196. 

  196. 											}
    197. 

  197. 											$output.= $cr . "],";
    198. 

  198. 										}
    199. 

  199. 										  }
    200. 

  200. 							$output.= $cr . "]";
    201. 

  201. 							$output.= $cr . "];";
    202. 

  202. 							     
    203. 

  203. 										$filename = '../js/tree_items_'.$_GET['lang'].'.js';
    204. 

  204.                     //if(!file_exists($filename))
    205. 

  205.                       fopen($filename, 'a+');
    206. 

  206. 										$content = $output;
    207. 

  207. 										if (is_writable($filename)) {
    208. 

  208. 										if (!$handle = fopen($filename, 'a+')) {
    209. 

  209.          							echo "Cannot open file ($filename)";
    210. 

  210.          						exit;
    211. 

  211.    									}
    212. 

  212. 										if (fwrite($handle, $content) === FALSE) {
    213. 

  213.        								echo "<html>";
    214. 

  214. 											echo "<body>";
    215. 

  215.        								echo "Cannot write to file ($filename) check the folder permission<br>";
    216. 

  216.        								echo "<font face=\"arial\" size=\"2\"><a href=\"javascript:window.close()\">There was an issue writing to file, do you wish to close this window?</a></font>";
    217. 

  217. 											echo "</body>";
    218. 

  218. 											echo "</html>";		
    219. 

  219.        							exit;
    220. 

  220.    									}
    221. 

  221.    									echo "<html>";
    222. 

  222. 										echo "<body>";
    223. 

  223.        							echo "Success, wrote menu to file ($filename)<br>";  
    224. 

  224.        							echo "<font face=\"arial\" size=\"2\"><a href=\"javascript:window.close()\">The menu was created successfully, do you wish to close this window?</a></font>";
    225. 

  225. 										echo "</body>";
    226. 

  226. 										echo "</html>";		 
    227. 

  227.    									fclose($handle);
    228. 

  228. 									} else {
    229. 

  229.    									echo "The file $filename is not writable check the file permission";
    230. 

  230. 								}
    231. 

  231. ?>
    232.