what I did , instead of running a mysql query was this:
1. save game icon to desktop
2. save crown icon to desktop
3. upload simon.swf to your games folder
4. go to the arcade admin panel and click on add game and enter the following information :
Game Identifier : simon
Game Title : Simon Says
Game Description : * describe it in your own words *
- browse to the champion icon on desktop
Champion text for Simon Says : Simon Says Champion
Champion text color : #FF0000
- browse to game icon on desktop
Filename : simon.swf
Game Hash Offset : 5
Score Return Variable : $simonscore
and then HTML Code For Game :
PHP Code:
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="400" height="500">
<param name="movie" value="$vpa_gameurl?location=$vpa_bburl&gamename=$game&gamehash=$gamehash&s=$session[sessionhash]">
<param name=loop value=false>
<param name=menu value=false>
<param name=quality value=high>
<param name=bgcolor value=#000000>
<embed src="$vpa_gameurl" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="400" height="500">
</embed>
</object>
and click add
be sure you enable the game and enable the champion icon and champion text if you're wanting to use that