summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorjesusalva <cpntb1@ymail.com>2018-03-09 06:53:58 -0300
committerjesusalva <cpntb1@ymail.com>2018-03-09 06:54:27 -0300
commit1af31c717bee94b110355c835f62e6a33d359668 (patch)
treeb39635c71c4e0514f3f11049cff54c5a8ca33719
parent710fd33307050916f1e5ad8dce57360745b4c49b (diff)
downloadserverdata-1af31c717bee94b110355c835f62e6a33d359668.tar.gz
serverdata-1af31c717bee94b110355c835f62e6a33d359668.tar.bz2
serverdata-1af31c717bee94b110355c835f62e6a33d359668.tar.xz
serverdata-1af31c717bee94b110355c835f62e6a33d359668.zip
Update Michel
-rw-r--r--npc/003-1/michel.txt35
1 files changed, 34 insertions, 1 deletions
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 "";