Merge vB > vB Script?

[Marshalus]

I know a lot of people would get a lot of use out of a hack like this, me especially. ;)

I recently took control of another website, which had a vBulletin fourm on it, and I'd like to merge the content of that forum (users, posts, attachments, etc) into mine. Both of the forums are fairly large (1000 users with 40,000 posts each) and some of the usernames are the same, since both sites were about the same topic.

Is there any kind of script out there that can do this? What would it take to write a script like this?

I'm willing to pay the person who decides to take it on. :D

[Neo]

*cough* this is one of my projects in the neer future

[Xenon]

hmm, merging posts, forums, threads would be easy, but users with same name will make a problem

are these many users with the same names or can you change usernames manually because they aren't too much?

also are some users also the same people or completele different?

[Marshalus]

All of the users are the same people. The two forums were in quasi-competition with each other and uh, we won ;) 99.9% of the people with idenitical users names are the same people, and the .1% that might not be, probably don't visit so I can delete them if I have to.

Neo, if you wrote this script I would be your slave for life. How near future are we talking? I don't mean to sound pushy but I REALLLLLLYYY would like to use this script. JamesUS said over at vB.com that he might make one, but they are so overwhelmed with vB3 that I doubt it'll happen soon.

One good thing is though, he said this will be a standard feature of vB3 :D (don't let that discourage you though ;) )

[SZ|TalonKarrde]

Taken into consideration that almost all the users are the same, it should be OK to just forget about the users table unless it was necassary.

[Marshalus]

Any news on this Neo?

[SZ|TalonKarrde]

/me pokes neo

You there?

[blackice912]

I'm very interested in this. Very very very.

[Marshalus]

You should be, you work for me ;)

Any word on this Neo?

[SZ|TalonKarrde]

Hey! I work for you too!
But I have vB as well =)

[MadMikey]

I have just spent the week, writing a script to merge two vBulletin databases into one.

It was written specifically for my situation, but someone with knowledge of mySQL and PHP (specifically with vBulletin) could easily get it working.

It will merge all users, first checking for matching email addresses, then exact matches on usernames. If either matches, it is assumed to be the same user. In my situation, we had several users in both forums, so this was appropriate.

It will copy over all users, userfield info (provided all of the fields in the source db exist in the destination db), custom avatars, polls, threads, post, attachments and private messages.

Threads from the original db can be put into any forum in the destination db. Existing forums, new forums....you can even merge 2 or more forums into one.

If anyone is seriously interested in this script, knowing that it will take some work, I can clean it up and get it posted with some instructions. After that, feel free to do whatever you wish with it.

Again. This was written for my two databases (2.2.6). I won't go so far to say it will even work for you, but you're welcome to try.

[ryanhulce]

MadMikey!!!

I am in need of this script!

Can you please post it or email it to me?

ryanhulce@insightbb.com

Thanks A Bunch

[MadMikey]

Sorry everyone. Real Life, as it's prone to do, just got in the way.

BACKUP YOUR ENTIRE DATABASE BEFORE RUNNING THIS SCRIPT!!!!!!!!!!!!!!!!!!!!

Here's the script that I used to merge to vB forums into one. I spent about 2 days writing it. Again, it was written specifically for my situation, but should work for yours.

It REQUIRES some knowledge of mySQL and PHP. Instructions are included in the readme.txt.

If you have questions or problems, feel free to email me at madmikey@unrealplayground.com.

BACKUP YOUR ENTIRE DATABASE BEFORE RUNNING THIS SCRIPT!!!!!!!!!!!!!!!!!!!!


I'd really like some feedback from someone who gets this to work. It worked for me, but if someone else gets some use out of it, that's even better.