<?php
//Adjust to point to root from where this script is located
require '../wp-load.php';
 
//Edit this path
$path = '/var/www/vhosts/domain/httpdocs/wp-content/uploads/shopp';
 
// END EDITS. You shouldn't have to edit below this line.
 
header("Content-Type: text/plain");
ini_set("auto_detect_line_endings", 1); 
$dir_handle = opendir($path);
$row = 1;
$csv_data = array();
while (false !== ($file = readdir($dir_handle))) 
{
	if ($file != "." && $file != "..") 
	{		
		$width_regex = '/((?<=width\\";i:)[0-9]{1,4})|((?<=width=\\")[0-9]{1,4})/';
		$height_regex = '/((?<=height\\";i:)[0-9]{1,4})|((?<=height=\\")[0-9]{1,4})/';
		$query = "select value from wp_shopp_meta where value LIKE '%\"".$file."\"%'";
		$info = getimagesize($path."/".$file);
 
		$existing_properties = $wpdb->get_var($query);
 
		if(strlen($existing_properties) > 10)
		{
			$new_width = $info[0];
			$new_height = $info[1];
 
			preg_match($width_regex, $existing_properties, $old_width);
			preg_match($height_regex, $existing_properties, $old_height);
 
 
			if(($new_width != $old_width[0] || $new_height != $old_height[0]) && !(empty($old_width[0]) || empty($old_height[0])))
			{
				echo "Updating $file. Old width/height: ".$old_width[0]."/".$old_height[0]." New width/height: $new_width/$new_height";
 
				$new_properties = preg_replace($width_regex, $new_width, $existing_properties);
				$new_properties = preg_replace($height_regex, $new_height, $new_properties);
 
				if(strlen($new_properties) > 10)
				{
					$query_update = "update wp_shopp_meta set value = '".mysql_real_escape_string($new_properties)."' where value LIKE '%\"".$file."\"%'";
 
					//echo "Query update: ".$query_update."\n";
 
					$update = $wpdb->query($query_update);
 
					if($update == 0)
					{
						echo " --- FAILED. No rows changed. Didn't update.\n";
					}
					else if($update > 1)
					{
						echo " --- POSSIBLE FAILURE. Updated too many rows.($update)\n";
					}
					else
					{
						echo " --- SUCCESS\n";
					}
				}
				else
				{
					echo "--- FAILED. New properties string suspiciously short.";
				}
			}
		}
	}
}
?>

<?php
// Copyright 2011, Clifton H. Griffin II
// This script is DESTRUCTIVE.  It will delete all images in your database! 
// Run at your own risk. It is provided with NO WARRANTY WHATSOEVER. 
// Please read carefully and do a full backup before using!
// Test with Shopp 1.0.14
 
//EDIT THIS LINE (this directory must be writeable)
$path = "/var/www/vhosts/domain.com/httpdocs/wp-content/uploads/shopp";
 
//Load WP data objects
require 'wp-load.php';
 
//Get list of rows from shopp
$sql    = "SELECT id FROM wp_shopp_asset";
$results = $wpdb->get_results($sql, "ARRAY_A");
 
//Loop through them, grabbing images
foreach ($results as $row)
{
	$id = $row['id'];
	$therow = $wpdb->get_row("SELECT name, data FROM wp_shopp_asset WHERE id = $id", "ARRAY_A");
	$image = $therow["data"];
	$name = $therow["name"];
 
	echo "File name: ".$path."$name <br />";
	$file = fopen($path."$name","w");
	fwrite($file, $image);
	fclose($file);
 
	//Clear image from DB
	$wpdb->query("UPDATE wp_shopp_asset SET data = null WHERE id = $id");
}
//Optimize the table to clear unused space
$wpdb->query("OPTIMIZE TABLE wp_shopp_asset");
?>