Changeset 16106 for extensions

Timestamp:

Jun 27, 2012, 11:14:46 PM (12 years ago)

Author:

mistic100

Message:

an try to not delete an image subscription when a category with the same id is deleted!!!!

Location:

extensions/Subscribe_to_comments

Files:

• include/subscribe_to_comments.inc.php (modified) (1 diff)
• main.inc.php (modified) (1 diff)

extensions/Subscribe_to_comments/include/subscribe_to_comments.inc.php

@@ -379 +379 @@
   $query = '
 DELETE FROM '.SUBSCRIBE_TO_TABLE.'
-  WHERE element_id IN ('.implode(',', $ids).')
+  WHERE 
+    element_id IN ('.implode(',', $ids).')
+    AND type = "image"
 ';
   pwg_query($query);
 }
+function stc_delete_categories($ids)
+{
+  $query = '
+DELETE FROM '.SUBSCRIBE_TO_TABLE.'
+  WHERE 
+    element_id IN ('.implode(',', $ids).')
+    AND (type = "album" OR type = "album-images")
+';
+  pwg_query($query);
+}
 
 

extensions/Subscribe_to_comments/main.inc.php

@@ -45 +45 @@
   // items deletion
   add_event_handler('begin_delete_elements', 'stc_delete_elements');
-  add_event_handler('delete_categories', 'stc_delete_elements');
+  add_event_handler('delete_categories', 'stc_delete_categories');
 
   // profile link