CAllTestAttempt::RecountQuestions

static function RecountQuestions($ATTEMPT_ID)
{
	global $DB;

	$ATTEMPT_ID = intval($ATTEMPT_ID);

	if ($ATTEMPT_ID < 1)
		return false;

	$strSql = "SELECT COUNT(*) CNT, SUM(TR.POINT) CNT_SUM, SUM(Q.POINT) MAX_POINT ".
				"FROM b_learn_test_result TR ".
				"INNER JOIN b_learn_question Q ON TR.QUESTION_ID = Q.ID ".
				"WHERE TR.ATTEMPT_ID = ".$ATTEMPT_ID;
	$res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
	if (!$ar = $res->Fetch())
		return false;

	$strSql = "UPDATE b_learn_attempt SET QUESTIONS = '".intval($ar["CNT"])."', SCORE = '".intval($ar["CNT_SUM"])."', MAX_SCORE = '".intval($ar["MAX_POINT"])."' WHERE ID = ".$ATTEMPT_ID;
	if (!$DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__))
		return false;

	return true;
}