X-Cart forums

[mikamedia]

Hi,

I had to move one of our X-cart site to a new server. We use the filesystem to store images, not the database. I noticed that X-cart saves the whole path info for every image stored in the database.
I wrote a very small but useful script for anyone that wants to change the path info for all images at one time:

<? 
mysql_connect('localhost', '%%username%%', '%%password%%');
$db = "%%dbasename%%";

Echo "Image paths will be changed for all images in X-cart...";

$selectPaths = mysql($db, "select * from xcart_thumbnails order by productid");
while ($rowPaths = mysql_fetch_row($selectPaths))
{
	$PathData = $rowPaths[2];
	echo "Old path: $rowPaths[2]
";
	$PathData = str_replace ("%%old_path_in_database%%", "%%new_path_in_database%%", $PathData);
	echo "New path: $PathData

";

	// write update to database
	mysql($db, "update xcart_thumbnails set image_path = '$PathData' WHERE productid = '$rowPaths[0]'");	

}
echo "

Done!";
?>

Replace all the %% %% with your own values.

It's not very handy to store the full path into the database, but it hope it helps for some people!

Good luck.
John.

[funkydunk]

Very useful.

[cyberdriveway]

I am only a couple of weeks into using x-cart. Tried to move the store to another location, and lost all of the image links. When I used the above code the "\"s were dropped from the path string during the update.

I was however able to make this sql statement work:

$sql= "UPDATE xcart_thumbnails SET image_path=( REPLACE (image_path,'dirA','dirB'))WHERE productid = '$rowPaths[0]';";
mysql_query($sql, yourconn);

dirA = original directory:
c:\inetpub\wwwroot\xcart\files\images.....

dirB = new directory:
c:\inetpub\wwwroot\backup\files\images....

Only include what needs to be changed:
(image_path, 'xcart', 'backup')


Hope this helps....