Delete subscriptions when a user is deleted

1 files changed, 5 insertions, 0 deletions

diff --git a/modules/notification/helpers/notification_event.php b/modules/notification/helpers/notification_event.php
index 6336733a..22a810bf 100644
--- a/modules/notification/helpers/notification_event.php
+++ b/modules/notification/helpers/notification_event.php
@@ -45,4 +45,9 @@ class notification_event_Core {
       notification::send_comment_published($new);
     }
   }
+
+  static function user_before_delete($user) {
+    $db = Database::instance();
+    $db->query("DELETE FROM subscriptions WHERE `user_id` = $user->id;");
+  }
 }