Load last element data?

[tommymaster]

Hi, is there a function, that loads the element data the player had, before quit? Or how can i save lua tables without using databases?

[Pirulax]

If the resource doesn't get restarted then simply store the result from getAllElementData
And when the player rejoins just reset his/her element data's from the table you saved. 

Edited August 18, 2018 by Pirulax

[tommymaster]

i have to restart it sometimes, if i add a feature, or fix a bug

Edited August 18, 2018 by tommymaster

[Pirulax]

the file functions+JSON

[tommymaster]

is there a way i can save a lua table in mysql?

[keymetaphore]

21 minutes ago, tommymaster said:

is there a way i can save a lua table in mysql?

You can. toJSON and fromJSON will do the trick.

[tommymaster]

how? could you please give me an example?

[keymetaphore]

Sure thing.

 

-- So, first we are going to create a table with any info.
table = { } 
table[1] = "a"

-- Tables cannot be stored to mysql, so we are converting it to JSON

jsonTable = toJSON(table)

-- Now it will be in the format of [ { "1": "a"} ] (something similar, writing by my head)

-- This can be saved in mysql.

-- When you want to use it as a lua table, use fromJSON(json string)

 

[tommymaster]

the lua table is like this {{["item"] = 101, ["amount"] = 1}}

 

would it work the same?

Edited August 18, 2018 by tommymaster

[keymetaphore]

So just use it like in my example, you supply a table to the toJSON(). 

[tommymaster]

and how can i save this to mysql?

[keymetaphore]

Supply the string to the query.

https://dev.mysql.com/doc/

https://wiki.multitheftauto.com/wiki/DbConnect

https://wiki.multitheftauto.com/wiki/DbQuery

[tommymaster]

i already wrote my msql query resource, but what type should the column in the mysql table be?

[Pirulax]

'text' should do the trick.

[tommymaster]

thank you guys! you really helped a lot! you are all awesome!!!!!! 

[Pirulax]

Thanks for those reps m8