Skip to:
Content

bbPress.org

Changeset 6215


Ignore:
Timestamp:
01/12/2017 06:29:48 AM (4 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:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/src/includes/admin/tools.php

    r6196 r6215  
    23022302    $changed       = $total = 0;
    23032303    $key           = $bbp_db->prefix . '_bbp_subscriptions';
    2304     $subscriptions = $bbp_db->get_results( $bbp_db->prepare( "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s", $key ) );
     2304    $subscriptions = $bbp_db->get_results( $bbp_db->prepare( "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s ORDER BY user_id", $key ) );
    23052305
    23062306    // Bail if no topic subscriptions found
     
    23652365    $changed       = $total = 0;
    23662366    $key           = $bbp_db->prefix . '_bbp_forum_subscriptions';
    2367     $subscriptions = $bbp_db->get_results( $bbp_db->prepare( "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s", $key ) );
     2367    $subscriptions = $bbp_db->get_results( $bbp_db->prepare( "SELECT * FROM {$bbp_db->usermeta} WHERE meta_key = %s ORDER BY user_id", $key ) );
    23682368
    23692369    // Bail if no forum subscriptions found
Note: See TracChangeset for help on using the changeset viewer.