cash and zeny ladder

[hendra814]

Need cash and zeny ladder script,

location npc prontera 147 168

char must select what he/she want to see.

if select cash, it will show 5 or 10 max user, from largest to smallest

and same for zeny.

 

Thanks.

[Winz]

prontera,147,168,4	script	Dumbledore	735,{
	mes "Apa yang ingin kamu ketahui?";
	menu "Pemegang Cashpoint terbanyak",L_CP,"Pemegang Zeny terbanyak",L_Zeny;
	
L_CP:
	next;
	set .@nb, query_sql("SELECT account_id, value FROM `global_reg_value` WHERE str = '#CASHPOINTS' ORDER BY value DESC LIMIT 5;", .@accid, .@value);
	mes "Pemegang Cashpoint terbanyak: TOP 5";
	for(set .@i,0; .@i <= .@nb; set .@i,.@i+1)
		mes .@i+1+". "+.@accid[.@i]+" ("+.@value[.@i]+")";
	end;
	
L_Zeny:
	next;
	set .@nb, query_sql("SELECT name, zeny FROM `char` ORDER BY zeny DESC LIMIT 5", .@name$, .@zeny);
	mes "Pemegang Zeny terbanyak: TOP 5";
	for(set .@i,0; .@i <= .@nb; set .@i,.@i+1)
		mes .@i+1+". "+.@name$[.@i]+" ("+.@zeny[.@i]+")";
	end;
}

limited to 5.

Since #cashpoints is embedded to accountid, not char_id, then it can only show the account id.

For some reasons, I'm not picking a random char's name from that account ID nor use the "login" from that accountid (security, privacy)

[hendra814]

prontera,147,168,4	script	Dumbledore	735,{
	mes "Apa yang ingin kamu ketahui?";
	menu "Pemegang Cashpoint terbanyak",L_CP,"Pemegang Zeny terbanyak",L_Zeny;
	
L_CP:
	next;
	set .@nb, query_sql("SELECT account_id, value FROM `global_reg_value` WHERE str = '#CASHPOINTS' ORDER BY value DESC LIMIT 5;", .@accid, .@value);
	mes "Pemegang Cashpoint terbanyak: TOP 5";
	for(set .@i,0; .@i <= .@nb; set .@i,.@i+1)
		mes .@i+1+". "+.@accid[.@i]+" ("+.@value[.@i]+")";
	end;
	
L_Zeny:
	next;
	set .@nb, query_sql("SELECT name, zeny FROM `char` ORDER BY zeny DESC LIMIT 5", .@name$, .@zeny);
	mes "Pemegang Zeny terbanyak: TOP 5";
	for(set .@i,0; .@i <= .@nb; set .@i,.@i+1)
		mes .@i+1+". "+.@name$[.@i]+" ("+.@zeny[.@i]+")";
	end;
}

limited to 5.

Since #cashpoints is embedded to accountid, not char_id, then it can only show the account id.

For some reasons, I'm not picking a random char's name from that account ID nor use the "login" from that accountid (security, privacy)

 

It's Okay. thanks for reply.