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 [email protected], query_sql("SELECT account_id, value FROM `global_reg_value` WHERE str = '#CASHPOINTS' ORDER BY value DESC LIMIT 5;", [email protected], [email protected]);
	mes "Pemegang Cashpoint terbanyak: TOP 5";
	for(set [email protected],0; [email protected] <= [email protected]; set [email protected],[email protected]+1)
		mes [email protected]+1+". "[email protected][[email protected]]+" ("[email protected][[email protected]]+")";
	end;
	
L_Zeny:
	next;
	set [email protected], query_sql("SELECT name, zeny FROM `char` ORDER BY zeny DESC LIMIT 5", [email protected]$, [email protected]);
	mes "Pemegang Zeny terbanyak: TOP 5";
	for(set [email protected],0; [email protected] <= [email protected]; set [email protected],[email protected]+1)
		mes [email protected]+1+". "[email protected]$[[email protected]]+" ("[email protected][[email protected]]+")";
	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 [email protected], query_sql("SELECT account_id, value FROM `global_reg_value` WHERE str = '#CASHPOINTS' ORDER BY value DESC LIMIT 5;", [email protected], [email protected]);
	mes "Pemegang Cashpoint terbanyak: TOP 5";
	for(set [email protected],0; [email protected] <= [email protected]; set [email protected],[email protected]+1)
		mes [email protected]+1+". "[email protected][[email protected]]+" ("[email protected][[email protected]]+")";
	end;
	
L_Zeny:
	next;
	set [email protected], query_sql("SELECT name, zeny FROM `char` ORDER BY zeny DESC LIMIT 5", [email protected]$, [email protected]);
	mes "Pemegang Zeny terbanyak: TOP 5";
	for(set [email protected],0; [email protected] <= [email protected]; set [email protected],[email protected]+1)
		mes [email protected]+1+". "[email protected]$[[email protected]]+" ("[email protected][[email protected]]+")";
	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.