Ideas for MySQL Player Saving

ID:151677
 
Sep 2 2009, 6:40 pm
How would you approach saving inventories?

Storing items that have variables that change from item to item.
Sep 3 2009, 12:35 am
The easiest method I can think of is using the BYOND Savefile format. You can turn a savefile into a text file, encrypt that, and store it in the database.
Sep 3 2009, 7:34 am
A persistence layer of sorts. I am due to make a blog post on how you might go about making a rudimentary persistence layer from MySQL, before eventually releasing a more sophisticated library of my own.
Sep 3 2009, 1:16 pm
Like Tiberath said, you could just use the already-existent savefile mechanism. Encryption being optional (maybe preferred), you might do something like this:

proc/get_save_text(mob/m)
    ASSERT(m)
    var/savefile/s = new
    s << m
    return s.ExportText()

After that, you might encrypt the result, and then you can stick it directly into your database. When you go to load, decrypt if it was encrypted and then use ImportText() to load it.
Sep 3 2009, 11:22 pm
Thank you all for the ideas.
Aug 23 2010, 2:02 pm
In response to Stephen001
Stephen001 wrote:
A persistence layer of sorts. I am due to make a blog post on how you might go about making a rudimentary persistence layer from MySQL, before eventually releasing a more sophisticated library of my own.

Did you ever get round to writing this blog/library?
I am aware this is an old post, however, i have recently created an inventory system using only mysql and would love to see others ideas on such a system.
Aug 23 2010, 4:10 pm
In response to Tonyth
I think it's a wonderful idea.
Just sayin'
Aug 24 2010, 1:13 am
In response to DivineTraveller
DivineTraveller wrote:
I think it's a wonderful idea.
Just sayin'

I see Its pretty similar to mine actually.
I load the users contents a bit differently.

Cheers for the ref Traveller.