Skip to:
Content

BuddyPress.org


Ignore:
Timestamp:
12/04/2012 12:03:40 PM (13 years ago)
Author:
djpaul
Message:

Fix alot of WPDB->Prepare() warnings in the 1.6 branch. See #4654

File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/1.6/bp-forums/bp-forums-functions.php

    r6108 r6557  
    471471
    472472    // Fetch the topic's last poster details
    473     $poster_details = $wpdb->get_results( $wpdb->prepare( "SELECT t.topic_id, t.topic_last_poster, u.user_login, u.user_nicename, u.user_email, u.display_name FROM {$wpdb->users} u, {$bbdb->topics} t WHERE u.ID = t.topic_last_poster AND t.topic_id IN ( {$topic_ids} )" ) );
     473    $poster_details = $wpdb->get_results( "SELECT t.topic_id, t.topic_last_poster, u.user_login, u.user_nicename, u.user_email, u.display_name FROM {$wpdb->users} u, {$bbdb->topics} t WHERE u.ID = t.topic_last_poster AND t.topic_id IN ( {$topic_ids} )" );
    474474    for ( $i = 0, $count = count( $topics ); $i < $count; ++$i ) {
    475475        foreach ( (array) $poster_details as $poster ) {
    … …  
    485485    // Fetch fullname for the topic's last poster
    486486    if ( bp_is_active( 'xprofile' ) ) {
    487         $poster_names = $wpdb->get_results( $wpdb->prepare( "SELECT t.topic_id, pd.value FROM {$bp->profile->table_name_data} pd, {$bbdb->topics} t WHERE pd.user_id = t.topic_last_poster AND pd.field_id = 1 AND t.topic_id IN ( {$topic_ids} )" ) );
     487        $poster_names = $wpdb->get_results( "SELECT t.topic_id, pd.value FROM {$bp->profile->table_name_data} pd, {$bbdb->topics} t WHERE pd.user_id = t.topic_last_poster AND pd.field_id = 1 AND t.topic_id IN ( {$topic_ids} )" );
    488488        for ( $i = 0, $count = count( $topics ); $i < $count; ++$i ) {
    489489            foreach ( (array) $poster_names as $name ) {
    … …  
    610610
    611611    // Fetch the poster's user_email, user_nicename and user_login
    612     $poster_details = $wpdb->get_results( $wpdb->prepare( "SELECT u.ID as user_id, u.user_login, u.user_nicename, u.user_email, u.display_name FROM {$wpdb->users} u WHERE u.ID IN ( {$user_ids} )" ) );
     612    $poster_details = $wpdb->get_results( "SELECT u.ID as user_id, u.user_login, u.user_nicename, u.user_email, u.display_name FROM {$wpdb->users} u WHERE u.ID IN ( {$user_ids} )" );
    613613
    614614    for ( $i = 0, $count = count( $posts ); $i < $count; ++$i ) {
    … …  
    625625    // Fetch fullname for each poster.
    626626    if ( bp_is_active( 'xprofile' ) ) {
    627         $poster_names = $wpdb->get_results( $wpdb->prepare( "SELECT pd.user_id, pd.value FROM {$bp->profile->table_name_data} pd WHERE pd.user_id IN ( {$user_ids} )" ) );
     627        $poster_names = $wpdb->get_results( "SELECT pd.user_id, pd.value FROM {$bp->profile->table_name_data} pd WHERE pd.user_id IN ( {$user_ids} )" );
    628628        for ( $i = 0, $count = count( $posts ); $i < $count; ++$i ) {
    629629            foreach ( (array) $poster_names as $name ) {
Note: See TracChangeset for help on using the changeset viewer.