Changeset 6518 for trunk/bp-friends/bp-friends-classes.php

Timestamp:

11/14/2012 08:04:09 PM (14 years ago)

Author:

djpaul

Message:

Fix more prepare() warnings. See #4654

File:

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

trunk/bp-friends/bp-friends-classes.php

@@ -85 +85 @@
 
                 if ( !empty( $friend_requests_only ) ) {
-                        $oc_sql = $wpdb->prepare( "AND is_confirmed = 0" );
-                        $friend_sql = $wpdb->prepare ( " WHERE friend_user_id = %d", $user_id );
-                } else {
-                        $oc_sql = $wpdb->prepare( "AND is_confirmed = 1" );
-                        $friend_sql = $wpdb->prepare ( " WHERE (initiator_user_id = %d OR friend_user_id = %d)", $user_id, $user_id );
-                }
-
-                $friends = $wpdb->get_results( $wpdb->prepare( "SELECT friend_user_id, initiator_user_id FROM {$bp->friends->table_name} $friend_sql $oc_sql ORDER BY date_created DESC" ) );
+                        $oc_sql = 'AND is_confirmed = 0';
+                        $friend_sql = $wpdb->prepare( " WHERE friend_user_id = %d", $user_id );
+                } else {
+                        $oc_sql = 'AND is_confirmed = 1';
+                        $friend_sql = $wpdb->prepare( " WHERE (initiator_user_id = %d OR friend_user_id = %d)", $user_id, $user_id );
+                }
+
+                $friends = $wpdb->get_results( "SELECT friend_user_id, initiator_user_id FROM {$bp->friends->table_name} $friend_sql $oc_sql ORDER BY date_created DESC" );
                 $fids = array();