function r_User($id){

$sql ="SELECT u.nickname
FROM cms_users u
LEFT JOIN cms_comments c ON c.user_id = u.id
LEFT JOIN cms_ratings r ON r.item_id = c.id 
WHERE u.id = $id LIMIT 1";

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

        if (!$this->inDB->num_rows($result)) { return false; }
$commen = $this->inDB->fetch_assoc($result);

return $commen;
}
/*******************************************************************/
function l_User($id){

$sql ="SELECT u.login
FROM cms_users u
LEFT JOIN cms_comments c ON c.user_id = u.id
LEFT JOIN cms_ratings r ON r.item_id = c.id 
WHERE u.id = $id LIMIT 1";

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

        if (!$this->inDB->num_rows($result)) { return false; }
$commen = $this->inDB->fetch_assoc($result);

return $commen;
}
/*****************************************************************/

    public function getRComment($id) {


        $sql = "SELECT c.*,
			 u.nickname as nickname,
			 u.login as login,					
                 r.user_id as ruser,r.points as points,r.pubdate as date
                 FROM cms_comments c
                                LEFT JOIN cms_ratings r ON r.item_id = c.id
				LEFT JOIN cms_users u ON u.id = c.user_id
				LEFT JOIN cms_user_profiles p ON p.user_id = u.id
                         WHERE c.id = r.item_id AND c.target_id=$id";
					

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

        if (!$this->inDB->num_rows($result)) { return false; }

      while($comment = $this->inDB->fetch_assoc($result)){

    $comment['rnick']   = implode($this->r_User($comment['ruser']));
      $comment['rlogin']   = implode($this->l_User($comment['ruser']));
        
         $comments[] = $comment;

}
             return $comments;

    }
