Category and Boards

[wgm]

Right forum I hope.

OK, I have removed many forums and want to know if there is a way to change the order when a new category and boards are added.

I have 2 categories with 3 forums only.

Category 1, 2, but now when added another it goes 4.
Board=1.0, 2.0, 3.0, when adding another board it jumps to 21, can it start at 4.0.

Possible or impossible ?

Thanks, please keep it plain and simple, MySQL is somewhat over my head.

[Grudge]

The reason the ID numbers jump is due to the auto_increment on SQL. Assuming there are no posts on these boards you can load up phpMyAdmin and manually change the IDs in the boards/categories table

[wgm]

Thanks, I did look around, but was lost in the process. 

[Oldiesmann]

Assuming the boards don't have posts in them, just run this query in phpMyAdmin, changing the numbers as needed...

Code Select Expand

UPDATE smf_boards SET ID_BOARD = '4' WHERE ID_BOARD = '6';

Now, if they do have posts in them, you will just have to live with those numbers because there's a lot more to update (boards, messages, notifications and topics, plus a couple of log tables).

[wgm]

All forums are gone except 3.

Will that still work.

Edit: I am so confused.

[wgm]

Both categories and boards are done the way I hoped, please don't ask how as I have know idea, well may be except what I added from Oldiesmann post must of worked.