TalkAction New DeathList!

[Critico]

DeathListclean.lua

function onTimer()
local days = 7*24*60*60 -- 7 days
local qry = db.getResult("SELECT `player_id`, `date` FROM `death_list` ORDER BY `date` DESC;")
if(qry:getID() ~= -1) then
repeat
local death_time, id_player = tonumber(qry:getDataInt("date")), qry:getDataInt("player_id")
if death_time < os.time() - days then
db.executeQuery("DELETE FROM `death_list` WHERE `player_id` = "..id_player)
end
until not(qry:next())
qry:free()
end
return true
end

<globalevent name="DeathListClean" time="03:00" event="script" value="DeathListclean.lua"/>

 

[imback1]

DeathListclean.lua

function onTimer()
local days = 7*24*60*60 -- 7 days
local qry = db.getResult("SELECT `player_id`, `date` FROM `death_list` ORDER BY `date` DESC;")
if(qry:getID() ~= -1) then
repeat
local death_time, id_player = tonumber(qry:getDataInt("date")), qry:getDataInt("player_id")
if death_time < os.time() - days then
db.executeQuery("DELETE FROM `death_list` WHERE `player_id` = "..id_player)
end
until not(qry:next())
qry:free()
end
return true
end

<globalevent name="DeathListClean" time="03:00" event="script" value="DeathListclean.lua"/>

Not working?

 

[Joe Rod]

that's for delete the player deaths.

 

[imback1]

that's for delete the player deaths.

I know and i tried it but nothing deleted

 

[Critico]

only delete if the time of death is greater than 7 days

and is onTimer() -