<?php
    require_once(dirname(__FILE__).'/wp-load.php');

    set_time_limit(300);
    $wpdb->show_errors();

    // диапазон раскидывания постов:
    //  от (текущая_дата - $days_minus дней)
    //  до (текущая дата + $days_plus дней)

    $days_minus = 185;
    $days_plus = 0;

    // дальше магия

    $sql = 'SELECT `ID` FROM `'.$wpdb->prefix.'posts`
            WHERE
                `post_type`="post"
            AND
                (`post_status`="future" OR `post_status`="publish")
    ';

    if ( $posts = $wpdb->get_results($sql) )
    {
        // Меняем дату у постов
        foreach ($posts as $post)
        {
            $sql = 'UPDATE `'.$wpdb->prefix.'posts` SET
                       `post_date`= DATE_ADD(
                                        FROM_DAYS( FLOOR( TO_DAYS(NOW())
                                                          + (RAND()*'.$days_plus.')
                                                          - (RAND()*'.$days_minus.')
                                                   )
                                        ),
                                        INTERVAL (FLOOR(RAND()*86400)) SECOND
                       ),
                       `post_date_gmt`=`post_date`,
                       `post_modified`=`post_date`,
                       `post_modified_gmt`=`post_date`
                   WHERE
                       `id`=%d
                   LIMIT 1
            ';

            $psql = $wpdb->prepare($sql, $post->ID);

            $wpdb->query($psql);
        }

        // Обновляем статусы постов

        $sql = 'UPDATE `'.$wpdb->prefix.'posts` SET
                  `post_status`="future"
                WHERE
                  `post_date`>NOW()
                AND
                  `post_type`="post"
                AND
                  (`post_status`="future" OR `post_status`="publish")
        ';

        $wpdb->query($sql);

        $sql = 'UPDATE `'.$wpdb->prefix.'posts` SET
                        `post_status`="publish"
                      WHERE
                        `post_date`<=NOW()
                      AND
                        `post_type`="post"
                      AND
                        (`post_status`="future" OR `post_status`="publish")
        ';

        $wpdb->query($sql);
    }

    die('Записи отсортированы. Вернитесь на главную страницу.<br><br><a href="/">Вернуться на главную</a>');