Contents

Code Reference Classes BP_Messages_Message BP_Messages_Message::get_existing_threads()

BP_Messages_Message::get_existing_threads( array $recipient_ids, integer $sender )

Get existsing threads which matches the recipients

Description

Parameters

$recipient_ids

(Required)

$sender

(Required)

Source

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

463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
public static function get_existing_threads( $recipient_ids, $sender = 0 ) {
    global $wpdb;
 
    $bp = buddypress();
 
    // add the sender into the recipient list and order by id ascending
    $recipient_ids[] = $sender;
    $recipient_ids   = array_filter( array_unique( array_values( $recipient_ids ) ) );
    sort( $recipient_ids );
 
    $results = $wpdb->get_results(
        $sql = $wpdb->prepare(
            "SELECT
            r.thread_id as thread_id,
            GROUP_CONCAT(DISTINCT user_id ORDER BY user_id separator ',') as recipient_list,
            MAX(m.date_sent) AS date_sent
        FROM {$bp->messages->table_name_recipients} r
        INNER JOIN {$bp->messages->table_name_messages} m ON m.thread_id = r.thread_id
        GROUP BY r.thread_id
        HAVING recipient_list = %s
        ORDER BY date_sent DESC
        ",
            implode( ',', $recipient_ids )
        )
    );
 
    if ( ! $results ) {
        return null;
    }
 
    return $results;
}

Expand full source code Collapse full source code

Changelog

Changelog
Version Description
BuddyBoss 1.2.9 Introduced.

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.