- * @param $resync bool Resync stats if they're incorrect.

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

-

- $ban_length[$row['ban_id']] = $user->lang['PERMANENT'];

- $ban_length[$row['ban_id']] = sprintf($user->lang['BANNED_UNTIL_DURATION'], $ban_end_text[$time_length], $user->format_date($row['ban_end'], false, true));

- $ban_length[$row['ban_id']] = sprintf($user->lang['BANNED_UNTIL_DATE'], $user->format_date($row['ban_end'], false, true));

- $ban_reasons[$row['ban_id']] = $row['ban_reason'];

- $ban_give_reasons[$row['ban_id']] = $row['ban_give_reason'];

- if (sizeof($ban_length))

- {

- foreach ($ban_length as $ban_id => $length)

- {

- $template->assign_block_vars('ban_length', array(

- 'BAN_ID' => (int) $ban_id,

- 'LENGTH' => $length,

- 'A_LENGTH' => addslashes($length),

- ));

- }

- }

-

- if (sizeof($ban_reasons))

- {

- foreach ($ban_reasons as $ban_id => $reason)

- {

- $template->assign_block_vars('ban_reason', array(

- 'BAN_ID' => $ban_id,

- 'REASON' => $reason,

- 'A_REASON' => addslashes($reason),

- ));

- }

- }

-

- if (sizeof($ban_give_reasons))

- {

- foreach ($ban_give_reasons as $ban_id => $reason)

- {

- $template->assign_block_vars('ban_give_reason', array(

- 'BAN_ID' => $ban_id,

- 'REASON' => $reason,

- 'A_REASON' => addslashes($reason),

- ));

- }

- }

-

- catch (Exception $e)

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

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

- * @param bool $run_inline if set to true errors will be returned and no logs being written

- 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;

- }

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

- $template->assign_vars(array(

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

- $template->assign_block_vars('ranks', array(

- 'U_DELETE' => $this->u_action . '&action=delete&id=' . $row['rank_id'])

- * @param string $level Styles tree level

- * @param array $level style inheritance level

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

- }

- 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 . '&u=' . $user_id));

- }

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