Changeset 6215

Timestamp:

01/12/2017 06:29:48 AM (9 years ago)

Author:

johnjamesjacoby

Message:

Tools: Order fav/sub upgrade by user_id.

This makes it easier to LIMIT later if you need to manually chunk this. See #2959.

File:

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

trunk/src/includes/admin/tools.php

@@ -2302 +2302 @@
     $changed       = $total = 0;
     $key           = $bbp_db->prefix . '_bbp_subscriptions';
-    $subscriptions = $bbp_db->get_results( $bbp_db->prepare( "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s", $key ) );
+    $subscriptions = $bbp_db->get_results( $bbp_db->prepare( "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s ORDER BY user_id", $key ) );
 
     // Bail if no topic subscriptions found
@@ -2365 +2365 @@
     $changed       = $total = 0;
     $key           = $bbp_db->prefix . '_bbp_forum_subscriptions';
-    $subscriptions = $bbp_db->get_results( $bbp_db->prepare( "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s", $key ) );
+    $subscriptions = $bbp_db->get_results( $bbp_db->prepare( "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s ORDER BY user_id", $key ) );
 
     // Bail if no forum subscriptions found