opa, beleza ?

cara uma duvida, se eu rodar o script e o player tiver casa ela fica disponivel para compra novamente ou a casa fica bugada ?

ex : look na porta da casa de um player deletado It belongs to house ''. owns this house.

consegue me ajudar com isso ?

Esse scripts funciona no TFS 1.3+?

2 horas atrás, igaa0o disse:

Esse scripts funciona no TFS 1.3+?

acho que algo assim funcionaria.

 

local inactiveMonths = 1
local createdMonths = 1
local protectedAccIdEnd = 20

local function clearInactivePlayers()
    local inactiveTimestamp = os.time() - (86400 * (inactiveMonths * 30))
    local totalClear = 0

    local fromClause = "`players` WHERE `account_id` > " .. protectedAccIdEnd .. " AND lastlogin <= " .. inactiveTimestamp

    local result = db.storeQuery("SELECT COUNT(*) as num_inativos FROM " .. fromClause)
    if result then
        totalClear = result:getNumber("num_inativos")
        if totalClear > 0 then
            db.query("DELETE FROM " .. fromClause)
        end
        result:free()
    end

    return totalClear
end

local function clearEmptyAccounts()
    local totalClear = 0
    local createdTimestamp = os.time() - (86400 * (createdMonths * 30))

    local fromClause = "`accounts` ACCS WHERE `id` > " .. protectedAccIdEnd .. " AND `creation` <= " .. createdTimestamp .. " AND (SELECT COUNT(*) from `players` WHERE `account_id` = ACCS.`id`) > 0"

    local result = db.storeQuery("SELECT COUNT(*) as num_inativas FROM " .. fromClause)
    if result then
        totalClear = result:getNumber("num_inativas")
        if totalClear > 0 then
            db.query("DELETE ACCS FROM " .. fromClause)
        end
        result:free()
    end

    return totalClear
end

function onStartup()
    print('>> ' .. clearInactivePlayers() .. " players inativos deletados.")
    print('>> ' .. clearEmptyAccounts() .. " contas vazias deletadas.")
end