Reset storagevalue

[freaked1]

Hello! Is there anyone that can make or know of a script that removes certain storageIDs on players after serverrestart so that quests that checks that storage ID gets reset for the player?

EDIT: Using TFS 1.1

Thanks in advance.

 

[Sharkot]

Hello! Is there anyone that can make or know of a script that removes certain storageIDs on players after serverrestart so that quests that checks that storage ID gets reset for the player?

EDIT: Using TFS 1.1

Thanks in advance.

You could do this when the server starts up send a query to the database and so the server will handle all of the entries rather than doing it when each player logs in.

local storages = {
    -- place the storage values here
}

for i = 1, #storages do
    db.query("UPDATE `player_storage` SET `value` = 0 WHERE `storage` = " .. storages[i] .. ";")
end

While placing it somewhere in startup.lua forgottenserver/data/globalevents/scripts/startup.lua

 

[Marcus]

You could do this when the server starts up send a query to the database and so the server will handle all of the entries rather than doing it when each player logs in.

local storages = {
    -- place the storage values here
}

for i = 1, #storages do
    db.query("UPDATE `player_storage` SET `value` = 0 WHERE `storage` = " .. storages[i] .. ";")
end

While placing it somewhere in startup.lua forgottenserver/data/globalevents/scripts/startup.lua

Update to 0 doesn't mean the storage is gone.
Many storages uses 0 as something.
better use DELETE FROM.

 

[Sharkot]

Update to 0 doesn't mean the storage is gone.
Many storages uses 0 as something.
better use DELETE FROM.

So then change it to -1

 

[Marcus]

So then change it to -1

why not clean the database while doing this? than keep all old unnecessary stuffs.

That code is a chance to clean up a huge amount of storages from players that maybe doesn't even play.
Take the chance if chance is given

 

[Sharkot]

why not clean the database while doing this? than keep all old unnecessary stuffs.

That code is a chance to clean up a huge amount of storages from players that maybe doesn't even play.
Take the chance if chance is given

Because he asked to reset the storages not delete them

 

[Marcus]

Hello! Is there anyone that can make or know of a script that removes certain storageIDs on players after serverrestart so that quests that checks that storage ID gets reset for the player?

EDIT: Using TFS 1.1

Thanks in advance.

Because he asked to reset the storages not delete them

 

[Sharkot]

Yea I missed that part apparently please by all means update the code

 

[freaked1]

Thanks guys! You both really helped out here. I'm "new" and trying to learn and this really helped show the way
Using this now in startup.lua

    local storages = {
        -- place the storage values here
        25000
    }

    for i = 1, #storages do
        db.query("DELETE FROM `player_storage` WHERE `key` = " .. storages[i] .. ";")
    end

EDIT: i

 

[Sharkot]

Thanks guys! You both really helped out here. I'm "new" and trying to learn and this really helped show the way
Using this now in startup.lua

    local storages = {
        -- place the storage values here
        25000
    }

    for i = 1, #storages do
        db.query("DELETE FROM `player_storage` WHERE `key` = " .. storages .. ";")
    end

You forgot the i this should be

db.query("DELETE FROM `player_storage` WHERE `key` = " .. storages[i] .. ";")

 

[freaked1]

You forgot the i this should be

db.query("DELETE FROM `player_storage` WHERE `key` = " .. storages[i] .. ";")

Yeah for some reason it didn't show when I posted it here, might be beacuse I fkd up the CODE tag at first and edited it It works fine, I have the correct with storages in my starup.lua

Ah, it makes the text like this, that is why