Changeset 8661

Timestamp:

07/22/2014 06:09:59 PM (11 years ago)

Author:

johnjamesjacoby

Message:

Remove incorrect prepare() usage in get_current_threads_for_user(). See #5388.

File:

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

trunk/src/bp-messages/bp-messages-classes.php

@@ -271 +271 @@
             $user_id_sql = $wpdb->prepare( 'm.sender_id = %d', $user_id );
             $thread_ids  = $wpdb->get_results( "SELECT m.thread_id, MAX(m.date_sent) AS date_sent FROM {$bp->messages->table_name_recipients} r, {$bp->messages->table_name_messages} m WHERE m.thread_id = r.thread_id AND m.sender_id = r.user_id AND {$user_id_sql} AND r.is_deleted = 0 {$search_sql} GROUP BY m.thread_id ORDER BY date_sent DESC {$pag_sql}" );
-            $total_threads = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT( DISTINCT m.thread_id ) FROM {$bp->messages->table_name_recipients} r, {$bp->messages->table_name_messages} m WHERE m.thread_id = r.thread_id AND m.sender_id = r.user_id AND {$user_id_sql} AND r.is_deleted = 0 {$search_sql} ", $user_id ) );
+            $total_threads = $wpdb->get_var( "SELECT COUNT( DISTINCT m.thread_id ) FROM {$bp->messages->table_name_recipients} r, {$bp->messages->table_name_messages} m WHERE m.thread_id = r.thread_id AND m.sender_id = r.user_id AND {$user_id_sql} AND r.is_deleted = 0 {$search_sql} " );
         } else {
             $user_id_sql = $wpdb->prepare( 'r.user_id = %d', $user_id );