Changeset 26557 for extensions/community/main.inc.php

Timestamp:

Jan 9, 2014, 8:44:12 PM (10 years ago)

Author:

plg

Message:

bug 2512 fixed: safely remove photos in community pending list when photo is
deleted (outside Community).

File:

• extensions/community/main.inc.php (modified) (2 diffs)

extensions/community/main.inc.php

@@ -85 +85 @@
     COUNT(*)
   FROM '.COMMUNITY_PENDINGS_TABLE.'
+    JOIN '.IMAGES_TABLE.' ON image_id = id
   WHERE state = \'moderation_pending\'
 ;';
@@ -644 +645 @@
 }
 
+add_event_handler('delete_elements', 'community_delete_elements');
+function community_delete_elements($image_ids)
+{
+  $query = '
+DELETE
+  FROM '.COMMUNITY_PENDINGS_TABLE.'
+  WHERE image_id IN ('.implode(',', $image_ids).')
+;';
+  pwg_query($query);
+}
+
 add_event_handler('invalidate_user_cache', 'community_refresh_cache_update_time');
 function community_refresh_cache_update_time()