Changeset 3856 for branches/plugin/bbp-includes/bbp-user-functions.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-includes/bbp-user-functions.php (modified) (10 diffs)

branches/plugin/bbp-includes/bbp-user-functions.php

@@ -216 +216 @@
 
 /**
+ * Get the meta key for favorites, based on blog prefix
+ *
+ * @since bbPress (r3856)
+ * @param int $blog_id Optional blog id to switch to
+ * @global WPDB $wpdb
+ * @return string 
+ */
+function bbp_get_favorites_key( $blog_id = 0 ) {
+    global $wpdb;
+
+    // If blog ID is passed, switch to that blog
+    if ( !empty( $blog_id ) ) {
+        switch_to_blog( $blog_id );
+        $prefix = $wpdb->prefix;
+        restore_current_blog();
+
+    // Use current blog
+    } else {
+        $prefix = $wpdb->prefix;
+    }
+
+    return apply_filters( 'bbp_get_favorites_key', '_bbp_' . $prefix . 'favorites', $blog_id, $prefix );
+}
+
+/**
  * Get the users who have made the topic favorite
  *
@@ -233 +258 @@
 
     // Get the users who have favorited the topic
-    $users = $wpdb->get_col( "SELECT user_id FROM {$wpdb->usermeta} WHERE meta_key = '_bbp_favorites' and FIND_IN_SET('{$topic_id}', meta_value) > 0" );
+    $key   = bbp_get_favorites_key();
+    $users = $wpdb->get_col( "SELECT user_id FROM {$wpdb->usermeta} WHERE meta_key = '{$key}' and FIND_IN_SET('{$topic_id}', meta_value) > 0" );
     $users = apply_filters( 'bbp_get_topic_favoriters', $users, $topic_id );
 
@@ -289 +315 @@
             return false;
 
-        $favorites = (string) get_user_meta( $user_id, '_bbp_favorites', true );
+        $favorites = (string) get_user_meta( $user_id, bbp_get_favorites_key(), true );
         $favorites = (array) explode( ',', $favorites );
         $favorites = array_filter( $favorites );
@@ -370 +396 @@
         $favorites   = array_filter( $favorites );
         $favorites   = (string) implode( ',', $favorites );
-        update_user_meta( $user_id, '_bbp_favorites', $favorites );
+        update_user_meta( $user_id, bbp_get_favorites_key(), $favorites );
     }
 
@@ -407 +433 @@
         if ( !empty( $favorites ) ) {
             $favorites = implode( ',', $favorites );
-            update_user_meta( $user_id, '_bbp_favorites', $favorites );
+            update_user_meta( $user_id, bbp_get_favorites_key(), $favorites );
         } else {
-            delete_user_meta( $user_id, '_bbp_favorites' );
+            delete_user_meta( $user_id, bbp_get_favorites_key() );
         }
     }
@@ -520 +546 @@
 
 /**
+ * Get the meta key for subscriptions, based on blog prefix
+ *
+ * @since bbPress (r3856)
+ * @global WPDB $wpdb
+ * @return string 
+ */
+function bbp_get_subscriptions_key( $blog_id = 0 ) {
+    global $wpdb;
+
+    // If blog ID is passed, switch to that blog
+    if ( !empty( $blog_id ) ) {
+        switch_to_blog( $blog_id );
+        $prefix = $wpdb->prefix;
+        restore_current_blog();
+
+    // Use current blog
+    } else {
+        $prefix = $wpdb->prefix;
+    }
+
+    return apply_filters( 'bbp_get_subscriptions_key', '_bbp_' . $prefix . 'subscriptions', $blog_id, $prefix );
+}
+
+/**
  * Get the users who have subscribed to the topic
  *
@@ -534 +584 @@
     global $wpdb;
 
+    $key   = bbp_get_subscriptions_key();
     $users = wp_cache_get( 'bbp_get_topic_subscribers_' . $topic_id, 'bbpress' );
     if ( empty( $users ) ) {
-        $users = $wpdb->get_col( "SELECT user_id FROM {$wpdb->usermeta} WHERE meta_key = '_bbp_subscriptions' and FIND_IN_SET('{$topic_id}', meta_value) > 0" );
+        $users = $wpdb->get_col( "SELECT user_id FROM {$wpdb->usermeta} WHERE meta_key = '{$key}' and FIND_IN_SET('{$topic_id}', meta_value) > 0" );
         wp_cache_set( 'bbp_get_topic_subscribers_' . $topic_id, $users, 'bbpress' );
     }
@@ -594 +645 @@
         return false;
 
-    $subscriptions = (string) get_user_meta( $user_id, '_bbp_subscriptions', true );
+    $subscriptions = (string) get_user_meta( $user_id, bbp_get_subscriptions_key(), true );
     $subscriptions = (array) explode( ',', $subscriptions );
     $subscriptions = array_filter( $subscriptions );
@@ -678 +729 @@
         $subscriptions   = array_filter( $subscriptions );
         $subscriptions   = (string) implode( ',', $subscriptions );
-        update_user_meta( $user_id, '_bbp_subscriptions', $subscriptions );
+        update_user_meta( $user_id, bbp_get_subscriptions_key(), $subscriptions );
 
         wp_cache_delete( 'bbp_get_topic_subscribers_' . $topic_id, 'bbpress' );
@@ -719 +770 @@
         if ( !empty( $subscriptions ) ) {
             $subscriptions = implode( ',', $subscriptions );
-            update_user_meta( $user_id, '_bbp_subscriptions', $subscriptions );
+            update_user_meta( $user_id, bbp_get_subscriptions_key(), $subscriptions );
         } else {
-            delete_user_meta( $user_id, '_bbp_subscriptions' );
+            delete_user_meta( $user_id, bbp_get_subscriptions_key() );
         }