- Fixed: solved an issue were databases of aps instances were not deleted c...

mcramer

2013-08-12 18fbae89570b414ea08a0011a35cc4a4c97a5948

- Fixed: solved an issue were databases of aps instances were not deleted correctly.

 interface/lib/classes/aps_guicontroller.inc.php

@@ -351,7 +351,7 @@
        $app->db->datalogSave('aps', 'DELETE', 'id', $instanceid, array(), $datalog);

        */

        

        $sql = "SELECT web_database.database_id as database_id, web_database.database_user_id as `database_user_id` FROM aps_instances_settings, web_database WHERE aps_instances_settings.value = web_database.database_name AND aps_instances_settings.value =  aps_instances_settings.name = 'main_database_name' AND aps_instances_settings.instance_id = ".$instanceid." LIMIT 0,1";

        $sql = "SELECT web_database.database_id as database_id, web_database.database_user_id as `database_user_id` FROM aps_instances_settings, web_database WHERE aps_instances_settings.value = web_database.database_name AND aps_instances_settings.name = 'main_database_name' AND aps_instances_settings.instance_id = ".$instanceid." LIMIT 0,1";

        $tmp = $app->db->queryOneRecord($sql);

        if($tmp['database_id'] > 0) $app->db->datalogDelete('web_database', 'database_id', $tmp['database_id']);