Changeset 14181

Timestamp:

11/20/2024 07:34:17 PM (7 weeks ago)

Author:

coffee2code

Message:

Photo Directory, Search: Prevent table name collisions in searches with an explicit taxonomy.

Props ryelle.
See #7815.

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/photo-directory/inc/search.php (modified) (2 diffs)

sites/trunk/wordpress.org/public_html/wp-content/plugins/photo-directory/inc/search.php

@@ -82 +82 @@
             $join .= "
                 LEFT JOIN
-                  {$wpdb->term_relationships} ON {$wpdb->posts}.ID = {$wpdb->term_relationships}.object_id
+                    {$wpdb->term_relationships} AS tr_search ON {$wpdb->posts}.ID = tr_search.object_id
                 LEFT JOIN
-                  {$wpdb->term_taxonomy} ON {$wpdb->term_taxonomy}.term_taxonomy_id = {$wpdb->term_relationships}.term_taxonomy_id
+                    {$wpdb->term_taxonomy} AS tt_search ON tt_search.term_taxonomy_id = tr_search.term_taxonomy_id
                 LEFT JOIN
-                  {$wpdb->terms} ON {$wpdb->terms}.term_id = {$wpdb->term_taxonomy}.term_id
+                    {$wpdb->terms} AS t_search ON t_search.term_id = tt_search.term_id
               ";
         }
@@ -132 +132 @@
                 $or_tag = $wpdb->prepare( "OR
                     (
-                        {$wpdb->term_taxonomy}.taxonomy = %s
+                        tt_search.taxonomy = %s
                         AND
-                        {$wpdb->terms}.name = %s
+                        t_search.name = %s
                     ) ",
                     Registrations::get_taxonomy( 'tags' ),