Been working on this and so far I have the PHP nearly ready:
You can test this right now by the following:
http://deadyeti.com/blanius/musicgame.php?action=get will dispay the data the way it will appear to 3dfa. (I'll explain later)
You can also get an HTML response with
http://deadyeti.com/blanius/musicgame.php?action=html
I added this in case you want to be able to display the high scores in a web page.
The update seems to be ready as well, but I'm still testing iit. (I do this by hand entering the variables that 3dfa will need to send)
Here is the partial code:
<?php
// This is not a secure way to do this we should really take all the connection code and put it in
// another file and use Include filename to add it
$host="myhost.com";//This is your server name
$dbname="mydatabase";//The name of the database on your server
$username="myusername"; // The username for accessing the database
$password="mypassword"; // The password for accessing the database
$dbtable="MusicGame"; // The name of the table we are using
$notify="youremail"; // The email address you want notices sent to. (optional)
mysql_connect($host,$username,$password) OR die("Can't connect to database");
mysql_select_db("$dbname") or die("Unable to select database");
if ($action=="html")
{
echo ("<table border=\"1\">");
$result = mysql_db_query ("$dbname", "SELECT * FROM $dbtable ORDER by Mid");
while ($row = mysql_fetch_array ($result))
{
$name =$row["name"];
$date =$row[date];
$score =$row[score];
echo"<tr><td>$date</td> <td>$name</td><td>$score</td></tr>";
}
echo "</table>";
}
if ($action=="get")
{
$result = mysql_db_query ("$dbname", "SELECT * FROM $dbtable");
while ($row = mysql_fetch_array ($result))
{
$name =$name.$row["name"]."|";
$date =$date.$row["date"]."|";
$Mid =$Mid.$row["Mid"]."|";
$score =$score.$row["score"]."|";
}
echo ("&Mid=".$Mid."&dates=".$date."&names=".$name."&score=".$score);
}
if ($action=="add")
{
$day = date("d");
$month = date("m");
$year = date("Y");
$date = "$day"."."."$month"."."."$year";
$sql = "UPDATE $dbtable SET name='".$name."',date='".$date."',score='".$score."' WHERE Mid='".$Mid."'";
echo $sql;
$result = mysql_query($sql);
/*if ($notify){
mail($notify,"new high score added ",$name."\n".$score,"");
}*/ //commented out while testing.
}
?>
Next the hard part. The javascript side within your game.
You will have to call the php script at the start of the game and the variables loaded into an array. Then if the user playing gets higher than the lowest score, add them and shift all the scores.
Perhaps Kusco would like to dive in at this point.