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