BP_Messages_Thread::update_tables()

Upgrade method for the older BP message thread DB table.

Description

Return

(bool)

Source

File: bp-messages/classes/class-bp-messages-thread.php

public static function update_tables() {
    global $wpdb;
 
    $bp_prefix = bp_core_get_table_prefix();
    $errors    = false;
    $threads   = $wpdb->get_results( "SELECT * FROM {$bp_prefix}bp_messages_threads" );
 
    // Nothing to update, just return true to remove the table.
    if ( empty( $threads ) ) {
        return true;
    }
 
    $bp = buddypress();
 
    foreach( (array) $threads as $thread ) {
        $message_ids = maybe_unserialize( $thread->message_ids );
 
        if ( ! empty( $message_ids ) ) {
            $message_ids = implode( ',', $message_ids );
 
            // Add the thread_id to the messages table.
            if ( ! $wpdb->query( $wpdb->prepare( "UPDATE {$bp->messages->table_name_messages} SET thread_id = %d WHERE id IN ({$message_ids})", $thread->id ) ) ) {
                $errors = true;
            }
        }
    }
 
    return (bool) ! $errors;
}

Expand full source code Collapse full source code

Changelog

Changelog
Version	Description
BuddyPress 1.2.0	Introduced.

Uses

Uses
Uses	Description
bp-loader.php: buddypress()	The main function responsible for returning the one true BuddyBoss Instance to functions everywhere.
bp-core/bp-core-functions.php: bp_core_get_table_prefix()	Get the $wpdb base prefix, run through the ‘bp_core_get_table_prefix’ filter.

Used By
Used By	Description
bp-core/deprecated/buddypress/1.7.php: bp_update_db_stuff()	This function was originally used to update pre-1.1 schemas, but that was before we had a legitimate update process.

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.

Contents