/** * @see PostList::initDefaultSQL(); */ protected function initDefaultSQL() { parent::initDefaultSQL(); // default selects / joins $this->sqlSelects = "user_option.*, wbb_user.*, user.*, rank.*, IFNULL(user.username, post.username) AS username,"; $this->sqlJoins = "\tLEFT JOIN \twcf" . WCF_N . "_user user\n\t\t\t\t\tON \t\t(user.userID = post.userID)\n\t\t\t\t\tLEFT JOIN \twbb" . WBB_N . "_user wbb_user \n\t\t\t\t\tON \t\t(wbb_user.userID = post.userID)\n\t\t\t\t\tLEFT JOIN \twcf" . WCF_N . "_user_option_value user_option\n\t\t\t\t\tON\t\t(user_option.userID = post.userID)\n\t\t\t\t\tLEFT JOIN \twcf" . WCF_N . "_user_rank rank\n\t\t\t\t\tON\t\t(rank.rankID = user.rankID)"; if (MESSAGE_SIDEBAR_ENABLE_AVATAR) { $this->sqlSelects .= 'avatar.avatarID, avatar.avatarExtension, avatar.width, avatar.height,'; $this->sqlJoins .= ' LEFT JOIN wcf' . WCF_N . '_avatar avatar ON (avatar.avatarID = user.avatarID) '; } }
/** * @see ThreadPostList::initDefaultSQL() */ protected function initDefaultSQL() { parent::initDefaultSQL(); if (!$this->board->getModeratorPermission('canReadDeletedPost') && THREAD_ENABLE_DELETED_POST_NOTE) { $this->sqlConditionVisible .= ' AND isDeleted = 0'; $this->sqlConditions .= ' AND isDeleted = 0'; } // default selects / joins $this->sqlSelects = "user.*, IFNULL(user.username, post.username) AS username,"; $this->sqlJoins = "\tLEFT JOIN \twcf" . WCF_N . "_user user\n\t\t\t\t\tON \t\t(user.userID = post.userID)"; $this->sqlSelects .= 'avatar.avatarID, avatar.avatarExtension, avatar.width, avatar.height,'; $this->sqlJoins .= ' LEFT JOIN wcf' . WCF_N . '_avatar avatar ON (avatar.avatarID = user.avatarID) '; }