CTicket::GetOnline

static function GetOnline($ticketID)
{
	$err_mess = (CTicket::err_mess())."
Function: GetOnline
Line: ";
	global $DB;
	$ticketID = intval($ticketID);
	$onlineInterval = intval(COption::GetOptionString("support", "ONLINE_INTERVAL"));
	$strSql = "
		SELECT
			".$DB->DateToCharFunction("max(T.TIMESTAMP_X)")."		TIMESTAMP_X,
			T.USER_ID,
			T.CURRENT_MODE,
			U.EMAIL													USER_EMAIL,
			U.LOGIN													USER_LOGIN,
			concat(ifnull(U.NAME,''),' ',ifnull(U.LAST_NAME,''))	USER_NAME
		FROM
			b_ticket_online T,
			b_user U
		WHERE
			T.TICKET_ID = $ticketID
		and T.TIMESTAMP_X >= DATE_ADD(now(), INTERVAL - $onlineInterval SECOND)
		and U.ID = T.USER_ID
		GROUP BY
			T.USER_ID, U.EMAIL, U.LOGIN, U.NAME, U.LAST_NAME
		ORDER BY
			T.USER_ID
		";

	$z = $DB->Query($strSql, false, $err_mess.__LINE__);
	return $z;
}