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