[20872] Clean?\194?\160up?\194?\160locations, ?\194?\160custom?\194? \160fields?\194?\160and?\194?\160ACL on uninstall

Revision: 20872
          http://svn.sv.gnu.org/viewvc/?view=rev&root=phpgroupware&revision=20872
Author:   sigurdne
Date:     2009-11-21 11:01:46 +0000 (Sat, 21 Nov 2009)
Log Message:
-----------
Clean?\194?\160up?\194?\160locations,?\194?\160custom?\194?\160fields?\194?\160and?\194?\160ACL on uninstall

Modified Paths:
--------------
    people/sigurdne/modules/phpgwapi/trunk/inc/class.setup.inc.php

Modified: people/sigurdne/modules/phpgwapi/trunk/inc/class.setup.inc.php
===================================================================
--- people/sigurdne/modules/phpgwapi/trunk/inc/class.setup.inc.php	2009-11-21 10:43:36 UTC (rev 20871)
+++ people/sigurdne/modules/phpgwapi/trunk/inc/class.setup.inc.php	2009-11-21 11:01:46 UTC (rev 20872)
@@ -530,6 +530,28 @@
 			$appname = $this->db->db_addslashes($appname);
 			$setup_info =& $GLOBALS['setup_info'];
 
+			// Clean up locations, custom fields and ACL
+			$this->db->query("SELECT app_id FROM phpgw_applications WHERE app_name = '{$appname}'");
+			$this->db->next_record();
+			$app_id = $this->db->f('app_id');
+
+			$this->db->query("SELECT location_id FROM phpgw_locations WHERE app_id = {$app_id}");
+
+			$locations = array();
+			while ($this->db->next_record())
+			{
+				$locations[] = $this->db->f('location_id');
+			}
+
+			if(count($locations))
+			{
+				$this->db->query('DELETE FROM phpgw_cust_choice WHERE location_id IN ('. implode (',',$locations) . ')');
+				$this->db->query('DELETE FROM phpgw_cust_attribute WHERE location_id IN ('. implode (',',$locations). ')');
+				$this->db->query('DELETE FROM phpgw_acl  WHERE location_id IN ('. implode (',',$locations) . ')');
+			}
+
+			$this->db->query("DELETE FROM phpgw_locations WHERE app_id = {$app_id}");
+
 			//echo 'DELETING application: ' . $appname;
 			$this->db->query("DELETE FROM phpgw_applications WHERE app_name='{$appname}'",__LINE__,__FILE__);
 			$this->clear_session_cache();