[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?

 

[Dantarrix]

I dont remember if it's a creaturescript or a globalevent.....
But search in VIP's system, in them they do the saame.....

 

[Erexo]

in creaturescript?

i can set in globalevents this:
<globalevent name="timer_example" time="23:59" event="script" value="daily.lua"/>

but i dont know what enter in a script

 

[DukeeH]

        <globalevent name="StorageAdd" time="23:59" event="script" value="storageadd.lua"/>

function onTimer()
                 	db.executeQuery("UPDATE player_storage SET VALUE = 1 WHERE KEY = 2423;")
        return true
end

#Should Work Now. (all players)

 

[cbrm]

only online players or ALL players ?

 

[DukeeH]

sorry, my fault. read wrong.
making
edit later.

edit-
how can i add something for who isn't online?
with sql query it can be done, but i don't know how to do it.

 

[cbrm]

i was asking it to OP xP

 

[DukeeH]

who's OP?

 

[Bogart]

who's OP?

Original Poster

 

[cbrm]

op = original poster, thread starter

UPDATE `player_storage` SET `value` = 1 WHERE `key` = 2423;

 

[DukeeH]

hmm, thanks.

edited my post with CyberM line.

 

[Erexo]

To all players,
not only online players

 

[Cykotitan]

INSERT IGNORE INTO `player_storage`
SELECT `id`, 2423, 1 FROM `players`
ON DUPLICATE KEY UPDATE `value` = 1

 

[Erexo]

hmm,
some kind of this?

function onTimer()
INSERT IGNORE INTO `player_storage`
SELECT `id`, 2423, 1 FROM `players`
ON DUPLICATE KEY UPDATE `value` = 1
        return true
end

 

[Cykotitan]

wrap db.executeQuery(' ... ') around it

 

[Erexo]

function onTimer()
db.executeQuery(' ... ')
INSERT IGNORE INTO `player_storage`
SELECT `id`, 2423, 1 FROM `players`
ON DUPLICATE KEY UPDATE `value` = 1
db.executeQuery(' ... ')
        return true
end

? :F

 

[Cykotitan]

...

function onTimer()
	db.executeQuery('INSERT IGNORE INTO `player_storage` SELECT `id`, 2423, 1 FROM `players` ON DUPLICATE KEY UPDATE `value` = 1')
	return true
end

 

[Erexo]

hahaha,
sorry my false ^^
I test it.

Rep+ for you ^^

 

[Erexo]

Its not working, idk why

(When i have 2423,2 , at 23:59 must change to 2423,1 or delete this stroage).

 

[Cykotitan]

it works. add a print('xd') to see if it's getting executed (change time for now)