Changeset 17013

Timestamp:

Jul 25, 2012, 3:22:56 PM (12 years ago)

Author:

mistic100

Message:

clean up table when a category is deleted

Location:

extensions/SmartAlbums

Files:

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

extensions/SmartAlbums/include/functions.inc.php

@@ -538 +538 @@
 }
 
+/**
+ * clean table when categories are deleted
+ */
+function smart_delete_categories($ids)
+{
+  $query = '
+DELETE FROM '.CATEGORY_FILTERS_TABLE.'
+  WHERE category_id IN('.implode(',', $ids).')
+;';
+  pwg_query($query);
+}
+
 ?>

extensions/SmartAlbums/main.inc.php

@@ -40 +40 @@
     add_event_handler('tabsheet_before_select','smart_tab', EVENT_HANDLER_PRIORITY_NEUTRAL, 2); 
     add_event_handler('get_admin_plugin_menu_links', 'smart_admin_menu');
+    add_event_handler('delete_categories', 'smart_delete_categories');
   }
 }