Communicating Information from MMF2 and SQL?

[Sparky]

I am looking to develop an action platform passed game that will interact with an SQL server. It should allow the game to download and upload information such as statistics and score that affect the users account on my website.

I’ve done a few searches through the forums here and I found some relevant information. It seems that I can interact with my server by calling a PHP script (using the active browser?) – so I could send information that way – example “example.php?score=xxx” and it would record the score from the game.

My question becomes – How I can I retrieve data from my website and work it in to the application. More specifically taking the value and assigning it to say a counter or an array. I don’t believe using a URL would work unless I had the php script redirect it self to include the requested value in the address string.

I also wondered if it is possible to use SQL connectivity through an extension instead? Or some way to do it while using the SWF exporter?

My dream result would to be able to communicate with the server using an exported SWF.

I am currently using the 30 day demo until I can assess if this product can meet what I need.

[turtle]

Ok I will try to answer this...

For web base swf, you may use the 'Get Object' to pass and return values to a web page like php or asp.net

Calling it like "example.php?score=xxx" passing the parameter while assigning the return value of "example.php?score=xxx" to a variable in MMF2 makes it available for processing. Hmm.. I might not be clear but lets say calling "example.php?score=xxx" returns "ok" as the result in the php script, this simply means you get "ok" as the data returned.

For a simple demo, just try to use the Get object on "www.google.com" and assigning the results to a text box, you will get the html codes of the google page.

Now there is also an "SQL Server" extention by Andre Guerreiro which lets you directly connects to the SQL server and lets you pass in SQL queries to work with. But that only works with the normal app creation and not the swf.

The trick is to use the Lacewing extention to build the client swf and talks to a Lacewing server built by MMF2 app. The bad news is you can't run this on a normal web hosting because you need to run the Lacewing Server on the server. You will need a Server Co-Location or Virtual private server (VPS) to host the Lacewing server.

[turtle]

If you are using Lacewing in MMF SWF it's like using SmartFoxServer in Flash-AS3. You will need a SWF client that talks to a Lacewing server. Then in the lacewing server, you can perform your SQL statements via the SQL Server object. This is very useful for realtime games like in Dofus but you will need a host that lets you run the Lacewing Server.

You cannot use the SQL Server object in the SWF.

Using the Get object will however enable you to use just about any web hosting services which supports scripting (php, asp...) but then you won't get a true realtime communication. It's usually one way... the client asking/putting info while the server provides/stores... .... the server can never push stuffs to client by itself wihtout a client's request. Well, it worked well for Farmville, it shouldn't be any problem. You can read about it here -> http://www.slideshare.net/amittmahajan/building-big-social-games

[byo]

Hi, guys.

I'll wonder if it's possible to have the SQL Server object work in that kind of way. I will take a look at the new tools and SDK to see what are the limitations of converting objects like that.

Exporting to a format like SWF must have its limits if I'm not mistaken. I'll keep you guys updated.

Thanks.