{"id":24,"date":"2014-04-01T04:06:00","date_gmt":"2014-04-01T08:06:00","guid":{"rendered":"http:\/\/naplandgames.com\/blog\/2014\/04\/01\/agk-tutorial-online-high-score-system\/"},"modified":"2018-12-18T09:14:17","modified_gmt":"2018-12-18T14:14:17","slug":"agk-tutorial-online-high-score-system","status":"publish","type":"post","link":"https:\/\/naplandgames.com\/blog\/2014\/04\/01\/agk-tutorial-online-high-score-system\/","title":{"rendered":"AGK Tutorial – Online High Score System"},"content":{"rendered":"
Originally published in the TGC Newsletter – April, 2014<\/a><\/div>\n
<\/div>\n
In concert with the current competition to make an addictive game, we thought it might be a good idea to show how to set up an online scoring system. This tutorial will make use of AGK Tier 1 BASIC, PHP, and MySQL. You will need access to a server with PHP and MySQL capabilities.<\/span><\/div>\n
<\/div>\n
To start, if you don’t already have a server set up, you can install XAMPP (www.apachefriends.org<\/a>) to your local PC. This could be used as your server, but you will need to allow access to outside networks which can be dangerous without the proper knowledge of security. I do suggest that you use XAMPP for testing before going to a live server.<\/div>\n
<\/div>\n

The database<\/h4>\n
After you have XAMPP set up you’ll need to create a database and table for the highscores to be recorded in. For this tutorial let’s call the database “high_scores<\/em>” and the table will be “my_game<\/em>“. You’ll also need to create a user for the database who has access to selecting (searching), and inserting the row. The table will need the following columns as a minimum:<\/div>\n
<\/div>\n
\n