BP_Messages_Thread::get_total_threads_for_user( int $user_id, string $box = 'inbox', string $type = 'all' )

Returns the total number of message threads for a user.

Description

Parameters

$user_id

(Required) The user ID.

$box

(Optional) The type of mailbox to get. Either 'inbox' or 'sentbox'. Defaults to 'inbox'.

Default value: 'inbox'

$type

(Optional) The type of messages to get. Either 'all' or 'unread'. or 'read'. Defaults to 'all'.

Default value: 'all'

Return

(int) $value Total thread count for the provided user.

Source

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

public static function get_total_threads_for_user( $user_id, $box = 'inbox', $type = 'all' ) {
    global $wpdb;
 
    $exclude_sender = $type_sql = '';
    // $exclude_sender = 'AND sender_only != 1';
 
    if ( $type === 'unread' ) {
        $type_sql = 'AND unread_count != 0';
    } elseif ( $type === 'read' ) {
        $type_sql = 'AND unread_count = 0';
    }
 
    $bp = buddypress();
 
    return (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(thread_id) FROM {$bp->messages->table_name_recipients} WHERE user_id = %d AND is_deleted = 0 {$exclude_sender} {$type_sql}", $user_id ) );
}

Expand full source code Collapse full source code

Changelog

Changelog
Version	Description
BuddyPress 1.0.0	Introduced.

Uses

Uses
Uses	Description
bp-messages/classes/class-bp-messages-thread.php: BP_Messages_Thread::get()	Query for recipients.

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