Contents

Code Reference Classes BP_Message_Export BP_Message_Export::get_data()

BP_Message_Export::get_data( $user,  $page )

Get data & count of messages by page and user.

Description

Parameters

$user

(Required)

$page

(Required)

Return

(array)

Source

File: bp-core/gdpr/class-bp-message-export.php

264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
function get_data( $user, $page ) {
    global $wpdb, $bp;
 
    $wpdb->show_errors( false );
 
    $table = "{$bp->messages->global_tables["table_name_messages"]} item";
 
    $query_select       = "item.*";
    $query_select_count = "COUNT(item.id)";
    $query_where        = "item.sender_id=%d";
 
    $offset = ( $page - 1 ) * $this->items_per_batch;
    $limit  = "LIMIT {$this->items_per_batch} OFFSET {$offset}";
 
    $query       = "SELECT {$query_select} FROM {$table} WHERE {$query_where} {$limit}";
    $query       = $wpdb->prepare( $query, $user->ID );
    $query_count = "SELECT {$query_select_count} FROM {$table} WHERE {$query_where}";
    $query_count = $wpdb->prepare( $query_count, $user->ID );
 
    $count = (int) $wpdb->get_var( $query_count );
    $items = $wpdb->get_results( $query );
 
    $items = $this->messages_recipients( $items );
 
    return array(
        "total"  => $count,
        "offset" => $offset,
        "items"  => $items,
    );
 
}

Expand full source code Collapse full source code

Changelog

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