Top Effect

local config = {
    tempo = 5,
    mensagem = {
        texto = "TOP LEVEL",
        efeito = TEXTCOLOR_RED
    },
    globalstr = 5687
}

local topPlayer = getGlobalStorageValue(config.globalstr) > 0 and getGlobalStorageValue(config.globalstr) or 0

function onLogin(cid)
    local query = db.getResult("SELECT `id`, `name`, `level` FROM `players` WHERE `group_id` = 1 ORDER BY `level` DESC LIMIT 1")
    if (query:getID() ~= -1) then
        local pid = query:getDataString("id")
        local name = query:getDataString("name")
        if getPlayerName(cid) == name then
            if topPlayer ~= getPlayerID(cid) then topPlayer = getPlayerID(cid) end
            setGlobalStorageValue(config.globalstr, pid)
            TopEffect(cid)
        end
    end
    registerCreatureEvent(cid, "CheckTop")
    return true
end

function onAdvance(cid, skill, oldlevel, newlevel)
    if skill == 8 then
        local query = db.getResult("SELECT `id`, `name`, `level` FROM `players` WHERE `group_id` < 4 ORDER BY `level` DESC LIMIT 1")
        if (query:getID() ~= -1) then
            local level = tonumber(query:getDataString("level"))
            if level < newlevel and topPlayer ~= getPlayerID(cid) then
                topPlayer = getPlayerID(cid)
                doSaveServer()
                setGlobalStorageValue(config.globalstr, getPlayerID(cid))
                TopEffect(cid)
            end            
        end
    end
    return true
end

function TopEffect(cid)
    if not isPlayer(cid) then return true end
    if topPlayer == getPlayerID(cid) then
        doSendAnimatedText(getCreaturePosition(cid), config.mensagem.texto, config.mensagem.efeito)
        addEvent(TopEffect, config.tempo * 1000, cid)
    end
end

function getPlayerNameById(id)
    local query = db.getResult("SELECT `name` FROM `players` WHERE `id` = " .. db.escapeString(id))
    if query:getID() ~= -1 then
        return query:getDataString("name")
    end
    return 0
end

function getPlayerIdByName(name)
    local query = db.getResult("SELECT `id` FROM `players` WHERE `name` = " .. db.escapeString(name))
    if query:getID() ~= -1 then
        return tonumber(query:getDataString("id"))
    end
    return 0
end

function getPlayerID(cid)
    return getPlayerIdByName(getPlayerName(cid))
end