Moving boards in bulk

[Anguz]

I know this is not available in the Manage Boards area, although it'd be nice. I was wondering what the SQL query would be to move a bunch of boards together. They're childs of board 1 and I want them child of board 2.

[[Unknown]]

UPDATE smf_boards
SET ID_PARENT = ###
WHERE ID_BOARD IN (xyz);

-[Unknown]

[Midgard]

xyz? board id?

[Oldiesmann]

xyz is a list of the board IDs for the boards whose parent you want to change. It allows you to update this value for multiple boards with one query, instead of having to use "WHERE ID_BOARD = 'x' || ID_BOARD = 'y' || ID_BOARD = 'z'" or run a seperate query for each board.

[Midgard]

"WHERE ID_BOARD = '1'"

It's true? xyz is board id?

[Tony Reid]

Hmmm.. sorry to jump in here... but I want to move a board and its boards into a fresh forum.......

If I did something like a select on the above, would it be as straight forward as an update/insert into the other forum?

I realise I have to share the user DB....

[Oldiesmann]

"WHERE ID_BOARD = '1'"

It's true? xyz is board id?

xyz is a list of the board IDs...

For instance - if you wanted to move boards 5,6 and 7 to board 1, you'd do it like this:

Koodi [Valitse] Laajenna

UPDATE smf_boards
SET ID_PARENT = '1'
WHERE ID_BOARD IN (5,6,7);

Hmmm.. sorry to jump in here... but I want to move a board and its boards into a fresh forum.......

If I did something like a select on the above, would it be as straight forward as an update/insert into the other forum?

I realise I have to share the user DB....

Koodi [Valitse] Laajenna

INSERT INTO db2.smf_boards
SELECT * FROM db1.smf_boards;

[Tony Reid]

Thank you Oldiesmann!

I take it that '*' is the id of the board ... and I can do the same with the sub boards

[Oldiesmann]

* means select everything. I wasn't thinking about moving just some boards. Do it like this (same principle as above for the "WHERE" clause).

Koodi [Valitse] Laajenna

INSERT INTO db1.smf_boards
SELECT * FROM db2.smf_boards
WHERE ID_BOARD IN (xyz);

[Tony Reid]

Hey thats great - thanks for your help with this

[Oldiesmann]

No problem.

[Anguz]

Thank you [Unknown] and Oldiesmann.

[Midgard]

Thank you so much Oldiesmann