/** * * @param object $criteria * @param boolean $id_as_key * @return array */ public function &getObjects($criteria = null, $id_as_key = false) { $ret = array(); $limit = $start = 0; $sql = "SELECT a.*, COUNT(u.user_id) AS count FROM " . $this->db->prefix('avatar') . " a LEFT JOIN " . $this->db->prefix('avatar_user_link') . " u ON u.avatar_id=a.avatar_id"; if (isset($criteria) && is_subclass_of($criteria, 'icms_db_criteria_Element')) { $sql .= " " . $criteria->renderWhere(); $sql .= " GROUP BY a.avatar_id ORDER BY avatar_weight, avatar_id"; $limit = $criteria->getLimit(); $start = $criteria->getStart(); } $result = $this->db->query($sql, $limit, $start); if (!$result) { return $ret; } while ($myrow = $this->db->fetchArray($result)) { $avatar = new icms_data_avatar_Object(); $avatar->assignVars($myrow); $avatar->setUserCount($myrow['count']); if (!$id_as_key) { $ret[] =& $avatar; } else { $ret[$myrow['avatar_id']] =& $avatar; } unset($avatar); } return $ret; }
public function __construct() { parent::__construct(); $this->_deprecated = icms_core_Debug::setDeprecated('icms_data_avatar_Object', sprintf(_CORE_REMOVE_IN_VERSION, '1.4')); }