From 90465012d18b9d795d315e2fdf0461b39716b0a5 Mon Sep 17 00:00:00 2001
From: Tim Almdal <tnalmdal@shaw.ca>
Date: Fri, 30 Oct 2009 14:23:57 -0700
Subject: Patch to clean up loose ends when a user is deleted. * For items and
 tasks the owner id is set to admin * For notification subscriptions, the
 subscription is deleted * For comments, I've extracted the user name, email
 and url and set the guest_name, guest_email and guest_url columns while
 setting the author_id to identity::guest()->id Fix for ticket #777.

---
 modules/comment/helpers/comment_event.php           | 11 +++++++++++
 modules/gallery/helpers/gallery_event.php           |  7 +++++++
 modules/notification/helpers/notification_event.php |  4 ++++
 3 files changed, 22 insertions(+)

(limited to 'modules')

diff --git a/modules/comment/helpers/comment_event.php b/modules/comment/helpers/comment_event.php
index 2199eb7f..f20e1a51 100644
--- a/modules/comment/helpers/comment_event.php
+++ b/modules/comment/helpers/comment_event.php
@@ -22,6 +22,17 @@ class comment_event_Core {
     Database::instance()->delete("comments", array("item_id" => $item->id));
   }
 
+  static function user_deleted($user) {
+    $guest = identity::guest();
+    Database::instance()
+      ->query("UPDATE {comments}
+                  SET author_id = {$guest->id},
+                      guest_email = '{$user->email}',
+                      guest_name = '{$user->name}',
+                      guest_url = '{$user->url}'
+                WHERE author_id = {$user->id}");
+  }
+
   static function admin_menu($menu, $theme) {
     $menu->get("content_menu")
       ->append(Menu::factory("link")
diff --git a/modules/gallery/helpers/gallery_event.php b/modules/gallery/helpers/gallery_event.php
index 87dee356..7e0382ec 100644
--- a/modules/gallery/helpers/gallery_event.php
+++ b/modules/gallery/helpers/gallery_event.php
@@ -28,6 +28,13 @@ class gallery_event_Core {
     locales::set_request_locale();
   }
 
+  static function user_deleted($user) {
+    $admin = identity::admin_user();
+    $db = Database::instance();
+    $db->query("UPDATE {tasks} SET owner_id = {$admin->id} where owner_id = {$user->id}");
+    $db->query("UPDATE {items} SET owner_id = {$admin->id} where owner_id = {$user->id}");
+  }
+
   static function group_created($group) {
     access::add_group($group);
   }
diff --git a/modules/notification/helpers/notification_event.php b/modules/notification/helpers/notification_event.php
index 3a369155..e6791071 100644
--- a/modules/notification/helpers/notification_event.php
+++ b/modules/notification/helpers/notification_event.php
@@ -52,6 +52,10 @@ class notification_event_Core {
     }
   }
 
+  static function user_deleted($user) {
+    Database::instance()->query("DELETE FROM {subscriptions} where user_id = {$user->id}");
+  }
+
   static function comment_created($comment) {
     try {
       if ($comment->state == "published") {
-- 
cgit v1.2.3