Changeset 7710

Timestamp:

12/21/2013 12:40:12 PM (11 years ago)

Author:

djpaul

Message:

xprofile: remove unnecessary $wpdb->prepare in BP_XProfile_ProfileData->get_random().

Props graham-washbrook for initial patch, fixes #5309

File:

• trunk/bp-xprofile/bp-xprofile-classes.php (modified) (1 diff)

trunk/bp-xprofile/bp-xprofile-classes.php

@@ -1265 +1265 @@
         global $wpdb, $bp;
 
-        if ( !empty( $exclude_fullname ) )
-            $exclude_sql = $wpdb->prepare( " AND pf.id != 1" );
+        $exclude_sql = ! empty( $exclude_fullname ) ? ' AND pf.id != 1' : '';
 
         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 ) );