one functions updates all storages

[Faraonekkk]

is there any function that update storage id for all online players?
thanks

 

[Tevo]

UPDATE `player_storage` SET `value` = -1 WHERE `key` = 101;

 

[Faraonekkk]

[08/09/2012 21:40:29] [Warning - Event::loadScript] Cannot load script (data/globalevents/scripts/scareds.lua)
[08/09/2012 21:40:29] data/globalevents/scripts/scareds.lua:7: '=' expected near '`'

line 7
UPDATE `player_storage` SET `value` = 1 WHERE `key` = 99971;

 

[Loney]

You need to execute it at the phpMyAdmin at a sql query..

 

[Faraonekkk]

i need to make it line in globalevents how to do it?

 

[Loney]

Hmm, to set all players that storage you need to use the query in PMA. =)

 

[Ratser]

Use this function (paste it at the end of 050-function.lua):

function doCreaturesOnlineSetStorage(key, value)
	for _, pid in ipairs(getPlayersOnline()) do
		doCreatureSetStorage(pid, key, value)
	end

	print("> Storage value for key " .. key .. " set for all players: \"" .. value .. "\".")
	return true
end