Changeset 6612 for trunk/src/includes/users/functions.php

Timestamp:

07/04/2017 03:54:06 PM (9 years ago)

Author:

johnjamesjacoby

Message:

Queries: Use new object_type over old post_type.

When bbp_get_user_object_ids() was introduced, some helpers did not get updated to use the new argument key. This change fixes that, and fixes failing tests in the process.

Note that these tests are testing new & unused helper functions for 2.6, so it's unlikely any noticable problems occurred from these being broken.

File:

• trunk/src/includes/users/functions.php (modified) (1 diff)

trunk/src/includes/users/functions.php

@@ -648 +648 @@
     $user_id = bbp_get_user_id( $user_id );
     $bbp_db  = bbp_db();
+    $statii  = "'" . implode( "', '", bbp_get_public_topic_statuses() ) . "'";
     $sql     = "SELECT COUNT(*)
             FROM {$bbp_db->posts}
             WHERE post_author = %d
                 AND post_type = %s
-                AND post_status = %s";
-
-    $query   = $bbp_db->prepare( $sql, $user_id, bbp_get_reply_post_type(), bbp_get_public_status_id() );
+                AND post_status IN ({$statii})";
+
+    $query   = $bbp_db->prepare( $sql, $user_id, bbp_get_reply_post_type() );
     $count   = (int) $bbp_db->get_var( $query );