<?php


//create a connection to a mysql server


$con = mysql_connect($host,$user,$password);





//kill the script if no connection could be made


if (!$con)


{


die('Could not connect: ' . mysql_error());


}





//select a database on the created connection


mysql_select_db($database, $con);





//Do mysql stuff here





//close the mysql connection after you are finished


mysql_close($con);


?>

GET http://www.myhost.com/myphpscript.php 

GET http://www.myhost.com/myphpscript.php?loginname=robotcecil&loginpassword=ry562s1e1949ffs389289dawe0328907 

<?php


//create a connection to a mysql server


$con = mysql_connect($host,$user,$password);





//kill the script if no connection could be made


if (!$con)


{


die('Could not connect: ' . mysql_error());


}





//select a database on the created connection


mysql_select_db($database, $con);





//Do a mysql query into the table where you store your user information (login name, password, user stats, etc)


//and look for the user with the login name (these should be forced to be unique upon creation so that lookup queries


//will only return ONE result) that matches the sent $_GET['loginname'] value from the HTTP GET Request by mmf2.


//This will return all the cell information about the resulting sql entry (login name, password, user stats, etc)


//which you can use.


//You can then compare the MD5 hash of the sent $_GET['loginpassword'] with the MD5 of the resulting sql entry.


//If they match you can print out the users stats, etc for mmf2 to recieve and parse and use in-game.


//If they do NOT match you can send a status string like "login failed" for mmf2 to detect and act


//accordingly.





//Close mysql connection


mysql_close($con);


?>