| | |
| | | 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';
|
| | |
| | | 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
|
| | |
| | | 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
|