}

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

$ban_length = $ban_reasons = $ban_give_reasons = array();

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

{

$time_length = ($row['ban_end']) ? ($row['ban_end'] - $row['ban_start']) / 60 : 0;

}

}

$template->assign_vars(array(

'S_BAN_END_OPTIONS' => $ban_end_options,

}

}

'hot_threshold' => array('lang' => 'HOT_THRESHOLD', 'validate' => 'int:0', 'type' => 'text:3:4', 'explain' => true),

'max_poll_options' => array('lang' => 'MAX_POLL_OPTIONS', 'validate' => 'int:2:127', 'type' => 'text:4:4', 'explain' => false),

'max_post_chars' => array('lang' => 'CHAR_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:6', 'explain' => true),

'max_post_smilies' => array('lang' => 'SMILIES_LIMIT', 'validate' => 'int:0', 'type' => 'text:4:4', 'explain' => true),

'max_post_urls' => array('lang' => 'MAX_POST_URLS', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true),

'max_post_font_size' => array('lang' => 'MAX_POST_FONT_SIZE', 'validate' => 'int:0', 'type' => 'text:5:4', 'explain' => true, 'append' => ' %'),

'max_name_chars' => array('lang' => 'USERNAME_LENGTH', 'validate' => 'int:8:180', 'type' => false, 'method' => false, 'explain' => false,),

'max_pass_chars' => array('lang' => 'PASSWORD_LENGTH', 'validate' => 'int:8:255', 'type' => false, 'method' => false, 'explain' => false,),

'new_member_post_limit' => array('lang' => 'NEW_MEMBER_POST_LIMIT', 'validate' => 'int:0:255', 'type' => 'text:4:4', 'explain' => true, 'append' => ' ' . $user->lang['POSTS']),

'new_member_group_default'=> array('lang' => 'NEW_MEMBER_GROUP_DEFAULT', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => true),

'min_name_chars' => array('lang' => 'USERNAME_LENGTH', 'validate' => 'int:1', 'type' => 'custom:5:180', 'method' => 'username_length', 'explain' => true),

/**

* Select account activation method

*/

{

global $user, $config;

);

if ($config['email_enable'])

{

}

/**

case 'submit':

$delete = request_var('delete', '');

$file = request_var('file', '');

if (!preg_match('#^backup_\d{10,}_[a-z\d]{16}\.(sql(?:\.(?:gz|bz2))?)$#', $file, $matches))

{

confirm_box(false, $user->lang['DELETE_SELECTED_BACKUP'], build_hidden_fields(array('delete' => $delete, 'file' => $file)));

}

}

{

if ($download)

{

$name = $matches[0];

trigger_error($user->lang['RESTORE_SUCCESS'] . adm_back_link($this->u_action));

break;

}

default:

$methods = array('sql');

$i = $j = 0;

$email_list = array();

$old_lang = $row['user_lang'];

$old_notify_type = $row['user_notify_type'];

$messenger->template('admin_send_email', $used_lang);

$messenger->subject(htmlspecialchars_decode($subject));

$messenger->set_mail_priority($priority);

$message = ($action == 'add') ? $user->lang['FORUM_CREATED'] : $user->lang['FORUM_UPDATED'];

// redirect directly to permission settings screen if authed

if ($action == 'add' && !$copied_permissions && $auth->acl_get('a_fauth'))

{

meta_refresh(4, append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions' . $acl_url));

}

$errors = array();

{

$errors[] = $user->lang['FORUM_NAME_EMPTY'];

}

$messenger->to($row['user_email'], $row['username']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($row['username']))

$messenger->to($row['user_email'], $row['username']);

$messenger->im($row['user_jabber'], $row['username']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($row['username']),

$default_lang_id = (int) $db->sql_fetchfield('lang_id');

$db->sql_freeresult($result);

// From the mysql documentation:

// Prior to MySQL 4.0.14, the target table of the INSERT statement cannot appear in the FROM clause of the SELECT part of the query. This limitation is lifted in 4.0.14.

// Due to this we stay on the safe side if we do the insertion "the manual way"

{

$row['lang_id'] = $lang_id;

$db->sql_query('INSERT INTO ' . PROFILE_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $row));

}

$db->sql_freeresult($result);

{

$row['lang_id'] = $lang_id;

$db->sql_query('INSERT INTO ' . PROFILE_FIELDS_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $row));

}

$db->sql_freeresult($result);

add_log('admin', 'LOG_LANGUAGE_PACK_INSTALLED', $lang_pack['name']);

break;

$template->assign_var('S_WRITABLE_CONFIG', (bool) (@fileperms($phpbb_root_path . 'config.' . $phpEx) & 0x0002));

}

// Fill dbms version if not yet filled

if (empty($config['dbms_version']))

{

'RANK_TITLE' => (isset($ranks['rank_title'])) ? $ranks['rank_title'] : '',

'S_FILENAME_LIST' => $filename_list,

'RANK_IMAGE' => ($edit_img) ? $phpbb_root_path . $config['ranks_path'] . '/' . $edit_img : $phpbb_admin_path . 'images/spacer.gif',

'MIN_POSTS' => (isset($ranks['rank_min']) && !$ranks['rank_special']) ? $ranks['rank_min'] : 0)

);

trigger_error($user->lang['NO_' . $l_prefix] . adm_back_link($this->u_action), E_USER_WARNING);

}

if ($update)

{

if ($mode == 'style')

trigger_error($user->lang[$message] . adm_back_link($this->u_action));

}

$this->page_title = 'DELETE_' . $l_prefix;

$template->assign_vars(array(

/**

* Display the options which can be used to replace a style/template/theme/imageset

*/

function display_component_options($component, $component_id, $style_row = false, $style_id = false)

{

global $db, $template, $user;

$component_in_use = array();

if ($component != 'style')

{

$s_options = '';

if (($component != 'style') && empty($component_in_use))

{

$sql = "SELECT {$component}_id, {$component}_name

FROM $sql_from

WHERE {$component}_id = {$component_id}";

{

if ($row[$component . '_id'] != $component_id)

{

$s_options .= '<option value="' . $row[$component . '_id'] . '">' . sprintf($user->lang['REPLACE_WITH_OPTION'], $row[$component . '_name']) . '</option>';

}

else if ($component != 'style')

}

}

}

}

/**

$errstr = '';

$errno = 0;

if ($info === false)

{

$messenger->to($user_row['user_email'], $user_row['username']);

$messenger->assign_vars(array(

'WELCOME_MSG' => htmlspecialchars_decode(sprintf($user->lang['WELCOME_SUBJECT'], $config['sitename'])),

$messenger->to($user_row['user_email'], $user_row['username']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($user_row['username']))

// Which updates do we need to do?

$update_username = ($user_row['username'] != $data['username']) ? $data['username'] : false;

$update_email = ($data['email'] != $user_row['user_email']) ? $data['email'] : false;

if (!sizeof($error))