Shared user database

[Dean C]

Okie dokie, well I'm too lazy to sit down and write all the regexps myself so I say we form a community collboration on this one

How we'll do this
There are several different types of SQL queries which are passed to the database driver in db_mysql.php. These are (off the top of my head):

• SELECT FROM / DELETE FROM
• UPDATE
• INSERT INTO / REPLACE INTO
• JOIN

So we're probably looking at 4 regexps and a possibly a few more (that I've forgot).

The idea is one person from the community volunteers to take part of a query and rewrite it As we're going to have 4+ different people writing different pieces of code I think all we need to post up for now is an example query taken from vB3 and an example of your regexp fixing your part of the query and echoing it before and after.

My Contribution:

I'll do the FROM part of SELECT and DELETE

[Xenon]

the from part of SELECT and DELETE might be the same

as well as replace and insert are actually the same thing, so can both be handled by one person

[Dean C]

You're right, we only have 3 left then

[Dean C]

Ok just an update, I've got this sorted out by myself in the end. I wrote all the regexps and it all works.

But I've just been speaking to 'RoyalRidge' in the #vBorg chatroom and we came up with some forseeable problems:

- Forum permissions (what happens if the forumids are the same?)
- Usergroups (usergroupids = the same could be a problem)

[Xenon]

now you see, why i haven't finished my work on that hack

basically you have to rewrite the usergroup system as well, and design it in a way, that the registred ug has the sam id on both forums, and all other usergroups will just be added as additional usergroups, with distinct ids (and dummy usergroups for those on the other board...)

[AN-net]

yeah for complications!