// TMW-2 Script
// Author:
// Jesusalva
// Description:
// Leaderboards + GM Command Log
function script HallOfFame {
// Moved to event statues
return;
mes "";
.@nb = query_sql("select name, karma from `char` WHERE `guild_id`!=1 ORDER BY karma DESC LIMIT 10", .@name$, .@value);
mes l("##BHall Of Fame: TOP10##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]+")");
mes("6."+.@name$[5]+" ("+.@value[5]+")");
mes("7."+.@name$[6]+" ("+.@value[6]+")");
mes("8."+.@name$[7]+" ("+.@value[7]+")");
mes("9."+.@name$[8]+" ("+.@value[8]+")");
mes("10."+.@name$[9]+" ("+.@value[9]+")");
return;
}
function script HallOfFortune {
mes "";
.@nb = query_sql("select name, zeny from `char` WHERE `guild_id`!=1 ORDER BY zeny DESC LIMIT 15", .@name$, .@value);
mes l("##BHall Of Fortune: TOP15##b");
mes("1."+.@name$[0]+" ("+format_number(.@value[0])+" GP)");
mes("2."+.@name$[1]+" ("+format_number(.@value[1])+" GP)");
mes("3."+.@name$[2]+" ("+format_number(.@value[2])+" GP)");
mes("4."+.@name$[3]+" ("+format_number(.@value[3])+" GP)");
mes("5."+.@name$[4]+" ("+format_number(.@value[4])+" GP)");
mes("6."+.@name$[5]+" ("+format_number(.@value[5])+" GP)");
mes("7."+.@name$[6]+" ("+format_number(.@value[6])+" GP)");
mes("8."+.@name$[7]+" ("+format_number(.@value[7])+" GP)");
mes("9."+.@name$[8]+" ("+format_number(.@value[8])+" GP)");
mes("10."+.@name$[9]+" ("+format_number(.@value[9])+" GP)");
mes("11."+.@name$[10]+" ("+format_number(.@value[10])+" GP)");
mes("12."+.@name$[11]+" ("+format_number(.@value[11])+" GP)");
mes("13."+.@name$[12]+" ("+format_number(.@value[12])+" GP)");
mes("14."+.@name$[13]+" ("+format_number(.@value[13])+" GP)");
mes("15."+.@name$[14]+" ("+format_number(.@value[14])+" GP)");
return;
}
function script HallOfLevel {
mes "";
.@nb = query_sql("select name, base_level from `char` WHERE `guild_id`!=1 ORDER BY base_level DESC LIMIT 15", .@name$, .@value);
mes l("##BHall Of Level: TOP15##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]+")");
mes("6."+.@name$[5]+" ("+.@value[5]+")");
mes("7."+.@name$[6]+" ("+.@value[6]+")");
mes("8."+.@name$[7]+" ("+.@value[7]+")");
mes("9."+.@name$[8]+" ("+.@value[8]+")");
mes("10."+.@name$[9]+" ("+.@value[9]+")");
mes("11."+.@name$[10]+" ("+.@value[10]+")");
mes("12."+.@name$[11]+" ("+.@value[11]+")");
mes("13."+.@name$[12]+" ("+.@value[12]+")");
mes("14."+.@name$[13]+" ("+.@value[13]+")");
mes("15."+.@name$[14]+" ("+.@value[14]+")");
return;
}
function script HallOfCoins {
mes "";
.@nb = query_sql("SELECT c.name, i.amount FROM `inventory` AS i, `char` AS c WHERE i.nameid="+StrangeCoin+" AND i.char_id=c.char_id ORDER BY i.amount DESC LIMIT 15", .@name$, .@value);
mes l("##BHall Of @@: TOP15##b", getitemlink(StrangeCoin));
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]+")");
mes("6."+.@name$[5]+" ("+.@value[5]+")");
mes("7."+.@name$[6]+" ("+.@value[6]+")");
mes("8."+.@name$[7]+" ("+.@value[7]+")");
mes("9."+.@name$[8]+" ("+.@value[8]+")");
mes("10."+.@name$[9]+" ("+.@value[9]+")");
mes("11."+.@name$[10]+" ("+.@value[10]+")");
mes("12."+.@name$[11]+" ("+.@value[11]+")");
mes("13."+.@name$[12]+" ("+.@value[12]+")");
mes("14."+.@name$[13]+" ("+.@value[13]+")");
mes("15."+.@name$[14]+" ("+.@value[14]+")");
return;
}
function script HallOfGMLog {
mes "";
.@nb = query_sql("select char_name, command from `atcommandlog` ORDER BY atcommand_id DESC LIMIT 15", .@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]+")");
mes("6."+.@name$[5]+" ("+.@value$[5]+")");
mes("7."+.@name$[6]+" ("+.@value$[6]+")");
mes("8."+.@name$[7]+" ("+.@value$[7]+")");
mes("9."+.@name$[8]+" ("+.@value$[8]+")");
mes("10."+.@name$[9]+" ("+.@value$[9]+")");
mes("11."+.@name$[10]+" ("+.@value$[10]+")");
mes("12."+.@name$[11]+" ("+.@value$[11]+")");
mes("13."+.@name$[12]+" ("+.@value$[12]+")");
mes("14."+.@name$[13]+" ("+.@value$[13]+")");
mes("15."+.@name$[14]+" ("+.@value$[14]+")");
return;
}
function script HallOfReferral {
mes "";
.@nb = query_sql("SELECT l.userid, COUNT(a.value) FROM `mapreg` AS a, `login` AS l WHERE a.varname='$REFERRAL_IDS' AND l.account_id=a.index ORDER BY COUNT(a.value) DESC LIMIT 20", .@name$, .@value);
mes "Referral Program Report - pg. 1";
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]+")");
mes("6."+.@name$[5]+" ("+.@value[5]+")");
mes("7."+.@name$[6]+" ("+.@value[6]+")");
mes("8."+.@name$[7]+" ("+.@value[7]+")");
mes("9."+.@name$[8]+" ("+.@value[8]+")");
mes("10."+.@name$[9]+" ("+.@value[9]+")");
next;
mes "Referral Program Report - pg. 2";
mes("11."+.@name$[10]+" ("+.@value[10]+")");
mes("12."+.@name$[11]+" ("+.@value[11]+")");
mes("13."+.@name$[12]+" ("+.@value[12]+")");
mes("14."+.@name$[13]+" ("+.@value[13]+")");
mes("15."+.@name$[14]+" ("+.@value[14]+")");
mes("16."+.@name$[15]+" ("+.@value[15]+")");
mes("17."+.@name$[16]+" ("+.@value[16]+")");
mes("18."+.@name$[17]+" ("+.@value[17]+")");
mes("19."+.@name$[18]+" ("+.@value[18]+")");
mes("20."+.@name$[19]+" ("+.@value[19]+")");
next;
return;
}
function script HallOfSponsor {
mes l("This is in honor of all the [@@help://about-server|Contributors@@] who helped rebuilding this world, after the Monster War outbreak.");
mes l("And also in notable mention of those who [@@https://www.patreon.com/TMW2|sponsor@@] the Alliance and its administrative structure.");
mes l("");
mes l("GonzoDark, Saulc.");
return;
}
function script HallOf2018 {
mes "";
if ($YETIKING_WINNER$ != "") {
mes l(".:: FIRST PLAYER TO COMPLETE YETI KING QUEST ::.");
mes $YETIKING_WINNER$;
mes "";
}
mes l(".:: NOTABLE NAMES ON HURNSCALD LIBERATION DAY ::.");
mes l("DragonStar, Aisen");
mes "";
mes l(".:: NOTABLE NAMES ON NIVALIS LIBERATION DAY ::.");
mes l("Jesusalva");
mes "";
mes l(".:: FIND-THE-NPC 2018 MINI-EVENT WINNER ::.");
mes "shab";
next;
mes l(".:: Easter 2018 ::.");
mes l("In honor of DragonStar, winner of Easter 2018.");
mesc l("Unfortunately, other victor's names weren't logged.");
mes "";
mes l(".:: Worker Day 2018 ::.");
mes l("No victor appliable.");
mes "";
mes l(".:: Purple Day 2018 ::.");
mes l("No victor appliable.");
next;
mes l(".:: Ched's Summer 2018 ::.");
mes ("1. WarBlade - 5325");
mes ("2. Aisen - 2000");
mes ("3. msawis - 1000");
mes ("4. vilbou - 400");
mes ("5. Woody - 353");
next;
mes l(".:: Hasan Scorpion Killing Challenge 2018 ::.");
mes ("1. Krists - 1070");
mes ("2. Aisen - 598");
mes ("3. AndulkaT - 212");
mes ("4. monking - 86");
mes ("5. Carbon14 - 78");
next;
mes l(".:: Christmas 2018 ::.");
mes ("1. WarBlade - 324");
mes ("2. Xtreem - 190");
mes ("3. msawis - 110");
mes ("4. Krists - 75");
mes ("5. Mrhedx - 38");
mes "";
mes l(".:: Christmas 2018 ::.");
mes ("1. WarBlade - 100,000 GP");
mes ("2. msawis - 7,500 GP");
mes ("3. LawnCable - 4,450 GP");
mes ("4. Krists - 1,000 GP");
mes ("5. demure GM - 1,000 GP");
return;
}
function script HallOf2019 {
mesc l("This schedule is subject to change without prior notice."), 1;
mesc l("Changes include but are not limited to festive events and dates."), 1;
next;
if ($HEROESHOLD_WINNER$ != "") {
mes l(".:: FIRST PLAYER TO COMPLETE HEROES HOLD MASTER DUNGEON ::.");
mes $HEROESHOLD_WINNER$;
mes "";
}
mes l(".:: TMW-2 Anniversary ::.");
//mesc l("Scheduled: January 13rd");
mes l("No victor appliable.");
mesc l("Anniversary marks the project birthdate. Do not mistake with TMW2 Day.");
mes "";
mes l(".:: Valentine Day ::.");
//mesc l("Scheduled: February 12th - 15th");
mes ("1. DragonStar - 300");
mes ("2. Jesusalva - 121");
mes ("3. Xanthem - 35");
mes ("4. Xtreem - 17");
mes ("5. Yuppi - 10");
next;
mes l(".:: TMW2 Day ::.");
//mesc l("Scheduled: March 2nd");
mes l("No victor appliable.");
mesc l("TMW2 Day marks the server birthdate. Do not mistake with TMW2 Anniversary.");
mes "";
mes l(".:: Easter 2019 ::.");
mesc l("Scheduled: April 17th - 24th");
mes "";
mes l(".:: Worker Day ::.");
mesc l("Scheduled: April 27th - May 3rd");
next;
mes l(".:: Ched's Summer 2019 ::.");
mesc l("June 21st - September 21st");
mes "";
mes l(".:: Chocolate Day ::.");
mesc l("Scheduled: July 7th");
mes "";
mes l(".:: Free Software Day ::.");
mesc l("Scheduled: September 9th");
mes "";
mes l(".:: Hasan Scorpion Killing Challenge 2019 ::.");
mesc l("September 22nd - December 20th");
mes "";
mes l(".:: Christmas 2019 ::.");
mesc l("Scheduled: December 19th - January 2nd");
return;
}
