CIMMessenger::GetSonetCode

function GetSonetCode($user_id, $site_id = SITE_ID)
{
	global $DB;
	$result = array();
	$user_id = intval($user_id);

	if($user_id > 0 && IsModuleInstalled('socialnetwork'))
	{
		$strSQL = "
			SELECT CODE, SUM(CNT) CNT
			FROM b_sonet_log_counter
			WHERE USER_ID = ".$user_id."
			AND (SITE_ID = '".$site_id."' OR SITE_ID = '**')
			GROUP BY CODE
		";
		$dbRes = $DB->Query($strSQL, true, "File: ".__FILE__."
Line: ".__LINE__);
		while ($arRes = $dbRes->Fetch())
			$result[$arRes["CODE"]] = $arRes["CNT"];
	}

	return $result;
}