3/18/16
Here is my php script to add the values to the database.
<?php
$server = "MyServersIP";
$user = "MyUser";
$pass = "MyPassword";
$db = "MyDB";
$conn = mysql_connect($server, $user, $pass);
mysql_select_db($db);
$Username = mysql_real_escape_string($_GET['Username'], $db);
$Fuel = mysql_real_escape_string($_GET['Fuel'], $db);
$IAPCar1 = mysql_real_escape_string($_GET['IAPCar1'], $db);
$IAPCar2 = mysql_real_escape_string($_GET['IAPCar2'], $db);
$Score = mysql_real_escape_string($_GET['Score'], $db);
$Level = mysql_real_escape_string($_GET['Level'], $db);
$Wins = mysql_real_escape_string($_GET['Wins'], $db);
$Losses = mysql_real_escape_string($_GET['Losses'], $db);
$Ads = mysql_real_escape_string($_GET['Ads'], $db);
$LicensePlate = mysql_real_escape_string($_GET['LicensePlate'], $db);
$hash = $_GET['hash'];
$secretKey = "BlItZkRiEg01![SCD];"
$real_hash = md5($Username . $Fuel . $IAPCar1 . $IAPCar2 . $Score . $Level . $Wins . $Losses .
$Ads . $LicensePlate . $hash);
if ($real_hash == $hash)
{
$query = "INSERT INTO Player values (NULL, '$Username', '$Fuel', '$IAPCar1', '$IAPCar2',
'$Score', '$Level', '$Wins', '$Losses', '$Ads', '$LicensePlate');"
$result = mysql_query($query);
}
mysql_close($conn);
?>
Here is the code I use to call the php script:
public string setValues = "http://www.mysite.com/Set_Values.php?";
private string secretKey = "SecretKeyFromThePhpScript";
public void SetValues(string username, int fuel, bool iapCar1, bool iapCar2, int score,
int level, int wins, int losses, bool ads, string licensePlate, bool firstTime)
{
string hash = Md5Sum(string.Format("{0}{1}{2}{3}{4}{5}{6}{7}{8}{9}", username, fuel, iapCar1, iapCar2,
score, level, wins, losses, ads, licensePlate, secretKey));
string url = string.Format("{0}username={1}&fuel={2}&IAPCar1={3}&IAPCar2={4}&Score={5}&Level={6}" +
"&Wins={7}&Losses={8}&Ads={9}&LicensePlate={10}&FirstTime={11}&hash={12}", setValues, username, fuel, iapCar1, iapCar2,
score, level, wins, losses, ads, licensePlate, firstTime, secretKey);
WWW www = new WWW(url);
}
