/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); $sql = "SELECT COUNT(*) AS count\n\t\t\t\tFROM ugml_users\n\t\t\t\tWHERE ally_id = " . $this->alliance->allianceID; $result = WCF::getDB()->getFirstRow($sql); return $result['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); $sql = "SELECT COUNT(*)\n\t\t\t\t\tAS count\n\t\t\t\tFROM ugml_archive_fleet\n\t\t\t\tWHERE fleetID IN (" . implode(',', $this->fleetIDs) . ")"; $result = WCF::getDB()->getFirstRow($sql); return $result['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); $sql = "SELECT\tCOUNT(*) AS count\n\t\t\tFROM\twcf" . WCF_N . "_bbcode"; $row = WCF::getDB()->getFirstRow($sql); return $row['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); $sql = "SELECT\tCOUNT(*) AS count\n\t\t\tFROM\twcf" . WCF_N . "_package_update\n\t\t\tWHERE\tpackageUpdateID IN (" . $this->search['searchData'] . ")"; $row = WCF::getDB()->getFirstRow($sql); return $row['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); $sql = "SELECT COUNT(*) AS count\n\t\t\t\tFROM ugml_archive_fleets\n\t\t\t\tWHERE fleet_owner = " . $this->userID . "\n\t\t\t\t\tOR fleet_ofiara = " . $this->userID; $result = WCF::getDB()->getFirstRow($sql); return $result['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { SortablePage::countItems(); $sql = "SELECT COUNT(DISTINCT cronjobID) AS count FROM wcf" . WCF_N . "_admin_tools_function_to_cronjob"; $row = WCF::getDB()->getFirstRow($sql); return $row['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); // count cronjobs $sql = "SELECT\tCOUNT(*) AS count\n\t\t\tFROM\twcf" . WCF_N . "_cronjobs_log\n\t\t\tWHERE\tcronjobID IN (\n\t\t\t\t\tSELECT\tcronjobID\n\t\t\t\t\tFROM\twcf" . WCF_N . "_cronjobs cronjobs,\n\t\t\t\t\t\twcf" . WCF_N . "_package_dependency package_dependency\n\t\t\t\t\tWHERE \tcronjobs.packageID = package_dependency.dependency\n\t\t\t\t\t\tAND package_dependency.packageID = " . PACKAGE_ID . "\n\t\t\t\t)"; $row = WCF::getDB()->getFirstRow($sql); return $row['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); $this->getOptionIDs(); if (empty($this->optionIDs)) { return 0; } $sql = "SELECT\tCOUNT(*) AS count\n\t\t\tFROM\twcf" . WCF_N . "_user_option\n\t\t\tWHERE\toptionID IN (" . $this->optionIDs . ")"; $row = WCF::getDB()->getFirstRow($sql); return $row['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { SortablePage::countItems(); if (!$this->userID) { return 0; } // count members $sql = "SELECT\tCOUNT(*) AS count\n\t\t\tFROM\twcf" . WCF_N . "_user_whitelist\n\t\t\tWHERE\tuserID = " . $this->userID . "\n\t\t\t\tAND confirmed = 1"; $row = WCF::getDB()->getFirstRow($sql); return $row['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); return $this->count; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); return $this->ruleList->countObjects(); }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); return $this->threadList->countThreads(); }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); if ($this->threadList == null) { return 0; } return $this->threadList->countThreads(); }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); $sql = "SELECT\t\tCOUNT(*) AS count\n\t\t\tFROM \t\twcf" . WCF_N . "_group_application\n\t\t\tWHERE \t\tgroupID IN (\n\t\t\t\t\t\tSELECT\tgroupID\n\t\t\t\t\t\tFROM\twcf" . WCF_N . "_group_leader\n\t\t\t\t\t\tWHERE\tleaderUserID = " . WCF::getUser()->userID . "\n\t\t\t\t\t\t\tOR leaderGroupID IN (" . implode(',', WCF::getUser()->getGroupIDs()) . ")\n\t\t\t\t\t)"; $result = WCF::getDB()->getFirstRow($sql); return $result['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); return $this->suspensionList->countObjects(); }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); return count($this->newsletterList); }
/** * Counts the number of users. * * @return integer */ public function countItems() { parent::countItems(); $this->buildSqlConditions(); // count members $sql = "SELECT\tCOUNT(*) AS count\n\t\t\tFROM\t" . $this->userTable . " user\n\t\t\t" . (!empty($this->sqlConditions) ? "WHERE " . $this->sqlConditions : ''); $row = WCF::getDB()->getFirstRow($sql); return $row['count']; }
public function countItems() { parent::countItems(); $sql = "SELECT COUNT(*) AS count FROM wcf" . WCF_N . "_admin_tools_spider"; $row = WCF::getDB()->getFirstRow($sql); return $row['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); return $this->userOptionCategoryList->countObjects(); }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); return $this->sessionAccessLogList->countObjects(); }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); switch ($this->folderID) { // outbox case PMFolderList::FOLDER_OUTBOX: $sql = "SELECT\tCOUNT(*) AS count\n\t\t\t\t\tFROM \twcf" . WCF_N . "_pm\n\t\t\t\t\tWHERE \tuserID = " . WCF::getUser()->userID . "\n\t\t\t\t\t\tAND saveInOutbox = 1"; break; // drafts // drafts case PMFolderList::FOLDER_DRAFTS: $sql = "SELECT\tCOUNT(*) AS count\n\t\t\t\t\tFROM \twcf" . WCF_N . "_pm\n\t\t\t\t\tWHERE \tuserID = " . WCF::getUser()->userID . "\n\t\t\t\t\t\tAND isDraft = 1"; break; // trash // trash case PMFolderList::FOLDER_TRASH: $sql = "SELECT\t\tCOUNT(*) AS count\n\t\t\t\t\tFROM \t\twcf" . WCF_N . "_pm_to_user pm_to_user\n\t\t\t\t\t" . ($this->filterBySender != 0 ? "LEFT JOIN wcf" . WCF_N . "_pm pm USING (pmID)" : '') . "\n\t\t\t\t\tWHERE \t\tpm_to_user.recipientID = " . WCF::getUser()->userID . "\n\t\t\t\t\t\t\tAND pm_to_user.isDeleted = 1\n\t\t\t\t\t\t\t" . ($this->filterBySender != 0 ? "AND pm.userID = " . $this->filterBySender : ''); break; // inbox & own folders // inbox & own folders default: $sql = "SELECT\t\tCOUNT(*) AS count\n\t\t\t\t\tFROM \t\twcf" . WCF_N . "_pm_to_user pm_to_user\n\t\t\t\t\t" . ($this->filterBySender != 0 ? "LEFT JOIN wcf" . WCF_N . "_pm pm USING (pmID)" : '') . "\n\t\t\t\t\tWHERE \t\tpm_to_user.recipientID = " . WCF::getUser()->userID . "\n\t\t\t\t\t\t\tAND pm_to_user.isDeleted = 0\n\t\t\t\t\t\t\tAND pm_to_user.folderID = " . $this->folderID . "\n\t\t\t\t\t\t\t" . ($this->filterBySender != 0 ? "AND pm.userID = " . $this->filterBySender : ''); } $result = WCF::getDB()->getFirstRow($sql); return $result['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); $sql = "SELECT\tCOUNT(*) AS count\n\t\t\tFROM\twcf" . WCF_N . "_user user_table\n\t\t\t" . (!empty($this->sqlConditions) ? 'WHERE ' . $this->sqlConditions : ''); $row = WCF::getDB()->getFirstRow($sql); return $row['count']; }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); return count($this->subscribersList); }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); return $this->userWarningList->countObjects(); }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); return $this->failedLoginList->countObjects(); }
/** * @see MultipleLinkPage::countItems() */ public function countItems() { parent::countItems(); return $this->attachmentList->countObjects(); }