BP_Group_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-group-export.php
function get_data( $user, $page ) { global $wpdb, $bp; $wpdb->show_errors( false ); $group_table = $bp->groups->global_tables["table_name"]; $group_members_table = $bp->groups->table_name_members; $table = "{$group_table} item, {$group_members_table} item2"; $query_select = "*"; $query_select_count = "COUNT(item.id)"; $query_where = "item2.user_id=%d AND item2.group_id=item.id AND item2.is_admin=1"; $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 ); // Merge the metas. $items = $this->merge_metas( $items ); 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.