WP Nightly Image OptimizatioN

cron.sh

# This cronjob is set to run at 130am every single night
30 1 * * * /usr/bin/php -q /var/www/yourwebsitesroot/wp-content/themes/YOURTHEME/skxvnvhthz2k4w.php

# This is a commented out cronjob to run every single minute - do not use this except to test that your server is executing the cron
# */1 * * * *  /usr/bin/php -q  /var/www/yourwebsitesroot/wp-content/themes/YOURTHEME/skxvnvhthz2k4w.php

Optimization Script.php

<?php

global $wpdb;

require('/var/www/yourwebsitesroot/wp-blog-header.php');
// require ( ABSPATH . 'wp-admin/includes/image.php' );

$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)"
		);

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

      wp_update_attachment_metadata( $image->ID, wp_generate_attachment_metadata( $image->ID, $fullsizepath ) );

    }

?>

prep-work.sh

# switch to the root account if you need to 
sudo -s
# Then create the script using either of the following
vim skxvnvhthz2k4w.php 
# OR
nano skxvnvhthz2k4w.php
# OR
touch skxvnvhthz2k4w.php
# Now change the files permissions so that only the root user may read, write and execute it.
chmod u+rwx  skxvnvhthz2k4w.php

test.sh

php  /var/www/yourwebsitesroot/wp-content/themes/YOURTHEME/skxvnvhthz2k4w.php