A Flash Developer Resource Site














Internet Commerce

Partners & Affiliates














Developer Channel

internet.com


Featured Flash FLA
Gallery Downloads 11336 Flash Movies | 2 New Flash Movies Added
What's New | Top 100

Featured FLA

» Author: Surjit Dhami
» Title: Book
» Description: Book
» More by Surjit Dhami


Random FLAs | Add Flash Movie
Featured Flash Site
Gallery Downloads 5848 Flash Sites | 0 New Flash Links
What's New | Top 100 Flash Site

Featured Site

» Posted in the Flash Kit Links section
» Title: All-American Rejects
» Description: Get to know this great band by exploring their "practice room".


Random Links | Add your own Flash Related Links
Flash Tutorials 1277 Tutorials 7 New Tutorials Added!
What's New | Top100

» Create xml slideshow with free template
» How to Insert a Multilingual Subtitle Into Your Flash Video Studio
» How to Create Cool Halloween Slideshow
» Debugging flash using the Firebug console
» Create Flash Slideshow on Blogger
» FLASH TRICKS IN WEB ADVERTISING: FLASH BANNERS
» HTML Photo Gallery Tutorial
» Create your first flash site – PART 1
» How to Make a Flash Photo Gallery
» Unknown Tag: Title10
Random Tutorial | Add Site

Trading Customer Accounting (IL)
Next Step Systems
US-IL-Chicago

Justtechjobs.com Post A Job | Post A Resume


Tutorials Home What's New Top Rated Submit myTutes Random!

Search Tutorials


Tutorials Tutorials » Games

Categories How to create scoreboards for your flash games
Author: Nick Kuh | Website: http://www.flasharcadia.com |

 
Page 2
«prev 1 2 3 4 5 6 7 next»

Setting up the mySQL database

This tutorial will not cover mySQL installation. However, most web hosting companies will do this for you. Your host must also run php for the script in this tutorial to work. If you don't yet have web space and you'd like to run php/mySQL my company does offer this service so let me know if you'd like to learn more - nick@edition.co.uk.

Ask you host to set up your mySQL database for you. Give them three pieces of information: (1) a name for you database (2) a username for your database (3) a password for your database.

Setting up phpMyAdmin

Inside the tutorial files you'll find a folder entitled mysql. Inside it open config.inc.php3 in your favourite text editor. Change the following variables to your own variables: YOURUSERNAME, YOURPASSWORD and YOURDATABASENAME. Save and close the file. Now upload the entire mysql folder to your web space. It doesn't make a difference which directory you put it in as it will automatically be able to find your database on your local host. I'll assume that you've put it into the root of your site. Now type http://www.your domain.com/mysql into your browser. If the mySQL database has been installed correct you should now see the name of your database in the top left corner of your screen. Click on the link.

Setting up a database table

OK, let's get down to business. First let's use the phpMyAdmin interface to set up a mySQL table to store our players names and scores in. At the bottom of web page you should see "Create new table on database yourdatabasename:" Name the table "highscores" and set fields to "3".

On the first row set the following variables as follows (leave the others blank):

Field - id
Type - int
Length/Set - 11
Extra - auto_increment
Primary - tick this box

On the second:

Field - players
Type - varchar
Length/Set - 255

On the third:

Field - scores
Type - int
Length/Set - 11
Default - 0

Click "Save"

Your table has now been created so we can leave the database and get to work on our action scripting.

«prev 1 2 3 4 5 6 7 next»

» Level Intermediate

Added: : 2002-04-21
Rating: 6.74 Votes: 19
Hits: 4202
» Author
Nick is a Flash Developer for London based web design agency Edition Interactive. His main role is online games design and development for clients such as Channel Four Television.
» Download
Download the files used in this tutorial.
Download (94 kb)
Get conversion and unzipping tools for PC and Mac here!

» Forums
More help? Search our boards for quick answers!

Please rate this tutorial, 10 is the top rating, you can also click the comments link to read/write a review.
10 9 8 7 6 5 4 3 2 1
www.flasharcadia.com. &URL=http://www.flashkit.com/tutorials/Games/How_to_c-Nick_Kuh-771/index.php"> Read or Post Comments
 
   
 

internet.commediabistro.comJusttechjobs.comGraphics.com

Search:

WebMediaBrands Corporate Info

Legal Notices, Licensing, Reprints, Permissions, Privacy Policy.
Advertise | Newsletters | Shopping | E-mail Offers | Freelance Jobs