deleting storages

[Scooty]

hi, im looking for script(globalevent)

at 00:00(midnight)

removes storage 2112 from all players.

Can someone help me?

 

[tosuxo]

why not just use a globalstorage instead of having every player have an individual storage and just change that at midnight?

 

[Dominik ms]

function onThink(interval, lastExecution, thinkInterval)
	local key = db.getResult("SELECT `key` FROM `player_storage`;")
	if(key:getID() ~= -1) then
		for i=1, key:getRows() do
			db.executeQuery("DELETE FROM `player_storage` WHERE `key` = 1005;")
		end
		key:free()
	end
	return true
end

<globalevent name="timer_example" time="21:35" event="script" value="my_script.lua"/>

 

[tosuxo]

function onThink(interval, lastExecution, thinkInterval)
	local key = db.getResult("SELECT `key` FROM `player_storage`;")
	if(key:getID() ~= -1) then
		for i=1, key:getRows() do
			db.executeQuery("DELETE FROM `player_storage` WHERE `key` = 1005;")
		end
		key:free()
	end
	return true
end

<globalevent name="timer_example" time="21:35" event="script" value="my_script.lua"/>

or that, except 00:00 instead of 21:35

 

[Dominik ms]

oh... are you sure?? ^^

 

[Santi]

Why in earth would you get results and then make loops and stuff, I find it innecessary?
Just make a damn query

function onThink(interval ,lastExecution)
db.executeQuery("DELETE FROM `player_storage` WHERE `key` = 2112 AND `value` > 0;")
return true
end

 

[Cykotitan]

If a player is online, he will get that storage again when he logs out.

function onThink()
	for _, cid in ipairs(getPlayersOnline()) do
		doCreatureSetStorage(cid, 2112)
	end
	db.executeQuery('DELETE FROM player_storage WHERE `key`=2112')
	return true
end

 

[Santi]

If a player is online, he will get that storage again when he logs out.

And in the other guys not?