From 6bfa33bb2d7e01ff351488510d96f14dcde08eb5 Mon Sep 17 00:00:00 2001 From: jesusalva Date: Fri, 23 Feb 2018 13:38:38 -0300 Subject: Michel is so useless at the moment, so now he'll return a Hall Of Fame. Using a statue would be smarter, but I need sprites for that. --- npc/003-1/michel.txt | 12 +++++++++++- npc/003-1/swezanne.txt | 8 -------- 2 files changed, 11 insertions(+), 9 deletions(-) (limited to 'npc/003-1') diff --git a/npc/003-1/michel.txt b/npc/003-1/michel.txt index 1a810b3e2..a4a6c9464 100644 --- a/npc/003-1/michel.txt +++ b/npc/003-1/michel.txt @@ -3,8 +3,18 @@ 003-1,89,109,0 script Michel NPC_BACCHUS,{ + mesn; + mesq l("All hail the ones who proven their worth to the High Council!"); + mes ""; -hello; + .@nb = query_sql("select name, fame from `char` ORDER BY fame DESC LIMIT 5", .@name$, .@fame); + mes l("##BHall Of Fame: TOP5##b"); + mes l("1."+.@name$[0]+"("+.@fame[0]+")"); + mes l("2."+.@name$[1]+"("+.@fame[1]+")"); + mes l("3."+.@name$[2]+"("+.@fame[2]+")"); + mes l("4."+.@name$[3]+"("+.@fame[3]+")"); + mes l("5."+.@name$[4]+"("+.@fame[4]+")"); + close; OnInit: .sex = G_MALE; diff --git a/npc/003-1/swezanne.txt b/npc/003-1/swezanne.txt index 7d1adb984..306056b84 100644 --- a/npc/003-1/swezanne.txt +++ b/npc/003-1/swezanne.txt @@ -27,14 +27,6 @@ L_Heroics: else if (.@d == 6) .@deed$="impressed even the High Council!"; else .@deed$="is awesome like me!"; // Should not happen - /*.@nb = query_sql("select name, fame from `char` ORDER BY fame DESC LIMIT 5", .@name$, .@fame); - mes("Hall Of Fame: TOP5"); - mes("1."+.@name$[0]+"("+.@fame[0]+")"); // Will return a person with the biggest fame value. - mes("2."+.@name$[1]+"("+.@fame[1]+")"); - mes("3."+.@name$[2]+"("+.@fame[2]+")"); - mes("4."+.@name$[3]+"("+.@fame[3]+")"); - mes("5."+.@name$[4]+"("+.@fame[4]+")");*/ - mesq l("I hope to one day be like @@, who @@", $MOST_HEROIC$, .@deed$); close; -- cgit v1.2.3-60-g2f50