admin管理员组

文章数量:1426648

I'm importin pictures via FTP and create custom recorss in mySQL via insert. I'm trying to make a cron job to regenerate thumbnails.

This is what i came up to.. but i doesnt work.

add_action( 'my_hook_regenerateimages', 'regenerateThumbnails' );

function regenerateThumbnails() {

//$images = $wpdb->get_results( "SELECT ID FROM $wpdb->posts WHERE post_type = 'attachment' AND post_mime_type LIKE 'image/%' AND DATE(´post_date´) > DATE_SUB(CURDATE(), INTERVAL 2 DAY)" );
//$images = $wpdb->get_results( "SELECT ID FROM $wpdb->posts WHERE post_type = 'attachment' AND post_mime_type LIKE 'image/%'");
$images = $wpdb->get_results( "SELECT ID FROM $wpdb->posts WHERE post_type = 'attachment' AND post_mime_type LIKE 'image/%' AND post_date > DATE_SUB(CURDATE(), INTERVAL 2 DAY)" );

foreach ( $images as $image ) {
    /*$id = $image->ID;
    $fullsizepath = get_attached_file( $id );

    if ( false === $fullsizepath || !file_exists($fullsizepath) )
        return;

    if ( wp_update_attachment_metadata( $id, wp_generate_attachment_metadata( $id, $fullsizepath ) ) )
        return true;
    else
        return false;
    */
    $fullsizepath = get_attached_file( $image->ID );
    wp_update_attachment_metadata( $image->ID, wp_generate_attachment_metadata( $image->ID, $fullsizepath ) );      
}
}

本文标签: Thumbnails regenerate wpgenerateattachmentmetadata