Changeset 7701 for trunk/bp-core/bp-core-classes.php

Timestamp:

12/18/2013 12:05:32 AM (11 years ago)

Author:

johnjamesjacoby

Message:

Use correct ID column name rather than id. Reverts testing code accidentally committed in r7700. See #5303.

File:

• trunk/bp-core/bp-core-classes.php (modified) (2 diffs)

trunk/bp-core/bp-core-classes.php

@@ -302 +302 @@
                 // the xprofile table
                 } else {
-                    $fullname_field_id = $wpdb->get_var( $wpdb->prepare( "SELECT id FROM {$bp->profile->table_name_fields} WHERE name = %s", bp_xprofile_fullname_field_name() ) );
+                    $fullname_field_id = $wpdb->get_var( $wpdb->prepare( "SELECT ID FROM {$bp->profile->table_name_fields} WHERE name = %s", bp_xprofile_fullname_field_name() ) );
 
                     $this->uid_name = 'user_id';
@@ -314 +314 @@
                 // to infer spam/deleted/non-activated users. To ensure that these users
                 // are filtered out, we add an appropriate sub-query.
-                $sql['where'][] = "u.{$this->uid_name} IN ( SELECT id FROM {$wpdb->users} WHERE " . bp_core_get_status_sql( '' ) . " )";
+                $sql['where'][] = "u.{$this->uid_name} IN ( SELECT ID FROM {$wpdb->users} WHERE " . bp_core_get_status_sql( '' ) . " )";
 
                 break;