vB3] 2 Forums, 1 User DB... possible?

[soopa]

Originally Posted by Xenon

Dean, that's exactly the way i mentioned above.
with that way you can produce some real problems if you are not carefully when creating new usergroups and such

could you not just move the usergroups table into the `user-db` ?

what types of problems you have in mind?

[soopa]

Originally Posted by Dean C

Wow phpbb does that - that's a great idea The tablenames are hardcoded but I genuinely think this'd be a good idea to do in later versions of vB3. I suggest you suggest this as a feature suggestion. I was going to suggest a way to do this in not so many lines within config.php. However I'm not sure if php's capabilities would allow this.

Basically for all those that may know I was thinking that perhaps you could write some ifs and regexp's to check the instance of where the constant is being used. For example if the follow characters until the next gap of TABLE_PREFIX was user then replace it with something. I don't know if this is possible.

yea its kinda neat. http://www.phpbb.com/kb/article.php?article_id=55

i will suggest it for vb. very handy.


as for adding db prefix to sql queries in vB code... easy nuff to do with text editor. rather find and replace by hand anyway just to make sure im not flubbin nothing.


just looking at the vB3 DB schema it could be quite a challenge figuring out what tables exactly to seperate... hmm.


would this also work for vB2 do you imagine?

[Dean C]

Well I kind of just did a practice of how this would work.

Assuming you had a table prefix (WILL NOT WORK WITHOUT A TABLE PREFIX !) you add this within db_mysql.php:

PHP Code:

$query_string = str_replace(TABLE_PREFIX . 'user', 'a' . TABLE_PREFIX . 'user', $query_string); 


Below:

PHP Code:

global $query_count, $querytime; 


Now don't actually do this - This is just to illustrate how you could use it. You'd replace the a with the name of the database and a period and it'll work. The problem comes with the key fields like userid, usergroupid. Just a though for people thinking about doing this though

[soopa]

hmm. if both sites have the same user groups tho, this would not be a problem correct?

[soopa]

what lines of db_mysql are you adding these snippets?

[Dean C]

It was just pseudo code not to actually be implemented. It was just to show the possibilities of how it could be done