class.ilObjUser.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2009 ILIAS open source, Extended GPL, see docs/LICENSE */

define("IL_PASSWD_PLAIN", "plain");
define("IL_PASSWD_CRYPTED", "crypted");


require_once "./Services/Object/classes/class.ilObject.php";
require_once './Services/User/exceptions/class.ilUserException.php';
require_once './Modules/OrgUnit/classes/class.ilObjOrgUnit.php';
require_once './Modules/OrgUnit/classes/class.ilObjOrgUnitTree.php';

class ilObjUser extends ilObject
{
    // personal data

    public $login;              // username in system

    protected $passwd; // password encoded in the format specified by $passwd_type

    protected $passwd_type;
    // specifies the password format.
    // value: IL_PASSWD_PLAIN or IL_PASSWD_CRYPTED.

    // Differences between password format in class ilObjUser and
    // in table usr_data:
    // Class ilObjUser supports two different password types
    // (plain and crypted) and it uses the variables $passwd
    // and $passwd_type to store them.
    // Table usr_data supports only two different password types
    // (md5 and bcrypt) and it uses the columns "passwd" and "passwd_type" to store them.
    // The conversion between these two storage layouts is done
    // in the methods that perform SQL statements. All other
    // methods work exclusively with the $passwd and $passwd_type
    // variables.

    protected $password_encoding_type;

    protected $password_salt = null;
    
    public $gender;     // 'm' or 'f'
    public $utitle;     // user title (keep in mind, that we derive $title from object also!)
    public $firstname;
    public $lastname;
    protected $birthday;
    public $fullname;   // title + firstname + lastname in one string
    //var $archive_dir = "./image";  // point to image file (should be flexible)
    // address data
    public $institution;
    public $department;
    public $street;
    public $city;
    public $zipcode;
    public $country;
    public $sel_country;
    public $phone_office;
    public $phone_home;
    public $phone_mobile;
    public $fax;
    public $email;
    protected $second_email = null;
    public $hobby;
    public $matriculation;
    public $referral_comment;
    public $approve_date = null;
    public $agree_date = null;
    public $active;
    public $client_ip; // client ip to check before login
    public $auth_mode; // authentication mode

    public $latitude;
    public $longitude;
    public $loc_zoom;

    public $last_password_change_ts;
    public $login_attempts;

    public $user_defined_data = array();
    
    public $prefs;

    public $skin;


    public $default_role;

    public $ilias;

    public static $is_desktop_item_loaded;
    public static $is_desktop_item_cache;

    protected static $personal_image_cache = array();
    
    protected $inactivation_date = null;

    private $is_self_registered = false;

    protected $org_units;
    
    protected $interests_general; // [array]
    protected $interests_help_offered; // [array]
    protected $interests_help_looking; // [array]

    public function __construct($a_user_id = 0, $a_call_by_reference = false)
    {
        global $ilias,$ilDB;

        // init variables
        $this->ilias =&$ilias;
        $this->db =&$ilDB;

        $this->type = "usr";
        parent::__construct($a_user_id, $a_call_by_reference);
        $this->auth_mode = "default";
        $this->passwd_type = IL_PASSWD_PLAIN;

        // for gender selection. don't change this
        /*$this->gender = array(
                              'n'    => "salutation_n",
                              'm'    => "salutation_m",
                              'f'    => "salutation_f"
                              );*/
        if ($a_user_id > 0) {
            $this->setId($a_user_id);
            $this->read();
        } else {
            // TODO: all code in else-structure doesn't belongs in class user !!!
            //load default data
            $this->prefs = array();
            //language
            $this->prefs["language"] = $this->ilias->ini->readVariable("language", "default");

            //skin and pda support
            $this->skin = $this->ilias->ini->readVariable("layout", "skin");

            $this->prefs["skin"] = $this->skin;
            //                  $this->prefs["show_users_online"] = "y";

            //style (css)
            $this->prefs["style"] = $this->ilias->ini->readVariable("layout", "style");
        }
    }

    public function read()
    {
        global $ilErr, $ilDB;

        // Alex: I have removed the JOIN to rbac_ua, since there seems to be no
        // use (3.11.0 alpha)
        /*$q = "SELECT * FROM usr_data ".
             "LEFT JOIN rbac_ua ON usr_data.usr_id=rbac_ua.usr_id ".
             "WHERE usr_data.usr_id= ".$ilDB->quote($this->id); */
        $r = $ilDB->queryF("SELECT * FROM usr_data " .
             "WHERE usr_id= %s", array("integer"), array($this->id));

        if ($data = $ilDB->fetchAssoc($r)) {
            // convert password storage layout used by table usr_data into
            // storage layout used by class ilObjUser
            $data["passwd_type"] = IL_PASSWD_CRYPTED;

            // this assign must not be set via $this->assignData($data)
            // because this method will be called on profile updates and
            // would set this values to 0, because they arent posted from form
            $this->setLastPasswordChangeTS($data['last_password_change']);
            $this->setLoginAttempts($data['login_attempts']);


            // fill member vars in one shot
            $this->assignData($data);

            //get userpreferences from usr_pref table
            $this->readPrefs();

            //set language to default if not set
            if ($this->prefs["language"] == "") {
                $this->prefs["language"] = $this->oldPrefs["language"];
            }

            //check skin-setting
            include_once("./Services/Style/System/classes/class.ilStyleDefinition.php");
            if ($this->prefs["skin"] == "" ||
                    !ilStyleDefinition::skinExists($this->prefs["skin"])) {
                $this->prefs["skin"] = $this->oldPrefs["skin"];
            }

            $this->skin = $this->prefs["skin"];

            //check style-setting (skins could have more than one stylesheet
            if ($this->prefs["style"] == "" ||
                    (!ilStyleDefinition::skinExists($this->skin) && ilStyleDefinition::styleExistsForSkinId($this->skin, $this->prefs["style"]))) {
                //load default (css)
                $this->prefs["style"] = $this->ilias->ini->readVariable("layout", "style");
            }

            if (empty($this->prefs["hits_per_page"])) {
                $this->prefs["hits_per_page"] = 10;
            }
        } else {
            $ilErr->raiseError("<b>Error: There is no dataset with id " .
                               $this->id . "!</b><br />class: " . get_class($this) . "<br />Script: " . __FILE__ .
                               "<br />Line: " . __LINE__, $ilErr->FATAL);
        }

        $this->readMultiTextFields();
        $this->readUserDefinedFields();

        parent::read();
    }

    public function getPasswordEncodingType()
    {
        return $this->password_encoding_type;
    }

    public function setPasswordEncodingType($password_encryption_type)
    {
        $this->password_encoding_type = $password_encryption_type;
    }

    public function getPasswordSalt()
    {
        return $this->password_salt;
    }

    public function setPasswordSalt($password_salt)
    {
        $this->password_salt = $password_salt;
    }

    public function assignData($a_data)
    {
        global $ilErr, $ilDB, $lng;
        
        // basic personal data
        $this->setLogin($a_data["login"]);
        if (!$a_data["passwd_type"]) {
            $ilErr->raiseError("<b>Error: passwd_type missing in function assignData(). " .
                                $this->id . "!</b><br />class: " . get_class($this) . "<br />Script: "
                                . __FILE__ . "<br />Line: " . __LINE__, $ilErr->FATAL);
        }
        if ($a_data["passwd"] != "********" and strlen($a_data['passwd'])) {
            $this->setPasswd($a_data["passwd"], $a_data["passwd_type"]);
        }

        $this->setGender($a_data["gender"]);
        $this->setUTitle($a_data["title"]);
        $this->setFirstname($a_data["firstname"]);
        $this->setLastname($a_data["lastname"]);
        $this->setFullname();
        if (!is_array($a_data['birthday'])) {
            $this->setBirthday($a_data['birthday']);
        } else {
            $this->setBirthday(null);
        }
        
        // address data
        $this->setInstitution($a_data["institution"]);
        $this->setDepartment($a_data["department"]);
        $this->setStreet($a_data["street"]);
        $this->setCity($a_data["city"]);
        $this->setZipcode($a_data["zipcode"]);
        $this->setCountry($a_data["country"]);
        $this->setSelectedCountry($a_data["sel_country"]);
        $this->setPhoneOffice($a_data["phone_office"]);
        $this->setPhoneHome($a_data["phone_home"]);
        $this->setPhoneMobile($a_data["phone_mobile"]);
        $this->setFax($a_data["fax"]);
        $this->setMatriculation($a_data["matriculation"]);
        $this->setEmail($a_data["email"]);
        $this->setSecondEmail($a_data["second_email"]);
        $this->setHobby($a_data["hobby"]);
        $this->setClientIP($a_data["client_ip"]);
        $this->setPasswordEncodingType($a_data['passwd_enc_type']);
        $this->setPasswordSalt($a_data['passwd_salt']);

        // other data
        $this->setLatitude($a_data["latitude"]);
        $this->setLongitude($a_data["longitude"]);
        $this->setLocationZoom($a_data["loc_zoom"]);

        // system data
        $this->setLastLogin($a_data["last_login"]);
        $this->setLastUpdate($a_data["last_update"]);
        $this->create_date      = $a_data["create_date"];
        $this->setComment($a_data["referral_comment"]);
        $this->approve_date = $a_data["approve_date"];
        $this->active = $a_data["active"];
        $this->agree_date = $a_data["agree_date"];
        
        $this->setInactivationDate($a_data["inactivation_date"]);

        // time limitation
        $this->setTimeLimitOwner($a_data["time_limit_owner"]);
        $this->setTimeLimitUnlimited($a_data["time_limit_unlimited"]);
        $this->setTimeLimitFrom($a_data["time_limit_from"]);
        $this->setTimeLimitUntil($a_data["time_limit_until"]);
        $this->setTimeLimitMessage($a_data['time_limit_message']);

        // user profile incomplete?
        $this->setProfileIncomplete($a_data["profile_incomplete"]);

        //authentication
        $this->setAuthMode($a_data['auth_mode']);
        $this->setExternalAccount($a_data['ext_account']);
        
        $this->setIsSelfRegistered((bool) $a_data['is_self_registered']);
    }

    public function saveAsNew($a_from_formular = true)
    {
        global $ilAppEventHandler;
        
        global $ilErr, $ilDB;

        switch ($this->passwd_type) {
            case IL_PASSWD_PLAIN:
                if (strlen($this->passwd)) {
                    require_once 'Services/User/classes/class.ilUserPasswordManager.php';
                    ilUserPasswordManager::getInstance()->encodePassword($this, $this->passwd);
                    $pw_value = $this->getPasswd();
                } else {
                    $pw_value = $this->passwd;
                }
                break;

            case IL_PASSWD_CRYPTED:
                $pw_value = $this->passwd;
                break;

            default:
                 $ilErr->raiseError("<b>Error: passwd_type missing in function saveAsNew. " .
                                    $this->id . "!</b><br />class: " . get_class($this) . "<br />Script: " . __FILE__ .
                                    "<br />Line: " . __LINE__, $ilErr->FATAL);
        }

        if (!$this->active) {
            $this->setInactivationDate(ilUtil::now());
        } else {
            $this->setInactivationDate(null);
        }

        $insert_array = array(
            "usr_id" => array("integer", $this->id),
            "login" => array("text", $this->login),
            "passwd" => array("text", $pw_value),
            'passwd_enc_type' => array("text", $this->getPasswordEncodingType()),
            'passwd_salt'     => array("text", $this->getPasswordSalt()),
            "firstname" => array("text", $this->firstname),
            "lastname" => array("text", $this->lastname),
            "title" => array("text", $this->utitle),
            "gender" => array("text", $this->gender),
            "email" => array("text", trim($this->email)),
            "second_email" => array("text", trim($this->second_email)),
            "hobby" => array("text", (string) $this->hobby),
            "institution" => array("text", $this->institution),
            "department" => array("text", $this->department),
            "street" => array("text", $this->street),
            "city" => array("text", $this->city),
            "zipcode" => array("text", $this->zipcode),
            "country" => array("text", $this->country),
            "sel_country" => array("text", $this->sel_country),
            "phone_office" => array("text", $this->phone_office),
            "phone_home" => array("text", $this->phone_home),
            "phone_mobile" => array("text", $this->phone_mobile),
            "fax" => array("text", $this->fax),
            "birthday" => array('date', $this->getBirthday()),
            "last_login" => array("timestamp", null),
            "last_update" => array("timestamp", ilUtil::now()),
            "create_date" => array("timestamp", ilUtil::now()),
            "referral_comment" => array("text", $this->referral_comment),
            "matriculation" => array("text", $this->matriculation),
            "client_ip" => array("text", $this->client_ip),
            "approve_date" => array("timestamp", $this->approve_date),
            "agree_date" => array("timestamp", $this->agree_date),
            "active" => array("integer", (int) $this->active),
            "time_limit_unlimited" => array("integer", $this->getTimeLimitUnlimited()),
            "time_limit_until" => array("integer", $this->getTimeLimitUntil()),
            "time_limit_from" => array("integer", $this->getTimeLimitFrom()),
            "time_limit_owner" => array("integer", $this->getTimeLimitOwner()),
            "auth_mode" => array("text", $this->getAuthMode()),
            "ext_account" => array("text", $this->getExternalAccount()),
            "profile_incomplete" => array("integer", $this->getProfileIncomplete()),
            "latitude" => array("text", $this->latitude),
            "longitude" => array("text", $this->longitude),
            "loc_zoom" => array("integer", (int) $this->loc_zoom),
            "last_password_change" => array("integer", (int) $this->last_password_change_ts),
            'inactivation_date' => array('timestamp', $this->inactivation_date),
            'is_self_registered' => array('integer', (int) $this->is_self_registered),
            );
        $ilDB->insert("usr_data", $insert_array);

        $this->updateMultiTextFields(true);

        // add new entry in usr_defined_data
        $this->addUserDefinedFieldEntry();
        // ... and update
        $this->updateUserDefinedFields();

        // CREATE ENTRIES FOR MAIL BOX
        include_once("Services/Mail/classes/class.ilMailbox.php");
        $mbox = new ilMailbox($this->id);
        $mbox->createDefaultFolder();

        include_once "Services/Mail/classes/class.ilMailOptions.php";
        $mail_options = new ilMailOptions($this->id);
        $mail_options->createMailOptionsEntry();

        // create personal bookmark folder tree
        include_once "./Services/Bookmarks/classes/class.ilBookmarkFolder.php";
        $bmf = new ilBookmarkFolder(0, $this->id);
        $bmf->createNewBookmarkTree();
        
        $ilAppEventHandler->raise(
            "Services/User",
            "afterCreate",
            array("user_obj" => $this)
        );
    }

    public function update()
    {
        global $ilErr, $ilDB, $ilAppEventHandler;

        $this->syncActive();

        if ($this->getStoredActive($this->id) && !$this->active) {
            $this->setInactivationDate(ilUtil::now());
        } elseif ($this->active) {
            $this->setInactivationDate(null);
        }

        $update_array = array(
            "gender" => array("text", $this->gender),
            "title" => array("text", $this->utitle),
            "firstname" => array("text", $this->firstname),
            "lastname" => array("text", $this->lastname),
            "email" => array("text", trim($this->email)),
            "second_email" => array("text", trim($this->second_email)),
            "birthday" => array('date', $this->getBirthday()),
            "hobby" => array("text", $this->hobby),
            "institution" => array("text", $this->institution),
            "department" => array("text", $this->department),
            "street" => array("text", $this->street),
            "city" => array("text", $this->city),
            "zipcode" => array("text", $this->zipcode),
            "country" => array("text", $this->country),
            "sel_country" => array("text", $this->sel_country),
            "phone_office" => array("text", $this->phone_office),
            "phone_home" => array("text", $this->phone_home),
            "phone_mobile" => array("text", $this->phone_mobile),
            "fax" => array("text", $this->fax),
            "referral_comment" => array("text", $this->referral_comment),
            "matriculation" => array("text", $this->matriculation),
            "client_ip" => array("text", $this->client_ip),
            "approve_date" => array("timestamp", $this->approve_date),
            "active" => array("integer", $this->active),
            "time_limit_unlimited" => array("integer", $this->getTimeLimitUnlimited()),
            "time_limit_until" => array("integer", $this->getTimeLimitUntil()),
            "time_limit_from" => array("integer", $this->getTimeLimitFrom()),
            "time_limit_owner" => array("integer", $this->getTimeLimitOwner()),
            "time_limit_message" => array("integer", $this->getTimeLimitMessage()),
            "profile_incomplete" => array("integer", $this->getProfileIncomplete()),
            "auth_mode" => array("text", $this->getAuthMode()),
            "ext_account" => array("text", $this->getExternalAccount()),
            "latitude" => array("text", $this->latitude),
            "longitude" => array("text", $this->longitude),
            "loc_zoom" => array("integer", (int) $this->loc_zoom),
            "last_password_change" => array("integer", $this->last_password_change_ts),
            "last_update" => array("timestamp", ilUtil::now()),
            'inactivation_date' => array('timestamp', $this->inactivation_date)
            );
            
        if (isset($this->agree_date) && (strtotime($this->agree_date) !== false || $this->agree_date == null)) {
            $update_array["agree_date"] = array("timestamp", $this->agree_date);
        }
        switch ($this->passwd_type) {
            case IL_PASSWD_PLAIN:
                if (strlen($this->passwd)) {
                    require_once 'Services/User/classes/class.ilUserPasswordManager.php';
                    ilUserPasswordManager::getInstance()->encodePassword($this, $this->passwd);
                    $update_array['passwd'] = array('text', $this->getPasswd());
                } else {
                    $update_array["passwd"] = array("text", (string) $this->passwd);
                }
                break;

            case IL_PASSWD_CRYPTED:
                $update_array["passwd"] = array("text", (string) $this->passwd);
                break;

            default:
                $ilErr->raiseError("<b>Error: passwd_type missing in function update()" . $this->id . "!</b><br />class: " .
                                   get_class($this) . "<br />Script: " . __FILE__ . "<br />Line: " . __LINE__, $ilErr->FATAL);
        }

        $update_array['passwd_enc_type'] = array('text', $this->getPasswordEncodingType());
        $update_array['passwd_salt']     = array('text', $this->getPasswordSalt());

        $ilDB->update("usr_data", $update_array, array("usr_id" => array("integer", $this->id)));

        $this->updateMultiTextFields();
        
        $this->writePrefs();

        // update user defined fields
        $this->updateUserDefinedFields();

        parent::update();
        parent::updateOwner();

        $this->read();
        
        $ilAppEventHandler->raise(
            "Services/User",
            "afterUpdate",
            array("user_obj" => $this)
        );

        return true;
    }

    public function writeAccepted()
    {
        global $ilDB;

        $ilDB->manipulateF("UPDATE usr_data SET agree_date = " . $ilDB->now() .
             " WHERE usr_id = %s", array("integer"), array($this->getId()));
    }

    private static function _lookup($a_user_id, $a_field)
    {
        global $ilDB;
        
        $res = $ilDB->queryF(
            "SELECT " . $a_field . " FROM usr_data WHERE usr_id = %s",
            array("integer"),
            array($a_user_id)
        );

        while ($set = $ilDB->fetchAssoc($res)) {
            return $set[$a_field];
        }
        return false;
    }
    
    public static function _lookupFullname($a_user_id)
    {
        global $ilDB;
        
        $set = $ilDB->queryF(
            "SELECT title, firstname, lastname FROM usr_data WHERE usr_id = %s",
            array("integer"),
            array($a_user_id)
        );

        if ($rec = $ilDB->fetchAssoc($set)) {
            if ($rec["title"]) {
                $fullname = $rec["title"] . " ";
            }
            if ($rec["firstname"]) {
                $fullname .= $rec["firstname"] . " ";
            }
            if ($rec["lastname"]) {
                $fullname .= $rec["lastname"];
            }
        }
        return $fullname;
    }

    public static function _lookupEmail($a_user_id)
    {
        return ilObjUser::_lookup($a_user_id, "email");
    }
    
    public static function _lookupSecondEmail($a_user_id)
    {
        return ilObjUser::_lookup($a_user_id, "second_email");
    }

    public static function _lookupGender($a_user_id)
    {
        return ilObjUser::_lookup($a_user_id, "gender");
    }

    public static function _lookupClientIP($a_user_id)
    {
        return ilObjUser::_lookup($a_user_id, "client_ip");
    }


    public static function _lookupName($a_user_id)
    {
        global $ilDB;

        $res = $ilDB->queryF(
            "SELECT firstname, lastname, title, login FROM usr_data WHERE usr_id = %s",
            array("integer"),
            array($a_user_id)
        );
        $user_rec = $ilDB->fetchAssoc($res);
        return array("user_id" => $a_user_id,
            "firstname" => $user_rec["firstname"],
            "lastname" => $user_rec["lastname"],
            "title" => $user_rec["title"],
            "login" => $user_rec["login"]);
    }

    public static function _lookupFields($a_user_id)
    {
        global $ilDB;

        $res = $ilDB->queryF(
            "SELECT * FROM usr_data WHERE usr_id = %s",
            array("integer"),
            array($a_user_id)
        );
        $user_rec = $ilDB->fetchAssoc($res);
        return $user_rec;
    }

    public static function _lookupLogin($a_user_id)
    {
        return ilObjUser::_lookup($a_user_id, "login");
    }

    public static function _lookupExternalAccount($a_user_id)
    {
        return ilObjUser::_lookup($a_user_id, "ext_account");
    }

    public static function _lookupId($a_user_str)
    {
        global $ilDB;

        if (!is_array($a_user_str)) {
            $res = $ilDB->queryF(
                "SELECT usr_id FROM usr_data WHERE login = %s",
                array("text"),
                array($a_user_str)
            );
            $user_rec = $ilDB->fetchAssoc($res);
            return $user_rec["usr_id"];
        } else {
            $set = $ilDB->query(
                "SELECT usr_id FROM usr_data " .
                " WHERE " . $ilDB->in("login", $a_user_str, false, "text")
            );
            $ids = array();
            while ($rec = $ilDB->fetchAssoc($set)) {
                $ids[] = $rec["usr_id"];
            }
            return $ids;
        }
    }

    public static function _lookupLastLogin($a_user_id)
    {
        return ilObjUser::_lookup($a_user_id, "last_login");
    }


    public function refreshLogin()
    {
        global $ilDB;

        $ilDB->manipulateF(
            "UPDATE usr_data SET " .
             "last_login = " . $ilDB->now() .
             " WHERE usr_id = %s",
            array("integer"),
            array($this->id)
        );
    }


    public function resetPassword($raw, $raw_retype)
    {
        global $ilDB;

        if (func_num_args() != 2) {
            return false;
        }

        if (!isset($raw) || !isset($raw_retype)) {
            return false;
        }

        if ($raw != $raw_retype) {
            return false;
        }

        require_once 'Services/User/classes/class.ilUserPasswordManager.php';
        ilUserPasswordManager::getInstance()->encodePassword($this, $raw);

        $ilDB->manipulateF(
            'UPDATE usr_data
                        SET passwd = %s, passwd_enc_type = %s, passwd_salt = %s
                        WHERE usr_id = %s',
            array('text', 'text', 'text', 'integer'),
            array($this->getPasswd(), $this->getPasswordEncodingType(), $this->getPasswordSalt(), $this->getId())
        );

        return true;
    }

    public static function _doesLoginnameExistInHistory($a_login)
    {
        global $ilDB;
            
        $res = $ilDB->queryF(
            '
                        SELECT * FROM loginname_history
                        WHERE login = %s',
            array('text'),
            array($a_login)
        );

        return $ilDB->fetchAssoc($res) ? true : false;
    }
    
    public static function _getLastHistoryDataByUserId($a_usr_id)
    {
        global $ilDB;
            
        $ilDB->setLimit(1, 0);
        $res = $ilDB->queryF(
            '
                        SELECT login, history_date FROM loginname_history
                        WHERE usr_id = %s ORDER BY history_date DESC',
            array('integer'),
            array($a_usr_id)
        );
        $row = $ilDB->fetchAssoc($res);
        if (!is_array($row) || !count($row)) {
            throw new ilUserException('');
        }
        
        return array(
            $row['login'], $row['history_date']
        );
    }
    
    public function updateLogin($a_login)
    {
        global $ilDB, $ilSetting;

        if (func_num_args() != 1) {
            return false;
        }

        if (!isset($a_login)) {
            return false;
        }
        
        $former_login = self::_lookupLogin($this->getId());

        // Update not necessary
        if (0 == strcmp($a_login, $former_login)) {
            return false;
        }
        
        try {
            $last_history_entry = ilObjUser::_getLastHistoryDataByUserId($this->getId());
        } catch (ilUserException $e) {
            $last_history_entry = null;
        }
    
        // throw exception if the desired loginame is already in history and it is not allowed to reuse it
        if ((int) $ilSetting->get('allow_change_loginname') &&
           (int) $ilSetting->get('reuse_of_loginnames') == 0 &&
           self::_doesLoginnameExistInHistory($a_login)) {
            throw new ilUserException($this->lng->txt('loginname_already_exists'));
        } elseif ((int) $ilSetting->get('allow_change_loginname') &&
                (int) $ilSetting->get('loginname_change_blocking_time') &&
                is_array($last_history_entry) &&
                $last_history_entry[1] + (int) $ilSetting->get('loginname_change_blocking_time') > time()) {
            include_once 'Services/Calendar/classes/class.ilDate.php';
            throw new ilUserException(
                sprintf(
                    $this->lng->txt('changing_loginname_not_possible_info'),
                    ilDatePresentation::formatDate(
                        new ilDateTime($last_history_entry[1], IL_CAL_UNIX)
                    ),
                    ilDatePresentation::formatDate(
                        new ilDateTime(($last_history_entry[1] + (int) $ilSetting->get('loginname_change_blocking_time')), IL_CAL_UNIX)
                    )
                )
            );
        } else {
            // log old loginname in history
            if ((int) $ilSetting->get('allow_change_loginname') &&
               (int) $ilSetting->get('create_history_loginname')) {
                ilObjUser::_writeHistory($this->getId(), $former_login);
            }

            //update login
            $this->login = $a_login;

            $ilDB->manipulateF(
                '
                                UPDATE usr_data
                                SET login = %s
                                WHERE usr_id = %s',
                array('text', 'integer'),
                array($this->getLogin(), $this->getId())
            );
        }

        return true;
    }

    public function writePref($a_keyword, $a_value)
    {
        self::_writePref($this->id, $a_keyword, $a_value);
        $this->setPref($a_keyword, $a_value);
    }


    public function deletePref($a_keyword)
    {
        self::_deletePref($this->getId(), $a_keyword);
    }

    public static function _deletePref($a_user_id, $a_keyword)
    {
        global $ilDB;

        $ilDB->manipulateF(
            'DELETE FROM usr_pref WHERE usr_id = %s AND keyword = %s',
            array('integer', 'text'),
            array($a_user_id, $a_keyword)
        );
    }

    public static function _deleteAllPref($a_user_id)
    {
        global $ilDB;

        $ilDB->manipulateF(
            "DELETE FROM usr_pref WHERE usr_id = %s",
            array("integer"),
            array($a_user_id)
        );
    }

    public static function _writePref($a_usr_id, $a_keyword, $a_value)
    {
        global $ilDB;
        $ilDB->replace(
            "usr_pref",
            array(
                "usr_id" => array("integer", $a_usr_id),
                "keyword" => array("text", $a_keyword),
            ),
            array(
                "value" => array("text",$a_value)
            )
        );

        /*
        self::_deletePref($a_usr_id, $a_keyword);
        if(strlen($a_value))
        {
            $ilDB->manipulateF(
                'INSERT INTO usr_pref (usr_id, keyword, value) VALUES (%s, %s, %s)',
                array('integer', 'text', 'text'),
                array($a_usr_id, $a_keyword, $a_value)
            );
        }*/
    }

    public function writePrefs()
    {
        global $ilDB;

        ilObjUser::_deleteAllPref($this->id);
        foreach ($this->prefs as $keyword => $value) {
            self::_writePref($this->id, $keyword, $value);
        }
    }

    public function getTimeZone()
    {
        if ($tz = $this->getPref('user_tz')) {
            return $tz;
        } else {
            include_once('Services/Calendar/classes/class.ilCalendarSettings.php');
            $settings = ilCalendarSettings::_getInstance();
            return $settings->getDefaultTimeZone();
        }
    }

    public function getTimeFormat()
    {
        if ($format = $this->getPref('time_format')) {
            return $format;
        } else {
            include_once('Services/Calendar/classes/class.ilCalendarSettings.php');
            $settings = ilCalendarSettings::_getInstance();
            return $settings->getDefaultTimeFormat();
        }
    }

    public function getDateFormat()
    {
        if ($format = $this->getPref('date_format')) {
            return $format;
        } else {
            include_once('Services/Calendar/classes/class.ilCalendarSettings.php');
            $settings = ilCalendarSettings::_getInstance();
            return $settings->getDefaultDateFormat();
        }
    }

    public function setPref($a_keyword, $a_value)
    {
        if ($a_keyword != "") {
            $this->prefs[$a_keyword] = $a_value;
        }
    }

    public function getPref($a_keyword)
    {
        if (array_key_exists($a_keyword, $this->prefs)) {
            return $this->prefs[$a_keyword];
        } else {
            return false;
        }
    }

    public static function _lookupPref($a_usr_id, $a_keyword)
    {
        global $ilDB;

        $query = "SELECT * FROM usr_pref WHERE usr_id = " . $ilDB->quote($a_usr_id, "integer") . " " .
            "AND keyword = " . $ilDB->quote($a_keyword, "text");
        $res = $ilDB->query($query);

        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return $row->value;
        }
        return false;
    }

    public function readPrefs()
    {
        global $ilDB;

        if (is_array($this->prefs)) {
            $this->oldPrefs = $this->prefs;
        }

        $this->prefs = ilObjUser::_getPreferences($this->id);
    }

    public function delete()
    {
        global $rbacadmin, $ilDB;

        // deassign from ldap groups
        include_once('Services/LDAP/classes/class.ilLDAPRoleGroupMapping.php');
        $mapping = ilLDAPRoleGroupMapping::_getInstance();
        $mapping->deleteUser($this->getId());

        // remove mailbox / update sent mails
        include_once("Services/Mail/classes/class.ilMailbox.php");
        $mailbox = new ilMailbox($this->getId());
        $mailbox->delete();
        $mailbox->updateMailsOfDeletedUser($this->getLogin());

        // delete feed blocks on personal desktop
        include_once("./Services/Block/classes/class.ilCustomBlock.php");
        $costum_block = new ilCustomBlock();
        $costum_block->setContextObjId($this->getId());
        $costum_block->setContextObjType("user");
        $c_blocks = $costum_block->queryBlocksForContext();
        include_once("./Services/Feeds/classes/class.ilPDExternalFeedBlock.php");
        foreach ($c_blocks as $c_block) {
            if ($c_block["type"] == "pdfeed") {
                $fb = new ilPDExternalFeedBlock($c_block["id"]);
                $fb->delete();
            }
        }


        // delete block settings
        include_once("./Services/Block/classes/class.ilBlockSetting.php");
        ilBlockSetting::_deleteSettingsOfUser($this->getId());

        // delete user_account
        $ilDB->manipulateF(
            "DELETE FROM usr_data WHERE usr_id = %s",
            array("integer"),
            array($this->getId())
        );
        
        $this->deleteMultiTextFields();

        // delete user_prefs
        ilObjUser::_deleteAllPref($this->getId());
            
        $this->removeUserPicture(false); // #8597

        // delete user_session
        include_once("./Services/Authentication/classes/class.ilSession.php");
        ilSession::_destroyByUserId($this->getId());

        // remove user from rbac
        $rbacadmin->removeUser($this->getId());

        // remove bookmarks
        // TODO: move this to class.ilBookmarkFolder
        $q = "DELETE FROM bookmark_tree WHERE tree = " .
            $ilDB->quote($this->getId(), "integer");
        $ilDB->manipulate($q);

        $q = "DELETE FROM bookmark_data WHERE user_id = " .
            $ilDB->quote($this->getId(), "integer");
        $ilDB->manipulate($q);

        // DELETE FORUM ENTRIES (not complete in the moment)
        include_once './Modules/Forum/classes/class.ilObjForum.php';
        ilObjForum::_deleteUser($this->getId());

        // Delete link check notify entries
        include_once './Services/LinkChecker/classes/class.ilLinkCheckNotify.php';
        ilLinkCheckNotify::_deleteUser($this->getId());

        // Delete crs entries
        include_once './Modules/Course/classes/class.ilObjCourse.php';
        ilObjCourse::_deleteUser($this->getId());

        // Delete user tracking
        include_once './Services/Tracking/classes/class.ilObjUserTracking.php';
        ilObjUserTracking::_deleteUser($this->getId());

        include_once 'Modules/Session/classes/class.ilEventParticipants.php';
        ilEventParticipants::_deleteByUser($this->getId());
        
        // Delete Tracking data SCORM 2004 RTE
        include_once 'Modules/Scorm2004/classes/ilSCORM13Package.php';
        ilSCORM13Package::_removeTrackingDataForUser($this->getId());
        
        // Delete Tracking data SCORM 1.2 RTE
        include_once 'Modules/ScormAicc/classes/class.ilObjSCORMLearningModule.php';
        ilObjSCORMLearningModule::_removeTrackingDataForUser($this->getId());

        // remove all notifications
        include_once "./Services/Notification/classes/class.ilNotification.php";
        ilNotification::removeForUser($this->getId());
        
        // remove portfolios
        include_once "./Modules/Portfolio/classes/class.ilObjPortfolio.php";
        ilObjPortfolio::deleteUserPortfolios($this->getId());
        
        // remove workspace
        include_once "./Services/PersonalWorkspace/classes/class.ilWorkspaceTree.php";
        $tree = new ilWorkspaceTree($this->getId());
        $tree->cascadingDelete();
        
        // remove disk quota entries
        include_once "./Services/DiskQuota/classes/class.ilDiskQuotaHandler.php";
        ilDiskQuotaHandler::deleteByOwner($this->getId());
        
        // remove reminder entries
        require_once 'Services/User/classes/class.ilCronDeleteInactiveUserReminderMail.php';
        ilCronDeleteInactiveUserReminderMail::removeSingleUserFromTable($this->getId());
        
        // badges
        include_once "Services/Badge/classes/class.ilBadgeAssignment.php";
        ilBadgeAssignment::deleteByUserId($this->getId());

        // remove org unit assignments
        $ilOrgUnitUserAssignmentQueries = ilOrgUnitUserAssignmentQueries::getInstance();
        $ilOrgUnitUserAssignmentQueries->deleteAllAssignmentsOfUser($this->getId());
        
        // Delete user defined field entries
        $this->deleteUserDefinedFieldEntries();
        
        // Delete clipboard entries
        $this->clipboardDeleteAll();
        
        // Reset owner
        $this->resetOwner();

        // Trigger deleteUser Event
        global $ilAppEventHandler;
        $ilAppEventHandler->raise(
            'Services/User',
            'deleteUser',
            array('usr_id' => $this->getId())
        );

        // delete object data
        parent::delete();
        return true;
    }

    public function setFullname($a_title = "", $a_firstname = "", $a_lastname = "")
    {
        $this->fullname = "";

        if ($a_title) {
            $fullname = $a_title . " ";
        } elseif ($this->utitle) {
            $this->fullname = $this->utitle . " ";
        }

        if ($a_firstname) {
            $fullname .= $a_firstname . " ";
        } elseif ($this->firstname) {
            $this->fullname .= $this->firstname . " ";
        }

        if ($a_lastname) {
            return $fullname . $a_lastname;
        }

        $this->fullname .= $this->lastname;
    }

    public function getFullname($a_max_strlen = 0)
    {
        if (!$a_max_strlen) {
            return ilUtil::stripSlashes($this->fullname);
        }

        if (strlen($this->fullname) <= $a_max_strlen) {
            return ilUtil::stripSlashes($this->fullname);
        }

        if ((strlen($this->utitle) + strlen($this->lastname) + 4) <= $a_max_strlen) {
            return ilUtil::stripSlashes($this->utitle . " " . substr($this->firstname, 0, 1) . ". " . $this->lastname);
        }

        if ((strlen($this->firstname) + strlen($this->lastname) + 1) <= $a_max_strlen) {
            return ilUtil::stripSlashes($this->firstname . " " . $this->lastname);
        }

        if ((strlen($this->lastname) + 3) <= $a_max_strlen) {
            return ilUtil::stripSlashes(substr($this->firstname, 0, 1) . ". " . $this->lastname);
        }

        return ilUtil::stripSlashes(substr($this->lastname, 0, $a_max_strlen));
    }

    public function setLogin($a_str)
    {
        $this->login = $a_str;
    }

    public function getLogin()
    {
        return $this->login;
    }

    public function setPasswd($a_str, $a_type = IL_PASSWD_PLAIN)
    {
        $this->passwd = $a_str;
        $this->passwd_type = $a_type;
    }

    public function getPasswd()
    {
        return $this->passwd;
    }
    public function getPasswdType()
    {
        return $this->passwd_type;
    }

    public function setGender($a_str)
    {
        $this->gender = substr($a_str, -1);
    }

    public function getGender()
    {
        return $this->gender;
    }

    public function setUTitle($a_str)
    {
        $this->utitle = $a_str;
    }

    public function getUTitle()
    {
        return $this->utitle;
    }

    public function setFirstname($a_str)
    {
        $this->firstname = $a_str;
    }

    public function getFirstname()
    {
        return $this->firstname;
    }

    public function setLastname($a_str)
    {
        $this->lastname = $a_str;
    }

    public function getLastname()
    {
        return $this->lastname;
    }

    public function setInstitution($a_str)
    {
        $this->institution = $a_str;
    }

    public function getInstitution()
    {
        return $this->institution;
    }

    public function setDepartment($a_str)
    {
        $this->department = $a_str;
    }

    public function getDepartment()
    {
        return $this->department;
    }

    public function setStreet($a_str)
    {
        $this->street = $a_str;
    }

    public function getStreet()
    {
        return $this->street;
    }

    public function setCity($a_str)
    {
        $this->city = $a_str;
    }

    public function getCity()
    {
        return $this->city;
    }

    public function setZipcode($a_str)
    {
        $this->zipcode = $a_str;
    }

    public function getZipcode()
    {
        return $this->zipcode;
    }

    public function setCountry($a_str)
    {
        $this->country = $a_str;
    }

    public function getCountry()
    {
        return $this->country;
    }

    public function setSelectedCountry($a_val)
    {
        $this->sel_country = $a_val;
    }

    public function getSelectedCountry()
    {
        return $this->sel_country;
    }

    public function setPhoneOffice($a_str)
    {
        $this->phone_office = $a_str;
    }

    public function getPhoneOffice()
    {
        return $this->phone_office;
    }

    public function setPhoneHome($a_str)
    {
        $this->phone_home = $a_str;
    }

    public function getPhoneHome()
    {
        return $this->phone_home;
    }

    public function setPhoneMobile($a_str)
    {
        $this->phone_mobile = $a_str;
    }

    public function getPhoneMobile()
    {
        return $this->phone_mobile;
    }

    public function setFax($a_str)
    {
        $this->fax = $a_str;
    }

    public function getFax()
    {
        return $this->fax;
    }

    public function setClientIP($a_str)
    {
        $this->client_ip = $a_str;
    }

    public function getClientIP()
    {
        return $this->client_ip;
    }

    public function setMatriculation($a_str)
    {
        $this->matriculation = $a_str;
    }

    public function getMatriculation()
    {
        return $this->matriculation;
    }

    public static function lookupMatriculation($a_usr_id)
    {
        global $ilDB;
        
        $query = "SELECT matriculation FROM usr_data " .
            "WHERE usr_id = " . $ilDB->quote($a_usr_id);
        $res = $ilDB->query($query);
        $row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT);
        return $row->matriculation ? $row->matriculation : '';
    }

    public function setEmail($a_str)
    {
        $this->email = $a_str;
    }

    public function getEmail()
    {
        return $this->email;
    }
    
    public function getSecondEmail()
    {
        return $this->second_email;
    }
    
    public function setSecondEmail($second_email)
    {
        $this->second_email = $second_email;
    }
    
    public function setHobby($a_str)
    {
        $this->hobby = $a_str;
    }

    public function getHobby()
    {
        return $this->hobby;
    }

    public function setLanguage($a_str)
    {
        $this->setPref("language", $a_str);
        unset($_SESSION['lang']);
    }

    public function getLanguage()
    {
        return $this->prefs["language"];
    }

    public function setDiskQuota($a_disk_quota)
    {
        $this->setPref("disk_quota", $a_disk_quota);
    }

    public function getDiskQuota()
    {
        return $this->prefs["disk_quota"] ? $this->prefs["disk_quota"] : 0;
    }
    
    public function getPersonalWorkspaceDiskQuota()
    {
        return $this->prefs["wsp_disk_quota"] ? $this->prefs["wsp_disk_quota"] : 0;
    }

    public function setLastPasswordChangeTS($a_last_password_change_ts)
    {
        $this->last_password_change_ts = $a_last_password_change_ts;
    }

    public function getLastPasswordChangeTS()
    {
        return $this->last_password_change_ts;
    }


    public static function _lookupLanguage($a_usr_id)
    {
        global $DIC;

        $ilDB = $DIC->database();
        $lng = $DIC->language();

        $q = "SELECT value FROM usr_pref WHERE usr_id= " .
            $ilDB->quote($a_usr_id, "integer") . " AND keyword = " .
            $ilDB->quote('language', "text");
        $r = $ilDB->query($q);

        while ($row = $ilDB->fetchAssoc($r)) {
            return $row['value'];
        }
        if (is_object($lng)) {
            return $lng->getDefaultLanguage();
        }
        return 'en';
    }

    public static function _writeExternalAccount($a_usr_id, $a_ext_id)
    {
        global $ilDB;

        $ilDB->manipulateF(
            "UPDATE usr_data " .
            " SET ext_account = %s WHERE usr_id = %s",
            array("text", "integer"),
            array($a_ext_id, $a_usr_id)
        );
    }

    public static function _writeAuthMode($a_usr_id, $a_auth_mode)
    {
        global $ilDB;

        $ilDB->manipulateF(
            "UPDATE usr_data " .
            " SET auth_mode = %s WHERE usr_id = %s",
            array("text", "integer"),
            array($a_auth_mode, $a_usr_id)
        );
    }

    public function getCurrentLanguage()
    {
        return $_SESSION['lang'];
    }

    public function setCurrentLanguage($a_val)
    {
        $_SESSION['lang'] = $a_val;
    }

    public function setLastLogin($a_str)
    {
        $this->last_login = $a_str;
    }

    public function getLastLogin()
    {
        return $this->last_login;
    }

    public function setLastUpdate($a_str)
    {
        $this->last_update = $a_str;
    }
    public function getLastUpdate()
    {
        return $this->last_update;
    }

    public function setComment($a_str)
    {
        $this->referral_comment = $a_str;
    }

    public function getComment()
    {
        return $this->referral_comment;
    }

    public function setApproveDate($a_str)
    {
        $this->approve_date = $a_str;
    }

    public function getApproveDate()
    {
        return $this->approve_date;
    }

    // BEGIN DiskQuota: show when user accepted user agreement
    public function getAgreeDate()
    {
        return $this->agree_date;
    }
    public function setAgreeDate($a_str)
    {
        $this->agree_date = $a_str;
    }
    // END DiskQuota: show when user accepted user agreement

    public function setActive($a_active, $a_owner = 0)
    {
        $this->setOwner($a_owner);

        if ($a_active) {
            $this->active = 1;
            $this->setApproveDate(date('Y-m-d H:i:s'));
            $this->setOwner($a_owner);
        } else {
            $this->active = 0;
            $this->setApproveDate(null);
        }
    }

    public function getActive()
    {
        return $this->active;
    }

    public static function _lookupActive($a_usr_id)
    {
        global $ilDB;

        $query = 'SELECT usr_id FROM usr_data ' .
            'WHERE active = ' . $ilDB->quote(1, 'integer') . ' ' .
            'AND usr_id = ' . $ilDB->quote($a_usr_id, 'integer');
        $res = $ilDB->query($query);
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            return true;
        }
        return false;
    }

    public function syncActive()
    {
        global $ilAuth;

        $storedActive   = 0;
        if ($this->getStoredActive($this->id)) {
            $storedActive   = 1;
        }

        $currentActive  = 0;
        if ($this->active) {
            $currentActive  = 1;
        }

        if ((!empty($storedActive) && empty($currentActive)) ||
                (empty($storedActive) && !empty($currentActive))) {
            $this->setActive($currentActive, self::getUserIdByLogin(ilObjUser::getLoginFromAuth()));
        }
    }

    public function getStoredActive($a_id)
    {
        $active = ilObjUser::_lookup($a_id, "active");
        return $active ? true : false;
    }

    public function setSkin($a_str)
    {
        // TODO: exception handling (dir exists)
        $this->skin = $a_str;
    }

    public function setTimeLimitOwner($a_owner)
    {
        $this->time_limit_owner = $a_owner;
    }
    public function getTimeLimitOwner()
    {
        return $this->time_limit_owner ? $this->time_limit_owner : 7;
    }
    public function setTimeLimitFrom($a_from)
    {
        $this->time_limit_from = $a_from;
    }
    public function getTimeLimitFrom()
    {
        return $this->time_limit_from;
    }
    public function setTimeLimitUntil($a_until)
    {
        $this->time_limit_until = $a_until;
    }
    public function getTimeLimitUntil()
    {
        return $this->time_limit_until;
    }
    public function setTimeLimitUnlimited($a_unlimited)
    {
        $this->time_limit_unlimited = $a_unlimited;
    }
    public function getTimeLimitUnlimited()
    {
        return $this->time_limit_unlimited;
    }
    public function setTimeLimitMessage($a_time_limit_message)
    {
        return $this->time_limit_message = $a_time_limit_message;
    }
    public function getTimeLimitMessage()
    {
        return $this->time_limit_message;
    }

    public function setLoginAttempts($a_login_attempts)
    {
        $this->login_attempts = $a_login_attempts;
    }

    public function getLoginAttempts()
    {
        return $this->login_attempts;
    }


    public function checkTimeLimit()
    {
        if ($this->getTimeLimitUnlimited()) {
            return true;
        }
        if ($this->getTimeLimitFrom() < time() and $this->getTimeLimitUntil() > time()) {
            return true;
        }
        return false;
    }
    public function setProfileIncomplete($a_prof_inc)
    {
        $this->profile_incomplete = (boolean) $a_prof_inc;
    }
    public function getProfileIncomplete()
    {
        if ($this->id == ANONYMOUS_USER_ID) {
            return false;
        }
        return $this->profile_incomplete;
    }

    public function isPasswordChangeDemanded()
    {
        if ($this->id == ANONYMOUS_USER_ID) {
            return false;
        }

        if ($this->id == SYSTEM_USER_ID) {
            require_once './Services/User/classes/class.ilUserPasswordManager.php';
            if (
                \ilUserPasswordManager::getInstance()->verifyPassword($this, base64_decode('aG9tZXI=')) &&
                !ilAuthUtils::_needsExternalAccountByAuthMode($this->getAuthMode(true))
            ) {
                return true;
            } else {
                return false;
            }
        }

        require_once('./Services/PrivacySecurity/classes/class.ilSecuritySettings.php');
        $security = ilSecuritySettings::_getInstance();

        if (
            !ilAuthUtils::_needsExternalAccountByAuthMode($this->getAuthMode(true)) &&
            $security->isPasswordChangeOnFirstLoginEnabled() &&
            $this->getLastPasswordChangeTS() == 0 &&
            $this->is_self_registered == false
        ) {
            return true;
        }

        return false;
    }

    public function isPasswordExpired()
    {
        if ($this->id == ANONYMOUS_USER_ID) {
            return false;
        }

        require_once('./Services/PrivacySecurity/classes/class.ilSecuritySettings.php');
        $security = ilSecuritySettings::_getInstance();
        if ($this->getLastPasswordChangeTS() > 0) {
            $max_pass_age = $security->getPasswordMaxAge();
            if ($max_pass_age > 0) {
                $max_pass_age_ts = ($max_pass_age * 86400);
                $pass_change_ts  = $this->getLastPasswordChangeTS();
                $current_ts      = time();

                if (($current_ts - $pass_change_ts) > $max_pass_age_ts) {
                    if (!ilAuthUtils::_needsExternalAccountByAuthMode($this->getAuthMode(true))) {
                        return true;
                    }
                }
            }
        }

        return false;
    }

    public function getPasswordAge()
    {
        $current_ts = time();
        $pass_change_ts = $this->getLastPasswordChangeTS();
        $password_age = (int) (($current_ts - $pass_change_ts) / 86400);
        return $password_age;
    }

    public function setLastPasswordChangeToNow()
    {
        global $ilDB;
        
        $this->setLastPasswordChangeTS(time());

        $query = "UPDATE usr_data SET last_password_change = %s " .
                "WHERE usr_id = %s";
        $affected = $ilDB->manipulateF(
            $query,
            array('integer','integer'),
            array($this->getLastPasswordChangeTS(),$this->id)
        );
        if ($affected) {
            return true;
        } else {
            return false;
        }
    }

    public function resetLastPasswordChange()
    {
        global $ilDB;
        
        $query = "UPDATE usr_data SET last_password_change = 0 " .
                "WHERE usr_id = %s";
        $affected = $ilDB->manipulateF(
            $query,
            array('integer'),
            array($this->getId())
        );
        if ($affected) {
            return true;
        } else {
            return false;
        }
    }

    public function setLatitude($a_latitude)
    {
        $this->latitude = $a_latitude;
    }

    public function getLatitude()
    {
        return $this->latitude;
    }

    public function setLongitude($a_longitude)
    {
        $this->longitude = $a_longitude;
    }

    public function getLongitude()
    {
        return $this->longitude;
    }

    public function setLocationZoom($a_locationzoom)
    {
        $this->loc_zoom = $a_locationzoom;
    }

    public function getLocationZoom()
    {
        return $this->loc_zoom;
    }

    
    public static function hasActiveSession($a_user_id, $a_session_id)
    {
        global $ilDB;
    
        $set = $ilDB->queryf(
            '
                        SELECT COUNT(*) session_count
                        FROM usr_session WHERE user_id = %s AND expires > %s AND session_id != %s ',
            array('integer', 'integer', 'text'),
            array($a_user_id, time(), $a_session_id)
        );
        $row = $ilDB->fetchAssoc($set);
        return (bool) $row['session_count'];
    }

    /*
     * check user id with login name
     * @access  public
     */
    public function checkUserId()
    {
        global $ilAuth, $ilSetting;

        $login = ilObjUser::getLoginFromAuth();
        $id = ilObjUser::_lookupId($login);
        if ($id > 0) {
            return $id;
        }
        return false;
    }

    private static function getLoginFromAuth()
    {
        global $ilAuth;

        $uid = $GLOBALS['DIC']['ilAuthSession']->getUserId();
        $login = ilObjUser::_lookupLogin($uid);

        // BEGIN WebDAV: Strip Microsoft Domain Names from logins
        require_once('Services/WebDAV/classes/class.ilDAVActivationChecker.php');
        if (ilDAVActivationChecker::_isActive()) {
            $login = self::toUsernameWithoutDomain($login);
        }
        return $login;
    }
    
    public static function toUsernameWithoutDomain($a_login)
    {
        // Remove all characters including the last slash or the last backslash
        // in the username
        $pos = strrpos($a_login, '/');
        $pos2 = strrpos($a_login, '\\');
        if ($pos === false || $pos < $pos2) {
            $pos = $pos2;
        }
        if ($pos !== false) {
            $a_login = substr($a_login, $pos + 1);
        }
        return $a_login;
    }

    /*
     * check to see if current user has been made active
     * @access  public
     * @return  true if active, otherwise false
     */
    public function isCurrentUserActive()
    {
        global $ilDB,$ilAuth;

        $login = ilObjUser::getLoginFromAuth();
        $set = $ilDB->queryF(
            "SELECT active FROM usr_data WHERE login= %s",
            array("text"),
            array($login)
        );
        //query has got a result
        if ($rec = $ilDB->fetchAssoc($set)) {
            if ($rec["active"]) {
                return true;
            }
        }
        
        return false;
    }

    /*
     * STATIC METHOD
     * get the user_id of a login name
     * @param   string login name
     * @return  integer id of user
     * @static
     * @access  public
     */
    public static function getUserIdByLogin($a_login)
    {
        return (int) ilObjUser::_lookupId($a_login);
    }

    public static function _getUserIdsByEmail($a_email)
    {
        global $ilias, $ilDB;

        $res = $ilDB->queryF(
            "SELECT login FROM usr_data " .
            "WHERE email = %s and active = 1",
            array("text"),
            array($a_email)
        );
        $ids = array();
        while ($row = $ilDB->fetchObject($res)) {
            $ids[] = $row->login;
        }

        return $ids;
    }



    public function getUserIdByEmail($a_email)
    {
        global $ilDB;

        $res = $ilDB->queryF("SELECT usr_id FROM usr_data " .
            "WHERE email = %s", array("text"), array($a_email));

        $row = $ilDB->fetchObject($res);
        return $row->usr_id ? $row->usr_id : 0;
    }

    /*
     * STATIC METHOD
     * get the login name of a user_id
     * @param   integer id of user
     * @return  string login name; false if not found
     * @static
     * @access  public
     */
    public function getLoginByUserId($a_userid)
    {
        $login = ilObjUser::_lookupLogin($a_userid);
        return $login ? $login : false;
    }

    public static function searchUsers($a_search_str, $active = 1, $a_return_ids_only = false, $filter_settings = false)
    {
        global $ilias, $ilDB, $ilLog;

        
        $query = "SELECT usr_data.usr_id, usr_data.login, usr_data.firstname, usr_data.lastname, usr_data.email, usr_data.active FROM usr_data ";
        
        $without_anonymous_users = true;

        // determine join filter
        $join_filter = " WHERE ";
        if ($filter_settings !== false && strlen($filter_settings)) {
            switch ($filter_settings) {
                case 3:
                    // show only users without courses
                    $join_filter = " LEFT JOIN obj_members ON usr_data.usr_id = obj_members.usr_id WHERE obj_members.usr_id IS NULL AND ";
                    break;
                case 5:
                    // show only users with a certain course membership
                    $ref_id = $_SESSION["user_filter_data"];
                    if ($ref_id) {
                        $join_filter = " LEFT JOIN obj_members ON usr_data.usr_id = obj_members.usr_id WHERE obj_members.obj_id = " .
                            "(SELECT obj_id FROM object_reference WHERE ref_id = " . $ilDB->quote($ref_id, "integer") . ") AND ";
                    }
                    break;
                case 6:
                    global $rbacreview;
                    $ref_id = $_SESSION["user_filter_data"];
                    if ($ref_id) {
                        $local_roles = $rbacreview->getRolesOfRoleFolder($ref_id, false);
                        if (is_array($local_roles) && count($local_roles)) {
                            $join_filter = " LEFT JOIN rbac_ua ON usr_data.usr_id = rbac_ua.usr_id WHERE " .
                                $ilDB->in("rbac_ua.rol_id", $local_roles, false, $local_roles) . " AND ";
                        }
                    }
                    break;
                case 7:
                    global $rbacreview;
                    $rol_id = $_SESSION["user_filter_data"];
                    if ($rol_id) {
                        $join_filter = " LEFT JOIN rbac_ua ON usr_data.usr_id = rbac_ua.usr_id WHERE rbac_ua.rol_id = " .
                            $ilDB->quote($rol_id, "integer") . " AND ";
                        $without_anonymous_users = false;
                    }
                    break;
            }
        }
        // This is a temporary hack to search users by their role
        // See Mantis #338. This is a hack due to Mantis #337.
        if (strtolower(substr($a_search_str, 0, 5)) == "role:") {
            $query = "SELECT DISTINCT usr_data.usr_id,usr_data.login,usr_data.firstname,usr_data.lastname,usr_data.email " .
                "FROM object_data,rbac_ua,usr_data " .
                "WHERE " . $ilDB->like("object_data.title", "text", "%" . substr($a_search_str, 5) . "%") .
                " AND object_data.type = 'role' " .
                "AND rbac_ua.rol_id = object_data.obj_id " .
                "AND usr_data.usr_id = rbac_ua.usr_id " .
                "AND rbac_ua.usr_id != " . $ilDB->quote(ANONYMOUS_USER_ID, "integer");
        } else {
            $query.= $join_filter .
                "(" . $ilDB->like("usr_data.login", "text", "%" . $a_search_str . "%") . " " .
                "OR " . $ilDB->like("usr_data.firstname", "text", "%" . $a_search_str . "%") . " " .
                "OR " . $ilDB->like("usr_data.lastname", "text", "%" . $a_search_str . "%") . " " .
                "OR " . $ilDB->like("usr_data.email", "text", "%" . $a_search_str . "%") . ") ";

            if ($filter_settings !== false && strlen($filter_settings)) {
                switch ($filter_settings) {
                    case 0:
                        $query.= " AND usr_data.active = " . $ilDB->quote(0, "integer") . " ";
                        break;
                    case 1:
                        $query.= " AND usr_data.active = " . $ilDB->quote(1, "integer") . " ";
                        break;
                    case 2:
                        $query.= " AND usr_data.time_limit_unlimited = " . $ilDB->quote(0, "integer") . " ";
                        break;
                    case 4:
                        $date = strftime("%Y-%m-%d %H:%I:%S", mktime(0, 0, 0, $_SESSION["user_filter_data"]["m"], $_SESSION["user_filter_data"]["d"], $_SESSION["user_filter_data"]["y"]));
                        $query.= " AND last_login < " . $ilDB->quote($date, "timestamp") . " ";
                        break;
                }
            }
                
            if ($without_anonymous_users) {
                $query.= "AND usr_data.usr_id != " . $ilDB->quote(ANONYMOUS_USER_ID, "integer");
            }

            if (is_numeric($active) && $active > -1 && $filter_settings === false) {
                $query.= " AND active = " . $ilDB->quote($active, "integer") . " ";
            }
        }
        $ilLog->write($query);
        $res = $ilDB->query($query);
        while ($row = $ilDB->fetchObject($res)) {
            $users[] = array(
                "usr_id"    => $row->usr_id,
                "login"     => $row->login,
                "firstname" => $row->firstname,
                "lastname"  => $row->lastname,
                "email"     => $row->email,
                "active"    => $row->active);
            $ids[] = $row->usr_id;
        }
        if ($a_return_ids_only) {
            return $ids ? $ids : array();
        } else {
            return $users ? $users : array();
        }
    }

    public static function getAllUserLogins()
    {
        global $ilDB;

        $logins = array();

        $res = $ilDB->query(
            "SELECT login FROM usr_data WHERE " . $ilDB->in('usr_id', array(ANONYMOUS_USER_ID), true, 'integer')
        );
        while ($row = $ilDB->fetchAssoc($res)) {
            $logins[] = $row['login'];
        }

        return $logins;
    }

    public static function _readUsersProfileData($a_user_ids)
    {
        global $ilDB;
        $res = $ilDB->query("SELECT * FROM usr_data WHERE " .
            $ilDB->in("usr_id", $a_user_ids, false, "integer"));
        while ($row = $ilDB->fetchAssoc($res)) {
            $user_data["$row[usr_id]"] = $row;
        }
        return $user_data ? $user_data : array();
    }

    public static function _getAllUserData($a_fields = null, $active =-1)
    {
        global $ilDB;

        $result_arr = array();
        $types = array();
        $values = array();

        if ($a_fields !== null and is_array($a_fields)) {
            if (count($a_fields) == 0) {
                $select = "*";
            } else {
                if (($usr_id_field = array_search("usr_id", $a_fields)) !== false) {
                    unset($a_fields[$usr_id_field]);
                }

                $select = implode(",", $a_fields) . ",usr_data.usr_id";
                // online time
                if (in_array('online_time', $a_fields)) {
                    $select .= ",ut_online.online_time ";
                }
            }

            $q = "SELECT " . $select . " FROM usr_data ";

            // Add online_time if desired
            // Need left join here to show users that never logged in
            if (in_array('online_time', $a_fields)) {
                $q .= "LEFT JOIN ut_online ON usr_data.usr_id = ut_online.usr_id ";
            }

            switch ($active) {
                case 0:
                case 1:
                    $q .= "WHERE active = " . $ilDB->quote($active, "integer");
                    break;
                case 2:
                    $q .= "WHERE time_limit_unlimited= " . $ilDB->quote(0, "integer");;
                    break;
                case 3:
                    $qtemp = $q . ", rbac_ua, object_data WHERE rbac_ua.rol_id = object_data.obj_id AND " .
                        $ilDB->like("object_data.title", "text", "%crs%") . " AND usr_data.usr_id = rbac_ua.usr_id";
                    $r = $ilDB->query($qtemp);
                    $course_users = array();
                    while ($row = $ilDB->fetchAssoc($r)) {
                        array_push($course_users, $row["usr_id"]);
                    }
                    if (count($course_users)) {
                        $q .= " WHERE " . $ilDB->in("usr_data.usr_id", $course_users, true, "integer") . " ";
                    } else {
                        return $result_arr;
                    }
                    break;
                case 4:
                    $date = strftime("%Y-%m-%d %H:%I:%S", mktime(0, 0, 0, $_SESSION["user_filter_data"]["m"], $_SESSION["user_filter_data"]["d"], $_SESSION["user_filter_data"]["y"]));
                    $q.= " AND last_login < " . $ilDB->quote($date, "timestamp");
                    break;
                case 5:
                    $ref_id = $_SESSION["user_filter_data"];
                    if ($ref_id) {
                        $q .= " LEFT JOIN obj_members ON usr_data.usr_id = obj_members.usr_id " .
                            "WHERE obj_members.obj_id = (SELECT obj_id FROM object_reference " .
                            "WHERE ref_id = " . $ilDB->quote($ref_id, "integer") . ") ";
                    }
                    break;
                case 6:
                    global $rbacreview;
                    $ref_id = $_SESSION["user_filter_data"];
                    if ($ref_id) {
                        $local_roles = $rbacreview->getRolesOfRoleFolder($ref_id, false);
                        if (is_array($local_roles) && count($local_roles)) {
                            $q.= " LEFT JOIN rbac_ua ON usr_data.usr_id = rbac_ua.usr_id WHERE " .
                                $ilDB->in("rbac_ua.rol_id", $local_roles, false, "integer") . " ";
                        }
                    }
                    break;
                case 7:
                    $rol_id = $_SESSION["user_filter_data"];
                    if ($rol_id) {
                        $q .= " LEFT JOIN rbac_ua ON usr_data.usr_id = rbac_ua.usr_id WHERE rbac_ua.rol_id = " .
                            $ilDB->quote($rol_id, "integer");
                    }
                    break;
            }
            $r = $ilDB->query($q);

            while ($row = $ilDB->fetchAssoc($r)) {
                $result_arr[] = $row;
            }
        }

        return $result_arr;
    }

    public static function _getNumberOfUsersForStyle($a_skin, $a_style)
    {
        global $ilDB;

        $q = "SELECT count(*) as cnt FROM usr_pref up1, usr_pref up2 " .
            " WHERE up1.keyword= " . $ilDB->quote("style", "text") .
            " AND up1.value= " . $ilDB->quote($a_style, "text") .
            " AND up2.keyword= " . $ilDB->quote("skin", "text") .
            " AND up2.value= " . $ilDB->quote($a_skin, "text") .
            " AND up1.usr_id = up2.usr_id ";

        $cnt_set = $ilDB->query($q);

        $cnt_rec = $ilDB->fetchAssoc($cnt_set);

        return $cnt_rec["cnt"];
    }

    public static function _getAllUserAssignedStyles()
    {
        global $ilDB;

        $q = "SELECT DISTINCT up1.value style, up2.value skin FROM usr_pref up1, usr_pref up2 " .
            " WHERE up1.keyword = " . $ilDB->quote("style", "text") .
            " AND up2.keyword = " . $ilDB->quote("skin", "text") .
            " AND up1.usr_id = up2.usr_id";
            
        $sty_set = $ilDB->query($q);

        $styles = array();
        while ($sty_rec = $ilDB->fetchAssoc($sty_set)) {
            $styles[] = $sty_rec["skin"] . ":" . $sty_rec["style"];
        }

        return $styles;
    }

    public static function _moveUsersToStyle($a_from_skin, $a_from_style, $a_to_skin, $a_to_style)
    {
        global $ilDB;

        $q = "SELECT up1.usr_id usr_id FROM usr_pref up1, usr_pref up2 " .
            " WHERE up1.keyword= " . $ilDB->quote("style", "text") .
            " AND up1.value= " . $ilDB->quote($a_from_style, "text") .
            " AND up2.keyword= " . $ilDB->quote("skin", "text") .
            " AND up2.value= " . $ilDB->quote($a_from_skin, "text") .
            " AND up1.usr_id = up2.usr_id ";

        $usr_set = $ilDB->query($q);

        while ($usr_rec = $ilDB->fetchAssoc($usr_set)) {
            self::_writePref($usr_rec["usr_id"], "skin", $a_to_skin);
            self::_writePref($usr_rec["usr_id"], "style", $a_to_style);
        }
    }


    public static function _addDesktopItem($a_usr_id, $a_item_id, $a_type, $a_par = "")
    {
        global $ilDB;

        $item_set = $ilDB->queryF(
            "SELECT * FROM desktop_item WHERE " .
            "item_id = %s AND type = %s AND user_id = %s",
            array("integer", "text", "integer"),
            array($a_item_id, $a_type, $a_usr_id)
        );

        // only insert if item is not already on desktop
        if (!$ilDB->fetchAssoc($item_set)) {
            $ilDB->manipulateF(
                "INSERT INTO desktop_item (item_id, type, user_id, parameters) VALUES " .
                " (%s,%s,%s,%s)",
                array("integer", "text", "integer", "text"),
                array($a_item_id,$a_type,$a_usr_id,$a_par)
            );
        }
        
        include_once './Services/Calendar/classes/class.ilCalendarCategories.php';
        ilCalendarCategories::deletePDItemsCache($a_usr_id);
    }

    public function addDesktopItem($a_item_id, $a_type, $a_par = "")
    {
        ilObjUser::_addDesktopItem($this->getId(), $a_item_id, $a_type, $a_par);
    }

    public function setDesktopItemParameters($a_item_id, $a_type, $a_par)
    {
        global $ilDB;

        $ilDB->manipulateF(
            "UPDATE desktop_item SET parameters = %s " .
            " WHERE item_id = %s AND type = %s AND user_id = %s",
            array("text", "integer", "text", "integer"),
            array($a_par, $a_item_id, $a_type, $this->getId())
        );
    }


    public static function _dropDesktopItem($a_usr_id, $a_item_id, $a_type)
    {
        global $ilDB;

        $ilDB->manipulateF(
            "DELETE FROM desktop_item WHERE " .
            " item_id = %s AND type = %s  AND user_id = %s",
            array("integer", "text", "integer"),
            array($a_item_id, $a_type, $a_usr_id)
        );

        include_once './Services/Calendar/classes/class.ilCalendarCategories.php';
        ilCalendarCategories::deletePDItemsCache($a_usr_id);
    }

    public function dropDesktopItem($a_item_id, $a_type)
    {
        ilObjUser::_dropDesktopItem($this->getId(), $a_item_id, $a_type);
    }

    public static function _removeItemFromDesktops($a_id)
    {
        global $ilDB;
        
        $r = $ilDB->queryF(
            "SELECT user_id FROM desktop_item WHERE item_id = %s",
            array("integer"),
            array($a_id)
        );

        $users = array();

        while ($row = $ilDB->fetchObject($r)) {
            $users[] = $row->user_id;
        } // while

        if (count($users) > 0) {
            $ilDB->manipulateF(
                "DELETE FROM desktop_item WHERE item_id = %s",
                array("integer"),
                array($a_id)
            );
        }

        return $users;
    }

    public static function _isDesktopItem($a_usr_id, $a_item_id, $a_type)
    {
        global $ilDB;

        if (self::$is_desktop_item_loaded[$a_usr_id . ":" . $a_item_id]) {
            return self::$is_desktop_item_cache[$a_usr_id . ":" . $a_item_id . ":" . $a_type];
        }
        $item_set = $ilDB->queryF(
            "SELECT item_id FROM desktop_item WHERE " .
            "item_id = %s AND type = %s AND user_id = %s",
            array("integer", "text", "integer"),
            array($a_item_id, $a_type, $a_usr_id)
        );

        if ($ilDB->fetchAssoc($item_set)) {
            return true;
        } else {
            return false;
        }
    }

    public static function preloadIsDesktopItem($a_usr_id, $a_item_ids)
    {
        global $ilDB;

        if (!is_array($a_item_ids)) {
            return;
        }

        $item_ids = array();
        foreach ($a_item_ids as $id) {
            if (!self::$is_desktop_item_loaded[$a_usr_id . ":" . $id]) {
                $item_ids[] = $id;
            }
            self::$is_desktop_item_loaded[$a_usr_id . ":" . $id] = true;
        }

        if (count($item_ids) > 0) {
            $item_set = $ilDB->query("SELECT item_id, type FROM desktop_item WHERE " .
                $ilDB->in("item_id", $item_ids, false, "integer") .
                " AND user_id = " . $ilDB->quote($a_usr_id, "integer"));
            while ($r = $ilDB->fetchAssoc($item_set)) {
                self::$is_desktop_item_cache[$a_usr_id . ":" . $r["item_id"] . ":" . $r["type"]]
                    = true;
            }
        }
    }

    public function isDesktopItem($a_item_id, $a_type)
    {
        return ilObjUser::_isDesktopItem($this->getId(), $a_item_id, $a_type);
    }

    public function getDesktopItems($a_types = "")
    {
        return $this->_lookupDesktopItems($this->getId(), $a_types);
    }

    public static function _lookupDesktopItems($user_id, $a_types = "")
    {
        global $ilUser, $rbacsystem, $tree, $ilDB;

        if ($a_types == "") {
            $is_nested_set = ($tree->getTreeImplementation() instanceof ilNestedSetTree);
            
            $item_set = $ilDB->queryF("SELECT obj.obj_id, obj.description, oref.ref_id, obj.title, obj.type " .
                " FROM desktop_item it, object_reference oref " .
                    ", object_data obj" .
                " WHERE " .
                "it.item_id = oref.ref_id AND " .
                "oref.obj_id = obj.obj_id AND " .
                "it.user_id = %s", array("integer"), array($user_id));
            $items = $all_parent_path = array();
            while ($item_rec = $ilDB->fetchAssoc($item_set)) {
                if ($tree->isInTree($item_rec["ref_id"])
                    && $item_rec["type"] != "rolf"
                    && $item_rec["type"] != "itgr") {   // due to bug 11508
                    $parent_ref = $tree->getParentId($item_rec["ref_id"]);
                    
                    if (!isset($all_parent_path[$parent_ref])) {
                        // #15746
                        //if($is_nested_set)
                        //{
                        //      $par_left = $tree->getLeftValue($parent_ref);
                        //      $all_parent_path[$parent_ref] = sprintf("%010d", $par_left);
                        //}
                        //else
                        //{
                            if ($parent_ref > 0) {      // workaround for #0023176
                                $node = $tree->getNodeData($parent_ref);
                                $all_parent_path[$parent_ref] = $node["title"];
                            } else {
                                $all_parent_path[$parent_ref] = "";
                            }
                        //}
                    }
                    
                    $parent_path = $all_parent_path[$parent_ref];

                    $title = ilObject::_lookupTitle($item_rec["obj_id"]);
                    $desc = ilObject::_lookupDescription($item_rec["obj_id"]);
                    $items[$parent_path . $title . $item_rec["ref_id"]] =
                        array("ref_id" => $item_rec["ref_id"],
                            "obj_id" => $item_rec["obj_id"],
                            "type" => $item_rec["type"],
                            "title" => $title,
                            "description" => $desc,
                            "parent_ref" => $parent_ref);
                }
            }
            ksort($items);
        } else {
            // due to bug 11508
            if (!is_array($a_types)) {
                $a_types = array($a_types);
            }
            $items = array();
            $foundsurveys = array();
            foreach ($a_types as $a_type) {
                if ($a_type == "itgr") {
                    continue;
                }
                $item_set = $ilDB->queryF(
                    "SELECT obj.obj_id, obj.description, oref.ref_id, obj.title FROM desktop_item it, object_reference oref " .
                    ", object_data obj WHERE " .
                    "it.item_id = oref.ref_id AND " .
                    "oref.obj_id = obj.obj_id AND " .
                    "it.type = %s AND " .
                    "it.user_id = %s " .
                    "ORDER BY title",
                    array("text", "integer"),
                    array($a_type, $user_id)
                );
                
                while ($item_rec = $ilDB->fetchAssoc($item_set)) {
                    $title = ilObject::_lookupTitle($item_rec["obj_id"]);
                    $desc = ilObject::_lookupDescription($item_rec["obj_id"]);
                    $items[$title . $a_type . $item_rec["ref_id"]] =
                        array("ref_id" => $item_rec["ref_id"],
                        "obj_id" => $item_rec["obj_id"], "type" => $a_type,
                        "title" => $title, "description" => $desc);
                }
            }
            ksort($items);
        }

        return $items;
    }

    
    public function addObjectToClipboard(
        $a_item_id,
        $a_type,
        $a_title,
        $a_parent = 0,
        $a_time = 0,
        $a_order_nr = 0
    ) {
        global $ilDB;

        if ($a_time == 0) {
            $a_time = date("Y-m-d H:i:s", time());
        }

        $item_set = $ilDB->queryF(
            "SELECT * FROM personal_clipboard WHERE " .
            "parent = %s AND item_id = %s AND type = %s AND user_id = %s",
            array("integer", "integer", "text", "integer"),
            array(0, $a_item_id, $a_type, $this->getId())
        );

        // only insert if item is not already in clipboard
        if (!$d = $item_set->fetchRow()) {
            $ilDB->manipulateF(
                "INSERT INTO personal_clipboard " .
                "(item_id, type, user_id, title, parent, insert_time, order_nr) VALUES " .
                " (%s,%s,%s,%s,%s,%s,%s)",
                array("integer", "text", "integer", "text", "integer", "timestamp", "integer"),
                array($a_item_id, $a_type, $this->getId(), $a_title, (int) $a_parent, $a_time, (int) $a_order_nr)
            );
        } else {
            $ilDB->manipulateF(
                "UPDATE personal_clipboard SET insert_time = %s " .
                "WHERE user_id = %s AND item_id = %s AND type = %s AND parent = 0",
                array("timestamp", "integer", "integer", "text"),
                array($a_time, $this->getId(), $a_item_id, $a_type)
            );
        }
    }

    public function addToPCClipboard($a_content, $a_time, $a_nr)
    {
        global $ilDB;
        if ($a_time == 0) {
            $a_time = date("Y-m-d H:i:s", time());
        }
        $ilDB->insert("personal_pc_clipboard", array(
            "user_id" => array("integer", $this->getId()),
            "content" => array("clob", $a_content),
            "insert_time" => array("timestamp", $a_time),
            "order_nr" => array("integer", $a_nr)
            ));
    }

    public function getPCClipboardContent()
    {
        global $ilDB;

        $set = $ilDB->queryF("SELECT MAX(insert_time) mtime FROM personal_pc_clipboard " .
            " WHERE user_id = %s", array("integer"), array($this->getId()));
        $row = $ilDB->fetchAssoc($set);
        
        $set = $ilDB->queryF(
            "SELECT * FROM personal_pc_clipboard " .
            " WHERE user_id = %s AND insert_time = %s ORDER BY order_nr ASC",
            array("integer", "timestamp"),
            array($this->getId(), $row["mtime"])
        );
        $content = array();
        while ($row = $ilDB->fetchAssoc($set)) {
            $content[] = $row["content"];
        }

        return $content;
    }

    public function clipboardHasObjectsOfType($a_type)
    {
        global $ilDB;

        $set = $ilDB->queryF(
            "SELECT * FROM personal_clipboard WHERE " .
            "parent = %s AND type = %s AND user_id = %s",
            array("integer", "text", "integer"),
            array(0, $a_type, $this->getId())
        );
        if ($rec = $ilDB->fetchAssoc($set)) {
            return true;
        }

        return false;
    }

    public function clipboardDeleteObjectsOfType($a_type)
    {
        global $ilDB;

        $ilDB->manipulateF(
            "DELETE FROM personal_clipboard WHERE " .
            "type = %s AND user_id = %s",
            array("text", "integer"),
            array($a_type, $this->getId())
        );
    }

    public function clipboardDeleteAll()
    {
        global $ilDB;

        $ilDB->manipulateF("DELETE FROM personal_clipboard WHERE " .
            "user_id = %s", array("integer"), array($this->getId()));
    }

    public function getClipboardObjects($a_type = "", $a_top_nodes_only = false)
    {
        global $ilDB;

        $par = "";
        if ($a_top_nodes_only) {
            $par = " AND parent = " . $ilDB->quote(0, "integer") . " ";
        }
        
        $type_str = ($a_type != "")
            ? " AND type = " . $ilDB->quote($a_type, "text") . " "
            : "";
        $q = "SELECT * FROM personal_clipboard WHERE " .
            "user_id = " . $ilDB->quote($this->getId(), "integer") . " " .
            $type_str . $par .
            " ORDER BY order_nr";
        $objs = $ilDB->query($q);
        $objects = array();
        while ($obj = $ilDB->fetchAssoc($objs)) {
            if ($obj["type"] == "mob") {
                $obj["title"] = ilObject::_lookupTitle($obj["item_id"]);
            }
            if ($obj["type"] == "incl") {
                include_once("./Modules/MediaPool/classes/class.ilMediaPoolPage.php");
                $obj["title"] = ilMediaPoolPage::lookupTitle($obj["item_id"]);
            }
            $objects[] = array("id" => $obj["item_id"],
                "type" => $obj["type"], "title" => $obj["title"],
                "insert_time" => $obj["insert_time"]);
        }
        return $objects;
    }

    public function getClipboardChilds($a_parent, $a_insert_time)
    {
        global $ilDB, $ilUser;

        $objs = $ilDB->queryF(
            "SELECT * FROM personal_clipboard WHERE " .
            "user_id = %s AND parent = %s AND insert_time = %s " .
            " ORDER BY order_nr",
            array("integer", "integer", "timestamp"),
            array($ilUser->getId(), (int) $a_parent, $a_insert_time)
        );
        $objects = array();
        while ($obj = $ilDB->fetchAssoc($objs)) {
            if ($obj["type"] == "mob") {
                $obj["title"] = ilObject::_lookupTitle($obj["item_id"]);
            }
            $objects[] = array("id" => $obj["item_id"],
                "type" => $obj["type"], "title" => $obj["title"], "insert_time" => $obj["insert_time"]);
        }
        return $objects;
    }

    public static function _getUsersForClipboadObject($a_type, $a_id)
    {
        global $ilDB;

        $q = "SELECT DISTINCT user_id FROM personal_clipboard WHERE " .
            "item_id = " . $ilDB->quote($a_id, "integer") . " AND " .
            "type = " . $ilDB->quote($a_type, "text");
        $user_set = $ilDB->query($q);
        $users = array();
        while ($user_rec = $ilDB->fetchAssoc($user_set)) {
            $users[] = $user_rec["user_id"];
        }

        return $users;
    }

    public function removeObjectFromClipboard($a_item_id, $a_type)
    {
        global $ilDB;

        $q = "DELETE FROM personal_clipboard WHERE " .
            "item_id = " . $ilDB->quote($a_item_id, "integer") .
            " AND type = " . $ilDB->quote($a_type, "text") . " " .
            " AND user_id = " . $ilDB->quote($this->getId(), "integer");
        $ilDB->manipulate($q);
    }

    public static function _getImportedUserId($i2_id)
    {
        global $ilDB;

        $query = "SELECT obj_id FROM object_data WHERE import_id = " .
            $ilDB->quote($i2_id, "text");

        $res = $ilDB->query($query);
        while ($row = $ilDB->fetchObject($res)) {
            $id = $row->obj_id;
        }
        return $id ? $id : 0;
    }
    
    public static function lookupOrgUnitsRepresentation($a_usr_id)
    {
        require_once('./Modules/OrgUnit/classes/PathStorage/class.ilOrgUnitPathStorage.php');
        return ilOrgUnitPathStorage::getTextRepresentationOfUsersOrgUnits($a_usr_id);
    }


    public function getOrgUnitsRepresentation()
    {
        return self::lookupOrgUnitsRepresentation($this->getId());
    }


    public function setAuthMode($a_str)
    {
        $this->auth_mode = $a_str;
    }

    public function getAuthMode($a_auth_key = false)
    {
        if (!$a_auth_key) {
            return $this->auth_mode;
        }

        include_once('./Services/Authentication/classes/class.ilAuthUtils.php');
        return ilAuthUtils::_getAuthMode($this->auth_mode);
    }

    public function setExternalAccount($a_str)
    {
        $this->ext_account = $a_str;
    }

    public function getExternalAccount()
    {
        return $this->ext_account;
    }

    public static function _getExternalAccountsByAuthMode($a_auth_mode, $a_read_auth_default = false)
    {
        global $ilDB,$ilSetting;

        include_once('./Services/Authentication/classes/class.ilAuthUtils.php');
        $q = "SELECT login,usr_id,ext_account,auth_mode FROM usr_data " .
            "WHERE auth_mode = %s";
        $types[] = "text";
        $values[] = $a_auth_mode;
        if ($a_read_auth_default and ilAuthUtils::_getAuthModeName($ilSetting->get('auth_mode', AUTH_LOCAL)) == $a_auth_mode) {
            $q.= " OR auth_mode = %s ";
            $types[] = "text";
            $values[] = 'default';
        }

        $res = $ilDB->queryF($q, $types, $values);
        while ($row = $ilDB->fetchObject($res)) {
            if ($row->auth_mode == 'default') {
                $accounts[$row->usr_id] = $row->login;
            } else {
                $accounts[$row->usr_id] = $row->ext_account;
            }
        }
        return $accounts ? $accounts : array();
    }

    public static function _toggleActiveStatusOfUsers($a_usr_ids, $a_status)
    {
        global $ilDB;

        if (!is_array($a_usr_ids)) {
            return false;
        }
        
        
        if ($a_status) {
            $q = "UPDATE usr_data SET active = 1, inactivation_date = NULL WHERE " .
                $ilDB->in("usr_id", $a_usr_ids, false, "integer");
            $ilDB->manipulate($q);
        } else {
            $usrId_IN_usrIds = $ilDB->in("usr_id", $a_usr_ids, false, "integer");

            $q = "UPDATE usr_data SET active = 0 WHERE $usrId_IN_usrIds";
            $ilDB->manipulate($q);
            
            $queryString = "
                                UPDATE usr_data
                                SET inactivation_date = %s
                                WHERE inactivation_date IS NULL
                                AND $usrId_IN_usrIds
                        ";
            $ilDB->manipulateF($queryString, array('timestamp'), array(ilUtil::now()));
        }
        
        return true;
    }


    public static function _lookupAuthMode($a_usr_id)
    {
        return (string) ilObjUser::_lookup($a_usr_id, "auth_mode");
    }

    public static function _checkExternalAuthAccount($a_auth, $a_account, $tryFallback = true)
    {
        $db       = $GLOBALS['DIC']->database();
        $settings = $GLOBALS['DIC']->settings();

        // Check directly with auth_mode
        $r = $db->queryF(
            "SELECT * FROM usr_data WHERE " .
            " ext_account = %s AND auth_mode = %s",
            array("text", "text"),
            array($a_account, $a_auth)
        );
        if ($usr = $db->fetchAssoc($r)) {
            return $usr["login"];
        }

        if (!$tryFallback) {
            return false;
        }

        // For compatibility, check for login (no ext_account entry given)
        $res = $db->queryF(
            "SELECT login FROM usr_data " .
            "WHERE login = %s AND auth_mode = %s AND (ext_account IS NULL OR ext_account = '') ",
            array("text", "text"),
            array($a_account, $a_auth)
        );
        if ($usr = $db->fetchAssoc($res)) {
            return $usr['login'];
        }

        // If auth_default == $a_auth => check for login
        if (ilAuthUtils::_getAuthModeName($settings->get('auth_mode')) == $a_auth) {
            $res = $db->queryF(
                "SELECT login FROM usr_data WHERE " .
                " ext_account = %s AND auth_mode = %s",
                array("text", "text"),
                array($a_account, "default")
            );
            if ($usr = $db->fetchAssoc($res)) {
                return $usr["login"];
            }
            // Search for login (no ext_account given)
            $res = $db->queryF(
                "SELECT login FROM usr_data " .
                "WHERE login = %s AND (ext_account IS NULL OR ext_account = '') AND auth_mode = %s",
                array("text", "text"),
                array($a_account, "default")
            );
            if ($usr = $db->fetchAssoc($res)) {
                return $usr["login"];
            }
        }
        return false;
    }

    public static function _getNumberOfUsersPerAuthMode()
    {
        global $ilDB;

        $r = $ilDB->query("SELECT count(*) AS cnt, auth_mode FROM usr_data " .
            "GROUP BY auth_mode");
        $cnt_arr = array();
        while ($cnt = $ilDB->fetchAssoc($r)) {
            $cnt_arr[$cnt["auth_mode"]] = $cnt["cnt"];
        }

        return $cnt_arr;
    }

    public static function _getLocalAccountsForEmail($a_email)
    {
        global $ilDB, $ilSetting;

        // default set to local (1)?

        $q = "SELECT * FROM usr_data WHERE " .
            " email = %s AND (auth_mode = %s ";
        $types = array("text", "text");
        $values = array($a_email, "local");

        if ($ilSetting->get("auth_mode") == 1) {
            $q.=" OR auth_mode = %s";
            $types[] = "text";
            $values[] = "default";
        }
        
        $q.= ")";

        $users = array();
        $usr_set = $ilDB->queryF($q, $types, $values);
        while ($usr_rec = $ilDB->fetchAssoc($usr_set)) {
            $users[$usr_rec["usr_id"]] = $usr_rec["login"];
        }

        return $users;
    }


    public static function _uploadPersonalPicture($tmp_file, $obj_id)
    {
        $webspace_dir = ilUtil::getWebspaceDir();
        $image_dir = $webspace_dir . "/usr_images";
        $store_file = "usr_" . $obj_id . "." . "jpg";
        $target_file = $image_dir . "/$store_file";

        chmod($tmp_file, 0770);

        // take quality 100 to avoid jpeg artefacts when uploading jpeg files
        // taking only frame [0] to avoid problems with animated gifs
        $show_file  = "$image_dir/usr_" . $obj_id . ".jpg";
        $thumb_file = "$image_dir/usr_" . $obj_id . "_small.jpg";
        $xthumb_file = "$image_dir/usr_" . $obj_id . "_xsmall.jpg";
        $xxthumb_file = "$image_dir/usr_" . $obj_id . "_xxsmall.jpg";

        ilUtil::execConvert($tmp_file . "[0] -geometry 200x200 -quality 100 JPEG:" . $show_file);
        ilUtil::execConvert($tmp_file . "[0] -geometry 100x100 -quality 100 JPEG:" . $thumb_file);
        ilUtil::execConvert($tmp_file . "[0] -geometry 75x75 -quality 100 JPEG:" . $xthumb_file);
        ilUtil::execConvert($tmp_file . "[0] -geometry 30x30 -quality 100 JPEG:" . $xxthumb_file);

        // store filename
        self::_writePref($obj_id, "profile_image", $store_file);

        return true;
    }


    public function getPersonalPicturePath($a_size = "small", $a_force_pic = false)
    {
        if (isset(self::$personal_image_cache[$this->getId()][$a_size][(int) $a_force_pic])) {
            return self::$personal_image_cache[$this->getId()][$a_size][(int) $a_force_pic];
        }

        self::$personal_image_cache[$this->getId()][$a_size][(int) $a_force_pic] = ilObjUser::_getPersonalPicturePath($this->getId(), $a_size, $a_force_pic);

        return self::$personal_image_cache[$this->getId()][$a_size][(int) $a_force_pic];
    }

    public static function _getPersonalPicturePath(
        $a_usr_id,
        $a_size = "small",
        $a_force_pic = false,
        $a_prevent_no_photo_image = false
    ) {
        global $DIC;

        $login = $firstname = $lastname = '';
        $upload = $profile              = false;

        $in  = $DIC->database()->in('usr_pref.keyword', array('public_upload', 'public_profile'), false, 'text');
        $res = $DIC->database()->queryF(
            "
                        SELECT usr_pref.*, ud.login, ud.firstname, ud.lastname
                        FROM usr_data ud LEFT JOIN usr_pref ON usr_pref.usr_id = ud.usr_id AND $in
                        WHERE ud.usr_id = %s",
            array("integer"),
            array($a_usr_id)
        );
        while ($row = $DIC->database()->fetchAssoc($res)) {
            $login     = $row['login'];
            $firstname = $row['firstname'];
            $lastname  = $row['lastname'];

            switch ($row['keyword']) {
                case 'public_upload':
                    $upload = $row['value'] == 'y';
                    break;
                case 'public_profile':
                    $profile = ($row['value'] == 'y' ||
                        $row['value'] == 'g');
                    break;
            }
        }

        // END DiskQuota: Fetch all user preferences in a single query
        $webspace_dir = "";
        if (defined('ILIAS_MODULE')) {
            $webspace_dir = ('.' . $webspace_dir);
        }
        $webspace_dir .= ('./' . ltrim(ilUtil::getWebspaceDir(), "./"));

        $image_dir = $webspace_dir . "/usr_images";
        // BEGIN DiskQuota: Support 'big' user images
        if ($a_size == 'big') {
            $thumb_file = $image_dir . "/usr_" . $a_usr_id . ".jpg";
        } else {
            $thumb_file = $image_dir . "/usr_" . $a_usr_id . "_" . $a_size . ".jpg";
        }
        // END DiskQuota: Support 'big' user images

        $random = new \ilRandom();
        if ((($upload && $profile) || $a_force_pic)
            && @is_file($thumb_file)) {
            $file = $thumb_file . "?t=" . $random->int(1, 99999);
        } else {
            if (!$a_prevent_no_photo_image) {
                // we only have xsmall and xxsmall for this
                if ($a_size == "small" || $a_size == "big") {
                    $a_size = "xsmall";
                }

                if ($profile) {
                    $short = ilStr::subStr($firstname, 0, 1) . ilStr::subStr($lastname, 0, 1);
                } else {
                    $short = ilStr::subStr($login, 0, 2);
                }

                $avatar = $DIC["user.avatar.factory"]->avatar($a_size);
                $avatar->setName($short);
                $avatar->setUsrId($a_usr_id);

                return $avatar->getUrl();
            }
        }

        require_once('./Services/WebAccessChecker/classes/class.ilWACSignedPath.php');
        return ilWACSignedPath::signFile($file);
    }

    public static function copyProfilePicturesToDirectory($a_user_id, $a_dir)
    {
        $a_dir = trim(str_replace("..", "", $a_dir));
        if ($a_dir == "" || !is_dir($a_dir)) {
            return;
        }
        
        $webspace_dir = ilUtil::getWebspaceDir();
        $image_dir = $webspace_dir . "/usr_images";
        $images = array(
            "upload_" . $a_user_id . "pic",
            "usr_" . $a_user_id . "." . "jpg",
            "usr_" . $a_user_id . "_small.jpg",
            "usr_" . $a_user_id . "_xsmall.jpg",
            "usr_" . $a_user_id . "_xxsmall.jpg",
            "upload_" . $a_user_id);
        foreach ($images as $image) {
            if (is_file($image_dir . "/" . $image)) {
                copy($image_dir . "/" . $image, $a_dir . "/" . $image);
            }
        }
    }
    
    
    public function removeUserPicture($a_do_update = true)
    {
        $webspace_dir = ilUtil::getWebspaceDir();
        $image_dir = $webspace_dir . "/usr_images";
        $file = $image_dir . "/usr_" . $this->getID() . "." . "jpg";
        $thumb_file = $image_dir . "/usr_" . $this->getID() . "_small.jpg";
        $xthumb_file = $image_dir . "/usr_" . $this->getID() . "_xsmall.jpg";
        $xxthumb_file = $image_dir . "/usr_" . $this->getID() . "_xxsmall.jpg";
        $upload_file = $image_dir . "/upload_" . $this->getID();

        if ($a_do_update) {
            // remove user pref file name
            $this->setPref("profile_image", "");
            $this->update();
        }

        if (@is_file($file)) {
            unlink($file);
        }
        if (@is_file($thumb_file)) {
            unlink($thumb_file);
        }
        if (@is_file($xthumb_file)) {
            unlink($xthumb_file);
        }
        if (@is_file($xxthumb_file)) {
            unlink($xxthumb_file);
        }
        if (@is_file($upload_file)) {
            unlink($upload_file);
        }
    }
    
    
    public function setUserDefinedData($a_data)
    {
        if (!is_array($a_data)) {
            return false;
        }
        foreach ($a_data as $field => $data) {
            #$new_data[$field] = ilUtil::stripSlashes($data);
            // Assign it directly to avoid update problems of unchangable fields
            $this->user_defined_data['f_' . $field] = $data;
        }
        #$this->user_defined_data = $new_data;

        return true;
    }

    public function getUserDefinedData()
    {
        return $this->user_defined_data ? $this->user_defined_data : array();
    }

    public function updateUserDefinedFields()
    {
        global $ilDB;

        $fields = '';

        $field_def = array();
        
        include_once("./Services/User/classes/class.ilUserDefinedData.php");
        $udata = new ilUserDefinedData($this->getId());

        foreach ($this->user_defined_data as $field => $value) {
            if ($field != 'usr_id') {
                //                              $field_def[$field] = array('text',$value);
                $udata->set($field, $value);
            }
        }
        $udata->update();

        /*              if(!$field_def)
                {
                    return true;
                }

                $query = "SELECT usr_id FROM udf_data WHERE usr_id = ".$ilDB->quote($this->getId(),'integer');
                $res = $ilDB->query($query);


                if($res->numRows())
                {
                    // Update
                    $ilDB->update('udf_data',$field_def,array('usr_id' => array('integer',$this->getId())));
                }
                else
                {
                    $field_def['usr_id'] = array('integer',$this->getId());
                    $ilDB->insert('udf_data',$field_def);
                }
        */
        return true;
    }

    public function readUserDefinedFields()
    {
        global $ilDB;

        include_once("./Services/User/classes/class.ilUserDefinedData.php");
        $udata = new ilUserDefinedData($this->getId());

        /*              $query = "SELECT * FROM udf_data ".
                    "WHERE usr_id = ".$ilDB->quote($this->getId(),'integer');

                $res = $this->db->query($query);
                while($row = $res->fetchRow(ilDBConstants::FETCHMODE_ASSOC))
                {
                    $this->user_defined_data = $row;
                }*/
        
        $this->user_defined_data = $udata->getAll();
        
        return true;
    }

    public function addUserDefinedFieldEntry()
    {
        global $ilDB;

        // not needed. no entry in udf_text/udf_clob means no value

        /*              $query = "INSERT INTO udf_data (usr_id ) ".
                    "VALUES( ".
                    $ilDB->quote($this->getId(),'integer').
                    ")";
                $res = $ilDB->manipulate($query);
        */
        return true;
    }

    public function deleteUserDefinedFieldEntries()
    {
        global $ilDB;

        include_once("./Services/User/classes/class.ilUserDefinedData.php");
        ilUserDefinedData::deleteEntriesOfUser($this->getId());
        
        // wrong place...
        /*              $query = "DELETE FROM udf_data  ".
                    "WHERE usr_id = ".$ilDB->quote($this->getId(),'integer');
                $res = $ilDB->manipulate($query);*/

        return true;
    }

    public function getProfileAsString(&$a_language)
    {
        include_once './Services/AccessControl/classes/class.ilObjRole.php';

        global $lng,$rbacreview;

        $language =&$a_language;
        $language->loadLanguageModule('registration');
        $language->loadLanguageModule('crs');

        $body = '';
        $body .= ($language->txt("login") . ": " . $this->getLogin() . "\n");

        if (strlen($this->getUTitle())) {
            $body .= ($language->txt("title") . ": " . $this->getUTitle() . "\n");
        }
        if (1 === strlen($this->getGender())) {
            $body .= ($language->txt("gender") . ": " . $language->txt('gender_' . strtolower($this->getGender())) . "\n");
        }
        if (strlen($this->getFirstname())) {
            $body .= ($language->txt("firstname") . ": " . $this->getFirstname() . "\n");
        }
        if (strlen($this->getLastname())) {
            $body .= ($language->txt("lastname") . ": " . $this->getLastname() . "\n");
        }
        if (strlen($this->getInstitution())) {
            $body .= ($language->txt("institution") . ": " . $this->getInstitution() . "\n");
        }
        if (strlen($this->getDepartment())) {
            $body .= ($language->txt("department") . ": " . $this->getDepartment() . "\n");
        }
        if (strlen($this->getStreet())) {
            $body .= ($language->txt("street") . ": " . $this->getStreet() . "\n");
        }
        if (strlen($this->getCity())) {
            $body .= ($language->txt("city") . ": " . $this->getCity() . "\n");
        }
        if (strlen($this->getZipcode())) {
            $body .= ($language->txt("zipcode") . ": " . $this->getZipcode() . "\n");
        }
        if (strlen($this->getCountry())) {
            $body .= ($language->txt("country") . ": " . $this->getCountry() . "\n");
        }
        if (strlen($this->getSelectedCountry())) {
            $body .= ($language->txt("sel_country") . ": " . $this->getSelectedCountry() . "\n");
        }
        if (strlen($this->getPhoneOffice())) {
            $body .= ($language->txt("phone_office") . ": " . $this->getPhoneOffice() . "\n");
        }
        if (strlen($this->getPhoneHome())) {
            $body .= ($language->txt("phone_home") . ": " . $this->getPhoneHome() . "\n");
        }
        if (strlen($this->getPhoneMobile())) {
            $body .= ($language->txt("phone_mobile") . ": " . $this->getPhoneMobile() . "\n");
        }
        if (strlen($this->getFax())) {
            $body .= ($language->txt("fax") . ": " . $this->getFax() . "\n");
        }
        if (strlen($this->getEmail())) {
            $body .= ($language->txt("email") . ": " . $this->getEmail() . "\n");
        }
        if (strlen($this->getSecondEmail())) {
            $body .= ($language->txt("second_email") . ": " . $this->getSecondEmail() . "\n");
        }
        if (strlen($this->getHobby())) {
            $body .= ($language->txt("hobby") . ": " . $this->getHobby() . "\n");
        }
        if (strlen($this->getComment())) {
            $body .= ($language->txt("referral_comment") . ": " . $this->getComment() . "\n");
        }
        if (strlen($this->getMatriculation())) {
            $body .= ($language->txt("matriculation") . ": " . $this->getMatriculation() . "\n");
        }
        if (strlen($this->getCreateDate())) {
            ilDatePresentation::setUseRelativeDates(false);
            ilDatePresentation::setLanguage($language);
            $date = ilDatePresentation::formatDate(new ilDateTime($this->getCreateDate(), IL_CAL_DATETIME));
            ilDatePresentation::resetToDefaults();
            
            $body .= ($language->txt("create_date") . ": " . $date . "\n");
        }

        foreach ($rbacreview->getGlobalRoles() as $role) {
            if ($rbacreview->isAssigned($this->getId(), $role)) {
                $gr[] = ilObjRole::_lookupTitle($role);
            }
        }
        if (count($gr)) {
            $body .= ($language->txt('reg_role_info') . ': ' . implode(',', $gr) . "\n");
        }

        // Time limit
        if ($this->getTimeLimitUnlimited()) {
            $body .= ($language->txt('time_limit') . ": " . $language->txt('crs_unlimited') . "\n");
        } else {
            ilDatePresentation::setUseRelativeDates(false);
            ilDatePresentation::setLanguage($language);
            $period = ilDatePresentation::formatPeriod(
                new ilDateTime($this->getTimeLimitFrom(), IL_CAL_UNIX),
                new ilDateTime($this->getTimeLimitUntil(), IL_CAL_UNIX)
            );
            ilDatePresentation::resetToDefaults();
            
            $start = new ilDateTime($this->getTimeLimitFrom(), IL_CAL_UNIX);
            $end = new ilDateTime($this->getTimeLimitUntil(), IL_CAL_UNIX);
            
            $body .= $language->txt('time_limit') . ': ' . $start->get(IL_CAL_DATETIME);
            $body .= $language->txt('time_limit') . ': ' . $end->get(IL_CAL_DATETIME);
        }

        include_once './Services/User/classes/class.ilUserDefinedFields.php';
        $user_defined_fields = ilUserDefinedFields::_getInstance();
        $user_defined_data = $this->getUserDefinedData();

        foreach ($user_defined_fields->getDefinitions() as $field_id => $definition) {
            $data = $user_defined_data["f_" . $field_id];
            if (strlen($data)) {
                if ($definition['field_type'] ==  UDF_TYPE_WYSIWYG) {
                    $data = preg_replace('/<br(\s*)?\/?>/i', "\n", $data);
                    $data = strip_tags($data);
                }

                $body .= $definition['field_name'] . ': ' . $data . "\n";
            }
        }

        return $body;
    }

    public static function _lookupFeedHash($a_user_id, $a_create = false)
    {
        global $ilDB;

        if ($a_user_id > 0) {
            $set = $ilDB->queryF(
                "SELECT feed_hash from usr_data WHERE usr_id = %s",
                array("integer"),
                array($a_user_id)
            );
            if ($rec = $ilDB->fetchAssoc($set)) {
                if (strlen($rec["feed_hash"]) == 32) {
                    return $rec["feed_hash"];
                } elseif ($a_create) {
                    $random = new \ilRandom();
                    $hash = md5($random->int(1, 9999999) + str_replace(" ", "", (string) microtime()));
                    $ilDB->manipulateF(
                        "UPDATE usr_data SET feed_hash = %s" .
                        " WHERE usr_id = %s",
                        array("text", "integer"),
                        array($hash, $a_user_id)
                    );
                    return $hash;
                }
            }
        }

        return false;
    }

    public static function _getFeedPass($a_user_id)
    {
        global $ilDB;

        if ($a_user_id > 0) {
            return ilObjUser::_lookupPref($a_user_id, "priv_feed_pass");
        }
        return false;
    }

    public static function _setFeedPass($a_user_id, $a_password)
    {
        global $ilDB;
        
        self::_writePref(
            $a_user_id,
            "priv_feed_pass",
            ($a_password=="") ? "" : md5($a_password)
        );
    }

    public static function _loginExists($a_login, $a_user_id = 0)
    {
        global $ilDB;

        $q = "SELECT DISTINCT login, usr_id FROM usr_data " .
             "WHERE login = %s";
        $types[] = "text";
        $values[] = $a_login;
             
        if ($a_user_id != 0) {
            $q.= " AND usr_id != %s ";
            $types[] = "integer";
            $values[] = $a_user_id;
        }
             
        $r = $ilDB->queryF($q, $types, $values);

        if ($row = $ilDB->fetchAssoc($r)) {
            return $row['usr_id'];
        }
        return false;
    }

    public static function _externalAccountExists($a_external_account, $a_auth_mode)
    {
        global $ilDB;

        $res = $ilDB->queryF(
            "SELECT * FROM usr_data " .
            "WHERE ext_account = %s AND auth_mode = %s",
            array("text", "text"),
            array($a_external_account, $a_auth_mode)
        );
        return $ilDB->fetchAssoc($res) ? true :false;
    }

    public static function _getUsersForRole($role_id, $active = -1)
    {
        global $ilDB, $rbacreview;
        $data = array();

        $ids = $rbacreview->assignedUsers($role_id);

        if (count($ids) == 0) {
            $ids = array(-1);
        }

        $query = "SELECT usr_data.*, usr_pref.value AS language
                                                        FROM usr_data
                                                        LEFT JOIN usr_pref ON usr_pref.usr_id = usr_data.usr_id AND usr_pref.keyword = %s
                                                        WHERE " . $ilDB->in("usr_data.usr_id", $ids, false, "integer");
        $values[] = "language";
        $types[] = "text";


        if (is_numeric($active) && $active > -1) {
            $query .= " AND usr_data.active = %s";
            $values[] = $active;
            $types[] = "integer";
        }
        
        $query .= " ORDER BY usr_data.lastname, usr_data.firstname ";
        
        $r = $ilDB->queryF($query, $types, $values);
        $data = array();
        while ($row = $ilDB->fetchAssoc($r)) {
            $data[] = $row;
        }
        return $data;
    }


    public static function _getUsersForFolder($ref_id, $active)
    {
        global $ilDB;
        $data = array();
        $query = "SELECT usr_data.*, usr_pref.value AS language FROM usr_data LEFT JOIN usr_pref ON usr_pref.usr_id = usr_data.usr_id and usr_pref.keyword = %s WHERE 1 = 1 ";
        $types[] = "text";
        $values[] = "language";

        if (is_numeric($active) && $active > -1) {
            $query .= " AND usr_data.active = %s";
            $values[] = $active;
            $types[] = "integer";
        }

        if ($ref_id != USER_FOLDER_ID) {
            $query.= " AND usr_data.time_limit_owner = %s";
            $values[] = $ref_id;
            $types[] = "integer";
        }

        $query .=       " AND usr_data.usr_id != %s ";
        $values[] = ANONYMOUS_USER_ID;
        $types[] = "integer";

        $query .= " ORDER BY usr_data.lastname, usr_data.firstname ";

        $result = $ilDB->queryF($query, $types, $values);
        $data = array();
        while ($row = $ilDB->fetchAssoc($result)) {
            array_push($data, $row);
        }

        return $data;
    }


    public static function _getUsersForGroup($a_mem_ids, $active = -1)
    {
        return ilObjUser::_getUsersForIds($a_mem_ids, $active);
    }


    public static function _getUsersForIds($a_mem_ids, $active = -1, $timelimitowner = -1)
    {
        global $rbacadmin, $rbacreview, $ilDB;

        $query = "SELECT usr_data.*, usr_pref.value AS language
                          FROM usr_data
                          LEFT JOIN usr_pref ON usr_pref.usr_id = usr_data.usr_id AND usr_pref.keyword = %s
                          WHERE " . $ilDB->in("usr_data.usr_id", $a_mem_ids, false, "integer") . "
                                        AND usr_data.usr_id != %s";
        $values[] = "language";
        $types[] = "text";
        $values[] = ANONYMOUS_USER_ID;
        $types[] = "integer";

        if (is_numeric($active) && $active > -1) {
            $query .= " AND active = %s";
            $values[] = $active;
            $types[] = "integer";
        }

        if ($timelimitowner != USER_FOLDER_ID && $timelimitowner != -1) {
            $query.= " AND usr_data.time_limit_owner = %s";
            $values[] = $timelimitowner;
            $types[] = "integer";
        }

        $query .= " ORDER BY usr_data.lastname, usr_data.firstname ";

        $result = $ilDB->queryF($query, $types, $values);
        while ($row = $ilDB->fetchAssoc($result)) {
            $mem_arr[] = $row;
        }

        return $mem_arr ? $mem_arr : array();
    }



    public static function _getUserData($a_internalids)
    {
        global $ilDB;

        $ids = array();
        if (is_array($a_internalids)) {
            foreach ($a_internalids as $internalid) {
                if (is_numeric($internalid)) {
                    $ids[] = $internalid;
                } else {
                    $parsedid = ilUtil::__extractId($internalid, IL_INST_ID);
                    if (is_numeric($parsedid) && $parsedid > 0) {
                        $ids[] = $parsedid;
                    }
                }
            }
        }
        if (count($ids) == 0) {
            $ids [] = -1;
        }

        $query = "SELECT usr_data.*, usr_pref.value AS language
                          FROM usr_data
                          LEFT JOIN usr_pref
                          ON usr_pref.usr_id = usr_data.usr_id AND usr_pref.keyword = %s
                          WHERE " . $ilDB->in("usr_data.usr_id", $ids, false, "integer");
        $values[] = "language";
        $types[] = "text";

        $query .= " ORDER BY usr_data.lastname, usr_data.firstname ";

        $data = array();
        $result = $ilDB->queryF($query, $types, $values);
        while ($row = $ilDB->fetchAssoc($result)) {
            $data[] = $row;
        }
        return $data;
    }

    public static function _getPreferences($user_id)
    {
        global $ilDB;

        $prefs = array();

        $r = $ilDB->queryF(
            "SELECT * FROM usr_pref WHERE usr_id = %s",
            array("integer"),
            array($user_id)
        );

        while ($row = $ilDB->fetchAssoc($r)) {
            $prefs[$row["keyword"]] = $row["value"];
        }

        return $prefs;
    }

    public static function getUserSubsetByPreferenceValue($a_user_ids, $a_keyword, $a_val)
    {
        global $ilDB;

        $users = array();
        $set = $ilDB->query(
            "SELECT usr_id FROM usr_pref " .
            " WHERE keyword = " . $ilDB->quote($a_keyword, "text") .
            " AND " . $ilDB->in("usr_id", $a_user_ids, false, "integer") .
            " AND value = " . $ilDB->quote($a_val, "text")
        );
        while ($rec = $ilDB->fetchAssoc($set)) {
            $users[] = $rec["usr_id"];
        }
        return $users;
    }


    public static function _resetLoginAttempts($a_usr_id)
    {
        global $ilDB;

        $query = "UPDATE usr_data SET login_attempts = 0 WHERE usr_id = %s";
        $affected = $ilDB->manipulateF($query, array('integer'), array($a_usr_id));

        if ($affected) {
            return true;
        } else {
            return false;
        }
    }

    public static function _getLoginAttempts($a_usr_id)
    {
        global $ilDB;

        $query = "SELECT login_attempts FROM usr_data WHERE usr_id = %s";
        $result = $ilDB->queryF($query, array('integer'), array($a_usr_id));
        $record = $ilDB->fetchAssoc($result);
        $login_attempts = $record['login_attempts'];

        return $login_attempts;
    }

    public static function _incrementLoginAttempts($a_usr_id)
    {
        global $ilDB;

        $query = "UPDATE usr_data SET login_attempts = (login_attempts + 1) WHERE usr_id = %s";
        $affected = $ilDB->manipulateF($query, array('integer'), array($a_usr_id));

        if ($affected) {
            return true;
        } else {
            return false;
        }
    }

    public static function _setUserInactive($a_usr_id)
    {
        global $ilDB;

        $query = "UPDATE usr_data SET active = 0, inactivation_date = %s WHERE usr_id = %s";
        $affected = $ilDB->manipulateF($query, array('timestamp', 'integer'), array(ilUtil::now(), $a_usr_id));
        
        if ($affected) {
            return true;
        } else {
            return false;
        }
    }
    
    public function hasPublicProfile()
    {
        return in_array($this->getPref("public_profile"), array("y", "g"));
    }
    
    public function getPublicName()
    {
        if ($this->hasPublicProfile()) {
            return $this->getFirstname() . " " . $this->getLastname() . " (" . $this->getLogin() . ")";
        } else {
            return $this->getLogin();
        }
    }
    
    public static function _writeHistory($a_usr_id, $a_login)
    {
        global $ilDB;

        $timestamp = time();
            
        $res = $ilDB->queryF(
            'SELECT * FROM loginname_history WHERE usr_id = %s AND login = %s AND history_date = %s',
            array('integer', 'text', 'integer'),
            array($a_usr_id, $a_login, $timestamp)
        );
        
        if ($ilDB->numRows($res) == 0) {
            $ilDB->manipulateF(
                '
                                INSERT INTO loginname_history 
                                                (usr_id, login, history_date)
                                VALUES  (%s, %s, %s)',
                array('integer', 'text', 'integer'),
                array($a_usr_id, $a_login, $timestamp)
            );
        }
        
        return true;
    }
    
    public static function _getUsersOnline($a_user_id = 0, $a_no_anonymous = false)
    {
        global $DIC;

        $ilDB       = $DIC->database();
        $rbacreview = $DIC->rbac()->review();

        $log = ilLoggerFactory::getLogger("user");

        $pd_set = new ilSetting('pd');
        $atime  = $pd_set->get('user_activity_time') * 60;
        $ctime  = time();
        
        $where = array();

        if ($a_user_id == 0) {
            $where[] = 'user_id > 0';
        } elseif (is_array($a_user_id)) {
            $where[] = $ilDB->in("user_id", $a_user_id, false, "integer");
        } else {
            $where[] = 'user_id = ' . $ilDB->quote($a_user_id, 'integer');
        }

        if ($a_no_anonymous) {
            $where[] = 'user_id != ' . $ilDB->quote(ANONYMOUS_USER_ID, 'integer');
        }

        include_once 'Services/User/classes/class.ilUserAccountSettings.php';
        if (ilUserAccountSettings::getInstance()->isUserAccessRestricted()) {
            include_once 'Services/User/classes/class.ilUserFilter.php';
            $where[] =  $ilDB->in('time_limit_owner', ilUserFilter::getInstance()->getFolderIds(), false, 'integer');
        }

        $where[] = 'expires > ' . $ilDB->quote($ctime, 'integer');
        $where[] = '(p.value IS NULL OR NOT p.value = ' . $ilDB->quote('y', 'text') . ')';

        $where = 'WHERE ' . implode(' AND ', $where);

        $r = $ilDB->queryF(
            $q = "
                        SELECT COUNT(user_id) num, user_id, firstname, lastname, title, login, last_login, MAX(ctime) ctime, context, agree_date
                        FROM usr_session
                        LEFT JOIN usr_data u
                                ON user_id = u.usr_id
                        LEFT JOIN usr_pref p
                                ON (p.usr_id = u.usr_id AND p.keyword = %s)
                        {$where}
                        GROUP BY user_id, firstname, lastname, title, login, last_login, context, agree_date
                        ORDER BY lastname, firstname
                        ",
            array('text'),
            array('hide_own_online_status')
        );

        $log->debug("Query: " . $q);

        $users = array();
        while ($user = $ilDB->fetchAssoc($r)) {
            if ($atime <= 0 || $user['ctime'] + $atime > $ctime) {
                $users[$user['user_id']] = $user;
            }
        }

        $log->debug("Found users: " . count($users));

        require_once 'Services/TermsOfService/classes/class.ilTermsOfServiceHelper.php';
        if (ilTermsOfServiceHelper::isEnabled()) {
            $users = array_filter($users, function ($user) {
                if ($user['agree_date'] || $user['user_id'] == SYSTEM_USER_ID || 'root' === $user['login']) {
                    return true;
                }

                return false;
            });

            $log->debug("TOS filtered to users: " . count($users));
        }

        return $users;
    }

    public static function _getAssociatedUsersOnline($a_user_id, $a_no_anonymous = false)
    {
        global $ilias, $ilDB;

        $pd_set = new ilSetting("pd");
        $atime = $pd_set->get("user_activity_time") * 60;
        $ctime = time();
        $no_anonym = ($a_no_anonymous)
            ? "AND user_id <> " . $ilDB->quote(ANONYMOUS_USER_ID, "integer") . " "
            : "";

        // Get a list of object id's of all courses and groups for which
        // the current user has local roles.
        // Note: we have to use DISTINCT here, because a user may assume
        // multiple roles in a group or a course.
        $q = "SELECT DISTINCT dat.obj_id as obj_id " .
            "FROM rbac_ua ua " .
            "JOIN rbac_fa fa ON fa.rol_id = ua.rol_id " .
            "JOIN object_reference r1 ON r1.ref_id = fa.parent " .
            "JOIN tree ON tree.child = r1.ref_id " .
            "JOIN object_reference r2 ON r2.ref_id = tree.child " . // #17674 - rolf is gone
            "JOIN object_data dat ON dat.obj_id = r2.obj_id " .
            "WHERE ua.usr_id = " . $ilDB->quote($a_user_id, "integer") . " " .
            "AND fa.assign = " . $ilDB->quote("y", "text") . " " .
            "AND dat.type IN (" . $ilDB->quote("crs", "text") . "," .
            $ilDB->quote("grp", "text") . ")";
        $r = $ilDB->query($q);

        while ($row = $ilDB->fetchAssoc($r)) {
            $groups_and_courses_of_user[] = $row["obj_id"];
        }

        require_once 'Services/TermsOfService/classes/class.ilTermsOfServiceHelper.php';
        $tos_condition = '';
        if (ilTermsOfServiceHelper::isEnabled()) {
            $tos_condition = " AND (agree_date IS NOT NULL OR ud.usr_id = " . $ilDB->quote(SYSTEM_USER_ID, 'integer') . ") ";
        }

        // If the user is not in a course or a group, he has no associated users.
        if (count($groups_and_courses_of_user) == 0) {
            $q = "SELECT count(user_id) as num,ctime,user_id,firstname,lastname,title,login,last_login " .
                "FROM usr_session " .
                "JOIN usr_data ud ON user_id = ud.usr_id " .
                "WHERE user_id = " . $ilDB->quote($a_user_id, "integer") . " " .
                $no_anonym .
                $tos_condition .
                "AND expires > " . $ilDB->quote(time(), "integer") . " " .
                "GROUP BY user_id,ctime,firstname,lastname,title,login,last_login";
            $r = $ilDB->query($q);
        } else {
            $q = "SELECT count(user_id) as num,s.ctime,s.user_id,ud.firstname,ud.lastname,ud.title,ud.login,ud.last_login " .
                "FROM usr_session s " .
                "JOIN usr_data ud ON ud.usr_id = s.user_id " .
                "JOIN rbac_ua ua ON ua.usr_id = s.user_id " .
                "JOIN rbac_fa fa ON fa.rol_id = ua.rol_id " .
                "JOIN tree ON tree.child = fa.parent " .
                "JOIN object_reference or1 ON or1.ref_id = tree.child " . // #17674 - rolf is gone
                "JOIN object_data od ON od.obj_id = or1.obj_id " .
                "LEFT JOIN usr_pref p ON (p.usr_id = ud.usr_id AND p.keyword = " .
                    $ilDB->quote("hide_own_online_status", "text") . ") " .
                "WHERE s.user_id != 0 " .
                $no_anonym .
                "AND (p.value IS NULL OR NOT p.value = " . $ilDB->quote("y", "text") . ") " .
                "AND s.expires > " . $ilDB->quote(time(), "integer") . " " .
                "AND fa.assign = " . $ilDB->quote("y", "text") . " " .
                $tos_condition .
                "AND " . $ilDB->in("od.obj_id", $groups_and_courses_of_user, false, "integer") . " " .
                "GROUP BY s.user_id,s.ctime,ud.firstname,ud.lastname,ud.title,ud.login,ud.last_login " .
                "ORDER BY ud.lastname, ud.firstname";
            $r = $ilDB->query($q);
        }

        while ($user = $ilDB->fetchAssoc($r)) {
            if ($atime <= 0
                || $user["ctime"] + $atime > $ctime) {
                $users[$user["user_id"]] = $user;
            }
        }

        return $users ? $users : array();
    }
    
    public static function _generateRegistrationHash($a_usr_id)
    {
        global $ilDB;
        
        do {
            $continue = false;

            $random = new \ilRandom();
            $hashcode = substr(md5(uniqid($random->int(), true)), 0, 16);
            
            $res = $ilDB->queryf(
                '
                                SELECT COUNT(usr_id) cnt FROM usr_data 
                                WHERE reg_hash = %s',
                array('text'),
                array($hashcode)
            );
            while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
                if ($row->cnt > 0) {
                    $continue = true;
                }
                break;
            }
            
            if ($continue) {
                continue;
            }
            
            $ilDB->manipulateF(
                '
                                UPDATE usr_data 
                                SET reg_hash = %s       
                                WHERE usr_id = %s',
                array('text', 'integer'),
                array($hashcode, (int) $a_usr_id)
            );
            
            break;
        } while (true);
        
        return $hashcode;
    }
    
    public static function _verifyRegistrationHash($a_hash)
    {
        global $ilDB;
        
        $res = $ilDB->queryf(
            '
                        SELECT usr_id, create_date FROM usr_data 
                        WHERE reg_hash = %s',
            array('text'),
            array($a_hash)
        );
        while ($row = $ilDB->fetchAssoc($res)) {
            require_once 'Services/Registration/classes/class.ilRegistrationSettings.php';
            $oRegSettigs = new ilRegistrationSettings();
            
            if ((int) $oRegSettigs->getRegistrationHashLifetime() != 0 &&
               time() - (int) $oRegSettigs->getRegistrationHashLifetime() > strtotime($row['create_date'])) {
                require_once 'Services/Registration/exceptions/class.ilRegConfirmationLinkExpiredException.php';
                throw new ilRegConfirmationLinkExpiredException('reg_confirmation_hash_life_time_expired', $row['usr_id']);
            }
            
            $ilDB->manipulateF(
                '
                                UPDATE usr_data 
                                SET reg_hash = %s
                                WHERE usr_id = %s',
                array('text', 'integer'),
                array('', (int) $row['usr_id'])
            );
            
            return (int) $row['usr_id'];
        }
        
        require_once 'Services/Registration/exceptions/class.ilRegistrationHashNotFoundException.php';
        throw new ilRegistrationHashNotFoundException('reg_confirmation_hash_not_found');
    }

    public function setBirthday($a_birthday)
    {
        if (strlen($a_birthday)) {
            $date = new ilDate($a_birthday, IL_CAL_DATE);
            $this->birthday = $date->get(IL_CAL_DATE);
        } else {
            $this->birthday = null;
        }
    }
    
    public function getBirthday()
    {
        return $this->birthday;
    }

    public static function _getUserIdsByInactivityPeriod($period)
    {
        if (!(int) $period) {
            throw new ilException('no valid period given');
        }

        global $ilDB;

        $date = date('Y-m-d H:i:s', (time() - ((int) $period * 24 * 60 * 60)));

        $query = "SELECT usr_id FROM usr_data WHERE last_login < %s OR (ISNULL(last_login) AND create_date < %s)";

        $res = $ilDB->queryF($query, array('timestamp', 'timestamp'), array($date, $date));

        $ids = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $ids[] = $row->usr_id;
        }

        return $ids;
    }
    
    public static function _getUserIdsByInactivationPeriod($period)
    {
        $field = 'inactivation_date';
        
        if (!(int) $period) {
            throw new ilException('no valid period given');
        }

        global $ilDB;

        $date = date('Y-m-d H:i:s', (time() - ((int) $period * 24 * 60 * 60)));

        $query = "SELECT usr_id FROM usr_data WHERE $field < %s AND active = %s";

        $res = $ilDB->queryF($query, array('timestamp', 'integer'), array($date, 0));
        
        $ids = array();
        while ($row = $res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)) {
            $ids[] = $row->usr_id;
        }

        return $ids;
    }

    public static function _updateLastLogin($a_usr_id, $a_last_login = null)
    {
        if ($a_last_login !== null) {
            $last_login = $a_last_login;
        } else {
            $last_login = date('Y-m-d H:i:s');
        }

        global $ilDB;

        $query = "UPDATE usr_data SET last_login = %s WHERE usr_id = %s";
        $affected = $ilDB->manipulateF($query, array('timestamp', 'integer'), array($last_login, $a_usr_id));

        if ($affected) {
            return $last_login;
        } else {
            return false;
        }
    }
    
    public function resetOwner()
    {
        global $ilDB;
        
        $query = "UPDATE object_data SET owner = 0 " .
            "WHERE owner = " . $ilDB->quote($this->getId(), 'integer');
        $ilDB->query($query);
        
        return true;
    }


    public static function getFirstLettersOfLastnames()
    {
        global $ilDB;

        $q = "SELECT DISTINCT " . $ilDB->upper($ilDB->substr("lastname", 1, 1)) . " let" .
            " FROM usr_data" .
            " WHERE usr_id <> " . $ilDB->quote(ANONYMOUS_USER_ID, "integer") .
            " ORDER BY let";
        $let_set = $ilDB->query($q);

        $lets = array();
        while ($let_rec = $ilDB->fetchAssoc($let_set)) {
            $let[$let_rec["let"]] = $let_rec["let"];
        }
        return $let;
    }
    
    // begin-patch deleteProgress
    public static function userExists($a_usr_ids = array())
    {
        global $ilDB;
        
        $query = 'SELECT count(*) num FROM object_data od ' .
                'JOIN usr_data ud ON obj_id = usr_id ' .
                'WHERE ' . $ilDB->in('obj_id', $a_usr_ids, false, 'integer') . ' ';
        $res = $ilDB->query($query);
        $num_rows =$res->fetchRow(ilDBConstants::FETCHMODE_OBJECT)->num;
        return $num_rows == count((array) $a_usr_ids);
    }
    // end-patch deleteProgress

    public function isCaptchaVerified()
    {
        return (boolean) $_SESSION["user_captcha_verified"];
    }
    
    public function setCaptchaVerified($a_val)
    {
        $_SESSION["user_captcha_verified"] = $a_val;
    }
    
    public function exportPersonalData()
    {
        include_once("./Services/Export/classes/class.ilExport.php");
        $exp = new ilExport();
        $dir = ilExport::_getExportDirectory($this->getId(), "xml", "usr", "personal_data");
        ilUtil::delDir($dir, true);
        $title = $this->getLastname() . ", " . $this->getLastname() . " [" . $this->getLogin() . "]";
        $exp->exportEntity(
            "personal_data",
            $this->getId(),
            "",
            "Services/User",
            $title,
            $dir
        );
    }
    
    public function getPersonalDataExportFile()
    {
        include_once("./Services/Export/classes/class.ilExport.php");
        $dir = ilExport::_getExportDirectory($this->getId(), "xml", "usr", "personal_data");
        if (!is_dir($dir)) {
            return "";
        }
        foreach (ilUtil::getDir($dir) as $entry) {
            if (is_int(strpos($entry["entry"], ".zip"))) {
                return $entry["entry"];
            }
        }
        
        return "";
    }
    
    public function sendPersonalDataFile()
    {
        include_once("./Services/Export/classes/class.ilExport.php");
        $file = ilExport::_getExportDirectory($this->getId(), "xml", "usr", "personal_data") .
            "/" . $this->getPersonalDataExportFile();
        if (is_file($file)) {
            ilUtil::deliverFile($file, $this->getPersonalDataExportFile());
        }
    }
    
    public function importPersonalData(
        $a_file,
        $a_profile_data,
        $a_settings,
        $a_bookmarks,
        $a_notes,
        $a_calendar
    ) {
        include_once("./Services/Export/classes/class.ilImport.php");
        $imp = new ilImport();
        if (!$a_profile_data) {
            $imp->addSkipEntity("Services/User", "usr_profile");
        }
        if (!$a_settings) {
            $imp->addSkipEntity("Services/User", "usr_setting");
        }
        if (!$a_bookmarks) {
            $imp->addSkipEntity("Services/Bookmarks", "bookmarks");
        }
        if (!$a_notes) {
            $imp->addSkipEntity("Services/Notes", "user_notes");
        }
        if (!$a_calendar) {
            $imp->addSkipEntity("Services/Calendar", "calendar");
        }
        $imp->importEntity(
            $a_file["tmp_name"],
            $a_file["name"],
            "personal_data",
            "Services/User"
        );
    }
    
    private static function initInactivationDate($usrIds)
    {
        global $ilDB;
        
        $NOW = $ilDB->now();
        
        $usrId_IN_usrIds = $ilDB->in('usr_id', $usrIds, false, 'integer');
        
        $queryString = "
                        UPDATE usr_data
                        SET inactivation_date = $NOW
                        WHERE inactivation_date IS NULL
                        AND $usrId_IN_usrIds
                ";
        
        $ilDB->manipulate($queryString);
    }
    
    private static function resetInactivationDate($usrIds)
    {
        global $ilDB;
        
        $usrId_IN_usrIds = $ilDB->in('usr_id', $usrIds, false, 'integer');
        
        $queryString = "
                        UPDATE usr_data
                        SET inactivation_date = NULL
                        WHERE $usrId_IN_usrIds
                ";
        
        $ilDB->manipulate($queryString);
    }
    
    public function setInactivationDate($inactivation_date)
    {
        $this->inactivation_date = $inactivation_date;
    }
    
    public function getInactivationDate()
    {
        return $this->inactivation_date;
    }

    public function hasToAcceptTermsOfService()
    {
        require_once 'Services/TermsOfService/classes/class.ilTermsOfServiceHelper.php';

        if (
            ilTermsOfServiceHelper::isEnabled() &&
            null == $this->agree_date &&
            'root' != $this->login &&
            !in_array($this->getId(), array(ANONYMOUS_USER_ID, SYSTEM_USER_ID))
        ) {
            return true;
        }

        return false;
    }

    public static function hasUserToAcceptTermsOfService($a_username)
    {
        global $ilDB;

        require_once 'Services/TermsOfService/classes/class.ilTermsOfServiceHelper.php';

        if (!ilTermsOfServiceHelper::isEnabled()) {
            return false;
        }

        $in = $ilDB->in('usr_id', array(ANONYMOUS_USER_ID, SYSTEM_USER_ID), true, 'integer');
        $res = $ilDB->queryF(
            "SELECT usr_id FROM usr_data WHERE login = %s AND agree_date IS NULL $in",
            array("text"),
            array($a_username)
        );
        return $ilDB->fetchAssoc($res) ? true : false;
    }

    public static function getUsersAgreed($a_agreed = true, $a_users = null)
    {
        global $ilDB;

        $date_is = ($a_agreed)
            ? "IS NOT NULL"
            : "IS NULL";

        $users = (is_array($a_users))
            ? " AND " . $ilDB->in("usr_id", $a_users, false, "integer")
            : "";

        $set = $ilDB->query("SELECT usr_id FROM usr_data " .
            " WHERE agree_date " . $date_is .
            $users);
        $ret = array();
        while ($rec = $ilDB->fetchAssoc($set)) {
            $ret[] = $rec["usr_id"];
        }
        return $ret;
    }


    public function hasToAcceptTermsOfServiceInSession($status = null)
    {
        if (null === $status) {
            return ilSession::get('has_to_accept_agr_in_session');
        }
        
        require_once 'Services/TermsOfService/classes/class.ilTermsOfServiceHelper.php';
        if (ilTermsOfServiceHelper::isEnabled()) {
            ilSession::set('has_to_accept_agr_in_session', (int) $status);
        }
    }

    public function isAnonymous()
    {
        return self::_isAnonymous($this->getId());
    }

    public static function _isAnonymous($usr_id)
    {
        return $usr_id == ANONYMOUS_USER_ID;
    }
    
    public function activateDeletionFlag()
    {
        $this->writePref("delete_flag", true);
    }
    
    public function removeDeletionFlag()
    {
        $this->writePref("delete_flag", false);
    }
    
    public function hasDeletionFlag()
    {
        return (bool) $this->getPref("delete_flag");
    }

    public function setIsSelfRegistered($status)
    {
        $this->is_self_registered = (bool) $status;
    }
    
    public function isSelfRegistered()
    {
        return (bool) $this->is_self_registered;
    }
    
    
    //
    // MULTI-TEXT / INTERESTS
    //
        
    public function setGeneralInterests(array $value = null)
    {
        $this->interests_general = $value;
    }
    
    public function getGeneralInterests()
    {
        return $this->interests_general;
    }
    
    public function getGeneralInterestsAsText()
    {
        return $this->buildTextFromArray("interests_general");
    }
    
    public function setOfferingHelp(array $value = null)
    {
        $this->interests_help_offered = $value;
    }
    
    public function getOfferingHelp()
    {
        return $this->interests_help_offered;
    }
    
    public function getOfferingHelpAsText()
    {
        return $this->buildTextFromArray("interests_help_offered");
    }
    
    public function setLookingForHelp(array $value = null)
    {
        $this->interests_help_looking = $value;
    }
    
    public function getLookingForHelp()
    {
        return $this->interests_help_looking;
    }
    
    public function getLookingForHelpAsText()
    {
        return $this->buildTextFromArray("interests_help_looking");
    }
    
    protected function buildTextFromArray($a_attr)
    {
        $current = $this->$a_attr;
        if (is_array($current) && sizeof($current)) {
            return implode(", ", $current);
        }
    }
    
    protected function readMultiTextFields()
    {
        global $ilDB;
        
        if (!$this->getId()) {
            return;
        }

        $set = $ilDB->query("SELECT field_id,value" .
            " FROM usr_data_multi" .
            " WHERE usr_id = " . $ilDB->quote($this->getId(), "integer") .
            " ORDER BY value");
        while ($row = $ilDB->fetchAssoc($set)) {
            $values[$row["field_id"]][] = $row["value"];
        }
        
        if (isset($values["interests_general"])) {
            $this->setGeneralInterests($values["interests_general"]);
        } else {
            $this->setGeneralInterests();
        }
        if (isset($values["interests_help_offered"])) {
            $this->setOfferingHelp($values["interests_help_offered"]);
        } else {
            $this->setOfferingHelp();
        }
        if (isset($values["interests_help_looking"])) {
            $this->setLookingForHelp($values["interests_help_looking"]);
        } else {
            $this->setLookingForHelp();
        }
    }
    
    public function updateMultiTextFields($a_create = false)
    {
        global $ilDB;
        
        if (!$this->getId()) {
            return;
        }
        
        if (!$a_create) {
            $this->deleteMultiTextFields();
        }
        
        $map = array(
            "interests_general" => $this->getGeneralInterests(),
            "interests_help_offered" => $this->getOfferingHelp(),
            "interests_help_looking" => $this->getLookingForHelp()
        );
        
        foreach ($map as $id => $values) {
            if (is_array($values) && sizeof($values)) {
                foreach ($values as $value) {
                    $value = trim($value);
                    if ($value) {
                        $uniq_id = $ilDB->nextId('usr_data_multi');

                        $ilDB->manipulate("INSERT usr_data_multi" .
                            " (id,usr_id,field_id,value) VALUES" .
                            " (" . $ilDB->quote($uniq_id, "integer") .
                            "," . $ilDB->quote($this->getId(), "integer") .
                            "," . $ilDB->quote($id, "text") .
                            "," . $ilDB->quote($value, "text") .
                            ")");
                    }
                }
            }
        }
    }
    
    protected function deleteMultiTextFields()
    {
        global $ilDB;
        
        if (!$this->getId()) {
            return;
        }
        
        $ilDB->manipulate("DELETE FROM usr_data_multi" .
            " WHERE usr_id = " . $ilDB->quote($this->getId(), "integer"));
    }
    
    public static function findInterests($a_term, $a_user_id = null, $a_field_id = null)
    {
        global $ilDB;
        
        $res = array();
        
        $sql = "SELECT DISTINCT(value)" .
            " FROM usr_data_multi" .
            " WHERE " . $ilDB->like("value", "text", "%" . $a_term . "%");
        if ($a_field_id) {
            $sql .= " AND field_id = " . $ilDB->quote($a_field_id, "text");
        }
        if ($a_user_id) {
            $sql .=  " AND usr_id <> " . $ilDB->quote($a_user_id, "integer");
        }
        $sql .= " ORDER BY value";
        $set = $ilDB->query($sql);
        while ($row = $ilDB->fetchAssoc($set)) {
            $res[] = $row["value"];
        }
        
        return $res;
    }

    public static function getProfileStatusOfUsers($a_user_ids)
    {
        global $DIC;

        $ilDB = $DIC->database();

        $set = $ilDB->query(
            "SELECT * FROM usr_pref " .
                " WHERE keyword = " . $ilDB->quote("public_profile", "text") .
                " AND " . $ilDB->in("usr_id", $a_user_ids, false, "integer")
        );
        $r = array(
            "global" => array(),
            "local" => array(),
            "public" => array(),
            "not_public" => array()
        );
        while ($rec = $ilDB->fetchAssoc($set)) {
            if ($rec["value"] == "g") {
                $r["global"][] = $rec["usr_id"];
                $r["public"][] = $rec["usr_id"];
            }
            if ($rec["value"] == "y") {
                $r["local"][] = $rec["usr_id"];
                $r["public"][] = $rec["usr_id"];
            }
        }
        foreach ($a_user_ids as $id) {
            if (!in_array($id, $r["public"])) {
                $r["not_public"][] = $id;
            }
        }

        return $r;
    }
} // END class ilObjUser