summaryrefslogblamecommitdiff
path: root/npc/functions/scoreboards.txt
blob: 979b918f1a86a803ffce31746752b3b5416216ed (plain) (tree)
1
2
3
4
5
6
7
8
9
10







                                         

                                                                                                          




                                                 





                                                  



                                         

                                                                                                        




                                                 










                                                    



                                         

                                                                                                                                        




                                                 







                                                    





















                                                                                                                                                                                                


                                                    















                                                                                                                                 




                                                     
           
 
// TMW-2 Script
// Author:
//    Jesusalva
// Description:
//    Leaderboards + GM Command Log

function	script	HallOfFame	{
    mes "";
	.@nb = query_sql("select name, karma from `char` 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` ORDER BY zeny DESC LIMIT 15", .@name$, .@value);
	mes l("##BHall Of Fortune: 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	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 10", .@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;
}