Remove Storage TFS 1.5 downgrade 8.6

[Azerty]

Good morning, I put this line to remove the storage when the player goes through the portal, but when the player resets(ctrl+g) the storage it comes back. Can someone help me?

db.query(string.format("DELETE FROM `player_storage` WHERE `key` = 123456;"))

 

[Ramon Bernardo]

Try

player:setStorageValue(storageId, value)

 

[Azerty]

Try

player:setStorageValue(storageId, value)

How?

    local destination4 = Position(33221, 31923, 7)
    if isInArray({9715}, item.actionid) and player:getStorageValue(6395643) == 1 then
        player:teleportTo(destination4)
        destination4:sendMagicEffect(CONST_ME_FIREAREA)
        db.query(string.format("DELETE FROM `player_storage` WHERE `key` = 6395643;"))

 

[dami1310]

Set the storage to value -1 when going through portal.
By reset you mean relog? If so then make an onLogin script to set another value.

 

[Sarah Wesker]

How?

    local destination4 = Position(33221, 31923, 7)
    if isInArray({9715}, item.actionid) and player:getStorageValue(6395643) == 1 then
        player:teleportTo(destination4)
        destination4:sendMagicEffect(CONST_ME_FIREAREA)
        db.query(string.format("DELETE FROM `player_storage` WHERE `key` = 6395643;"))

replace db.query(string.format("DELETE FROM player_storage WHERE key = 6395643;")) with player:setStorageValue(6395643, -1)
If you want to see the changes reflected in the database you might want to try using player:save()

 

[Azerty]

If you want to see the changes reflected in the database you might want to try using player:save()

replace db.query(string.format("DELETE FROM player_storage WHERE key = 6395643;")) with player:setStorageValue(6395643, -1)

i tried it this way but the script is recognizing as the player is with a storage value of 1

 

[Sarah Wesker]

i tried it this way but the script is recognizing as the player is with a storage value of 1

no matter what value you have stored, if you set it to -1 this value will be removed and not saved to the database when the player is saved.

 

[Azerty]

no matter what value you have stored, if you set it to -1 this value will be removed and not saved to the database when the player is saved.

Thank u! apparently worked. Thx!!!!

 

[Ramon Bernardo]

You cannot change the value in the database unless the player is offline. Because the server that has the real data. When the player logs out, the db is overwritten by server. So it is necessary to use player:setStorageValue()