Previous Thread
Next Thread
Print Thread
Hop To
Joined: Sep 2004
Posts: 28
F
newbie
newbie
F Offline
Joined: Sep 2004
Posts: 28
is it possible to safely change the internal name of a forum?
we have one forum which is known as

http://www.poisonfree.com/community/messageboard/postlist.php/Cat/0/Board/sex

originally this was meant to be a joke, it's more like an "emo forum" with people discussing their heartaches, it doesn't contain nudity or anything at all.
But now we got users complaining they can't enter this forum, e.g. from work, because of content filters.
is it possible to change the title afterwards? I'm thinking of changing "sex" into something friendly like "heartcore" ... <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />

Joined: Dec 2003
Posts: 11
K
stranger
stranger
K Offline
Joined: Dec 2003
Posts: 11
I'm not sure if this can be safely done, and if so, if there is only one place to change it... I'll let Rick or Josh or someone with more programming knowledge answer that...

However, I've needed to do the same thing a couple times on my personal board and what I've done is simply create a new forum, then move the content from the old forum into the new and delete the old. Voila! <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />


Kristi Horn
Customer Advocate
Infopop Corporation
Joined: Jun 2006
Posts: 742
enthusiast
enthusiast
Joined: Jun 2006
Posts: 742
Kristi's method is safest. But if you're brave.
Backup Your database and use Caution with SQL Queries... untested

UPDATE w3t_Announcements
SET A_Board = 'heartcore'
WHERE A_Board = 'sex'


UPDATE w3t_Boards
SET Bo_Keyword = 'heartcore'
WHERE Bo_Keyword = 'sex'

UPDATE w3t_Last
SET L_Board = 'heartcore'
WHERE L_Board = 'sex'


UPDATE w3t_Moderators
SET Mod_Board = 'heartcore'
WHERE Mod_Board = 'sex'


UPDATE w3t_Online
SET O_Board = 'heartcore'
WHERE O_Board = 'sex'


UPDATE w3t_Posts
SET B_Board = 'heartcore'
WHERE B_Board = 'sex'


UPDATE w3t_Subscribe
SET S_Board = 'heartcore'
WHERE S_Board = 'sex'



I think that'll update everything. <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />

Again, backup your data first to be sure. <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />


Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
Who's Online Now
1 members (Ruben), 1,277 guests, and 207 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 20240506)