Hello Paul,
Making good use of a que would be required for writing to the file
without errors, so a database is the best and easiest way; as well, for
high scores, you might want to use a public private key system for
preventing xss exploits, as anyone that knows how to intercept and edit
the get or post data will be able to screw with the request to the
server, and you could end up with a hundred people having the best score
that the column in the DB will allow.
Take care,
Anthony
Glen Pike wrote:
Not working for Cornwall County Council by any chance??? :)
Paul Steven wrote:
Thanks Glen and Ian
Yes I am currently using a mysql database while the high scores are
hosted
on my site. The game is for a rather large organisation so it is not the
easiest task in the world getting a database set up at their end. The
mention of flash alone was enough to cause major panic so you can
imagine
the fear when I mentioned the need to upload php files to their server:)
Cheers
Paul
-----Original Message-----
From: flashcoders-boun...@chattyfig.figleaf.com
[mailto:flashcoders-boun...@chattyfig.figleaf.com] On Behalf Of Glen
Pike
Sent: 22 April 2009 12:15
To: Flash Coders List
Subject: Re: [Flashcoders] Feasibility of xml file for high score data
storage
I am guessing that any server side code to update the XML file will
rely on the server to "lock" files, etc.
Databases are often optimised to allow for multiple "clients" to
update, but most file based commands will lock the file preventing
access by other "clients" so if your code throws a wobbly rather than
waiting, that could be a problem...
Saying that, you could look at using SQLLite for example - this uses
a file based database, but your SQLLite "engine" will handle all of
the access - a lot of PHP installations come with this nowadays and
ASP code also uses ADOBC to connect to Access database files so you
will have a similar system.
The upshot is that using a server side database engine will make life
easier because they will deal with problems like concurrent
connections for you :)
Glen
Paul Steven wrote:
I was considering using an xml file to store high score data for a
game.
It
is quite possible that this game will have a significant amount of
traffic
(certainly in the first few days after launch) and I am now
wondering if
an
xml file would be suitable. I am not sure what happens in the scenario
where
multiple players want to update the highscore at the same time -
they will
all need to write to the file. I assume this is the same scenario
with a
database but think perhaps updating a database is more efficient.
Anyone care to offer any insight into whether an xml file would be
suitable
or not?
Thanks
Paul
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
