[Fmsystem-commits] [7471] API: delete choice for custom attrib on delete attrib

[Sigurd Nes]

Revision: 7471
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=7471
Author:   sigurdne
Date:     2011-07-04 13:37:47 +0000 (Mon, 04 Jul 2011)
Log Message:
-----------
API: delete choice for custom attrib on delete attrib

Modified Paths:
--------------
    trunk/phpgwapi/inc/class.custom_fields.inc.php

Modified: trunk/phpgwapi/inc/class.custom_fields.inc.php
===================================================================
--- trunk/phpgwapi/inc/class.custom_fields.inc.php      2011-07-04 07:36:43 UTC 
(rev 7470)
+++ trunk/phpgwapi/inc/class.custom_fields.inc.php      2011-07-04 13:37:47 UTC 
(rev 7471)
@@ -553,9 +553,15 @@
                                                . " WHERE location_id = 
{$loc_id} AND attrib_sort > {$attrib_sort} AND group_id = {$group_id}";
                                        $this->_db->query($sql, __LINE__, 
__FILE__);
                                }
+
+                               $sql = "DELETE FROM phpgw_cust_choice"
+                                               . " WHERE location_id = 
{$loc_id} AND attrib_id = {$attrib_id}";
+                               $this->_db->query($sql, __LINE__,__FILE__);
+
                                $sql = "DELETE FROM phpgw_cust_attribute"
                                                . " WHERE location_id = 
{$loc_id} AND id = {$attrib_id}";
                                $this->_db->query($sql, __LINE__,__FILE__);
+
                        }       
                        return $this->_db->transaction_commit();
                }