Changeset 5617

Timestamp:

07/03/2017 10:43:31 PM (7 years ago)

Author:

SergeyBiryukov

Message:

Support Theme: Add "Reviews Written" count to user's profile page.

Fixes #2772.

Location:

sites/trunk/wordpress.org/public_html/wp-content/themes/pub/wporg-support

Files:

• bbpress/user-details.php (modified) (1 diff)
• bbpress/user-profile.php (modified) (2 diffs)
• bbpress/user-reviews-written.php (moved) (moved from sites/trunk/wordpress.org/public_html/wp-content/themes/pub/wporg-support/bbpress/user-reviews-created.php) (4 diffs)
• functions.php (modified) (1 diff)

sites/trunk/wordpress.org/public_html/wp-content/themes/pub/wporg-support/bbpress/user-details.php

@@ -55 +55 @@
                         <a href="<?php bbp_user_profile_url(); ?>reviews/" title="<?php
                             /* translators: %s: user's display name */
-                            printf( esc_attr__( "%s's Reviews", 'wporg-forums' ), bbp_get_displayed_user_field( 'display_name' ) );
-                        ?>"><?php esc_html_e( 'Reviews', 'wporg-forums' ); ?></a>
+                            printf( esc_attr__( "%s's Reviews Written", 'wporg-forums' ), bbp_get_displayed_user_field( 'display_name' ) );
+                        ?>"><?php esc_html_e( 'Reviews Written', 'wporg-forums' ); ?></a>
                     </span>
                 </li>

sites/trunk/wordpress.org/public_html/wp-content/themes/pub/wporg-support/bbpress/user-profile.php

@@ -116 +116 @@
 
         <p class="bbp-user-topic-count"><?php
+            $review_count = wporg_support_get_user_review_count();
+
             /* translators: %s: number of user's topics */
-            printf( esc_html__( 'Topics Started: %s', 'wporg-forums' ), number_format_i18n( bbp_get_user_topic_count_raw() ) );
+            printf( esc_html__( 'Topics Started: %s', 'wporg-forums' ), number_format_i18n( bbp_get_user_topic_count_raw() - $review_count ) );
         ?></p>
 
@@ -124 +126 @@
             printf( esc_html__( 'Replies Created: %s', 'wporg-forums' ), number_format_i18n( bbp_get_user_reply_count_raw() ) );
         ?></p>
+
+        <p class="bbp-user-review-count"><?php
+            /* translators: %s: number of user's reviews */
+            printf( esc_html__( 'Reviews Written: %s', 'wporg-forums' ), number_format_i18n( $review_count ) );
+        ?></p>
     </div>
 </div><!-- #bbp-author-topics-started -->

sites/trunk/wordpress.org/public_html/wp-content/themes/pub/wporg-support/bbpress/user-reviews-written.php

@@ -2 +2 @@
 
 /**
- * User Reviews Created
+ * User Reviews Written
  *
  * @package bbPress
@@ -8 +8 @@
  */
 
-do_action( 'bbp_template_before_user_topics_created' ); ?>
+do_action( 'bbp_template_before_user_reviews_written' ); ?>
 
 <div id="bbp-user-topics-started" class="bbp-user-topics-started">
-    <h2 class="entry-title"><?php esc_html_e( 'Reviews', 'wporg-forums' ); ?></h2>
+    <h2 class="entry-title"><?php esc_html_e( 'Reviews Written', 'wporg-forums' ); ?></h2>
     <div class="bbp-user-section">
 
@@ -25 +25 @@
 
             <p><?php bbp_is_user_home()
-                ? esc_html_e( 'You have not created any reviews.',      'wporg-forums' )
-                : esc_html_e( 'This user has not created any reviews.', 'wporg-forums' );
+                ? esc_html_e( 'You have not written any reviews.',      'wporg-forums' )
+                : esc_html_e( 'This user has not written any reviews.', 'wporg-forums' );
             ?></p>
 
@@ -34 +34 @@
 </div><!-- #bbp-user-topics-started -->
 
-<?php do_action( 'bbp_template_after_user_topics_created' );
+<?php do_action( 'bbp_template_after_user_reviews_written' );

sites/trunk/wordpress.org/public_html/wp-content/themes/pub/wporg-support/functions.php

@@ -212 +212 @@
     /* translators: registration date format, see https://secure.php.net/date */
     return mysql2date( __( 'F jS, Y', 'wporg-forums' ), $user->user_registered );
+}
+
+/**
+ * Return 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.
+ */
+function wporg_support_get_user_review_count( $user_id = 0 ) {
+    global $wpdb;
+
+    $user_id = bbp_get_user_id( $user_id );
+    if ( empty( $user_id ) ) {
+        return false;
+    }
+
+    if ( ! class_exists( 'WordPressdotorg\Forums\Plugin' ) ) {
+        return false;
+    }
+
+    $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 = %s
+                AND post_author = %d",
+        WordPressdotorg\Forums\Plugin::REVIEWS_FORUM_ID,
+        $user_id
+    ) );
+
+    return $count;
 }