GlobalEvent House Clean

[Critico]

Description: Is to delete houses from inactive players, meaning that the player does not log in "X" days lose your house!

houseclean.lua

function onTimer()
local days = 15*24*60*60
doSaveServer()
local query = db.getResult("SELECT `owner`,`id` FROM `houses`;")
if (query:getID() ~= -1) then
while true do
local own,houseid = query:getDataInt("owner"),query:getDataInt("id")
local qry = db.getResult("SELECT `lastlogin`  FROM `players` WHERE `id` = "..own)
if(qry:getID() ~= -1) then
last = tonumber(qry:getDataInt("lastlogin"))
if last < os.time() - days then
setHouseOwner(houseid, NO_OWNER_PHRASE,true)
end
end
if not(query:next()) then
break
end
end
query:free()
end
return true
end

globalevents.xml

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

the tag is to run the script at 3am, if you want to change, change this part::

time="03:00"

to configure the days that the player who did not log in "X" days is here:

local days = 15*24*60*60

 

[xLosT]

thx
+REP

 

[Sir Juninho]

thank you Critico!

rep+

 

[tetra20]

NICE gonna use it Repped

 

[Sir Gabriiel]

And if Guildhall how it works?

 

[zygus0000]

Thx for script i need this to my server but i make my own map