BP_XProfile_ProfileData::get_random( int $user_id, string $exclude_fullname )
Get random field type by user ID.
Description
Parameters
- $user_id
-
(Required) User ID to query for.
- $exclude_fullname
-
(Required) SQL portion used to exclude by field ID.
Return
(array|null|object)
Source
File: bp-xprofile/classes/class-bp-xprofile-profiledata.php
699 700 701 702 703 704 705 706 707 | public static function get_random( $user_id , $exclude_fullname ) { global $wpdb ; $exclude_sql = ! empty ( $exclude_fullname ) ? ' AND pf.id != 1' : '' ; $bp = buddypress(); return $wpdb ->get_results( $wpdb ->prepare( "SELECT pf.type, pf.name, pd.value FROM {$bp->profile->table_name_data} pd INNER JOIN {$bp->profile->table_name_fields} pf ON pd.field_id = pf.id AND pd.user_id = %d {$exclude_sql} ORDER BY RAND() LIMIT 1" , $user_id ) ); } |
Changelog
Version | Description |
---|---|
BuddyPress 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.