Changeset 12866 for trunk/src/bp-core/classes/class-bp-invitation.php

Timestamp:

03/17/2021 08:35:54 PM (2 years ago)

Author:

dcavins

Message:

BP_Invitation: Improve search_terms support for useful columns.

Instead of searching the class column, which would potentially return
surprising results, search the invitee_email and content columns.

Fixes #8443.

File:

• trunk/src/bp-core/classes/class-bp-invitation.php (modified) (2 diffs)

trunk/src/bp-core/classes/class-bp-invitation.php

@@ -423 +423 @@
          * Only create a where statement if something less than "all" has been
          * specifically requested.
-         */ 
+         */
         if ( ! empty( $args['invite_sent'] ) && 'all' !== $args['invite_sent'] ) {
             if ( $args['invite_sent'] == 'draft' ) {
@@ -444 +444 @@
         if ( ! empty( $args['search_terms'] ) ) {
             $search_terms_like = '%' . bp_esc_like( $args['search_terms'] ) . '%';
-            $where_conditions['search_terms'] = $wpdb->prepare( "( class LIKE %s )", $search_terms_like, $search_terms_like );
+            $where_conditions['search_terms'] = $wpdb->prepare( '( invitee_email LIKE %s OR content LIKE %s )', $search_terms_like, $search_terms_like );
         }