private function checkingModerator()
{
if ($this->status['checkingModerator'] == 1) {
ErrorHelper::getMessageError("Ваш отзыв направлен модератору.");
}
}
private function insertComments()
{
$ip = $_SERVER['REMOTE_ADDR'];
$this->getDataIPStatus($ip);
$queryFeedbacks = "INSERT INTO `Feedbacks` SET ";
$queryFeedbacks .= "`fio` = '" . $this->insertValue['fio'] . "', ";
$queryFeedbacks .= "`title` = " . InputValueHelper::mayByNull($this->insertValue['title']) . ", ";
$queryFeedbacks .= "`text` = '" . $this->insertValue['text'] . "', ";
$queryFeedbacks .= "`email` = " . InputValueHelper::mayByNull($this->insertValue['email']) . ", ";
$queryFeedbacks .= "`phone` = " . InputValueHelper::mayByNull($this->insertValue['phone']) . ", ";
$queryFeedbacks .= "`ip` = '" . $ip . "', ";
$queryFeedbacks .= "`date` = '" . date("Y-m-d h:i:s") . "', ";
$queryFeedbacks .= "`rating` = 'noRating', ";
$queryFeedbacks .= "`show` = '1', ";
$queryFeedbacks .= "`like` = '0', ";
$queryFeedbacks .= "`dislike` = '0' ; ";
$queryListIP = "INSERT INTO `FeedbacksListIP` SET ";
$queryListIP .= "`ip` = '" . $ip . "', ";
$queryListIP .= "`status` = 'default';";
// если статус IP 'blocked'
if ($this->status['status'] == 'blocked') {
return ErrorHelper::getMessageError("Этот IP заблокирован. Вы не можете оставлять отзывы и комментарии ");
}
// проверка существования IP в таблице `FeedbacksListIP`
if (!isset($this->status['ip'])) {
$this->SQL_HELPER->insert($queryListIP);
$this->SQL_HELPER->insert($queryFeedbacks);
$addCom = $this->SQL_HELPER->lastInsertID();
$this->SQL_HELPER->insert($this->queryFeedbacksIsComments($addCom));
} else {
if ($this->status['commentYourself'] == 0 && $this->getDataIP() == $ip) {
ErrorHelper::getMessageError("Вы не можете комментировать свои отзывы");
} else {
$this->SQL_HELPER->insert($queryFeedbacks);
$addCom = $this->SQL_HELPER->lastInsertID();
$this->SQL_HELPER->insert($this->queryFeedbacksIsComments($addCom));
}
}
}
