}

$db->sql_freeresult($result);

$template->assign_vars(array(

'TOTAL_FILES' => $num_files,

'TOTAL_SIZE' => get_formatted_filesize($total_size),

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir)

'board_disable_msg' => false,

'default_lang' => array('lang' => 'DEFAULT_LANGUAGE', 'validate' => 'lang', 'type' => 'select', 'function' => 'language_select', 'params' => array('{CONFIG_VALUE}'), 'explain' => false),

'default_dateformat' => array('lang' => 'DEFAULT_DATE_FORMAT', 'validate' => 'string', 'type' => 'custom', 'method' => 'dateformat_select', 'explain' => true),

'default_style' => array('lang' => 'DEFAULT_STYLE', 'validate' => 'int', 'type' => 'select', 'function' => 'style_select', 'params' => array('{CONFIG_VALUE}', false), 'explain' => false),

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

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

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

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

'allow_quick_reply' => array('lang' => 'ALLOW_QUICK_REPLY', 'validate' => 'bool', 'type' => 'custom', 'method' => 'quick_reply', 'explain' => true),

'legend2' => 'ACP_LOAD_SETTINGS',

'load_cpf_pm' => array('lang' => 'LOAD_CPF_PM', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_cpf_viewprofile' => array('lang' => 'LOAD_CPF_VIEWPROFILE', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_cpf_viewtopic' => array('lang' => 'LOAD_CPF_VIEWTOPIC', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'legend3' => 'ACP_SUBMIT_CHANGES',

)

'load_moderators' => array('lang' => 'YES_MODERATORS', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'load_jumpbox' => array('lang' => 'YES_JUMPBOX', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

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

'legend3' => 'CUSTOM_PROFILE_FIELDS',

'load_cpf_memberlist' => array('lang' => 'LOAD_CPF_MEMBERLIST', 'validate' => 'bool', 'type' => 'radio:yes_no', 'explain' => false),

'<br /><br /><input class="button2" type="submit" id="' . $key . '_enable" name="' . $key . '_enable" value="' . $user->lang['ALLOW_QUICK_REPLY_BUTTON'] . '" />';

}

/**

* Select default dateformat

// Let the format_date function operate with the acp values

$old_tz = $user->timezone;

$dateformat_options = '';

// Reset users date options

$user->timezone = $old_tz;

return "<select name=\"dateoptions\" id=\"dateoptions\" onchange=\"if (this.value == 'custom') { document.getElementById('" . addslashes($key) . "').value = '" . addslashes($value) . "'; } else { document.getElementById('" . addslashes($key) . "').value = this.value; }\">$dateformat_options</select>

<input type=\"text\" name=\"config[$key]\" id=\"$key\" value=\"$value\" maxlength=\"30\" />";

*/

class acp_database

{

var $u_action;

function main($id, $mode)

global $cache, $db, $user, $auth, $template, $table_prefix;

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

$user->add_lang('acp/database');

$this->tpl_name = 'acp_database';

{

case 'download':

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

$format = request_var('method', '');

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

break;

default:

asort($tables);

foreach ($tables as $table_name)

{

$s_action_options .= '<option value="' . $option . '">' . $user->lang['GROUP_' . $lang] . '</option>';

}

$template->assign_vars(array(

'S_LIST' => true,

'S_GROUP_SPECIAL' => ($group_row['group_type'] == GROUP_SPECIAL) ? true : false,

'S_ACTION_OPTIONS' => $s_action_options,

'GROUP_NAME' => ($group_row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $group_row['group_name']] : $group_row['group_name'],

'U_ACTION' => $this->u_action . "&amp;g=$group_id",

}

}

$db->sql_freeresult($result);

}

/**

add_log('admin', 'LOG_USER_ACTIVE', $row['username']);

add_log('user', $row['user_id'], 'LOG_USER_ACTIVE_USER');

}

}

// For activate we really need to redirect, else a refresh can result in users being deactivated again

}

add_log('admin', 'LOG_INACTIVE_' . strtoupper($action), implode(', ', $user_affected));

}

else

{

$db->sql_query($sql);

add_log('admin', 'LOG_INACTIVE_REMIND', implode(', ', $usernames));

}

$db->sql_freeresult($result);

$option_ary += array('remind' => 'REMIND');

}

$template->assign_vars(array(

'S_INACTIVE_USERS' => true,

'S_INACTIVE_OPTIONS' => build_select($option_ary),

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir,

'USERS_PER_PAGE' => $per_page,

'U_ACTION' => $this->u_action . "&amp;$u_sort_param&amp;users_per_page=$per_page&amp;start=$start",

$log_count = 0;

$start = view_log($mode, $log_data, $log_count, $config['topics_per_page'], $start, $forum_id, 0, 0, $sql_where, $sql_sort, $keywords);

$template->assign_vars(array(

'L_TITLE' => $l_title,

'L_EXPLAIN' => $l_title_explain,

'U_ACTION' => $this->u_action . "&amp;$u_sort_param$keywords_param&amp;start=$start",

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

// No maximum post id? :o

if (!$max_post_id)

{

FROM ' . POSTS_TABLE;

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

$max_post_id = (int) $db->sql_fetchfield('max_post_id');

class acp_styles

{

public $u_action;

protected $u_base_action;

protected $s_hidden_fields;

protected $mode;

*/

protected function read_style_cfg($dir)

{

$cfg = parse_cfg_file($this->styles_path . $dir . '/style.cfg');

// Check if it is a valid file

$user_row['posts_in_queue'] = (int) $db->sql_fetchfield('posts_in_queue');

$db->sql_freeresult($result);

$template->assign_vars(array(

'L_NAME_CHARS_EXPLAIN' => $user->lang($config['allow_name_chars'] . '_EXPLAIN', $user->lang('CHARACTERS', (int) $config['min_name_chars']), $user->lang('CHARACTERS', (int) $config['max_name_chars'])),

'L_CHANGE_PASSWORD_EXPLAIN' => $user->lang($config['pass_complex'] . '_EXPLAIN', $user->lang('CHARACTERS', (int) $config['min_pass_chars']), $user->lang('CHARACTERS', (int) $config['max_pass_chars'])),

'USER_EMAIL' => $user_row['user_email'],

'USER_WARNINGS' => $user_row['user_warnings'],

'USER_POSTS' => $user_row['user_posts'],

'USER_INACTIVE_REASON' => $inactive_reason,

));

$log_count = 0;

$start = view_log('user', $log_data, $log_count, $config['topics_per_page'], $start, 0, 0, $user_id, $sql_where, $sql_sort);

$template->assign_vars(array(

'S_FEEDBACK' => true,

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

$data = array(

'dateformat' => utf8_normalize_nfc(request_var('dateformat', $user_row['user_dateformat'], true)),

'lang' => basename(request_var('lang', $user_row['user_lang'])),

'style' => request_var('style', $user_row['user_style']),

'viewemail' => request_var('viewemail', $user_row['user_allow_viewemail']),

'massemail' => request_var('massemail', $user_row['user_allow_massemail']),

'hideonline' => request_var('hideonline', !$user_row['user_allow_viewonline']),

$error = validate_data($data, array(

'dateformat' => array('string', false, 1, 30),

'lang' => array('match', false, '#^[a-z_\-]{2,}$#i'),

'topic_sk' => array('string', false, 1, 1),

'topic_sd' => array('string', false, 1, 1),

'user_notify_type' => $data['notifymethod'],

'user_notify_pm' => $data['notifypm'],

'user_dateformat' => $data['dateformat'],

'user_lang' => $data['lang'],

'user_timezone' => $data['tz'],

${'s_sort_' . $sort_option . '_dir'} .= '</select>';

}

$template->assign_vars(array(

'S_PREFS' => true,

'S_JABBER_DISABLED' => ($config['jab_enable'] && $user_row['user_jabber'] && @extension_loaded('xml')) ? false : true,

'NOTIFY_BOTH' => ($data['notifymethod'] == NOTIFY_BOTH) ? true : false,

'NOTIFY_PM' => $data['notifypm'],

'POPUP_PM' => $data['popuppm'],

'BBCODE' => $data['bbcode'],

'SMILIES' => $data['smilies'],

'ATTACH_SIG' => $data['sig'],

'S_LANG_OPTIONS' => language_select($data['lang']),

'S_STYLE_OPTIONS' => style_select($data['style']),

)

);

}

$db->sql_freeresult($result);

$template->assign_vars(array(

'S_ATTACHMENTS' => true,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir,

break;