PHP, SQL and FLASH

Shovinus

Hello all
I am currently building a website made with flash and php intereacting with a SQL server.

I have download and installed PHPBB as my forum template and and it is up and running fine

I have also managed to make a flash document and insert it into each post within the php forum so that using flashVars it will generate a profile information display that shows the posters rank and online status. This was more as a test than anything else.

Furthermore me and a friend are creating an avatar generator that will allow you to customise your personal icon (change the colour and style of clothes, hair facial fetures etc) to be used next to each post and on your profile (or you can opt for you own image)

Anyway inorder to create the avatar for each post the flash document will need to pull the generated code (outputted by the avatar generator) from the sql server in order to create the avatar.

This means that I must first get the avatar generator to give the code to the PHP which will then store it on the SQL server. And I must be able to find the information again (presumably withing the users data) and pass it back to the post avatar.

Sorry if that is a bit long winded but I think it should make sense, anyone out there willing to help me?

If anyone can help please give me a pm or reply to this post.

djjjozsi

you edit your post, save the avatar design for the next post (you have then a post_ID ),
you can save all the avatar style in avatars table, with post_id as well ( mysql_insert_id() )
when you list the posts, you can send this ID to the flash:

        [CODE]<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="32" height="32">
          <param name="movie" value="aaa.swf?post_id=XXXXXXXXXXXXXXXXX" />
          <param name="quality" value="high" />
          <embed src="aaa.swf?post_id=XXXXXXXXXXXXXXXXX" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="32" height="32"></embed>
        </object>[/CODE]

An in flash you can load the image with

onFrame (1) {
    loadMovie("avatars/avatar_make.php?post_id="+post_id);
}

avatar_make.php can GET this id number, and load from the database its settings.
Once you create this avatar, lets save in the filesystem with a name, and check if its exists on the very beggining: [post_id]_avatar.png
As a matter a fact, you can save this file after posting the forum with a file name dedicated before.

Hello,
jjozsi.

Shovinus

Ah it appears I have not explained very well.

Basically, you know that on forum profiles you can have for example hobbies catagory, and the user inserts their hobbies?

Well instead of hobbies I want avatar_code (example) and instead of the users changing it themselves, the flash movie will change it to the code outputted from the avatar generator and it will be saved on the sql server.

I know how to retrieve the data it only putting on in the first place. I know nothing about php, only what I have reverse engineered on my own, the code as a whole is still gibberish to me but I understand the principles from programming in other languages and tweaking the template in phpbb.