/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$this->interactionList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->interactionList->sqlLimit = $this->itemsPerPage;
$this->interactionList->readObjects();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// cache message data
$this->cacheMessageData();
// get messages
$this->messages = $this->readMessages();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
if ($this->avatarCategoryID) {
$sql = "SELECT\tCOUNT(*) AS count\n\t\t\t\tFROM\twcf" . WCF_N . "_avatar\n\t\t\t\tWHERE\tavatarCategoryID = 0 AND userID = 0 AND groupID IN (0," . implode(',', WCF::getUser()->getGroupIDs()) . ") AND neededPoints <= " . intval(WCF::getUser()->activityPoints);
$row = WCF::getDB()->getFirstRow($sql);
$this->hasDefaultAvatars = $row['count'];
} else {
$this->hasDefaultAvatars = $this->items;
}
$this->readAvailableAvatars();
$this->readAvailableCategories();
}
public function readData()
{
parent::readData();
$sql = "SELECT\r\n\t\t\t \t*\r\n\t\t\t\tFROM\r\n\t\t\t \t\t`bash" . BASH_N . "_entry`" . ((BASHCore::getUser()->userID == 0 or !BASHCore::getUser()->isModerator()) ? ' WHERE `isDisabled` = 0 ' : '') . "\r\n\t\t\t\tORDER BY\r\n\t\t\t \tRAND()\r\n\t\t\t LIMIT 10";
$result = WCF::getDB()->sendQuery($sql);
while ($row = WCF::getDB()->fetchArray($result)) {
$this->entries[] = new ViewableBashEntry(null, $row);
}
// init sidebars
$this->sidebarFactory = new MessageSidebarFactory($this);
foreach ($this->entries as $entry) {
$this->sidebarFactory->create($entry);
}
$this->sidebarFactory->init();
}
public function readData()
{
parent::readData();
$sql = "SELECT\r\n\t\t\t \t*\r\n\t\t\t\tFROM\r\n\t\t\t \t\t`bash" . BASH_N . "_news`\r\n\t\t\t\tORDER BY\r\n\t\t\t \t`timestamp` DESC";
$result = WCF::getDB()->sendQuery($sql, $this->itemsPerPage, ($this->pageNo - 1) * $this->itemsPerPage);
while ($row = WCF::getDB()->fetchArray($result)) {
$this->entries[] = new ViewableNewsEntry(null, $row);
}
// init sidebars
$this->sidebarFactory = new MessageSidebarFactory($this);
foreach ($this->entries as $entry) {
$this->sidebarFactory->create($entry);
}
$this->sidebarFactory->init();
}
public function readData()
{
parent::readData();
$sql = "SELECT\r\n\t\t\t \t`bash" . BASH_N . "_entry`.*\r\n\t\t\t\tFROM\r\n\t\t\t \t\t`bash" . BASH_N . "_entry`\r\n\t\t\t \tWHERE\r\n\t\t\t \t\t`bash" . BASH_N . "_entry`.authorID = " . $this->frame->getUserID() . (!BASHCore::getUser()->getPermission('mod.bash.moderatorPermissions') ? ' AND bash' . BASH_N . '_entry.isDisabled = 0' : '') . "\r\n\t\t\t\tORDER BY\r\n\t\t\t \t`bash" . BASH_N . "_entry`.`timestamp` DESC";
$result = WCF::getDB()->sendQuery($sql, $this->itemsPerPage, ($this->pageNo - 1) * $this->itemsPerPage);
while ($row = WCF::getDB()->fetchArray($result)) {
$this->entries[] = new ViewableBashEntry(null, $row);
}
// init sidebars
$this->sidebarFactory = new MessageSidebarFactory($this);
foreach ($this->entries as $entry) {
$this->sidebarFactory->create($entry);
}
$this->sidebarFactory->init();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// get posts
if ($this->items) {
$this->postList->offset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->postList->limit = $this->itemsPerPage;
$this->postList->readPosts();
}
// get marked posts
$sessionVars = WCF::getSession()->getVars();
if (isset($sessionVars['markedPosts'])) {
$this->markedPosts = count($sessionVars['markedPosts']);
}
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$sql = "SELECT\r\n\t\t\t \t*\r\n\t\t\t\tFROM\r\n\t\t\t \t\t`bash" . BASH_N . "_entry`" . (BASHCore::getUser()->isModerator() ? '' : 'WHERE `isDisabled` = 0 ') . "\r\n\t\t\t\tORDER BY\r\n\t\t\t \ttimestamp DESC";
$result = WCF::getDB()->sendQuery($sql, $this->itemsPerPage, ($this->pageNo - 1) * $this->itemsPerPage);
while ($row = WCF::getDB()->fetchArray($result)) {
$this->entries[] = new ViewableBashEntry(null, $row);
}
// init sidebars
$this->sidebarFactory = new MessageSidebarFactory($this);
foreach ($this->entries as $entry) {
$this->sidebarFactory->create($entry);
}
$this->sidebarFactory->init();
}
/**
* @see Form::readData()
*/
public function readData()
{
parent::readData();
// read objects
$this->participantList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->participantList->sqlLimit = $this->itemsPerPage;
$this->participantList->readObjects();
// init todo list
require_once WCF_DIR . 'lib/data/contest/participant/todo/ContestParticipantTodoList.class.php';
$this->todoList = new ContestParticipantTodoList();
$this->todoList->sqlConditions .= 'contest_participant.contestID = ' . intval($this->contestID);
$this->todoList->readObjects();
// init sidebar
$this->sidebar = new ContestSidebar($this->entry, array('participantList', 'advertiseParticipant'));
}
public function readData()
{
parent::readData();
$sql = "SELECT\r\n\t\t\t \t*\r\n\t\t\t\tFROM\r\n\t\t\t \t\t`bash" . BASH_N . "_entry`\r\n\t\t\t \tWHERE\r\n\t\t\t \t\tisDisabled = 1\r\n\t\t\t\tORDER BY\r\n\t\t\t \t`timestamp` DESC\r\n\t\t\t LIMIT 10";
$result = WCF::getDB()->sendQuery($sql);
while ($row = WCF::getDB()->fetchArray($result)) {
$temp = new ViewableBashEntry(null, $row);
// placeholder for additional buttons
$this->entries[] = $temp;
unset($temp);
}
// init sidebars
$this->sidebarFactory = new MessageSidebarFactory($this);
foreach ($this->entries as $entry) {
$this->sidebarFactory->create($entry);
}
$this->sidebarFactory->init();
}
public function readData()
{
parent::readData();
$sql = "SELECT\r\n\t\t\t \t*\r\n\t\t\t\tFROM\r\n\t\t\t \t\t`bash" . BASH_N . "_server_comment`\r\n\t\t\t \tWHERE\r\n\t\t\t \t\tisDisabled = 1\r\n\t\t\t \tORDER BY\r\n\t\t\t \t\t`timestamp` DESC\r\n\t\t\t LIMIT 10";
$result = WCF::getDB()->sendQuery($sql);
while ($row = WCF::getDB()->fetchArray($result)) {
$temp = new ViewableServerComment(null, $row);
WCF::getTPL()->assign('comment', $temp);
$temp->additionalButtons .= WCF::getTPL()->fetchString($this->getScriptingCompiler()->compileString('comment' . $temp->commentID . 'AdditionalButton', '<li><a id="server{@$comment->commentID}" href="index.php?page=ServerDetail&serverID={@$comment->serverID}{@SID_ARG_2ND}" title="' . WCF::getLanguage()->get('bash.moderation.disabledComments.serverButton') . '"><img src="{icon}serverS.png{/icon}" alt="" /> <span>' . WCF::getLanguage()->get('bash.moderation.disabledComments.serverButton') . '</span></a></li>'));
$this->comments[] = $temp;
unset($temp);
}
// init sidebars
$this->sidebarFactory = new MessageSidebarFactory($this);
foreach ($this->comments as $comment) {
$this->sidebarFactory->create($comment);
}
$this->sidebarFactory->init();
}
/**
* @see Page::readData()
*/
public function readData()
{
$this->entry = new UserGuestbookEntry($this->entryID ? $this->entryID : null, array());
$this->entryList = new UserGuestbookEntryList();
$this->userPermissions = UserGuestbookUtil::getUserPermissions($this->frame->getUser());
$this->modPermissions = UserGuestbookUtil::getModeratorPermissions($this->frame->getUser());
$this->entryList->sqlConditions = 'entry.ownerID = ' . $this->frame->getUserID();
if (!USER_GUESTBOOK_SHOW_DELETED_ENTRY_NOTE || !$this->modPermissions['canReadDeletedEntry']) {
$this->entryList->sqlConditions = 'AND entry.isDeleted = 0';
}
$this->entryList->sqlOrderBy = 'entry.time DESC, entry.entryID DESC';
$this->verifyData();
$this->verifyPermissions();
if ($this->entry->entryID) {
$this->calculatePageNo();
}
parent::readData();
$this->entryList->sqlOffset = $this->startIndex - 1;
$this->entryList->sqlLimit = $this->itemsPerPage;
$this->entryList->readObjects();
$this->entryList->readOwners();
$this->entryList->readAuthors();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$ugb = new UserGuestbookData();
$this->ugbData = $ugb->getGuestbookList($this->sortField, $this->sortOrder, $this->pageNo, $this->itemsPerPage);
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// get users online
if (MODULE_USERS_ONLINE && THREAD_ENABLE_ONLINE_LIST) {
$this->renderOnlineList();
}
// get posts
$this->postList->offset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->postList->limit = $this->itemsPerPage;
$this->postList->readPosts();
$this->readSimilarThreads();
// update thread visit
if ($this->thread->isNew() && $this->postList->maxPostTime > $this->thread->lastVisitTime) {
WCF::getUser()->setThreadVisitTime($this->threadID, $this->postList->maxPostTime);
}
// get marked posts
$sessionVars = WCF::getSession()->getVars();
if (isset($sessionVars['markedPosts'])) {
$this->markedPosts = count($sessionVars['markedPosts']);
}
if (isset($sessionVars['markedThreads'])) {
$this->markedThreads = count($sessionVars['markedThreads']);
}
if (isset($sessionVars['quotes'][$this->threadID])) {
foreach ($sessionVars['quotes'][$this->threadID] as $postID => $postQuotes) {
$this->quotes += count($postQuotes);
}
}
// get tags
if (MODULE_TAGGING && THREAD_ENABLE_TAGS) {
$this->readTags();
}
// init sidebars
$this->sidebarFactory = new MessageSidebarFactory($this);
foreach ($this->postList->posts as $post) {
$this->sidebarFactory->create($post);
}
$this->sidebarFactory->init();
// update views
if (!WCF::getSession()->spiderID) {
$this->updateViews();
}
}
/**
* @see Form::readData()
*/
public function readData()
{
parent::readData();
// read objects
$this->sponsortalkList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->sponsortalkList->sqlLimit = $this->itemsPerPage;
$this->sponsortalkList->readObjects();
// init sidebar
$this->sidebar = new ContestSidebar($this->entry);
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
if ($this->classID) {
$class = new ContestClass($this->classID);
$val = WCF::getLanguage()->get($class->description);
if (!empty($val)) {
$this->description[] = $val;
}
}
// read entries
$this->entryList->sqlLimit = $this->itemsPerPage;
$this->entryList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->entryList->readObjects();
// init todo list
require_once WCF_DIR . 'lib/data/contest/crew/todo/ContestCrewTodoList.class.php';
$this->todoList = new ContestCrewTodoList();
$this->todoList->readObjects();
// init sidebar
$this->sidebar = new ContestSidebar();
// read tags
if (MODULE_TAGGING) {
$this->tagList->readObjects();
$this->tags = $this->tagList->getObjects();
}
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// show 5 entries on first page, but 20 on the following pages
$this->eventmixList->sqlLimit = $this->pageNo <= 1 ? $this->itemsOnLandingpage : $this->itemsPerPage;
$this->eventmixList->sqlOffset = $this->pageNo <= 1 ? 0 : ($this->pageNo - 2) * $this->itemsPerPage + $this->itemsOnLandingpage;
// fire sql query
$this->eventmixList->readObjects();
// get previous entry
$sql = "SELECT\t\t*\n\t\t\tFROM\t\twcf" . WCF_N . "_contest\n\t\t\tWHERE\t\tuserID = " . intval($this->entry->userID) . "\n\t\t\t\t\tAND (\n\t\t\t\t\t\ttime > " . intval($this->entry->time) . "\n\t\t\t\t\t\tOR (time = " . intval($this->entry->time) . " AND contestID < " . intval($this->entry->contestID) . ")\n\t\t\t\t\t)\n\t\t\tORDER BY\ttime ASC, contestID DESC";
$this->previousEntry = new Contest(null, WCF::getDB()->getFirstRow($sql));
if (!$this->previousEntry->contestID) {
$this->previousEntry = null;
}
// get next entry
$sql = "SELECT\t\t*\n\t\t\tFROM\t\twcf" . WCF_N . "_contest\n\t\t\tWHERE\t\tuserID = " . intval($this->entry->userID) . "\n\t\t\t\t\tAND (\n\t\t\t\t\t\ttime < " . intval($this->entry->time) . "\n\t\t\t\t\t\tOR (time = " . intval($this->entry->time) . " AND contestID > " . intval($this->entry->contestID) . ")\n\t\t\t\t\t)\n\t\t\tORDER BY\ttime DESC, contestID ASC";
$this->nextEntry = new Contest(null, WCF::getDB()->getFirstRow($sql));
if (!$this->nextEntry->contestID) {
$this->nextEntry = null;
}
// read attachments
if (MODULE_ATTACHMENT == 1 && $this->entry->attachments > 0) {
require_once WCF_DIR . 'lib/data/attachment/MessageAttachmentList.class.php';
$this->attachmentList = new MessageAttachmentList($this->contestID, 'contestEntry', '', WCF::getPackageID('de.easy-coding.wcf.contest'));
$this->attachmentList->readObjects();
$this->attachments = $this->attachmentList->getSortedAttachments(WCF::getUser()->getPermission('user.contest.canViewAttachmentPreview'));
// set embedded attachments
if (WCF::getUser()->getPermission('user.contest.canViewAttachmentPreview')) {
require_once WCF_DIR . 'lib/data/message/bbcode/AttachmentBBCode.class.php';
AttachmentBBCode::setAttachments($this->attachments);
}
// remove embedded attachments from list
if (count($this->attachments) > 0) {
MessageAttachmentList::removeEmbeddedAttachments($this->attachments);
}
}
if ($this->entry->isOwner()) {
// init todo list
require_once WCF_DIR . 'lib/data/contest/owner/todo/ContestOwnerTodoList.class.php';
$this->todoList = new ContestOwnerTodoList();
$this->todoList->sqlConditions .= 'contest.contestID = ' . intval($this->contestID);
$this->todoList->readObjects();
}
// init sidebar
$this->sidebar = new ContestSidebar($this->entry);
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// read pages for the given host
$this->readPages();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// Löschen
if (isset($_REQUEST['action'])) {
if ($_REQUEST['action'] == 'delete' && !empty($_REQUEST['id'])) {
if ($this->user->userID != WCF::getUser()->userID && !WCF::getUser()->getPermission('mod.guestbook.canDeleteEntrys')) {
require_once WCF_DIR . 'lib/system/exception/PermissionDeniedException.class.php';
throw new PermissionDeniedException();
} else {
$userGB = new UserGuestbookData($this->userID);
$userGB->deleteEntry($_REQUEST['id']);
}
} else {
if ($_REQUEST['action'] == 'deleteComment' && !empty($_REQUEST['id'])) {
if ($this->user->userID != WCF::getUser()->userID || !WCF::getUser()->getPermission('user.guestbook.canComment')) {
require_once WCF_DIR . 'lib/system/exception/PermissionDeniedException.class.php';
throw new PermissionDeniedException();
} else {
$userGB = new UserGuestbookData($this->userID);
$userGB->deleteComment($_REQUEST['id']);
}
} else {
if (($_REQUEST['action'] == 'lock' || $_REQUEST['action'] == 'unlock') && !empty($_REQUEST['userID'])) {
if (!WCF::getUser()->getPermission('mod.guestbook.canLock')) {
require_once WCF_DIR . 'lib/system/exception/PermissionDeniedException.class.php';
throw new PermissionDeniedException();
} else {
$userGB = new UserGuestbookData($this->userID);
$userGB->lockEntry($_REQUEST['userID'], $_REQUEST['action']);
}
}
}
}
}
// Statistiken
if ($this->user->userID && WCF::getUser()->userID && (empty($this->pageNo) || $this->pageNo < 2)) {
if ($this->user->userID != WCF::getUser()->userID) {
UserGuestbookData::updateStatsVisitor(WCF::getUser()->userID);
} else {
UserGuestbookData::updateStatsUser();
}
}
$stats = UserGuestbookData::getStats();
$this->cntEntries = $stats['entries'];
$this->cntViews = $stats['views'];
$this->lastVisitor = $stats['lastVisitor'];
$this->visitorLastVisit = $stats['visitorLastVisit'];
// Lade Gästebuchdaten
$userGB = new UserGuestbookData($this->userID);
$this->gbData = $userGB->getEntries($this->pageNo, $this->itemsPerPage);
// Wandle BBCode um und newlines
$bbcode = new MessageParser();
foreach ($this->gbData as $p => $v) {
$this->gbData[$p]['text'] = $bbcode->parse($v['text'], $v['enableSmilies'], $v['enableHtml'], $v['enableBBCodes']);
if (!empty($v['comment'])) {
$this->gbData[$p]['comment'] = $bbcode->parse($v['comment'], $v['enableSmilies'], $v['enableHtml'], $v['enableBBCodes']);
}
// permissions
$editTime = intval(WCF::getUser()->getPermission('user.guestbook.canEditOwnEntries'));
if (WCF::getUser()->getPermission('mod.guestbook.canDeleteEntrys') || $v['userID'] == WCF::getUser()->userID) {
$this->gbData[$p]['permDelete'] = true;
} else {
$this->gbData[$p]['permDelete'] = false;
}
if (WCF::getUser()->getPermission('mod.guestbook.canEditAll') || WCF::getUser()->getPermission('user.guestbook.canEditOwnGuestbook') && $v['userID'] == WCF::getUser()->userID || $editTime != 0 && $v['fromUserID'] == WCF::getUser()->userID && ($editTime == -1 || $v['entryTime'] > TIME_NOW - $editTime)) {
$this->gbData[$p]['permEdit'] = true;
} else {
$this->gbData[$p]['permEdit'] = false;
}
if (WCF::getUser()->getPermission('user.guestbook.canComment') && $v['userID'] == WCF::getUser()->userID) {
$this->gbData[$p]['permComment'] = true;
} else {
$this->gbData[$p]['permComment'] = false;
}
}
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$this->readItems();
}
/**
* @see Form::readData()
*/
public function readData()
{
parent::readData();
// read objects
$this->priceList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->priceList->sqlLimit = $this->itemsPerPage;
$this->priceList->readObjects();
$this->isSponsor = $this->entry->isSponsor();
// init sidebar
$this->sidebar = new ContestSidebar($this->entry, array('priceList', 'advertiseSponsor'));
}
/**
* @see Page::readData();
*/
public function readData()
{
parent::readData();
if ($this->tagObj) {
// get tagged objects
if ($this->taggableID == 0) {
// get objects for overview
$this->taggedObjects = TagEngine::getInstance()->getGroupedTaggedObjectsByTagID($this->tagObj->getID());
} else {
$this->taggedObjects = $this->taggable->getObjectsByTagID($this->tagObj->getID(), $this->itemsPerPage, ($this->pageNo - 1) * $this->itemsPerPage);
}
}
// get tags
$tagCloud = new TagCloud(WCF::getSession()->getVisibleLanguageIDArray());
$this->tags = $tagCloud->getTags($this->tagObj !== null ? 50 : 500);
}
/**
* @see Form::readData()
*/
public function readData()
{
parent::readData();
if ($this->sendPickNotification) {
$this->solutionObj->getEditor()->sendPickNotification();
}
// init todo list
$this->todoList = new ContestParticipantTodoList();
$this->todoList->sqlConditions .= 'contest_participant.contestID = ' . intval($this->contestID);
$this->todoList->readObjects();
// read comments
$this->commentList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->commentList->sqlLimit = $this->itemsPerPage;
$this->commentList->readObjects();
// read ratings
$this->ratingList->readObjects();
// read attachments
if (MODULE_ATTACHMENT == 1 && $this->solutionObj->attachments > 0) {
require_once WCF_DIR . 'lib/data/attachment/MessageAttachmentList.class.php';
$this->attachmentList = new MessageAttachmentList($this->solutionObj->solutionID, 'contestSolutionEntry', '', WCF::getPackageID('de.easy-coding.wcf.contest'));
$this->attachmentList->readObjects();
$this->attachments = $this->attachmentList->getSortedAttachments(WCF::getUser()->getPermission('user.contest.canViewAttachmentPreview'));
// set embedded attachments
if (WCF::getUser()->getPermission('user.contest.canViewAttachmentPreview')) {
require_once WCF_DIR . 'lib/data/message/bbcode/AttachmentBBCode.class.php';
AttachmentBBCode::setAttachments($this->attachments);
}
// remove embedded attachments from list
if (count($this->attachments) > 0) {
MessageAttachmentList::removeEmbeddedAttachments($this->attachments);
}
}
// init sidebar
$this->sidebar = new ContestSidebar($this->entry);
}
/**
* @see Page::readParameters()
*/
public function readData()
{
parent::readData();
$this->readStyles();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$this->am = new AttachmentManager();
$this->attachments = $this->am->getAttachments($this->userID, $this->sortField, $this->sortOrder, $this->itemsPerPage, $this->pageNo, true, $this->showThumbnails, $this->showOnlyImages, $this->showOnlyMessageType, $this->showOnlyFileType);
}
/**
* @see Page::readData()
*/
public function readData()
{
$this->validateSortOrder();
$this->validateSortField();
parent::readData();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$this->readMembers();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$uwp = new UserWantedPosterData();
$this->uwpData = $uwp->readEntries($this->sortField, $this->sortOrder, $this->pageNo, $this->itemsPerPage);
}
