BP_Friendship_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-friendship-export.php
function get_data( $user, $page ) { global $wpdb, $bp; $wpdb->show_errors( false ); $friends_table = $bp->friends->table_name; $table = "{$friends_table} item"; $query_select = "item.*"; $query_select_count = "COUNT(item.id)"; $query_where = "item.initiator_user_id=%d OR item.friend_user_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, $user->ID ); $query_count = "SELECT {$query_select_count} FROM {$table} WHERE {$query_where}"; $query_count = $wpdb->prepare( $query_count, $user->ID, $user->ID ); $count = (int) $wpdb->get_var( $query_count ); $items = $wpdb->get_results( $query ); return array( 'total' => $count, 'offset' => $offset, 'items' => $items, ); }
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.