CIMMessage::GetMessage

public function GetMessage($id, $files = false)
{
	global $DB;

	$id = intval($id);

	$query = "SELECT 
				M.*, ".$DB->DatetimeToTimestampFunction('M.DATE_CREATE')." DATE_CREATE, 
				R.MESSAGE_TYPE,
				C.TITLE CHAT_TITLE, C.COLOR CHAT_COLOR, C.AVATAR CHAT_AVATAR 
			FROM 
				b_im_message M
				INNER JOIN b_im_relation R ON R.CHAT_ID = M.CHAT_ID AND R.USER_ID = ".$this->user_id."
				INNER JOIN b_im_chat C ON C.ID = M.CHAT_ID
			WHERE 
				M.ID = ".$id."";

	$result = $DB->Query($query, false, "File: ".__FILE__."
Line: ".__LINE__);
	$message = $result->Fetch();

	if (!$message)
		return false;

	if ($files)
	{
		$files = CIMMessageParam::Get($id, 'FILE_ID');
		$message['FILES'] = CIMDisk::GetFiles($message['CHAT_ID'], $files, false);
	}

	return $message;
}