From 615a0a96618fa99e7e452523145d6c0f238d4473 Mon Sep 17 00:00:00 2001 From: tbrehm <t.brehm@ispconfig.org> Date: Wed, 31 Jul 2013 09:33:43 -0400 Subject: [PATCH] Merged revisions 3960-4065 from stable branch. --- interface/web/sites/aps_availablepackages_list.php | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/interface/web/sites/aps_availablepackages_list.php b/interface/web/sites/aps_availablepackages_list.php index 3e3b83b..0966df9 100644 --- a/interface/web/sites/aps_availablepackages_list.php +++ b/interface/web/sites/aps_availablepackages_list.php @@ -42,10 +42,10 @@ // Load needed classes $app->uses('tpl,listform_actions'); -$app->listform_actions->SQLOrderBy = 'ORDER BY name, version'; +$app->listform_actions->SQLOrderBy = 'ORDER BY aps_packages.name, aps_packages.version'; // Show only unlocked packages to clients and (un-)lockable packages to admins -if($_SESSION['s']['user']['typ'] != 'admin') $app->listform_actions->SQLExtWhere = 'package_status = '.PACKAGE_ENABLED; -else $app->listform_actions->SQLExtWhere = '(package_status = '.PACKAGE_ENABLED.' OR package_status = '.PACKAGE_LOCKED.')'; +if($_SESSION['s']['user']['typ'] != 'admin') $app->listform_actions->SQLExtWhere = 'aps_packages.package_status = '.PACKAGE_ENABLED; +else $app->listform_actions->SQLExtWhere = '(aps_packages.package_status = '.PACKAGE_ENABLED.' OR aps_packages.package_status = '.PACKAGE_LOCKED.')'; // Get package amount $pkg_count = $app->db->queryOneRecord("SELECT COUNT(*) FROM aps_packages"); -- Gitblit v1.9.1