Contents

Code Reference Classes BP_Messages_Thread BP_Messages_Thread::get_user_last_deleted_message()

BP_Messages_Thread::get_user_last_deleted_message( int $thread_id )

Get the user’s last deleted message in thread

Description

Parameters

$thread_id

(Required)

Source

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

568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
public static function get_user_last_deleted_message( $thread_id ) {
    global $wpdb;
    $bp = buddypress();
 
    $results = $wpdb->get_results( $wpdb->prepare(
        "SELECT m.* FROM {$bp->messages->table_name_messages} m
        LEFT JOIN {$bp->messages->table_name_meta} mm ON m.id = mm.message_id
        WHERE m.thread_id = %d
        AND (
            mm.meta_key = 'deleted_by' AND mm.meta_value = %d
        )
        ORDER BY m.date_sent DESC, m.id DESC
        LIMIT 1
    ", $thread_id, bp_loggedin_user_id() ) );
 
    if ( ! empty( $results ) ) {
        static::$last_deleted_message = (object) $results[0];
    }
 
    return static::$last_deleted_message;
}

Expand full source code Collapse full source code

Changelog

Changelog
Version Description
BuddyPress 1.0.0 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.