someone could make this top be for time played

[pelimpolem 9]

someone could make this top be for time played

quest ranking begin
state start begin
  when 9003.chat."Ranking" begin
   local rangliste = mysql_query("SELECT player.name, player.level FROM player.player WHERE player.name NOT LIKE '[%]%' ORDER BY player.level DESC, player.exp DESC","root","passnavicat","player","ipnavicat")
   say_title("Top 10")
   say("#:   Nombre     Nivel ")
   say_reward("Top 1: "..rangliste.name[1].." "..rangliste.level[1].." ")
   say_title("Top 2: "..rangliste.name[2].." "..rangliste.level[2].." ")
   say("Top 3: "..rangliste.name[3].." "..rangliste.level[3].." ")
   say("Top 4: "..rangliste.name[4].." "..rangliste.level[4].." ")
   say("Top 5: "..rangliste.name[5].." "..rangliste.level[5].." ")
   say("Top 6: "..rangliste.name[6].." "..rangliste.level[6].." ")
   say("Top 7: "..rangliste.name[7].." "..rangliste.level[7].." ")
   say("Top 8: "..rangliste.name[8].." "..rangliste.level[8].." ")
   say("Top 9: "..rangliste.name[9].." "..rangliste.level[9].." ")
   say("Top 10: "..rangliste.name[10].." "..rangliste.level[10].." ")
   local s = select("Salir")
   if s == 1 then
    return
   end
  end
end
end

 

 

plis help

[tierrilopes 449]

ORDER BY player.level DESC  >>  ORDER BY player.playtime DESC

[Syreldar 1838]

quest ranking begin
	state start begin
		when 9003.chat."Ranking" begin
			local limit = 10;
			local rangliste = mysql_query(string.format("SELECT name, level FROM player.player WHERE name NOT LIKE '[%]%' ORDER BY player.playtime DESC, player.exp DESC LIMIT %d", "root", "passnavicat", "player", "ipnavicat", limit));
			say_title(string.format("Top %d players:[ENTER]", limit))
			say("#:   Nombre     Nivel ")
			for i = 1, limit do
				say_reward(string.format("%d. %s (Lv. %d)", i, rangliste.name[i], rangliste.level[i]))
			end -- for
		end -- when
	end -- state
end -- quest

 

I wonder if he would have c/ped the same line 100 times, if that ranking had been top 100 instead of 10.