Changeset 924

Timestamp:

10/21/2014 11:15:55 PM (10 years ago)

Author:

nacin

Message:

Credits: Use new table prefix.

props markoheijnen.
fixes #664.

File:

• sites/trunk/api.wordpress.org/public_html/core/credits/wp-credits.php (modified) (1 diff)

sites/trunk/api.wordpress.org/public_html/core/credits/wp-credits.php

@@ -191 +191 @@
     protected function grab_validators( $gp_locale ) {
         global $wpdb;
-        $blog_id = $wpdb->get_var( $wpdb->prepare( "SELECT blog_id FROM ros_blogs INNER JOIN locales ON ros_blogs.domain = CONCAT(locales.subdomain, '.wordpress.org') WHERE locales.locale = %s", $gp_locale->wp_locale ) );
+        $blog_id = $wpdb->get_var( $wpdb->prepare( "SELECT blog_id FROM wporg_blogs INNER JOIN locales ON wporg_blogs.domain = CONCAT(locales.subdomain, '.wordpress.org') WHERE locales.locale = %s", $gp_locale->wp_locale ) );
         if ( $blog_id ) {
-            $meta_key = 'ros_' . intval( $blog_id ) . '_capabilities';
+            $meta_key = 'wporg_' . intval( $blog_id ) . '_capabilities';
             return $wpdb->get_col( "SELECT user_id FROM $wpdb->usermeta WHERE meta_key = '$meta_key' AND meta_value NOT LIKE '%subscriber%'" );
         }