[Phpgroupware-cvs] projects/inc class.soprojects.inc.php,1.106.2.1

[ceb]

Update of projects/inc

Modified Files:
     Branch: old_0_9_17_HEAD
            class.soprojects.inc.php lines: +4 -4

Log Message:
deleteaccount fix

====================================================
Index: projects/inc/class.soprojects.inc.php
diff -u projects/inc/class.soprojects.inc.php:1.106 
projects/inc/class.soprojects.inc.php:1.106.2.1
--- projects/inc/class.soprojects.inc.php:1.106 Fri Nov 12 15:51:47 2004
+++ projects/inc/class.soprojects.inc.php       Sun Aug 21 23:22:15 2005
@@ -982,11 +982,11 @@
                        {
                                $this->db->query('delete from phpgw_categories 
where cat_owner=' . $account_id . " AND 
cat_appname='projects'",__LINE__,__FILE__);
                                $this->db->query('delete from phpgw_p_hours 
where employee=' . $account_id,__LINE__,__FILE__);
-                               $this->db->query('select id from 
phpgw_p_projects where coordinator=' . $account_id,__LINE__,__FILE__);
+                               $this->db->query('select project_id from 
phpgw_p_projects where coordinator=' . $account_id,__LINE__,__FILE__);

                                while ($this->db->next_record())
                                {
-                                       $drop_list[] = $this->db->f('id');
+                                       $drop_list[] = 
$this->db->f('project_id');
                                }

                                if (is_array($drop_list))
@@ -997,7 +997,7 @@

                                        $subdelete = ' OR parent in (' . 
implode(',',$drop_list) . ')';

-                                       $this->db->query('DELETE from 
phpgw_p_projects where id project_in (' . implode(',',$drop_list) . ')'
+                                       $this->db->query('DELETE from 
phpgw_p_projects where project_id project_in (' . implode(',',$drop_list) . ')'
                                                                        . 
$subdelete,__LINE__,__FILE__);

                                        $this->db->query('select id from 
phpgw_p_delivery where project_id in (' . implode(',',$drop_list) . 
')',__LINE__,__FILE__);