Flash MX Expert Needed For PHP/MySQL Integrated Project

Basically I'm looking for someone with excellent Flash MX skills to mainly create a Flash Quiz Game. There will be some MySQL and PHP work required too, as the quiz will get questions from a database, and post the users score back to the MySQL database.

I've put full details in the deliverables section, which in my opnion is well worth reading :)

I think this project is fairly straight forward for anyone with good Flash skills, and standard mysql / php skills. I'm going to allow a month to complete it, however my guess is it won't take anyone skilled that long to complete it. It is worth noting that I am a very flexible buyer, who listens to coder's advice, and I have happily extended deadlines before without any kind of penalty for the coder. I have a high buyer rating, and its worth checking out some of my high feedback - I am an EXCELLENT buyer to work with!

Please bid on this project. If you don't want to bid after reading this bid request, it would be great to know why so that I can improve my bid requests in future. Similarly, if there's anything you don't understand, or if you have any questions please feel free to ask them! I don't mind people asking questions, and it doesn't make me think you are less knowledgeable than other coders. In fact, I find that the better coders are the ones that ask lots of questions!

Thanks once again for bidding ;)

David Hammond

P.S - I find it useful if coders have MSN Messenger for live communication, as it makes it easier to explain things, and provide instant help / feedback. It would be good if when bidding you could let me know if you have / are willing to use/get MSN messenger :) Thanks ;)

## Deliverables

**Ok, so this is how the flash quiz game should work... :)**

When a user takes the quiz, they select a game type before they play. A round number is also assigned. This information needs to be passed to the flash game, which will be loaded in a new window. The details need to be confirmed with the MySQL server when the flash game loads, to make sure a user isn't posting fake information to the flash game.

*(I was thinking maybe an encrypted code should be passed to flash, then the flash looks up this encrypted code in the database to find out the username, game type, question category etc? By encrypted code, I mean a random text/number combination that is hard for people to make up, thats then searched for in the database to find out what game is being played. Ie. "EH73DHP039HSWE2214MDKJKEW237482")*

The flash game needs to preload images, questions and a background sound before the quiz starts. The url of the images and sound will be stored in the MySQL database, and the images and sound will be stored on the server. The questions will be selected randomly from the MySQL database, from the relevant category (ie. select randomly where category = category required).

The user will then be asked the preset number of questions that were selected from the database. These consist of 1 question, and 4 possible answers. The user is NOT told if they have got the question right or not at this point. The quiz is timed from the point the 1st question is shown, to the point they click on their final answer.

At the end of the quiz, a score is generated based on the amount of time the user took, and the number of correct answers they achieved. The settings will be found in the MySQL database, for example the user might get 10 points per correct answer, and lose 1 point per second they take answering the questions. It is therefore possible a user may get a negative score.

The score is shown to the user, along with their time taken and number of correct answers. This score is also stored in the MySQL database (Update from entries where entryid = xxx, set score = xxx). When the user clicks a button they will be redirected to a php page, something like "[url removed, login to view]".

There are several specific important things I need to say about this project. Firstly, the user taking the quiz should NOT be able to navigate through the frames of the quiz. In other words they cannot go back and change their answers, OR take the quiz twice. Secondly all the questions, music and background images need to be preloaded to speed up the quiz. A loading screen should be created with a progress indicator.

The flash quiz needs to be secure, so that users cannot (a) pretend they are another user taking the quiz OR (b) change answers / manipulate their score by cheating.

It is important also to mention that the MySQL database that this flash game will utilise has NOT been created yet. You will need to create it so that the quiz works. However, I have a word document which lays out the fields I feel are needed, so this should make it easier for you.

Another coder will create the page where the user selects the quiz, and the information is posted to flash. I will however need you to explain what variables you want posted to your flash quiz, and how. It would be ideal if you created a demonstration php page where I click a button/link that sends the variables to the flash game, and loads the quiz in a new window. It would also be good if you'd create the finishing php page (the one that the user is redirected to after the quiz), which gets the quiz result from the database, just to show that the quiz works!

Basically, the job involves passing variables to and from flash, getting information from mysql, and creating a simple flash game.

I need you to create some basic images for the flash game, which should be stored as gif or jpeg files, and preloaded into the quiz. I want these images to be editable though so that my designer can design the look of each quiz. In other words if I replace [url removed, login to view] on the /flash/images/ folder on the website, the background of the quiz with [url removed, login to view] should look different.

Note: Each quiz will use the same flash game, however it may load different background images (I think of this as a "skin"), questions and sounds. Hence the flash game needs to communicate with the mysql database to find out where the relevant background images / sounds are stored.

One other thing you will need to do with the flash game is make allowances for server errors. In other words, if my mysql database is down, and the flash is trying to get the questions from the mysql database, it should come up with a suitable error message, rather than just crashing!

Here is a summary of the key "frames" required:

- Loading screen

- Welcome screen (with button, to start quiz)

- Quiz screens (1 question, 4 answers, user clicks on correct answer)

- Quiz finished screen / calculating score (as soon as the user submits the last answer, they are shown this screen for about 5 seconds, which will say "calculating score..." etc. This will have a different background sound and image.)

- Result screen (shows user's score)

- User clicks button and is redirected to php page, or is redirected from result screen after x seconds.

-----------------------

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Flash 6 (MX)

To work in Internet Explorer / other common browsers

Integrated with MySQL database and PHP.

PHP

Proje NO: #3917642

Proje hakkında