/**
* @see PostList::readPosts()
*/
public function readPosts()
{
parent::readPosts();
// calculate max post time
foreach ($this->posts as $post) {
if ($post->time > $this->maxPostTime) {
$this->maxPostTime = $post->time;
}
}
}
/**
* @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) ';
}