Hi,
Some questions if I may...
(Not certain if this is the right forum, btw. If it isn't my apologies)
Our site consists of 2 distinct areas, a memberarea and a message board, both of these unfortunately use their own database. People need to pay for memberarea access and we would like to know on the message board which members have and which have not paid. This info will allow us to give more features to paying members.
In order to realize this we need to combine the registration processes.
JoshPet was already nice enough to point us in the right direction a bit in that we need a seperate group on the board to identify paying members. I assume I then need to have the registration process add a user to this group if he has paid.
And this is where I begin to run into problems
To be honest I am a bit stuck at how to best handle this. Preferably I think I would like to use the UBBT registration and add additional fields for our account options (free, 1-month trial, 1-year, etc.).
Alternatively we could use the info on our registration page to create a useraccount on the board.
My partner has had a look at this a bit and has the following questions:
* How can we see if a user exists?
I assume this could be done by a query on Username and / or email address, right?
* How can we create a new user in UBBT?
I think this is done in adduser.php, but could we do this with an SQL query as well? Or do we need to use this script?
An added complication, I think, is that the databases run on different machines, so a solution using only SQL queries would be great since the account creation could then be done remotely from the billing server.
Anyway, I hope this is clear and that someone could provide us with some pointers.
Sanuk!
