/**
  * @see PostList::initDefaultSQL();
  */
 protected function initDefaultSQL()
 {
     parent::initDefaultSQL();
     $this->sqlSelects .= "thread.topic, thread.prefix, thread.boardID, board.title,";
     $this->sqlJoins .= "\tLEFT JOIN wbb" . WBB_N . "_thread thread ON (thread.threadID = post.threadID)\n\t\t\t\t\tLEFT JOIN wbb" . WBB_N . "_board board ON (board.boardID = thread.boardID)";
     $this->sqlConditionJoins .= "LEFT JOIN wbb" . WBB_N . "_thread thread ON (thread.threadID = post.threadID)";
 }
 /**
  * @see PostList::initDefaultSQL();
  */
 protected function initDefaultSQL()
 {
     parent::initDefaultSQL();
     // default sql conditions
     $this->sqlConditions = "threadID = " . $this->thread->threadID;
     if (!$this->board->getModeratorPermission('canReadDeletedPost') && !THREAD_ENABLE_DELETED_POST_NOTE) {
         $this->sqlConditionVisible .= ' AND isDeleted = 0';
     }
     if (!$this->board->getModeratorPermission('canEnablePost')) {
         $this->sqlConditionVisible .= ' AND isDisabled = 0';
     }
     $this->sqlConditions .= $this->sqlConditionVisible;
 }
 private function openPostManager()
 {
     $list = new PostList();
     $data = array('posts' => $list->getPosts());
     $this->loadView('cm_posts', $data);
 }
 public function getBaiViet($catid, $count)
 {
     $postList = new PostList();
     $c = 0;
     foreach ($this->postList as $k => $v) {
         if ($v->getIdLoai() == $catid) {
             if ($v->getAnHien() == 1 || $v->getAnHien() == '1') {
                 $postList->addPost($v);
                 if ($c > $count - 1) {
                     break;
                 }
                 $c++;
             }
         }
     }
     return $postList;
 }
 /**
  * @see Action::execute()
  */
 public function execute()
 {
     parent::execute();
     // add edit note
     $postData = array();
     if (!$this->board->getPermission('canHideEditNote') && (WCF::getUser()->userID != $this->post->userID || $this->post->time <= TIME_NOW - POST_EDIT_HIDE_EDIT_NOTE_PERIOD * 60)) {
         $postData['editor'] = WCF::getUser()->username;
         $postData['editorID'] = WCF::getUser()->userID;
         $postData['lastEditTime'] = TIME_NOW;
         $postData['editCount'] = $this->post->editCount + 1;
         $postData['editReason'] = '';
     }
     // update message
     $this->post->updateMessage($this->text, $postData);
     if ($this->thread->firstPostID == $this->post->postID) {
         // update first post preview
         $this->post->updateFirstPostPreview($this->post->threadID, $this->post->postID, $this->text, array('enableSmilies' => $this->post->enableSmilies, 'enableHtml' => $this->post->enableHtml, 'enableBBCodes' => $this->post->enableBBCodes));
     }
     $this->executed();
     // get new formatted message and return it
     $postList = new PostList();
     $postList->sqlConditions = 'post.postID = ' . $this->postID;
     $postList->readPosts();
     $post = reset($postList->posts);
     HeaderUtil::sendHeaders();
     echo $post->getFormattedMessage();
 }
Example #6
0
 public function getTopPopularRead($count, $idLoai = null)
 {
     $sql = "SELECT * FROM `mk_post`";
     if ($idLoai) {
         $sql .= " WHERE `idLoai`=" . $idLoai . " AND `AnHien` = 1";
     } else {
         $sql .= "WHERE `AnHien` = 1";
     }
     $sql .= "  ORDER BY `SoLanXem` DESC LIMIT 0," . $count;
     $this->load->database();
     $query = $this->db->query($sql);
     $result = $query->result_array();
     $postList = new PostList();
     foreach ($result as $k => $v) {
         $post = new PostClass();
         $post->setIdPO($v['idPO']);
         $post->setIdCL($v['idCL']);
         $post->setIdLoai($v['idLoai']);
         $post->setIdSub($v['idSub']);
         $post->setTieuDe($v['TieuDe']);
         $post->setTieuDeKD($v['TieuDeKD']);
         $post->setTitle($v['Title']);
         $post->setDes($v['Des']);
         $post->setKeyword($v['Keyword']);
         $post->setTomTat($v['TomTat']);
         $post->setNoiDung($v['NoiDung']);
         $post->setUrlHinh($v['UrlHinh']);
         $post->setNgayDang($v['NgayDang']);
         $post->setAnHien($v['AnHien']);
         $post->setNoiBat($v['NoiBat']);
         $post->setSoLanXem($v['SoLanXem']);
         $post->setIdGroup($v['idGroup']);
         $postList->addPost($post);
     }
     $this->db->close();
     return $postList;
 }