psychonaut

local qry = db.query or db.executeQuery

function onThink(interval, lastExecution, thinkInterval)
    setGlobalStorageValue(722504,os.time()) -- Return itens
    local query = db.getResult('SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, `g`.`logo_gfx_name` AS `logo`, COUNT(`g`.`name`) as `frags` FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id` WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0, 6;')
    if query:getID() ~= -1 then
        qry("DELETE FROM most_powerful_guilds WHERE frags > 0")
        while true do
            local g_name = query:getDataString("name")
            local g_frags = query:getDataInt("frags")
            local g_id = query:getDataInt("id")
            qry('INSERT INTO most_powerful_guilds (name, id, frags) VALUES ("'..g_name..'","'..g_id..'","'..g_frags..'")')
            if not query:next() then
                break;
            end
        end
        query:free()
    end
    return true
end