Changeset 6644 for trunk/src/includes/admin/tools/repair.php

Timestamp:

08/07/2017 08:27:00 PM (9 years ago)

Author:

johnjamesjacoby

Message:

Topics: Introduce bbp_get_non_public_topic_statuses()

This new function returns the inverse post-statuses of bbp_get_public_topic_statuses() with a filter to help target them more specifically in places where it was not previously possible to do so.

See #3128.

File:

• trunk/src/includes/admin/tools/repair.php (modified) (1 diff)

trunk/src/includes/admin/tools/repair.php

@@ -281 +281 @@
         // Post types and status
         $rpt = bbp_get_reply_post_type();
-        $tps = bbp_get_trash_status_id();
-        $sps = bbp_get_spam_status_id();
-        $pps = bbp_get_pending_status_id();
-
-        $sql = "INSERT INTO `{$bbp_db->postmeta}` (`post_id`, `meta_key`, `meta_value`) (SELECT `post_parent`, '_bbp_reply_count_hidden', COUNT(`post_status`) as `meta_value` FROM `{$bbp_db->posts}` WHERE `post_type` = '{$rpt}' AND `post_status` IN ( '{$tps}', '{$sps}', '{$pps}' ) GROUP BY `post_parent`)";
+        $sta = bbp_get_non_public_topic_statuses();
+
+        // SQL
+        $sql_status = "'" . implode( "','", $sta ) . "'";
+
+        $sql = "INSERT INTO `{$bbp_db->postmeta}` (`post_id`, `meta_key`, `meta_value`) (SELECT `post_parent`, '_bbp_reply_count_hidden', COUNT(`post_status`) as `meta_value` FROM `{$bbp_db->posts}` WHERE `post_type` = '{$rpt}' AND `post_status` IN ({$sql_status}) GROUP BY `post_parent`)";
         if ( is_wp_error( $bbp_db->query( $sql ) ) ) {
                 return array( 2, sprintf( $statement, $result ) );