Could this not work from one set of tables? I was thinking the addition of a userid or siteid columns to each table so the data could be 'per site' but still within the realms of managability. This way would also make changes across all sites easier, and in addition it would make permissions handling from vBulletin easier.
Obviously, I dont know exactly whats involved with the above, I'm sure its a fair amount of slog...but I'm thinking that once you've gone the full distance on your current path, it may have been less work going the alternate way I mention.
|