<?php

/**

*

*

*/

$which_ary = ($user_id_ary) ? 'user_id_ary' : 'username_ary';

{

}

$user_id_ary = $username_ary = array();

*/

function update_last_username()

{

// Get latest username

$sql = 'SELECT user_id, username, user_colour

if ($row)

{

}

}

if ($config['newest_username'] == $old_name)

{

}

/**

* @event core.update_username

* @var string old_name The old username that is replaced

* @var string new_name The new username

*/

$vars = array('old_name', 'new_name');

extract($phpbb_dispatcher->trigger_event('core.update_username', compact($vars)));

*

* @param mixed $user_row An array containing the following keys (and the appropriate values): username, group_id (the group to place the user in), user_email and the user_type(usually 0). Additional entries not overridden by defaults will be forwarded.

* @param string $cp_data custom profile fields, see custom_profile::build_insert_sql_array

* @return the new user's ID.

*/

{

global $phpbb_dispatcher, $phpbb_container;

if (empty($user_row['username']) || !isset($user_row['group_id']) || !isset($user_row['user_email']) || !isset($user_row['user_type']))

'username' => $user_row['username'],

'username_clean' => $username_clean,

'user_password' => (isset($user_row['user_password'])) ? $user_row['user_password'] : '',

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

'user_email_hash' => phpbb_email_hash($user_row['user_email']),

'group_id' => $user_row['group_id'],

* Use this event to modify the values to be inserted when a user is added

*

* @event core.user_add_modify_data

* @var array sql_ary Array of data to be inserted when a user is added

*/

extract($phpbb_dispatcher->trigger_event('core.user_add_modify_data', compact($vars)));

$sql = 'INSERT INTO ' . USERS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

{

$cp_data['user_id'] = (int) $user_id;

$cp = $phpbb_container->get('profilefields.manager');

$sql = 'INSERT INTO ' . PROFILE_FIELDS_DATA_TABLE . ' ' .

$db->sql_build_array('INSERT', $cp->build_insert_sql_array($cp_data));

{

global $phpbb_log;

$phpbb_log->disable('admin');

// Add user to "newly registered users" group and set to default group if admin specified so.

// set the newest user and adjust the user count if the user is a normal user and no activation mail is sent

if ($user_row['user_type'] == USER_NORMAL || $user_row['user_type'] == USER_FOUNDER)

{

$sql = 'SELECT group_colour

FROM ' . GROUPS_TABLE . '

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

$db->sql_freeresult($result);

}

return $user_id;

}

/**

function user_delete($mode, $user_ids, $retain_username = true)

{

global $phpbb_root_path, $phpEx;

$db->sql_transaction('begin');

* @var array user_ids IDs of the deleted user

* @var mixed retain_username True if username should be retained

* or false if not

*/

$vars = array('mode', 'user_ids', 'retain_username');

extract($phpbb_dispatcher->trigger_event('core.delete_user_before', compact($vars)));

$num_users_delta = 0;

// Some things need to be done in the loop (if the query changes based

// on which user is currently being deleted)

$added_guest_posts = 0;

avatar_delete('user', $user_row);

}

// Decrement number of users if this user is active

if ($user_row['user_type'] != USER_INACTIVE && $user_row['user_type'] != USER_IGNORE)

{

if ($num_users_delta != 0)

{

}

// Now do the invariant tasks

WHERE ' . $db->sql_in_set('poster_id', $user_ids);

$db->sql_query($sql);

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_posts = user_posts + ' . $added_guest_posts . '

WHERE user_id = ' . ANONYMOUS;

$cache->destroy('sql', MODERATOR_CACHE_TABLE);

// Delete user log entries about this user

$sql = 'DELETE FROM ' . LOG_TABLE . '

WHERE ' . $db->sql_in_set('reportee_id', $user_ids);

}

phpbb_delete_users_pms($user_ids);

$db->sql_transaction('commit');

/**

* @var array user_ids IDs of the deleted user

* @var mixed retain_username True if username should be retained

* or false if not

*/

$vars = array('mode', 'user_ids', 'retain_username');

extract($phpbb_dispatcher->trigger_event('core.delete_user_after', compact($vars)));

*/

function user_active_flip($mode, $user_id_ary, $reason = INACTIVE_MANUAL)

{

$deactivated = $activated = 0;

$sql_statements = array();

}

$db->sql_freeresult($result);

if (sizeof($sql_statements))

{

foreach ($sql_statements as $user_id => $sql_ary)

$auth->acl_clear_prefetch(array_keys($sql_statements));

}

if ($deactivated)

{

}

if ($activated)

{

}

// Update latest username

*/

function user_ban($mode, $ban, $ban_len, $ban_len_other, $ban_exclude, $ban_reason, $ban_give_reason = '')

{

// Delete stale bans

$sql = 'DELETE FROM ' . BANLIST_TABLE . '

else

{

$ban_other = explode('-', $ban_len_other);

(strlen($ban_other[0]) == 4) && (strlen($ban_other[1]) == 2) && (strlen($ban_other[2]) == 2))

{

$ban_end = max($current_time, $user->create_datetime()

if ($ip_2_counter == 0 && $ip_2_end == 254)

{

$ip_2_counter = 256;

$banlist_ary[] = "$ip_1_counter.*";

}

if ($ip_3_counter == 0 && $ip_3_end == 254)

{

$ip_3_counter = 256;

$banlist_ary[] = "$ip_1_counter.$ip_2_counter.*";

}

if ($ip_4_counter == 0 && $ip_4_end == 254)

{

$ip_4_counter = 256;

$banlist_ary[] = "$ip_1_counter.$ip_2_counter.$ip_3_counter.*";

}

// Update log

$log_entry = ($ban_exclude) ? 'LOG_BAN_EXCLUDE_' : 'LOG_BAN_';

if ($mode == 'user')

{

foreach ($banlist_ary as $user_id)

{

}

}

*/

function user_unban($mode, $ban)

{

// Delete stale bans

$sql = 'DELETE FROM ' . BANLIST_TABLE . '

$db->sql_query($sql);

// Add to moderator log, admin log and user notes

if ($mode == 'user')

{

foreach ($user_ids_ary as $user_id)

{

}

}

}

$match = array();

// Test for referrals from $whois_host to other whois databases, roll on rwhois

{

if (strpos($match[1], ':') !== false)

{

{

$function = array_shift($validate);

array_unshift($validate, $data[$var]);

{

// Since errors are checked later for their language file existence, we need to make sure custom errors are not adjusted.

$error[] = (empty($user->lang[$result . '_' . strtoupper($var)])) ? $result : $result . '_' . strtoupper($var);

return 'INVALID_CHARS';

}

switch ($config['allow_name_chars'])

{

case 'USERNAME_CHARS_ANY':

$regex = '.+';

break;

case 'USERNAME_ALPHA_ONLY':

$regex = '[A-Za-z0-9]+';

break;

case 'USERNAME_ALPHA_SPACERS':

$regex = '[A-Za-z0-9-[\]_+ ]+';

break;

case 'USERNAME_LETTER_NUM':

break;

case 'USERNAME_LETTER_NUM_SPACERS':

break;

case 'USERNAME_ASCII':

default:

$regex = '[\x01-\x7F]+';

break;

}

{

}

$sql = 'SELECT username

return false;

}

$chars = array();

switch ($config['pass_complex'])

$chars[] = $upp;

}

{

{

}

}

}

/**

*

* @param string $email The email to check

*

* @return mixed Either false if validation succeeded or a string which will be used as the error message (with the variable name appended)

*/

{

{

}

if (!preg_match('/^' . get_preg_expression('email') . '$/i', $email))

{

return 'EMAIL_INVALID';

}

}

if (($ban_reason = $user->check_ban(false, false, $email, true)) !== false)

{

return ($ban_reason === true) ? 'EMAIL_BANNED' : $ban_reason;

*/

function avatar_delete($mode, $row, $clean_db = false)

{

// Check if the users avatar is actually *not* a group avatar

if ($mode == 'user')

{

{

return false;

}

{

global $config;

if ($avatar_entry[0] === 'g')

{

$avatar_group = true;

*/

function group_create(&$group_id, $type, $name, $desc, $group_attributes, $allow_desc_bbcode = false, $allow_desc_urls = false, $allow_desc_smilies = false)

{

$error = array();

$current_legend = \phpbb\groupposition\legend::GROUP_DISABLED;

$current_teampage = \phpbb\groupposition\teampage::GROUP_DISABLED;

$legend = $phpbb_container->get('groupposition.legend');

$teampage = $phpbb_container->get('groupposition.teampage');

if ($group_id)

{

try

// Setting the log message before we set the group id (if group gets added)

$log = ($group_id) ? 'LOG_GROUP_UPDATED' : 'LOG_GROUP_CREATED';

if ($group_id)

{

$sql = 'SELECT user_id

group_set_user_default($group_id, $user_ary, $sql_ary);

}

group_update_listings($group_id);

}

{

global $config, $db, $phpbb_root_path;

$ext = substr(strrchr($old_entry, '.'), 1);

$old_filename = get_avatar_filename($old_entry);

$new_filename = $config['avatar_salt'] . "_g$group_id.$ext";

*/

function avatar_remove_db($avatar_name)

{

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_avatar = '',

*/

function group_delete($group_id, $group_name = false)

{

if (!$group_name)

{

// Delete group from legend and teampage

try

{

$legend = $phpbb_container->get('groupposition.legend');

$legend->delete_group($group_id);

unset($legend);

try

{

$teampage = $phpbb_container->get('groupposition.teampage');

$teampage->delete_group($group_id);

unset($teampage);

* @event core.delete_group_after

* @var int group_id ID of the deleted group

* @var string group_name Name of the deleted group

*/

$vars = array('group_id', 'group_name');

extract($phpbb_dispatcher->trigger_event('core.delete_group_after', compact($vars)));

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

// Return false - no error

return false;

*/

function group_user_add($group_id, $user_id_ary = false, $username_ary = false, $group_name = false, $default = false, $leader = 0, $pending = 0, $group_attributes = false)

{

// We need both username and user_id info

$result = user_get_id_name($user_id_ary, $username_ary);

// Clear permissions cache of relevant users

$auth->acl_clear_prefetch($user_id_ary);

if (!$group_name)

{

$group_name = get_group_name($group_id);

$log = ($leader) ? 'LOG_MODS_ADDED' : (($pending) ? 'LOG_USERS_PENDING' : 'LOG_USERS_ADDED');

group_update_listings($group_id);

if ($pending)

{

$phpbb_notifications = $phpbb_container->get('notification_manager');

foreach ($add_id_ary as $user_id)

{

'group_id' => $group_id,

'user_id' => $user_id,

'group_name' => $group_name,

*/

function group_user_del($group_id, $user_id_ary = false, $username_ary = false, $group_name = false)

{

if ($config['coppa_enable'])

{

* @var string group_name Name of the group

* @var array user_id_ary IDs of the users which are removed

* @var array username_ary names of the users which are removed

*/

$vars = array('group_id', 'group_name', 'user_id_ary', 'username_ary');

extract($phpbb_dispatcher->trigger_event('core.group_delete_user_before', compact($vars)));

// Clear permissions cache of relevant users

$auth->acl_clear_prefetch($user_id_ary);

if (!$group_name)

{

$group_name = get_group_name($group_id);

if ($group_name)

{

}

group_update_listings($group_id);

$phpbb_notifications = $phpbb_container->get('notification_manager');

// Return false - no error

return false;

$sql = 'SELECT *

FROM ' . GROUPS_TABLE . '

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

if (!$row = $db->sql_fetchrow($result))

{

$sql = 'SELECT *

FROM ' . GROUPS_TABLE . '

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

if (!$row = $db->sql_fetchrow($result))

{

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_rank = 0

AND user_rank <> 0

AND ' . $db->sql_in_set('user_id', $user_ids);

$db->sql_query($sql);

}

*/

function group_user_attributes($action, $group_id, $user_id_ary = false, $username_ary = false, $group_name = false, $group_attributes = false)

{

// We need both username and user_id info

$result = user_get_id_name($user_id_ary, $username_ary);

AND " . $db->sql_in_set('user_id', $user_id_ary);

$db->sql_query($sql);

$phpbb_notifications = $phpbb_container->get('notification_manager');

'user_ids' => $user_id_ary,

'group_id' => $group_id,

'group_name' => $group_name,

));

$log = 'LOG_USERS_APPROVED';

break;

// Clear permissions cache of relevant users

$auth->acl_clear_prefetch($user_id_ary);

group_update_listings($group_id);

*/

function group_validate_groupname($group_id, $group_name)

{

$group_name = utf8_clean_string($group_name);

*/

function group_set_user_default($group_id, $user_id_ary, $group_attributes = false, $update_listing = false)

{

if (empty($user_id_ary))

{

if (isset($sql_ary[$avatar_option]))

{

$avatar_sql_ary[$avatar_option] = $sql_ary[$avatar_option];

}

$sql = 'UPDATE ' . USERS_TABLE . '

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

WHERE " . $db->sql_in_set('topic_last_poster_id', $user_id_ary);

$db->sql_query($sql);

if (in_array($config['newest_user_id'], $user_id_ary))

{

}

}

* @var array group_attributes Group attributes which were changed

* @var array update_listing Update the list of moderators and foes

* @var array sql_ary User attributes which were changed

*/

$vars = array('group_id', 'user_id_ary', 'group_attributes', 'update_listing', 'sql_ary');

extract($phpbb_dispatcher->trigger_event('core.user_set_default_group', compact($vars)));

*/

function get_group_name($group_id)

{

$sql = 'SELECT group_name, group_type

FROM ' . GROUPS_TABLE . '

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

$db->sql_freeresult($result);

{

return '';

}

}

/**

*

* @param array $user_ids Array of users' ids to check for banning,

* leave empty to get complete list of banned ids

* @return array Array of banned users' ids if any, empty array otherwise

*/

{

global $db;

$sql = 'SELECT ban_userid

FROM ' . BANLIST_TABLE . "

WHERE $sql_user_ids

OR ban_end = 0)';

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

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

{

return $banned_ids_list;

}