我正在尝试检索WordPress多站点实例中在给定日期/时间之前注册的站点列表。

使用get_sites() 和WP_Date_Query 我有以下内容，但没有网站被退回。。。

$now       = current_time( \'timestamp\' );
$lifetime  = epd_get_default_site_lifetime(); // returning 3600. Aim to retrieve all sites registered over an hour ago

if ( ! $lifetime )  {
    return;
}

$delete_on = $now - $lifetime;

$delete_sites_query = array(
    \'site__not_in\' => array( get_network()->blog_id ),
    \'date_query\' => array(
        array(
            \'year\'          => date( \'Y\', $delete_on ),
            \'month\'         => date( \'n\', $delete_on ),
            \'day\'           => date( \'j\', $delete_on ),
            \'hour\'          => date( \'G\', $delete_on ),
            \'minute\'        => intval( date( \'i\', $delete_on ) ),
            \'second\'        => intval( date( \'s\', $delete_on ) ),
            \'compare\'       => \'<=\',
            \'column\'        => \'registered\'
        )
    )
);

$delete_sites_query = apply_filters( \'epd_delete_sites_query\', $delete_sites_query );

$sites = get_sites( $delete_sites_query );

如果我var_export( $delete_sites_query ); 我看到了以下内容（对我来说似乎是正确的）。。。

array (
  \'site__not_in\' => 
  array (
    0 => \'1\',
  ),
  \'date_query\' => 
  array (
    0 => 
    array (
      \'year\' => \'2018\',
      \'month\' => \'8\',
      \'day\' => \'14\',
      \'hour\' => \'22\',
      \'minute\' => 46,
      \'second\' => 19,
      \'compare\' => \'<=\',
      \'column\' => \'registered\',
    ),
  ),
)

我已经在上述日期之前注册了网站。。。

$delete_on_timestamp = time() - 3600*24*30;

$args = array (
    \'site__not_in\' => array ( 1 ),
    \'fields\' => \'ids\',
    \'number\' => 999999,
);

$site_ids = get_sites( $args );

foreach( $site_ids as $site_id ) {
    $object_site_details = get_blog_details( $site_id );
    $site_register_timestamp = strtotime( $object_site_details->registered );
    if ( $site_register_timestamp <= $delete_on_timestamp ) {
        wpmu_delete_blog( $site_id, true );
    }
}