1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
<?php
// $Id: avatar.php,v 1.4.6.2.2.1 2005/09/20 00:34:48 skalpa Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <http://www.xoops.org/> //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
// Author: Kazumi Ono (AKA onokazu) //
// URL: http://www.myweb.ne.jp/, http://www.xoops.org/, http://jp.xoops.org/ //
// Project: The XOOPS Project //
// ------------------------------------------------------------------------- //
if (!defined('XOOPS_ROOT_PATH')) {
exit();
}
class XoopsAvatar extends XoopsObject
{
var $_userCount;
function XoopsAvatar()
{
$this->XoopsObject();
$this->initVar('avatar_id', XOBJ_DTYPE_INT, null, false);
$this->initVar('avatar_file', XOBJ_DTYPE_OTHER, null, false, 30);
$this->initVar('avatar_name', XOBJ_DTYPE_TXTBOX, null, true, 100);
$this->initVar('avatar_mimetype', XOBJ_DTYPE_OTHER, null, false);
$this->initVar('avatar_created', XOBJ_DTYPE_INT, null, false);
$this->initVar('avatar_display', XOBJ_DTYPE_INT, 1, false);
$this->initVar('avatar_weight', XOBJ_DTYPE_INT, 0, false);
$this->initVar('avatar_type', XOBJ_DTYPE_OTHER, 0, false);
}
function setUserCount($value)
{
$this->_userCount = intval($value);
}
function getUserCount()
{
return $this->_userCount;
}
}
/**
* XOOPS avatar handler class.
* This class is responsible for providing data access mechanisms to the data source
* of XOOPS avatar class objects.
*
*
* @author Kazumi Ono <onokazu@xoops.org>
*/
class XoopsAvatarHandler extends XoopsPersistableObjectHandler
{
function XoopsAvatarHandler(&$db) {
$this->XoopsPersistableObjectHandler($db, 'avatar', 'XoopsAvatar', 'avatar_id');
}
function addUser($avatar_id, $user_id){
$avatar_id = intval($avatar_id);
$user_id = intval($user_id);
if ($avatar_id < 1 || $user_id < 1) {
return false;
}
$sql = sprintf("DELETE FROM %s WHERE user_id = %u", $this->db->prefix('avatar_user_link'), $user_id);
$this->db->query($sql);
$sql = sprintf("INSERT INTO %s (avatar_id, user_id) VALUES (%u, %u)", $this->db->prefix('avatar_user_link'), $avatar_id, $user_id);
if (!$result =& $this->db->query($sql)) {
return false;
}
return true;
}
function getUser( &$avatar ) {
$ret = array();
if (strtolower(get_class($avatar)) != 'xoopsavatar') {
return $ret;
}
$sql = 'SELECT user_id FROM '.$this->db->prefix('avatar_user_link').' WHERE avatar_id='.$avatar->getVar('avatar_id');
if (!$result = $this->db->query($sql)) {
return $ret;
}
while ($myrow = $this->db->fetchArray($result)) {
$ret[] =& $myrow['user_id'];
}
return $ret;
}
function getList($avatar_type = null, $avatar_display = null)
{
$criteria = new CriteriaCompo();
if (isset($avatar_type)) {
$avatar_type = ($avatar_type == 'C') ? 'C' : 'S';
$criteria->add(new Criteria('avatar_type', $avatar_type));
}
if (isset($avatar_display)) {
$criteria->add(new Criteria('avatar_display', intval($avatar_display)));
}
$avatars =& $this->getObjects($criteria, true);
$ret = array('blank.gif' => _NONE);
foreach (array_keys($avatars) as $i) {
$ret[$avatars[$i]->getVar('avatar_file')] = $avatars[$i]->getVar('avatar_name');
}
return $ret;
}
}
?>
|