Changeset 5860

Timestamp:

09/03/2017 09:29:57 AM (8 years ago)

Author:

SergeyBiryukov

Message:

Support Forums: Introduce Users::get_user_topics_count() and ::get_user_reviews_count() methods.

The code is relocated from the wporg-support theme.

See #2967, #2772.

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/support-forums/inc/class-users.php (modified) (1 diff)

sites/trunk/wordpress.org/public_html/wp-content/plugins/support-forums/inc/class-users.php

@@ -264 +264 @@
     }
 
+    /**
+     * Return the raw database count of topics by a user, excluding reviews.
+     *
+     * @global wpdb $wpdb WordPress database abstraction object.
+     *
+     * @param int $user_id User ID to get count for.
+     * @return int Raw DB count of topics.
+     */
+    public function get_user_topics_count( $user_id = 0 ) {
+        global $wpdb;
+
+        $user_id = bbp_get_user_id( $user_id );
+        if ( empty( $user_id ) ) {
+            return 0;
+        }
+
+        if ( ! class_exists( 'WordPressdotorg\Forums\Plugin' ) ) {
+            return 0;
+        }
+
+        $count = (int) $wpdb->get_var( $wpdb->prepare(
+            "SELECT COUNT(*)
+                FROM {$wpdb->posts}
+                WHERE post_type = 'topic'
+                    AND post_status IN ( 'publish', 'closed' )
+                    AND post_parent <> %d
+                    AND post_author = %d",
+            Plugin::REVIEWS_FORUM_ID,
+            $user_id
+        ) );
+
+        return $count;
+    }
+
+    /**
+     * Cle the raw database count of reviews by a user.
+     *
+     * @global wpdb $wpdb WordPress database abstraction object.
+     *
+     * @param int $user_id User ID to get count for.
+     * @return int Raw DB count of reviews.
+     */
+    public function get_user_reviews_count( $user_id = 0 ) {
+        global $wpdb;
+
+        $user_id = bbp_get_user_id( $user_id );
+        if ( empty( $user_id ) ) {
+            return 0;
+        }
+
+        if ( ! class_exists( 'WordPressdotorg\Forums\Plugin' ) ) {
+            return 0;
+        }
+
+        $count = (int) $wpdb->get_var( $wpdb->prepare(
+            "SELECT COUNT(*)
+                FROM {$wpdb->posts}
+                WHERE post_type = 'topic'
+                    AND post_status IN ( 'publish', 'closed' )
+                    AND post_parent = %d
+                    AND post_author = %d",
+            Plugin::REVIEWS_FORUM_ID,
+            $user_id
+        ) );
+
+        return $count;
+    }
+
 }