function Reset($ID)
{
global $DB;
$err_mess = CVoteQuestion::err_mess() . "<br>Function: Reset<br>Line: ";
$ID = intval($ID);
// удаляем вопросы при анкетировании
$DB->Query("DELETE FROM b_vote_event_question WHERE QUESTION_ID='{$ID}'", false, $err_mess . __LINE__);
// обнуляем счетчик у вопроса
$arFields = array("COUNTER" => "0");
$DB->Update("b_vote_question", $arFields, "WHERE ID='{$ID}'", $err_mess . __LINE__);
// обнуляем счетчики у ответов
$arFields = array("COUNTER" => "0");
$DB->Update("b_vote_answer", $arFields, "WHERE QUESTION_ID='{$ID}'", $err_mess . __LINE__);
}
public static function Reset($ID, $VOTE_ID = false)
{
global $DB;
$err_mess = CVoteQuestion::err_mess() . "<br>Function: Reset<br>Line: ";
$ID = intVal($ID) > 0 ? intVal($ID) : false;
$VOTE_ID = intVal($VOTE_ID) > 0 ? intVal($VOTE_ID) : false;
if ($ID > 0) {
$strSqlID = "" . $ID . "";
} elseif ($VOTE_ID > 0) {
$strSqlID = "SELECT Q.ID FROM b_vote_question Q WHERE Q.VOTE_ID=" . $VOTE_ID;
} else {
return false;
}
// drop answer events
$DB->Query("DELETE FROM b_vote_event_answer WHERE EVENT_QUESTION_ID IN (\n\t\t\tSELECT ID FROM b_vote_event_question WHERE QUESTION_ID IN (" . $strSqlID . "))", false, $err_mess . __LINE__);
// drop question events
$DB->Query("DELETE FROM b_vote_event_question WHERE QUESTION_ID IN (" . $strSqlID . ")", false, $err_mess . __LINE__);
// zeroize answers counter
$arFields = array("COUNTER" => "0");
$DB->Update("b_vote_answer", $arFields, "WHERE QUESTION_ID IN (" . $strSqlID . ")", $err_mess . __LINE__);
// zeroize questions counter
$arFields = array("COUNTER" => "0");
$DB->Update("b_vote_question", $arFields, "WHERE " . ($ID > 0 ? "ID = " . $ID . "" : "VOTE_ID = " . $VOTE_ID . ""), $err_mess . __LINE__);
/***************** Cleaning cache **********************************/
if ($ID === false) {
unset($GLOBALS["VOTE_CACHE"]["QUESTION"]);
} else {
unset($GLOBALS["VOTE_CACHE"]["QUESTION"][$ID]);
}
/***************** Cleaning cache/**********************************/
return true;
}
