Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jul 2006
Posts: 96
A
member
member
A Offline
Joined: Jul 2006
Posts: 96
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!

Joined: Jul 2006
Posts: 96
A
member
member
A Offline
Joined: Jul 2006
Posts: 96
I worked it out smile

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")

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Was this an import from ubb.threads or ubb.classic?


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Post Moderation Issue
by FREAK - 11/24/2022 1:07 PM
Who's Online Now
0 members (), 184 guests, and 64 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221129)