Contents

Code Reference Functions bp_last_activity_migrate()

bp_last_activity_migrate()

Migrate last_activity data from the usermeta table to the activity table.

Description

Generally, this function is only run when BP is upgraded to 2.0. It can also be called directly from the BuddyBoss Tools panel.

Return

(bool)

Source

File: bp-members/bp-members-functions.php

1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
function bp_last_activity_migrate() {
    global $wpdb;
 
    $bp = buddypress();
 
    // Wipe out existing last_activity data in the activity table -
    // this helps to prevent duplicates when pulling from the usermeta
    // table.
    $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->members->table_name_last_activity} WHERE component = %s AND type = 'last_activity'", $bp->members->id ) );
 
    $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'
    );";
 
    return $wpdb->query( $sql );
}

Expand full source code Collapse full source code

Changelog

Changelog
Version Description
BuddyPress 2.0.0 Introduced.

Uses

Uses
Uses Description
bp-loader.php: buddypress()

The main function responsible for returning the one true BuddyBoss Instance to functions everywhere.

Questions?

We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.