ABSTRACT
High score tables encourage users to stay online in order to see their name appear in the high score list, or to win a prize if they are the highest scorer for a prize winning game. The high score tables are usually stored in a database and then loaded into Flash when a call to a high score table is required. This chapter explores the options. The information extends what you have learnt in Chapters 12 and 14. In contrast to Chapter 14, where we concentrated on using an SQL Server database, in this chapter we will use an Access database. Access is part of the Office package and can be accessed from all Windows servers. To make high score tables work you will need a registration and login form and you will need to keep track of information as you move from page to page. Session variables provide this vehicle or cookies if you want the information to persist even after the user has logged off the site. We will look at using session variables and cookies to store information as we navigate a multi-page site. On a big site the Webmaster will need tools to examine traffic and users; we will look at creating pages in Flash to review the database, update and delete records.
Creating a registration page If a user has never visited a site then the first thing we want them to do is register. You probably want them to have some access to find out what the site has to offer, but you will constantly remind them that they should register. Registered users bring a database to help you to promote the site as new features and games are added. Some users will gladly register and are happy to receive information via email; others will deliberately give a fake address in order to remain anonymous. High score tables are the most effective encouragement to register, particularly when linked to a prize-winning game. There would be no point winning a prize-winning game if the player had given a fake email address!
