- <td class="row1"><select name="banlength"><?php echo $ban_end_options; ?></select>&nbsp; <input type="text" name="banlengthother" maxlength="10" size="10" /></td>

- <td class="row1"><input type="text" name="banreason" maxlength="255" size="40" /></td>

- set_config($config_name, stripslashes($new[$config_name]));

- <td class="row2"><input type="text" maxlength="255" name="cookie_domain" value="<?php echo $new['cookie_domain']; ?>" /></td>

- <td class="row2"><input type="text" maxlength="16" name="cookie_name" value="<?php echo $new['cookie_name']; ?>" /></td>

- <td class="row2"><input type="text" maxlength="255" name="cookie_path" value="<?php echo $new['cookie_path']; ?>" /></td>

- <td class="row2"><input type="text" size="4" maxlength="10" name="avatar_filesize" value="<?php echo $new['avatar_filesize']; ?>" /> Bytes</td>

- <td class="row2"><input type="text" size="3" maxlength="4" name="avatar_max_height" value="<?php echo $new['avatar_max_height']; ?>" /> x <input type="text" size="3" maxlength="4" name="avatar_max_width" value="<?php echo $new['avatar_max_width']; ?>"></td>

- <td class="row2"><input type="text" size="20" maxlength="255" name="avatar_path" value="<?php echo $new['avatar_path']; ?>" /></td>

- <td class="row2"><input type="text" size="20" maxlength="255" name="avatar_gallery_path" value="<?php echo $new['avatar_gallery_path']; ?>" /></td>

- <td class="row2"><input type="text" name="default_dateformat" value="<?php echo $new['default_dateformat']; ?>" /></td>

- <td class="row2"><input type="text" size="4" maxlength="4" name="max_post_chars" value="<?php echo $new['max_post_chars']; ?>" /></td>

- <td class="row2"><input type="text" size="4" maxlength="4" name="max_post_smilies" value="<?php echo $new['max_post_smilies']; ?>" /></td>

- <td class="row2"><input type="text" size="4" maxlength="4" name="max_quote_depth" value="<?php echo $new['max_quote_depth']; ?>" /></td>

- <td class="row2"><input type="text" size="30" maxlength="255" name="allow_html_tags" value="<?php echo $new['allow_html_tags']; ?>" /></td>

- <td class="row2"><input type="text" size="5" maxlength="4" name="max_sig_chars" value="<?php echo $new['max_sig_chars']; ?>" /></td>

- <td class="row2"><input type="text" size="40" maxlength="255" name="sitename" value="<?php echo htmlentities($new['sitename']); ?>" /></td>

- <td class="row2"><input type="text" size="40" maxlength="255" name="site_desc" value="<?php echo htmlentities($new['site_desc']); ?>" /></td>

- <td class="row2"><input type="radio" name="board_disable" value="1" <?php echo $disable_board_yes; ?> /> <?php echo $user->lang['YES']; ?>&nbsp;&nbsp;<input type="radio" name="board_disable" value="0" <?php echo $disable_board_no; ?> /> <?php echo $user->lang['NO']; ?><br /><input type="text" name="board_disable_msg" maxlength="255" size="40" value="<?php echo $new['board_disable_msg']; ?>" /></td>

- <td class="row2"><input type="text" size="25" maxlength="100" name="coppa_fax" value="<?php echo $new['coppa_fax']; ?>" /></td>

- <td class="row2"><input type="text" maxlength="4" size="4" name="pm_max_boxes" value="<?php echo $new['pm_max_boxes']; ?>" /></td>

- <td class="row2"><input type="text" maxlength="4" size="4" name="pm_max_msgs" value="<?php echo $new['pm_max_msgs']; ?>" /></td>

- <td class="row2"><input type="text" maxlength="3" size="3" name="edit_time" value="<?php echo $new['edit_time']; ?>" /></td>

- <td class="row2"><input type="text" size="3" maxlength="4" name="flood_interval" value="<?php echo $new['flood_interval']; ?>" /></td>

- <td class="row2"><input type="text" size="3" maxlength="3" name="min_search_chars" value="<?php echo $new['min_search_chars']; ?>" /></td>

- <td class="row2"><input type="text" size="3" maxlength="3" name="max_search_chars" value="<?php echo $new['max_search_chars']; ?>" /></td>

- <td class="row2"><input type="text" name="topics_per_page" size="3" maxlength="4" value="<?php echo $new['topics_per_page']; ?>" /></td>

- <td class="row2"><input type="text" name="posts_per_page" size="3" maxlength="4" value="<?php echo $new['posts_per_page']; ?>" /></td>

- <td class="row2"><input type="text" name="hot_threshold" size="3" maxlength="4" value="<?php echo $new['hot_threshold']; ?>" /></td>

- <td class="row2"><input type="text" name="max_poll_options" size="4" maxlength="4" value="<?php echo $new['max_poll_options']; ?>" /></td>

- <td class="row2"><input type="text" size="25" maxlength="100" name="board_contact" value="<?php echo $new['board_contact']; ?>" /></td>

- <td class="row2"><input type="text" size="25" maxlength="100" name="board_email" value="<?php echo $new['board_email']; ?>" /></td>

- <td class="row2"><input type="text" name="smtp_host" value="<?php echo $new['smtp_host']; ?>" size="25" maxlength="50" /></td>

- <td class="row2"><input type="text" name="smtp_port" value="<?php echo $new['smtp_port']; ?>" size="4" maxlength="5" /></td>

- <td class="row2"><input type="text" name="smtp_username" value="<?php echo $new['smtp_username']; ?>" size="25" maxlength="255" /></td>

- <td class="row2"><input type="password" name="smtp_password" value="<?php echo $new['smtp_password']; ?>" size="25" maxlength="255" /></td>

- <td class="row2"><input type="text" maxlength="255" size="40" name="server_name" value="<?php echo $new['server_name']; ?>" /></td>

- <td class="row2"><input type="text" maxlength="5" size="5" name="server_port" value="<?php echo $new['server_port']; ?>" /></td>

- <td class="row2"><input type="text" maxlength="255" name="script_path" value="<?php echo $new['script_path']; ?>" /></td>

- <td class="row2"><input type="text" size="20" maxlength="255" name="smilies_path" value="<?php echo $new['smilies_path']; ?>" /></td>

- <td class="row2"><input type="text" size="20" maxlength="255" name="icons_path" value="<?php echo $new['icons_path']; ?>" /></td>

- <td class="row2"><input type="text" size="4" maxlength="4" name="limit_load" value="<?php echo $new['limit_load']; ?>" /></td>

- <td class="row2"><input type="text" maxlength="5" size="5" name="session_length" value="<?php echo $new['session_length']; ?>" /></td>

- <td class="row2"><input type="text" size="4" maxlength="4" name="active_sessions" value="<?php echo $new['active_sessions']; ?>" /></td>

- <td class="row2"><input type="text" size="4" maxlength="3" name="load_online_time" value="<?php echo $new['load_online_time']; ?>" /></td>

- <td class="row2"><input type="text" size="3" maxlength="4" name="search_interval" value="<?php echo $new['search_interval']; ?>" /></td>

- <td class="<?php echo $row_class; ?>" align="center" nowrap="nowrap">&nbsp;<a href="admin_groups.<?php echo "$phpEx$SID&amp;action=add&amp;g=$group_id"; ?>"><?php echo $user->lang['ADD']; ?></a> | <a href="admin_groups.<?php echo "$phpEx$SID&amp;action=edit&amp;g=$group_id"; ?>"><?php echo $user->lang['EDIT']; ?></a><?php

- <td class="row2"><input type="text" name="code" value="<?php echo (!empty($data['code'])) ? $data['code'] : '' ?>" /></td>

- <td class="row2"><input type="text" name="emotion" value="<?php echo (!empty($data['emoticon'])) ? $data['emoticon'] : '' ?>" /></td>

- <td class="row1"><input type="text" size="3" name="width" value="<?php echo (!empty($data[$fields .'_width'])) ? $data[$fields .'_width'] : '' ?>" /></td>

- <td class="row2"><input type="text" size="3" name="height" value="<?php echo (!empty($data[$fields .'_height'])) ? $data[$fields .'_height'] : '' ?>" /></td>

- <td class="row2"><input type="text" name="word" value="<?php echo $word_info['word']; ?>" /></td>

- <td class="row2"><input type="text" name="replacement" value="<?php echo $word_info['replacement']; ?>" /></td>

-/* Fancy form styles for IE */

-input, textarea, select {

- border-width: 1px;

-input {

- text-indent: 2px;

- line-height: 18px

- $sql = (isset($_POST['activate'])) ? "UPDATE " . USERS_TABLE . " SET user_active = 1 WHERE user_id IN ($in_sql)" : "DELETE FROM " . USERS_TABLE . " WHERE user_id IN ($in_sql)";

- $emailer->email_address($row['user_email']);

- $sql = "SELECT user_id, username, user_regdate

- FROM " . USERS_TABLE . "

- AND user_id <> " . ANONYMOUS . "

- ORDER BY user_regdate ASC";

-require_once($phpbb_root_path . 'includes/functions_admin.'.$phpEx);

- font: 8pt Verdana, Arial, Helvetica, sans-serif;

- font: bold 11px;

-

-/* Import the fancy styles for IE only (NS4.x doesn't use the @import function) */

-@import url("forms.css");

-define('USER_AVATAR_NONE', 0);

-define('USER_AVATAR_UPLOAD', 1);

-define('USER_AVATAR_REMOTE', 2);

-define('USER_AVATAR_GALLERY', 3);

- 'post_encoding' => $user->lang['ENCODING']

- ));

- $sql = "SELECT * FROM " . POLL_OPTIONS_TABLE . "

- WHERE topic_id = " . $post_data['topic_id'] . "

- ORDER BY poll_option_id";

- $sql = "INSERT INTO " . POLL_OPTIONS_TABLE . " (poll_option_id, topic_id, poll_option_text)

- VALUES (" . $i . ", " . $post_data['topic_id'] . ", '" . $db->sql_escape($poll['poll_options'][$i]) . "')";

- WHERE poll_option_id = " . $cur_poll_options[$i]['poll_option_id'];

- $sql = "DELETE FROM " . POLL_OPTIONS_TABLE . "

- WHERE poll_option_id > " . sizeof($poll['poll_options']) . "

- AND topic_id = " . $post_data['topic_id'];

- $sql = "SELECT group_name

- FROM " . GROUPS_TABLE . "

- $sql = "SELECT disallow_username

- FROM " . DISALLOW_TABLE;

- $sql = "SELECT word

- FROM " . WORDS_TABLE;

- global $db, $user;

-

- if ($email != '')

- if (preg_match('#^[a-z0-9\.\-_\+]+@(.*?\.)*?[a-z0-9\-_]+\.[a-z]+$#is', $email))

- $sql = "SELECT ban_email

- FROM " . BANLIST_TABLE;

- $result = $db->sql_query($sql);

-

- while ($row = $db->sql_fetchrow($result))

- if (preg_match('#^' . str_replace('*', '.*?', $row['ban_email']) . '$#is', $email))

- {

- return 'EMAIL_BANNED';

- }

- $db->sql_freeresult($result);

-

- $sql = "SELECT user_email

- FROM " . USERS_TABLE . "

-

- return false;

- function update_user($userdata)

-

-

- echo $sql = "SELECT w.word_id, w.word_text, m.title_match

- *

-

-

-*/

- 'user_viewemail' => $data['viewemail'],

- $view_email = (isset($viewemail)) ? $viewemail : $user->data['user_viewemail'];

- 'username' => '2,30',

- 'password_confirm' => '6,255',

- 'new_password' => '6,255',

- 'cur_password' => '6,255',

- 'cur_password' => ($data['new_password'] || $data['email'] != $user->data['user_email']) ? $user->data['user_password'] : '',

- 'USERNAME' => (isset($username)) ? $username : $user->data['username'],

- 'EMAIL' => (isset($email)) ? $email : $user->data['user_email'],

- 'NEW_PASSWORD' => (isset($new_password)) ? $new_password : '',

- 'PASSWORD_CONFIRM' => (isset($password_confirm)) ? $password_confirm : '',

- $dir = @opendir($config['avatar_gallery_path']);

-

- $avatar_images = array();

- while( $file = @readdir($dir) )

- if( $file != '.' && $file != '..' && !is_file($config['avatar_gallery_path'] . '/' . $file) && !is_link($config['avatar_gallery_path'] . '/' . $file) )

- $sub_dir = @opendir($config['avatar_gallery_path'] . '/' . $file);

-

- $avatar_row_count = 0;

- $avatar_col_count = 0;

- while( $sub_file = @readdir($sub_dir) )

- {

- if( preg_match('#(\.gif$|\.png$|\.jpg|\.jpeg)$#i', $sub_file) )

- {

- $avatar_images[$file][$avatar_row_count][$avatar_col_count] = $file . '/' . $sub_file;

- $avatar_name[$file][$avatar_row_count][$avatar_col_count] = ucfirst(str_replace("_", " ", preg_replace('/^(.*)\..*$/', '\1', $sub_file)));

-

- $avatar_col_count++;

- if( $avatar_col_count == 4 )

- {

- $avatar_row_count++;

- $avatar_col_count = 0;

- }

- }

- }

- }

- @closedir($dir);

- @ksort($avatar_images);

- @reset($avatar_images);

- $category = (isset($_POST['avatarcat'])) ? htmlspecialchars($_POST['avatarcat']) : '';

- if( empty($category) )

- {

- list($category, ) = each($avatar_images);

- }

- @reset($avatar_images);

- $s_categories = '';

- while( list($key) = each($avatar_images) )

- {

- $selected = ( $key == $category ) ? ' selected="selected"' : '';

- if( count($avatar_images[$key]) )

- {

- $s_categories .= '<option value="' . $key . '"' . $selected . '>' . ucfirst($key) . '</option>';

- $s_colspan = 0;

- for($i = 0; $i < count($avatar_images[$category]); $i++)

- $s_colspan = max($s_colspan, count($avatar_images[$category][$i]));

-

- for($j = 0; $j < count($avatar_images[$category][$i]); $j++)

- "AVATAR_IMAGE" => $config['avatar_gallery_path'] . '/' . $avatar_images[$category][$i][$j],

- "AVATAR_NAME" => $avatar_name[$category][$i][$j])

- "S_OPTIONS_AVATAR" => $avatar_images[$category][$i][$j])

- 'AVATAR' => '<img src="images/avatars/upload/' . $user->data['user_avatar'] . '" />',

- 'S_AVATAR_CAT_OPTIONS' => $s_categories,

- 'S_GALLERY_AVATAR' => true,)

- function check_image_type(&$type)

- {

- global $user;

-

- switch ($type)

- {

- case 'jpeg':

- case 'pjpeg':

- case 'jpg':

- return '.jpg';

- case 'gif':

- return '.gif';

- case 'png':

- return '.png';

- case 'bmp':

- return '.bmp';

- }

-

- $this->error[] = $user->lang['INVALID_IMAGETYPE'];

- return false;

- }

- 'username' => '2,30',

- 'new_password' => '6,255',

- 'password_confirm' => '6,255',

- 'lang' => '1,50',

- 'confirm_code' => '6,6'

- if ($coppa && ($config['require_activation'] == USER_ACTIVATION_SELF ||

- $config['require_activation'] == USER_ACTIVATION_ADMIN))

- 'user_password' => $data['new_password'],

- // Place into appropriate group, either REGISTERED or INACTIVE depending on config

- $group_name = ($config['require_activation'] == USER_ACTIVATION_NONE) ? 'REGISTERED' : 'INACTIVE';

- if ($coppa)

- else if ($config['require_activation'] == USER_ACTIVATION_SELF)

- else if ($config['require_activation'] == USER_ACTIVATION_ADMIN)

-

- if ($config['require_activation'] == USER_ACTIVATION_NONE)

- if ($row['attempts'] > 5)

- 'L_CONFIRM_EXPLAIN' => sprintf($user->lang['CONFIRM_EXPLAIN'], '<a href="mailto:' . htmlentities($config['board_contact']) . '">', '</a>'),

- 'L_ITEMS_REQUIRED' => $l_reg_cond,

- 'BIRTHDAY_LIST' => ($birthday_list) ? $birthday_list : $user->lang['NO_BIRTHDAYS'],

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','30');

-INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_quote_depth', '10');

-INSERT INTO phpbb_auth_options (auth_option, is_local) VALUES ('f_votechg', 1);

-INSERT INTO phpbb_styles_imageset (imageset_id, imageset_name, imageset_path, btn_post, btn_post_pm, btn_reply, btn_reply_pm, btn_locked, btn_profile, btn_pm, btn_delete, btn_ip, btn_quote, btn_search, btn_edit, btn_report, btn_email, btn_www, btn_icq, btn_aim, btn_yim, btn_msnm, btn_no_email, btn_no_www, btn_no_icq, btn_no_aim, btn_no_yim, btn_no_msnm, btn_online, btn_offline, btn_topic_watch, btn_topic_unwatch, icon_unapproved, icon_reported, icon_attach, icon_post, icon_post_new, icon_post_latest, icon_post_newest, forum, forum_new, forum_locked, sub_forum, sub_forum_new, folder, folder_posted, folder_new, folder_new_posted, folder_hot, folder_hot_posted, folder_hot_new, folder_hot_new_posted, folder_locked, folder_locked_posted, folder_locked_new, folder_locked_new_posted, folder_sticky, folder_sticky_posted, folder_sticky_new, folder_sticky_new_posted, folder_announce, folder_announce_posted, folder_announce_new, folder_announce_new_posted, poll_left, poll_center, poll_right) VALUES (1, 'subSilver &copy; phpBB Group', 'subSilver', '"imagesets/subSilver/{LANG}/btn_post.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_post_pm.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_reply.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/reply.gif" width="88" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_locked.gif" width="82" height="25" border="0"', '"imagesets/subSilver/{LANG}/btn_profile.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_pm.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_delete.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_ip.gif" width="16" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_quote.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_search.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_edit.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_report.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_email.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_www.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_icq.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_aim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_yim.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_msnm.gif" width="59" height="18" border="0"', '', '', '', '', '', '', '"imagesets/subSilver/{LANG}/btn_online.gif" width="59" height="18" border="0"', '"imagesets/subSilver/{LANG}/btn_offline.gif" width="59" height="18" border="0"', NULL, NULL, '"imagesets/subSilver/icon_unapproved.gif" width="19" height="18" border="0"', '"imagesets/subSilver/icon_reported.gif" width="19" height="18" border="0"', '"imagesets/subSilver/icon_attach.gif" width="14" height="18" border="0"', '"imagesets/subSilver/icon_minipost.gif" width="12" height="9" border="0"', '"imagesets/subSilver/icon_minipost_new.gif" width="12" height="9" border="0"', '"imagesets/subSilver/icon_latest_reply.gif" width="18" height="9" border="0"', '"imagesets/subSilver/icon_newest_reply.gif" width="18" height="9" border="0"', '"imagesets/subSilver/folder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder_new_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder_locked_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/subfolder_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/subfolder_new_big.gif" width="46" height="25" border="0"', '"imagesets/subSilver/folder.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_new_hot_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_lock_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_sticky_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new.gif" width="19" height="18" border="0"', '"imagesets/subSilver/folder_announce_new_posted.gif" width="19" height="18" border="0"', '"imagesets/subSilver/vote_lcap.gif" width="4" height="12" border="0"', '"imagesets/subSilver/voting_bar.gif" height="12" border="0"', '"imagesets/subSilver/vote_rcap.gif" width="4" height="12" border="0"');

- reason_name varchar(255) NOT NULL default '',

- session_id varchar(32) NOT NULL default '',

- word_text varchar(50) binary NOT NULL default '',

- imageset_name varchar(100) default NULL,

- imageset_path varchar(30) default NULL,

- btn_post varchar(200) default NULL,

- btn_post_pm varchar(200) default NULL,

- btn_reply varchar(200) default NULL,

- btn_reply_pm varchar(200) default NULL,

- btn_locked varchar(200) default NULL,

- btn_profile varchar(200) default NULL,

- btn_pm varchar(200) default NULL,

- btn_delete varchar(200) default NULL,

- btn_ip varchar(200) default NULL,

- btn_quote varchar(200) default NULL,

- btn_search varchar(200) default NULL,

- btn_edit varchar(200) default NULL,

- btn_report varchar(200) default NULL,

- btn_email varchar(200) default NULL,

- btn_www varchar(200) default NULL,

- btn_icq varchar(200) default NULL,

- btn_aim varchar(200) default NULL,

- btn_yim varchar(200) default NULL,

- btn_msnm varchar(200) default NULL,

- btn_no_email varchar(200) default '',

- btn_no_www varchar(200) default '',

- btn_no_icq varchar(200) default '',

- btn_no_aim varchar(200) default '',

- btn_no_yim varchar(200) default '',

- btn_no_msnm varchar(200) default '',

- btn_online varchar(200) default '',

- btn_offline varchar(200) default '',

- btn_topic_watch varchar(200) default NULL,

- btn_topic_unwatch varchar(200) default NULL,

- icon_unapproved varchar(200) NOT NULL default '',

- icon_reported varchar(200) NOT NULL default '',

- icon_attach varchar(200) default '',

- icon_post varchar(200) default NULL,

- icon_post_new varchar(200) default NULL,

- icon_post_latest varchar(200) default NULL,

- icon_post_newest varchar(200) default NULL,

- forum varchar(200) default NULL,

- forum_new varchar(200) default NULL,

- forum_locked varchar(200) default NULL,

- sub_forum varchar(200) default NULL,

- sub_forum_new varchar(200) default NULL,

- folder varchar(200) default NULL,

- folder_posted varchar(200) NOT NULL default '',

- folder_new varchar(200) default NULL,

- folder_new_posted varchar(200) NOT NULL default '',

- folder_hot varchar(200) default NULL,

- folder_hot_posted varchar(200) NOT NULL default '',

- folder_hot_new varchar(200) default NULL,

- folder_hot_new_posted varchar(200) NOT NULL default '',

- folder_locked varchar(200) default NULL,

- folder_locked_posted varchar(200) NOT NULL default '',

- folder_locked_new varchar(200) default NULL,

- folder_locked_new_posted varchar(200) NOT NULL default '',

- folder_sticky varchar(200) default NULL,

- folder_sticky_posted varchar(200) NOT NULL default '',

- folder_sticky_new varchar(200) default NULL,

- folder_sticky_new_posted varchar(200) NOT NULL default '',

- folder_announce varchar(200) default NULL,

- folder_announce_posted varchar(200) NOT NULL default '',

- folder_announce_new varchar(200) default NULL,

- folder_announce_new_posted varchar(200) NOT NULL default '',

- poll_left varchar(200) default NULL,

- poll_center varchar(200) default NULL,

- poll_right varchar(200) default NULL,

- PRIMARY KEY (imageset_id)

- user_avatar_type tinyint(4) DEFAULT '0' NOT NULL,

- 'OVERRIDE_STYLE_EXPLAIN' => 'Replaces users style with the default',

- 'QUOTE_DEPTH_LIMIT' => 'Max nested quotes in posts',

- 'ALLOWED_TAGS_EXPLAIN' => 'Separate tags with commas',

- 'MAX_SIG_LENGTH_EXPLAIN' => 'Maximum number of characters in user signatures',

-

- 'MARK_FORUMS_READ' => 'Mark all forums read',

- 'MARK_TOPICS_READ' => 'Mark all topics read',

- 'STOP_WATCHING_FORUM' => 'Stop watching this forum',

- 'START_WATCHING_FORUM' => 'Watch this forum for new posts',

- 'NOT_WATCHING_FORUM' => 'You are no longer watching this forum',

- 'ARE_WATCHING_FORUM' => 'You are now watching this forum',

- 'PRINT_TOPIC' => 'Printable version',

- 'EMAIL_TOPIC' => 'Email to friend',

- 'VIEW_NEXT_TOPIC' => 'View next topic',

- 'VIEW_PREVIOUS_TOPIC' => 'View previous topic',

- 'VIEW_UNREAD_POST' => 'View first unread post',

- 'TOPIC_REPORTED' => 'This topic has been reported',

- 'TOPIC_NOT_APPROVED'=> 'This topic has not been approved',

- 'STOP_WATCHING_TOPIC' => 'Stop watching this topic',

- 'START_WATCHING_TOPIC' => 'Watch this topic for replies',

- 'NOT_WATCHING_TOPIC' => 'You are no longer watching this topic',

- 'NOW_WATCHING_TOPIC' => 'You are now watching this topic',

- 'UCP_REG_DETAILS' => 'Registration details',

- 'CONFIRM_EMAIL_EXPLAIN' => 'You only need to specify this if you are changing your email address.',

- 'BIRTHDAY' => 'Birthday',

- 'UCP_AVATAR' => 'Your avatar',

- 'AVATAR' => 'Avatar',

- 'AVATAR_EXPLAIN' => 'Displays a small graphic image below your details in posts. Only one image can be displayed at a time, its width can be no greater than %d pixels, a height no greater than %d pixels and a file size no more than %dkB.',

- 'DELETE_AVATAR' => 'Delete Image',

- 'CURRENT_IMAGE' => 'Current Image',

- 'AVATAR_URL' => 'URL of Avatar Image',

- 'SHOW_GALLERY' => 'Show gallery',

-

-

- 'Select_avatar' => 'Select avatar',

- 'Return_profile' => 'Cancel avatar',

- 'Select_category' => 'Select category',

-

-

-

- 'Avatar_imagesize' => 'The avatar must be less than %d pixels wide and %d pixels high',

- 'REGISTRATION' => 'Registration',

- 'COPPA_BIRTHDAY' => 'To continue with the registration procedure please tell us when you were born.',

- 'UCP_COPPA_BEFORE' => 'Before %s',

- 'UCP_COPPA_ON_AFTER'=> 'On or After %s',

- 'UCP_AGREEMENT' => 'While the administrators and moderators of this forum will attempt to remove or edit any generally objectionable material as quickly as possible, it is impossible to review every message. Therefore you acknowledge that all posts made to these forums express the views and opinions of the author and not the administrators, moderators or webmaster (except for posts by these people) and hence will not be held liable.<br /><br />You agree not to post any abusive, obscene, vulgar, slanderous, hateful, threatening, sexually-orientated or any other material that may violate any applicable laws. Doing so may lead to you being immediately and permanently banned (and your service provider being informed). The IP address of all posts is recorded to aid in enforcing these conditions. You agree that the webmaster, administrator and moderators of this forum have the right to remove, edit, move or close any topic at any time should they see fit. As a user you agree to any information you have entered above being stored in a database. While this information will not be disclosed to any third party without your consent the webmaster, administrator and moderators cannot be held responsible for any hacking attempt that may lead to the data being compromised.<br /><br />This forum system uses cookies to store information on your local computer. These cookies do not contain any of the information you have entered above, they serve only to improve your viewing pleasure. The email address is used only for confirming your registration details and password (and for sending new passwords should you forget your current one).<br /><br />By clicking Register below you agree to be bound by these conditions.',

- 'UCP_EMAIL_ACTIVATE'=> 'Please note that you will need to enter a valid email address before your account is actived. You will recieve an email at the address you provide that contains an account activation link.',

- 'UCP_ADMIN_ACTIVATE'=> 'Please note that the administrator of this forum will have to approve your account before it is activated. You will recieve and email once your account has been activated.',

- 'NOT_AGREE' => 'I do not agree to these terms',

- 'AGREE' => 'I agree to these terms',

-

- 'CONFIRM_EMAIL' => 'Confirm email address',

- 'NEW_PASSWORD' => 'New password',

- 'NEW_PASSWORD_EXPLAIN' => 'You only need to supply a password if you want to change it',

- 'CURRENT_PASSWORD' => 'Current password',

- 'CURRENT_PASSWORD_EXPLAIN' => 'You must confirm your current password if you wish to change it or alter your email address',

- 'CONFIRM_PASSWORD' => 'Confirm password',

- 'CONFIRM_PASSWORD_EXPLAIN' => 'You only need to confirm your password if you changed it above',

- 'LANGUAGE' => 'Language',

- 'TIMEZONE' => 'Timezone',

- 'CONFIRMATION' => 'Confirmation of registration',

- 'CONFIRM_EXPLAIN' => 'To prevent automated registrations the board administrator requires you to enter a confirmation code. The code is displayed in the image you should see below. If you are visually impaired or cannot otherwise read this code please contact the %sBoard Administrator%s.',

- 'CONFIRM_CODE' => 'Confirmation code',

- 'CONFIRM_CODE_EXPLAIN' => 'Enter the code exactly as you see it in the image',

- 'COPPA_COMPLIANCE' => 'COPPA Compliance',

- 'COPPA_EXPLAIN' => 'Please note that clicking submit will create your account. However it cannot be activated until a parent or guardian approves your registration. You will be emailed a copy of the necessary form with details of where to send it.',

- 'ACCOUNT_INACTIVE_SELF_ADMIN'=> 'Your account has been created. However, this forum requires account activation by both yourself and the administrator. An activation key has been sent to the email address you provided. Please follow the directions in that message. Once activated an administrator will need to approve your account. You will be notified when this occcurs.',

- 'Wrong_activation' => 'The activation key you supplied does not match any in the database',

- 'Send_password' => 'Send me a new password',

- 'Password_updated' => 'A new password has been created, please check your email for details on how to activate it',

- 'No_email_match' => 'The email address you supplied does not match the one listed for that username',

- 'New_password_activation' => 'New password activation',

- 'Password_activated' => 'Your account has been re-activated. To logon please use the password supplied in the email you received',

-);

-

-

-// lang_mod strings

-$lang += array(

-// ------

-// strings borrowed from lang_admin

-// ------

- $sql = "SELECT username, user_id, user_colour, user_permissions, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_viewemail, user_posts, user_regdate, user_rank, user_from, user_occ, user_interests, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, user_lastvisit, MAX(session_time) AS session_time

- GROUP BY username, user_id, user_colour, user_permissions, user_sig, user_sig_bbcode_uid, user_sig_bbcode_bitfield, user_viewemail, user_posts, user_regdate, user_rank, user_from, user_occ, user_interests, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, user_lastvisit";

- $sql = "SELECT username, user_id, user_colour, user_viewemail, user_posts, user_regdate, user_rank, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, user_lastvisit

- if (isset($data['user_avatar_type']) && $user_id && !empty($data['user_allowavatar']) && $user->data['user_viewavatars'])

- switch($data['user_avatar_type'])

- case USER_AVATAR_UPLOAD:

- $poster_avatar = ($config['allow_avatar_upload']) ? '<img src="' . $config['avatar_path'] . '/' . $data['user_avatar'] . '" alt="" border="0" />' : '';

-

- case USER_AVATAR_REMOTE:

- $poster_avatar = ($config['allow_avatar_remote']) ? '<img src="' . $data['user_avatar'] . '" alt="" border="0" />' : '';

- break;

-

- case USER_AVATAR_GALLERY:

- $poster_avatar = ($config['allow_avatar_local']) ? '<img src="' . $config['avatar_gallery_path'] . '/' . $data['user_avatar'] . '" alt="" border="0" />' : '';

- if (!empty($data['user_viewemail']) || $auth->acl_get('a_'))

- $email_uri = (!empty($config['board_email_form'])) ? "memberlist.$phpEx$SID&amp;mode=email&amp;u=" . $user_id : 'mailto:' . $row['user_email'];

- <td class="row1" width="100%" align="left"><span class="gensmall">{L_CONGRATULATIONS}: <b>{BIRTHDAY_LIST}</b></span></td>

-/* Protected classes used internally -DO NOT REMOVE!- */

-span.hilit {

- color: red;

- font-weight: bold;

-}

-

- color: black;

- font-size: 70%;

- color: #006699;

- font-size: 80%;

- font-weight:bold;

- color: black;

- font-size: 65%;

- font-weight:bold;

- color: black;

- font-size: 65%;

- font-weight:bold;

- color: black;

- font-size: 70%;

- color: black;

- font-size: 60%;

- color: #444;

- font: normal 70%/125% Verdana, Arial, Helvetica, sans-serif;

- border: #D1D7DC solid 1px;

- background-color: #FAFAFA;

- color: #006600;

- font: normal 70% 'Courier New', monospace;

- border: #D1D7DC 1px solid;

- background-color: #FAFAFA;

- <th>Options</th>

- <td class="row1" width="38%"><b class="genmed">{L_USERNAME}: </b></td>

- <td class="row1"><b class="genmed">{L_NEW_PASSWORD}: </b><br /><span class="gensmall">{L_NEW_PASSWORD_EXPLAIN}</span></td>

- <td class="row2"><input class="post" type="text" name="jabber" size="30" maxlength="255" value="{YIM}" /></td>

- <td class="row1"><b class="genmed">{L_BIRTHDAY}: </b></td>

- <td class="row1" colspan="2"><table width="70%" cellspacing="2" cellpadding="0" border="0" align="center">

- <tr>

- <td width="65%"><span class="gensmall">{L_AVATAR_EXPLAIN}</span></td>

- <td align="center"><span class="gensmall">{L_CURRENT_IMAGE}</span><br />{AVATAR}<br /><input type="checkbox" name="avatardel" />&nbsp;<span class="gensmall">{L_DELETE_AVATAR}</span></td>

- </tr>

- </table></td>

- <td class="row1"><b class="genmed">{L_UPLOAD_AVATAR_FILE}:</b></td>

- <td class="row2"><input type="hidden" name="MAX_FILE_SIZE" value="{AVATAR_SIZE}" /><input type="file" name="avatar" class="post" style="width:200px" /></td>

- <td class="row1"><b class="genmed">{L_UPLOAD_AVATAR_URL}:</b><br /><span class="gensmall">{L_UPLOAD_AVATAR_URL_EXPLAIN}</span></td>

- <td class="row2"><input type="text" name="avatarurl" size="40" class="post" style="width:200px" /></td>

- <td class="row1"><b class="genmed">{L_LINK_REMOTE_AVATAR}:</b><br /><span class="gensmall">{L_LINK_REMOTE_AVATAR_EXPLAIN}</span></td>

- <td class="row2"><input type="text" name="avatarremoteurl" size="40" class="post" style="width:200px" /></td>

- <td class="row1"><b class="genmed">{L_AVATAR_GALLERY}:</b></td>

- <td class="row2"><input type="submit" name="avatargallery" value="{L_SHOW_GALLERY}" class="liteoption" /></td>

- <td class="row1" width="38%"><span class="gen">{L_USERNAME}: </span></td>

- <td class="row1"><span class="gen">{L_EMAIL_ADDRESS}: </span></td>

- <td class="row1"><span class="gen">{L_CONFIRM_EMAIL}: </span></td>

- <td class="row1"><span class="gen">{L_PASSWORD}: </span></td>

- <td class="row1"><span class="gen">{L_CONFIRM_PASSWORD}: </span></td>

- <td class="row1"><span class="gen">{L_LANGUAGE}: </span></td>

- <td class="row1"><span class="gen">{L_TIMEZONE}: </span></td>

- <td class="row1"><span class="gen">{L_CONFIRM_CODE}: </span><br /><span class="gensmall">{L_CONFIRM_CODE_EXPLAIN}</span></td>

- <td colspan="2"><a class="titles" href="{U_VIEW_FORUM}" title="{FORUM_DESC}">{FORUM_NAME}</a><!-- IF S_IS_POSTABLE --><!-- IF MODERATORS neq ''--><br /><b class="gensmall">{L_MODERATORS}: {MODERATORS}</b><!-- ENDIF --><!-- ENDIF --></td>

- <td class="nav" valign="middle" nowrap="nowrap">{PAGE_NUMBER}</td>

- <td class="gensmall" nowrap="nowrap">[ {TOTAL_TOPICS} ]&nbsp;</td>

- <td class="gensmall" width="100%" align="right" nowrap="nowrap"><b>{PAGINATION}</b></td>

-// * Simple registration (option or always?), i.e. username, email address, password

- $ucp->module('activate');

- $ucp->modules['activate']->main();

- $ucp->module('remind');

- $ucp->modules['remind']->main();

- $ucp->module('register');

- $ucp->modules['register']->main();

- $ucp->module('confirm');

- $ucp->modules['confirm']->main();

-$pagination_url = "viewtopic.$phpEx$SID&amp;t=$topic_id&amp;" . (($highlight_match) ? "&amp;hilit=$highlight" : '');

- if ($row['user_avatar_type'] && $user->data['user_viewavatars'])

- case USER_AVATAR_UPLOAD:

- $user_cache[$poster_id]['avatar'] = ($config['allow_avatar_upload']) ? '<img src="' . $config['avatar_path'] . '/' . $row['user_avatar'] . '" width="' . $row['user_avatar_width'] . '" height="' . $row['user_avatar_height'] . '" border="0" alt="" />' : '';

-

- case USER_AVATAR_REMOTE:

- $user_cache[$poster_id]['avatar'] = ($config['allow_avatar_remote']) ? '<img src="' . $row['user_avatar'] . '" width="' . $row['user_avatar_width'] . '" height="' . $row['user_avatar_height'] . '" border="0" alt="" />' : '';

- break;

-

- case USER_AVATAR_GALLERY:

- $user_cache[$poster_id]['avatar'] = ($config['allow_avatar_local']) ? '<img src="' . $config['avatar_gallery_path'] . '/' . $row['user_avatar'] . '" width="' . $row['user_avatar_width'] . '" height="' . $row['user_avatar_height'] . '" border="0" alt="" />' : '';

- $poster_id = intval($row['user_id']);

- 'MINI_POST_IMG' => ($row['post_time'] > $user->data['user_lastvisit'] && $row['post_time'] > $topic_last_read) ? $user->img('icon_post_new', $user->lang['NEW_POST']) : $user->img('icon_post', $user->lang['POST']),

- 'U_EDIT' => (($user->data['user_id'] == $poster_id && $auth->acl_get('f_edit', $forum_id) && ($post_time > time() - $config['edit_time'] || !$config['edit_time'])) || $auth->acl_get('m_edit', $forum_id)) ? "posting.$phpEx$SID&amp;mode=edit&amp;f=" . $row['forum_id'] . "&amp;p=" . $row['post_id'] : '',

- 'U_DELETE' => (($user->data['user_id'] == $poster_id && $auth->acl_get('f_delete', $forum_id) && $topic_data['topic_last_post_id'] == $row['post_id']) || $auth->acl_get('m_delete', $forum_id)) ? "posting.$phpEx$SID&amp;mode=delete&amp;p=" . $row['post_id'] : '',

-

-//print_r($_COOKIE);

-