a fix for a ubb conversion utility problem?

Has anyone created some type of hack that will search the post table for all signs of "smile.gif" "biggrin.gif" etc and replace it with the necessary keyboard stroke? I converted from ubb and my images arent in the same directory and I just need an easy way to replace all the [ img ]http://www.extremeforums.com/smile.gif[ /img ] tags with ": )"

Anyone done such a thing?

~Chris

[Edited by TechTalk on 08-11-2000 at 10:21 PM]

If you had a script that changed it automatically, wouldn't it cause just as much stress on the server since it needs to run that program everytime an old smilie comes up?

Originally posted by Me2Be
If you had a script that changed it automatically, wouldn't it cause just as much stress on the server since it needs to run that program everytime an old smilie comes up?

I didn't take a look at the script, but I was under the impression that this was a data cleanup type program that would run once for the entire database, and fix all the links. Once it ran, all would be well.

-Chris

Ah, I guess it would help if I read the entire thread LOL - but no, I like my little solution