CAllUser::GetUserGroupEx

static function GetUserGroupEx($ID)
{
	global $DB;

	$strSql = "
		SELECT UG.GROUP_ID, G.STRING_ID,
			" . $DB->DateToCharFunction("UG.DATE_ACTIVE_FROM") . " as DATE_ACTIVE_FROM,
			" . $DB->DateToCharFunction("UG.DATE_ACTIVE_TO") . " as DATE_ACTIVE_TO
		FROM b_user_group UG INNER JOIN b_group G ON G.ID=UG.GROUP_ID
		WHERE UG.USER_ID = " . intval($ID) . "
			and ((UG.DATE_ACTIVE_FROM IS NULL) OR (UG.DATE_ACTIVE_FROM <= " . $DB->CurrentTimeFunction() . "))
			and ((UG.DATE_ACTIVE_TO IS NULL) OR (UG.DATE_ACTIVE_TO >= " . $DB->CurrentTimeFunction() . "))
			and G.ACTIVE = 'Y'
		UNION SELECT 2, 'everyone', NULL, NULL ";

	$res = $DB->Query($strSql);

	return $res;
}