Guys,

I am getting lots of errors looking into this the icon images have changed...

icons/wink.gif icons/default/wink.gif
icons/tongue.gif iconsdefault/tongue.gif
icons/grin.gif icons/default/grin.gif
icons/confused.gif icons/default/confused.gif
icons/shocked.gif icons/default/shocked.gif
icons/smile.gif icons/default/smile.gif
icons/mad.gif icons/default/mad.gif
icons/frown.gif icons/default/frown.gif

Okay this is all in posts. Can this be SQL updated to simply find the text on the left in a post and change it to whats in the right? If so how please....

Thanks!

I worked it out

UPDATE ubbt_POSTS SET POST_BODY=REPLACE(POST_BODY,"icons/wink.gif","icons/default/wink.gif")
UPDATE ubbt_POSTS SET POST_BODY=REPLACE(POST_BODY,"icons/tongue.gif","icons/default/tongue.gif")
UPDATE ubbt_POSTS SET POST_BODY=REPLACE(POST_BODY,"icons/grin.gif","icons/default/grin.gif")
UPDATE ubbt_POSTS SET POST_BODY=REPLACE(POST_BODY,"icons/confused.gif","icons/default/confused.gif")
UPDATE ubbt_POSTS SET POST_BODY=REPLACE(POST_BODY,"icons/shocked.gif","icons/default/shocked.gif")
UPDATE ubbt_POSTS SET POST_BODY=REPLACE(POST_BODY,"icons/smile.gif","icons/default/smile.gif")
UPDATE ubbt_POSTS SET POST_BODY=REPLACE(POST_BODY,"icons/mad.gif","icons/default/mad.gif")
UPDATE ubbt_POSTS SET POST_BODY=REPLACE(POST_BODY,"icons/frown.gif","icons/default/frown.gif")
UPDATE ubbt_POSTS SET POST_BODY=REPLACE(POST_BODY,"images/blank.gif","images/general/default/blank.gif")

Was this an import from UBB.threads or ubb.classic?