From 1af31c717bee94b110355c835f62e6a33d359668 Mon Sep 17 00:00:00 2001 From: jesusalva Date: Fri, 9 Mar 2018 06:53:58 -0300 Subject: Update Michel --- npc/003-1/michel.txt | 35 ++++++++++++++++++++++++++++++++++- 1 file changed, 34 insertions(+), 1 deletion(-) (limited to 'npc/003-1') diff --git a/npc/003-1/michel.txt b/npc/003-1/michel.txt index 350caddef..7bbfaef49 100644 --- a/npc/003-1/michel.txt +++ b/npc/003-1/michel.txt @@ -5,8 +5,8 @@ mesn; mesq l("All hail the ones who proven their worth before the whole Alliance!"); - mes ""; + mes ""; .@nb = query_sql("select name, karma from `char` ORDER BY karma DESC LIMIT 5", .@name$, .@value); mes l("##BHall Of Fame: TOP5##b"); mes("1."+.@name$[0]+" ("+.@value[0]+")"); @@ -14,8 +14,41 @@ mes("3."+.@name$[2]+" ("+.@value[2]+")"); mes("4."+.@name$[3]+" ("+.@value[3]+")"); mes("5."+.@name$[4]+" ("+.@value[4]+")"); + next; + + mes ""; + .@nb = query_sql("select name, zeny from `char` ORDER BY zeny DESC LIMIT 5", .@name$, .@value); + mes l("##BHall Of Fortune: TOP5##b"); + mes("1."+.@name$[0]+" ("+.@value[0]+")"); + mes("2."+.@name$[1]+" ("+.@value[1]+")"); + mes("3."+.@name$[2]+" ("+.@value[2]+")"); + mes("4."+.@name$[3]+" ("+.@value[3]+")"); + mes("5."+.@name$[4]+" ("+.@value[4]+")"); + next; mes ""; + .@nb = query_sql("select name, base_level from `char` ORDER BY base_level DESC LIMIT 5", .@name$, .@value); + mes l("##BHall Of Level: TOP5##b"); + mes("1."+.@name$[0]+" ("+.@value[0]+")"); + mes("2."+.@name$[1]+" ("+.@value[1]+")"); + mes("3."+.@name$[2]+" ("+.@value[2]+")"); + mes("4."+.@name$[3]+" ("+.@value[3]+")"); + mes("5."+.@name$[4]+" ("+.@value[4]+")"); + next; + + + if (!getgmlevel()) close; + mes ""; + .@nb = query_sql("select char_name, command from `atcommandlog` ORDER BY atcommand_id DESC LIMIT 5", .@name$, .@value$); + mes l("##BLatest GM Commands##b"); + mes("1."+.@name$[0]+" ("+.@value$[0]+")"); + mes("2."+.@name$[1]+" ("+.@value$[1]+")"); + mes("3."+.@name$[2]+" ("+.@value$[2]+")"); + mes("4."+.@name$[3]+" ("+.@value$[3]+")"); + mes("5."+.@name$[4]+" ("+.@value$[4]+")"); + next; + + if (getgmlevel() < 99) close; if (getgmlevel()) mes "##BGM Information##b"; if (getgmlevel()) mes "We are currently relying in Karma to generate this Hall Of Fame."; if (getgmlevel()) mes ""; -- cgit v1.2.3-60-g2f50