Просмотр файла admin/admin_ranks.php

Конкурс дизайнеров на 15000 рублей
Скрипты | CMS | Боты
Размер файла: 8.53Kb 
  1. <?php
  2. /***************************************************************************
  3.  *                                mides.ru
  4.  *                            -------------------
  5.  ***************************************************************************/
  6. if( !empty($setmodules) )
  7. {
  8. 	$file = basename(__FILE__);
  9. 	$module['Users']['Ranks'] = $file;
  10. 	return;
  11. }
  12.  
  13. define('IN_PHPBB', 1);
  14.  
  15. $phpbb_root_path = "./../";
  16. require($phpbb_root_path . 'extension.inc');
  17.  
  18. $cancel = ( isset($HTTP_POST_VARS['cancel']) || isset($_POST['cancel']) ) ? true : false;
  19. $no_page_header = $cancel;
  20.  
  21. require('./pagestart.' . $phpEx);
  22.  
  23.  
  24. if ($cancel)
  25. {
  26. 	redirect('admin/' . append_sid("admin_ranks.$phpEx", true));
  27. }
  28.  
  29. if( isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']) )
  30. {
  31. 	$mode = (isset($HTTP_GET_VARS['mode'])) ? $HTTP_GET_VARS['mode'] : $HTTP_POST_VARS['mode'];
  32. 	$mode = htmlspecialchars($mode);
  33. }
  34. else 
  35. {
  36.  
  37. 	if( isset($HTTP_POST_VARS['add']) )
  38. 	{
  39. 		$mode = "add";
  40. 	}
  41. 	else if( isset($HTTP_POST_VARS['save']) )
  42. 	{
  43. 		$mode = "save";
  44. 	}
  45. 	else
  46. 	{
  47. 		$mode = "";
  48. 	}
  49. }
  50.  
  51. $mode = ( in_array($mode, array('add', 'edit', 'save', 'delete')) ) ? $mode : '';
  52.  
  53. if( $mode != "" )
  54. {
  55. 	if( $mode == "edit" || $mode == "add" )
  56. 	{
  57.  
  58. 		$rank_id = ( isset($HTTP_GET_VARS['id']) ) ? intval($HTTP_GET_VARS['id']) : 0;
  59. 		
  60. 		$s_hidden_fields = "";
  61. 		
  62. 		if( $mode == "edit" )
  63. 		{
  64. 			if( empty($rank_id) )
  65. 			{
  66. 				message_die(GENERAL_MESSAGE, $lang['Must_select_rank']);
  67. 			}
  68.  
  69. 			$sql = "SELECT * FROM " . RANKS_TABLE . "
  70. 				WHERE rank_id = $rank_id";
  71. 			if(!$result = $db->sql_query($sql))
  72. 			{
  73. 				message_die(GENERAL_ERROR, "Couldn't obtain rank data", "", __LINE__, __FILE__, $sql);
  74. 			}
  75. 			
  76. 			$rank_info = $db->sql_fetchrow($result);
  77. 			$s_hidden_fields .= '<input type="hidden" name="id" value="' . $rank_id . '" />';
  78.  
  79. 		}
  80. 		else
  81. 		{
  82. 			$rank_info['rank_special'] = 0;
  83. 		}
  84.  
  85. 		$s_hidden_fields .= '<input type="hidden" name="mode" value="save" />';
  86.  
  87. 		$rank_is_special = ( $rank_info['rank_special'] ) ? "checked=\"checked\"" : "";
  88. 		$rank_is_not_special = ( !$rank_info['rank_special'] ) ? "checked=\"checked\"" : "";
  89. 		
  90. 		$template->set_filenames(array(
  91. 			"body" => "admin/ranks_edit_body.tpl")
  92. 		);
  93.  
  94. 		$template->assign_vars(array(
  95. 			"RANK" => $rank_info['rank_title'],
  96. 			"SPECIAL_RANK" => $rank_is_special,
  97. 			"NOT_SPECIAL_RANK" => $rank_is_not_special,
  98. 			"MINIMUM" => ( $rank_is_special ) ? "" : $rank_info['rank_min'],
  99. 			"IMAGE" => ( $rank_info['rank_image'] != "" ) ? $rank_info['rank_image'] : "",
  100. 			"IMAGE_DISPLAY" => ( $rank_info['rank_image'] != "" ) ? '<img src="../' . $rank_info['rank_image'] . '" />' : "",
  101. 			
  102. 			"L_RANKS_TITLE" => $lang['Ranks_title'],
  103. 			"L_RANKS_TEXT" => $lang['Ranks_explain'],
  104. 			"L_RANK_TITLE" => $lang['Rank_title'],
  105. 			"L_RANK_SPECIAL" => $lang['Rank_special'],
  106. 			"L_RANK_MINIMUM" => $lang['Rank_minimum'],
  107. 			"L_RANK_IMAGE" => $lang['Rank_image'],
  108. 			"L_RANK_IMAGE_EXPLAIN" => $lang['Rank_image_explain'],
  109. 			"L_SUBMIT" => $lang['Submit'],
  110. 			"L_RESET" => $lang['Reset'],
  111. 			"L_YES" => $lang['Yes'],
  112. 			"L_NO" => $lang['No'],
  113. 			
  114. 			"S_RANK_ACTION" => append_sid("admin_ranks.$phpEx"),
  115. 			"S_HIDDEN_FIELDS" => $s_hidden_fields)
  116. 		);
  117. 		
  118. 	}
  119. 	else if( $mode == "save" )
  120. 	{
  121.  
  122. 		$rank_id = ( isset($HTTP_POST_VARS['id']) ) ? intval($HTTP_POST_VARS['id']) : 0;
  123. 		$rank_title = ( isset($HTTP_POST_VARS['title']) ) ? trim($HTTP_POST_VARS['title']) : "";
  124. 		$special_rank = ( $HTTP_POST_VARS['special_rank'] == 1 ) ? TRUE : 0;
  125. 		$min_posts = ( isset($HTTP_POST_VARS['min_posts']) ) ? intval($HTTP_POST_VARS['min_posts']) : -1;
  126. 		$rank_image = ( (isset($HTTP_POST_VARS['rank_image'])) ) ? trim($HTTP_POST_VARS['rank_image']) : "";
  127.  
  128. 		if( $rank_title == "" )
  129. 		{
  130. 			message_die(GENERAL_MESSAGE, $lang['Must_select_rank']);
  131. 		}
  132.  
  133. 		if( $special_rank == 1 )
  134. 		{
  135. 			$max_posts = -1;
  136. 			$min_posts = -1;
  137. 		}
  138.  
  139. 		if($rank_image != "")
  140. 		{
  141. 			if ( !preg_match("/(\.gif|\.png|\.jpg)$/is", $rank_image))
  142. 			{
  143. 				$rank_image = "";
  144. 			}
  145. 		}
  146.  
  147. 		if ($rank_id)
  148. 		{
  149. 			if (!$special_rank)
  150. 			{
  151. 				$sql = "UPDATE " . USERS_TABLE . " 
  152. 					SET user_rank = 0 
  153. 					WHERE user_rank = $rank_id";
  154.  
  155. 				if( !$result = $db->sql_query($sql) ) 
  156. 				{
  157. 					message_die(GENERAL_ERROR, $lang['No_update_ranks'], "", __LINE__, __FILE__, $sql);
  158. 				}
  159. 			}
  160. 			$sql = "UPDATE " . RANKS_TABLE . "
  161. 				SET rank_title = '" . str_replace("\'", "''", $rank_title) . "', rank_special = $special_rank, rank_min = $min_posts, rank_image = '" . str_replace("\'", "''", $rank_image) . "'
  162. 				WHERE rank_id = $rank_id";
  163.  
  164. 			$message = $lang['Rank_updated'];
  165. 		}
  166. 		else
  167. 		{
  168. 			$sql = "INSERT INTO " . RANKS_TABLE . " (rank_title, rank_special, rank_min, rank_image)
  169. 				VALUES ('" . str_replace("\'", "''", $rank_title) . "', $special_rank, $min_posts, '" . str_replace("\'", "''", $rank_image) . "')";
  170.  
  171. 			$message = $lang['Rank_added'];
  172. 		}
  173. 		
  174. 		if( !$result = $db->sql_query($sql) )
  175. 		{
  176. 			message_die(GENERAL_ERROR, "Couldn't update/insert into ranks table", "", __LINE__, __FILE__, $sql);
  177. 		}
  178.  
  179. 		$message .= "<br /><br />" . sprintf($lang['Click_return_rankadmin'], "<a href=\"" . append_sid("admin_ranks.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");
  180.  
  181. 		message_die(GENERAL_MESSAGE, $message);
  182.  
  183. 	}
  184. 	else if( $mode == "delete" )
  185. 	{
  186. 	
  187. 		if( isset($HTTP_POST_VARS['id']) || isset($HTTP_GET_VARS['id']) )
  188. 		{
  189. 			$rank_id = ( isset($HTTP_POST_VARS['id']) ) ? intval($HTTP_POST_VARS['id']) : intval($HTTP_GET_VARS['id']);
  190. 		}
  191. 		else
  192. 		{
  193. 			$rank_id = 0;
  194. 		}
  195.  
  196. 		$confirm = isset($HTTP_POST_VARS['confirm']);
  197. 		
  198. 		if( $rank_id && $confirm )
  199. 		{
  200. 			$sql = "DELETE FROM " . RANKS_TABLE . "
  201. 				WHERE rank_id = $rank_id";
  202. 			
  203. 			if( !$result = $db->sql_query($sql) )
  204. 			{
  205. 				message_die(GENERAL_ERROR, "Couldn't delete rank data", "", __LINE__, __FILE__, $sql);
  206. 			}
  207. 			
  208. 			$sql = "UPDATE " . USERS_TABLE . " 
  209. 				SET user_rank = 0 
  210. 				WHERE user_rank = $rank_id";
  211.  
  212. 			if( !$result = $db->sql_query($sql) ) 
  213. 			{
  214. 				message_die(GENERAL_ERROR, $lang['No_update_ranks'], "", __LINE__, __FILE__, $sql);
  215. 			}
  216.  
  217. 			$message = $lang['Rank_removed'] . "<br /><br />" . sprintf($lang['Click_return_rankadmin'], "<a href=\"" . append_sid("admin_ranks.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");
  218.  
  219. 			message_die(GENERAL_MESSAGE, $message);
  220.  
  221. 		}
  222. 		elseif( $rank_id && !$confirm)
  223. 		{
  224. 			$template->set_filenames(array(
  225. 				'body' => 'admin/confirm_body.tpl')
  226. 			);
  227.  
  228. 			$hidden_fields = '<input type="hidden" name="mode" value="delete" /><input type="hidden" name="id" value="' . $rank_id . '" />';
  229.  
  230. 			$template->assign_vars(array(
  231. 				'MESSAGE_TITLE' => $lang['Confirm'],
  232. 				'MESSAGE_TEXT' => $lang['Confirm_delete_rank'],
  233.  
  234. 				'L_YES' => $lang['Yes'],
  235. 				'L_NO' => $lang['No'],
  236.  
  237. 				'S_CONFIRM_ACTION' => append_sid("admin_ranks.$phpEx"),
  238. 				'S_HIDDEN_FIELDS' => $hidden_fields)
  239. 			);
  240. 		}
  241. 		else
  242. 		{
  243. 			message_die(GENERAL_MESSAGE, $lang['Must_select_rank']);
  244. 		}
  245. 	}
  246.  
  247. 	$template->pparse("body");
  248.  
  249. 	include('./page_footer_admin.'.$phpEx);
  250. }
  251.  
  252. $template->set_filenames(array(
  253. 	"body" => "admin/ranks_list_body.tpl")
  254. );
  255.  
  256. $sql = "SELECT * FROM " . RANKS_TABLE . "
  257. 	ORDER BY rank_min ASC, rank_special ASC";
  258. if( !$result = $db->sql_query($sql) )
  259. {
  260. 	message_die(GENERAL_ERROR, "Couldn't obtain ranks data", "", __LINE__, __FILE__, $sql);
  261. }
  262. $rank_count = $db->sql_numrows($result);
  263.  
  264. $rank_rows = $db->sql_fetchrowset($result);
  265.  
  266. $template->assign_vars(array(
  267. 	"L_RANKS_TITLE" => $lang['Ranks_title'],
  268. 	"L_RANKS_TEXT" => $lang['Ranks_explain'],
  269. 	"L_RANK" => $lang['Rank_title'],
  270. 	"L_RANK_MINIMUM" => $lang['Rank_minimum'],
  271. 	"L_SPECIAL_RANK" => $lang['Rank_special'],
  272. 	"L_EDIT" => $lang['Edit'],
  273. 	"L_DELETE" => $lang['Delete'],
  274. 	"L_ADD_RANK" => $lang['Add_new_rank'],
  275. 	"L_ACTION" => $lang['Action'],
  276. 	
  277. 	"S_RANKS_ACTION" => append_sid("admin_ranks.$phpEx"))
  278. );
  279.  
  280. for($i = 0; $i < $rank_count; $i++)
  281. {
  282. 	$rank = $rank_rows[$i]['rank_title'];
  283. 	$special_rank = $rank_rows[$i]['rank_special'];
  284. 	$rank_id = $rank_rows[$i]['rank_id'];
  285. 	$rank_min = $rank_rows[$i]['rank_min'];
  286. 	
  287. 	if( $special_rank == 1 )
  288. 	{
  289. 		$rank_min = $rank_max = "-";
  290. 	}
  291.  
  292. 	$row_class = ( !($i % 2) ) ? 'row_easy' : 'row_hard';
  293.  
  294. 	$rank_is_special = ( $special_rank ) ? $lang['Yes'] : $lang['No'];
  295. 	
  296. 	$template->assign_block_vars("ranks", array(
  297. 		"ROW_CLASS" => $row_class,
  298. 		"RANK" => $rank,
  299. 		"SPECIAL_RANK" => $rank_is_special,
  300. 		"RANK_MIN" => $rank_min,
  301.  
  302. 		"U_RANK_EDIT" => append_sid("admin_ranks.$phpEx?mode=edit&amp;id=$rank_id"),
  303. 		"U_RANK_DELETE" => append_sid("admin_ranks.$phpEx?mode=delete&amp;id=$rank_id"))
  304. 	);
  305. }
  306.  
  307. $template->pparse("body");
  308.  
  309. include('./page_footer_admin.'.$phpEx);
  310.  
  311. ?>