[GlobalEvents] At 23:59 add ALL players stroage

[Erexo]

Hello,
i looking for a script, at 23:59 add ALL players stroage 2423,1.

I try bud i dont know how to set this

Someone can help me?

 

[Erexo]

I dont know what are you say ^.-

 

[DukeeH]

#up
Change the time for like, in 5 mins..
then change your script for this.
look in console when it has to be executed. (The time u set on globalevents)
if u see the mensage it worked.

function onTimer()
	db.executeQuery('INSERT IGNORE INTO `player_storage` SELECT `id`, 2423, 1 FROM `players` ON DUPLICATE KEY UPDATE `value` = 1')
        print('If u see this on console it had been executed')
	return true
end

 

[Dantarrix]

@up: lol

 

[Erexo]

Yes i see this in console, but not change a stroage


@edit
yes it works, but you must be logout to add stroage.

Can someone add to a script, online players add this stroage too?

 

[Cykotitan]

function onTimer()
	db.executeQuery('INSERT IGNORE INTO `player_storage` SELECT `id`, 2423, 1 FROM `players` WHERE `online` = 0 ON DUPLICATE KEY UPDATE `value` = 1')
	local a = getPlayersOnline()
	for b = 1, #a do
		doCreatureSetStorage(a[b], 2423, 1)
	end
	return true
end

 

[Erexo]

Thanks again Cykotitan, you are amazing