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