UBB.threads PHP Forum Software Community Forums UBB.threads 7 Version 7 Support SQL search and replace

** MAKE A BACKUP
** BE VERY CAREFUL OF "POST_DEFAULT_BODY" and "POST_BODY" USAGE - DO NOT INTERCHANGE THEM

• POST_DEFAULT_BODY
[BBcode] - this is the original post. CONTENT REBUILDER > REBUILD POSTS takes this and converts it to POST_BODY [HTML]

• POST_BODY
[HTML] - this is shown to the user. it is generated from POST_DEFAULT_BODY

USAGE EXAMPLE FOR HTTP => HTTPS
UPDATE ubbt_POSTS
SET POST_BODY = replace(POST_BODY, 'http://EXAMPLE.com', 'https://EXAMPLE.com')

Run CONTENT REBUILDER > REBUILD POSTS afterwards.

---

FOR REFERENCE:

Posts

• ubbt_TOPICS - TOPIC_SUBJECT
• ubbt_POSTS - POST_SUBJECT
• ubbt_POSTS - POST_DEFAULT_BODY
• ubbt_POSTS - POST_BODY

Private Messages

• ubbt_PRIVATE_MESSAGE_TOPICS - TOPIC_SUBJECT
• ubbt_PRIVATE_MESSAGE_POSTS - POST_DEFAULT_BODY
• ubbt_PRIVATE_MESSAGE_POSTS - POST_BODY

Profiles

• ubbt_USER_PROFILE - USER_AVATAR
• ubbt_PROFILE_COMMENTS - COMMENT_BODY