[Phpgroupware-cvs] fudforum/inc class.ufud.inc.php,1.1.1.1.2.5

[ceb]

Update of fudforum/inc

Modified Files:
     Branch: Version-0_9_16-branch
            class.ufud.inc.php lines: +42 -8

Log Message:
update delete user

====================================================
Index: fudforum/inc/class.ufud.inc.php
diff -u fudforum/inc/class.ufud.inc.php:1.1.1.1.2.4 
fudforum/inc/class.ufud.inc.php:1.1.1.1.2.5
--- fudforum/inc/class.ufud.inc.php:1.1.1.1.2.4 Tue Jun 14 16:28:57 2005
+++ fudforum/inc/class.ufud.inc.php     Tue Jun 14 23:09:42 2005
@@ -107,30 +107,64 @@
                                return true;
                        }

-                       /* this doesnt work at all. $GLOBALS['hook_values'] is 
empty and $row is not an array */
-                       /*if(!is_array($row))
+                       /* this doesnt work at all. $GLOBALS['hook_values'] is 
empty and $row is not an array
+                       if(!is_array($row))
                        {
                                print_r($GLOBALS['hook_values']); // empty ????
                                $row['account_id'] = 
$GLOBALS['hook_values']['account_id'];
-                       }*/
-
+                       }
                        define('plain_page', 1);
                        require($GLOBALS['phpgw_info']['server']['files_dir'] . 
'/fudforum/include/GLOBALS.php');
-
                        fud_use('db.inc');
                        fud_use('private.inc');
                        fud_use('users_reg.inc');
                        fud_use('users_adm.inc',True);
+                       $id = q_singleval("SELECT id FROM phpgw_fud_users WHERE 
phpgw_id=".$row['account_id']);*/

-                       //$id = q_singleval("SELECT id FROM phpgw_fud_users 
WHERE phpgw_id=".$row['account_id']);

                        $GLOBALS['phpgw']->db->query('SELECT id from 
phpgw_fud_users WHERE phpgw_id=' . $account_id);
                        $GLOBALS['phpgw']->db->next_record();
                        $id = intval($GLOBALS['phpgw']->db->f('id'));

-                       if ($id)
+                       if ($id > 0)
                        {
-                               usr_delete($id);
+                               $tbl = 'phpgw_fud_';
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'mod WHERE user_id='.$id);
+
+                               /*if (db_affected()) {
+                                       rebuildmodlist();
+                               }*/
+
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'custom_tags WHERE user_id='.$id);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'thread_notify WHERE user_id='.$id);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'forum_notify WHERE user_id='.$id);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'read WHERE user_id='.$id);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'forum_read WHERE user_id='.$id);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'thread_rate_track WHERE user_id='.$id);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'user_ignore WHERE user_id='.$id);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'user_ignore WHERE ignore_id='.$id);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'buddy WHERE user_id='.$id);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'buddy WHERE bud_id='.$id);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'poll_opt_track WHERE user_id='.$id);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'group_members WHERE user_id='.$id);
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'msg WHERE poster_id='.$id);
+
+                               /* Delete the private messages of this user */
+                               $i = 0;
+                               $GLOBALS['phpgw']->db->query('SELECT id FROM 
'.$tbl.'pmsg WHERE duser_id='.$id);
+                               while($GLOBALS['phpgw']->db->next_record())
+                               {
+                                       $pmsg[$i] = 
$GLOBALS['phpgw']->db->f('id');
+                                       ++$i;
+                               }
+                               if (is_array($pmsg))
+                               {
+                                       foreach($pmsg as $key => $val)
+                                       {
+                                               
$GLOBALS['phpgw']->db->query('DELETE FROM '.$tbl.'pmsg WHERE duser_id='.$id);
+                                       }
+                               }
+                               $GLOBALS['phpgw']->db->query('DELETE FROM 
'.$tbl.'users WHERE id='.$id);
                        }
                }