

подскажите, пожалуйста
assign('is_group', $inUser->group_id)->
public function getComments($only_published=true, $is_tree=false, $from_module = false) { $inUser = cmsUser::getInstance(); global $_LANG; $published = $only_published ? 'c.published = 1' : '1=1'; $sql = "SELECT c.*, u.id as user_id, u.group_id, IFNULL(u.nickname, 0) as nickname, IFNULL(u.login, 0) as login, IFNULL(u.is_deleted, 0) as is_deleted, IFNULL(p.imageurl, 0) as imageurl, IFNULL(p.gender, 0) as gender FROM cms_comments c LEFT JOIN cms_users u ON u.id = c.user_id LEFT JOIN cms_user_profiles p ON p.user_id = u.id WHERE {$published} {$this->inDB->where} {$this->inDB->group_by} {$this->inDB->order_by}\n"; if ($this->inDB->limit){ $sql .= "LIMIT {$this->inDB->limit}"; } $result = $this->inDB->query($sql);
u.id as user_id, u.group_id,
$group_id = $inUser->getGroupIdByUserId($inUser->id);
выводит везде значения = 2
..................... $published = $only_published ? 'c.published = 1' : '1=1'; $sql = "SELECT c.*, g.id AS gid, g.title AS gtitle, g.alias AS galias, IFNULL(u.nickname, 0) as nickname, IFNULL(u.login, 0) as login, IFNULL(u.is_deleted, 0) as is_deleted, IFNULL(p.imageurl, 0) as imageurl, IFNULL(p.gender, 0) as gender FROM cms_comments c LEFT JOIN cms_users u ON u.id = c.user_id LEFT JOIN cms_user_profiles p ON p.user_id = u.id LEFT JOIN cms_user_groups g ON u.group_id = g.id WHERE {$published} {$this->inDB->where} {$this->inDB->group_by} {$this->inDB->order_by}\n"; if ($this->inDB->limit){ $sql .= "LIMIT {$this->inDB->limit}"; } $result = $this->inDB->query($sql); $this->inDB->resetConditions(); while($comment = $this->inDB->fetch_assoc($result)){ ............