| [ Index ] |
PHP Cross Reference of BuddyPress |
[Summary view] [Print] [Text view]
1 <?php 2 /** 3 * BuddyPress Groups Classes. 4 * 5 * @package BuddyPress 6 * @subpackage GroupsClasses 7 * @since 1.6.0 8 */ 9 10 // Exit if accessed directly. 11 defined( 'ABSPATH' ) || exit; 12 13 /** 14 * BuddyPress Group Membership object. 15 */ 16 class BP_Groups_Member { 17 18 /** 19 * ID of the membership. 20 * 21 * @since 1.6.0 22 * @var int 23 */ 24 var $id; 25 26 /** 27 * ID of the group associated with the membership. 28 * 29 * @since 1.6.0 30 * @var int 31 */ 32 var $group_id; 33 34 /** 35 * ID of the user associated with the membership. 36 * 37 * @since 1.6.0 38 * @var int 39 */ 40 var $user_id; 41 42 /** 43 * ID of the user whose invitation initiated the membership. 44 * 45 * @since 1.6.0 46 * @var int 47 */ 48 var $inviter_id; 49 50 /** 51 * Whether the member is an admin of the group. 52 * 53 * @since 1.6.0 54 * @var int 55 */ 56 var $is_admin; 57 58 /** 59 * Whether the member is a mod of the group. 60 * 61 * @since 1.6.0 62 * @var int 63 */ 64 var $is_mod; 65 66 /** 67 * Whether the member is banned from the group. 68 * 69 * @since 1.6.0 70 * @var int 71 */ 72 var $is_banned; 73 74 /** 75 * Title used to describe the group member's role in the group. 76 * 77 * Eg, 'Group Admin'. 78 * 79 * @since 1.6.0 80 * @var int 81 */ 82 var $user_title; 83 84 /** 85 * Last modified date of the membership. 86 * 87 * This value is updated when, eg, invitations are accepted. 88 * 89 * @since 1.6.0 90 * @var string 91 */ 92 var $date_modified; 93 94 /** 95 * Whether the membership has been confirmed. 96 * 97 * @since 1.6.0 98 * @var int 99 */ 100 var $is_confirmed; 101 102 /** 103 * Comments associated with the membership. 104 * 105 * In BP core, these are limited to the optional message users can 106 * include when requesting membership to a private group. 107 * 108 * @since 1.6.0 109 * @var string 110 */ 111 var $comments; 112 113 /** 114 * Whether an invitation has been sent for this membership. 115 * 116 * The purpose of this flag is to mark when an invitation has been 117 * "drafted" (the user has been added via the interface at Send 118 * Invites), but the Send button has not been pressed, so the 119 * invitee has not yet been notified. 120 * 121 * @since 1.6.0 122 * @var int 123 */ 124 var $invite_sent; 125 126 /** 127 * WP_User object representing the membership's user. 128 * 129 * @since 1.6.0 130 * @var WP_User 131 */ 132 protected $user; 133 134 /** 135 * Constructor method. 136 * 137 * @since 1.6.0 138 * 139 * @param int $user_id Optional. Along with $group_id, can be used to 140 * look up a membership. 141 * @param int $group_id Optional. Along with $user_id, can be used to 142 * look up a membership. 143 * @param int|bool $id Optional. The unique ID of the membership object. 144 * @param bool $populate Whether to populate the properties of the 145 * located membership. Default: true. 146 */ 147 public function __construct( $user_id = 0, $group_id = 0, $id = false, $populate = true ) { 148 149 // User and group are not empty, and ID is. 150 if ( !empty( $user_id ) && !empty( $group_id ) && empty( $id ) ) { 151 $this->user_id = $user_id; 152 $this->group_id = $group_id; 153 154 if ( !empty( $populate ) ) { 155 $this->populate(); 156 } 157 } 158 159 // ID is not empty. 160 if ( !empty( $id ) ) { 161 $this->id = $id; 162 163 if ( !empty( $populate ) ) { 164 $this->populate(); 165 } 166 } 167 } 168 169 /** 170 * Populate the object's properties. 171 * 172 * @since 1.6.0 173 */ 174 public function populate() { 175 global $wpdb; 176 177 $bp = buddypress(); 178 179 if ( $this->user_id && $this->group_id && !$this->id ) 180 $sql = $wpdb->prepare( "SELECT * FROM {$bp->groups->table_name_members} WHERE user_id = %d AND group_id = %d", $this->user_id, $this->group_id ); 181 182 if ( !empty( $this->id ) ) 183 $sql = $wpdb->prepare( "SELECT * FROM {$bp->groups->table_name_members} WHERE id = %d", $this->id ); 184 185 $member = $wpdb->get_row($sql); 186 187 if ( !empty( $member ) ) { 188 $this->id = (int) $member->id; 189 $this->group_id = (int) $member->group_id; 190 $this->user_id = (int) $member->user_id; 191 $this->inviter_id = (int) $member->inviter_id; 192 $this->is_admin = (int) $member->is_admin; 193 $this->is_mod = (int) $member->is_mod; 194 $this->is_banned = (int) $member->is_banned; 195 $this->user_title = $member->user_title; 196 $this->date_modified = $member->date_modified; 197 $this->is_confirmed = (int) $member->is_confirmed; 198 $this->comments = $member->comments; 199 $this->invite_sent = (int) $member->invite_sent; 200 } 201 } 202 203 /** 204 * Magic getter. 205 * 206 * @since 2.8.0 207 * 208 * @param string $key Key. 209 * @return BP_Core_User|null 210 */ 211 public function __get( $key ) { 212 switch ( $key ) { 213 case 'user' : 214 return $this->get_user_object( $this->user_id ); 215 } 216 } 217 218 /** 219 * Magic issetter. 220 * 221 * @since 2.8.0 222 * 223 * @param string $key Key. 224 * @return bool 225 */ 226 public function __isset( $key ) { 227 switch ( $key ) { 228 case 'user' : 229 return true; 230 231 default : 232 return isset( $this->{$key} ); 233 } 234 } 235 236 /** 237 * Get the user object corresponding to this membership. 238 * 239 * Used for lazyloading the protected `user` property. 240 * 241 * @since 2.8.0 242 * 243 * @return BP_Core_User 244 */ 245 protected function get_user_object() { 246 if ( empty( $this->user ) ) { 247 $this->user = new BP_Core_User( $this->user_id ); 248 } 249 250 return $this->user; 251 } 252 253 /** 254 * Save the membership data to the database. 255 * 256 * @since 1.6.0 257 * 258 * @return bool True on success, false on failure. 259 */ 260 public function save() { 261 global $wpdb; 262 263 $bp = buddypress(); 264 265 $this->user_id = apply_filters( 'groups_member_user_id_before_save', $this->user_id, $this->id ); 266 $this->group_id = apply_filters( 'groups_member_group_id_before_save', $this->group_id, $this->id ); 267 $this->inviter_id = apply_filters( 'groups_member_inviter_id_before_save', $this->inviter_id, $this->id ); 268 $this->is_admin = apply_filters( 'groups_member_is_admin_before_save', $this->is_admin, $this->id ); 269 $this->is_mod = apply_filters( 'groups_member_is_mod_before_save', $this->is_mod, $this->id ); 270 $this->is_banned = apply_filters( 'groups_member_is_banned_before_save', $this->is_banned, $this->id ); 271 $this->user_title = apply_filters( 'groups_member_user_title_before_save', $this->user_title, $this->id ); 272 $this->date_modified = apply_filters( 'groups_member_date_modified_before_save', $this->date_modified, $this->id ); 273 $this->is_confirmed = apply_filters( 'groups_member_is_confirmed_before_save', $this->is_confirmed, $this->id ); 274 $this->comments = apply_filters( 'groups_member_comments_before_save', $this->comments, $this->id ); 275 $this->invite_sent = apply_filters( 'groups_member_invite_sent_before_save', $this->invite_sent, $this->id ); 276 277 /** 278 * Fires before the current group membership item gets saved. 279 * 280 * Please use this hook to filter the properties above. Each part will be passed in. 281 * 282 * @since 1.0.0 283 * 284 * @param BP_Groups_Member $this Current instance of the group membership item being saved. Passed by reference. 285 */ 286 do_action_ref_array( 'groups_member_before_save', array( &$this ) ); 287 288 // The following properties are required; bail if not met. 289 if ( empty( $this->user_id ) || empty( $this->group_id ) ) { 290 return false; 291 } 292 293 if ( !empty( $this->id ) ) { 294 $sql = $wpdb->prepare( "UPDATE {$bp->groups->table_name_members} SET inviter_id = %d, is_admin = %d, is_mod = %d, is_banned = %d, user_title = %s, date_modified = %s, is_confirmed = %d, comments = %s, invite_sent = %d WHERE id = %d", $this->inviter_id, $this->is_admin, $this->is_mod, $this->is_banned, $this->user_title, $this->date_modified, $this->is_confirmed, $this->comments, $this->invite_sent, $this->id ); 295 } else { 296 // Ensure that user is not already a member of the group before inserting. 297 if ( $wpdb->get_var( $wpdb->prepare( "SELECT id FROM {$bp->groups->table_name_members} WHERE user_id = %d AND group_id = %d AND is_confirmed = 1 LIMIT 1", $this->user_id, $this->group_id ) ) ) { 298 return false; 299 } 300 301 $sql = $wpdb->prepare( "INSERT INTO {$bp->groups->table_name_members} ( user_id, group_id, inviter_id, is_admin, is_mod, is_banned, user_title, date_modified, is_confirmed, comments, invite_sent ) VALUES ( %d, %d, %d, %d, %d, %d, %s, %s, %d, %s, %d )", $this->user_id, $this->group_id, $this->inviter_id, $this->is_admin, $this->is_mod, $this->is_banned, $this->user_title, $this->date_modified, $this->is_confirmed, $this->comments, $this->invite_sent ); 302 } 303 304 if ( !$wpdb->query( $sql ) ) 305 return false; 306 307 $this->id = $wpdb->insert_id; 308 309 // Update the user's group count. 310 self::refresh_total_group_count_for_user( $this->user_id ); 311 312 // Update the group's member count. 313 self::refresh_total_member_count_for_group( $this->group_id ); 314 315 /** 316 * Fires after the current group membership item has been saved. 317 * 318 * Please use this hook to filter the properties above. Each part will be passed in. 319 * 320 * @since 1.0.0 321 * 322 * @param BP_Groups_Member $this Current instance of the group membership item has been saved. Passed by reference. 323 */ 324 do_action_ref_array( 'groups_member_after_save', array( &$this ) ); 325 326 return true; 327 } 328 329 /** 330 * Promote a member to a new status. 331 * 332 * @since 1.6.0 333 * 334 * @param string $status The new status. 'mod' or 'admin'. 335 * @return bool True on success, false on failure. 336 */ 337 public function promote( $status = 'mod' ) { 338 if ( 'mod' == $status ) { 339 $this->is_admin = 0; 340 $this->is_mod = 1; 341 $this->user_title = __( 'Group Mod', 'buddypress' ); 342 } 343 344 if ( 'admin' == $status ) { 345 $this->is_admin = 1; 346 $this->is_mod = 0; 347 $this->user_title = __( 'Group Admin', 'buddypress' ); 348 } 349 350 return $this->save(); 351 } 352 353 /** 354 * Demote membership to Member status (non-admin, non-mod). 355 * 356 * @since 1.6.0 357 * 358 * @return bool True on success, false on failure. 359 */ 360 public function demote() { 361 $this->is_mod = 0; 362 $this->is_admin = 0; 363 $this->user_title = false; 364 365 return $this->save(); 366 } 367 368 /** 369 * Ban the user from the group. 370 * 371 * @since 1.6.0 372 * 373 * @return bool True on success, false on failure. 374 */ 375 public function ban() { 376 if ( !empty( $this->is_admin ) ) 377 return false; 378 379 $this->is_mod = 0; 380 $this->is_banned = 1; 381 382 return $this->save(); 383 } 384 385 /** 386 * Unban the user from the group. 387 * 388 * @since 1.6.0 389 * 390 * @return bool True on success, false on failure. 391 */ 392 public function unban() { 393 if ( !empty( $this->is_admin ) ) 394 return false; 395 396 $this->is_banned = 0; 397 398 return $this->save(); 399 } 400 401 /** 402 * Mark a pending invitation as accepted. 403 * 404 * @since 1.6.0 405 */ 406 public function accept_invite() { 407 $this->inviter_id = 0; 408 $this->is_confirmed = 1; 409 $this->date_modified = bp_core_current_time(); 410 } 411 412 /** 413 * Confirm a membership request. 414 * 415 * @since 1.6.0 416 */ 417 public function accept_request() { 418 $this->is_confirmed = 1; 419 $this->date_modified = bp_core_current_time(); 420 } 421 422 /** 423 * Remove the current membership. 424 * 425 * @since 1.6.0 426 * 427 * @return bool True on success, false on failure. 428 */ 429 public function remove() { 430 global $wpdb; 431 432 /** 433 * Fires before a member is removed from a group. 434 * 435 * @since 2.3.0 436 * 437 * @param BP_Groups_Member $this Current group membership object. 438 */ 439 do_action_ref_array( 'groups_member_before_remove', array( $this ) ); 440 441 $bp = buddypress(); 442 $sql = $wpdb->prepare( "DELETE FROM {$bp->groups->table_name_members} WHERE user_id = %d AND group_id = %d", $this->user_id, $this->group_id ); 443 444 if ( !$result = $wpdb->query( $sql ) ) 445 return false; 446 447 // Update the user's group count. 448 self::refresh_total_group_count_for_user( $this->user_id ); 449 450 // Update the group's member count. 451 self::refresh_total_member_count_for_group( $this->group_id ); 452 453 /** 454 * Fires after a member is removed from a group. 455 * 456 * @since 2.3.0 457 * 458 * @param BP_Groups_Member $this Current group membership object. 459 */ 460 do_action_ref_array( 'groups_member_after_remove', array( $this ) ); 461 462 return $result; 463 } 464 465 /** Static Methods ****************************************************/ 466 467 /** 468 * Refresh the `total_group_count` for a user. 469 * 470 * @since 1.8.0 471 * 472 * @param int $user_id ID of the user. 473 */ 474 public static function refresh_total_group_count_for_user( $user_id ) { 475 bp_update_user_meta( $user_id, 'total_group_count', (int) self::total_group_count( $user_id ) ); 476 } 477 478 /** 479 * Refresh the `total_member_count` for a group. 480 * 481 * The request skip the current cache so that we always grab the lastest total count. 482 * 483 * @since 1.8.0 484 * @since 10.0.0 Updated to use `BP_Groups_Group::get_total_member_count` 485 * 486 * @param int $group_id ID of the group. 487 */ 488 public static function refresh_total_member_count_for_group( $group_id ) { 489 BP_Groups_Group::get_total_member_count( $group_id, true ); 490 } 491 492 /** 493 * Delete a membership, based on user + group IDs. 494 * 495 * @since 1.6.0 496 * 497 * @param int $user_id ID of the user. 498 * @param int $group_id ID of the group. 499 * @return bool True on success, false on failure. 500 */ 501 public static function delete( $user_id, $group_id ) { 502 global $wpdb; 503 504 /** 505 * Fires before a group membership is deleted. 506 * 507 * @since 2.3.0 508 * 509 * @param int $user_id ID of the user. 510 * @param int $group_id ID of the group. 511 */ 512 do_action( 'bp_groups_member_before_delete', $user_id, $group_id ); 513 514 $bp = buddypress(); 515 $remove = $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->groups->table_name_members} WHERE user_id = %d AND group_id = %d", $user_id, $group_id ) ); 516 517 // Update the user's group count. 518 self::refresh_total_group_count_for_user( $user_id ); 519 520 // Update the group's member count. 521 self::refresh_total_member_count_for_group( $group_id ); 522 523 /** 524 * Fires after a member is removed from a group. 525 * 526 * @since 2.3.0 527 * 528 * @param int $user_id ID of the user. 529 * @param int $group_id ID of the group. 530 */ 531 do_action( 'bp_groups_member_after_delete', $user_id, $group_id ); 532 533 return (bool) $remove; 534 } 535 536 /** 537 * Get the IDs of the groups of which a specified user is a member. 538 * 539 * @since 1.6.0 540 * 541 * @param int $user_id ID of the user. 542 * @param int|bool $limit Optional. Max number of results to return. 543 * Default: false (no limit). 544 * @param int|bool $page Optional. Page offset of results to return. 545 * Default: false (no limit). 546 * @return array { 547 * @type array $groups Array of groups returned by paginated query. 548 * @type int $total Count of groups matching query. 549 * } 550 */ 551 public static function get_group_ids( $user_id, $limit = false, $page = false ) { 552 global $wpdb; 553 554 $pag_sql = ''; 555 if ( !empty( $limit ) && !empty( $page ) ) 556 $pag_sql = $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) ); 557 558 $bp = buddypress(); 559 560 // If the user is logged in and viewing their own groups, we can show hidden and private groups. 561 if ( $user_id != bp_loggedin_user_id() ) { 562 $group_sql = $wpdb->prepare( "SELECT DISTINCT m.group_id FROM {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE g.status != 'hidden' AND m.user_id = %d AND m.is_confirmed = 1 AND m.is_banned = 0{$pag_sql}", $user_id ); 563 $total_groups = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(DISTINCT m.group_id) FROM {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE g.status != 'hidden' AND m.user_id = %d AND m.is_confirmed = 1 AND m.is_banned = 0", $user_id ) ); 564 } else { 565 $group_sql = $wpdb->prepare( "SELECT DISTINCT group_id FROM {$bp->groups->table_name_members} WHERE user_id = %d AND is_confirmed = 1 AND is_banned = 0{$pag_sql}", $user_id ); 566 $total_groups = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(DISTINCT group_id) FROM {$bp->groups->table_name_members} WHERE user_id = %d AND is_confirmed = 1 AND is_banned = 0", $user_id ) ); 567 } 568 569 $groups = $wpdb->get_col( $group_sql ); 570 571 return array( 'groups' => $groups, 'total' => (int) $total_groups ); 572 } 573 574 /** 575 * Get the IDs of the groups of which a specified user is a member, sorted by the date joined. 576 * 577 * @since 1.6.0 578 * 579 * @param int $user_id ID of the user. 580 * @param int|bool $limit Optional. Max number of results to return. 581 * Default: false (no limit). 582 * @param int|bool $page Optional. Page offset of results to return. 583 * Default: false (no limit). 584 * @param string|bool $filter Optional. Limit results to groups whose name or 585 * description field matches search terms. 586 * @return array { 587 * @type array $groups Array of groups returned by paginated query. 588 * @type int $total Count of groups matching query. 589 * } 590 */ 591 public static function get_recently_joined( $user_id, $limit = false, $page = false, $filter = false ) { 592 global $wpdb; 593 594 $user_id_sql = $pag_sql = $hidden_sql = $filter_sql = ''; 595 596 $user_id_sql = $wpdb->prepare( 'm.user_id = %d', $user_id ); 597 598 if ( !empty( $limit ) && !empty( $page ) ) 599 $pag_sql = $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) ); 600 601 if ( !empty( $filter ) ) { 602 $search_terms_like = '%' . bp_esc_like( $filter ) . '%'; 603 $filter_sql = $wpdb->prepare( " AND ( g.name LIKE %s OR g.description LIKE %s )", $search_terms_like, $search_terms_like ); 604 } 605 606 if ( $user_id != bp_loggedin_user_id() ) 607 $hidden_sql = " AND g.status != 'hidden'"; 608 609 $bp = buddypress(); 610 611 $paged_groups = $wpdb->get_results( "SELECT g.*, gm1.meta_value as total_member_count, gm2.meta_value as last_activity FROM {$bp->groups->table_name_groupmeta} gm1, {$bp->groups->table_name_groupmeta} gm2, {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE g.id = m.group_id AND g.id = gm1.group_id AND g.id = gm2.group_id AND gm2.meta_key = 'last_activity' AND gm1.meta_key = 'total_member_count'{$hidden_sql}{$filter_sql} AND {$user_id_sql} AND m.is_confirmed = 1 AND m.is_banned = 0 ORDER BY m.date_modified DESC {$pag_sql}" ); 612 $total_groups = $wpdb->get_var( "SELECT COUNT(DISTINCT m.group_id) FROM {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE m.group_id = g.id{$hidden_sql}{$filter_sql} AND {$user_id_sql} AND m.is_banned = 0 AND m.is_confirmed = 1 ORDER BY m.date_modified DESC" ); 613 614 return array( 'groups' => $paged_groups, 'total' => $total_groups ); 615 } 616 617 /** 618 * Get the IDs of the groups of which a specified user is an admin. 619 * 620 * @since 1.6.0 621 * 622 * @param int $user_id ID of the user. 623 * @param int|bool $limit Optional. Max number of results to return. 624 * Default: false (no limit). 625 * @param int|bool $page Optional. Page offset of results to return. 626 * Default: false (no limit). 627 * @param string|bool $filter Optional. Limit results to groups whose name or 628 * description field matches search terms. 629 * @return array { 630 * @type array $groups Array of groups returned by paginated query. 631 * @type int $total Count of groups matching query. 632 * } 633 */ 634 public static function get_is_admin_of( $user_id, $limit = false, $page = false, $filter = false ) { 635 global $wpdb; 636 637 $user_id_sql = $pag_sql = $hidden_sql = $filter_sql = ''; 638 639 $user_id_sql = $wpdb->prepare( 'm.user_id = %d', $user_id ); 640 641 if ( !empty( $limit ) && !empty( $page ) ) 642 $pag_sql = $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) ); 643 644 if ( !empty( $filter ) ) { 645 $search_terms_like = '%' . bp_esc_like( $filter ) . '%'; 646 $filter_sql = $wpdb->prepare( " AND ( g.name LIKE %s OR g.description LIKE %s )", $search_terms_like, $search_terms_like ); 647 } 648 649 if ( $user_id != bp_loggedin_user_id() ) 650 $hidden_sql = " AND g.status != 'hidden'"; 651 652 $bp = buddypress(); 653 654 $paged_groups = $wpdb->get_results( "SELECT g.*, gm1.meta_value as total_member_count, gm2.meta_value as last_activity FROM {$bp->groups->table_name_groupmeta} gm1, {$bp->groups->table_name_groupmeta} gm2, {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE g.id = m.group_id AND g.id = gm1.group_id AND g.id = gm2.group_id AND gm2.meta_key = 'last_activity' AND gm1.meta_key = 'total_member_count'{$hidden_sql}{$filter_sql} AND {$user_id_sql} AND m.is_confirmed = 1 AND m.is_banned = 0 AND m.is_admin = 1 ORDER BY m.date_modified ASC {$pag_sql}" ); 655 $total_groups = $wpdb->get_var( "SELECT COUNT(DISTINCT m.group_id) FROM {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE m.group_id = g.id{$hidden_sql}{$filter_sql} AND {$user_id_sql} AND m.is_confirmed = 1 AND m.is_banned = 0 AND m.is_admin = 1 ORDER BY date_modified ASC" ); 656 657 return array( 'groups' => $paged_groups, 'total' => $total_groups ); 658 } 659 660 /** 661 * Get the IDs of the groups of which a specified user is a moderator. 662 * 663 * @since 1.6.0 664 * 665 * @param int $user_id ID of the user. 666 * @param int|bool $limit Optional. Max number of results to return. 667 * Default: false (no limit). 668 * @param int|bool $page Optional. Page offset of results to return. 669 * Default: false (no limit). 670 * @param string|bool $filter Optional. Limit results to groups whose name or 671 * description field matches search terms. 672 * @return array { 673 * @type array $groups Array of groups returned by paginated query. 674 * @type int $total Count of groups matching query. 675 * } 676 */ 677 public static function get_is_mod_of( $user_id, $limit = false, $page = false, $filter = false ) { 678 global $wpdb; 679 680 $user_id_sql = $pag_sql = $hidden_sql = $filter_sql = ''; 681 682 $user_id_sql = $wpdb->prepare( 'm.user_id = %d', $user_id ); 683 684 if ( !empty( $limit ) && !empty( $page ) ) 685 $pag_sql = $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) ); 686 687 if ( !empty( $filter ) ) { 688 $search_terms_like = '%' . bp_esc_like( $filter ) . '%'; 689 $filter_sql = $wpdb->prepare( " AND ( g.name LIKE %s OR g.description LIKE %s )", $search_terms_like, $search_terms_like ); 690 } 691 692 if ( $user_id != bp_loggedin_user_id() ) 693 $hidden_sql = " AND g.status != 'hidden'"; 694 695 $bp = buddypress(); 696 697 $paged_groups = $wpdb->get_results( "SELECT g.*, gm1.meta_value as total_member_count, gm2.meta_value as last_activity FROM {$bp->groups->table_name_groupmeta} gm1, {$bp->groups->table_name_groupmeta} gm2, {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE g.id = m.group_id AND g.id = gm1.group_id AND g.id = gm2.group_id AND gm2.meta_key = 'last_activity' AND gm1.meta_key = 'total_member_count'{$hidden_sql}{$filter_sql} AND {$user_id_sql} AND m.is_confirmed = 1 AND m.is_banned = 0 AND m.is_mod = 1 ORDER BY m.date_modified ASC {$pag_sql}" ); 698 $total_groups = $wpdb->get_var( "SELECT COUNT(DISTINCT m.group_id) FROM {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE m.group_id = g.id{$hidden_sql}{$filter_sql} AND {$user_id_sql} AND m.is_confirmed = 1 AND m.is_banned = 0 AND m.is_mod = 1 ORDER BY date_modified ASC" ); 699 700 return array( 'groups' => $paged_groups, 'total' => $total_groups ); 701 } 702 703 /** 704 * Get the groups of which a specified user is banned from. 705 * 706 * @since 2.4.0 707 * 708 * @param int $user_id ID of the user. 709 * @param int|bool $limit Optional. Max number of results to return. 710 * Default: false (no limit). 711 * @param int|bool $page Optional. Page offset of results to return. 712 * Default: false (no limit). 713 * @param string|bool $filter Optional. Limit results to groups whose name or 714 * description field matches search terms. 715 * @return array { 716 * @type array $groups Array of groups returned by paginated query. 717 * @type int $total Count of groups matching query. 718 * } 719 */ 720 public static function get_is_banned_of( $user_id, $limit = false, $page = false, $filter = false ) { 721 global $wpdb; 722 723 $bp = buddypress(); 724 725 $user_id_sql = $pag_sql = $hidden_sql = $filter_sql = ''; 726 $user_id_sql = $wpdb->prepare( 'm.user_id = %d', $user_id ); 727 728 if ( $limit && $page ) { 729 $pag_sql = $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit ), intval( $limit ) ); 730 } 731 732 if ( $filter ) { 733 $search_terms_like = '%' . bp_esc_like( $filter ) . '%'; 734 $filter_sql = $wpdb->prepare( " AND ( g.name LIKE %s OR g.description LIKE %s )", $search_terms_like, $search_terms_like ); 735 } 736 737 if ( $user_id !== bp_loggedin_user_id() && ! bp_current_user_can( 'bp_moderate' ) ) { 738 $hidden_sql = " AND g.status != 'hidden'"; 739 } 740 741 $paged_groups = $wpdb->get_results( "SELECT g.*, gm1.meta_value as total_member_count, gm2.meta_value as last_activity FROM {$bp->groups->table_name_groupmeta} gm1, {$bp->groups->table_name_groupmeta} gm2, {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE g.id = m.group_id AND g.id = gm1.group_id AND g.id = gm2.group_id AND gm2.meta_key = 'last_activity' AND gm1.meta_key = 'total_member_count'{$hidden_sql}{$filter_sql} AND {$user_id_sql} AND m.is_banned = 1 ORDER BY m.date_modified ASC {$pag_sql}" ); 742 $total_groups = $wpdb->get_var( "SELECT COUNT(DISTINCT m.group_id) FROM {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE m.group_id = g.id{$hidden_sql}{$filter_sql} AND {$user_id_sql} AND m.is_banned = 1 ORDER BY date_modified ASC" ); 743 744 return array( 'groups' => $paged_groups, 'total' => $total_groups ); 745 } 746 747 /** 748 * Get the count of groups of which the specified user is a member. 749 * 750 * @since 1.6.0 751 * 752 * @param int $user_id Optional. Default: ID of the displayed user. 753 * @return int Group count. 754 */ 755 public static function total_group_count( $user_id = 0 ) { 756 global $wpdb; 757 758 if ( empty( $user_id ) ) 759 $user_id = bp_displayed_user_id(); 760 761 $bp = buddypress(); 762 763 if ( $user_id != bp_loggedin_user_id() && !bp_current_user_can( 'bp_moderate' ) ) { 764 return (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(DISTINCT m.group_id) FROM {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE m.group_id = g.id AND g.status != 'hidden' AND m.user_id = %d AND m.is_confirmed = 1 AND m.is_banned = 0", $user_id ) ); 765 } else { 766 return (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(DISTINCT m.group_id) FROM {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE m.group_id = g.id AND m.user_id = %d AND m.is_confirmed = 1 AND m.is_banned = 0", $user_id ) ); 767 } 768 } 769 770 /** 771 * Get group objects for groups that a user is currently invited to. 772 * 773 * @since 1.6.0 774 * 775 * @param int $user_id ID of the invitee. 776 * @param int|bool $limit Optional. Max number of results to return. 777 * Default: false (no limit). 778 * @param int|bool $page Optional. Page offset of results to return. 779 * Default: false (no limit). 780 * @param string|array|bool $exclude Optional. Array or comma-separated list 781 * of group IDs to exclude from results. 782 * @return array { 783 * @type array $groups Array of groups returned by paginated query. 784 * @type int $total Count of groups matching query. 785 * } 786 */ 787 public static function get_invites( $user_id, $limit = false, $page = false, $exclude = false ) { 788 return groups_get_invites_for_user( $user_id, $limit, $page, $exclude ); 789 } 790 791 /** 792 * Gets the total group invite count for a user. 793 * 794 * @since 2.0.0 795 * 796 * @param int $user_id The user ID. 797 * @return int 798 */ 799 public static function get_invite_count_for_user( $user_id = 0 ) { 800 return groups_get_invite_count_for_user( $user_id ); 801 } 802 803 /** 804 * Gets memberships of a user for purposes of a personal data export. 805 * 806 * @since 4.0.0 807 * 808 * @param int $user_id ID of the user. 809 * @param array $args { 810 * Array of optional arguments. 811 * @type int $page Page of memberships being requested. Default 1. 812 * @type int $per_page Memberships to return per page. Default 20. 813 * @type string $type Membership type being requested. Accepts 'membership', 814 * 'pending_request', 'pending_received_invitation', 815 * 'pending_sent_invitation'. Default 'membership'. 816 * } 817 * 818 * @return array 819 */ 820 public static function get_user_memberships( $user_id, $args = array() ) { 821 global $wpdb; 822 823 $bp = buddypress(); 824 825 $r = array_merge( array( 826 'page' => 1, 827 'per_page' => 20, 828 'type' => 'membership', 829 ), $args ); 830 831 $sql = array( 832 'select' => 'SELECT *', 833 'from' => "FROM {$bp->groups->table_name_members}", 834 'where' => '', 835 'limits' => '', 836 ); 837 838 switch ( $r['type'] ) { 839 case 'pending_request' : 840 return groups_get_requests( array( 841 'user_id' => $user_id, 842 'page' => $r['page'], 843 'per_page' => $r['per_page'], 844 ) ); 845 break; 846 847 case 'pending_received_invitation' : 848 return groups_get_invites( array( 849 'user_id' => $user_id, 850 'page' => $r['page'], 851 'per_page' => $r['per_page'], 852 ) ); 853 break; 854 855 case 'pending_sent_invitation' : 856 return groups_get_invites( array( 857 'inviter_id' => $user_id, 858 'page' => $r['page'], 859 'per_page' => $r['per_page'], 860 ) ); 861 break; 862 863 case 'membership' : 864 default : 865 $sql['where'] = $wpdb->prepare( "user_id = %d AND is_confirmed = 1", $user_id ); 866 break; 867 } 868 869 if ( $r['page'] && $r['per_page'] ) { 870 $sql['limits'] = $wpdb->prepare( "LIMIT %d, %d", ( $r['page'] - 1 ) * $r['per_page'], $r['per_page'] ); 871 } 872 873 $memberships = $wpdb->get_results( "{$sql['select']} {$sql['from']} WHERE {$sql['where']} {$sql['limits']}" ); 874 875 foreach ( $memberships as &$membership ) { 876 $membership->id = (int) $membership->id; 877 $membership->group_id = (int) $membership->group_id; 878 $membership->user_id = (int) $membership->user_id; 879 $membership->inviter_id = (int) $membership->inviter_id; 880 $membership->is_admin = (int) $membership->is_admin; 881 $membership->is_mod = (int) $membership->is_mod; 882 $membership->is_banned = (int) $membership->is_banned; 883 $membership->is_confirmed = (int) $membership->is_confirmed; 884 $membership->invite_sent = (int) $membership->invite_sent; 885 } 886 887 return $memberships; 888 } 889 890 /** 891 * Check whether a user has an outstanding invitation to a given group. 892 * 893 * @since 1.6.0 894 * 895 * @param int $user_id ID of the potential invitee. 896 * @param int $group_id ID of the group. 897 * @param string $type If 'sent', results are limited to those invitations 898 * that have actually been sent (non-draft). Default: 'sent'. 899 * @return int|null The ID of the invitation if found; null if not found. 900 */ 901 public static function check_has_invite( $user_id, $group_id, $type = 'sent' ) { 902 return groups_is_user_invited( $user_id, $group_id, $type ); 903 } 904 905 /** 906 * Delete an invitation, by specifying user ID and group ID. 907 * 908 * @since 1.6.0 909 * 910 * @global WPDB $wpdb 911 * 912 * @param int $user_id ID of the user. 913 * @param int $group_id ID of the group. 914 * @param int $inviter_id ID of the inviter. Specify if you want to delete 915 * a specific invite. Leave false if you want to 916 * delete all invites to this group. 917 * @return int Number of records deleted. 918 */ 919 public static function delete_invite( $user_id, $group_id, $inviter_id = false ) { 920 /** 921 * Fires before a group invitation is deleted. 922 * 923 * @since 2.6.0 924 * @since 5.0.0 Added $inviter_id 925 * 926 * @param int $user_id ID of the user. 927 * @param int $group_id ID of the group. 928 * @param int $inviter_id ID of the inviter. 929 */ 930 do_action( 'bp_groups_member_before_delete_invite', $user_id, $group_id, $inviter_id ); 931 932 return groups_delete_invite( $user_id, $group_id, $inviter_id ); 933 } 934 935 /** 936 * Delete an unconfirmed membership request, by user ID and group ID. 937 * 938 * @since 1.6.0 939 * 940 * @param int $user_id ID of the user. 941 * @param int $group_id ID of the group. 942 * @return int Number of records deleted. 943 */ 944 public static function delete_request( $user_id, $group_id ) { 945 return groups_delete_membership_request( false, $user_id, $group_id ); 946 } 947 948 /** 949 * Check whether a user is an admin of a given group. 950 * 951 * @since 1.6.0 952 * 953 * @param int $user_id ID of the user. 954 * @param int $group_id ID of the group. 955 * @return mixed 956 */ 957 public static function check_is_admin( $user_id, $group_id ) { 958 global $wpdb; 959 960 if ( empty( $user_id ) ) 961 return false; 962 963 $bp = buddypress(); 964 965 return $wpdb->query( $wpdb->prepare( "SELECT id FROM {$bp->groups->table_name_members} WHERE user_id = %d AND group_id = %d AND is_admin = 1 AND is_banned = 0", $user_id, $group_id ) ); 966 } 967 968 /** 969 * Check whether a user is a mod of a given group. 970 * 971 * @since 1.6.0 972 * 973 * @param int $user_id ID of the user. 974 * @param int $group_id ID of the group. 975 * @return mixed 976 */ 977 public static function check_is_mod( $user_id, $group_id ) { 978 global $wpdb; 979 980 if ( empty( $user_id ) ) 981 return false; 982 983 $bp = buddypress(); 984 985 return $wpdb->query( $wpdb->prepare( "SELECT id FROM {$bp->groups->table_name_members} WHERE user_id = %d AND group_id = %d AND is_mod = 1 AND is_banned = 0", $user_id, $group_id ) ); 986 } 987 988 /** 989 * Check whether a user is a member of a given group. 990 * 991 * @since 1.6.0 992 * 993 * @param int $user_id ID of the user. 994 * @param int $group_id ID of the group. 995 * @return mixed 996 */ 997 public static function check_is_member( $user_id, $group_id ) { 998 global $wpdb; 999 1000 if ( empty( $user_id ) ) 1001 return false; 1002 1003 $bp = buddypress(); 1004 1005 return $wpdb->query( $wpdb->prepare( "SELECT id FROM {$bp->groups->table_name_members} WHERE user_id = %d AND group_id = %d AND is_confirmed = 1 AND is_banned = 0", $user_id, $group_id ) ); 1006 } 1007 1008 /** 1009 * Check whether a user is banned from a given group. 1010 * 1011 * @since 1.6.0 1012 * 1013 * @param int $user_id ID of the user. 1014 * @param int $group_id ID of the group. 1015 * @return int|null int 1 if user is banned; int 0 if user is not banned; 1016 * null if user is not part of the group or if group doesn't exist. 1017 */ 1018 public static function check_is_banned( $user_id, $group_id ) { 1019 global $wpdb; 1020 1021 if ( empty( $user_id ) ) 1022 return false; 1023 1024 $bp = buddypress(); 1025 1026 $query = $wpdb->get_var( $wpdb->prepare( "SELECT is_banned FROM {$bp->groups->table_name_members} WHERE user_id = %d AND group_id = %d", $user_id, $group_id ) ); 1027 1028 return is_numeric( $query ) ? (int) $query : $query; 1029 } 1030 1031 /** 1032 * Is the specified user the creator of the group? 1033 * 1034 * @since 1.2.6 1035 * 1036 * @param int $user_id ID of the user. 1037 * @param int $group_id ID of the group. 1038 * @return int|null int of group ID if user is the creator; null on failure. 1039 */ 1040 public static function check_is_creator( $user_id, $group_id ) { 1041 global $wpdb; 1042 1043 if ( empty( $user_id ) ) 1044 return false; 1045 1046 $bp = buddypress(); 1047 1048 $query = $wpdb->get_var( $wpdb->prepare( "SELECT id FROM {$bp->groups->table_name} WHERE creator_id = %d AND id = %d", $user_id, $group_id ) ); 1049 1050 return is_numeric( $query ) ? (int) $query : $query; 1051 } 1052 1053 /** 1054 * Check whether a user has an outstanding membership request for a given group. 1055 * 1056 * @since 1.6.0 1057 * 1058 * @param int $user_id ID of the user. 1059 * @param int $group_id ID of the group. 1060 * @return int Database ID of the membership if found; int 0 on failure. 1061 */ 1062 public static function check_for_membership_request( $user_id, $group_id ) { 1063 return groups_is_user_pending( $user_id, $group_id ); 1064 } 1065 1066 /** 1067 * Get a list of randomly selected IDs of groups that the member belongs to. 1068 * 1069 * @since 1.6.0 1070 * 1071 * @param int $user_id ID of the user. 1072 * @param int $total_groups Max number of group IDs to return. Default: 5. 1073 * @return array Group IDs. 1074 */ 1075 public static function get_random_groups( $user_id = 0, $total_groups = 5 ) { 1076 global $wpdb; 1077 1078 $bp = buddypress(); 1079 1080 // If the user is logged in and viewing their random groups, we can show hidden and private groups. 1081 if ( bp_is_my_profile() ) { 1082 return array_map( 'intval', $wpdb->get_col( $wpdb->prepare( "SELECT DISTINCT group_id FROM {$bp->groups->table_name_members} WHERE user_id = %d AND is_confirmed = 1 AND is_banned = 0 ORDER BY rand() LIMIT %d", $user_id, $total_groups ) ) ); 1083 } else { 1084 return array_map( 'intval', $wpdb->get_col( $wpdb->prepare( "SELECT DISTINCT m.group_id FROM {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE m.group_id = g.id AND g.status != 'hidden' AND m.user_id = %d AND m.is_confirmed = 1 AND m.is_banned = 0 ORDER BY rand() LIMIT %d", $user_id, $total_groups ) ) ); 1085 } 1086 } 1087 1088 /** 1089 * Get the IDs of all a given group's members. 1090 * 1091 * @since 1.6.0 1092 * 1093 * @param int $group_id ID of the group. 1094 * @return array IDs of all group members. 1095 */ 1096 public static function get_group_member_ids( $group_id ) { 1097 global $wpdb; 1098 1099 $bp = buddypress(); 1100 1101 return array_map( 'intval', $wpdb->get_col( $wpdb->prepare( "SELECT user_id FROM {$bp->groups->table_name_members} WHERE group_id = %d AND is_confirmed = 1 AND is_banned = 0", $group_id ) ) ); 1102 } 1103 1104 /** 1105 * Get a list of all a given group's admins. 1106 * 1107 * @since 1.6.0 1108 * 1109 * @param int $group_id ID of the group. 1110 * @return array Info about group admins (user_id + date_modified). 1111 */ 1112 public static function get_group_administrator_ids( $group_id ) { 1113 global $wpdb; 1114 1115 if ( empty( $group_id ) ) { 1116 return array(); 1117 } 1118 1119 $group_admins = wp_cache_get( $group_id, 'bp_group_admins' ); 1120 1121 if ( false === $group_admins ) { 1122 self::prime_group_admins_mods_cache( array( $group_id ) ); 1123 $group_admins = wp_cache_get( $group_id, 'bp_group_admins' ); 1124 } 1125 1126 if ( false === $group_admins ) { 1127 // The wp_cache_get is still coming up empty. Return an empty array. 1128 $group_admins = array(); 1129 } else { 1130 // Cast the user_id property as an integer. 1131 foreach ( (array) $group_admins as $key => $data ) { 1132 $group_admins[ $key ]->user_id = (int) $group_admins[ $key ]->user_id; 1133 } 1134 } 1135 1136 return $group_admins; 1137 } 1138 1139 /** 1140 * Prime the bp_group_admins cache for one or more groups. 1141 * 1142 * @since 2.7.0 1143 * 1144 * @param array $group_ids IDs of the groups. 1145 * @return bool True on success. 1146 */ 1147 public static function prime_group_admins_mods_cache( $group_ids ) { 1148 global $wpdb; 1149 1150 $uncached = bp_get_non_cached_ids( $group_ids, 'bp_group_admins' ); 1151 1152 if ( $uncached ) { 1153 $bp = buddypress(); 1154 $uncached_sql = implode( ',', array_map( 'intval', $uncached ) ); 1155 $group_admin_mods = $wpdb->get_results( "SELECT user_id, group_id, date_modified, is_admin, is_mod FROM {$bp->groups->table_name_members} WHERE group_id IN ({$uncached_sql}) AND ( is_admin = 1 OR is_mod = 1 ) AND is_banned = 0" ); 1156 1157 $admins = $mods = array(); 1158 if ( $group_admin_mods ) { 1159 foreach ( $group_admin_mods as $group_admin_mod ) { 1160 $obj = new stdClass(); 1161 $obj->user_id = $group_admin_mod->user_id; 1162 $obj->date_modified = $group_admin_mod->date_modified; 1163 1164 if ( $group_admin_mod->is_admin ) { 1165 $admins[ $group_admin_mod->group_id ][] = $obj; 1166 } else { 1167 $mods[ $group_admin_mod->group_id ][] = $obj; 1168 } 1169 } 1170 } 1171 1172 // Prime cache for all groups, even those with no matches. 1173 foreach ( $uncached as $group_id ) { 1174 $group_admins = isset( $admins[ $group_id ] ) ? $admins[ $group_id ] : array(); 1175 wp_cache_set( $group_id, $group_admins, 'bp_group_admins' ); 1176 1177 $group_mods = isset( $mods[ $group_id ] ) ? $mods[ $group_id ] : array(); 1178 wp_cache_set( $group_id, $group_mods, 'bp_group_mods' ); 1179 } 1180 } 1181 } 1182 1183 /** 1184 * Get a list of all a given group's moderators. 1185 * 1186 * @since 1.6.0 1187 * 1188 * @param int $group_id ID of the group. 1189 * @return array Info about group mods (user_id + date_modified). 1190 */ 1191 public static function get_group_moderator_ids( $group_id ) { 1192 1193 if ( empty( $group_id ) ) { 1194 return array(); 1195 } 1196 1197 $group_mods = wp_cache_get( $group_id, 'bp_group_mods' ); 1198 1199 if ( false === $group_mods ) { 1200 self::prime_group_admins_mods_cache( array( $group_id ) ); 1201 $group_mods = wp_cache_get( $group_id, 'bp_group_mods' ); 1202 } 1203 1204 if ( false === $group_mods ) { 1205 // The wp_cache_get is still coming up empty. Return an empty array. 1206 $group_mods = array(); 1207 } else { 1208 // Cast the user_id property as an integer. 1209 foreach ( (array) $group_mods as $key => $data ) { 1210 $group_mods[ $key ]->user_id = (int) $group_mods[ $key ]->user_id; 1211 } 1212 } 1213 1214 return $group_mods; 1215 } 1216 1217 /** 1218 * Get group membership objects by ID (or an array of IDs). 1219 * 1220 * @since 2.6.0 1221 * 1222 * @param int|string|array $membership_ids Single membership ID or comma-separated/array list of membership IDs. 1223 * @return array 1224 */ 1225 public static function get_memberships_by_id( $membership_ids ) { 1226 global $wpdb; 1227 1228 $bp = buddypress(); 1229 1230 $membership_ids = implode( ',', wp_parse_id_list( $membership_ids ) ); 1231 return $wpdb->get_results( "SELECT * FROM {$bp->groups->table_name_members} WHERE id IN ({$membership_ids})" ); 1232 } 1233 1234 /** 1235 * Get the IDs users with outstanding membership requests to the group. 1236 * 1237 * @since 1.6.0 1238 * 1239 * @param int $group_id ID of the group. 1240 * @return array IDs of users with outstanding membership requests. 1241 */ 1242 public static function get_all_membership_request_user_ids( $group_id ) { 1243 return groups_get_membership_requested_user_ids( $group_id ); 1244 } 1245 1246 /** 1247 * Get members of a group. 1248 * 1249 * @deprecated 1.6.0 1250 * 1251 * @param int $group_id ID of the group being queried for. 1252 * @param bool|int $limit Max amount to return. 1253 * @param bool|int $page Pagination value. 1254 * @param bool $exclude_admins_mods Whether or not to exclude admins and moderators. 1255 * @param bool $exclude_banned Whether or not to exclude banned members. 1256 * @param bool|array $exclude Array of user IDs to exclude. 1257 * @return false|array 1258 */ 1259 public static function get_all_for_group( $group_id, $limit = false, $page = false, $exclude_admins_mods = true, $exclude_banned = true, $exclude = false ) { 1260 global $wpdb; 1261 1262 _deprecated_function( __METHOD__, '1.8', 'BP_Group_Member_Query' ); 1263 1264 $pag_sql = ''; 1265 if ( !empty( $limit ) && !empty( $page ) ) 1266 $pag_sql = $wpdb->prepare( "LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) ); 1267 1268 $exclude_admins_sql = ''; 1269 if ( !empty( $exclude_admins_mods ) ) 1270 $exclude_admins_sql = "AND is_admin = 0 AND is_mod = 0"; 1271 1272 $banned_sql = ''; 1273 if ( !empty( $exclude_banned ) ) 1274 $banned_sql = " AND is_banned = 0"; 1275 1276 $exclude_sql = ''; 1277 if ( !empty( $exclude ) ) { 1278 $exclude = implode( ',', wp_parse_id_list( $exclude ) ); 1279 $exclude_sql = " AND m.user_id NOT IN ({$exclude})"; 1280 } 1281 1282 $bp = buddypress(); 1283 1284 if ( bp_is_active( 'xprofile' ) ) { 1285 1286 /** 1287 * Filters the SQL prepared statement used to fetch group members. 1288 * 1289 * @since 1.5.0 1290 * 1291 * @param string $value SQL prepared statement for fetching group members. 1292 */ 1293 $members = $wpdb->get_results( apply_filters( 'bp_group_members_user_join_filter', $wpdb->prepare( "SELECT m.user_id, m.date_modified, m.is_banned, u.user_login, u.user_nicename, u.user_email, pd.value as display_name FROM {$bp->groups->table_name_members} m, {$wpdb->users} u, {$bp->profile->table_name_data} pd WHERE u.ID = m.user_id AND u.ID = pd.user_id AND pd.field_id = 1 AND group_id = %d AND is_confirmed = 1 {$banned_sql} {$exclude_admins_sql} {$exclude_sql} ORDER BY m.date_modified DESC {$pag_sql}", $group_id ) ) ); 1294 } else { 1295 1296 /** This filter is documented in bp-groups/bp-groups-classes */ 1297 $members = $wpdb->get_results( apply_filters( 'bp_group_members_user_join_filter', $wpdb->prepare( "SELECT m.user_id, m.date_modified, m.is_banned, u.user_login, u.user_nicename, u.user_email, u.display_name FROM {$bp->groups->table_name_members} m, {$wpdb->users} u WHERE u.ID = m.user_id AND group_id = %d AND is_confirmed = 1 {$banned_sql} {$exclude_admins_sql} {$exclude_sql} ORDER BY m.date_modified DESC {$pag_sql}", $group_id ) ) ); 1298 } 1299 1300 if ( empty( $members ) ) { 1301 return false; 1302 } 1303 1304 if ( empty( $pag_sql ) ) { 1305 $total_member_count = count( $members ); 1306 } else { 1307 1308 /** 1309 * Filters the SQL prepared statement used to fetch group members total count. 1310 * 1311 * @since 1.5.0 1312 * 1313 * @param string $value SQL prepared statement for fetching group member count. 1314 */ 1315 $total_member_count = $wpdb->get_var( apply_filters( 'bp_group_members_count_user_join_filter', $wpdb->prepare( "SELECT COUNT(user_id) FROM {$bp->groups->table_name_members} m WHERE group_id = %d AND is_confirmed = 1 {$banned_sql} {$exclude_admins_sql} {$exclude_sql}", $group_id ) ) ); 1316 } 1317 1318 // Fetch whether or not the user is a friend. 1319 foreach ( (array) $members as $user ) 1320 $user_ids[] = $user->user_id; 1321 1322 $user_ids = implode( ',', wp_parse_id_list( $user_ids ) ); 1323 1324 if ( bp_is_active( 'friends' ) ) { 1325 $friend_status = $wpdb->get_results( $wpdb->prepare( "SELECT initiator_user_id, friend_user_id, is_confirmed FROM {$bp->friends->table_name} WHERE (initiator_user_id = %d AND friend_user_id IN ( {$user_ids} ) ) OR (initiator_user_id IN ( {$user_ids} ) AND friend_user_id = %d )", bp_loggedin_user_id(), bp_loggedin_user_id() ) ); 1326 for ( $i = 0, $count = count( $members ); $i < $count; ++$i ) { 1327 foreach ( (array) $friend_status as $status ) { 1328 if ( $status->initiator_user_id == $members[$i]->user_id || $status->friend_user_id == $members[$i]->user_id ) { 1329 $members[$i]->is_friend = $status->is_confirmed; 1330 } 1331 } 1332 } 1333 } 1334 1335 return array( 'members' => $members, 'count' => $total_member_count ); 1336 } 1337 1338 /** 1339 * Get all membership IDs for a user. 1340 * 1341 * @since 2.6.0 1342 * 1343 * @param int $user_id ID of the user. 1344 * @return array 1345 */ 1346 public static function get_membership_ids_for_user( $user_id ) { 1347 global $wpdb; 1348 1349 $bp = buddypress(); 1350 1351 $group_ids = $wpdb->get_col( $wpdb->prepare( "SELECT id FROM {$bp->groups->table_name_members} WHERE user_id = %d ORDER BY id ASC", $user_id ) ); 1352 1353 return $group_ids; 1354 } 1355 1356 /** 1357 * Delete all memberships for a given group. 1358 * 1359 * @since 1.6.0 1360 * 1361 * @param int $group_id ID of the group. 1362 * @return int Number of records deleted. 1363 */ 1364 public static function delete_all( $group_id ) { 1365 global $wpdb; 1366 1367 $bp = buddypress(); 1368 1369 return $wpdb->query( $wpdb->prepare( "DELETE FROM {$bp->groups->table_name_members} WHERE group_id = %d", $group_id ) ); 1370 } 1371 1372 /** 1373 * Delete all group membership information for the specified user. 1374 * 1375 * In cases where the user is the sole member of a group, a site administrator is 1376 * assigned to be the group's administrator. Unhook `groups_remove_data_for_user()` 1377 * to modify this behavior. 1378 * 1379 * @since 1.0.0 1380 * @since 4.0.0 The method behavior was changed so that single-member groups are not deleted. 1381 * 1382 * @param int $user_id ID of the user. 1383 * @return bool 1384 */ 1385 public static function delete_all_for_user( $user_id ) { 1386 $group_ids = BP_Groups_Member::get_group_ids( $user_id ); 1387 1388 foreach ( $group_ids['groups'] as $group_id ) { 1389 if ( groups_is_user_admin( $user_id, $group_id ) ) { 1390 // If the user is a sole group admin, install a site admin as their replacement. 1391 if ( count( groups_get_group_admins( $group_id ) ) < 2 ) { 1392 $admin = get_users( array( 1393 'blog_id' => bp_get_root_blog_id(), 1394 'fields' => 'id', 1395 'number' => 1, 1396 'orderby' => 'ID', 1397 'role' => 'administrator', 1398 ) ); 1399 1400 if ( ! empty( $admin ) ) { 1401 groups_join_group( $group_id, $admin[0] ); 1402 1403 $member = new BP_Groups_Member( $admin[0], $group_id ); 1404 $member->promote( 'admin' ); 1405 } 1406 } 1407 } 1408 1409 BP_Groups_Member::delete( $user_id, $group_id ); 1410 } 1411 1412 return true; 1413 } 1414 }
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Thu Nov 21 01:00:57 2024 | Cross-referenced by PHPXref 0.7.1 |