Leaderboard

be grateful, I just setup rathena test server just to answer your question 1. 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; }2.besides inventory, there also can be storage, carts, guild_storage, mail and auction also, inventory is bound to character storage is bound by account guild storage is bound to a guild auction .... I don't want to think about it it will be just insane to list them all

@Kido : Ok, I note this ! @Fresh prince : I note too. Name : Captain_Arman Game : Trickster Online File Size: 573 KB Author: ToZorMan Download : Mob - Captain_Arman [ToZorMan].zip Link : www.green-peach.net ----------------------------------------------------------------- Name : Garm_Baby Game : Ragnarok Online File Size: 1033 KB Author: Gravity Download : Mob - Garm_Baby [ToZorMan].zip Link : www.green-peach.net ----------------------------------------------------------------- Name : Fashionable_Glasses Categorie : Upper Headgear File Size: 198 KB Author: Gravity Download : Hat - Fashionable_Glasses [ToZorMan].zip Link : www.green-peach.net

why not just make use of current settings..? conf/battle/misc.conf // Makes player cannot be attacked when autotrade? (turns player's state.monster_ignore) (Note 1) at_monsterignore: yes

pc_status_def_rate: if value = 50, you need 200 VIT to have STUN immunity if value = 100, you need 100 VIT to have STUN immunity if value = 200, you need 50 VIT to have STUN immunity pc_max_status_def: if value = 10, you can have maximum of 10% STUN immunity if value = 50, you can have maximum of 50% STUN immunity if value = 100, you can have maximum of 100% STUN immunity all the above settings is based on solely your character stats, not equipments nor cards.

find the message here, and edit it. conf/msg_conf or clif_displaymessage( sd->fd,"Whatever message you want to display" );

after you use @unloadnpc <main npc> all the duplicates NPC should have removed together. otherwise use @unloadnpcfile <file path>

1. select zeny, name from `char` where account_id in ( select account_id from login where group_id < 10 ) order by zeny desc limit 7;2. select name, value from `char` inner join global_reg_value on `char`.char_id = global_reg_value.char_id where global_reg_value.str = '#CASHPOINTS' and `char`.account_id in ( select account_id from login where group_id < 10 ) order by cast( value as signed ) desc limit 7;this is a request so ... 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" ) == 1 ) { .@nb = query_sql( "select zeny, name from `char` where account_id in ( select account_id from login where group_id < 10 ) order by zeny desc limit 7", .@zeny, .@name$ ); for ( .@i = 0; .@i < .@nb; .@i++ ) mes .@name$[.@i] +" - "+ .@zeny[.@i] +"Z"; } else { .@nb = query_sql( "select name, value from `char` inner join global_reg_value on `char`.char_id = global_reg_value.char_id where global_reg_value.str = '#CASHPOINTS' and `char`.account_id in ( select account_id from login where group_id < 10 ) order by cast( value as signed ) desc limit 5", .@name$, .@cash ); for ( .@i = 0; .@i < .@nb; .@i++ ) mes .@name$[.@i] +" - "+ .@cash[.@i] +" points."; } close; }I also didn't test

query_sql( "SELECT `name`,`zeny` FROM `char` WHERE `account_id` NOT IN ( SELECT `account_id` FROM `login` WHERE `group_id` > 0 ) ORDER BY `zeny` DESC LIMIT 5",.@char$,.@zeny ); .@size = getarraysize( .@char$ ); for( .@i = 0; .@i < .@size; .@i++ ) mes .@char$[.@i]+" - "+.@zeny[.@i]; close; something like this... didnt test.

Sure, you can: query_sql() in /doc/scripts_commands.txt SELECT, LIMIT, ORDER, from mysql docs Command in NPC to select total zeny from all characters on the server to .@total_zeny array. query_sql(" SELECT SUM(`zeny`) FROM `char`", .@total_zeny); It will select from `char` table 10 richest players to the two arrays: .@player$[], and .@zeny[] query_sql("SELECT name, zeny FROM `char` ORDER BY DESC LIMIT 10", .@player$, .@zeny);

actually, it is a very simple script: prontera,150,150,5 script 117,{ set .map$,"Your warp map"; if ( JobLevel >= 10 ) { warp .map$,150,150; end; } else { specialeffect2 313; percentheal 100,100; sleep2 200; specialeffect2 37; sc_start SC_INCREASEAGI,240000,10; sleep2 200; specialeffect2 42; sc_start SC_BLESSING,240000,10; } } Copy it from there --> PasteBin I've added 2 "sleep2" instructions, because looks ugly when all the buffs are applied at once

add this at the bottom after the first </connection>(your first server configuration) of your clientinfo.xml <connection> <display>Test Server</display> <desc>Ragnarok Online</desc> <balloon>this is a tool tip</balloon> <address>yourIP</address> <port>yourport</port> <version>yourversion</version> <langtype>1</langtype> <registrationweb>REGISTRATION URL HERE</registrationweb> </connection>

to be honest .... I rarely visit the main page of rAthena, probably once in a week or even longer .. O__O I alway using View New Content , even the bookmark that I made in my browser also using the same link. EDIT: ** Merged both topic