UBB.Developers Forums Community Development Programming MySQL and Server Configuration How to rename board's keyword

On ubbt 6.4.x board is defined in w3t_Boards.

Boards keyword is used in next tables:
[*]w3t_Boards as Bo_Keyword
[*]w3t_Last as L_Board
[*]w3t_Online as O_Board
[*]w3t_Posts as B_Board
[*]w3t_Subscribe as S_Board
I thinkg this is it

What would be mySQL query to rename keyword for a specific board?

My knowledge of mySQL queries is limited to select, update, insert and delete []http://pages.prodigy.net/rogerlori1/emoticons/bigblush.gif[/]

UPDATE w3t_Boards
SET Bo_Keyword = 'newkeyword'
WHERE Bo_Keyword = 'oldkeyword'

You'd have to do a similar query for every table the board keyword is used in.

Backup your database first, as one slip of your fingers you can screw up alot of stuff.

[]JoshPet said:
You'd have to do a similar query for every table the board keyword is used in.
[/]
This is what I would like NOT to do

In fact - screw the whole thing: I'm gonna build my own lunar lander, with BlackJack and with my php script

There is no way to update it with one query - as there are many differnt tables involved. You can only update one table at a time. You'd have to write a script to do it. Doing all the queries would be faster.

[]JoshPet said:
There is no way to update it with one query - as there are many differnt tables involved. You can only update one table at a time.[/]
OK - I did not know that, sorry []http://pages.prodigy.net/rogerlori1/emoticons/bigblush.gif[/]

[]JoshPet said:
You'd have to write a script to do it. Doing all the queries would be faster. [/]
I have 43 boards I'll write me a script when I have the time

In 6.5b1 you can do it in the admin panel with a few clicks :-p