public function UpdateEditCommentData(ModuleComment_EntityComment $oComment) { $sql = "UPDATE " . Config::Get('db.table.comment') . "\r\n SET\r\n comment_edit_count= ?d,\r\n comment_edit_date=?\r\n WHERE\r\n comment_id = ?d\r\n "; if ($this->oDb->query($sql, $oComment->getEditCount(), $oComment->getEditDate(), $oComment->getId()) !== false) { return true; } return false; }
/** * Обновляет коммент * * @param ModuleComment_EntityComment $oComment Объект комментария * @return bool */ public function UpdateComment(ModuleComment_EntityComment $oComment) { $sql = "UPDATE " . Config::Get('db.table.comment') . "\n\t\t\tSET \n\t\t\t\tcomment_text= ?,\n\t\t\t\tcomment_text_source= ?,\n\t\t\t\tcomment_rating= ?f,\n\t\t\t\tcomment_count_vote= ?d,\n\t\t\t\tcomment_count_favourite= ?d,\n\t\t\t\tcomment_count_edit= ?d,\n\t\t\t\tcomment_date_edit= ?,\n\t\t\t\tcomment_delete = ?d ,\n\t\t\t\tcomment_publish = ?d ,\n\t\t\t\tcomment_text_hash = ?\n\t\t\tWHERE\n\t\t\t\tcomment_id = ?d\n\t\t"; $res = $this->oDb->query($sql, $oComment->getText(), $oComment->getTextSource(), $oComment->getRating(), $oComment->getCountVote(), $oComment->getCountFavourite(), $oComment->getCountEdit(), $oComment->getDateEdit(), $oComment->getDelete(), $oComment->getPublish(), $oComment->getTextHash(), $oComment->getId()); return $this->IsSuccessful($res); }
public function UpdateComment(ModuleComment_EntityComment $oComment) { $sql = "UPDATE " . Config::Get('db.table.comment') . " \n\t\t\tSET \n\t\t\t\tcomment_text= ?,\n\t\t\t\tcomment_rating= ?f,\n\t\t\t\tcomment_count_vote= ?d,\n\t\t\t\tcomment_delete = ?d ,\n\t\t\t\tcomment_publish = ?d ,\n\t\t\t\tcomment_text_hash = ?\n\t\t\tWHERE\n\t\t\t\tcomment_id = ?d\n\t\t"; if ($this->oDb->query($sql, $oComment->getText(), $oComment->getRating(), $oComment->getCountVote(), $oComment->getDelete(), $oComment->getPublish(), $oComment->getTextHash(), $oComment->getId())) { return true; } return false; }
/** * Проверяет может ли пользователь голосовать за конкретный комментарий * * @param ModuleUser_EntityUser $oUser Пользователь * @param ModuleComment_EntityComment $oComment Комментарий * @return bool */ public function CanVoteComment($oUser, $oComment) { $that = $this; // fix for PHP < 5.4 return $this->Rbac_IsAllowUser($oUser, 'vote_comment', array('callback' => function ($oUser, $aParams) use($that, $oComment) { if (!$oUser) { return false; } /** * Голосует автор комментария? */ if ($oComment->getUserId() == $oUser->getId()) { return $that->Lang_Get('vote.notices.error_self'); } /** * Пользователь уже голосовал? */ if ($oTopicCommentVote = $that->Vote_GetVote($oComment->getId(), 'comment', $oUser->getId())) { return $that->Lang_Get('vote.notices.error_already_voted'); } /** * Ограничение по рейтингу */ if ($oUser->getRating() < Config::Get('acl.vote.comment.rating')) { return $that->Lang_Get('vote.notices.error_acl'); } /** * Время голосования истекло? */ if (strtotime($oComment->getDate()) <= time() - Config::Get('acl.vote.comment.limit_time')) { return $that->Lang_Get('vote.notices.error_time'); } return true; })); }
/** * Обновляет коммент * * @param ModuleComment_EntityComment $oComment Объект комментария * * @return bool */ public function UpdateComment(ModuleComment_EntityComment $oComment) { $sql = "UPDATE ?_comment\n\t\t\tSET \n\t\t\t\tcomment_text= ?,\n\t\t\t\tcomment_rating= ?f,\n\t\t\t\tcomment_count_vote= ?d,\n\t\t\t\tcomment_count_favourite= ?d,\n\t\t\t\tcomment_delete = ?d ,\n\t\t\t\tcomment_publish = ?d ,\n\t\t\t\tcomment_date_edit = CASE comment_text_hash WHEN ? THEN comment_date_edit ELSE ? END,\n\t\t\t\tcomment_text_hash = ?\n\t\t\tWHERE\n\t\t\t\tcomment_id = ?d\n\t\t"; $bResult = $this->oDb->query($sql, $oComment->getText(), $oComment->getRating(), $oComment->getCountVote(), $oComment->getCountFavourite(), $oComment->getDelete(), $oComment->getPublish(), $oComment->getTextHash(), F::Now(), $oComment->getTextHash(), $oComment->getId()); return $bResult !== false; }