Zacarias
Wed 30th Jan '08, 8:26pm
I had a question... If I have 2 vBulletin forums and both are running vB 3.7 Beta 4, technically, couldn't I import users and posts (because that's all I need) from one forum into the other, and merge users via admincp later?
I was thinking about this because I'm in this exact situation.
I know that a direct import of the SQL would overwrite posts and users based on userid and postid.... So I was wondering if there was a query that I could run (or an array) that would append all entries with a number (let's say '10' for example-- making post number 2200 by user id 230 be post number 102200 by user 10230)... If this were possible (given that I don't have a users or post numbers that are these numbers), couldn't I import one forum into the other with no loss of data?
If this is confusing, just let me know.. I'll try to explain another way.
EDIT: I made a test database and brought in some SQL from the forum and found I can do things like this:
UPDATE user SET userid = userid + 100000
This makes every user be their userid plus 100,000... So it seems I can import after all.
I was thinking about this because I'm in this exact situation.
I know that a direct import of the SQL would overwrite posts and users based on userid and postid.... So I was wondering if there was a query that I could run (or an array) that would append all entries with a number (let's say '10' for example-- making post number 2200 by user id 230 be post number 102200 by user 10230)... If this were possible (given that I don't have a users or post numbers that are these numbers), couldn't I import one forum into the other with no loss of data?
If this is confusing, just let me know.. I'll try to explain another way.
EDIT: I made a test database and brought in some SQL from the forum and found I can do things like this:
UPDATE user SET userid = userid + 100000
This makes every user be their userid plus 100,000... So it seems I can import after all.