Online Database

[TotalProjects]

Thank you very much for your help. I've already revealed the right HTTP request. It appears that an empty line should have been sent...
It now looks not so bad at all, but I definitely agree with previous posts, that it would have been much easier if MMF & Click Team had turned the online database interaction with MMF into a much more user-friendly simplified process, as it definitely adds powerful attributes to development needs today.
I really hope that Vitalize 4 will support this interaction as well.

[Corentin]

I'd be glad if we had a better way to communicate with online databases, but I'm not sure this is really possible. As said above, most of the time, access to databases are only allowed from localhost, so this wouldn't help many users (only users running their own servers I guess). Since Vitalize is client-side, I don't think we'll have a better tool...

[Jeff]

Yes the main problem is with the servers not with MMF
So unless a custom server/extension combo comes along we are stuck with php in the middle for a little bit.

But we are looking for solutions it just won't be very quick and it might require some sort of service that won't run on other servers.

[Nifflas]

It's extremely easy to do this with the live receiver <-> php <-> sql database combo.

I propose that somebody create a kit that contains:

* An example application.
* A flexible and simple PHP Script that can be configured through a few simple variables. If it will need to deal with a large amount of data, sql communication is the way to go - otherwise it could store the scores in a text file on the server (it just needs to remove low scores as new higher ones appear).
* An installation guide.

This could be made extremely simple and user friendly in my opinion.

To be honest, just forget about your application communicating directly with the sql server, unless you can find a way to customize the sql server to only accept data that comes with an md5 encoded validation string that confirms that the game submitted the data, and not an user who connects directly to the database. That is probably harder to do than learning to write a php script anyway.