[FMX] Fridge poetry + MySQL

programming flash
1

I’m about to create a flash movie were you can simulate “fridge poetry”, nothing tricky here …

What I want to do is to connect to a database to get all the words that you’re supposed to make your poetry of so that you want have to make them all by yourself in flash. Also this would let me easily change the type o words used. I intend to use PHP and MySQL …

So does anyone know if this is possible, that is:

Flash creates Dynamic drag and drop objects from a list that is read from a database.

regards, Olki

2

Hi Olki,
First of all I must say that I have absolutely no idea what
"fridge"poetry is???
However, if I have understood your post correctly, you can achieve what you want with a txt file. If you place your words for the poetry in a text file and then place your dynamic text box in an mc, on the first and only frame you just use loadvariables ( or Load vars if in MX). You could then make the mc’s draggable and droppable so that the user can move the words around to make a poem.
You can add to/subtract from/change the words in the text file to suit yourself.
I have seen an example of this somewhere - but for the life of me I cannot remember where - if I remember I will post for you OK

Cheers

SteveD

3

Thanks for the input!
How do I make the MC duplicate? Since I’ll have alot of words in my database or textfile I would like to make each word into a singel MC.

Here are two links that’ll give you an idea of what “fridge poetry” is (In swedish, but you’ll get the point …):
http://www.kylskapspoesi.com/interaktiv/
http://www.forfattarcentrum.se/skriv/kylskapspoesi.html

best regards, Olki

4

Hi,
I found ( by accident) the example I quoted above if you go here
Which is over at www.actionscript.org
If the link doesnt work, goto the site and do a search for frdge magnet.
The only difference between the example and what you are trying to do, is that the user is allowed to type in his/her own words

Hope it halps

SteveD

5

Thanks a lot!

Now I just have to alter it so it will read from a database/textfile instead of the user typing the diffrent words.

thanks again, Olki

6

I’ve now manage to alter it so it fits me. What I would need to know is:

When all the words are loaded into the scene I want the one that I’m dragging beeing the topmost. I’ve read all the threads about swapDepths but want work perfectly for me. So can somone please help me?

(I’ve posted a zip with all the source files)

regards, Olki

7

Hi olki,
This is an area that I am not too certain about, but as far as I can recall, you will need to load your magnet mc’s into empty clips in order to swapDepths.
I know you say that you have looked at the tutes etc, but if you make another trip towww.actionscript.org you will find in tutorials > intermediate > tute9 a swapDepths tute, at the end of the tute,( to save you ploughing thru’ it) is a source file that expalins what you are tryng to achieve.
Soryy I cannot be of more help than that

SteveD

8

Thanks for your effort, unfortunately it didn’t solve my case.

regards, Olki