Changeset 3633

Timestamp:

11/26/2011 09:24:26 PM (12 years ago)

Author:

johnjamesjacoby

Message:

Introduce raw functions for getting user topic and reply post counts directly from the posts table. See #1694.

File:

• branches/plugin/bbp-includes/bbp-user-functions.php (modified) (1 diff)

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

@@ -161 +161 @@
 
     return apply_filters( 'bbp_current_author_ua', $retval );
+}
+
+/** Post Counts ***************************************************************/
+
+/**
+ * Return the raw database count of topics by a user
+ *
+ * @since bbPress (r3633)
+ * @global WPDB $wpdb
+ * @uses bbp_get_user_id()
+ * @uses get_posts_by_author_sql()
+ * @uses bbp_get_topic_post_type()
+ * @uses apply_filters()
+ * @return int Raw DB count of topics
+ */
+function bbp_get_user_topic_count_raw( $user_id = 0 ) {
+    if ( !$user_id = bbp_get_user_id( $user_id ) )
+        return false;
+
+    global $wpdb;
+
+    $where = get_posts_by_author_sql( bbp_get_topic_post_type(), true, $user_id );
+    $count = (int) $wpdb->get_var( "SELECT COUNT(*) FROM {$wpdb->posts} {$where}" );
+
+    return (int) apply_filters( 'bbp_get_user_topic_count_raw', $count, $user_id );
+}
+
+/**
+ * Return the raw database count of replies by a user
+ *
+ * @since bbPress (r3633)
+ * @global WPDB $wpdb
+ * @uses bbp_get_user_id()
+ * @uses get_posts_by_author_sql()
+ * @uses bbp_get_reply_post_type()
+ * @uses apply_filters()
+ * @return int Raw DB count of replies
+ */
+function bbp_get_user_reply_count_raw( $user_id = 0 ) {
+    if ( !$user_id = bbp_get_user_id( $user_id ) )
+        return false;
+
+    global $wpdb;
+
+    $where = get_posts_by_author_sql( bbp_get_reply_post_type(), true, $user_id );
+    $count = (int) $wpdb->get_var( "SELECT COUNT(*) FROM {$wpdb->posts} {$where}" );
+
+    return (int) apply_filters( 'bbp_get_user_reply_count_raw', $count, $user_id );
 }