CAllSocNetLogSmartFilter::GetList

static function GetList($arOrder = array(), $arFilter = array(), $arGroupBy = false, $arNavStartParams = false, $arSelectFields = array())
{
	global $DB;

	if (count($arSelectFields) <= 0)
		$arSelectFields = array("USER_ID", "TYPE");

	// FIELDS -->
	$arFields = array(
		"USER_ID" => Array("FIELD" => "SLSF.USER_ID", "TYPE" => "int"),
		"TYPE" => array("FIELD" => "SLSF.TYPE", "TYPE" => "char")
	);
	// <-- FIELDS

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

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

	$strSql =
		"SELECT ".$arSqls["SELECT"]." ".
		"FROM b_sonet_log_smartfilter SLSF ".
		"	".$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;
}