Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Aiheen aloitti: Adin - helmikuu 10, 2005, 07:21:07 AP

Otsikko: Assimilating other boards
Kirjoitti: Adin - helmikuu 10, 2005, 07:21:07 AP
Ok, in mere theory:

Let's say somebody runs out of money (no, it's not me, stop staring like that :P) and is like "Well, i can't go on, but i don't want the users to lose all their posts, pms, etc, can't you help me out ?" Now lets say that guys running phpbb, ipb or something, while i am running SMF. I know it's possible to convert forums such as these, but if i only want to take over the posts to add them to my forum ... how would i do that ? Technicly, that would be a big bunch of handwork with phpmyadmin, but there should be a easier way to do it ... some way to automate this.

Any ideas ?
Otsikko: Re: Assimilating other boards
Kirjoitti: Oldiesmann - helmikuu 10, 2005, 10:18:02 AP
Really there just isn't an easy way to do this because of how inter-connected everything is...

Boards table:
ID_BOARD - the ID number of the board
ID_CAT - the ID number of the category the board is in
ID_LAST_MSG - the ID number of the last message in the board

Messages table:
ID_MSG - the ID number of the message
ID_MEMBER - the ID number of the member who posted the message
ID_BOARD - the ID number of the board the message is in
ID_TOPIC - the ID number of the topic the message is in

Topics table:
ID_TOPIC - the ID number of the topic
ID_BOARD - the ID number of the board that this topic is in
ID_MEMBER_STARTED - the ID number of the member who started the topic
ID_MEMBER_UPDATED - the ID number of the member who last posted in the topic
ID_FIRST_MSG - the ID number of the first message in the topic
ID_LAST_MSG - the ID number of the last message in the topic
Otsikko: Re: Assimilating other boards
Kirjoitti: Adin - helmikuu 10, 2005, 01:07:59 IP
Yeah, but if i simply go like "Ok ... all of these topics go from their old sub-forum into this one on my forum." If you'd give the script a little help it should actually work.

The members would simply need to be given new ids according to their new home forum and that'd be fixed aswell ...

... but since i think you know more about programming then i do, i'll drop the matter. ;) Was just an idea anyways.
Otsikko: Re: Assimilating other boards
Kirjoitti: Oldiesmann - helmikuu 10, 2005, 01:35:12 IP
The main reason this is so difficult is because you'd have to re-number all the message and topic IDs so that they don't clash with the existing messages and topics.
Otsikko: Re: Assimilating other boards
Kirjoitti: Adin - helmikuu 10, 2005, 01:51:49 IP
Yes, i see that, i saw it before. But if the whole id table is simply rewritten, i believe that should work.