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

Timestamp:

02/26/2017 07:12:34 PM (8 years ago)

Author:

johnjamesjacoby

Message:

Engagements: First pass at:

• User profile section
• Template parts changes
• Rewrite rules support
• Repair & upgrade tools
• BuddyPress support
• engagement slug setting

See #3068.

File:

• trunk/src/includes/admin/tools/repair.php (modified) (3 diffs)

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

@@ -233 +233 @@
     $result    = __( 'Failed!', 'bbpress' );
 
-    $sql_delete = "DELETE FROM `{$bbp_db->postmeta}` WHERE `meta_key` = '_bbp_voice_count'";
+    $sql_delete = "DELETE FROM {$bbp_db->postmeta} WHERE meta_key IN ('_bbp_voice_count', '_bbp_engagement')";
     if ( is_wp_error( $bbp_db->query( $sql_delete ) ) ) {
         return array( 1, sprintf( $statement, $result ) );
@@ -244 +244 @@
     $cps = bbp_get_closed_status_id();
 
-    $sql = "INSERT INTO `{$bbp_db->postmeta}` (`post_id`, `meta_key`, `meta_value`) (
-            SELECT `postmeta`.`meta_value`, '_bbp_voice_count', COUNT(DISTINCT `post_author`) as `meta_value`
-                FROM `{$bbp_db->posts}` AS `posts`
-                LEFT JOIN `{$bbp_db->postmeta}` AS `postmeta`
-                    ON `posts`.`ID` = `postmeta`.`post_id`
-                    AND `postmeta`.`meta_key` = '_bbp_topic_id'
-                WHERE `posts`.`post_type` IN ( '{$tpt}', '{$rpt}' )
-                    AND `posts`.`post_status` IN ( '{$pps}', '{$cps}' )
-                    AND `posts`.`post_author` != '0'
-                GROUP BY `postmeta`.`meta_value`)";
-
-    if ( is_wp_error( $bbp_db->query( $sql ) ) ) {
+    $voice_id_sql = $bbp_db->prepare( "INSERT INTO {$bbp_db->postmeta} (post_id, meta_key, meta_value) (
+        SELECT postmeta.meta_value, '_bbp_engagement', posts.post_author
+            FROM {$bbp_db->posts} AS posts
+            LEFT JOIN {$bbp_db->postmeta} AS postmeta
+                ON posts.ID = postmeta.post_id
+                AND postmeta.meta_key = '_bbp_topic_id'
+            WHERE posts.post_type IN (%s, %s)
+                AND posts.post_status IN (%s, %s))", $tpt, $rpt, $pps, $cps );
+
+    if ( is_wp_error( $bbp_db->query( $voice_id_sql ) ) ) {
         return array( 2, sprintf( $statement, $result ) );
+    }
+
+    $voice_count_sql = "INSERT INTO {$bbp_db->postmeta} (post_id, meta_key, meta_value) (
+        SELECT post_id, '_bbp_voice_count', COUNT(DISTINCT meta_value)
+            FROM {$bbp_db->postmeta}
+            WHERE meta_key = '_bbp_engagement'
+            GROUP BY post_id ORDER BY post_id)";
+
+    if ( is_wp_error( $bbp_db->query( $voice_count_sql ) ) ) {
+        return array( 3, sprintf( $statement, $result ) );
     }
 
@@ -695 +703 @@
 
     // Query for users with favorites
+    $key       = $bbp_db->prefix . '_bbp_favorites';
     $users     = $bbp_db->get_results( "SELECT `user_id`, `meta_value` AS `favorites` FROM `{$bbp_db->usermeta}` WHERE `meta_key` = '{$key}'" );