}

$db->sql_freeresult($result);

$display_vars = array(

'title' => 'ACP_ATTACHMENT_SETTINGS',

$db->sql_query($sql);

add_log('admin', 'LOG_ATTACH_ORPHAN_DEL', implode(', ', $delete_files));

}

$upload_list = array();

$error[] = $user->lang['FILES_GONE'];

}

add_log('admin', 'LOG_ATTACHMENTS_DELETED', implode(', ', $deleted_filenames));

}

else

{

$template->assign_vars(array(

'S_ACTION_OPTIONS' => ($auth->acl_get('a_board')) ? true : false,

'U_ACTION' => $this->u_action,)

}

// Make sure $start is set to the last page if it exceeds the amount

}

$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)

break;

}

$template->assign_vars(array(

'L_TITLE' => $this->page_title,

/**

* Display ban options

*/

{

global $user, $db, $template;

'legend1' => 'ACP_BOARD_SETTINGS',

'sitename' => array('lang' => 'SITE_NAME', 'validate' => 'string', 'type' => 'text:40:255', 'explain' => false),

'site_desc' => array('lang' => 'SITE_DESC', 'validate' => 'string', 'type' => 'text:40:255', 'explain' => false),

'board_disable' => array('lang' => 'DISABLE_BOARD', 'validate' => 'bool', 'type' => 'custom', 'method' => 'board_disable', 'explain' => true),

'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\" />";

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

include($phpbb_root_path . 'includes/captcha/captcha_factory.' . $phpEx);

$selected = request_var('select_captcha', $config['captcha_plugin']);

$selected = (isset($captchas['available'][$selected]) || isset($captchas['unavailable'][$selected])) ? $selected : $config['captcha_plugin'];

*/

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)

{

function main($id, $mode)

{

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

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

'forum_password_unset' => request_var('forum_password_unset', false),

);

// On add, add empty forum_options... else do not consider it (not updating it)

if ($action == 'add')

{

$forum_data['forum_flags'] += (request_var('enable_quick_reply', false)) ? FORUM_FLAG_QUICK_REPLY : 0;

}

// Show form to create/modify a forum

if ($action == 'edit')

{

}

}

$forum_rules_data = array(

'text' => $forum_data['forum_rules'],

'allow_bbcode' => true,

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

}

'S_EDIT_FORUM' => true,

'S_ERROR' => (sizeof($errors)) ? true : false,

'S_PARENT_ID' => $this->parent_id,

'S_ENABLE_POST_REVIEW' => ($forum_data['forum_flags'] & FORUM_FLAG_POST_REVIEW) ? true : false,

'S_ENABLE_QUICK_REPLY' => ($forum_data['forum_flags'] & FORUM_FLAG_QUICK_REPLY) ? true : false,

'S_CAN_COPY_PERMISSIONS' => ($action != 'edit' || empty($forum_id) || ($auth->acl_get('a_fauth') && $auth->acl_get('a_authusers') && $auth->acl_get('a_authgroups') && $auth->acl_get('a_mauth'))) ? true : false,

return;

*/

function update_forum_data(&$forum_data)

{

$errors = array();

if ($forum_data['forum_name'] == '')

{

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

}

unset($forum_data_sql['forum_password_unset']);

{

// no forum_id means we're creating a new forum

unset($forum_data_sql['type_action']);

add_log('admin', 'LOG_FORUM_EDIT', $forum_data['forum_name']);

}

return $errors;

}

*/

function move_forum($from_id, $to_id)

{

$to_data = $moved_ids = $errors = array();

if ($to_data['forum_type'] == FORUM_LINK)

{

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

}

}

$moved_forums = get_forum_branch($from_id, 'children', 'descending');

$from_data = $moved_forums[0];

$diff = sizeof($moved_forums) * 2;

*/

function move_forum_content($from_id, $to_id, $sync = true)

{

$table_ary = array(LOG_TABLE, POSTS_TABLE, TOPICS_TABLE, DRAFTS_TABLE, TOPICS_TRACK_TABLE);

$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",

switch ($method)

{

case 'ftp':

break;

case 'ftp_fsock':

break;

default:

trigger_error($user->lang['INVALID_UPLOAD_METHOD'], E_USER_ERROR);

}

if (($result = $transfer->open_session()) !== true)

{

$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');

$template->assign_vars(array(

'S_FORUM_NAMES' => (sizeof($forum_names)) ? true : false,

);

}

$field_row = array_merge($default_values[$field_type], array(

'field_ident' => str_replace(' ', '_', utf8_clean_string(request_var('field_ident', '', true))),

'field_required' => 0,

'field_hide' => 0,

'field_show_profile'=> 0,

'field_no_view' => 0,

// $exclude contains the data we gather in each step

$exclude = array(

2 => array('field_length', 'field_maxlen', 'field_minlen', 'field_validation', 'field_novalue', 'field_default_value'),

3 => array('l_lang_name', 'l_lang_explain', 'l_lang_default_value', 'l_lang_options')

);

// Visibility Options...

$visibility_ary = array(

'field_required',

'field_show_on_reg',

'field_show_on_pm',

'field_show_on_vt',

$template->assign_vars(array(

'S_STEP_ONE' => true,

'S_FIELD_REQUIRED' => ($cp->vars['field_required']) ? true : false,

'S_SHOW_ON_REG' => ($cp->vars['field_show_on_reg']) ? true : false,

'S_SHOW_ON_PM' => ($cp->vars['field_show_on_pm']) ? true : false,

'S_SHOW_ON_VT' => ($cp->vars['field_show_on_vt']) ? true : false,

'field_default_value' => $cp->vars['field_default_value'],

'field_validation' => $cp->vars['field_validation'],

'field_required' => $cp->vars['field_required'],

'field_show_on_reg' => $cp->vars['field_show_on_reg'],

'field_show_on_pm' => $cp->vars['field_show_on_pm'],

'field_show_on_vt' => $cp->vars['field_show_on_vt'],

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

$max_order = (int) $db->sql_fetchfield('max_reason_order');

$db->sql_freeresult($result);

$sql_ary = array(

'reason_title' => (string) $reason_row['reason_title'],

'reason_description' => (string) $reason_row['reason_description'],

'U_ACTION' => $this->u_action . "&amp;id=$reason_id&amp;action=$action",

'U_BACK' => $this->u_action,

'ERROR_MSG' => (sizeof($error)) ? implode('<br />', $error) : '',

'REASON_TITLE' => $reason_row['reason_title'],

'REASON_DESCRIPTION' => $reason_row['reason_description'],

'TRANSLATED_TITLE' => ($translated) ? $user->lang['report_reasons']['TITLE'][strtoupper($reason_row['reason_title'])] : '',

'TRANSLATED_DESCRIPTION'=> ($translated) ? $user->lang['report_reasons']['DESCRIPTION'][strtoupper($reason_row['reason_title'])] : '',

'S_EDIT_REASON' => true,

'S_TRANSLATED' => $translated,

'S_ERROR' => (sizeof($error)) ? true : false,

do

{

++$order;

if ($row['reason_order'] != $order)

{

$sql = 'UPDATE ' . REPORTS_REASONS_TABLE . "

*/

function init_search($type, &$search, &$error)

{

{

$error = $user->lang['NO_SUCH_SEARCH_MODULE'];

return $error;

}

$error = false;

return $error;

}

class acp_styles

{

public $u_action;

protected $u_base_action;

protected $s_hidden_fields;

protected $mode;

protected $cache;

protected $auth;

protected $phpbb_root_path;

public function main($id, $mode)

{

$this->auth = $auth;

$this->config = $config;

$this->phpbb_root_path = $phpbb_root_path;

$this->default_style = $config['default_style'];

$this->styles_path = $this->phpbb_root_path . $this->styles_path_absolute . '/';

$this->s_hidden_fields = array(

'mode' => $mode,

);

// Preview

$actions[] = array(

'L_ACTION' => $this->user->lang['PREVIEW']

);

}

{

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

global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix, $file_uploads;

$user->add_lang(array('posting', 'ucp', 'acp/users'));

$this->tpl_name = 'acp_users';

}

break;

}

// Handle registration info updates

'username' => utf8_normalize_nfc(request_var('user', $user_row['username'], true)),

'user_founder' => request_var('user_founder', ($user_row['user_type'] == USER_FOUNDER) ? 1 : 0),

'email' => strtolower(request_var('user_email', $user_row['user_email'])),

);

// Validation data - we do not check the password complexity setting here

}

}

if ($update_username !== false)

{

$sql_ary['username'] = $update_username;

}

}

if ($config['load_onlinetrack'])

{

$sql = 'SELECT MAX(session_time) AS session_time, MIN(session_viewonline) AS session_viewonline

unset($row);

}

$last_visit = (!empty($user_row['session_time'])) ? $user_row['session_time'] : $user_row['user_lastvisit'];

$inactive_reason = '';

$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']),

)

);

$message = (sizeof($log_attachments) == 1) ? $user->lang['ATTACHMENT_DELETED'] : $user->lang['ATTACHMENTS_DELETED'];

trigger_error($message . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

else

}

$db->sql_freeresult($result);

$template->assign_vars(array(

'S_ATTACHMENTS' => true,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir,

break;

'NAME' => $ug_name,

'CATEGORIES' => implode('</th><th>', $categories),

'L_ACL_TYPE' => $l_acl_type,

'S_LOCAL' => ($local) ? true : false,