Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • There is solution, just add ORDER BY post_date_gmt desc to mysql queries:

    120                 $blog_list = get_blog_list( 0, 'all' );
    121                 if (($white == 0 && !in_array(1, $wgt_miss)) || ($white == 1 && in_array(1, $wgt_white))) {
    122                         $sqlstr = "(SELECT 1 as blog_id, id, post_date_gmt from ".$table_prefix ."posts where post_status = 'publish' and post_type = 'post' and post_title <> '".__('Hello world!')."' ORDER BY post_date_gmt desc ".$limitstr.")";
    123                 }
    124                 $uni = '';
    125
    126                 foreach ($blog_list AS $blog) {
    127                         if (($white == 0 && !in_array($blog['blog_id'], $wgt_miss) && $blog['blog_id'] != 1) ||
    128                         ($white == 1 && $blog['blog_id'] != 1 && in_array($blog['blog_id'], $wgt_white))) {
    129                                 if ($sqlstr != '')
    130                                         $uni = ' union ';;
    131                                 $sqlstr .= $uni . " (SELECT ".$blog['blog_id']." as blog_id, id, post_date_gmt from ".$table_prefix .$blog['blog_id']."_posts  where post_status = 'publish' and post_type = 'post' and post_title <> '".__('Hello world!')."' ORDER BY post_date_gmt desc ".$limitstr.")";
    132                         }
    133                 }
    Thread Starter blazeblz

    (@blazeblz)

    Done. I had to remove my brower’s cache (Firefox). Everything is ok.

Viewing 2 replies - 1 through 2 (of 2 total)