2 /***************************************************************************
5 * begin : Thursday, Jul 12, 2001
6 * copyright : (C) 2001 The phpBB Group
7 * email : support@phpbb.com
9 * $Id: admin_board.php,v 1.51.2.13 2005/12/29 11:51:11 acydburn Exp $
12 ***************************************************************************/
14 define('IN_PHPBB', 1);
16 if( !empty($setmodules) )
18 $file = basename(__FILE__);
19 $module['General']['Configuration'] = $file;
24 // Let's set the root dir for phpBB
26 $phpbb_root_path = "./../";
27 require($phpbb_root_path . 'extension.inc');
28 require('./pagestart.' . $phpEx);
29 include($phpbb_root_path . 'includes/functions_selects.'.$phpEx);
32 // Pull all config data
35 FROM " . CONFIG_TABLE;
36 if(!$result = $db->sql_query($sql))
38 message_die(CRITICAL_ERROR, "Could not query config information in admin_board", "", __LINE__, __FILE__, $sql);
42 while( $row = $db->sql_fetchrow($result) )
44 $config_name = $row['config_name'];
45 $config_value = $row['config_value'];
46 $default_config[$config_name] = isset($HTTP_POST_VARS['submit']) ? str_replace("'", "\'", $config_value) : $config_value;
48 $new[$config_name] = ( isset($HTTP_POST_VARS[$config_name]) ) ? $HTTP_POST_VARS[$config_name] : $default_config[$config_name];
50 if ($config_name == 'cookie_name')
52 $cookie_name = str_replace('.', '_', $new['cookie_name']);
55 if( isset($HTTP_POST_VARS['submit']) )
57 $sql = "UPDATE " . CONFIG_TABLE . " SET
58 config_value = '" . str_replace("\'", "''", $new[$config_name]) . "'
59 WHERE config_name = '$config_name'";
60 if( !$db->sql_query($sql) )
62 message_die(GENERAL_ERROR, "Failed to update general configuration for $config_name", "", __LINE__, __FILE__, $sql);
67 if( isset($HTTP_POST_VARS['submit']) )
69 $message = $lang['Config_updated'] . "<br /><br />" . sprintf($lang['Click_return_config'], "<a href=\"" . append_sid("admin_board.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");
71 message_die(GENERAL_MESSAGE, $message);
75 $style_select = style_select($new['default_style'], 'default_style', "../templates");
76 $lang_select = language_select($new['default_lang'], 'default_lang', "language");
77 $timezone_select = tz_select($new['board_timezone'], 'board_timezone');
79 $disable_board_yes = ( $new['board_disable'] ) ? "checked=\"checked\"" : "";
80 $disable_board_no = ( !$new['board_disable'] ) ? "checked=\"checked\"" : "";
82 $cookie_secure_yes = ( $new['cookie_secure'] ) ? "checked=\"checked\"" : "";
83 $cookie_secure_no = ( !$new['cookie_secure'] ) ? "checked=\"checked\"" : "";
85 $html_tags = $new['allow_html_tags'];
87 $override_user_style_yes = ( $new['override_user_style'] ) ? "checked=\"checked\"" : "";
88 $override_user_style_no = ( !$new['override_user_style'] ) ? "checked=\"checked\"" : "";
90 $html_yes = ( $new['allow_html'] ) ? "checked=\"checked\"" : "";
91 $html_no = ( !$new['allow_html'] ) ? "checked=\"checked\"" : "";
93 $bbcode_yes = ( $new['allow_bbcode'] ) ? "checked=\"checked\"" : "";
94 $bbcode_no = ( !$new['allow_bbcode'] ) ? "checked=\"checked\"" : "";
96 $activation_none = ( $new['require_activation'] == USER_ACTIVATION_NONE ) ? "checked=\"checked\"" : "";
97 $activation_user = ( $new['require_activation'] == USER_ACTIVATION_SELF ) ? "checked=\"checked\"" : "";
98 $activation_admin = ( $new['require_activation'] == USER_ACTIVATION_ADMIN ) ? "checked=\"checked\"" : "";
100 $confirm_yes = ($new['enable_confirm']) ? 'checked="checked"' : '';
101 $confirm_no = (!$new['enable_confirm']) ? 'checked="checked"' : '';
103 $allow_autologin_yes = ($new['allow_autologin']) ? 'checked="checked"' : '';
104 $allow_autologin_no = (!$new['allow_autologin']) ? 'checked="checked"' : '';
106 $board_email_form_yes = ( $new['board_email_form'] ) ? "checked=\"checked\"" : "";
107 $board_email_form_no = ( !$new['board_email_form'] ) ? "checked=\"checked\"" : "";
109 $gzip_yes = ( $new['gzip_compress'] ) ? "checked=\"checked\"" : "";
110 $gzip_no = ( !$new['gzip_compress'] ) ? "checked=\"checked\"" : "";
112 $privmsg_on = ( !$new['privmsg_disable'] ) ? "checked=\"checked\"" : "";
113 $privmsg_off = ( $new['privmsg_disable'] ) ? "checked=\"checked\"" : "";
115 $prune_yes = ( $new['prune_enable'] ) ? "checked=\"checked\"" : "";
116 $prune_no = ( !$new['prune_enable'] ) ? "checked=\"checked\"" : "";
118 $smile_yes = ( $new['allow_smilies'] ) ? "checked=\"checked\"" : "";
119 $smile_no = ( !$new['allow_smilies'] ) ? "checked=\"checked\"" : "";
121 $sig_yes = ( $new['allow_sig'] ) ? "checked=\"checked\"" : "";
122 $sig_no = ( !$new['allow_sig'] ) ? "checked=\"checked\"" : "";
124 $namechange_yes = ( $new['allow_namechange'] ) ? "checked=\"checked\"" : "";
125 $namechange_no = ( !$new['allow_namechange'] ) ? "checked=\"checked\"" : "";
127 $avatars_local_yes = ( $new['allow_avatar_local'] ) ? "checked=\"checked\"" : "";
128 $avatars_local_no = ( !$new['allow_avatar_local'] ) ? "checked=\"checked\"" : "";
129 $avatars_remote_yes = ( $new['allow_avatar_remote'] ) ? "checked=\"checked\"" : "";
130 $avatars_remote_no = ( !$new['allow_avatar_remote'] ) ? "checked=\"checked\"" : "";
131 $avatars_upload_yes = ( $new['allow_avatar_upload'] ) ? "checked=\"checked\"" : "";
132 $avatars_upload_no = ( !$new['allow_avatar_upload'] ) ? "checked=\"checked\"" : "";
134 $smtp_yes = ( $new['smtp_delivery'] ) ? "checked=\"checked\"" : "";
135 $smtp_no = ( !$new['smtp_delivery'] ) ? "checked=\"checked\"" : "";
137 $template->set_filenames(array(
138 "body" => "admin/board_config_body.tpl")
142 // Escape any quotes in the site description for proper display in the text
143 // box on the admin page
145 $new['site_desc'] = str_replace('"', '"', $new['site_desc']);
146 $new['sitename'] = str_replace('"', '"', strip_tags($new['sitename']));
147 $template->assign_vars(array(
148 "S_CONFIG_ACTION" => append_sid("admin_board.$phpEx"),
150 "L_YES" => $lang['Yes'],
151 "L_NO" => $lang['No'],
152 "L_CONFIGURATION_TITLE" => $lang['General_Config'],
153 "L_CONFIGURATION_EXPLAIN" => $lang['Config_explain'],
154 "L_GENERAL_SETTINGS" => $lang['General_settings'],
155 "L_SERVER_NAME" => $lang['Server_name'],
156 "L_SERVER_NAME_EXPLAIN" => $lang['Server_name_explain'],
157 "L_SERVER_PORT" => $lang['Server_port'],
158 "L_SERVER_PORT_EXPLAIN" => $lang['Server_port_explain'],
159 "L_SCRIPT_PATH" => $lang['Script_path'],
160 "L_SCRIPT_PATH_EXPLAIN" => $lang['Script_path_explain'],
161 "L_SITE_NAME" => $lang['Site_name'],
162 "L_SITE_DESCRIPTION" => $lang['Site_desc'],
163 "L_DISABLE_BOARD" => $lang['Board_disable'],
164 "L_DISABLE_BOARD_EXPLAIN" => $lang['Board_disable_explain'],
165 "L_ACCT_ACTIVATION" => $lang['Acct_activation'],
166 "L_NONE" => $lang['Acc_None'],
167 "L_USER" => $lang['Acc_User'],
168 "L_ADMIN" => $lang['Acc_Admin'],
169 "L_VISUAL_CONFIRM" => $lang['Visual_confirm'],
170 "L_VISUAL_CONFIRM_EXPLAIN" => $lang['Visual_confirm_explain'],
171 "L_ALLOW_AUTOLOGIN" => $lang['Allow_autologin'],
172 "L_ALLOW_AUTOLOGIN_EXPLAIN" => $lang['Allow_autologin_explain'],
173 "L_AUTOLOGIN_TIME" => $lang['Autologin_time'],
174 "L_AUTOLOGIN_TIME_EXPLAIN" => $lang['Autologin_time_explain'],
175 "L_COOKIE_SETTINGS" => $lang['Cookie_settings'],
176 "L_COOKIE_SETTINGS_EXPLAIN" => $lang['Cookie_settings_explain'],
177 "L_COOKIE_DOMAIN" => $lang['Cookie_domain'],
178 "L_COOKIE_NAME" => $lang['Cookie_name'],
179 "L_COOKIE_PATH" => $lang['Cookie_path'],
180 "L_COOKIE_SECURE" => $lang['Cookie_secure'],
181 "L_COOKIE_SECURE_EXPLAIN" => $lang['Cookie_secure_explain'],
182 "L_SESSION_LENGTH" => $lang['Session_length'],
183 "L_PRIVATE_MESSAGING" => $lang['Private_Messaging'],
184 "L_INBOX_LIMIT" => $lang['Inbox_limits'],
185 "L_SENTBOX_LIMIT" => $lang['Sentbox_limits'],
186 "L_SAVEBOX_LIMIT" => $lang['Savebox_limits'],
187 "L_DISABLE_PRIVATE_MESSAGING" => $lang['Disable_privmsg'],
188 "L_ENABLED" => $lang['Enabled'],
189 "L_DISABLED" => $lang['Disabled'],
190 "L_ABILITIES_SETTINGS" => $lang['Abilities_settings'],
191 "L_MAX_POLL_OPTIONS" => $lang['Max_poll_options'],
192 "L_FLOOD_INTERVAL" => $lang['Flood_Interval'],
193 "L_FLOOD_INTERVAL_EXPLAIN" => $lang['Flood_Interval_explain'],
195 'L_MAX_LOGIN_ATTEMPTS' => $lang['Max_login_attempts'],
196 'L_MAX_LOGIN_ATTEMPTS_EXPLAIN' => $lang['Max_login_attempts_explain'],
197 'L_LOGIN_RESET_TIME' => $lang['Login_reset_time'],
198 'L_LOGIN_RESET_TIME_EXPLAIN' => $lang['Login_reset_time_explain'],
199 'MAX_LOGIN_ATTEMPTS' => $new['max_login_attempts'],
200 'LOGIN_RESET_TIME' => $new['login_reset_time'],
202 "L_BOARD_EMAIL_FORM" => $lang['Board_email_form'],
203 "L_BOARD_EMAIL_FORM_EXPLAIN" => $lang['Board_email_form_explain'],
204 "L_TOPICS_PER_PAGE" => $lang['Topics_per_page'],
205 "L_POSTS_PER_PAGE" => $lang['Posts_per_page'],
206 "L_HOT_THRESHOLD" => $lang['Hot_threshold'],
207 "L_DEFAULT_STYLE" => $lang['Default_style'],
208 "L_OVERRIDE_STYLE" => $lang['Override_style'],
209 "L_OVERRIDE_STYLE_EXPLAIN" => $lang['Override_style_explain'],
210 "L_DEFAULT_LANGUAGE" => $lang['Default_language'],
211 "L_DATE_FORMAT" => $lang['Date_format'],
212 "L_SYSTEM_TIMEZONE" => $lang['System_timezone'],
213 "L_ENABLE_GZIP" => $lang['Enable_gzip'],
214 "L_ENABLE_PRUNE" => $lang['Enable_prune'],
215 "L_ALLOW_HTML" => $lang['Allow_HTML'],
216 "L_ALLOW_BBCODE" => $lang['Allow_BBCode'],
217 "L_ALLOWED_TAGS" => $lang['Allowed_tags'],
218 "L_ALLOWED_TAGS_EXPLAIN" => $lang['Allowed_tags_explain'],
219 "L_ALLOW_SMILIES" => $lang['Allow_smilies'],
220 "L_SMILIES_PATH" => $lang['Smilies_path'],
221 "L_SMILIES_PATH_EXPLAIN" => $lang['Smilies_path_explain'],
222 "L_ALLOW_SIG" => $lang['Allow_sig'],
223 "L_MAX_SIG_LENGTH" => $lang['Max_sig_length'],
224 "L_MAX_SIG_LENGTH_EXPLAIN" => $lang['Max_sig_length_explain'],
225 "L_ALLOW_NAME_CHANGE" => $lang['Allow_name_change'],
226 "L_AVATAR_SETTINGS" => $lang['Avatar_settings'],
227 "L_ALLOW_LOCAL" => $lang['Allow_local'],
228 "L_ALLOW_REMOTE" => $lang['Allow_remote'],
229 "L_ALLOW_REMOTE_EXPLAIN" => $lang['Allow_remote_explain'],
230 "L_ALLOW_UPLOAD" => $lang['Allow_upload'],
231 "L_MAX_FILESIZE" => $lang['Max_filesize'],
232 "L_MAX_FILESIZE_EXPLAIN" => $lang['Max_filesize_explain'],
233 "L_MAX_AVATAR_SIZE" => $lang['Max_avatar_size'],
234 "L_MAX_AVATAR_SIZE_EXPLAIN" => $lang['Max_avatar_size_explain'],
235 "L_AVATAR_STORAGE_PATH" => $lang['Avatar_storage_path'],
236 "L_AVATAR_STORAGE_PATH_EXPLAIN" => $lang['Avatar_storage_path_explain'],
237 "L_AVATAR_GALLERY_PATH" => $lang['Avatar_gallery_path'],
238 "L_AVATAR_GALLERY_PATH_EXPLAIN" => $lang['Avatar_gallery_path_explain'],
239 "L_COPPA_SETTINGS" => $lang['COPPA_settings'],
240 "L_COPPA_FAX" => $lang['COPPA_fax'],
241 "L_COPPA_MAIL" => $lang['COPPA_mail'],
242 "L_COPPA_MAIL_EXPLAIN" => $lang['COPPA_mail_explain'],
243 "L_EMAIL_SETTINGS" => $lang['Email_settings'],
244 "L_ADMIN_EMAIL" => $lang['Admin_email'],
245 "L_EMAIL_SIG" => $lang['Email_sig'],
246 "L_EMAIL_SIG_EXPLAIN" => $lang['Email_sig_explain'],
247 "L_USE_SMTP" => $lang['Use_SMTP'],
248 "L_USE_SMTP_EXPLAIN" => $lang['Use_SMTP_explain'],
249 "L_SMTP_SERVER" => $lang['SMTP_server'],
250 "L_SMTP_USERNAME" => $lang['SMTP_username'],
251 "L_SMTP_USERNAME_EXPLAIN" => $lang['SMTP_username_explain'],
252 "L_SMTP_PASSWORD" => $lang['SMTP_password'],
253 "L_SMTP_PASSWORD_EXPLAIN" => $lang['SMTP_password_explain'],
254 "L_SUBMIT" => $lang['Submit'],
255 "L_RESET" => $lang['Reset'],
257 "SERVER_NAME" => $new['server_name'],
258 "SCRIPT_PATH" => $new['script_path'],
259 "SERVER_PORT" => $new['server_port'],
260 "SITENAME" => $new['sitename'],
261 "SITE_DESCRIPTION" => $new['site_desc'],
262 "S_DISABLE_BOARD_YES" => $disable_board_yes,
263 "S_DISABLE_BOARD_NO" => $disable_board_no,
264 "ACTIVATION_NONE" => USER_ACTIVATION_NONE,
265 "ACTIVATION_NONE_CHECKED" => $activation_none,
266 "ACTIVATION_USER" => USER_ACTIVATION_SELF,
267 "ACTIVATION_USER_CHECKED" => $activation_user,
268 "ACTIVATION_ADMIN" => USER_ACTIVATION_ADMIN,
269 "ACTIVATION_ADMIN_CHECKED" => $activation_admin,
270 "CONFIRM_ENABLE" => $confirm_yes,
271 "CONFIRM_DISABLE" => $confirm_no,
272 'ALLOW_AUTOLOGIN_YES' => $allow_autologin_yes,
273 'ALLOW_AUTOLOGIN_NO' => $allow_autologin_no,
274 'AUTOLOGIN_TIME' => (int) $new['max_autologin_time'],
275 "BOARD_EMAIL_FORM_ENABLE" => $board_email_form_yes,
276 "BOARD_EMAIL_FORM_DISABLE" => $board_email_form_no,
277 "MAX_POLL_OPTIONS" => $new['max_poll_options'],
278 "FLOOD_INTERVAL" => $new['flood_interval'],
279 "TOPICS_PER_PAGE" => $new['topics_per_page'],
280 "POSTS_PER_PAGE" => $new['posts_per_page'],
281 "HOT_TOPIC" => $new['hot_threshold'],
282 "STYLE_SELECT" => $style_select,
283 "OVERRIDE_STYLE_YES" => $override_user_style_yes,
284 "OVERRIDE_STYLE_NO" => $override_user_style_no,
285 "LANG_SELECT" => $lang_select,
286 "L_DATE_FORMAT_EXPLAIN" => $lang['Date_format_explain'],
287 "DEFAULT_DATEFORMAT" => $new['default_dateformat'],
288 "TIMEZONE_SELECT" => $timezone_select,
289 "S_PRIVMSG_ENABLED" => $privmsg_on,
290 "S_PRIVMSG_DISABLED" => $privmsg_off,
291 "INBOX_LIMIT" => $new['max_inbox_privmsgs'],
292 "SENTBOX_LIMIT" => $new['max_sentbox_privmsgs'],
293 "SAVEBOX_LIMIT" => $new['max_savebox_privmsgs'],
294 "COOKIE_DOMAIN" => $new['cookie_domain'],
295 "COOKIE_NAME" => $new['cookie_name'],
296 "COOKIE_PATH" => $new['cookie_path'],
297 "SESSION_LENGTH" => $new['session_length'],
298 "S_COOKIE_SECURE_ENABLED" => $cookie_secure_yes,
299 "S_COOKIE_SECURE_DISABLED" => $cookie_secure_no,
300 "GZIP_YES" => $gzip_yes,
301 "GZIP_NO" => $gzip_no,
302 "PRUNE_YES" => $prune_yes,
303 "PRUNE_NO" => $prune_no,
304 "HTML_TAGS" => $html_tags,
305 "HTML_YES" => $html_yes,
306 "HTML_NO" => $html_no,
307 "BBCODE_YES" => $bbcode_yes,
308 "BBCODE_NO" => $bbcode_no,
309 "SMILE_YES" => $smile_yes,
310 "SMILE_NO" => $smile_no,
311 "SIG_YES" => $sig_yes,
313 "SIG_SIZE" => $new['max_sig_chars'],
314 "NAMECHANGE_YES" => $namechange_yes,
315 "NAMECHANGE_NO" => $namechange_no,
316 "AVATARS_LOCAL_YES" => $avatars_local_yes,
317 "AVATARS_LOCAL_NO" => $avatars_local_no,
318 "AVATARS_REMOTE_YES" => $avatars_remote_yes,
319 "AVATARS_REMOTE_NO" => $avatars_remote_no,
320 "AVATARS_UPLOAD_YES" => $avatars_upload_yes,
321 "AVATARS_UPLOAD_NO" => $avatars_upload_no,
322 "AVATAR_FILESIZE" => $new['avatar_filesize'],
323 "AVATAR_MAX_HEIGHT" => $new['avatar_max_height'],
324 "AVATAR_MAX_WIDTH" => $new['avatar_max_width'],
325 "AVATAR_PATH" => $new['avatar_path'],
326 "AVATAR_GALLERY_PATH" => $new['avatar_gallery_path'],
327 "SMILIES_PATH" => $new['smilies_path'],
328 "INBOX_PRIVMSGS" => $new['max_inbox_privmsgs'],
329 "SENTBOX_PRIVMSGS" => $new['max_sentbox_privmsgs'],
330 "SAVEBOX_PRIVMSGS" => $new['max_savebox_privmsgs'],
331 "EMAIL_FROM" => $new['board_email'],
332 "EMAIL_SIG" => $new['board_email_sig'],
333 "SMTP_YES" => $smtp_yes,
334 "SMTP_NO" => $smtp_no,
335 "SMTP_HOST" => $new['smtp_host'],
336 "SMTP_USERNAME" => $new['smtp_username'],
337 "SMTP_PASSWORD" => $new['smtp_password'],
338 "COPPA_MAIL" => $new['coppa_mail'],
339 "COPPA_FAX" => $new['coppa_fax'])
342 $template->pparse("body");
344 include('./page_footer_admin.'.$phpEx);