[Lua Script] Return the 5 higher values

[StormRusher]

Well i wanna know how to return the 5 players which have the highers storagevalue(1), from online list (getPlayerOnline~~)

Thanks

 

[Cykotitan]

seriously, this is mindfuck

everything would be so much easier if you just stored them in a separate table, but i'm probably wrong and sleepy.

 

[Sync]

You could make a Script to add +1 to the collum TFrags in your DB and then use this script.

local DontShow = {
		"Account Manager",
		"Master Sorcerer",
		"Elder Druid",
		"Royal Paladin",
		"Elite Knight"
	}

function onSay(cid, words, param, channel)
	local players = 1
	local result = db.getResult("SELECT `tfrags`, `name` FROM `players`  WHERE `group_id` = "..players.." ORDER BY `tfrags` DESC, `name` ASC;")

	if (result:getID() ~= -1) then
		str = "# [Total Frags] - Name -\n"
		local i, name = 1, ""
		while TRUE do
		     name = result:getDataString("name")
			if isInArray(DontShow, name) == false then
				str = str .. "\n " .. i .. ". [" .. result:getDataInt("tfrags") .. "] - " .. result:getDataString("name")
				i = i+1
			end
			if not(result:next()) or i > players then
				break
			end
		end
		if str ~= "" then
			doPlayerPopupFYI(cid, str)
		end
	end
	result:free()
	return TRUE
end

 

[StormRusher]

edit~~ already done

Now i only need that the script show the 5 players with the higher tfrags, not only one

thanks a lot

 

[StormRusher]

Bump

 

[StormRusher]

Bump

 

[StormRusher]

**Now i only need that the script show the 5 players with the higher tfrags, not only one

BUMP

 

[StormRusher]

No one can do this for me?
Or it is impossible?

 

[Cykotitan]

it's a mindfuck, hard to make only in Lua

 

[menfes]

Agree, this would be like a twister in your head ^^. Your brain would split in four pieces, don't try. // Sarkasm+truth