CreatureScript%252525252FGlobalEvent%252525252FMoveMent DB CLEANER PARA SQLITE

[karlkalvin 73]

Em Global Events.xml adicione essa tag...

<globalevent name="cleandb" interval="46200" script="dbclean.lua"/>

agora em Globalevents/scripts crie um arquivo chamado.. e adicione isso dentro do arquivo.

dbclean.lua

-- [[> 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 = 5000, time = 15 * 24 * 60 * 60},

[3] = {level = 30000, time = 30 * 24 * 60 * 60},

[4] = {level = 50000, time = 60 * 24 * 60 * 60},

[5] = {level = 150000, 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

Creditos : Leoprotons 90% Por ter Criado

Kalvin Karl 10% Por ter trago para o TK.