Emistry

execute the table in your SQL machine

try this.. http://pastebin.com/raw.php?i=UEUbarEq it will check the database everyday..and remove all account that not login for 90 days or longer... please do a backup before use this..just in case anything happened.

i think this is the sql table for this script.. create table pvpladder ( char_id int(11) not null default '0' primary key, name varchar(30) not null default '', streaks smallint(6) unsigned not null default '0', kills smallint(6) unsigned not null default '0', deaths smallint(6) unsigned not null default '0', streaktime datetime ) engine = myisam; create table ownladder ( guild_id int(11) not null default '0' primary key, name varchar(24) not null default '', currentown smallint(6) unsigned not null default '0', highestown smallint(6) unsigned not null default '0', owntime datetime ) engine = myisam;

the current script doesnt accept items as payment...only zeny...

you can refer this. http://www.eathena.ws/board/index.php?s=&showtopic=229401&view=findpost&p=1250314

trunk/npc/merchants/refine.txt callfunc "refinemain","Hollgrehenn",0; callfunc "refinemain","Aragham",0; callfunc "refinemain","Antonio",0; callfunc "refinemain","Fredrik",0; callfunc "refinemain","Lambert",0; callfunc "refinemain","Manthasman Pruhag",0; callfunc "refinemain","Fulerr",0; change the 0 to 1

this topic are unable to solve perfectly using just npc script... it should be done through source mode since you are not going to use the manner.txt anyway i think this would be a good choice for you http://www.eathena.ws/board/index.php?showtopic=138710 but dunno if it's still working in rAthena or not.

bindatcmd is not used only for existing commands....it allow you to add a "new" @commands using npc script...that bind to certain npc label and execute the label if it's used.

if ( getgmlevel() >= $@LadderGM || ( !compare( strcharinfo(3),"prtg_cas" ) && !compare( strcharinfo(3),"arug_cas" ) ) ) end;

learn HTML / CSS / PHP / Javascript / JQuery and other website languages.... some website for reference.. http://www.w3schools.com/

http://rathena.org/board/topic/56229-can-not-carry-more-than-30000-of-one-kind-item/

View File Advanced Stylist Original idea of this script : http://www.eathena.ws/board/index.php?showtopic=148888 Well, this was my favourite stylist script in eAthena ....xD Since i got some time, and lately received a request on editing a stylist npc script. So i come with with the idea to add some minor features or enhance the original script. The script are written from scratch... A very quick and simple intro for the script, Able to nagivate styles easily ( Forward, Backward, Jump ). Able to blacklist certain style for each style group and separately by Gender. Removed save / load features since not really useful. Enable Zeny as payment for the services. Able to enable any of the 3 services. ( Hairstyle, Hair Color, Cloth Color ) Support multiple type of Currency Payment. ( Item , Cash Points , Zeny and etc ) Customizable. ( If any style was blacklisted, a default style will be displayed ) The script are rewrited and clean up some unecessary parts. Credits : AnnieRuru Hudelf Submitter Emistry Submitted 03/26/2013 Category Utilities Video Content Author Emistry  

run it in ur SQL Machine

i think it's the SQL datatype for HP and MAXHP column are not enough to cover 20,000,000 HP...since it can only hold up to around 8,000,000 mil++ HP only..because it's mediumint(8) try run this SQL query. ALTER TABLE `char` CHANGE COLUMN `max_hp` `max_hp` INT UNSIGNED NOT NULL DEFAULT '0' , CHANGE COLUMN `hp` `hp` INT UNSIGNED NOT NULL DEFAULT '0' ; Please do a back up before you run this..just in case anything unusual happen ~

http://rathena.org/board/topic/72715-unofficial-extra-status-icons/

trunk/conf/battle/player.conf // Maximum HP. (Default is 1000000) max_hp: 1000000

i just show the way to call the func.. LOL.. it should be like this inside the item_db.txt ..........{}{ disguise callfunc( "disguide_mob",2521,2616 ); }{ undisguise; }

//callfunc( "disguide_mob",2521,2616 ); function script disguise_mob { .@min_mob_id = getarg(0); .@max_mob_id = getarg(1); do{ .@mob_id = rand( .@max_mob_id,.@min_mob_id ); }while( .@mob_id == 2549 || .@mob_id == 2569 || .@mob_id == 2575 ); return .@mob_id; } try

use BaseJob or BaseClass ....

you mean these ? trunk/conf/battle/client.conf // Maximum allowed 'level' value that can be sent in unit packets. // Use together with the aura_lv setting to tell when exactly to show the aura. // NOTE: You also need to adjust the client if you want this to work. // NOTE: Default is 99. Values above 127 will probably behave incorrectly. // NOTE: If you don't know what this does, don't change it!!! max_lv: 99 // Level required to display an aura. // NOTE: This assumes that sending max_lv to the client will display the aura. // NOTE: aura_lv must not be less than max_lv. // Example: If max_lv is 99 and aura_lv is 150, characters with level 99~149 // will be sent as being all level 98, and only characters with level // 150 or more will be reported as having level 99 and show an aura. aura_lv: 99

I know it's wrong, but this is pretty much the idea. atcommand "@disguise "+rand( 2521,2616); and for the another post....check for any error ... the script look fine ~

current rAthena support up to level 160.. trunk/db/re/exp.txt

.@amount = ( #CASHPOINTS / 100 ); #CASHPOINTS -= ( .@amount * 100 ); #KVMPOINTS += .@amount; dispbottom "Gained "+.@amount+" KVM Points.";

check your npc in these folder trunk/npc/guild/ trunk/npc/guild2/