Changeset 5916 for trunk/src/includes/admin/tools.php
- Timestamp:
- 08/15/2015 08:59:51 AM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/src/includes/admin/tools.php
r5908 r5916 1063 1063 * @uses bbp_get_trash_status_id() To get the trash status id 1064 1064 * @uses bbp_get_spam_status_id() To get the spam status id 1065 * @uses bbp_get_pending_status_id() To get the pending status id 1065 1066 * @return array An array of the status code and the message 1066 1067 */ … … 1069 1070 // Define variables 1070 1071 $bbp_db = bbp_db(); 1071 $statement = __( 'Counting the number of spammedand trashed replies in each topic… %s', 'bbpress' );1072 $statement = __( 'Counting the number of pending, spammed, and trashed replies in each topic… %s', 'bbpress' ); 1072 1073 $result = __( 'Failed!', 'bbpress' ); 1073 1074 … … 1081 1082 $tps = bbp_get_trash_status_id(); 1082 1083 $sps = bbp_get_spam_status_id(); 1083 1084 $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}' ) GROUP BY `post_parent`);"; 1084 $pps = bbp_get_pending_status_id(); 1085 1086 $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`);"; 1085 1087 if ( is_wp_error( $bbp_db->query( $sql ) ) ) { 1086 1088 return array( 2, sprintf( $statement, $result ) );
Note: See TracChangeset
for help on using the changeset viewer.