Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

Creating a DB feed fruit machine

I want to create a flash movie that will simulate a fruit machine with 6 reels, the reels need to spin around when a button on the movie is pressed and then one by one (from left to right) the reels need to stop.

One the reels I need to have a value that will be drawn from a record set ( IE 12,000 so in this case reel one would have

REEL Value

1-----0
2-----1
3-----2
4-----0
5-----0
6-----0

I already have the SQL query for this so it is just a matter of adding it to Flash and having it populate the reels with the dynamic data

Then once all the reels have stopped I want another value to appear in the bottom part of the movie.

Many thanks

Willa
0
willa666
Asked:
willa666
  • 2
  • 2
1 Solution
 
MontoyaProcess Improvement MgrCommented:
Im not sure I get your reel concept. Is this like a slot machine?

0
 
willa666Author Commented:
Thats correct it is a slot machine / fruit machine, one armed banit.

0
 
MontoyaProcess Improvement MgrCommented:
well, you threw me off w/ the whole SQL database thing.. we've done a simulation like that, but playing around.
Here's how we did it..

We had pics of the fruits.

We created an array with the different fruits

fruits=["cherry.jpg","bar.jpg","banana.jpg"];

we chose a random number in our code...

then we set intervals of 5 seconds for the beggining spin
and then every two seconds there after we would reveal each fruit, which was a slice of the fruits array. (array.slice(randomnum));

One thing we did was simulate the spin of the reels with a little photshop and some blurred, runny images... (yeah, we kinda cheated).

I thought I had the code with me... but I dont. We can reconstruct, if necessary. However, I have a feeling you're doing something entirely different.
0
 
willa666Author Commented:
Well the concept is similer!

I want to be able to feeed in two value to the page from a a sql database. the two values are value one which will be a number between 0- 999999 and the second value which will be a number between 0-9999.

i want the first value to appear on the reels and then the second value to appear in the prise bin.

What you have done sounds lke it is a step in the right dirrection! do you still have you code? that would be a great help! :)

Have you had exposure to pulling data it to flash from DB's?

Many thanks

Willa
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now