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