예제 #1
0
 /**
  * @see	\wcf\data\AbstractDatabaseObjectAction::delete()
  */
 public function delete()
 {
     parent::delete();
     if (!empty($this->objects)) {
         // identify i18n labels
         $languageVariables = array();
         foreach ($this->objects as $object) {
             if (preg_match('~wcf.acp.label.label\\d+~', $object->label)) {
                 $languageVariables[] = $object->label;
             }
         }
         // remove language variables
         if (!empty($languageVariables)) {
             $conditions = new PreparedStatementConditionBuilder();
             $conditions->add("languageItem IN (?)", array($languageVariables));
             $sql = "SELECT\tlanguageItemID\n\t\t\t\t\tFROM\twcf" . WCF_N . "_language_item\n\t\t\t\t\t" . $conditions;
             $statement = WCF::getDB()->prepareStatement($sql);
             $statement->execute($conditions->getParameters());
             $languageItemIDs = array();
             while ($row = $statement->fetchArray()) {
                 $languageItemIDs[] = $row['languageItemID'];
             }
             $objectAction = new LanguageItemAction($languageItemIDs, 'delete');
             $objectAction->executeAction();
         }
     }
 }
 /**
  * @see	\wcf\system\faker\AbstractLikeFaker::getLikeableObject()
  */
 public function getLikeableObjectID()
 {
     $sql = "SELECT\t\tcommentID\n\t\t\tFROM\t\twcf" . WCF_N . "_comment\n\t\t\t" . $this->condition;
     $statement = \wcf\system\WCF::getDB()->prepareStatement($sql, 1, $this->generator->numberBetween(0, $this->commentCount - 1));
     $statement->execute($this->condition->getParameters());
     return $statement->fetchColumn();
 }
예제 #3
0
 /**
  * @see wcf\system\setup\IFileHandler::logFiles()
  */
 public function logFiles(array $files)
 {
     if (empty($files)) {
         return;
     }
     // fetch already installed files
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add("packageID = ?", array($this->packageInstallation->getPackageID()));
     $conditions->add("filename IN (?)", array($files));
     $sql = "SELECT\tfilename\n\t\t\tFROM\twcf" . WCF_N . "_package_installation_file_log\n\t\t\t" . $conditions;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($conditions->getParameters());
     $installedFiles = array();
     while ($row = $statement->fetchArray()) {
         $installedFiles[] = $row['filename'];
     }
     // ignore files which have already been installed
     $installFiles = array();
     foreach ($files as $file) {
         if (in_array($file, $installedFiles)) {
             continue;
         }
         $installFiles[] = $file;
     }
     if (!empty($installFiles)) {
         $sql = "INSERT INTO\twcf" . WCF_N . "_package_installation_file_log\n\t\t\t\t\t\t(packageID, filename)\n\t\t\t\tVALUES\t\t(?, ?)";
         $statement = WCF::getDB()->prepareStatement($sql);
         foreach ($installFiles as $file) {
             $statement->execute(array($this->packageInstallation->getPackageID(), $file));
         }
     }
 }
 /**
  * @see	\wcf\system\cache\builder\AbstractCacheBuilder::rebuild()
  */
 protected function rebuild(array $parameters)
 {
     $data = array('boxes' => array(), 'pages' => array());
     // load boxes
     $boxList = new DashboardBoxList();
     $boxList->readObjects();
     foreach ($boxList as $box) {
         $data['boxes'][$box->boxID] = $box;
     }
     // load settings
     $objectTypes = ObjectTypeCache::getInstance()->getObjectTypes('com.woltlab.wcf.user.dashboardContainer');
     $objectTypeIDs = array();
     foreach ($objectTypes as $objectType) {
         $objectTypeIDs[] = $objectType->objectTypeID;
     }
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add("objectTypeID IN (?)", array($objectTypeIDs));
     $sql = "SELECT\t\t*\n\t\t\tFROM\t\twcf" . WCF_N . "_dashboard_option\n\t\t\t" . $conditions . "\n\t\t\tORDER BY\tshowOrder ASC";
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($conditions->getParameters());
     while ($row = $statement->fetchArray()) {
         if (!isset($data['pages'][$row['objectTypeID']])) {
             $data['pages'][$row['objectTypeID']] = array();
         }
         $data['pages'][$row['objectTypeID']][] = $row['boxID'];
     }
     return $data;
 }
예제 #5
0
 /**
  * @see wcf\system\cache\ICacheBuilder::getData()
  */
 public function getData(array $cacheResource)
 {
     list($cache, $packageID) = explode('-', $cacheResource['cache']);
     $data = array();
     // get all menu items and filter menu items with low priority
     $sql = "SELECT\t\tmenuItem, menuItemID \n\t\t\tFROM\t\twcf" . WCF_N . "_page_menu_item menu_item\n\t\t\tLEFT JOIN\twcf" . WCF_N . "_package_dependency package_dependency\n\t\t\tON\t\t(package_dependency.dependency = menu_item.packageID)\n\t\t\tWHERE \t\tpackage_dependency.packageID = ?\n\t\t\tORDER BY\tpackage_dependency.priority ASC";
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute(array($packageID));
     $itemIDs = array();
     while ($row = $statement->fetchArray()) {
         $itemIDs[$row['menuItem']] = $row['menuItemID'];
     }
     if (count($itemIDs) > 0) {
         // get needed menu items and build item tree
         $conditions = new PreparedStatementConditionBuilder();
         $conditions->add("menu_item.menuItemID IN (?)", array($itemIDs));
         $conditions->add("menu_item.isDisabled = ?", array(0));
         $sql = "SELECT\t\tmenuItemID, menuItem, parentMenuItem, menuItemLink,\n\t\t\t\t\t\tpermissions, options, packageDir, menuPosition, className,\n\t\t\t\t\t\tCASE WHEN parentPackageID <> 0 THEN parentPackageID ELSE menu_item.packageID END AS packageID\n\t\t\t\tFROM\t\twcf" . WCF_N . "_page_menu_item menu_item\n\t\t\t\tLEFT JOIN\twcf" . WCF_N . "_package package\n\t\t\t\tON\t\t(package.packageID = menu_item.packageID)\n\t\t\t\t" . $conditions . "\n\t\t\t\tORDER BY\tshowOrder ASC";
         $statement = WCF::getDB()->prepareStatement($sql);
         $statement->execute($conditions->getParameters());
         while ($row = $statement->fetchArray()) {
             $data[$row['parentMenuItem'] ? $row['parentMenuItem'] : $row['menuPosition']][] = new PageMenuItem(null, $row);
         }
     }
     return $data;
 }
 /**
  * @see	\wcf\system\worker\IWorker::execute()
  */
 public function execute()
 {
     parent::execute();
     $users = $userIDs = array();
     foreach ($this->getObjectList() as $user) {
         $users[] = new UserEditor($user);
         $userIDs[] = $user->userID;
     }
     // update user ranks
     if (!empty($users)) {
         $action = new UserProfileAction($users, 'updateUserOnlineMarking');
         $action->executeAction();
     }
     if (!empty($userIDs)) {
         // update activity points
         UserActivityPointHandler::getInstance()->updateUsers($userIDs);
         // update like counter
         if (MODULE_LIKE) {
             $conditionBuilder = new PreparedStatementConditionBuilder();
             $conditionBuilder->add('user_table.userID IN (?)', array($userIDs));
             $sql = "UPDATE\twcf" . WCF_N . "_user user_table\n\t\t\t\t\tSET\tlikesReceived = (\n\t\t\t\t\t\t\tSELECT\tCOUNT(*)\n\t\t\t\t\t\t\tFROM\twcf" . WCF_N . "_like\n\t\t\t\t\t\t\tWHERE\tobjectUserID = user_table.userID\n\t\t\t\t\t\t\t\tAND likeValue = " . Like::LIKE . "\n\t\t\t\t\t\t)\n\t\t\t\t\t" . $conditionBuilder;
             $statement = WCF::getDB()->prepareStatement($sql);
             $statement->execute($conditionBuilder->getParameters());
         }
     }
 }
 /**
  * Updates the participants of this conversation.
  * 
  * @param	array<integer>	$participantIDs
  * @param	array<integer>	$invisibleParticipantIDs
  */
 public function updateParticipants(array $participantIDs, array $invisibleParticipantIDs = array())
 {
     $usernames = array();
     if (!empty($participantIDs) || !empty($invisibleParticipantIDs)) {
         $conditions = new PreparedStatementConditionBuilder();
         $conditions->add("userID IN (?)", array(array_merge($participantIDs, $invisibleParticipantIDs)));
         $sql = "SELECT\tuserID, username\n\t\t\t\tFROM\twcf" . WCF_N . "_user\n\t\t\t\t" . $conditions;
         $statement = WCF::getDB()->prepareStatement($sql);
         $statement->execute($conditions->getParameters());
         while ($row = $statement->fetchArray()) {
             $usernames[$row['userID']] = $row['username'];
         }
     }
     if (!empty($participantIDs)) {
         WCF::getDB()->beginTransaction();
         $sql = "INSERT INTO\t\twcf" . WCF_N . "_conversation_to_user\n\t\t\t\t\t\t\t(conversationID, participantID, username, isInvisible)\n\t\t\t\tVALUES\t\t\t(?, ?, ?, ?)\n\t\t\t\tON DUPLICATE KEY\n\t\t\t\tUPDATE\t\t\thideConversation = 0";
         $statement = WCF::getDB()->prepareStatement($sql);
         foreach ($participantIDs as $userID) {
             $statement->execute(array($this->conversationID, $userID, $usernames[$userID], 0));
         }
         WCF::getDB()->commitTransaction();
     }
     if (!empty($invisibleParticipantIDs)) {
         WCF::getDB()->beginTransaction();
         $sql = "INSERT INTO\t\twcf" . WCF_N . "_conversation_to_user\n\t\t\t\t\t\t\t(conversationID, participantID, username, isInvisible)\n\t\t\t\tVALUES\t\t\t(?, ?, ?, ?)";
         $statement = WCF::getDB()->prepareStatement($sql);
         foreach ($invisibleParticipantIDs as $userID) {
             $statement->execute(array($this->conversationID, $userID, $usernames[$userID], 1));
         }
         WCF::getDB()->commitTransaction();
     }
     $this->updateParticipantCount();
 }
예제 #8
0
	/**
	 * Compiles LESS stylesheets.
	 * 
	 * @param	wcf\data\style\Style	$style
	 */
	public function compile(Style $style) {
		// read stylesheets by dependency order
		$conditions = new PreparedStatementConditionBuilder();
		$conditions->add("file_log.filename REGEXP ?", array('style/([a-zA-Z0-9\_\-\.]+)\.less'));
		
		$sql = "SELECT		file_log.filename, package.packageDir
			FROM		wcf".WCF_N."_package_installation_file_log file_log
			LEFT JOIN	wcf".WCF_N."_package package
			ON		(file_log.packageID = package.packageID)
			".$conditions;
		$statement = WCF::getDB()->prepareStatement($sql);
		$statement->execute($conditions->getParameters());
		$files = array();
		while ($row = $statement->fetchArray()) {
			$files[] = WCF_DIR.$row['packageDir'].$row['filename'];
		}
		
		// get style variables
		$variables = $style->getVariables();
		$individualLess = '';
		if (isset($variables['individualLess'])) {
			$individualLess = $variables['individualLess'];
			unset($variables['individualLess']);
		}
		
		$this->compileStylesheet(
			WCF_DIR.'style/style-'.$style->styleID,
			$files,
			$variables,
			$individualLess,
			new Callback(function($content) use ($style) {
				return "/* stylesheet for '".$style->styleName."', generated on ".gmdate('r')." -- DO NOT EDIT */\n\n" . $content;
			})
		);
	}
 /**
  * Reads associated tags.
  */
 protected function getTags()
 {
     $this->tags = array();
     if (!empty($this->objectTypeIDs)) {
         // get tag ids
         $tagIDs = array();
         $conditionBuilder = new PreparedStatementConditionBuilder();
         $conditionBuilder->add('object.objectTypeID IN (?)', array($this->objectTypeIDs));
         $conditionBuilder->add('object.languageID IN (?)', array($this->languageIDs));
         $sql = "SELECT\t\tCOUNT(*) AS counter, object.tagID\n\t\t\t\tFROM\t\twcf" . WCF_N . "_tag_to_object object\n\t\t\t\t" . $conditionBuilder . "\n\t\t\t\tGROUP BY\tobject.tagID\n\t\t\t\tORDER BY\tcounter DESC";
         $statement = WCF::getDB()->prepareStatement($sql, 500);
         $statement->execute($conditionBuilder->getParameters());
         while ($row = $statement->fetchArray()) {
             $tagIDs[$row['tagID']] = $row['counter'];
         }
         // get tags
         if (!empty($tagIDs)) {
             $sql = "SELECT\t*\n\t\t\t\t\tFROM\twcf" . WCF_N . "_tag\n\t\t\t\t\tWHERE\ttagID IN (?" . (count($tagIDs) > 1 ? str_repeat(',?', count($tagIDs) - 1) : '') . ")";
             $statement = WCF::getDB()->prepareStatement($sql);
             $statement->execute(array_keys($tagIDs));
             while ($row = $statement->fetchArray()) {
                 $row['counter'] = $tagIDs[$row['tagID']];
                 $this->tags[$row['name']] = new TagCloudTag(new Tag(null, $row));
             }
             // sort by counter
             uasort($this->tags, array('self', 'compareTags'));
         }
     }
 }
예제 #10
0
	/**
	 * @see	wcf\system\option\ISearchableUserOption::getCondition()
	 */
	public function getCondition(PreparedStatementConditionBuilder &$conditions, Option $option, $value) {
		$value = StringUtil::trim($value);
		if (!$value) return false;
		
		$conditions->add("option_value.userOption".$option->optionID." = ?", array($value));
		return true;
	}
    protected function initUnreadArticle()
    {
        //Get application
        $classParts = explode('\\', get_called_class());
        if (WCF::getUser()->userID) {
            $conditionBuilder = new PreparedStatementConditionBuilder();
            $conditionBuilder->add(self::$articleType . '.lastChangeTime > ?', array(VisitTracker::getInstance()->getVisitTime(self::OBJECT_TYPE)));
            $conditionBuilder->add(self::$articleType . '.isDeleted = 0');
            $conditionBuilder->add(self::$articleType . '.isDisabled = 0');
            $conditionBuilder->add('tracked_visit.visitTime IS NULL');
            // apply language filter
            if (LanguageFactory::getInstance()->multilingualismEnabled() && count(WCF::getUser()->getLanguageIDs())) {
                $conditionBuilder->add('(' . self::$articleType . '.languageID IN (?) OR ' . self::$articleType . '.languageID IS NULL)', array(WCF::getUser()->getLanguageIDs()));
            }
            $sql = 'SELECT		COUNT(*) AS count, ' . self::$articleType . '_to_category.categoryID
				FROM		' . $classParts[0] . WCF_N . '_' . self::$articleType . ' ' . self::$articleType . '
				LEFT JOIN	wcf' . WCF_N . '_tracked_visit tracked_visit
				ON		(tracked_visit.objectTypeID = ' . VisitTracker::getInstance()->getObjectTypeID(self::OBJECT_TYPE) . ' AND tracked_visit.objectID = ' . self::$articleType . '.' . self::$articleType . 'ID AND tracked_visit.userID = ' . WCF::getUser()->userID . ')
				LEFT JOIN	' . $classParts[0] . WCF_N . '_' . self::$articleType . '_to_category ' . self::$articleType . '_to_category
				ON		(' . self::$articleType . '_to_category.' . self::$articleType . 'ID = ' . self::$articleType . '.' . self::$articleType . 'ID)
				' . $conditionBuilder . '
				GROUP BY	' . self::$articleType . '_to_category.categoryID';
            $statement = WCF::getDB()->prepareStatement($sql);
            $statement->execute($conditionBuilder->getParameters());
            while ($row = $statement->fetchArray()) {
                $this->unreadArticles[$row['categoryID']] = $row['count'];
            }
        }
    }
예제 #12
0
 /**
  * @see	\wcf\data\ISortableAction::validateUpdatePosition()
  */
 public function validateUpdatePosition()
 {
     if (!WCF::getSession()->getPermission('admin.project.canEditProject')) {
         throw new PermissionDeniedException();
     }
     if (!isset($this->parameters['data']['structure'])) {
         throw new UserInputException('structure');
     }
     $projectIDs = array();
     foreach ($this->parameters['data']['structure'][0] as $projectID) {
         if (!$projectID) {
             throw new UserInputException('structure');
         }
         $projectIDs[] = $projectID;
     }
     $projectIDs = array_unique($projectIDs);
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add("projectID IN (?)", array($projectIDs));
     $sql = "SELECT\tprojectID\n\t\t\t\tFROM\tict" . WCF_N . "_project\n\t\t\t\t" . $conditions;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($conditions->getParameters());
     while ($row = $statement->fetchArray()) {
         $key = array_search($row['projectID'], $projectIDs);
         if ($key !== false) {
             unset($projectIDs[$key]);
         }
     }
     if (!empty($projectIDs)) {
         throw new UserInputException('structure');
     }
 }
 /**
  * @see	\wcf\system\setup\IFileHandler::logFiles()
  */
 public function logFiles(array $files)
 {
     // remove file extension
     foreach ($files as &$file) {
         $file = substr($file, 0, -4);
     }
     unset($file);
     // fetch already installed acp templates
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add('packageID = ?', array($this->packageInstallation->getPackageID()));
     $conditions->add('templateName IN (?)', array($files));
     $conditions->add('application = ?', array($this->application));
     $sql = "SELECT\ttemplateName\n\t\t\tFROM\twcf" . WCF_N . "_" . $this->tableName . "\n\t\t\t" . $conditions;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($conditions->getParameters());
     while ($templateName = $statement->fetchColumn()) {
         $index = array_search($templateName, $files);
         if ($index !== false) {
             unset($files[$index]);
         }
     }
     if (!empty($files)) {
         $sql = "INSERT INTO\twcf" . WCF_N . "_" . $this->tableName . "\n\t\t\t\t\t\t(packageID, templateName, application)\n\t\t\t\tVALUES\t\t(?, ?, ?)";
         $statement = WCF::getDB()->prepareStatement($sql);
         foreach ($files as $file) {
             $statement->execute(array($this->packageInstallation->getPackageID(), $file, $this->application));
         }
     }
 }
예제 #14
0
 /**
  * Loads storage for a given set of users.
  * 
  * @param	array<integer>	$userIDs
  * @param	integer		$packageID
  */
 public function loadStorage(array $userIDs, $packageID = PACKAGE_ID)
 {
     $tmp = array();
     foreach ($userIDs as $userID) {
         if (!isset($this->cache[$userID])) {
             $tmp[] = $userID;
         }
     }
     // ignore users whose storage data is already loaded
     if (empty($tmp)) {
         return;
     }
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add("userID IN (?)", array($tmp));
     $conditions->add("packageID IN (?)", array(PackageDependencyHandler::getInstance()->getDependencies($packageID)));
     $sql = "SELECT\t*\n\t\t\tFROM\twcf" . WCF_N . "_user_storage\n\t\t\t" . $conditions;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($conditions->getParameters());
     while ($row = $statement->fetchArray()) {
         if (!isset($this->cache[$row['userID']])) {
             $this->cache[$row['userID']] = array();
         }
         $this->cache[$row['userID']][$row['field']] = $row['fieldValue'];
     }
 }
 /**
  * @see	\wcf\system\like\IViewableLikeProvider::prepare()
  */
 public function prepare(array $likes)
 {
     $responseIDs = array();
     foreach ($likes as $like) {
         $responseIDs[] = $like->objectID;
     }
     // get objects type ids
     $responses = array();
     $conditionBuilder = new PreparedStatementConditionBuilder();
     $conditionBuilder->add('comment_response.responseID IN (?)', array($responseIDs));
     $sql = "SELECT\t\tcomment.objectTypeID, comment_response.responseID\n\t\t\tFROM\t\twcf" . WCF_N . "_comment_response comment_response\n\t\t\tLEFT JOIN\twcf" . WCF_N . "_comment comment\n\t\t\tON\t\t(comment.commentID = comment_response.commentID)\n\t\t\t" . $conditionBuilder;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($conditionBuilder->getParameters());
     while ($row = $statement->fetchArray()) {
         $responses[$row['responseID']] = $row['objectTypeID'];
     }
     // group likes by object type id
     $likeData = array();
     foreach ($likes as $like) {
         if (isset($responses[$like->objectID])) {
             if (!isset($likeData[$responses[$like->objectID]])) {
                 $likeData[$responses[$like->objectID]] = array();
             }
             $likeData[$responses[$like->objectID]][] = $like;
         }
     }
     foreach ($likeData as $objectTypeID => $likes) {
         $objectType = CommentHandler::getInstance()->getObjectType($objectTypeID);
         if (CommentHandler::getInstance()->getCommentManager($objectType->objectType) instanceof IViewableLikeProvider) {
             CommentHandler::getInstance()->getCommentManager($objectType->objectType)->prepare($likes);
         }
     }
 }
예제 #16
0
 protected function getTopOptionCategories($packageID)
 {
     // get all option categories and filter categories with low priority
     $sql = "SELECT\t\tcategoryName, categoryID \n\t\t\tFROM\t\twcf" . WCF_N . "_option_category option_category\n\t\t\tLEFT JOIN\twcf" . WCF_N . "_package_dependency package_dependency\n\t\t\tON\t\t(package_dependency.dependency = option_category.packageID)\n\t\t\tWHERE \t\tpackage_dependency.packageID = ?\n\t\t\tORDER BY\tpackage_dependency.priority ASC";
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute(array($packageID));
     $optionCategories = array();
     while ($row = $statement->fetchArray()) {
         $optionCategories[$row['categoryName']] = $row['categoryID'];
     }
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add("categoryID IN (?)", array($optionCategories));
     $statementParameters = $conditions->getParameters();
     array_unshift($statementParameters, $packageID);
     $sql = "SELECT \t\tcategoryID, parentCategoryName, categoryName,\n\t\t\t\t\t(\n\t\t\t\t\t\tSELECT COUNT(*) FROM wcf" . WCF_N . "_option WHERE categoryName = category.categoryName AND packageID IN (\n\t\t\t\t\t\t\tSELECT dependency FROM wcf" . WCF_N . "_package_dependency WHERE packageID = ?\n\t\t\t\t\t\t)\n\t\t\t\t\t) AS count\n\t\t\tFROM\t\twcf" . WCF_N . "_option_category category\n\t\t\t" . $conditions;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($statementParameters);
     while ($row = $statement->fetchArray()) {
         if (!isset($this->optionCategoryStructure[$row['parentCategoryName']])) {
             $this->optionCategoryStructure[$row['parentCategoryName']] = array();
         }
         $this->optionCategoryStructure[$row['parentCategoryName']][] = $row;
     }
     $topOptionCategories = array();
     foreach ($this->optionCategoryStructure[''] as $optionCategory) {
         $count = $optionCategory['count'] + $this->countOptions($optionCategory['categoryName']);
         if ($count > 0) {
             $topOptionCategories[] = $optionCategory['categoryID'];
         }
     }
     return $topOptionCategories;
 }
예제 #17
0
	/**
	 * @see	wcf\system\option\ISearchableUserOption::getCondition()
	 */
	public function getCondition(PreparedStatementConditionBuilder &$conditions, Option $option, $value) {
		$value = StringUtil::trim($value);
		if (empty($value)) return false;
		
		$conditions->add("option_value.userOption".$option->optionID." LIKE ?", array('%'.addcslashes($value, '_%').'%'));
		return true;
	}
 /**
  * @see	\wcf\system\moderation\queue\IModerationQueueHandler::assignQueues()
  */
 public function assignQueues(array $queues)
 {
     $assignments = array();
     // read comments and responses
     $responseIDs = array();
     foreach ($queues as $queue) {
         $responseIDs[] = $queue->objectID;
     }
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add("comment_response.responseID IN (?)", array($responseIDs));
     $sql = "SELECT\t\tcomment_response.responseID, comment.commentID, comment.objectTypeID, comment.objectID\n\t\t\tFROM\t\twcf" . WCF_N . "_comment_response comment_response\n\t\t\tLEFT JOIN\twcf" . WCF_N . "_comment comment\n\t\t\tON\t\t(comment.commentID = comment_response.commentID)\n\t\t\t" . $conditions;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($conditions->getParameters());
     $comments = $responses = array();
     while ($row = $statement->fetchArray()) {
         $comments[$row['commentID']] = new Comment(null, $row);
         $responses[$row['responseID']] = new CommentResponse(null, $row);
     }
     $orphanedQueueIDs = array();
     foreach ($queues as $queue) {
         $assignUser = false;
         if (!isset($responses[$queue->objectID]) || !isset($comments[$responses[$queue->objectID]->commentID])) {
             $orphanedQueueIDs[] = $queue->queueID;
             continue;
         }
         $comment = $comments[$responses[$queue->objectID]->commentID];
         if ($this->getCommentManager($comment)->canModerate($comment->objectTypeID, $comment->objectID)) {
             $assignUser = true;
         }
         $assignments[$queue->queueID] = $assignUser;
     }
     ModerationQueueManager::getInstance()->removeOrphans($orphanedQueueIDs);
     ModerationQueueManager::getInstance()->setAssignment($assignments);
 }
 /**
  * @see	\wcf\system\event\listener\IParameterizedEventListener::execute()
  */
 public function execute($eventObj, $className, $eventName, array &$parameters)
 {
     // conversation
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add("userID IN (?)", array($eventObj->mergedUserIDs));
     $sql = "UPDATE\twcf" . WCF_N . "_conversation\n\t\t\tSET\tuserID = ?\n\t\t\t" . $conditions;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute(array_merge(array($eventObj->destinationUserID), $conditions->getParameters()));
     // conversation_to_user
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add("participantID IN (?)", array($eventObj->mergedUserIDs));
     $sql = "UPDATE IGNORE\twcf" . WCF_N . "_conversation_to_user\n\t\t\tSET\t\tparticipantID = ?\n\t\t\t" . $conditions;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute(array_merge(array($eventObj->destinationUserID), $conditions->getParameters()));
     // conversation_message
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add("userID IN (?)", array($eventObj->mergedUserIDs));
     $sql = "UPDATE\twcf" . WCF_N . "_conversation_message\n\t\t\tSET\tuserID = ?\n\t\t\t" . $conditions;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute(array_merge(array($eventObj->destinationUserID), $conditions->getParameters()));
     // conversation_label
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add("userID IN (?)", array($eventObj->mergedUserIDs));
     $sql = "UPDATE\twcf" . WCF_N . "_conversation_label\n\t\t\tSET\tuserID = ?\n\t\t\t" . $conditions;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute(array_merge(array($eventObj->destinationUserID), $conditions->getParameters()));
 }
예제 #20
0
 /**
  * @see	\wcf\system\setup\IFileHandler::checkFiles()
  */
 public function checkFiles(array $files)
 {
     if ($this->packageInstallation->getPackage()->package != 'com.woltlab.wcf') {
         if (!empty($files)) {
             // get registered files of other packages for the
             // same application
             $conditions = new PreparedStatementConditionBuilder();
             $conditions->add('packageID <> ?', array($this->packageInstallation->getPackageID()));
             $conditions->add('filename IN (?)', array($files));
             $conditions->add('application = ?', array($this->application));
             $sql = "SELECT\tfilename, packageID\n\t\t\t\t\tFROM\twcf" . WCF_N . "_package_installation_file_log\n\t\t\t\t\t" . $conditions;
             $statement = WCF::getDB()->prepareStatement($sql);
             $statement->execute($conditions->getParameters());
             $lockedFiles = array();
             while ($row = $statement->fetchArray()) {
                 $lockedFiles[$row['filename']] = $row['packageID'];
             }
             // check delivered files
             if (!empty($lockedFiles)) {
                 foreach ($files as $key => $file) {
                     if (isset($lockedFiles[$file])) {
                         $owningPackage = new Package($lockedFiles[$file]);
                         throw new SystemException("A package can't overwrite files from other packages. Only an update from the package which owns the file can do that. (Package '" . $this->packageInstallation->getPackage()->package . "' tries to overwrite file '" . $file . "', which is owned by package '" . $owningPackage->package . "')");
                     }
                 }
             }
         }
     }
 }
예제 #21
0
 /**
  * @see	\wcf\system\setup\IFileHandler::logFiles()
  */
 public function logFiles(array $files)
 {
     $packageID = $this->packageInstallation->getPackageID();
     // remove file extension
     foreach ($files as &$file) {
         $file = substr($file, 0, -4);
     }
     unset($file);
     // get existing templates
     $existingTemplates = $updateTemplateIDs = array();
     $sql = "SELECT\ttemplateName, templateID\n\t\t\tFROM\twcf" . WCF_N . "_template\n\t\t\tWHERE\tpackageID = ?\n\t\t\t\tAND application = ?\n\t\t\t\tAND templateGroupID IS NULL";
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute(array($packageID, $this->application));
     while ($row = $statement->fetchArray()) {
         $existingTemplates[$row['templateName']] = $row['templateID'];
     }
     // save new templates
     $sql = "INSERT INTO\twcf" . WCF_N . "_template\n\t\t\t\t\t(packageID, templateName, lastModificationTime, application)\n\t\t\tVALUES\t\t(?, ?, ?, ?)";
     $statement = WCF::getDB()->prepareStatement($sql);
     foreach ($files as $file) {
         if (isset($existingTemplates[$file])) {
             $updateTemplateIDs[] = $existingTemplates[$file];
             continue;
         }
         $statement->execute(array($packageID, $file, TIME_NOW, $this->application));
     }
     if (!empty($updateTemplateIDs)) {
         // update old templates
         $conditionBuilder = new PreparedStatementConditionBuilder();
         $conditionBuilder->add('templateID IN (?)', array($updateTemplateIDs));
         $sql = "UPDATE\twcf" . WCF_N . "_template\n\t\t\t\tSET\tlastModificationTime = ?\n\t\t\t\t" . $conditionBuilder;
         $statement = WCF::getDB()->prepareStatement($sql);
         $statement->execute(array_merge(array(TIME_NOW), $conditionBuilder->getParameters()));
     }
 }
예제 #22
0
	/**
	 * Loads storage for a given set of users.
	 * 
	 * @param	array<integer>	$userIDs
	 */
	public function loadStorage(array $userIDs) {
		$tmp = array();
		foreach ($userIDs as $userID) {
			if (!isset($this->cache[$userID])) $tmp[] = $userID;
		}
		
		// ignore users whose storage data is already loaded
		if (empty($tmp)) return;
		
		$conditions = new PreparedStatementConditionBuilder();
		$conditions->add("userID IN (?)", array($tmp));
		
		$sql = "SELECT	*
			FROM	wcf".WCF_N."_user_storage
			".$conditions;
		$statement = WCF::getDB()->prepareStatement($sql);
		$statement->execute($conditions->getParameters());
		while ($row = $statement->fetchArray()) {
			if (!isset($this->cache[$row['userID']])) {
				$this->cache[$row['userID']] = array();
			}
			
			$this->cache[$row['userID']][$row['field']] = $row['fieldValue'];
		}
	}
 /**
  * @see	\wcf\system\search\acp\IACPSearchResultProvider::search()
  */
 public function search($query)
 {
     if (!WCF::getSession()->getPermission('admin.system.package.canUpdatePackage') && !WCF::getSession()->getPermission('admin.system.package.canUninstallPackage')) {
         return array();
     }
     $results = array();
     // search by language item
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add("languageID = ?", array(WCF::getLanguage()->languageID));
     $conditions->add("languageItem LIKE ?", array('wcf.acp.package.packageName.package%'));
     $conditions->add("languageItemValue LIKE ?", array('%' . $query . '%'));
     $sql = "SELECT\t\tlanguageItem\n\t\t\tFROM\t\twcf" . WCF_N . "_language_item\n\t\t\t" . $conditions;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($conditions->getParameters());
     $packageIDs = array();
     while ($row = $statement->fetchArray()) {
         $packageIDs[] = str_replace('wcf.acp.package.packageName.package', '', $row['languageItem']);
     }
     $conditions = new PreparedStatementConditionBuilder(false);
     if (!empty($packageIDs)) {
         $conditions->add("packageID IN (?)", array($packageIDs));
     }
     $sql = "SELECT\t*\n\t\t\tFROM\twcf" . WCF_N . "_package\n\t\t\tWHERE\tpackageName LIKE ?\n\t\t\t\tOR package LIKE ?\n\t\t\t\t" . (count($conditions->getParameters()) ? "OR " . $conditions : "");
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute(array_merge(array($query . '%', $query . '%'), $conditions->getParameters()));
     while ($package = $statement->fetchObject('wcf\\data\\package\\Package')) {
         $results[] = new ACPSearchResult($package->getName(), LinkHandler::getInstance()->getLink('Package', array('id' => $package->packageID, 'title' => $package->getName())));
     }
     return $results;
 }
예제 #24
0
 /**
  * Removes a list of polls by id.
  * 
  * @param	array<integer>		$pollIDs
  */
 public function removePolls(array $pollIDs)
 {
     $conditions = new PreparedStatementConditionBuilder();
     $conditions->add("pollID IN (?)", array($pollIDs));
     $sql = "DELETE FROM\twcf" . WCF_N . "_poll\n\t\t\t" . $conditions;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($conditions->getParameters());
 }
예제 #25
0
	/**
	 * @see	wcf\system\option\ISearchableUserOption::getCondition()
	 */
	public function getCondition(PreparedStatementConditionBuilder &$conditions, Option $option, $value) {
		if (!is_array($value) || empty($value)) return false;
		$value = ArrayUtil::trim($value);
		if (empty($value)) return false;
		
		$conditions->add("option_value.userOption".$option->optionID." = ?", array(implode("\n", $value)));
		return true;
	}
 /**
  * @see	\wcf\system\option\ISearchableUserOption::getCondition()
  */
 public function getCondition(PreparedStatementConditionBuilder &$conditions, Option $option, $value)
 {
     if (!isset($_POST['searchOptions'][$option->optionName])) {
         return false;
     }
     $conditions->add("option_value.userOption" . $option->optionID . " = ?", array(StringUtil::trim($value)));
     return true;
 }
 /**
  * Rebuilds entry data.
  * 
  * @param	array<integer>		$entryIDs
  */
 public static function rebuildEntryData(array $entryIDs)
 {
     $conditionBuilder = new PreparedStatementConditionBuilder();
     $conditionBuilder->add('entryID IN (?)', array($entryIDs));
     $sql = "UPDATE\tfilebase" . WCF_N . "_entry entry\n\t\t\tSET\tfiles = IF(entry.isDeleted = 0 AND entry.isDisabled = 0, (\n\t\t\t\t\tSELECT\t\tCOUNT(*)\n\t\t\t\t\tFROM\t\tfilebase" . WCF_N . "_file\n\t\t\t\t\tWHERE\t\tentryID = entry.entryID\n\t\t\t\t\t\t\tAND isDisabled = 0\n\t\t\t\t\t\t\tAND isDeleted = 0\n\t\t\t\t), 0),\n                \n                lastFileID = COALESCE((\n\t\t\t\t\tSELECT\t\tfileID\n\t\t\t\t\tFROM\t\tfilebase" . WCF_N . "_file\n\t\t\t\t\tWHERE\t\tentryID = entry.entryID\n\t\t\t\t\t\t\tAND isDisabled = entry.isDisabled\n\t\t\t\t\t\t\tAND isDeleted = entry.isDeleted\n\t\t\t\t\tORDER BY\ttime DESC\n\t\t\t\t\tLIMIT\t\t1\n\t\t\t\t), lastFileID)\n\t\t\t" . $conditionBuilder;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($conditionBuilder->getParameters());
 }
예제 #28
0
 /**
  * @see	\wcf\system\option\ISearchableUserOption::getCondition()
  */
 public function getCondition(PreparedStatementConditionBuilder &$conditions, Option $option, $value)
 {
     $value = intval($value);
     if (!$value) {
         return false;
     }
     $conditions->add("option_value.userOption" . $option->optionID . " = ?", array(1));
     return true;
 }
예제 #29
0
 /**
  * Deletes active sessions of the given users.
  * 
  * @param	array<integer>	$userIDs
  */
 public static function deleteUserSessions(array $userIDs = array())
 {
     $conditionBuilder = new PreparedStatementConditionBuilder();
     if (!empty($userIDs)) {
         $conditionBuilder->add('userID IN (?)', array($userIDs));
     }
     $sql = "DELETE FROM\t" . call_user_func(array(static::$baseClass, 'getDatabaseTableName')) . "\n\t\t\t" . $conditionBuilder;
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($conditionBuilder->getParameters());
 }
예제 #30
0
 /**
  * @see wcf\system\cache\ICacheBuilder::getData()
  */
 public function getData(array $cacheResource)
 {
     // get next execution time
     $conditionBuilder = new PreparedStatementConditionBuilder();
     $conditionBuilder->add("packageID IN (?)", array(PackageDependencyHandler::getInstance()->getDependencies()));
     $sql = "SELECT\t\tMIN(nextExec) AS nextExec,\n\t\t\t\t\tMIN(afterNextExec) AS afterNextExec\n\t\t\tFROM\t\twcf" . WCF_N . "_cronjob\n\t\t\t" . $conditionBuilder->__toString();
     $statement = WCF::getDB()->prepareStatement($sql);
     $statement->execute($conditionBuilder->getParameters());
     $row = $statement->fetchArray();
     return array('afterNextExec' => $row['afterNextExec'], 'nextExec' => $row['nextExec']);
 }