Forums / Craftwork / Server-side / merge the data base...

thanks for the reply Trustm., i didnt predict that ull also explain merge with other cot tables, my plan is to merge ONLY sed_users, sed_forum_topics, sed_forum_posts my fault, now explanation:

i already did 1 merge with d.b. from the phpBB, i made few mistakes that cost me alot of time after merging :)
basicly my idea this time (with small experience) is to:

1. MOVE ALL USERS to 1 group (i.e. users.php?g=4) from the site that will be merged
2. MOVE ALL TOPICS to 1 section, like: fs_id=4 from sed_forum_sections from the site that will be merged

and thats all, after that i can tell my moderators to start moveing topics to correct sections

also i'd i.e. if the D.B. of the merged site have user_id's starting from 1 till 6000, i'd ONLY add the "prefix":
something like:
10001, 10002 till 106000 (it can be done with the Notapd++ and "regular extensions", i already used it, it helped me to fix bbcode betwen phpbb and cotonti) after that only i'd have to:
UPDATE sed_forum_topics SET ft_lastposterid='10001' WHERE ft_lastposterid='1';
UPDATE sed_forum_topics SET ft_firstposterid='10001' WHERE ft_firstposterid='1';

-Dave