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)); } } }