XOOPS / XoopsCore25

     *           objects? FALSE returns associative array.

     * @return array array of groups the user belongs to

     */

    public function getGroupsByUser($uid)

    {

        $ret    = array();

        $sql    = 'SELECT groupid FROM ' . $this->db->prefix('groups_users_link') . ' WHERE uid=' . (int)$uid;

        $result = $this->db->query($sql);

        if (!$result) {

            return $ret;

        }

        while ($myrow = $this->db->fetchArray($result)) {

            $ret[] = $myrow['groupid'];

        }

        return $ret;

    }

    /**

     * retrieve users belonging to a group

     *                        FALSE will return arrays

     * @return array array of users belonging to the group

     */

    public function getUsersByGroup($groupid, $limit = 0, $start = 0)

    {

        $ret    = array();

        $sql    = 'SELECT uid FROM ' . $this->db->prefix('groups_users_link') . ' WHERE groupid=' . (int)$groupid;

        $result = $this->db->query($sql, $limit, $start);

        if (!$result) {

            return $ret;

        }

        while ($myrow = $this->db->fetchArray($result)) {

            $ret[] = $myrow['uid'];

        }

        return $ret;

    }

}