I haven't reviewed how this kit works closely as I created my own HTTP online scoring system for several games in the past. But I can try to help:
Quote: "First, after testing this today I have noticed that the sql database is larger than the limit size. Is this correct? If I had thousands of people use this would the database have thousands of entries? I have altered the limit of 9 up to 30, but perhaps I have misunderstood the php script."
The "LIMIT" portion of the query in PHP simply retrieves the top 10 from the list of all saved records (or whatever value is specified there). So, by changing that to 30 you will actually be fetching the top 30 results which would only be necessary if you are also displaying the top 30 scores in your game.
There are a few ways you can control how many records are created in your database. The most direct way is to simply compare the user's score to the lowest saved score in the online top 10 (or however many you are displaying) before making a call to save it. Only make the HTTP request to save the score if it is greater than the lowest in the top 10. This will still create more records each time a new score is made, but it won't be submitting any scores that don't already beat the existing top ones. Note that MySQL can easily handle hundreds of thousands of records assuming your database storage limit isn't too small.
Another manual option is to periodically call the "DELETE" command in SQL with a range of rows specified. There are a bunch of different ways to do this depending on what records need to be deleted. If you'd just like to delete a range of records based on their ID, I'm attaching a simple PHP script that is compatible with those Daniel posted. Just upload it to the same directory as config.php and call it from a Web browser using:
http://yourdomain.com/dir/deletescores.php?startid=0&endid=50 This will immediately delete any records that have an ID between 0 and 50. ONLY use this script if you are following the advice above and only saving scores that are higher than the existing top 10, otherwise the IDs won't necessarily correlate to the top scores and by deleting a range like this you may be deleting some of the top scores. A more advanced solution would be to sort the records by score descending and then delete the total count minus 10 (or whatever) but I did not do that here.
Quote: "Secondly, and this may be the problem with the first question. I deleted a few of the entries as I was getting some blank entries with my initial tests, via my webpage. So now a few id numbers are gone and not been replaced as I expected. So for example id 1, 10, ans 28 are now missing. Will this cause issues?"
Nothing is wrong with this, the IDs are simply unique identifiers of the records and have no other effect.
