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 ) );
}
}