/**
* @see Page::readData()
*/
public function readData()
{
$functionName = 'read' . ucfirst($this->activeTabMenuItem);
if (method_exists($this, $functionName)) {
$this->{$functionName}();
}
parent::readData();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$this->entryList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->entryList->sqlLimit = $this->itemsPerPage;
$this->entryList->sqlOrderBy = $this->sortField . " " . $this->sortOrder;
$this->entryList->readObjects();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// read objects
$this->sessionLogList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->sessionLogList->sqlLimit = $this->itemsPerPage;
$this->sessionLogList->sqlOrderBy = ($this->sortField != 'accesses' && $this->sortField != 'username' ? 'session_log.' : '') . $this->sortField . " " . $this->sortOrder;
$this->sessionLogList->readObjects();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// read objects
$this->avatarList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->avatarList->sqlLimit = $this->itemsPerPage;
$this->avatarList->sqlOrderBy = ($this->sortField != 'avatarCategoryTitle' && $this->sortField != 'username' && $this->sortField != 'groupName' ? 'avatar.' : '') . $this->sortField . " " . $this->sortOrder;
$this->avatarList->readObjects();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// read objects
$this->ruleList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->ruleList->sqlLimit = $this->itemsPerPage;
$this->ruleList->sqlOrderBy = ($this->sortField != 'conditions' ? 'pm_rule.' : '') . $this->sortField . " " . $this->sortOrder;
$this->ruleList->readObjects();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// read objects
$this->userOptionCategoryList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->userOptionCategoryList->sqlLimit = $this->itemsPerPage;
$this->userOptionCategoryList->sqlOrderBy = ($this->sortField != 'options' ? 'option_category.' : '') . $this->sortField . " " . $this->sortOrder;
$this->userOptionCategoryList->readObjects();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$this->readGroups();
if (!count($this->groups)) {
throw new PermissionDeniedException();
}
$this->readApplications();
WCF::getSession()->unregister('outstandingGroupApplications');
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// get threads
if ($this->items) {
$this->threadList->limit = $this->itemsPerPage;
$this->threadList->offset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->threadList->sqlOrderBy = $this->sortField . " " . $this->sortOrder . ($this->sortField == 'ratingResult' ? ", ratings " . $this->sortOrder : '') . ($this->sortField != 'lastPostTime' ? ", lastPostTime DESC" : '');
$this->threadList->readThreads();
}
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$sql = "SELECT * FROM wcf" . WCF_N . "_admin_tools_spider\n\t\t\t\tORDER BY " . $this->sortField . " " . $this->sortOrder;
$result = WCF::getDB()->sendQuery($sql, $this->itemsPerPage, ($this->pageNo - 1) * $this->itemsPerPage);
while ($row = WCF::getDB()->fetchArray($result)) {
$this->spiders[] = new Spider(null, $row);
}
// build page url
$this->url = 'index.php?page=AdminToolsSpiderList&pageNo=' . $this->pageNo . '&sortField=' . $this->sortField . '&sortOrder=' . $this->sortOrder . '&packageID=' . PACKAGE_ID . SID_ARG_2ND_NOT_ENCODED;
}
/**
* @see Page::assignVariables()
*/
public function readData()
{
parent::readData();
if ($this->items) {
$sql = "SELECT\t\tcontest_interaction_ruleset.*\n\t\t\t\tFROM\t\twcf" . WCF_N . "_contest_interaction_ruleset contest_interaction_ruleset\n\t\t\t\tORDER BY\t" . $this->sortField . " " . $this->sortOrder;
$result = WCF::getDB()->sendQuery($sql, $this->itemsPerPage, ($this->pageNo - 1) * $this->itemsPerPage);
while ($row = WCF::getDB()->fetchArray($result)) {
$row['deletable'] = WCF::getUser()->getPermission('admin.user.canEditGroup');
$row['editable'] = WCF::getUser()->getPermission('admin.user.canEditGroup');
$this->rulesets[] = $row;
}
}
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// get message list
$this->readMessages();
$this->readAvailableSenders();
// columns
$this->showRecipientColumn = $this->folderID == PMFolderList::FOLDER_DRAFTS || $this->folderID == PMFolderList::FOLDER_OUTBOX;
$this->showIconColumn = !$this->showRecipientColumn;
$this->showViewedColumn = $this->showRecipientColumn;
// marked messages
$this->markedMessages = PMAction::getMarkedCount();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// get marked users
$this->markedUsers = WCF::getSession()->getVar('markedUsers');
if ($this->markedUsers == null || !is_array($this->markedUsers)) {
$this->markedUsers = array();
}
// get columns heads
$this->readColumnsHeads();
// get users
$this->readUsers();
// build page url
$this->url = 'index.php?page=UserList&searchID=' . $this->searchID . '&action=' . rawurlencode($this->action) . '&pageNo=' . $this->pageNo . '&sortField=' . $this->sortField . '&sortOrder=' . $this->sortOrder . '&packageID=' . PACKAGE_ID . SID_ARG_2ND_NOT_ENCODED;
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// get smileys
$this->smileyList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->smileyList->sqlLimit = $this->itemsPerPage;
$this->smileyList->sqlOrderBy = 'smiley.' . $this->sortField . " " . $this->sortOrder;
$this->smileyList->readObjects();
// get categories
$this->smileyCategories = SmileyCategory::getSmileyCategories();
// get default smileys
$sql = "SELECT\tCOUNT(*) AS count\n\t\t\tFROM\twcf" . WCF_N . "_smiley\n\t\t\tWHERE\tsmileyCategoryID = 0";
$row = WCF::getDB()->getFirstRow($sql);
$this->defaultSmileys = $row['count'];
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// get data
if ($this->items) {
$this->threadList->limit = $this->itemsPerPage;
$this->threadList->offset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->threadList->sqlOrderBy = $this->sortField . " " . $this->sortOrder . ($this->sortField != 'lastPostTime' ? ", lastPostTime DESC" : '');
$this->threadList->readThreads();
}
// get marked threads
$sessionVars = WCF::getSession()->getVars();
if (isset($sessionVars['markedThreads'])) {
$this->markedThreads = count($sessionVars['markedThreads']);
}
}
/**
* @see Page::readData
*/
public function readData()
{
parent::readData();
if ($this->alliance === null) {
require_once WCF_DIR . 'lib/system/exception/IllegalLinkException.class.php';
throw new IllegalLinkException();
}
if (!$this->alliance->getRank(true, 4)) {
require_once WCF_DIR . 'lib/system/exception/PermissionDeniedException.class.php';
throw new PermissionDeniedException();
}
// get members
$sql = "SELECT id\n\t\t\t\tFROM ugml_users\n\t\t\t\tLEFT JOIN ugml_stat_entry\n\t\t\t\t\tON ugml_users.id = ugml_stat_entry.relationalID\n\t\t\t\t\t\tAND ugml_stat_entry.statTypeID = 1\n\t\t\t\tWHERE ally_id = " . $this->alliance->allianceID . "\n\t\t\t\tORDER BY " . $this->realSortField . " " . $this->sortOrder . "\n\t\t\t\tLIMIT " . $this->itemsPerPage . "\n\t\t\t\t\tOFFSET " . ($this->pageNo - 1) * $this->itemsPerPage;
$result = WCF::getDB()->sendQuery($sql);
while ($row = WCF::getDB()->fetchArray($result)) {
$this->members[$row['id']] = new LWUser($row['id']);
}
}
/**
* @see Page::readData
*/
public function readData()
{
parent::readData();
if ($this->alliance === null) {
require_once WCF_DIR . 'lib/system/exception/IllegalLinkException.class.php';
throw new IllegalLinkException();
}
if (!$this->alliance->getRank(true, 3)) {
require_once WCF_DIR . 'lib/system/exception/PermissionDeniedException.class.php';
throw new PermissionDeniedException();
}
// get applications
$sql = "SELECT id\n\t\t\t\tFROM ugml_users\n\t\t\t\tWHERE ally_request = " . $this->alliance->allianceID . "\n\t\t\t\tORDER BY " . $this->sortField . " " . $this->sortOrder . "\n\t\t\t\tLIMIT " . $this->itemsPerPage . "\n\t\t\t\tOFFSET " . ($this->pageNo - 1) * $this->itemsPerPage;
$result = WCF::getDB()->sendQuery($sql);
while ($row = WCF::getDB()->fetchArray($result)) {
$this->applications[$row['id']] = new LWUser($row['id']);
}
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// get ratingoptions
$this->ratingoptionList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->ratingoptionList->sqlLimit = $this->itemsPerPage;
$this->ratingoptionList->sqlOrderBy = 'contest_ratingoption.' . $this->sortField . " " . $this->sortOrder;
$this->ratingoptionList->readObjects();
// get classes
$this->classList = new ContestClassList();
$this->classList->sqlJoins = "LEFT JOIN\twcf" . WCF_N . "_contest_ratingoption contest_ratingoption USING(classID)";
$this->classList->sqlGroupBy = 'contest_class.classID';
$this->classList->readObjects();
// get categories
$this->classes = $this->classList->getObjects();
// defaultRatingoptions
$sql = "SELECT\tCOUNT(*) AS count\r\n\t\t\tFROM\twcf" . WCF_N . "_contest_ratingoption\r\n\t\t\tWHERE\tclassID\t= 0";
$row = WCF::getDB()->getFirstRow($sql);
$this->defaultRatingoptions = $row['count'];
}
/**
* @see Page::readData()
*/
public function readData()
{
if (!WCF::getUser()->getPermission('user.board.canViewUsersOnlineBox')) {
return;
}
parent::readData();
$this->usersOnlineSortedList->sqlOrderBy = 'session.' . $this->sortField . ' ' . $this->sortOrder;
$this->usersOnlineSortedList->getUsersOnline();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$this->readLanguages();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// get the log entries.
$this->readLogEntries();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$this->readFleetLog();
$this->userObj = new LWUser($this->userID);
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$this->readBBCodes();
}
/**
* @see SortablePage::readData()
*/
public function readData()
{
$this->readNewsletters();
parent::readData();
$this->sortNewsletters();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$this->readOptions();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// read objects
$this->userSuspensionList->sqlOffset = ($this->pageNo - 1) * $this->itemsPerPage;
$this->userSuspensionList->sqlLimit = $this->itemsPerPage;
$this->userSuspensionList->sqlOrderBy = ($this->sortField != 'title' && $this->sortField != 'username' ? 'user_suspension.' : '') . $this->sortField . " " . $this->sortOrder;
$this->userSuspensionList->readObjects();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// remove deleted fields
foreach ($this->activeFields as $key => $field) {
if (preg_match("/^userOption\\d+\$/", $field) && !$this->userOptions->getOption($field)) {
unset($this->activeFields[$key]);
}
}
$this->readMembers();
$this->loadLetters();
$this->loadHeaders();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
// get servers
$this->readUpdateServers();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$this->usersOnlineSortedList->sqlOrderBy = 'session.' . $this->sortField . ' ' . $this->sortOrder;
$this->usersOnlineSortedList->getUsersOnline();
}
/**
* @see Page::readData()
*/
public function readData()
{
parent::readData();
$this->readFleets();
}
/**
* @see Page::assignVariables()
*/
public function readData()
{
parent::readData();
$this->readGroups();
}
