Changeset 8124 for trunk/bp-members/bp-members-functions.php

Timestamp:

03/13/2014 11:45:17 AM (11 years ago)

Author:

boonebgorges

Message:

Introduce tool on Tools menu for repairing last_activity data

Fixes #5461

File:

• trunk/bp-members/bp-members-functions.php (modified) (1 diff)

trunk/bp-members/bp-members-functions.php

@@ -989 +989 @@
 
     return apply_filters( 'bp_get_user_last_activity', $activity, $user_id );
+}
+
+/**
+ * Migrate last_activity data from the usermeta table to the activity table.
+ *
+ * Generally, this function is only run when BP is upgraded to 2.0. It can also
+ * be called directly from the BuddyPress Tools panel.
+ *
+ * @since BuddyPress (2.0.0)
+ */
+function bp_last_activity_migrate() {
+    global $wpdb;
+
+    $bp = buddypress();
+
+    // The "NOT IN" clause prevents duplicates
+    $sql = "INSERT INTO {$bp->members->table_name_last_activity} (`user_id`, `component`, `type`, `action`, `content`, `primary_link`, `item_id`, `date_recorded` ) (
+          SELECT user_id, '{$bp->members->id}' as component, 'last_activity' as type, '' as action, '' as content, '' as primary_link, 0 as item_id, meta_value AS date_recorded
+          FROM {$wpdb->usermeta}
+          WHERE
+            meta_key = 'last_activity'
+            AND
+            user_id NOT IN (
+              SELECT user_id
+              FROM {$bp->members->table_name_last_activity}
+              WHERE component = '{$bp->members->id}' AND type = 'last_activity'
+            )
+    );";
+
+    return $wpdb->query( $sql );
 }