codeQuake

PHP Source code

public static function refreshAll($categoryIDs) {
		if (empty($categoryIDs)) return;
 
		$sql = "UPDATE wcf".WCF_N."_linklist_category linkList_category
			SET	links = (
					SELECT	COUNT(*)
					FROM	wcf".WCF_N."_linklist_link
					WHERE	categoryID = linkList_category.categoryID
						AND isDeleted = 0
						AND isDisabled = 0
					),
				comments = (
					SELECT	COUNT(*)
					FROM	wcf".WCF_N."_linklist_link_comment
					WHERE	categoryID = linkList_category.categoryID
					),
				visits = (
					SELECT	IFNULL(SUM(visits), 0)
					FROM	wcf".WCF_N."_linklist_link
					WHERE	categoryID = linkList_category.categoryID
						AND isDeleted = 0
						AND isDisabled = 0
					)
			WHERE	categoryID IN (".$categoryIDs.")";
		WCF::getDB()->registerShutdownUpdate($sql);
	}

PHP Source code

$categoryIDs = '';
		$sql = "SELECT		categoryID
			FROM		wcf".WCF_N."_linklist_category
			ORDER BY	categoryID";
		$result = WCF::getDB()->sendQuery($sql, $limit, $offset);
		while ($row = WCF::getDB()->fetchArray($result)) {
			if (!empty($categoryIDs)) $categoryIDs .= ',';
			$categoryIDs .= $row['categoryID'];
 
			// update last entry
			$category = new LinkListCategoryEditor($row['categoryID']);
			// refresh categories
			LinkListCategoryEditor::refreshAll($categoryIDs);
			LinkListCategory::resetCache();
 
			// call event
			$this->updated();
		}
		if (empty($categoryIDs)) {
			$this->finished = true;
			return;
		}
}