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.
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
Thanks, I did look around, but was lost in the process. :)
Assuming the boards don't have posts in them, just run this query in phpMyAdmin, changing the numbers as needed...
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).
All forums are gone except 3.
Will that still work.
Edit: I am so confused.
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.