MySQL & PHP Login/Register System

[Haris]

Hello again, I have created a simple login/register system using PHP and MySQL. It is located at http://pokemonol.net/main.php I now want to allow users to login to the game (once they have registered by using my PHP system) with the actual game client. I need help as I don't know how to get MMF to gain access to the MySQL database (where all the user info is stored) and allow users to login, if what they entered matches the MySQL user database. I also want to allow users to have the option of registering through the game client aswell as the website, where all their account info they entered would be sent and stored in the MySQL database. How would I do this? Can anyone help solve this problem? Is there any example files that would do the same thing?

[Haris]

Hello again, I have created a simple login/register system using PHP and MySQL. It is located at http://pokemonol.net/main.php I now want to allow users to login to the game (once they have registered by using my PHP system) with the actual game client. I need help as I don't know how to get MMF to gain access to the MySQL database (where all the user info is stored) and allow users to login, if what they entered matches the MySQL user database. I also want to allow users to have the option of registering through the game client aswell as the website, where all their account info they entered would be sent and stored in the MySQL database. How would I do this? Can anyone help solve this problem? Is there any example files that would do the same thing?

[Gamerdude]

I don't have time to cook up an example, but I've done this before...not in a secure way though. I went the simple route and just used MooSock to send the login variables through POST (GET would make it a URL, which is even less secure) and I had a php script on my server that took care of all the checking. From there, I had it display "okay" or "denied" in just text on an empty page which I would then grab with MooSock (since it gets the response after sending the data).

This may seem complex...maybe someone else has an alternate method or an example...sorry I can't provide more info, too busy >_>.

[Gamerdude]

I don't have time to cook up an example, but I've done this before...not in a secure way though. I went the simple route and just used MooSock to send the login variables through POST (GET would make it a URL, which is even less secure) and I had a php script on my server that took care of all the checking. From there, I had it display "okay" or "denied" in just text on an empty page which I would then grab with MooSock (since it gets the response after sending the data).

This may seem complex...maybe someone else has an alternate method or an example...sorry I can't provide more info, too busy >_>.

[TotallyTurton]

Glad you managed to make the register/login system quite quickly!

I wouldn't know the best way to communicate with the database from an MMF app, but I'm very interested to find out. I hope there is a better way than sending and retrieving data from PHP pages.

[TotallyTurton]

Glad you managed to make the register/login system quite quickly!

I wouldn't know the best way to communicate with the database from an MMF app, but I'm very interested to find out. I hope there is a better way than sending and retrieving data from PHP pages.

[neat_Kliker2]

PHP!? PERL! :P
but why use direct SQL, you will send your SQL login details in plan text over the internet, so anyone can get anyones password

[neat_Kliker2]

PHP!? PERL! :P
but why use direct SQL, you will send your SQL login details in plan text over the internet, so anyone can get anyones password

[TotallyTurton]

What alternative methods would you suggest for communicating with an online database?

Or do you think talking to it via a Server-side language is the best way?

[TotallyTurton]

What alternative methods would you suggest for communicating with an online database?

Or do you think talking to it via a Server-side language is the best way?