/** * @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(); }
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; }