The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
I hope what I want is possible, but I guess it'll be just something I have to live with.
Here's the deal: I have oxle.com, a Snitz forum, running on an Access database. I also have storage.oxle.com, a file storage facility based on PHP, using a MySQL database at a completely different hosting provider. I want to integrate the user registration for storage.oxle.com into the user registration process of the snitz forum at oxle.com.
The registration process for storage.oxle.com is extremely simple: http://storage.oxle.com/register
1 Username
2 password (+confirm)
3 e-mail address
4 two preference questions about allow mail and allow PM. 5 accepting the ToS
1,2 and 3 are also covered in the Snitz registration process. 4 can be removed. 5 is also included in the Snitz registration process. In other words, I already have all the information needed for registration on storage.oxle.com in the registration form of the Snitz forum. So, the question is: how can I enable the user to post that form to two pages, one being the Snitz page and the second being the Storage page.
<
Here's the deal: I have oxle.com, a Snitz forum, running on an Access database. I also have storage.oxle.com, a file storage facility based on PHP, using a MySQL database at a completely different hosting provider. I want to integrate the user registration for storage.oxle.com into the user registration process of the snitz forum at oxle.com.
The registration process for storage.oxle.com is extremely simple: http://storage.oxle.com/register
1 Username
2 password (+confirm)
3 e-mail address
4 two preference questions about allow mail and allow PM. 5 accepting the ToS
1,2 and 3 are also covered in the Snitz registration process. 4 can be removed. 5 is also included in the Snitz registration process. In other words, I already have all the information needed for registration on storage.oxle.com in the registration form of the Snitz forum. So, the question is: how can I enable the user to post that form to two pages, one being the Snitz page and the second being the Storage page.
<
Posted
Hi,
If the PHP accepts remote connections then you can write the connection string in ASP.
For instance
dim adoConn
dim adoRS
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "Driver={mySQL}; Server=phpwebsite; Port=3306; Option=0; Socket=; Stmt=; Database=address; Uid=admin; Pwd=password;"
adoRS.ActiveConnection = adoConn
Also depends on whether the directory the mysql database resides in is visible on the Internet via the domain address (not recommended for security reasons).
Cheers
Phil<
If the PHP accepts remote connections then you can write the connection string in ASP.
For instance
dim adoConn
dim adoRS
set adoConn = Server.CreateObject("ADODB.Connection")
set adoRS = Server.CreateObject("ADODB.Recordset")
adoConn.Open "Driver={mySQL}; Server=phpwebsite; Port=3306; Option=0; Socket=; Stmt=; Database=address; Uid=admin; Pwd=password;"
adoRS.ActiveConnection = adoConn
Also depends on whether the directory the mysql database resides in is visible on the Internet via the domain address (not recommended for security reasons).
Cheers
Phil<
Posted
I've been forced to do it differently, as it does not end with just the insertion into the MySQL database ; the user folders need to be created too, and that's part of the registration process in PHP.
So, I've now done it manually : the registration page on storage.oxle.com is gone, and redirects to the oxle.com registration page.
After the registration is complete, the account is manually created on storage.oxle.com by me, and the hashed password is inserted into the db using a simple script. I've tested it, and it works great. Not as nice as I wanted it to be, but it'll do the trick.
Thanks for all the suggestions!
<
After the registration is complete, the account is manually created on storage.oxle.com by me, and the hashed password is inserted into the db using a simple script. I've tested it, and it works great. Not as nice as I wanted it to be, but it'll do the trick.
Thanks for all the suggestions!
<
Posted
Well, after the DB insertion from oxle.com, you could retrieve the member ID and redirect to a page on storage that would get that ID and create an appropriately named folder. Of course, this last part would require you to do it in PHP...<