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

Timestamp:

09/26/2017 07:11:40 PM (9 years ago)

Author:

johnjamesjacoby

Message:

Tools: Remove quotes from prepared query statements.

Also use the same esc_like() result in 2 matched queries.

Props jrf. Fixes #3168.

File:

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

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

@@ -1014 +1014 @@
     $bbp_db        = bbp_db();
     $statement     = esc_html__( 'Repairing closed topics… %s', 'bbpress' );
-    $result        = esc_html__( 'No closed topics to repair.', 'bbpress' );
+    $result        = esc_html__( 'No closed topics to repair.',        'bbpress' );
     $changed       = 0;
 
     // Results
-    $query         = "SELECT ID FROM `{$bbp_db->posts}` WHERE `post_type` = '%s' AND `post_status` = 'closed'";
-    $prepare       = $bbp_db->prepare( $query, bbp_get_topic_post_type() );
+    $query         = "SELECT ID FROM `{$bbp_db->posts}` WHERE `post_type` = %s AND `post_status` = %s";
+    $prepare       = $bbp_db->prepare( $query, bbp_get_topic_post_type(), bbp_get_closed_status_id() );
     $closed_topics = $bbp_db->get_col( $prepare );