Changeset 3856 for branches/plugin/bbp-admin/bbp-tools.php

Timestamp:

04/28/2012 10:55:53 PM (13 years ago)

Author:

johnjamesjacoby

Message:

Allow user favorites and subscriptions to work per site on multisite installations. Props isaacchapman. Fixes #1818.

File:

• branches/plugin/bbp-admin/bbp-tools.php (modified) (7 diffs)

branches/plugin/bbp-admin/bbp-tools.php

@@ -723 +723 @@
     $statement = __( 'Removing trashed topics from user favorites… %s', 'bbpress' );
     $result    = __( 'Failed!', 'bbpress' );
-
-    $users = $wpdb->get_results( "SELECT `user_id`, `meta_value` AS `favorites` FROM `$wpdb->usermeta` WHERE `meta_key` = '_bbp_favorites';" );
+    $key       = bbp_get_favorites_key();
+    $users     = $wpdb->get_results( "SELECT `user_id`, `meta_value` AS `favorites` FROM `{$wpdb->usermeta}` WHERE `meta_key` = '{$key}';" );
+
     if ( is_wp_error( $users ) )
         return array( 1, sprintf( $statement, $result ) );
 
-    $topics = $wpdb->get_col( "SELECT `ID` FROM `$wpdb->posts` WHERE `post_type` = '" . bbp_get_topic_post_type() . "' AND `post_status` = '" . bbp_get_public_status_id() . "';" );
+    $topics = $wpdb->get_col( "SELECT `ID` FROM `{$wpdb->posts}` WHERE `post_type` = '" . bbp_get_topic_post_type() . "' AND `post_status` = '" . bbp_get_public_status_id() . "';" );
 
     if ( is_wp_error( $topics ) )
@@ -743 +744 @@
 
         $favorites = join( ',', $favorites );
-        $values[] = "('$user->user_id', '_bbp_favorites', '$favorites')";
+        $values[] = "('{$user->user_id}', '{$key}, '{$favorites}')";
     }
 
@@ -751 +752 @@
     }
 
-    $sql_delete = "DELETE FROM `$wpdb->usermeta` WHERE `meta_key` = '_bbp_favorites';";
+    $sql_delete = "DELETE FROM `{$wpdb->usermeta}` WHERE `meta_key` = '{$key}';";
     if ( is_wp_error( $wpdb->query( $sql_delete ) ) )
         return array( 4, sprintf( $statement, $result ) );
@@ -782 +783 @@
     $statement = __( 'Removing trashed topics from user subscriptions… %s', 'bbpress' );
     $result    = __( 'Failed!', 'bbpress' );
-
-    $users = $wpdb->get_results( "SELECT `user_id`, `meta_value` AS `subscriptions` FROM `$wpdb->usermeta` WHERE `meta_key` = '_bbp_subscriptions';" );
+    $key       = bbp_get_subscriptions_key();
+    $users     = $wpdb->get_results( "SELECT `user_id`, `meta_value` AS `subscriptions` FROM `{$wpdb->usermeta}` WHERE `meta_key` = '{$key}';" );
+
     if ( is_wp_error( $users ) )
         return array( 1, sprintf( $statement, $result ) );
 
-    $topics = $wpdb->get_col( "SELECT `ID` FROM `$wpdb->posts` WHERE `post_type` = '" . bbp_get_topic_post_type() . "' AND `post_status` = '" . bbp_get_public_status_id() . "';" );
+    $topics = $wpdb->get_col( "SELECT `ID` FROM `{$wpdb->posts}` WHERE `post_type` = '" . bbp_get_topic_post_type() . "' AND `post_status` = '" . bbp_get_public_status_id() . "';" );
     if ( is_wp_error( $topics ) )
         return array( 2, sprintf( $statement, $result ) );
@@ -801 +803 @@
 
         $subscriptions = join( ',', $subscriptions );
-        $values[] = "('$user->user_id', '_bbp_subscriptions', '$subscriptions')";
+        $values[] = "('{$user->user_id}', '{$key}', '{$subscriptions}')";
     }
 
@@ -809 +811 @@
     }
 
-    $sql_delete = "DELETE FROM `$wpdb->usermeta` WHERE `meta_key` = '_bbp_subscriptions';";
+    $sql_delete = "DELETE FROM `{$wpdb->usermeta}` WHERE `meta_key` = '{$key}';";
     if ( is_wp_error( $wpdb->query( $sql_delete ) ) )
         return array( 4, sprintf( $statement, $result ) );
@@ -816 +818 @@
     foreach ( $values as $chunk ) {
         $chunk = "\n" . join( ",\n", $chunk );
-        $sql_insert = "INSERT INTO `$wpdb->usermeta` (`user_id`, `meta_key`, `meta_value`) VALUES $chunk;";
+        $sql_insert = "INSERT INTO `{$wpdb->usermeta}` (`user_id`, `meta_key`, `meta_value`) VALUES $chunk;";
         if ( is_wp_error( $wpdb->query( $sql_insert ) ) )
             return array( 5, sprintf( $statement, $result ) );