pelimpolem 9 Posted January 2, 2018 Share Posted January 2, 2018 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 Link to comment Share on other sites More sharing options...
Premium tierrilopes 452 Posted January 2, 2018 Premium Share Posted January 2, 2018 ORDER BY player.level DESC >> ORDER BY player.playtime DESC 1 Link to comment Share on other sites More sharing options...
Premium Syreldar 1875 Posted January 2, 2018 Premium Share Posted January 2, 2018 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. "Nothing's free in this life. Ignorant people have an obligation to make up for their ignorance by paying those who help them. Either you got the brains or cash, if you lack both you're useless." Syreldar Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now