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

Timestamp:

03/13/2014 11:45:17 AM (13 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 );
 }