prontera,156,185,6 script kdsjfhsdkfs 100,{
mes "blah";
next;
if ( select( "Show me Top 7 highest Zeny", "Show me Top 5 highest Cash Points", "Show me Top 10 Gold Coin holder" ) == 1 ) {
.@nb = query_sql( "select name, zeny from `char` left join login on `char`.account_id = login.account_id where group_id < 10 order by zeny desc limit 7", .@name$, .@zeny );
for ( .@i = 0; .@i < .@nb; .@i++ )
mes .@name$[.@i] +" - "+ .@zeny[.@i] +"Z";
}
else if ( @menu == 2 ) {
.@nb = query_sql( "select name, value from `char` left join global_reg_value on `char`.account_id = global_reg_value.account_id left join login on `char`.account_id = login.account_id where global_reg_value.str = '#CASHPOINTS' and group_id < 10 group by `char`.account_id order by cast( value as signed ) desc limit 5;", .@name$, .@cash );
for ( .@i = 0; .@i < .@nb; .@i++ )
mes .@name$[.@i] +" - "+ .@cash[.@i] +" points.";
}
else {
.@nb = query_sql( "select name, amount from inventory left join `char` on inventory.char_id = `char`.char_id left join login on `char`.account_id = login.account_id where nameid = 671 and group_id < 10 order by amount desc limit 10", .@name$, .@amount );
for ( .@i = 0; .@i < .@nb; .@i++ )
mes .@name$[.@i] +" - "+ .@amount[.@i] +" gold coins.";
}
close;
}
i need use this script but can use only show top zeny