Changeset 9845 for extensions/community

Timestamp:

Mar 24, 2011, 3:27:20 PM (13 years ago)

Author:

plg

Message:

bug fixed: when deleting a category, automatically delete related community permissions

File:

• extensions/community/main.inc.php (modified) (1 diff)

extensions/community/main.inc.php

@@ -214 +214 @@
 }
 
+add_event_handler('delete_categories', 'community_delete_category');
+function community_delete_category($category_ids)
+{
+  // $category_ids includes all the sub-category ids
+  $query = '
+DELETE
+  FROM '.COMMUNITY_PERMISSIONS_TABLE.'
+  WHERE category_id IN ('.implode(',', $category_ids).')
+;';
+  pwg_query($query);
+  
+  community_update_cache_key();
+}
+
 add_event_handler('invalidate_user_cache', 'community_refresh_cache_update_time');
 function community_refresh_cache_update_time()