Changeset 13557

Timestamp:

08/24/2023 07:45:32 PM (19 months ago)

Author:

imath

Message:

Improve table alias sanitization in BP_XProfile_Query

(Trunk)

File:

• trunk/src/bp-xprofile/classes/class-bp-xprofile-query.php (modified) (2 diffs)

trunk/src/bp-xprofile/classes/class-bp-xprofile-query.php

@@ -341 +341 @@
      *
      * @since 2.2.0
-     * 
+     *
      * @global wpdb $wpdb WordPress database object.
      *
@@ -525 +525 @@
             $sibling_compare = strtoupper( $sibling['compare'] );
             if ( in_array( $clause_compare, $compatible_compares ) && in_array( $sibling_compare, $compatible_compares ) ) {
-                $alias = $sibling['alias'];
+                $alias = preg_replace( '/\W/', '_', $sibling['alias'] );
                 break;
             }