Global VB3 user table

[Dolby]

I own 5 vbulletin licesens and I would like to have a global user table so a user just needs to register with one site and they are registered with all.

With vb3 am I wrong to think that all the user queries are done in functions_user.php, functions_register.php and adminfunctions_user.php so I can just change the database connections there to use the global user table? Or is this gonna be just about as impossible to do as with vb3.

I could just make a registration page that dumps the info into all the databases but I'd like the userid to be the global.

[NTLDR]

Originally Posted by Dolby

With vb3 am I wrong to think that all the user queries are done in functions_user.php, functions_register.php and adminfunctions_user.php

Yes, you would be very wrong to think that There are queries all over the place that relate to the 3 user tables, user, userfield and usertextfield. If you have them all in the same database then it should be just a matter of defining a user table prefix in config.php and then editing all the queries, which you'd have to search through all the files for " . TABLE_PREFIX . "user (as well as the other two) and edit the prefixes everywhere and that *should* work, its somthing to go on at least

[Dolby]

Thanks for the reply NTLDR. These would be seprate databases on a couple servers. Ohh well back to the drawing board.

I think I might just end up makeing a global registration page that dumps the data into all my vbulletins.

To bad there isnt a mysql command to share a specified table or auto sync a table through out multiple databases.

[Ryan Ashbrook]

Originally Posted by NTLDR

Yes, you would be very wrong to think that There are queries all over the place that relate to the 3 user tables, user, userfield and usertextfield. If you have them all in the same database then it should be just a matter of defining a user table prefix in config.php and then editing all the queries, which you'd have to search through all the files for " . TABLE_PREFIX . "user (as well as the other two) and edit the prefixes everywhere and that *should* work, its somthing to go on at least

I can verify that.

I've done it before and, while it's weird at first, it works.

[Dolby]

Originally Posted by Ryan Ashbrook

I can verify that.

I've done it before and, while it's weird at first, it works.

I believe NTLDR, however the 5 databases are all separate at the moment so that wont work for me. I guess I could merge all the databases together and use prefixes but wouldn?t it be more efficient to have 5 small databases then one big hairy db? I guess I could put the one big db on its own server.

Thanks.

[NTLDR]

To be honest I don't know. I'd suggest asking eva2000 over at vB.com as he would have a much better idea of any performance issues