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

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

- $bansubmit = (isset($_POST['bansubmit'])) ? true : false;

- $unbansubmit = (isset($_POST['unbansubmit'])) ? true : false;

- $current_time = time();

- $ban = utf8_normalize_nfc(request_var('ban', '', true));

- $ban_len = request_var('banlength', 0);

- $ban_len_other = request_var('banlengthother', '');

- $ban_exclude = request_var('banexclude', 0);

- $ban_reason = utf8_normalize_nfc(request_var('banreason', '', true));

- $ban_give_reason = utf8_normalize_nfc(request_var('bangivereason', '', true));

- user_ban($mode, $ban, $ban_len, $ban_len_other, $ban_exclude, $ban_reason, $ban_give_reason);

- $ban = request_var('unban', array(''));

- global $user;

- $timezone_select = phpbb_timezone_select($user, $value, true);

- $timezone_select['tz_select'];

- return '<select name="config[' . $key . ']" id="' . $key . '">' . $timezone_select['tz_select'] . '</select>';

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

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

- $factory = new phpbb_captcha_factory();

- $config_captcha = phpbb_captcha_factory::get_instance($selected);

- $old_captcha = phpbb_captcha_factory::get_instance($config['captcha_plugin']);

- $new_captcha = phpbb_captcha_factory::get_instance($config['captcha_plugin']);

- $demo_captcha = phpbb_captcha_factory::get_instance($selected);

- global $db, $user, $config;

- $captcha = phpbb_captcha_factory::get_instance($selected);

- header('Pragma: no-cache');

- header('Pragma: no-cache');

- header('Pragma: public');

- switch ($db->get_sql_layer())

- {

- case 'sqlite':

- case 'sqlite3':

- $sql = "SELECT sql

- FROM sqlite_master

- WHERE type = 'table'

- AND name = '" . PROFILE_FIELDS_DATA_TABLE . "'

- ORDER BY type DESC, name;";

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

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

- $db->sql_freeresult($result);

-

- // Create a temp table and populate it, destroy the existing one

- $db->sql_query(preg_replace('#CREATE\s+TABLE\s+"?' . PROFILE_FIELDS_DATA_TABLE . '"?#i', 'CREATE TEMPORARY TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp', $row['sql']));

- $db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . '_temp SELECT * FROM ' . PROFILE_FIELDS_DATA_TABLE);

- $db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE);

-

- preg_match('#\((.*)\)#s', $row['sql'], $matches);

-

- $new_table_cols = trim($matches[1]);

- $old_table_cols = preg_split('/,(?=[\\sa-z])/im', $new_table_cols);

- $column_list = array();

-

- foreach ($old_table_cols as $declaration)

- {

- $entities = preg_split('#\s+#', trim($declaration));

-

- if ($entities[0] == 'PRIMARY')

- {

- continue;

- }

-

- if ($entities[0] !== 'pf_' . $field_ident)

- {

- $column_list[] = $entities[0];

- }

- }

-

- $columns = implode(',', $column_list);

-

- $new_table_cols = preg_replace('/' . 'pf_' . $field_ident . '[^,]+,/', '', $new_table_cols);

-

- // create a new table and fill it up. destroy the temp one

- $db->sql_query('CREATE TABLE ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $new_table_cols . ');');

- $db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . PROFILE_FIELDS_DATA_TABLE . '_temp;');

- $db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp');

- break;

-

- default:

- $db->sql_query('ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " DROP COLUMN pf_$field_ident");

- }

-

- list($sql_type, $null) = $db_tools->get_column_type($profile_field->get_database_column_type());

- $profile_sql[] = $this->add_field_ident($field_ident, $sql_type);

-

- /**

- * Return sql statement for adding a new field ident (profile field) to the profile fields data table

- */

- function add_field_ident($field_ident, $sql_type)

- {

- global $db;

-

- switch ($db->get_sql_layer())

- {

- case 'mysql':

- case 'mysql4':

- case 'mysqli':

- $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD `$field_ident` " . $sql_type;

-

- break;

-

- case 'sqlite':

- case 'sqlite3':

- if (version_compare($db->sql_server_info(true), '3.0') == -1)

- {

- $sql = "SELECT sql

- FROM sqlite_master

- WHERE type = 'table'

- AND name = '" . PROFILE_FIELDS_DATA_TABLE . "'

- ORDER BY type DESC, name;";

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

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

- $db->sql_freeresult($result);

-

- // Create a temp table and populate it, destroy the existing one

- $db->sql_query(preg_replace('#CREATE\s+TABLE\s+"?' . PROFILE_FIELDS_DATA_TABLE . '"?#i', 'CREATE TEMPORARY TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp', $row['sql']));

- $db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . '_temp SELECT * FROM ' . PROFILE_FIELDS_DATA_TABLE);

- $db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE);

-

- preg_match('#\((.*)\)#s', $row['sql'], $matches);

-

- $new_table_cols = trim($matches[1]);

- $old_table_cols = explode(',', $new_table_cols);

- $column_list = array();

-

- foreach ($old_table_cols as $declaration)

- {

- $entities = preg_split('#\s+#', trim($declaration));

- if ($entities[0] == 'PRIMARY')

- {

- continue;

- }

- $column_list[] = $entities[0];

- }

-

- $columns = implode(',', $column_list);

-

- $new_table_cols = $field_ident . ' ' . $sql_type . ',' . $new_table_cols;

-

- // create a new table and fill it up. destroy the temp one

- $db->sql_query('CREATE TABLE ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $new_table_cols . ');');

- $db->sql_query('INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . ' (' . $columns . ') SELECT ' . $columns . ' FROM ' . PROFILE_FIELDS_DATA_TABLE . '_temp;');

- $db->sql_query('DROP TABLE ' . PROFILE_FIELDS_DATA_TABLE . '_temp');

- }

- else

- {

- $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD $field_ident [$sql_type]";

- }

-

- break;

-

- case 'mssql':

- case 'mssql_odbc':

- case 'mssqlnative':

- $sql = 'ALTER TABLE [' . PROFILE_FIELDS_DATA_TABLE . "] ADD [$field_ident] " . $sql_type;

-

- break;

-

- case 'postgres':

- $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD COLUMN \"$field_ident\" " . $sql_type;

-

- break;

-

- case 'oracle':

- $sql = 'ALTER TABLE ' . PROFILE_FIELDS_DATA_TABLE . " ADD $field_ident " . $sql_type;

-

- break;

- }

-

- return $sql;

- }

- case 'cache':

- $this->action_cache();

- return;

- * Purge cache

- */

- protected function action_cache()

- {

- global $db, $cache, $auth;

-

- $this->config->increment('assets_version', 1);

- $this->cache->purge();

-

- // Clear permissions

- $this->auth->acl_clear_prefetch();

- phpbb_cache_moderators($db, $cache, $auth);

-

- add_log('admin', 'LOG_PURGE_CACHE');

-

- trigger_error($this->user->lang['PURGED_CACHE'] . adm_back_link($this->u_base_action), E_USER_NOTICE);

- }

-

- /**

- $phpbb_notifications->delete_notifications('admin_activate_user', $user_row['user_id']);

- $sql_ary = array(

- 'user_avatar' => '',

- 'user_avatar_type' => '',

- 'user_avatar_width' => 0,

- 'user_avatar_height' => 0,

- );

-

- $sql = 'UPDATE ' . USERS_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "

- WHERE user_id = $user_id";

- $db->sql_query($sql);

-

- $driver = $phpbb_avatar_manager->get_driver($user_row['user_avatar_type']);

- if ($driver)

- {

- $driver->delete($user_row);

- }

- $timezone_selects = phpbb_timezone_select($user, $data['tz'], true);

- 'S_TZ_OPTIONS' => $timezone_selects['tz_select'],

- 'S_TZ_DATE_OPTIONS' => $timezone_selects['tz_dates'],

- else

- {

- $driver = $phpbb_avatar_manager->get_driver($avatar_data['avatar_type']);

- if ($driver)

- {

- $driver->delete($avatar_data);

- }

-

- // Removing the avatar

- $result = array(

- 'user_avatar' => '',

- 'user_avatar_type' => '',

- 'user_avatar_width' => 0,

- 'user_avatar_height' => 0,

- );

-

- $sql = 'UPDATE ' . USERS_TABLE . '

- SET ' . $db->sql_build_array('UPDATE', $result) . '

- WHERE user_id = ' . (int) $user_id;

-

- $db->sql_query($sql);

- trigger_error($user->lang['USER_AVATAR_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

- }

- $return_acl_fill = create_function('$value', 'return ' . $acl_fill . ';');

- 'cache' => array('title' => 'ACP_STYLES_CACHE', 'auth' => 'acl_a_styles', 'cat' => array('ACP_STYLE_MANAGEMENT')),