Zeny ranker

[caspa]

can somebody please help me create a zeny ranker script....

the script would have a function like this

 

 

 

mes "How can i help you?"';
 
next;
 
menu "View zeny ranking",1;
 
1:
mes "Alright, here's the top 10 richest character on the server :"
 
top 1 - name 1
top 2 - name 2
top 3 - name 3
top 4 - name 4
top 5 - name 5
top 6 - name 6
top 7 - name 7
top 8 - name 8
top 9 - name 9
top 10 - name 10
next;
menu "name 1",n1,"  "name 2",n2,"  "name 2",n2,"  "name 3",n3,"  "name 4",n4,"  "name 5",n5,"  "name 6",n6," and so on.....

n1:
name :
job :
blvl :
jlvl :
guild : 
current zeny : 1 billion
 
 
n2:
name :
job :
blvl :
jlvl :
guild : 
current zeny : 900 million
 
 
and so on.....
 

Edited August 6, 2013 by caspa

[celeron0134]

up for this.. Zeny Tracker

 

[xmaniacx]

Nice way to tract the farmers on the server, i'd like to have the script too.

[Aksl]

PM me.

[DeadlySilence]

prontera,150,185,5 script Test 100,{

query_sql("SELECT `c`.`name`, `c`.`class`, `c`.`base_level`, `c`.`job_level`, `c`.`zeny`, `g`.`name` FROM `char` c LEFT JOIN (`guild` g) ON (`c`.`guild_id` = `g`.`guild_id`) ORDER BY `c`.`zeny` DESC LIMIT 10", .@name$, .@class, .@blvl, .@jlvl, .@zeny, .@guild$);

for (.@i = 0; .@i < getarraysize(.@name$); .@i++) {

.@menu$ = (("" == .@menu$) ? "Top " + (.@i + 1) + " - " + .@name$[.@i] : .@menu$ + ":Top " + (.@i + 1) + " - " + .@name$[.@i]);

}

mes "[Zeny Ranking]";

mes "Which character do you want to see details about?";

.@selected = select(.@menu$);

next;

mes "Name: " + .@name$[.@selected - 1];

mes "Class: " + jobname(.@class[.@selected - 1]);

mes "Base level: " + .@blvl[.@selected - 1];

mes "Job level: " + .@jlvl[.@selected - 1];

mes "Guild: " + ((.@guild$[.@selected - 1]) ? .@guild$[.@selected - 1] : "none");

mes "Zeny: " + .@zeny[.@selected - 1];

close;

}