Block External Images using [img] tags

[SoloX]

Hello:

I have my own upload hack and dont want the users to use the [img] tag to display external images. If I just disable [img], the smilies wont show up .. How do I go about fixing this? help....

SoloX

[Erwin]

If you disable the [img] tags, the smilies should still show up. They are separate. I do the same, and I don't have that problem.

[SoloX]

ohh thanks Doc .. I looked more and you are right! It works .. but only for the threads that were created AFTER i migrated to VBB from UBB .. the original [UBB] threads now have links to those images in this format: http://www.domain.com/images/smilie.gif ...

Is there any way to replace certain text in mySQL tables? Like I would like to replace "htt://www.domain.com/images/smilie.gif" with ": )" ....

How do I search and replace in SQL tables...

Thanks ...

[Xenon]

search for the_sisko's profile, he has released a replace hack :)

[SoloX]

Thanks Xenon and doc .. i found the_sisko's solution and it works like a charm! :-) ..