CRatingsComponentsForum::CalcUserVoteForumPost

static function CalcUserVoteForumPost($arConfigs)
{
	global $DB;

	$err_mess = (CRatings::err_mess())."
Function: CalcUserVoteForumTopic
Line: ";

	CRatings::AddComponentResults($arConfigs);

	$strSql = "DELETE FROM b_rating_component_results WHERE RATING_ID = '".intval($arConfigs['RATING_ID'])."' AND COMPLEX_NAME = '".$DB->ForSql($arConfigs['COMPLEX_NAME'])."'";
	$res = $DB->Query($strSql, false, $err_mess.__LINE__);

	$strSql = "INSERT INTO b_rating_component_results (RATING_ID, MODULE_ID, RATING_TYPE, NAME, COMPLEX_NAME, ENTITY_ID, ENTITY_TYPE_ID, CURRENT_VALUE)
				SELECT
					'".intval($arConfigs['RATING_ID'])."'  RATING_ID,
					'".$DB->ForSql($arConfigs['MODULE_ID'])."'  MODULE_ID,
					'".$DB->ForSql($arConfigs['RATING_TYPE'])."'  RATING_TYPE,
					'".$DB->ForSql($arConfigs['NAME'])."'  NAME,
					'".$DB->ForSql($arConfigs['COMPLEX_NAME'])."'  COMPLEX_NAME,
					FM.AUTHOR_ID as ENTITY_ID,
					'".$DB->ForSql($arConfigs['ENTITY_ID'])."'  ENTITY_TYPE_ID,
					SUM(RVE.VALUE)*".floatval($arConfigs['CONFIG']['COEFFICIENT'])."  CURRENT_VALUE
				FROM
					b_rating_voting RV LEFT JOIN b_forum_message FM ON RV.ENTITY_ID = FM.ID,
					b_rating_vote RVE
				WHERE
					RV.ENTITY_TYPE_ID = 'FORUM_POST' AND FM.AUTHOR_ID > 0
				AND RVE.RATING_VOTING_ID = RV.ID".(intval($arConfigs['CONFIG']['LIMIT']) > 0 ? " AND RVE.CREATED > DATE_SUB(NOW(), INTERVAL ".intval($arConfigs['CONFIG']['LIMIT'])." DAY)" : "")."
				GROUP BY AUTHOR_ID";

	$res = $DB->Query($strSql, false, $err_mess.__LINE__);

	return true;
}