user.php

<?php
 
 
if (!defined('XOOPS_ROOT_PATH')) {
    exit();
}
 
class XoopsUser extends XoopsObject
{

    public $_groups = [];
    public $_isAdmin = null;
    public $_rank = null;
    public $_isOnline = null;

    public function __construct($id = null)
    {
        static $initVars;
        if (isset($initVars)) {
            $this->vars = $initVars;
        } else {
            $this->initVar('uid', XOBJ_DTYPE_INT, null, false);
            $this->initVar('name', XOBJ_DTYPE_TXTBOX, null, false, 60);
            $this->initVar('uname', XOBJ_DTYPE_TXTBOX, null, true, 25);
            $this->initVar('email', XOBJ_DTYPE_TXTBOX, null, true, 256);
            $this->initVar('url', XOBJ_DTYPE_TXTBOX, null, false, 100);
            $this->initVar('user_avatar', XOBJ_DTYPE_TXTBOX, null, false, 30);
            $this->initVar('user_regdate', XOBJ_DTYPE_INT, null, false);
            $this->initVar('user_icq', XOBJ_DTYPE_TXTBOX, null, false, 15);
            $this->initVar('user_from', XOBJ_DTYPE_TXTBOX, null, false, 100);
            $this->initVar('user_sig', XOBJ_DTYPE_TXTAREA, null, false, null);
            $this->initVar('user_viewemail', XOBJ_DTYPE_INT, 0, false);
            $this->initVar('actkey', XOBJ_DTYPE_OTHER, null, false);
            $this->initVar('user_aim', XOBJ_DTYPE_TXTBOX, null, false, 18);
            $this->initVar('user_yim', XOBJ_DTYPE_TXTBOX, null, false, 25);
            $this->initVar('user_msnm', XOBJ_DTYPE_TXTBOX, null, false, 100);
            $this->initVar('pass', XOBJ_DTYPE_TXTBOX, null, false, 255);
            $this->initVar('posts', XOBJ_DTYPE_INT, null, false);
            $this->initVar('attachsig', XOBJ_DTYPE_INT, 0, false);
            $this->initVar('rank', XOBJ_DTYPE_INT, 0, false);
            $this->initVar('level', XOBJ_DTYPE_INT, 0, false);
            $this->initVar('theme', XOBJ_DTYPE_OTHER, null, false);
            $this->initVar('timezone_offset', XOBJ_DTYPE_OTHER, null, false);
            $this->initVar('last_login', XOBJ_DTYPE_INT, 0, false);
            $this->initVar('umode', XOBJ_DTYPE_OTHER, null, false);
            $this->initVar('uorder', XOBJ_DTYPE_INT, 1, false);
            // RMV-NOTIFY
            $this->initVar('notify_method', XOBJ_DTYPE_OTHER, 1, false);
            $this->initVar('notify_mode', XOBJ_DTYPE_OTHER, 0, false);
            $this->initVar('user_occ', XOBJ_DTYPE_TXTBOX, null, false, 100);
            $this->initVar('bio', XOBJ_DTYPE_TXTAREA, null, false, null);
            $this->initVar('user_intrest', XOBJ_DTYPE_TXTBOX, null, false, 150);
            $this->initVar('user_mailok', XOBJ_DTYPE_INT, 1, false);
            $initVars = $this->vars;
        }
 
        // for backward compatibility
        if (isset($id)) {
            if (is_array($id)) {
                $this->assignVars($id);
            } else {
                $member_handler = xoops_gethandler('member');
                $user =& $member_handler->getUser($id);
                foreach ($user->vars as $k => $v) {
                    $this->assignVar($k, $v['value']);
                }
            }
        }
    }
    public function XoopsUser($id = null)
    {
        return self::__construct($id);
    }

    public function isGuest()
    {
        return false;
    }

    public static function getUnameFromId($userid, $usereal = 0)
    {
        $userid = (int)$userid;
        $usereal = (int)$usereal;
        if ($userid > 0) {
            static $nameCache;
            $field = $usereal?'name':'uname';
            if (isset($nameCache[$field][$userid])) {
                return $nameCache[$field][$userid];
            }
            $member_handler = xoops_gethandler('member');
            $user =& $member_handler->getUser($userid);
            if (is_object($user)) {
                return ($nameCache[$field][$userid] = $user->getVar($field));
            }
        }
        return $GLOBALS['xoopsConfig']['anonymous'];
    }

    public function incrementPost()
    {
        $member_handler = xoops_gethandler('member');
        return $member_handler->updateUserByField($this, 'posts', $this->getVar('posts') + 1);
    }

    public function setGroups($groupsArr)
    {
        if (is_array($groupsArr)) {
            $this->_groups =& $groupsArr;
        }
    }

    public function getGroups($bReget = false)
    {
        if ($bReget) {
            unset($this->_groups);
        }
 
        if (empty($this->_groups)) {
            $member_handler = xoops_gethandler('member');
            $this->_groups = $member_handler->getGroupsByUser($this->getVar('uid'));
        }
        return $this->_groups;
    }
 
    public function getNumGroups()
    {
        if (empty($this->_groups)) {
            $this->getGroups();
        }
        return count($this->_groups);
    }
 

    public function groups()
    {
        return $this->getGroups();
    }

    public function isAdmin($module_id = null)
    {
        if (null === $module_id) {
            global $xoopsModule;
            $module_id = isset($xoopsModule) ? $xoopsModule->getVar('mid', 'n') : 1;
        } elseif ((int)$module_id < 1) {
            $module_id = 0;
        }
        static $moduleperm_handler;
        isset($moduleperm_handler) || $moduleperm_handler = xoops_gethandler('groupperm');
        return $moduleperm_handler->checkRight('module_admin', $module_id, $this->getGroups());
    }

    public function rank()
    {
        if (!isset($this->_rank)) {
            $this->_rank = xoops_getrank($this->getVar('rank'), $this->getVar('posts'));
        }
        return $this->_rank;
    }

    public function isActive()
    {
        return ! ( 0 == $this->getVar( 'level' ) );
    }

    public function isOnline()
    {
        if (!isset($this->_isOnline)) {
            $onlinehandler = xoops_gethandler('online');
            // $this->_isOnline = ($onlinehandler->getCount(new Criteria('online_uid', $this->getVar('uid', 'N'))) > 0) ? true : false;
            $this->_isOnline = $onlinehandler->getCount(new Criteria('online_uid', $this->getVar('uid', 'N'))) > 0;
        }
        return $this->_isOnline;
    }

    public function uid()
    {
        return $this->getVar('uid');
    }

    public function name($format= 'S')
    {
        return $this->getVar('name', $format);
    }

    public function uname($format= 'S')
    {
        return $this->getVar('uname', $format);
    }

    public function email($format= 'S')
    {
        return $this->getVar('email', $format);
    }
 
    public function url($format= 'S')
    {
        return $this->getVar('url', $format);
    }
 
    public function user_avatar($format= 'S')
    {
        return $this->getVar('user_avatar');
    }
 
    public function user_regdate()
    {
        return $this->getVar('user_regdate');
    }
 
    public function user_icq($format= 'S')
    {
        return $this->getVar('user_icq', $format);
    }
 
    public function user_from($format= 'S')
    {
        return $this->getVar('user_from', $format);
    }
    public function user_sig($format= 'S')
    {
        return $this->getVar('user_sig', $format);
    }
 
    public function user_viewemail()
    {
        return $this->getVar('user_viewemail');
    }
 
    public function actkey()
    {
        return $this->getVar('actkey');
    }
 
    public function user_aim($format= 'S')
    {
        return $this->getVar('user_aim', $format);
    }
 
    public function user_yim($format= 'S')
    {
        return $this->getVar('user_yim', $format);
    }
 
    public function user_msnm($format= 'S')
    {
        return $this->getVar('user_msnm', $format);
    }
 
    public function pass()
    {
        return $this->getVar('pass');
    }
 
    public function posts()
    {
        return $this->getVar('posts');
    }
 
    public function attachsig()
    {
        return $this->getVar('attachsig');
    }
 
    public function level()
    {
        return $this->getVar('level');
    }
 
    public function theme()
    {
        return $this->getVar('theme');
    }
 
    public function timezone()
    {
        return $this->getVar('timezone_offset');
    }
 
    public function umode()
    {
        return $this->getVar('umode');
    }
 
    public function uorder()
    {
        return $this->getVar('uorder');
    }
 
    // RMV-NOTIFY
    public function notify_method()
    {
        return $this->getVar('notify_method');
    }
 
    public function notify_mode()
    {
        return $this->getVar('notify_mode');
    }
 
    public function user_occ($format= 'S')
    {
        return $this->getVar('user_occ', $format);
    }
 
    public function bio($format= 'S')
    {
        return $this->getVar('bio', $format);
    }
 
    public function user_intrest($format= 'S')
    {
        return $this->getVar('user_intrest', $format);
    }
 
    public function last_login()
    {
        return $this->getVar('last_login');
    }

    public function hasAvatar()
    {
        $avatar=$this->getVar('user_avatar');
        if (!$avatar || 'blank.gif' == $avatar) {
            return false;
        }
 
        $file= XOOPS_UPLOAD_PATH . '/' . $avatar;
        return file_exists($file);
    }

    public function getAvatarUrl()
    {
        if ($this->hasAvatar()) {
            return XOOPS_UPLOAD_URL . '/' . $this->getVar('user_avatar');
        }
 
        return null;
    }

}

class XoopsGuestUser extends XoopsUser
{
    public function isGuest()
    {
        return true;
    }
 
    public function getGroups($bReget = false)
    {
        return XOOPS_GROUP_ANONYMOUS;
    }
}
 

class XoopsUserHandler extends XoopsObjectHandler
{

    public function &create($isNew = true)
    {
        $user =new XoopsUser();
        if ($isNew) {
            $user->setNew();
        }
        return $user;
    }

    public function &get($id)
    {
        $ret = false;
        if ((int)$id > 0) {
            $sql = 'SELECT * FROM '.$this->db->prefix('users').' WHERE uid='.$id;
            if ($result = $this->db->query($sql)) {
                $numrows = $this->db->getRowsNum($result);
                if (1 == $numrows) {
                    $user =new XoopsUser();
                    $user->assignVars($this->db->fetchArray($result));
                    $ret =& $user;
                }
            }
        }
        return $ret;
    }

    public function insert(&$user, $force = false)
    {
        $uname = null;
        $name = null;
        $email = null;
        $url = null;
        $user_avatar = null;
        $user_icq = null;
        $user_from = null;
        $user_sig = null;
        $user_viewemail = null;
        $actkey = null;
        $user_aim = null;
        $user_yim = null;
        $user_msnm = null;
        $pass = null;
        $posts = null;
        $attachsig = null;
        $rank = null;
        $level = null;
        $theme = null;
        $timezone_offset = null;
        $umode = null;
        $uorder = null;
        $notify_method = null;
        $notify_mode = null;
        $user_occ = null;
        $bio = null;
        $user_intrest = null;
        $user_mailok = null;
        $last_login = null;
        $uid = null;
        if ('xoopsuser' != strtolower(get_class($user))) {
            return false;
        }
        if (!$user->isDirty()) {
            return true;
        }
        if (!$user->cleanVars()) {
            return false;
        }
        // check pass colmun length of users table
        if (!defined('XCUBE_CORE_USER_PASS_LEN_FIXED') && is_callable('User_Utils::checkUsersPassColumnLength')) {
            User_Utils::checkUsersPassColumnLength();
        }
        foreach ($user->cleanVars as $k => $v) {
            ${$k} = $v;
        }
        // RMV-NOTIFY
        // Added two fields, notify_method, notify_mode
        if ($user->isNew()) {
            $config = xoops_gethandler('config');
            $options = $config->getConfigs(new Criteria('conf_name', 'notify_method'));
            if (isset($options) and (1 == (is_countable($options) ? count($options) : 0))) {
                $notify_method = $options[0]->getvar('conf_value');
            }
            $uid = $this->db->genId('users_uid_seq');
            $sql = sprintf(
                'INSERT INTO %s (uid, uname, name, email, url, user_avatar, user_regdate, user_icq, user_from, user_sig, user_viewemail, actkey, user_aim, user_yim, user_msnm, pass, posts, attachsig, `rank`, level, theme, timezone_offset, last_login, umode, uorder, notify_method, notify_mode, user_occ, bio, user_intrest, user_mailok) VALUES (%u, %s, %s, %s, %s, %s, %u, %s, %s, %s, %u, %s, %s, %s, %s, %s, %u, %u, %u, %u, %s, %.2f, %u, %s, %u, %u, %u, %s, %s, %s, %u)', $this->db->prefix('users'), $uid, $this->db->quoteString($uname), $this->db->quoteString($name), $this->db->quoteString($email), $this->db->quoteString($url), $this->db->quoteString($user_avatar), time(), $this->db->quoteString($user_icq), $this->db->quoteString($user_from), $this->db->quoteString($user_sig), $user_viewemail, $this->db->quoteString($actkey), $this->db->quoteString($user_aim), $this->db->quoteString($user_yim), $this->db->quoteString($user_msnm), $this->db->quoteString($pass), $posts, $attachsig, $rank, $level, $this->db->quoteString($theme), $timezone_offset, 0, $this->db->quoteString($umode), $uorder, $notify_method, $notify_mode, $this->db->quoteString($user_occ), $this->db->quoteString($bio), $this->db->quoteString($user_intrest), $user_mailok);
        } else {
            $sql = sprintf(
                'UPDATE %s SET uname = %s, name = %s, email = %s, url = %s, user_avatar = %s, user_icq = %s, user_from = %s, user_sig = %s, user_viewemail = %u, user_aim = %s, user_yim = %s, user_msnm = %s, posts = %d,  pass = %s, attachsig = %u, `rank` = %u, level= %u, theme = %s, timezone_offset = %.2f, umode = %s, last_login = %u, uorder = %u, notify_method = %u, notify_mode = %u, user_occ = %s, bio = %s, user_intrest = %s, user_mailok = %u WHERE uid = %u', $this->db->prefix('users'), $this->db->quoteString($uname), $this->db->quoteString($name), $this->db->quoteString($email), $this->db->quoteString($url), $this->db->quoteString($user_avatar), $this->db->quoteString($user_icq), $this->db->quoteString($user_from), $this->db->quoteString($user_sig), $user_viewemail, $this->db->quoteString($user_aim), $this->db->quoteString($user_yim), $this->db->quoteString($user_msnm), $posts, $this->db->quoteString($pass), $attachsig, $rank, $level, $this->db->quoteString($theme), $timezone_offset, $this->db->quoteString($umode), $last_login, $uorder, $notify_method, $notify_mode, $this->db->quoteString($user_occ), $this->db->quoteString($bio), $this->db->quoteString($user_intrest), $user_mailok, $uid);
        }
        if (false != $force) {
            $result = $this->db->queryF($sql);
        } else {
            $result = $this->db->query($sql);
        }
        if (!$result) {
            return false;
        }
        if (empty($uid)) {
            $uid = $this->db->getInsertId();
        }
        $user->assignVar('uid', $uid);
        return true;
    }

    public function delete(&$user, $force = false)
    {
        if ('xoopsuser' != strtolower(get_class($user))) {
            return false;
        }
        $sql = sprintf('DELETE FROM %s WHERE uid = %u', $this->db->prefix('users'), $user->getVar('uid'));
        if (false != $force) {
            $result = $this->db->queryF($sql);
        } else {
            $result = $this->db->query($sql);
        }
        if (!$result) {
            return false;
        }
        return true;
    }

    public function getUnames($criteria = null, $id_as_key = false)
    {
        $ret = [];
        $limit = $start = 0;
        $sql = 'SELECT * FROM '.$this->db->prefix('users');
        if (isset($criteria) && $criteria instanceof \criteriaelement) {
            $sql .= ' '.$criteria->renderWhere();
            if ('' != $criteria->getSort()) {
                $sql .= ' ORDER BY '.$criteria->getSort().' '.$criteria->getOrder();
            }
            $limit = $criteria->getLimit();
            $start = $criteria->getStart();
        }
        $result = $this->db->query($sql, $limit, $start);
        if (!$result) {
            return $ret;
        }
        while ($myrow = $this->db->fetchArray($result)) {
            if (!$id_as_key) {
                $ret[] = $myrow['uname'];
            } else {
                $ret[$myrow['uid']] = $myrow['uname'];
            }
        }
        return $ret;
    }

    public function &getObjects($criteria = null, $id_as_key = false)
    {
        $ret = [];
        $limit = $start = 0;
        $sql = 'SELECT * FROM '.$this->db->prefix('users');
        if (isset($criteria) && $criteria instanceof \criteriaelement) {
            $sql .= ' '.$criteria->renderWhere();
            if ('' != $criteria->getSort()) {
                $sql .= ' ORDER BY '.$criteria->getSort().' '.$criteria->getOrder();
            }
            $limit = $criteria->getLimit();
            $start = $criteria->getStart();
        }
        $result = $this->db->query($sql, $limit, $start);
        if (!$result) {
            return $ret;
        }
        while ($myrow = $this->db->fetchArray($result)) {
            $user =new XoopsUser();
            $user->assignVars($myrow);
            if (!$id_as_key) {
                $ret[] =& $user;
            } else {
                $ret[$myrow['uid']] =& $user;
            }
            unset($user);
        }
        return $ret;
    }

    public function &getObjectsByLevel($level=0)
    {
        $ret= [];
        $level=(int)$level;
        $result = $this->db->query('SELECT * FROM ' . $this->db->prefix('users') . " WHERE level > $level ORDER BY uname");
        if (!$result) {
            return $ret;
        }
 
        while ($myrow=$this->db->fetchArray($result)) {
            $user=new XoopsUser();
            $user->assignVars($myrow);
            $ret[]=&$user;
            unset($user);
        }
 
        return $ret;
    }

    public function getCount($criteria = null)
    {
        $sql = 'SELECT COUNT(*) FROM '.$this->db->prefix('users');
        if (isset($criteria) && $criteria instanceof \criteriaelement) {
            $sql .= ' '.$criteria->renderWhere();
        }
        $result = $this->db->query($sql);
        if (!$result) {
            return 0;
        }
        [$count] = $this->db->fetchRow($result);
        return $count;
    }

    public function deleteAll($criteria = null)
    {
        $sql = 'DELETE FROM '.$this->db->prefix('users');
        if (isset($criteria) && $criteria instanceof \criteriaelement) {
            $sql .= ' '.$criteria->renderWhere();
        }
        if (!$result = $this->db->query($sql)) {
            return false;
        }
        return true;
    }

    public function updateAll($fieldname, $fieldvalue, $criteria = null)
    {
        $set_clause = is_numeric($fieldvalue) ? $fieldname.' = '.$fieldvalue : $fieldname.' = '.$this->db->quoteString($fieldvalue);
        $sql = 'UPDATE '.$this->db->prefix('users').' SET '.$set_clause;
        if (isset($criteria) && $criteria instanceof \criteriaelement) {
            $sql .= ' '.$criteria->renderWhere();
        }
        if (!$result = $this->db->query($sql)) {
            return false;
        }
        return true;
    }
}