Contents

Code Reference Classes BP_Activity_Export BP_Activity_Export::get_data()

BP_Activity_Export::get_data( $user,  $page, string $mode = 'erase' )

Returns the data & count of activities by page and user.

Description

Parameters

$user

(Required)

$page

(Required)

$mode

(Optional)

Default value: 'erase'

Return

(array)

Source

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

162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
function get_data( $user, $page, $mode = "erase" ) {
    global $wpdb;
 
    $wpdb->show_errors( false );
 
    $table              = "{$wpdb->prefix}bp_activity item";
    $query_select       = "item.*";
    $query_select_count = "COUNT(item.id)";
 
    $query_where = "item.user_id=%d AND item.type IN ('activity_update','activity_comment') && is_spam=0";
 
    $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 );
 
    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.

Uses

Uses
Uses Description
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.

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.