-- [[> Automated Database Cleanup 1.1 //By Cybermaster <]] -- -- [[> Function getDBPlayersCount() by Elf <]] --
function getDBPlayersCount() local result = db.getResult("SELECT COUNT(`id`) as `count` FROM `players`;") local tmp = result:getDataInt("count") result:free() return tmp end
function onStartup() local DB_BEFORE = getDBPlayersCount()
--In each table, players with below specified level, and days of inactivity will be deleted from db on server startup local cleanup = { [1] = {level = 11, time = 5 * 24 * 60 * 60}, [2] = {level = 50, time = 15 * 24 * 60 * 60}, [3] = {level = 100, time = 30 * 24 * 60 * 60}, [4] = {level = 200, time = 60 * 24 * 60 * 60}, [5] = {level = 300, time = 90 * 24 * 60 * 60} }
for i = 1, #cleanup do db.executeQuery("DELETE FROM `players` WHERE `level` < ".. cleanup.level .." AND `id` > 6 AND `group_id` < 2 AND `lastlogin` < UNIX_TIMESTAMP() - ".. cleanup.time ..";") end
local DB_NOW = DB_BEFORE - getDBPlayersCount() if DB_NOW > 0 then local text = ">> [DBCLEANUP] "..DB_NOW.." inactive players have been deleted from database." print("" .. text .. "") local file = io.open("data/logs/db_cleanup.txt", "a") file:write("\n[".. os.date("%d %B %Y %X ", os.time()) .."] "..text.."") file:close() end return true end
Pergunta
warriorfrog 3
Achei um DB Cleanner pra SQILE, mas ta dando erro ao iniciar, preciso muito desse script, alguem sabe como arrumar?
Erro:
Script:
Link para o comentário
https://xtibia.com/forum/topic/221628-ajuda-erro-db-cleanner-sqile/Compartilhar em outros sites
22 respostass a esta questão
Posts Recomendados