Spoiler

[2:19:02.949] [Error - GlobalEvent Interface]
[2:19:02.956] In a timer event called from:
[2:19:02.959] data/globalevents/scripts/doCheckHouses.lua:onStartup
[2:19:02.962] Description:
[2:19:02.964] data/globalevents/scripts/doCheckHouses.lua:18: attempt to call field 'getNumber' (a nil value)
[2:19:02.971] stack traceback:
[2:19:02.974]   data/globalevents/scripts/doCheckHouses.lua:18: in function <data/globalevents/scripts/doCheckHouses.lua:3>

script

Spoiler

-- <globalevent type="startup" name="doCheckHouses" script="doCheckHouses.lua" />

local function doCheckHouses()

    local dias = 7
    local tempo = os.time() - (dias * 24 * 60 * 60)
    local registros = db.storeQuery("SELECT `houses`.`owner`, `houses`.`id` FROM `houses`,`players` WHERE `houses`.`owner` != 0 AND `houses`.`owner` = `players`.`id` AND `players`.`lastlogin` <= " .. tempo .. ";")
    
    if registros ~= false then
    
        local count = 0
        
        print('house leave code')
        
        repeat
            count = count + 1
            
            local owner = result.getNumber(registros, "owner")
            local houseId = result.getNumber(registros, "id")
            local house = House(houseId)
            
            if house and (owner > 0) then
                print(house:getName())
                house:setOwnerGuid(0)
            end
            
        until not result.next(registros)
        
        print('house leave house count:' .. count)
        
        result.free(registros)
    end
end

function onStartup()
    addEvent(doCheckHouses, 60 * 1000)
    
    return true
end

 

esse script é para tfs 1.1+

1 hora atrás, Vodkart disse:

esse script é para tfs 1.1+

tem como deixar 0.4 pra min pfv?

4 horas atrás, ZikaLord disse:

tem como deixar 0.4 pra min pfv?

segue o script em 0.4

 

Spoiler

function onThink(interval, lastExecution)

local days = 7*24*60*60

if tostring(os.date("%X")):sub(1, 5) == "04:00" then

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

end

return true

end

creditos: vodkart