示例#1
0
 public function read()
 {
     // Adding JavaScript file for Ajax Comment
     $this->design->addJs(PH7_LAYOUT . PH7_SYS . PH7_MOD . $this->registry->module . PH7_SH . PH7_TPL . PH7_TPL_MOD_NAME . PH7_SH . PH7_JS, 'comment.js');
     $this->sTitle = t('Read Comment');
     $this->view->page_title = $this->sTitle;
     $this->view->meta_description = $this->sTitle;
     $this->view->h1_title = $this->sTitle;
     $this->view->h4_title = CommentCore::count($this->iId, $this->sTable);
     $oPage = new Page();
     $this->view->total_pages = $oPage->getTotalPages($this->oCommentModel->total($this->iId, $this->sTable), 15);
     $this->view->current_page = $oPage->getCurrentPage();
     $oComment = $this->oCommentModel->read($this->iId, 1, $oPage->getFirstItem(), $oPage->getNbItemsByPage(), $this->sTable);
     unset($oPage);
     if (!empty($oComment)) {
         $this->view->avatarDesign = new AvatarDesignCore();
         // Avatar Design Class
         $this->view->member_id = $this->session->get('member_id');
         $this->view->csrf_token = (new Framework\Security\CSRF\Token())->generate('comment');
         $this->view->comment = $oComment;
     } else {
         $this->_notFound();
     }
     $this->output();
 }
示例#2
0
 /**
  * Delete a comment.
  *
  * @param integer $iRecipientId The Comment Recipient ID.
  * @param string $sTable The Comment Table.
  * @return boolean Returns TRUE on success, FALSE on failure.
  */
 public static function deleteRecipient($iRecipientId, $sTable)
 {
     $sTable = CommentCore::checkTable($sTable);
     $iRecipientId = (int) $iRecipientId;
     $rStmt = Db::getInstance()->prepare('DELETE FROM' . Db::prefix('Comments' . $sTable) . 'WHERE recipient = :recipient');
     $rStmt->bindValue(':recipient', $iRecipientId, \PDO::PARAM_INT);
     return $rStmt->execute();
 }
示例#3
0
 /**
  * To prevent spam!
  *
  * @param integer $iSenderId
  * @param integer $iWaitTime In minutes!
  * @param string $sCurrentTime In date format: 0000-00-00 00:00:00
  * @param string $sTable
  * @return boolean Return TRUE if the weather was fine, otherwise FALSE
  */
 public function checkWaitSend($iSenderId, $iWaitTime, $sCurrentTime, $sTable)
 {
     $sTable = CommentCore::checkTable($sTable);
     $rStmt = Db::getInstance()->prepare('SELECT commentId FROM' . Db::prefix('Comments' . $sTable) . 'WHERE sender = :sender AND DATE_ADD(createdDate, INTERVAL :waitTime MINUTE) > :currentTime LIMIT 1');
     $rStmt->bindValue(':sender', $iSenderId, \PDO::PARAM_INT);
     $rStmt->bindValue(':waitTime', $iWaitTime, \PDO::PARAM_INT);
     $rStmt->bindValue(':currentTime', $sCurrentTime, \PDO::PARAM_STR);
     $rStmt->execute();
     return $rStmt->rowCount() === 0;
 }
 protected function totalComments($sTable, $iDay = 0)
 {
     CommentCore::checkTable($sTable);
     $iDay = (int) $iDay;
     $sSqlDay = $iDay > 0 ? ' WHERE (createdDate + INTERVAL ' . $iDay . ' DAY) > NOW()' : '';
     $rStmt = Db::getInstance()->prepare('SELECT COUNT(commentId) AS totalComments FROM' . Db::prefix('Comments' . $sTable) . $sSqlDay);
     $rStmt->execute();
     $oRow = $rStmt->fetch(\PDO::FETCH_OBJ);
     return (int) $oRow->totalComments;
 }