function user_delete($p_user_id)
{
    $c_user_id = db_prepare_int($p_user_id);
    $t_user_table = config_get('mantis_user_table');
    user_ensure_unprotected($p_user_id);
    # Remove associated profiles
    user_delete_profiles($p_user_id);
    # Remove associated preferences
    user_pref_delete_all($p_user_id);
    # Remove project specific access levels
    user_delete_project_specific_access_levels($p_user_id);
    #unset non-unique realname flags if necessary
    if (config_get('differentiate_duplicates')) {
        $c_realname = db_prepare_string(user_get_field($p_user_id, 'realname'));
        $query = "SELECT id\n\t\t\t\t\tFROM {$t_user_table}\n\t\t\t\t\tWHERE realname='{$c_realname}'";
        $result = db_query($query);
        $t_count = db_num_rows($result);
        if ($t_count == 2) {
            # unset flags if there are now only 2 unique names
            for ($i = 0; $i < $t_count; $i++) {
                $t_user_id = db_result($result, $i);
                user_set_field($t_user_id, 'duplicate_realname', OFF);
            }
        }
    }
    user_clear_cache($p_user_id);
    # Remove account
    $query = "DELETE FROM {$t_user_table}\n\t\t\t\t  WHERE id='{$c_user_id}'";
    db_query($query);
    return true;
}

/**
 * delete a user account (account, profiles, preferences, project-specific access levels)
 * returns true when the account was successfully deleted
 *
 * @param integer $p_user_id A valid user identifier.
 * @return boolean Always true
 */
function user_delete($p_user_id)
{
    $c_user_id = (int) $p_user_id;
    user_ensure_unprotected($p_user_id);
    # Remove associated profiles
    user_delete_profiles($p_user_id);
    # Remove associated preferences
    user_pref_delete_all($p_user_id);
    # Remove project specific access levels
    user_delete_project_specific_access_levels($p_user_id);
    # unset non-unique realname flags if necessary
    if (config_get('differentiate_duplicates')) {
        $c_realname = user_get_field($p_user_id, 'realname');
        $t_query = 'SELECT id FROM {user} WHERE realname=' . db_param();
        $t_result = db_query($t_query, array($c_realname));
        $t_users = array();
        while ($t_row = db_fetch_array($t_result)) {
            $t_users[] = $t_row;
        }
        $t_user_count = count($t_users);
        if ($t_user_count == 2) {
            # unset flags if there are now only 2 unique names
            for ($i = 0; $i < $t_user_count; $i++) {
                $t_user_id = $t_users[$i]['id'];
                user_set_field($t_user_id, 'duplicate_realname', OFF);
            }
        }
    }
    user_clear_cache($p_user_id);
    # Remove account
    $t_query = 'DELETE FROM {user} WHERE id=' . db_param();
    db_query($t_query, array($c_user_id));
    return true;
}

$c_realname = db_prepare_string($f_realname);
$c_protected = db_prepare_bool($f_protected);
$c_enabled = db_prepare_bool($f_enabled);
$c_user_id = db_prepare_int($f_user_id);
$c_access_level = db_prepare_int($f_access_level);
$t_user_table = config_get('mantis_user_table');
$t_old_protected = user_get_field($f_user_id, 'protected');
# check that we are not downgrading the last administrator
$t_old_access = user_get_field($f_user_id, 'access_level');
if (ADMINISTRATOR == $t_old_access && $t_old_access != $f_access_level && 1 >= user_count_level(ADMINISTRATOR)) {
    trigger_error(ERROR_USER_CHANGE_LAST_ADMIN, ERROR);
}
# Project specific access rights override global levels, hence, for users who are changed
# to be administrators, we have to remove project specific rights.
if ($c_access_level >= ADMINISTRATOR && !user_is_administrator($c_user_id)) {
    user_delete_project_specific_access_levels($c_user_id);
}
# if the user is already protected and the admin is not removing the
#  protected flag then don't update the access level and enabled flag.
#  If the user was unprotected or the protected flag is being turned off
#  then proceed with a full update.
if ($f_protected && $t_old_protected) {
    $query = "UPDATE {$t_user_table}\n\t    \t\tSET username='{$c_username}', email='{$c_email}',\n\t    \t\t\tprotected='{$c_protected}', realname='{$c_realname}'\n\t    \t\tWHERE id='{$c_user_id}'";
} else {
    $query = "UPDATE {$t_user_table}\n\t    \t\tSET username='{$c_username}', email='{$c_email}',\n\t    \t\t\taccess_level='{$c_access_level}', enabled='{$c_enabled}',\n\t    \t\t\tprotected='{$c_protected}', realname='{$c_realname}'\n\t    \t\tWHERE id='{$c_user_id}'";
}
$result = db_query($query);
$t_redirect_url = 'manage_user_page.php';
html_page_top1();
if ($result) {
    html_meta_redirect($t_redirect_url);