Marius Cramer
2013-10-14 d9bcf68e395d6156645a7974b1a992aa6e6c00aa
interface/web/sites/aps_installedpackages_list.php
@@ -52,7 +52,8 @@
if(!$is_admin)
{
    $cid = $app->db->queryOneRecord('SELECT client_id FROM client WHERE username = "'.$app->db->quote($_SESSION['s']['user']['username']).'";');
    $client_ext = ' AND aps_instances.customer_id = '.$cid['client_id'];
    //$client_ext = ' AND aps_instances.customer_id = '.$cid['client_id'];
   $client_ext = ' AND '.$app->tform->getAuthSQL('r', 'aps_instances');
}
$app->listform_actions->SQLExtWhere = 'aps_instances.package_id = aps_packages.id'.$client_ext;
$app->listform_actions->SQLOrderBy = 'ORDER BY package_name';
@@ -89,7 +90,7 @@
                 aps_instances.instance_status AS instance_status, aps_packages.name AS package_name, 
                 aps_packages.version AS package_version, aps_packages.release AS package_release, 
                 aps_packages.package_status AS package_status, 
              CONCAT ((SELECT value FROM aps_instances_settings WHERE name='main_domain' AND instance_id = aps_instances.id),
              CONCAT((SELECT value FROM aps_instances_settings WHERE name='main_domain' AND instance_id = aps_instances.id),
                 '/', (SELECT value FROM aps_instances_settings WHERE name='main_location' AND instance_id = aps_instances.id)) 
                  AS install_location  
          FROM aps_instances, aps_packages, client 
@@ -100,7 +101,7 @@
             aps_instances.instance_status AS instance_status, aps_packages.name AS package_name, 
                 aps_packages.version AS package_version, aps_packages.release AS package_release, 
                 aps_packages.package_status AS package_status, 
              CONCAT ((SELECT value FROM aps_instances_settings WHERE name='main_domain' AND instance_id = aps_instances.id),
              CONCAT((SELECT value FROM aps_instances_settings WHERE name='main_domain' AND instance_id = aps_instances.id),
                 '/', (SELECT value FROM aps_instances_settings WHERE name='main_location' AND instance_id = aps_instances.id)) 
                  AS install_location  
          FROM aps_instances, aps_packages, sys_group