CAllFormResult::GetFileByHash

static function GetFileByHash($RESULT_ID, $HASH)
{
	global $DB, $APPLICATION, $strError, $USER;

	$err_mess = (CAllFormResult::err_mess())."
Function: GetAnswerFile
Line: ";

	$RESULT_ID = intval($RESULT_ID);
	if ($RESULT_ID<=0 || trim($HASH) == '') return;

	$strSql = "
SELECT
F.ID as FILE_ID,
F.FILE_NAME,
F.SUBDIR,
F.CONTENT_TYPE,
F.HANDLER_ID,
F.FILE_SIZE,
RA.USER_FILE_NAME ORIGINAL_NAME,
RA.USER_FILE_IS_IMAGE,
RA.FORM_ID, R.USER_ID
FROM b_form_result R
LEFT JOIN b_form_result_answer RA ON RA.RESULT_ID=R.ID
INNER JOIN b_file F ON (F.ID = RA.USER_FILE_ID)
WHERE R.ID = '".$RESULT_ID."'
AND RA.USER_FILE_HASH = '".$DB->ForSql($HASH, 255)."'
";

	$z = $DB->Query($strSql, false, $err_mess.__LINE__);
	if ($zr = $z->Fetch())
	{
		$F_RIGHT = CForm::GetPermission($zr['FORM_ID']);
		if ($F_RIGHT >= 20 || ($F_RIGHT >= 15 && $USER->GetID() == $zr['USER_ID']))
		{
			unset($zr['FORM_ID']); unset($zr['USER_ID']);
			return $zr;
		}
		else
		{
			return false;
		}
	}
	else
	{
		return false;
	}
}