CSocNetLogPages::GetList

static function GetList($arOrder = array(), $arFilter = array(), $arGroupBy = false, $arNavStartParams = false, $arSelectFields = array())
{
	if (func_num_args() <= 2)
	{
		$arSelectFields = $arFilter;
		$arFilter = $arOrder;
		$arOrder = array();
	}

	global $DB;

	if (count($arSelectFields) <= 0)
	{
		$arSelectFields = array("USER_ID", "SITE_ID", "GROUP_CODE", "PAGE_SIZE", "PAGE_NUM", "PAGE_LAST_DATE", "TRAFFIC_AVG", "TRAFFIC_CNT", "TRAFFIC_LAST_DATE");
	}

	// FIELDS -->
	$arFields = array(
		"USER_ID" => Array("FIELD" => "SLP.USER_ID", "TYPE" => "int"),
		"SITE_ID" => Array("FIELD" => "SLP.SITE_ID", "TYPE" => "string"),
		"GROUP_CODE" => Array("FIELD" => "SLP.GROUP_CODE", "TYPE" => "string"),
		"PAGE_SIZE" => array("FIELD" => "SLP.PAGE_SIZE", "TYPE" => "int"),
		"PAGE_NUM" => array("FIELD" => "SLP.PAGE_NUM", "TYPE" => "int"),
		"PAGE_LAST_DATE" => Array("FIELD" => "SLP.PAGE_LAST_DATE", "TYPE" => "datetime"),
		"TRAFFIC_AVG" => array("FIELD" => "SLP.TRAFFIC_AVG", "TYPE" => "int"),
		"TRAFFIC_CNT" => array("FIELD" => "SLP.TRAFFIC_CNT", "TYPE" => "int"),
		"TRAFFIC_LAST_DATE" => Array("FIELD" => "SLP.TRAFFIC_LAST_DATE", "TYPE" => "datetime"),
	);
	// <-- FIELDS

	$arSqls = CSocNetGroup::PrepareSql($arFields, $arOrder, $arFilter, false, $arSelectFields);

	$arSqls["SELECT"] = str_replace("%%_DISTINCT_%%", "", $arSqls["SELECT"]);

	$strSql =
		"SELECT ".$arSqls["SELECT"]." ".
		"FROM b_sonet_log_page SLP ".
		"	".$arSqls["FROM"]." ";
	if ($arSqls["WHERE"] <> '')
	{
		$strSql .= "WHERE ".$arSqls["WHERE"]." ";
	}
	if ($arSqls["ORDERBY"] <> '')
	{
		$strSql .= "ORDER BY ".$arSqls["ORDERBY"]." ";
	}

	$dbRes = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);

	return $dbRes;
}