From 5107efb51fdeac3b9167d010141cd4bb5482c10a Mon Sep 17 00:00:00 2001
From: "wurblzap%gmail.com" <>
Date: Wed, 14 Dec 2005 04:20:12 +0000
Subject: Bug 319942: Preferences not deleted along with user accounts. Patch
 by Marc Schumann <wurblzap@gmail.com>, r=LpSolit, a=justdave

---
 editusers.cgi | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'editusers.cgi')

diff --git a/editusers.cgi b/editusers.cgi
index e9b61b13d..bfc7eee14 100755
--- a/editusers.cgi
+++ b/editusers.cgi
@@ -436,6 +436,9 @@ if ($action eq 'search') {
     $vars->{'bugs_activity'} = $dbh->selectrow_array(
         'SELECT COUNT(*) FROM bugs_activity WHERE who = ?',
         undef, $otherUserID);
+    $vars->{'email_setting'} = $dbh->selectrow_array(
+        'SELECT COUNT(*) FROM email_setting WHERE user_id = ?',
+        undef, $otherUserID);
     $vars->{'flags'}{'requestee'} = $dbh->selectrow_array(
         'SELECT COUNT(*) FROM flags WHERE requestee_id = ? AND is_active = 1',
         undef, $otherUserID);
@@ -448,6 +451,9 @@ if ($action eq 'search') {
     $vars->{'namedqueries'} = $dbh->selectrow_array(
         'SELECT COUNT(*) FROM namedqueries WHERE userid = ?',
         undef, $otherUserID);
+    $vars->{'profile_setting'} = $dbh->selectrow_array(
+        'SELECT COUNT(*) FROM profile_setting WHERE user_id = ?',
+        undef, $otherUserID);
     $vars->{'profiles_activity'} = $dbh->selectrow_array(
         'SELECT COUNT(*) FROM profiles_activity WHERE who = ? AND userid != ?',
         undef, ($otherUserID, $otherUserID));
@@ -499,6 +505,8 @@ if ($action eq 'search') {
                          'logincookies WRITE',
                          'profiles WRITE',
                          'profiles_activity WRITE',
+                         'email_setting WRITE',
+                         'profile_setting WRITE',
                          'groups READ',
                          'bug_group_map READ',
                          'user_group_map WRITE',
@@ -568,8 +576,12 @@ if ($action eq 'search') {
     }
 
     # Simple deletions in referred tables.
+    $dbh->do('DELETE FROM email_setting WHERE user_id = ?', undef,
+             $otherUserID);
     $dbh->do('DELETE FROM logincookies WHERE userid = ?', undef, $otherUserID);
     $dbh->do('DELETE FROM namedqueries WHERE userid = ?', undef, $otherUserID);
+    $dbh->do('DELETE FROM profile_setting WHERE user_id = ?', undef,
+             $otherUserID);
     $dbh->do('DELETE FROM profiles_activity WHERE userid = ? OR who = ?', undef,
              ($otherUserID, $otherUserID));
     $dbh->do('DELETE FROM tokens WHERE userid = ?', undef, $otherUserID);
-- 
cgit v1.2.3-24-g4f1b