Changeset 883 for trunk/bp-activity/bp-activity-classes.php

Timestamp:

01/19/2009 10:41:25 PM (18 years ago)

Author:

apeatling

Message:

Added clean up routine to activity component that will flush the site wide activity stream of any activity from that user. The users' activity tables will also be dropped when the user is deleted. Activity for that user in friends' activity streams will be removed when recached.

File:

• trunk/bp-activity/bp-activity-classes.php (modified) (2 diffs)

trunk/bp-activity/bp-activity-classes.php

@@ -328 +328 @@
         }
         
+        function delete_activity_for_user( $user_id ) {
+                global $wpdb, $bp;
+
+                /* Empty user's activities from the sitewide stream */
+                $wpdb->query( $wpdb->prepare( "DELETE FROM " . $bp['activity']['table_name_sitewide'] . " WHERE user_id = %d", $user_id ) );
+
+                /* Empty the user's activity items and cached activity items */
+                $wpdb->query( $wpdb->prepare( "TRUNCATE TABLE wp_user_{$user_id}_activity" ) );
+                $wpdb->query( $wpdb->prepare( "TRUNCATE TABLE wp_user_{$user_id}_activity_cached" ) );  
+                
+                return true;
+        }
+        
         function get_last_updated() {
                 global $bp, $wpdb;
@@ -334 +347 @@
         }
         
+        function kill_tables_for_user( $user_id ) {
+                global $bp, $wpdb;
+                
+                $wpdb->query( $wpdb->prepare( "DROP TABLE wp_user_{$user_id}_activity" ) );
+                $wpdb->query( $wpdb->prepare( "DROP TABLE wp_user_{$user_id}_activity_cached" ) );      
+                $wpdb->query( $wpdb->prepare( "DROP TABLE wp_user_{$user_id}_friends_activity_cached" ) );      
+                
+                return true;
+        }
+        
 
 }