roundcubemail/program/lib/Roundcube/rcube_user.php
static function query($user, $host)
    {
        $dbh    = rcube::get_instance()->get_dbh();
        $config = rcube::get_instance()->config;

        // query for matching user name
        $sql_result = $dbh->query("SELECT * FROM " . $dbh->table_name('users', true)
            ." WHERE `mail_host` = ? AND `username` = ?", $host, $user);

        $sql_arr = $dbh->fetch_assoc($sql_result);

        // username not found, try aliases from identities
        if (empty($sql_arr) && $config->get('user_aliases') && strpos($user, '@')) {
            $sql_result = $dbh->limitquery("SELECT u.*"
                ." FROM " . $dbh->table_name('users', true) . " u"
                ." JOIN " . $dbh->table_name('identities', true) . " i ON (i.`user_id` = u.`user_id`)"
                ." WHERE `email` = ? AND `del` <> 1", 0, 1, $user);

            $sql_arr = $dbh->fetch_assoc($sql_result);
        }

        // user already registered -> overwrite username
        if ($sql_arr) {
            return new rcube_user($sql_arr['user_id'], $sql_arr);
        }

        return false;
    }
static function query($user, $host)
    {
        $dbh    = rcube::get_instance()->get_dbh();
        $config = rcube::get_instance()->config;

        // query for matching user name
        $sql_result = $dbh->query("SELECT * FROM " . $dbh->table_name('users', true)
            ." WHERE `mail_host` = ? AND `username` = ?", $host, $user);

        $sql_arr = $dbh->fetch_assoc($sql_result);

        // username not found, try aliases from identities
        if (empty($sql_arr) && $config->get('user_aliases') && strpos($user, '@')) {
            $sql_result = $dbh->limitquery("SELECT u.*"
                ." FROM " . $dbh->table_name('users', true) . " u"
                ." JOIN " . $dbh->table_name('identities', true) . " i ON (i.`user_id` = u.`user_id`)"
                ." WHERE `email` = ? AND `del` <> 1", 0, 1, $user);

            $sql_arr = $dbh->fetch_assoc($sql_result);
        }

        // user already registered -> overwrite username
        if ($sql_arr) {
            return new rcube_user($sql_arr['user_id'], $sql_arr);
        }

        return false;
    }
static function query ( $ user , $ host ) { $ dbh = rcube :: get_instance ( ) -> get_dbh ( ) ; $ config = rcube :: get_instance ( ) -> config ; // query for matching user name $ sql_result = $ dbh -> query ( "SELECT * FROM " . $ dbh -> table_name ( 'users' , true ) . " WHERE `mail_host` = ? AND `username` = ?" , $ host , $ user ) ; $ sql_arr = $ dbh -> fetch_assoc ( $ sql_result ) ; // username not found, try aliases from identities if ( empty ( $ sql_arr ) && $ config -> get ( 'user_aliases' ) && strpos ( $ user , '@' ) ) { $ sql_result = $ dbh -> limitquery ( "SELECT u.*" . " FROM " . $ dbh -> table_name ( 'users' , true ) . " u" . " JOIN " . $ dbh -> table_name ( 'identities' , true ) . " i ON (i.`user_id` = u.`user_id`)" . " WHERE `email` = ? AND `del` <> 1" , 0 , 1 , $ user ) ; $ sql_arr = $ dbh -> fetch_assoc ( $ sql_result ) ; } // user already registered -> overwrite username if ( $ sql_arr ) { return new rcube_user ( $ sql_arr [ 'user_id' ] , $ sql_arr ) ; } return false ; }
Find a user record matching the given name and host

@param string $user IMAP user name
@param string $host IMAP host name
@return rcube_user New user instance
Find a user record matching the given name and host