2 namespace wcf\system\package
;
3 use wcf\system\style\StyleHandler
;
5 use wcf\data\application\Application
;
6 use wcf\data\application\ApplicationEditor
;
7 use wcf\data\language\category\LanguageCategory
;
8 use wcf\data\language\LanguageEditor
;
9 use wcf\data\language\LanguageList
;
10 use wcf\data\option\OptionEditor
;
11 use wcf\data\package\installation\queue\PackageInstallationQueue
;
12 use wcf\data\package\installation\queue\PackageInstallationQueueEditor
;
13 use wcf\data\package\Package
;
14 use wcf\data\package\PackageEditor
;
15 use wcf\system\application\ApplicationHandler
;
16 use wcf\system\cache\CacheHandler
;
17 use wcf\system\database\statement\PreparedStatement
;
18 use wcf\system\database\util\PreparedStatementConditionBuilder
;
19 use wcf\system\exception\SystemException
;
20 use wcf\system\form\container
;
21 use wcf\system\form\element
;
22 use wcf\system\form\FormDocument
;
24 use wcf\system\language\LanguageFactory
;
25 use wcf\system\package\plugin\IPackageInstallationPlugin
;
26 use wcf\system\package\plugin\ObjectTypePackageInstallationPlugin
;
27 use wcf\system\package\plugin\SQLPackageInstallationPlugin
;
28 use wcf\system\request\LinkHandler
;
29 use wcf\system\request\RouteHandler
;
31 use wcf\util\FileUtil
;
32 use wcf\util\HeaderUtil
;
33 use wcf\util\StringUtil
;
36 * PackageInstallationDispatcher handles the whole installation process.
38 * @author Alexander Ebert
39 * @copyright 2001-2012 WoltLab GmbH
40 * @license GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
41 * @package com.woltlab.wcf
42 * @subpackage system.package
43 * @category Community Framework
45 class PackageInstallationDispatcher
{
47 * current installation type
50 protected $action = '';
53 * instance of PackageArchive
54 * @var wcf\system\package\PackageArchive
56 public $archive = null;
59 * instance of PackageInstallationNodeBuilder
60 * @var wcf\system\package\PackageInstallationNodeBuilder
62 public $nodeBuilder = null;
66 * @var wcf\data\package\Package
68 public $package = null;
71 * instance of PackageInstallationQueue
72 * @var wcf\system\package\PackageInstallationQueue
77 * default name of the config file
80 const CONFIG_FILE
= 'config.inc.php';
83 * holds state of structuring version tables
86 protected $requireRestructureVersionTables = false;
89 * Creates a new instance of PackageInstallationDispatcher.
91 * @param wcf\data\package\installation\queue\PackageInstallationQueue $queue
93 public function __construct(PackageInstallationQueue
$queue) {
94 $this->queue
= $queue;
95 $this->nodeBuilder
= new PackageInstallationNodeBuilder($this);
97 $this->action
= $this->queue
->action
;
101 * Installs node components and returns next node.
103 * @param string $node
104 * @return wcf\system\package\PackageInstallationStep
106 public function install($node) {
107 $nodes = $this->nodeBuilder
->getNodeData($node);
109 // invoke node-specific actions
110 foreach ($nodes as $data) {
111 $nodeData = unserialize($data['nodeData']);
113 switch ($data['nodeType']) {
115 $step = $this->installPackage($nodeData);
119 $step = $this->executePIP($nodeData);
122 case 'optionalPackages':
123 $step = $this->selectOptionalPackages($node, $nodeData);
127 die("Unknown node type: '".$data['nodeType']."'");
131 if ($step->splitNode()) {
132 $this->nodeBuilder
->cloneNode($node, $data['sequenceNo']);
137 // mark node as completed
138 $this->nodeBuilder
->completeNode($node);
141 $node = $this->nodeBuilder
->getNextNode($node);
142 $step->setNode($node);
144 // perform post-install/update actions
146 // update options.inc.php
147 OptionEditor
::resetCache();
149 if ($this->action
== 'install') {
150 // save localized package infos
151 $this->saveLocalizedPackageInfos();
153 // remove all cache files after WCFSetup
155 CacheHandler
::getInstance()->clear(WCF_DIR
.'cache/', 'cache.*.php');
158 // rebuild application paths
159 ApplicationHandler
::rebuild();
160 ApplicationEditor
::setup();
163 // remove template listener cache
164 CacheHandler
::getInstance()->clear(WCF_DIR
.'cache/templateListener/', '*.php');
166 // reset language cache
167 LanguageFactory
::getInstance()->clearCache();
168 LanguageFactory
::getInstance()->deleteLanguageCache();
171 StyleHandler
::resetStylesheets();
174 if ($this->requireRestructureVersionTables
) {
175 $this->restructureVersionTables();
182 * Returns current package archive.
184 * @return wcf\system\package\PackageArchive
186 public function getArchive() {
187 if ($this->archive
=== null) {
188 $this->archive
= new PackageArchive($this->queue
->archive
, $this->getPackage());
190 if (FileUtil
::isURL($this->archive
->getArchive())) {
191 // get return value and update entry in
192 // package_installation_queue with this value
193 $archive = $this->archive
->downloadArchive();
194 $queueEditor = new PackageInstallationQueueEditor($this->queue
);
195 $queueEditor->update(array(
196 'archive' => $archive
200 $this->archive
->openArchive();
203 return $this->archive
;
207 * Installs current package.
209 * @param array $nodeData
211 protected function installPackage(array $nodeData) {
212 $installationStep = new PackageInstallationStep();
214 // check requirements
215 if (!empty($nodeData['requirements'])) {
216 foreach ($nodeData['requirements'] as $package => $requirementData) {
217 // get existing package
218 if ($requirementData['packageID']) {
219 $sql = "SELECT packageName, packageVersion
220 FROM wcf".WCF_N
."_package
221 WHERE packageID = ?";
222 $statement = WCF
::getDB()->prepareStatement($sql);
223 $statement->execute(array($requirementData['packageID']));
226 // try to find matching package
227 $sql = "SELECT packageName, packageVersion
228 FROM wcf".WCF_N
."_package
230 $statement = WCF
::getDB()->prepareStatement($sql);
231 $statement->execute(array($package));
233 $row = $statement->fetchArray();
235 // package is required but not available
236 if ($row === false) {
237 throw new SystemException("Package '".$package."' is required by '".$nodeData['packageName']."', but is neither installed nor shipped.");
240 // check version requirements
241 if ($requirementData['minVersion']) {
242 if (Package
::compareVersion($row['packageVersion'], $requirementData['minVersion']) < 0) {
243 throw new SystemException("Package '".$nodeData['packageName']."' requires the package '".$row['packageName']."' in version '".$requirementData['minVersion']."', but version '".$row['packageVersion']."'");
248 unset($nodeData['requirements']);
250 if (!$this->queue
->packageID
) {
251 // create package entry
252 $package = PackageEditor
::create($nodeData);
254 // update package id for current queue
255 $queueEditor = new PackageInstallationQueueEditor($this->queue
);
256 $queueEditor->update(array(
257 'packageID' => $package->packageID
260 // save excluded packages
261 if (count($this->getArchive()->getExcludedPackages()) > 0) {
262 $sql = "INSERT INTO wcf".WCF_N
."_package_exclusion
263 (packageID, excludedPackage, excludedPackageVersion)
265 $statement = WCF
::getDB()->prepareStatement($sql);
267 foreach ($this->getArchive()->getExcludedPackages() as $excludedPackage) {
268 $statement->execute(array($package->packageID
, $excludedPackage['name'], (!empty($excludedPackage['version']) ?
$excludedPackage['version'] : '')));
272 // if package is plugin to com.woltlab.wcf it must not have any other requirement
273 $requirements = $this->getArchive()->getRequirements();
275 // insert requirements and dependencies
276 $requirements = $this->getArchive()->getAllExistingRequirements();
277 if (!empty($requirements)) {
278 $sql = "INSERT INTO wcf".WCF_N
."_package_requirement
279 (packageID, requirement)
281 $statement = WCF
::getDB()->prepareStatement($sql);
283 foreach ($requirements as $identifier => $possibleRequirements) {
284 if (count($possibleRequirements) == 1) {
285 $requirement = array_shift($possibleRequirements);
288 $requirement = $possibleRequirements[$this->selectedRequirements
[$identifier]];
291 $statement->execute(array($package->packageID
, $requirement['packageID']));
295 // build requirement map
296 Package
::rebuildPackageRequirementMap($package->packageID
);
299 $this->queue
= new PackageInstallationQueue($this->queue
->queueID
);
300 $this->package
= null;
302 if ($package->isApplication
) {
303 $host = StringUtil
::replace(RouteHandler
::getProtocol(), '', RouteHandler
::getHost());
304 $path = RouteHandler
::getPath(array('acp'));
306 // insert as application
307 ApplicationEditor
::create(array(
308 'domainName' => $host,
309 'domainPath' => $path,
310 'cookieDomain' => $host,
311 'cookiePath' => $path,
312 'packageID' => $package->packageID
317 if ($this->getPackage()->isApplication
&& $this->getPackage()->package
!= 'com.woltlab.wcf' && $this->getAction() == 'install') {
318 if (empty($this->getPackage()->packageDir
)) {
319 $document = $this->promptPackageDir();
320 if ($document !== null && $document instanceof form\FormDocument
) {
321 $installationStep->setDocument($document);
324 $installationStep->setSplitNode();
328 return $installationStep;
332 * Saves the localized package infos.
334 * @todo license and readme
336 protected function saveLocalizedPackageInfos() {
337 $package = new Package($this->queue
->packageID
);
339 // localize package information
340 $sql = "INSERT INTO wcf".WCF_N
."_language_item
341 (languageID, languageItem, languageItemValue, languageCategoryID, packageID)
342 VALUES (?, ?, ?, ?, ?)";
343 $statement = WCF
::getDB()->prepareStatement($sql);
346 $languageList = new LanguageList();
347 $languageList->sqlLimit
= 0;
348 $languageList->readObjects();
350 // workaround for WCFSetup
353 FROM wcf".WCF_N
."_language_category
354 WHERE languageCategory = ?";
355 $statement2 = WCF
::getDB()->prepareStatement($sql);
356 $statement2->execute(array('wcf.acp.package'));
357 $languageCategory = $statement2->fetchObject('wcf\data\language\category\LanguageCategory');
360 $languageCategory = LanguageFactory
::getInstance()->getCategory('wcf.acp.package');
364 $this->saveLocalizedPackageInfo($statement, $languageList, $languageCategory, $package, 'packageName');
366 // save package description
367 $this->saveLocalizedPackageInfo($statement, $languageList, $languageCategory, $package, 'packageDescription');
369 // update description and name
370 $packageEditor = new PackageEditor($package);
371 $packageEditor->update(array(
372 'packageDescription' => 'wcf.acp.package.packageDescription.package'.$this->queue
->packageID
,
373 'packageName' => 'wcf.acp.package.packageName.package'.$this->queue
->packageID
378 * Saves a localized package info.
380 * @param wcf\system\database\statement\PreparedStatement $statement
381 * @param wcf\data\language\LanguageList $languageList
382 * @param wcf\data\language\category\LanguageCategory $languageCategory
383 * @param wcf\data\package\Package $package
384 * @param string $infoName
386 protected function saveLocalizedPackageInfo(PreparedStatement
$statement, $languageList, LanguageCategory
$languageCategory, Package
$package, $infoName) {
387 $infoValues = $this->getArchive()->getPackageInfo($infoName);
389 // get default value for languages without specified information
391 if (isset($infoValues['default'])) {
392 $defaultValue = $infoValues['default'];
394 else if (isset($infoValues['en'])) {
395 // fallback to English
396 $defaultValue = $infoValues['en'];
398 else if (isset($infoValues[WCF
::getLanguage()->getFixedLanguageCode()])) {
399 // fallback to the language of the current user
400 $defaultValue = $infoValues[WCF
::getLanguage()->getFixedLanguageCode()];
402 else if ($infoName == 'packageName') {
403 // fallback to the package identifier for the package name
404 $defaultValue = $this->archive
->getPackageInfo('name');
407 foreach ($languageList as $language) {
408 $value = $defaultValue;
409 if (isset($infoValues[$language->languageCode
])) {
410 $value = $infoValues[$language->languageCode
];
413 $statement->execute(array(
414 $language->languageID
,
415 'wcf.acp.package.'.$infoName.'.package'.$package->packageID
,
417 $languageCategory->languageCategoryID
,
424 * Executes a package installation plugin.
429 protected function executePIP(array $nodeData) {
430 $step = new PackageInstallationStep();
432 // fetch all pips associated with current PACKAGE_ID and include pips
433 // previously installed by current installation queue
434 $sql = "SELECT pluginName, className
435 FROM wcf".WCF_N
."_package_installation_plugin
436 WHERE pluginName = ?";
437 $statement = WCF
::getDB()->prepareStatement($sql);
438 $statement->execute(array(
441 $row = $statement->fetchArray();
444 if (!$row ||
(strcmp($nodeData['pip'], $row['pluginName']) !== 0)) {
445 throw new SystemException("unable to find package installation plugin '".$nodeData['pip']."'");
448 // valdidate class definition
449 $className = $row['className'];
450 if (!class_exists($className)) {
451 throw new SystemException("unable to find class '".$className."'");
454 $plugin = new $className($this, $nodeData);
456 if (!($plugin instanceof IPackageInstallationPlugin
)) {
457 throw new SystemException("'".$className."' does not implement 'wcf\system\package\plugin\IPackageInstallationPlugin'");
460 if ($plugin instanceof SQLPackageInstallationPlugin ||
$plugin instanceof ObjectTypePackageInstallationPlugin
) {
461 $this->requireRestructureVersionTables
= true;
466 $document = $plugin->{$this->action
}();
468 catch (SplitNodeException
$e) {
469 $step->setSplitNode();
472 if ($document !== null && ($document instanceof FormDocument
)) {
473 $step->setDocument($document);
474 $step->setSplitNode();
481 protected function selectOptionalPackages($currentNode, array $nodeData) {
482 $installationStep = new PackageInstallationStep();
484 $document = $this->promptOptionalPackages($nodeData);
485 if ($document !== null && $document instanceof form\FormDocument
) {
486 $installationStep->setDocument($document);
487 $installationStep->setSplitNode();
489 // insert new nodes for each package
490 else if (is_array($document)) {
491 // get target child node
492 $node = $currentNode;
493 $queue = $this->queue
;
496 foreach ($nodeData as $package) {
497 if (in_array($package['package'], $document)) {
499 $this->nodeBuilder
->shiftNodes($currentNode, 'tempNode');
503 $queue = PackageInstallationQueueEditor
::create(array(
504 'parentQueueID' => $queue->queueID
,
505 'processNo' => $this->queue
->processNo
,
506 'userID' => WCF
::getUser()->userID
,
507 'package' => $package['package'],
508 'packageName' => $package['packageName'],
509 'archive' => $package['archive'],
510 'action' => $queue->action
513 $installation = new PackageInstallationDispatcher($queue);
514 $installation->nodeBuilder
->setParentNode($node);
515 $installation->nodeBuilder
->buildNodes();
516 $node = $installation->nodeBuilder
->getCurrentNode();
522 $this->nodeBuilder
->shiftNodes('tempNode', $node);
526 return $installationStep;
530 * Extracts files from .tar (or .tar.gz) archive and installs them
532 * @param string $targetDir
533 * @param string $sourceArchive
534 * @param FileHandler $fileHandler
535 * @return wcf\system\setup\Installer
537 public function extractFiles($targetDir, $sourceArchive, $fileHandler = null) {
538 return new \wcf\system\setup\
Installer($targetDir, $sourceArchive, $fileHandler);
542 * Returns current package.
544 * @return wcf\data\package\Package
546 public function getPackage() {
547 if ($this->package
=== null) {
548 $this->package
= new Package($this->queue
->packageID
);
551 return $this->package
;
555 * Prompts for a text input for package directory (applies for applications only)
557 * @return wcf\system\form\FormDocument
559 protected function promptPackageDir() {
560 if (!PackageInstallationFormManager
::findForm($this->queue
, 'packageDir')) {
562 $container = new container\
GroupFormElementContainer();
563 $packageDir = new element\
TextInputFormElement($container);
564 $packageDir->setName('packageDir');
565 $packageDir->setLabel(WCF
::getLanguage()->get('wcf.acp.package.packageDir.input'));
567 $path = RouteHandler
::getPath(array('wcf', 'acp'));
568 $defaultPath = FileUtil
::addTrailingSlash(FileUtil
::unifyDirSeperator($_SERVER['DOCUMENT_ROOT'] . $path));
569 $packageDir->setValue($defaultPath);
570 $container->appendChild($packageDir);
572 $document = new form\
FormDocument('packageDir');
573 $document->appendContainer($container);
575 PackageInstallationFormManager
::registerForm($this->queue
, $document);
579 $document = PackageInstallationFormManager
::getForm($this->queue
, 'packageDir');
580 $document->handleRequest();
581 $packageDir = $document->getValue('packageDir');
583 if ($packageDir !== null) {
584 // validate package dir
585 if (file_exists(FileUtil
::addTrailingSlash($packageDir) . 'global.php')) {
586 $document->setError('packageDir', WCF
::getLanguage()->get('wcf.acp.package.packageDir.notAvailable'));
591 $packageEditor = new PackageEditor($this->getPackage());
592 $packageEditor->update(array(
593 'packageDir' => FileUtil
::getRelativePath(WCF_DIR
, $packageDir)
597 $domainPath = FileUtil
::getRelativePath(FileUtil
::unifyDirSeperator($_SERVER['DOCUMENT_ROOT']), FileUtil
::unifyDirSeperator($packageDir));
599 // work-around for applications installed in document root
600 if ($domainPath == './') {
604 $domainPath = FileUtil
::addLeadingSlash(FileUtil
::addTrailingSlash($domainPath));
606 // update application path
607 $application = new Application($this->getPackage()->packageID
);
608 $applicationEditor = new ApplicationEditor($application);
609 $applicationEditor->update(array(
610 'domainPath' => $domainPath,
611 'cookiePath' => $domainPath
614 // create directory and set permissions
615 @mkdir
($packageDir, 0777, true);
616 @chmod
($packageDir, 0777);
624 protected function promptOptionalPackages(array $packages) {
625 if (!PackageInstallationFormManager
::findForm($this->queue
, 'optionalPackages')) {
626 $container = new container\
MultipleSelectionFormElementContainer();
627 $container->setName('optionalPackages');
629 foreach ($packages as $package) {
630 $optionalPackage = new element\
MultipleSelectionFormElement($container);
631 $optionalPackage->setName('optionalPackages');
632 $optionalPackage->setLabel($package['packageName']);
633 $optionalPackage->setValue($package['package']);
635 $container->appendChild($optionalPackage);
638 $document = new form\
FormDocument('optionalPackages');
639 $document->appendContainer($container);
641 PackageInstallationFormManager
::registerForm($this->queue
, $document);
645 $document = PackageInstallationFormManager
::getForm($this->queue
, 'optionalPackages');
646 $document->handleRequest();
648 return $document->getValue('optionalPackages');
653 * Returns current package id.
657 public function getPackageID() {
658 return $this->queue
->packageID
;
662 * Returns current package installation type.
666 public function getAction() {
667 return $this->action
;
671 * Opens the package installation queue and
672 * starts the installation, update or uninstallation of the first entry.
674 * @param integer $parentQueueID
675 * @param integer $processNo
677 public static function openQueue($parentQueueID = 0, $processNo = 0) {
678 $conditions = new PreparedStatementConditionBuilder();
679 $conditions->add("userID = ?", array(WCF
::getUser()->userID
));
680 $conditions->add("parentQueueID = ?", array($parentQueueID));
681 if ($processNo != 0) $conditions->add("processNo = ?", array($processNo));
682 $conditions->add("done = ?", array(0));
685 FROM wcf".WCF_N
."_package_installation_queue
687 ORDER BY queueID ASC";
688 $statement = WCF
::getDB()->prepareStatement($sql);
689 $statement->execute($conditions->getParameters());
690 $packageInstallation = $statement->fetchArray();
692 if (!isset($packageInstallation['queueID'])) {
693 $url = LinkHandler
::getInstance()->getLink('PackageList');
694 HeaderUtil
::redirect($url);
698 $url = LinkHandler
::getInstance()->getLink('PackageInstallationConfirm', array(), 'action='.$packageInstallation['action'].'&queueID='.$packageInstallation['queueID']);
699 HeaderUtil
::redirect($url);
705 * Checks the package installation queue for outstanding entries.
709 public static function checkPackageInstallationQueue() {
710 $sql = "SELECT queueID
711 FROM wcf".WCF_N
."_package_installation_queue
713 AND parentQueueID = 0
715 ORDER BY queueID ASC";
716 $statement = WCF
::getDB()->prepareStatement($sql);
717 $statement->execute(array(WCF
::getUser()->userID
));
718 $row = $statement->fetchArray();
724 return $row['queueID'];
728 * Executes post-setup actions.
730 public function completeSetup() {
731 // mark queue as done
732 $queueEditor = new PackageInstallationQueueEditor($this->queue
);
733 $queueEditor->update(array(
738 $this->nodeBuilder
->purgeNodes();
740 // update package version
741 if ($this->action
== 'update') {
742 $packageEditor = new PackageEditor($this->getPackage());
743 $packageEditor->update(array(
744 'updateDate' => TIME_NOW
,
745 'packageVersion' => $this->archive
->getPackageInfo('version')
749 // clear language files once whole installation is completed
750 LanguageEditor
::deleteLanguageFiles();
753 CacheHandler
::getInstance()->clear(WCF_DIR
.'cache/', '*');
757 * Updates queue information.
759 public function updatePackage() {
760 if (empty($this->queue
->packageName
)) {
761 $queueEditor = new PackageInstallationQueueEditor($this->queue
);
762 $queueEditor->update(array(
763 'packageName' => $this->getArchive()->getLocalizedPackageInfo('packageName')
767 $this->queue
= new PackageInstallationQueue($this->queue
->queueID
);
772 * Validates specific php requirements.
774 * @param array $requirements
775 * @return array<array>
777 public static function validatePHPRequirements(array $requirements) {
780 // validate php version
781 if (isset($requirements['version'])) {
783 if (version_compare(PHP_VERSION
, $requirements['version'], '>=')) {
788 $errors['version'] = array(
789 'required' => $requirements['version'],
790 'installed' => PHP_VERSION
795 // validate extensions
796 if (isset($requirements['extensions'])) {
797 foreach ($requirements['extensions'] as $extension) {
798 $passed = (extension_loaded($extension)) ?
true : false;
801 $errors['extension'][] = array(
802 'extension' => $extension
809 if (isset($requirements['settings'])) {
810 foreach ($requirements['settings'] as $setting => $value) {
811 $iniValue = ini_get($setting);
813 $passed = self
::compareSetting($setting, $value, $iniValue);
815 $errors['setting'][] = array(
816 'setting' => $setting,
817 'required' => $value,
818 'installed' => ($iniValue === false) ?
'(unknown)' : $iniValue
824 // validate functions
825 if (isset($requirements['functions'])) {
826 foreach ($requirements['functions'] as $function) {
827 $function = StringUtil
::toLowerCase($function);
829 $passed = self
::functionExists($function);
831 $errors['function'][] = array(
832 'function' => $function
839 if (isset($requirements['classes'])) {
840 foreach ($requirements['classes'] as $class) {
843 // see: http://de.php.net/manual/en/language.oop5.basic.php
844 if (preg_match('~[a-zA-Z_\x7f-\xff][a-zA-Z0-9_\x7f-\xff]*.~', $class)) {
845 $globalClass = '\\'.$class;
847 if (class_exists($globalClass, false)) {
853 $errors['class'][] = array(
865 * Validates if an function exists and is not blacklisted by suhosin extension.
867 * @param string $function
869 * @see http://de.php.net/manual/en/function.function-exists.php#77980
871 protected static function functionExists($function) {
872 if (extension_loaded('suhosin')) {
873 $blacklist = @ini_get
('suhosin.executor.func.blacklist');
874 if (!empty($blacklist)) {
875 $blacklist = explode(',', $blacklist);
876 foreach ($blacklist as $disabledFunction) {
877 $disabledFunction = StringUtil
::toLowerCase(StringUtil
::trim($disabledFunction));
879 if ($function == $disabledFunction) {
886 return function_exists($function);
890 * Compares settings, converting values into compareable ones.
892 * @param string $setting
893 * @param string $value
894 * @param mixed $compareValue
897 protected static function compareSetting($setting, $value, $compareValue) {
898 if ($compareValue === false) return false;
900 $value = StringUtil
::toLowerCase($value);
901 $trueValues = array('1', 'on', 'true');
902 $falseValues = array('0', 'off', 'false');
904 // handle values considered as 'true'
905 if (in_array($value, $trueValues)) {
906 return ($compareValue) ?
true : false;
908 // handle values considered as 'false'
909 else if (in_array($value, $falseValues)) {
910 return (!$compareValue) ?
true : false;
912 else if (!is_numeric($value)) {
913 $compareValue = self
::convertShorthandByteValue($compareValue);
914 $value = self
::convertShorthandByteValue($value);
917 return ($compareValue >= $value) ?
true : false;
921 * Converts shorthand byte values into an integer representing bytes.
923 * @param string $value
925 * @see http://www.php.net/manual/en/faq.using.php#faq.using.shorthandbytes
927 protected static function convertShorthandByteValue($value) {
928 // convert into bytes
929 $lastCharacter = StringUtil
::substring($value, -1);
930 switch ($lastCharacter) {
933 return (int)$value * 1073741824;
938 return (int)$value * 1048576;
943 return (int)$value * 1024;
953 * Restructure version tables.
955 protected function restructureVersionTables() {
956 $objectTypes = \wcf\system\version\VersionHandler
::getInstance()->getObjectTypes();
958 if (empty($objectTypes)) {
962 // base structure of version tables
963 $versionTableBaseColumns = array();
964 $versionTableBaseColumns[] = array('name' => 'versionID', 'data' => array('type' => 'INT', 'key' => 'PRIMARY', 'autoIncrement' => 'AUTO_INCREMENT'));
965 $versionTableBaseColumns[] = array('name' => 'versionUserID', 'data' => array('type' => 'INT'));
966 $versionTableBaseColumns[] = array('name' => 'versionUsername', 'data' => array('type' => 'VARCHAR', 'length' => 255));
967 $versionTableBaseColumns[] = array('name' => 'versionTime', 'data' => array('type' => 'INT'));
969 foreach ($objectTypes as $objectTypeID => $objectType) {
970 // get structure of base table
971 $baseTableColumns = WCF
::getDB()->getEditor()->getColumns($objectType::getDatabaseTableName());
972 // get structure of version table
973 $versionTableColumns = WCF
::getDB()->getEditor()->getColumns($objectType::getDatabaseVersionTableName());
975 if (empty($versionTableColumns)){
976 $columns = array_merge($versionTableBaseColumns, $baseTableColumns);
978 WCF
::getDB()->getEditor()->createTable($objectType::getDatabaseVersionTableName(), $columns);
981 // check garbage columns in versioned table
982 foreach ($versionTableColumns as $columnData) {
983 if (!array_search($columnData['name'], $baseTableColumns, true)) {
985 WCF
::getDB()->getEditor()->dropColumn($objectType::getDatabaseVersionTableName(), $columnData['name']);
989 // check new columns for versioned table
990 foreach ($baseTableColumns as $columnData) {
991 if (!array_search($columnData['name'], $versionTableColumns, true)) {
993 WCF
::getDB()->getEditor()->addColumn($objectType::getDatabaseVersionTableName(), $columnData['name'], $columnData['data']);