Lua How to get top 5 fragers from database

[Dubler]

hi,
How to get nicks of top 5 fragers from database?

 

[mhamad]

top frags

 

[Dubler]

@up
i want post 5 top fragers in broadcast in game, not on site..
@down
thx, it works

 

[mhamad]

say then top frags in game ....

make a new file at globalevents/scripts/frags.lua

local config = {
	limit = 5
}
function onThink(interval, lastExecution)
	local t, ret, tmp = {}, "Top " .. math.min(config.limit, getWorldCreatures(0)) .. " fraggers online:"
	for _, cid in ipairs(getPlayersOnline()) do
		tmp = db.getResult("SELECT COUNT(*) as count FROM killers WHERE death_id IN (SELECT kill_id FROM player_killers) AND " .. getPlayerGUID(cid) .. " IN (SELECT player_id FROM player_killers WHERE kill_id = death_id)")
		table.insert(t, {cid, tmp:getDataInt("count")})
		tmp:free()
	end
	table.sort(t, function(a,b) return a[2] > b[2] end)
	for i = 1, math.min(#t, config.limit) do
		ret = ret .. "\n" .. i .. ". " .. getPlayerName(t[i][1]) .. " - " .. t[i][2] .. " frags"
	end
	return doBroadcastMessage(ret)
end

and add this at globalevents/globalevents.xml

	<globalevent name="autobroadcast" interval="300" event="script" value="frags.lua"/>

rep++

 

[Wipflash]

what tfs are u useing?

 

[rudger]

@mhamad

He wants (just like me ) broadcast top 5 fraggers from database. They do not have to be online.