Changeset 4695

Timestamp:

01/22/2013 04:10:01 AM (14 years ago)

Author:

johnjamesjacoby

Message:

Introduce tool for repairing each forum's sticky topic ID's. Props gawain. Fixes #2157.

File:

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

trunk/includes/admin/tools.php

@@ -162 +162 @@
                 10 => array( 'bbp-sync-forum-visibility',  __( 'Recalculate private and hidden forums',               'bbpress' ), 'bbp_admin_repair_forum_visibility'         ),
                 15 => array( 'bbp-sync-all-topics-forums', __( 'Recalculate last activity in each topic and forum',   'bbpress' ), 'bbp_admin_repair_freshness'                ),
-                20 => array( 'bbp-group-forums',           __( 'Repair BuddyPress Group Forum relationships',         'bbpress' ), 'bbp_admin_repair_group_forum_relationship' ),
-                25 => array( 'bbp-forum-topics',           __( 'Count topics in each forum',                          'bbpress' ), 'bbp_admin_repair_forum_topic_count'        ),
-                30 => array( 'bbp-forum-replies',          __( 'Count replies in each forum',                         'bbpress' ), 'bbp_admin_repair_forum_reply_count'        ),
-                35 => array( 'bbp-topic-replies',          __( 'Count replies in each topic',                         'bbpress' ), 'bbp_admin_repair_topic_reply_count'        ),
-                40 => array( 'bbp-topic-voices',           __( 'Count voices in each topic',                          'bbpress' ), 'bbp_admin_repair_topic_voice_count'        ),
-                45 => array( 'bbp-topic-hidden-replies',   __( 'Count spammed & trashed replies in each topic',       'bbpress' ), 'bbp_admin_repair_topic_hidden_reply_count' ),
-                50 => array( 'bbp-user-topics',            __( 'Count topics for each user',                          'bbpress' ), 'bbp_admin_repair_user_topic_count'         ),
-                55 => array( 'bbp-user-replies',           __( 'Count replies for each user',                         'bbpress' ), 'bbp_admin_repair_user_reply_count'         ),
-                60 => array( 'bbp-user-favorites',         __( 'Remove trashed topics from user favorites',           'bbpress' ), 'bbp_admin_repair_user_favorites'           ),
-                65 => array( 'bbp-user-subscriptions',     __( 'Remove trashed topics from user subscriptions',       'bbpress' ), 'bbp_admin_repair_user_subscriptions'       ),
-                70 => array( 'bbp-user-role-map',          __( 'Remap existing users to default forum roles',         'bbpress' ), 'bbp_admin_repair_user_roles'               )
+                20 => array( 'bbp-sync-all-topics-sticky', __( 'Recalculate the sticky replationship of each topic',  'bbpress' ), 'bbp_admin_repair_sticky'                   ),
+                25 => array( 'bbp-group-forums',           __( 'Repair BuddyPress Group Forum relationships',         'bbpress' ), 'bbp_admin_repair_group_forum_relationship' ),
+                30 => array( 'bbp-forum-topics',           __( 'Count topics in each forum',                          'bbpress' ), 'bbp_admin_repair_forum_topic_count'        ),
+                35 => array( 'bbp-forum-replies',          __( 'Count replies in each forum',                         'bbpress' ), 'bbp_admin_repair_forum_reply_count'        ),
+                40 => array( 'bbp-topic-replies',          __( 'Count replies in each topic',                         'bbpress' ), 'bbp_admin_repair_topic_reply_count'        ),
+                45 => array( 'bbp-topic-voices',           __( 'Count voices in each topic',                          'bbpress' ), 'bbp_admin_repair_topic_voice_count'        ),
+                50 => array( 'bbp-topic-hidden-replies',   __( 'Count spammed & trashed replies in each topic',       'bbpress' ), 'bbp_admin_repair_topic_hidden_reply_count' ),
+                55 => array( 'bbp-user-topics',            __( 'Count topics for each user',                          'bbpress' ), 'bbp_admin_repair_user_topic_count'         ),
+                60 => array( 'bbp-user-replies',           __( 'Count replies for each user',                         'bbpress' ), 'bbp_admin_repair_user_reply_count'         ),
+                65 => array( 'bbp-user-favorites',         __( 'Remove trashed topics from user favorites',           'bbpress' ), 'bbp_admin_repair_user_favorites'           ),
+                70 => array( 'bbp-user-subscriptions',     __( 'Remove trashed topics from user subscriptions',       'bbpress' ), 'bbp_admin_repair_user_subscriptions'       ),
+                75 => array( 'bbp-user-role-map',          __( 'Remap existing users to default forum roles',         'bbpress' ), 'bbp_admin_repair_user_roles'               )
         );
         ksort( $repair_list );
@@ -705 +706 @@
                 // If no role map exists, give the default forum role (bbp-participant)
                 $new_role = isset( $role_map[$role] ) ? $role_map[$role] : $default_role;
-                        
+
                 // Get users of this site, limited to 1000
                 while ( $users = get_users( array(
@@ -830 +831 @@
                         bbp_update_forum( array( 'forum_id' => $forum_id ) );
                 }
+        }
+
+        // Complete results
+        return array( 0, sprintf( $statement, __( 'Complete!', 'bbpress' ) ) );
+}
+
+/**
+ * Repairs the relationship of sticky topics to the actual parent forum
+ *
+ * @since bbPress (r4695)
+ *
+ * @uses wpdb::get_col() To run our recount sql queries
+ * @uses is_wp_error() To check if the executed query returned {@link WP_Error}
+ * @return array An array of the status code and the message
+ */
+function bbp_admin_repair_sticky() {
+        global $wpdb;
+
+        $statement = __( 'Repairing the sticky topic to the parent forum relationships… %s', 'bbpress' );
+        $result    = __( 'Failed!', 'bbpress' );
+        $forums    = $wpdb->get_col( "SELECT ID FROM `{$wpdb->posts}` WHERE `post_type` = 'forum';" );
+
+        // Bail if no forums found
+        if ( empty( $forums ) || is_wp_error( $forums ) )
+                return array( 1, sprintf( $statement, $result ) );
+
+        // Loop through forums and get their sticky topics
+        foreach ( $forums as $forum ) {
+                $forum_stickies[$forum] = get_post_meta( $forum, '_bbp_sticky_topics', true );
+        }
+
+        // Cleanup
+        unset( $forums, $forum );
+
+        // Loop through each forum with sticky topics
+        foreach ( $forum_stickies as $forum_id => $stickies ) {
+
+                // Skip if no stickies
+                if ( empty( $stickies ) ) {
+                        continue;
+                }
+
+                // Loop through each sticky topic
+                foreach ( $stickies as $id => $topic_id ) {
+
+                        // If the topic is not a super sticky, and the forum ID does not
+                        // match the topic's forum ID, unset the forum's sticky meta.
+                        if ( ! bbp_is_topic_super_sticky( $topic_id ) && $forum_id != bbp_get_topic_forum_id( $topic_id ) ) {
+                                unset( $forum_stickies[$forum_id][$id] );
+                        }
+                }
+
+                // Get sticky topic ID's, or use empty string
+                $stickers = empty( $forum_stickies[$forum_id] ) ? '' : array_values( $forum_stickies[$forum_id] );
+
+                // Update the forum's sticky topics meta
+                update_post_meta( $forum_id, '_bbp_sticky_topics', $stickers );
         }