From 37001c4e5b31127f92827ceaa0346cd4c31518bb Mon Sep 17 00:00:00 2001 From: Marcel Werk Date: Mon, 26 Sep 2011 18:48:28 +0200 Subject: [PATCH] Fixe some SQL syntax errors --- .../install/files/lib/system/package/PackageArchive.class.php | 2 +- .../system/package/PackageUninstallationNodeBuilder.class.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/wcfsetup/install/files/lib/system/package/PackageArchive.class.php b/wcfsetup/install/files/lib/system/package/PackageArchive.class.php index 1567c3f87b..a8f132aa67 100644 --- a/wcfsetup/install/files/lib/system/package/PackageArchive.class.php +++ b/wcfsetup/install/files/lib/system/package/PackageArchive.class.php @@ -809,7 +809,7 @@ class PackageArchive { FROM wcf".WCF_N."_package_exclusion package_exclusion LEFT JOIN wcf".WCF_N."_package package ON (package.packageID = package_exclusion.packageID) - WHERE excludedPackage = ?'".$this->packageInfo['name']."'"; + WHERE excludedPackage = ?"; $statement = WCF::getDB()->prepareStatement($sql); $statement->execute(array($this->packageInfo['name'])); while ($row = $statement->fetchArray()) { diff --git a/wcfsetup/install/files/lib/system/package/PackageUninstallationNodeBuilder.class.php b/wcfsetup/install/files/lib/system/package/PackageUninstallationNodeBuilder.class.php index e8966519fe..2068697562 100644 --- a/wcfsetup/install/files/lib/system/package/PackageUninstallationNodeBuilder.class.php +++ b/wcfsetup/install/files/lib/system/package/PackageUninstallationNodeBuilder.class.php @@ -36,7 +36,7 @@ class PackageUninstallationNodeBuilder extends PackageInstallationNodeBuilder { // fetch ordered pips $pips = array(); $sql = "SELECT pluginName, className, - CASE pluginName WHEN 'packageinstallationplugin' THEN 1 WHEN 'files' THEN 2 ELSE 0 END 'pluginOrder' + CASE pluginName WHEN 'packageinstallationplugin' THEN 1 WHEN 'files' THEN 2 ELSE 0 END AS pluginOrder FROM wcf".WCF_N."_package_installation_plugin ORDER BY pluginOrder, priority"; $statement = WCF::getDB()->prepareStatement($sql); -- 2.20.1