source: Kopie - forum/admin/admin_ranks.php@ 5

Last change on this file since 5 was 5, checked in by george, 18 years ago

import
File size: 9.5 KB
Line 
1<?php
2/***************************************************************************
3 * admin_ranks.php
4 * -------------------
5 * begin : Thursday, Jul 12, 2001
6 * copyright : (C) 2001 The phpBB Group
7 * email : support@phpbb.com
8 *
9 * $Id: admin_ranks.php,v 1.13.2.7 2006/01/23 19:47:19 grahamje Exp $
10 *
11 ***************************************************************************/
12
13/***************************************************************************
14 *
15 * This program is free software; you can redistribute it and/or modify
16 * it under the terms of the GNU General Public License as published by
17 * the Free Software Foundation; either version 2 of the License, or
18 * (at your option) any later version.
19 *
20 ***************************************************************************/
21
22if( !empty($setmodules) )
23{
24 $file = basename(__FILE__);
25 $module['Users']['Ranks'] = $file;
26 return;
27}
28
29define('IN_PHPBB', 1);
30
31//
32// Let's set the root dir for phpBB
33//
34$phpbb_root_path = "./../";
35require($phpbb_root_path . 'extension.inc');
36require('./pagestart.' . $phpEx);
37
38if( isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']) )
39{
40 $mode = (isset($HTTP_GET_VARS['mode'])) ? $HTTP_GET_VARS['mode'] : $HTTP_POST_VARS['mode'];
41 $mode = htmlspecialchars($mode);
42}
43else
44{
45 //
46 // These could be entered via a form button
47 //
48 if( isset($HTTP_POST_VARS['add']) )
49 {
50 $mode = "add";
51 }
52 else if( isset($HTTP_POST_VARS['save']) )
53 {
54 $mode = "save";
55 }
56 else
57 {
58 $mode = "";
59 }
60}
61
62// Restrict mode input to valid options
63$mode = ( in_array($mode, array('add', 'edit', 'save', 'delete')) ) ? $mode : '';
64
65if( $mode != "" )
66{
67 if( $mode == "edit" || $mode == "add" )
68 {
69 //
70 // They want to add a new rank, show the form.
71 //
72 $rank_id = ( isset($HTTP_GET_VARS['id']) ) ? intval($HTTP_GET_VARS['id']) : 0;
73
74 $s_hidden_fields = "";
75
76 if( $mode == "edit" )
77 {
78 if( empty($rank_id) )
79 {
80 message_die(GENERAL_MESSAGE, $lang['Must_select_rank']);
81 }
82
83 $sql = "SELECT * FROM " . RANKS_TABLE . "
84 WHERE rank_id = $rank_id";
85 if(!$result = $db->sql_query($sql))
86 {
87 message_die(GENERAL_ERROR, "Couldn't obtain rank data", "", __LINE__, __FILE__, $sql);
88 }
89
90 $rank_info = $db->sql_fetchrow($result);
91 $s_hidden_fields .= '<input type="hidden" name="id" value="' . $rank_id . '" />';
92
93 }
94 else
95 {
96 $rank_info['rank_special'] = 0;
97 }
98
99 $s_hidden_fields .= '<input type="hidden" name="mode" value="save" />';
100
101 $rank_is_special = ( $rank_info['rank_special'] ) ? "checked=\"checked\"" : "";
102 $rank_is_not_special = ( !$rank_info['rank_special'] ) ? "checked=\"checked\"" : "";
103
104 $template->set_filenames(array(
105 "body" => "admin/ranks_edit_body.tpl")
106 );
107
108 $template->assign_vars(array(
109 "RANK" => $rank_info['rank_title'],
110 "SPECIAL_RANK" => $rank_is_special,
111 "NOT_SPECIAL_RANK" => $rank_is_not_special,
112 "MINIMUM" => ( $rank_is_special ) ? "" : $rank_info['rank_min'],
113 "IMAGE" => ( $rank_info['rank_image'] != "" ) ? $rank_info['rank_image'] : "",
114 "IMAGE_DISPLAY" => ( $rank_info['rank_image'] != "" ) ? '<img src="../' . $rank_info['rank_image'] . '" />' : "",
115
116 "L_RANKS_TITLE" => $lang['Ranks_title'],
117 "L_RANKS_TEXT" => $lang['Ranks_explain'],
118 "L_RANK_TITLE" => $lang['Rank_title'],
119 "L_RANK_SPECIAL" => $lang['Rank_special'],
120 "L_RANK_MINIMUM" => $lang['Rank_minimum'],
121 "L_RANK_IMAGE" => $lang['Rank_image'],
122 "L_RANK_IMAGE_EXPLAIN" => $lang['Rank_image_explain'],
123 "L_SUBMIT" => $lang['Submit'],
124 "L_RESET" => $lang['Reset'],
125 "L_YES" => $lang['Yes'],
126 "L_NO" => $lang['No'],
127
128 "S_RANK_ACTION" => append_sid("admin_ranks.$phpEx"),
129 "S_HIDDEN_FIELDS" => $s_hidden_fields)
130 );
131
132 }
133 else if( $mode == "save" )
134 {
135 //
136 // Ok, they sent us our info, let's update it.
137 //
138
139 $rank_id = ( isset($HTTP_POST_VARS['id']) ) ? intval($HTTP_POST_VARS['id']) : 0;
140 $rank_title = ( isset($HTTP_POST_VARS['title']) ) ? trim($HTTP_POST_VARS['title']) : "";
141 $special_rank = ( $HTTP_POST_VARS['special_rank'] == 1 ) ? TRUE : 0;
142 $min_posts = ( isset($HTTP_POST_VARS['min_posts']) ) ? intval($HTTP_POST_VARS['min_posts']) : -1;
143 $rank_image = ( (isset($HTTP_POST_VARS['rank_image'])) ) ? trim($HTTP_POST_VARS['rank_image']) : "";
144
145 if( $rank_title == "" )
146 {
147 message_die(GENERAL_MESSAGE, $lang['Must_select_rank']);
148 }
149
150 if( $special_rank == 1 )
151 {
152 $max_posts = -1;
153 $min_posts = -1;
154 }
155
156 //
157 // The rank image has to be a jpg, gif or png
158 //
159 if($rank_image != "")
160 {
161 if ( !preg_match("/(\.gif|\.png|\.jpg)$/is", $rank_image))
162 {
163 $rank_image = "";
164 }
165 }
166
167 if ($rank_id)
168 {
169 if (!$special_rank)
170 {
171 $sql = "UPDATE " . USERS_TABLE . "
172 SET user_rank = 0
173 WHERE user_rank = $rank_id";
174
175 if( !$result = $db->sql_query($sql) )
176 {
177 message_die(GENERAL_ERROR, $lang['No_update_ranks'], "", __LINE__, __FILE__, $sql);
178 }
179 }
180 $sql = "UPDATE " . RANKS_TABLE . "
181 SET rank_title = '" . str_replace("\'", "''", $rank_title) . "', rank_special = $special_rank, rank_min = $min_posts, rank_image = '" . str_replace("\'", "''", $rank_image) . "'
182 WHERE rank_id = $rank_id";
183
184 $message = $lang['Rank_updated'];
185 }
186 else
187 {
188 $sql = "INSERT INTO " . RANKS_TABLE . " (rank_title, rank_special, rank_min, rank_image)
189 VALUES ('" . str_replace("\'", "''", $rank_title) . "', $special_rank, $min_posts, '" . str_replace("\'", "''", $rank_image) . "')";
190
191 $message = $lang['Rank_added'];
192 }
193
194 if( !$result = $db->sql_query($sql) )
195 {
196 message_die(GENERAL_ERROR, "Couldn't update/insert into ranks table", "", __LINE__, __FILE__, $sql);
197 }
198
199 $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>");
200
201 message_die(GENERAL_MESSAGE, $message);
202
203 }
204 else if( $mode == "delete" )
205 {
206 //
207 // Ok, they want to delete their rank
208 //
209
210 if( isset($HTTP_POST_VARS['id']) || isset($HTTP_GET_VARS['id']) )
211 {
212 $rank_id = ( isset($HTTP_POST_VARS['id']) ) ? intval($HTTP_POST_VARS['id']) : intval($HTTP_GET_VARS['id']);
213 }
214 else
215 {
216 $rank_id = 0;
217 }
218
219 $confirm = isset($HTTP_POST_VARS['confirm']);
220
221 if( $rank_id && $confirm )
222 {
223 $sql = "DELETE FROM " . RANKS_TABLE . "
224 WHERE rank_id = $rank_id";
225
226 if( !$result = $db->sql_query($sql) )
227 {
228 message_die(GENERAL_ERROR, "Couldn't delete rank data", "", __LINE__, __FILE__, $sql);
229 }
230
231 $sql = "UPDATE " . USERS_TABLE . "
232 SET user_rank = 0
233 WHERE user_rank = $rank_id";
234
235 if( !$result = $db->sql_query($sql) )
236 {
237 message_die(GENERAL_ERROR, $lang['No_update_ranks'], "", __LINE__, __FILE__, $sql);
238 }
239
240 $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>");
241
242 message_die(GENERAL_MESSAGE, $message);
243
244 }
245 elseif( $rank_id && !$confirm)
246 {
247 // Present the confirmation screen to the user
248 $template->set_filenames(array(
249 'body' => 'admin/confirm_body.tpl')
250 );
251
252 $hidden_fields = '<input type="hidden" name="mode" value="delete" /><input type="hidden" name="id" value="' . $rank_id . '" />';
253
254 $template->assign_vars(array(
255 'MESSAGE_TITLE' => $lang['Confirm'],
256 'MESSAGE_TEXT' => $lang['Confirm_delete_rank'],
257
258 'L_YES' => $lang['Yes'],
259 'L_NO' => $lang['No'],
260
261 'S_CONFIRM_ACTION' => append_sid("admin_ranks.$phpEx"),
262 'S_HIDDEN_FIELDS' => $hidden_fields)
263 );
264 }
265 else
266 {
267 message_die(GENERAL_MESSAGE, $lang['Must_select_rank']);
268 }
269 }
270
271 $template->pparse("body");
272
273 include('./page_footer_admin.'.$phpEx);
274}
275
276//
277// Show the default page
278//
279$template->set_filenames(array(
280 "body" => "admin/ranks_list_body.tpl")
281);
282
283$sql = "SELECT * FROM " . RANKS_TABLE . "
284 ORDER BY rank_min ASC, rank_special ASC";
285if( !$result = $db->sql_query($sql) )
286{
287 message_die(GENERAL_ERROR, "Couldn't obtain ranks data", "", __LINE__, __FILE__, $sql);
288}
289$rank_count = $db->sql_numrows($result);
290
291$rank_rows = $db->sql_fetchrowset($result);
292
293$template->assign_vars(array(
294 "L_RANKS_TITLE" => $lang['Ranks_title'],
295 "L_RANKS_TEXT" => $lang['Ranks_explain'],
296 "L_RANK" => $lang['Rank_title'],
297 "L_RANK_MINIMUM" => $lang['Rank_minimum'],
298 "L_SPECIAL_RANK" => $lang['Rank_special'],
299 "L_EDIT" => $lang['Edit'],
300 "L_DELETE" => $lang['Delete'],
301 "L_ADD_RANK" => $lang['Add_new_rank'],
302 "L_ACTION" => $lang['Action'],
303
304 "S_RANKS_ACTION" => append_sid("admin_ranks.$phpEx"))
305);
306
307for($i = 0; $i < $rank_count; $i++)
308{
309 $rank = $rank_rows[$i]['rank_title'];
310 $special_rank = $rank_rows[$i]['rank_special'];
311 $rank_id = $rank_rows[$i]['rank_id'];
312 $rank_min = $rank_rows[$i]['rank_min'];
313
314 if( $special_rank == 1 )
315 {
316 $rank_min = $rank_max = "-";
317 }
318
319 $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
320 $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
321
322 $rank_is_special = ( $special_rank ) ? $lang['Yes'] : $lang['No'];
323
324 $template->assign_block_vars("ranks", array(
325 "ROW_COLOR" => "#" . $row_color,
326 "ROW_CLASS" => $row_class,
327 "RANK" => $rank,
328 "SPECIAL_RANK" => $rank_is_special,
329 "RANK_MIN" => $rank_min,
330
331 "U_RANK_EDIT" => append_sid("admin_ranks.$phpEx?mode=edit&amp;id=$rank_id"),
332 "U_RANK_DELETE" => append_sid("admin_ranks.$phpEx?mode=delete&amp;id=$rank_id"))
333 );
334}
335
336$template->pparse("body");
337
338include('./page_footer_admin.'.$phpEx);
339
340?>
Note: See TracBrowser for help on using the repository browser.