View Full Version : Want to upgrade to v5, but is there an easy way to edit vb post links?
March 11th, 2005, 05:24 AM
This new version looks great, however in my forums, lots of posts link to the MEDIUM sized thumbnails. I know the fullsize image filename is not changed, so thats OK, but with the medium now moved to a seperate dir, obviously a load of these posts will now have dead links.
Has anyone yet written a script that loops through all the posts (long winded i know!) and modifies the link so it will point to the new image?
March 11th, 2005, 10:17 AM
Nope there is no such thing I know of.
Basically the file structure has changed like this
There is no easy way to do this
I know of a mass body replacement in mysql where you could replace -med with nothing so it would get the picture format right but since the categories are all different you would need to also issue the same mass replacement for each cat to change say
/data/500/ to /data/500/medium/
PLEASE NOTE YOU DO THIS AT YOUR OWN RISK AS THIS IS POWERFUL QUERY
EXAMPLES BELOW make sure to add your table prefix but here is an example of both query types
UPDATE post SET pagetext = REPLACE(pagetext, '-med','')
UPDATE post SET pagetext = REPLACE(pagetext, '/data/500/','/data/500/medium/')
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.