Changeset 6320 for trunk/src/includes/admin/tools/upgrades.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/upgrades.php (modified) (1 diff)

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

@@ -156 +156 @@
 
 /**
+ * Upgrade user engagements for bbPress 2.6 and higher
+ *
+ * @since 2.6.0 bbPress (r63010)
+ *
+ * @return array An array of the status code and the message
+ */
+function bbp_admin_upgrade_user_engagements() {
+
+    // Define variables
+    $bbp_db    = bbp_db();
+    $statement = __( 'Upgrading user engagements … %s', 'bbpress' );
+    $result    = __( 'No engagements to upgrade.',             'bbpress' );
+    $total     = 0;
+
+    // Delete previous engagements
+    $sql_delete = "DELETE FROM {$bbp_db->postmeta} WHERE meta_key = '_bbp_engagement'";
+    if ( is_wp_error( $bbp_db->query( $sql_delete ) ) ) {
+        return array( 1, sprintf( $statement, $result ) );
+    }
+
+    // Post types and status
+    $tpt = bbp_get_topic_post_type();
+    $rpt = bbp_get_reply_post_type();
+    $pps = bbp_get_public_status_id();
+    $cps = bbp_get_closed_status_id();
+    $sql = $bbp_db->prepare( "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 );
+
+    $engagements = $bbp_db->get_results( $sql );
+
+    // Bail if no closed topics found
+    if ( empty( $engagements ) || is_wp_error( $engagements ) ) {
+        return array( 1, sprintf( $statement, $result ) );
+    }
+
+    // Loop through each user's favorites
+    foreach ( $engagements as $meta ) {
+
+        // Skip if already exists
+        if ( $bbp_db->get_var( $bbp_db->prepare( "SELECT * FROM {$bbp_db->postmeta} WHERE post_id = %d AND meta_key = %s AND meta_value = %d LIMIT 1", $meta->meta_value, '_bbp_engagement', $meta->post_author ) ) ) {
+            continue;
+        }
+
+        // Add the post meta
+        $added = add_post_meta( $meta->meta_value, '_bbp_engagement', $meta->post_author, false );
+
+        // Bump counts if successfully added
+        if ( ! empty( $added ) ) {
+            ++$total;
+        }
+    }
+
+    // Cleanup
+    unset( $engagements, $added );
+
+    // Complete results
+    $result = sprintf( _n( 'Complete! %d engagements upgraded.', 'Complete! %d engagements upgraded.', $total, 'bbpress' ), $total );
+
+    return array( 0, sprintf( $statement, $result ) );
+}
+
+/**
  * Upgrade user favorites for bbPress 2.6 and higher
  *