Hi,
Is it possible to connect the local sql database to Network?
Hi,
Is it possible to connect the local sql database to Network?
Change your localhost to your global DNS
###script.js###
var addScoreUrl = "http://localhost/connecttosql.php?";//the ? mark is for the query
function PostScore(name:String, score:int){
var hash = Md5.Md5Sum(name + score + secretKey);
var highscore_url = addScoreUrl + “name=” + WWW.EscapeURL(name) + “≻ore=” + score + “&hash=” + hash;
hs_post = WWW(highscore_url);//send url
yield hs_post;// wait untill something back
if(hs_post.error){
print("Error posting score: " + hs_post.error);
}
Application.LoadLevel(“HighScore”);
}
###connecttosql.php###
<?php
$db = mysql_connect('localhost', 'root', '') or die('Could not connect: ' . mysql_error());
mysql_select_db('mydb') or die('Could not select database');
// Strings must be escaped to prevent SQL injection attack.
$name = mysql_real_escape_string($_GET['name'], $db);
$score = mysql_real_escape_string($_GET['score'], $db);
$hash = $_GET['hash'];
$secretKey="777"; # Change this value to match the value stored in the client javascript below
$real_hash = md5($name . $score . $secretKey);
if($real_hash == $hash) {
// Send variables for the MySQL database class.
$query = "insert into scores values (NULL, '$name', '$score');";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
}
?>