Saving and reading items from mysql

[pepper82]

Hi all,
does andybody know how to store player's tool or inventory in a mysql table and later give it to him again?
I know the mysql part, but I have no clue about how to save / restore the item in a mysql table.

 

[AsuDev]

Serialize the item into a string and store it that way. When you retrieve, you can de-serialize the string back into an item. You can do this pretty simply with skript-json.

Example code (Serializing a single item):

function serializeItem(i: item) :: string:
    add {_i} to {_items::*}
    return {_items::*}'s serialized json form

function deserializeItem(s: string) :: item:
    map json {_s} to {_items::*}
    return {_items::1}

Example code 2 (Serializing a player inventory):

function serializeInventory(inventory: inventory) :: String:
    set {_size} to {_inventory}'s amount of rows * 9
    set {_c} to 0
    loop {_size} times:
        add slot {_c} of {_inventory} to {_items::*}
        add 1 to {_c}
    if "%{_inventory}%" is not "inventory of <none>":
        loop 5 times:
            set {_i} to slot {_c} of {_inventory}
            if "%{_i}%" is "<none>":
                add air to {_items::*}
            else:
                add slot {_c} of {_inventory} to {_items::*}
            add 1 to {_c}
            delete {_i}
    return {_items::*}'s serialized json form
 
function deserializedInventory(inventory: inventory, json: string, includeArmor: boolean):
    map json {_json} to {_items::*}
    set {_c} to 1
    loop ({_inventory}'s amount of rows * 9) times:
        set slot {_c}-1 of {_inventory} to {_items::%{_c}%}
        add 1 to {_c}
    if "%{_inventory}%" is not "inventory of <none>":
        if {_includeArmor} is true:
            loop 5 times:
                set slot {_c}-1 of {_inventory} to {_items::%{_c}%}
                add 1 to {_c}

 

[pepper82]

Thanks for the reply. But is there any way without having to install another skript addon?

 

[AsuDev]

Thanks for the reply. But is there any way without having to install another skript addon?

I don't know of any way other than having an addon. If you use skript-mirror you can do it too.