ChAvaDb.php

Go to the documentation of this file.

<?php
 
ch_import('ChWsbModuleDb');
 
define('CH_AVATAR_TABLE_PREFIX', 'ch_avatar_');
 
/*
 * Avatar module Data
 */
class ChAvaDb extends ChWsbModuleDb
{
    var $_oConfig;
    /*
     * Constructor.
     */
    function __construct(&$oConfig)
    {
        parent::__construct();
 
        $this->_oConfig = $oConfig;
    }
 
    function updateProfile ($iAvatar, $iOwner, $isAdmin)
    {
        if (-1 == $iAvatar)
            $iAvatar = (int)$this->getOne ("SELECT `id` FROM `" . CH_AVATAR_TABLE_PREFIX . "images` WHERE `author_id` = $iOwner LIMIT 1");
 
        if ((int)$iOwner)
            return $this->query("UPDATE `Profiles` SET `Avatar` = '$iAvatar' WHERE `ID` = " . (int)$iOwner);
        else
            return false;
    }
 
    function getCurrentAvatar ($iOwner, $isAdmin)
    {
        if ((int)$iOwner)
            return $this->getOne("SELECT `Avatar` FROM `Profiles` WHERE `ID` = " . (int)$iOwner);
        else
            return 0;
    }
 
    function getAvatarByIdAndOwner ($iId, $iOwner, $isAdmin)
    {
        $sWhere = '';
        if (!$isAdmin)
            $sWhere = " AND `author_id` = '$iOwner' ";
        return $this->getRow ("SELECT * FROM `" . CH_AVATAR_TABLE_PREFIX . "images` WHERE `id` = ? $sWhere LIMIT 1", [$iId]);
    }
 
    function getAvatarsByAuthor($iProfileId)
    {
        return $this->getPairs ("SELECT `id` FROM `" . CH_AVATAR_TABLE_PREFIX . "images` WHERE `author_id` = '$iProfileId'", 'id', 'id');
    }
 
    function addAvatar($iProfileId)
    {
        if (!$this->query ("INSERT INTO `" . CH_AVATAR_TABLE_PREFIX . "images` SET `author_id` = '$iProfileId'"))
            return false;
        return $this->lastId();
    }
 
    function deleteAvatarByIdAndOwner ($iId, $iOwner, $isAdmin)
    {
        $sWhere = '';
        if (!$isAdmin)
            $sWhere = " AND `author_id` = '$iOwner' ";
        if (!($iRet = $this->query ("DELETE FROM `" . CH_AVATAR_TABLE_PREFIX . "images` WHERE `id` = $iId $sWhere LIMIT 1")))
            return false;
        return true;
    }
 
    function getSettingsCategory()
    {
        return $this->getOne("SELECT `ID` FROM `sys_options_cats` WHERE `name` = 'Avatar' LIMIT 1");
    }
 
    function suspendProfile($iProfileId)
    {
        return $this->query("UPDATE `Profiles` SET `Status` = 'Approval' WHERE `ID` = $iProfileId AND `Status` = 'Active' LIMIT 1");
    }
}