Jump to content

Emistry

Forum Moderator
  • Posts

    10015
  • Joined

  • Days Won

    396

Community Answers

  1. Emistry's post in how to fix this vote for points? help me please thnx was marked as the answer   
    perhap you have some files missing...or put it at wrong place..
     
    make sure you have a folder / files named voteforpoints
    in your module folder.
  2. Emistry's post in Help-Help was marked as the answer   
    try this...
    http://pastebin.com/raw.php?i=euHQksK6
     
    edit the setting here
    OnInit: // required item .item_id = 671; .item_quantity = 1; // Colour Name List setarray .color_name$,"RED","BLUE"; setarray .color_code$,"FF0000","0055FF"; .color_name_menu$ = implode( .color_name$,":" ); // Filter Words setarray .filter_word$,"fuck","you"; .filter_word_check$ = ":"+implode( .filter_word$,":" )+":";
  3. Emistry's post in Sql query/script that will delete item to everyone. was marked as the answer   
    shutdown server...and
    try run these in your SQL Machine..
     
    DELETE FROM `auction` WHERE `nameid` = '16774' DELETE FROM `cart_inventory` WHERE `nameid` = '16774' DELETE FROM `guild_storage` WHERE `nameid` = '16774' DELETE FROM `inventory` WHERE `nameid` = '16774' DELETE FROM `mail` WHERE `nameid` = '16774' DELETE FROM `storage` WHERE `nameid` = '16774'  
     
    do a backup before try it.
  4. Emistry's post in if agitstart enable npc? was marked as the answer   
    OnAgitStart:
    enablenpc "prizegiver";
    end;
    OnAgitEnd:
    disablenpc "prizegiver";
    end;

  5. Emistry's post in BG Emperium Type Help was marked as the answer   
    try this
    http://pastebin.com/raw.php?i=T6eU8m9j
    if ( .winside ) { mapannounce "bat_c01", "[ "+( ( .winside == 1 )?"Red":"Blue" )+" Team] won !", 0; // Winner Rewards. getbgusers ( .winside == 1 )? .red : .blue; for ( .@i = 0; .@i < $@arenamembersnum; .@i++ ) getitem .rewarditem[0], .rewarditem[1], $@arenamembers[.@i]; // item reward // Loser Rewards. getbgusers ( .winside == 1 )? .blue : .red; for ( .@i = 0; .@i < $@arenamembersnum; .@i++ ) getitem .rewarditem[0], .rewarditem[1], $@arenamembers[.@i]; // item reward } else
  6. Emistry's post in eAthena Script to rAthena was marked as the answer   
    change
    getarraysize(".Global_Array_Item")  
    to
    getarraysize(.Global_Array_Item)  
     
     
    change
    for(set @i, 0; $Rank$[@i]; set @i, @i + 1) mes @i+"º"+$Rank$[@i]+".";  
    to
    for(set @i, 0; @i < getarraysize( $Rank$ ); set @i, @i + 1) mes @i+"º"+$Rank$[@i]+".";  
     
    EDIT : missing parts.
  7. Emistry's post in Request for a @sell Command was marked as the answer   
    you can do like this too
     
    - shop Sample_Shop -1,909:-1 - script Sample -1,{ OnInit: bindatcmd "sell",strnpcinfo(3)+"::OnAtCommand"; end; OnAtCommand: callshop "Sample_Shop",2; end; }
  8. Emistry's post in Bloody Branch Wont Spawn MVP Lighthazen? was marked as the answer   
    trunk/db/re/mob_boss.txt
    add in those missing mvp in this file.
  9. Emistry's post in PvP ladder remain empty was marked as the answer   
    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;
  10. Emistry's post in can i ask where is the old 1 refiner was marked as the answer   
    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
  11. Emistry's post in item stack higher than 30000 please! was marked as the answer   
    http://rathena.org/board/topic/56229-can-not-carry-more-than-30000-of-one-kind-item/
  12. Emistry's post in 'HP' DB error was marked as the answer   
    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 ~
  13. Emistry's post in Can you help me?Cash point to KVM point (glorious) was marked as the answer   
    .@amount = ( #CASHPOINTS / 100 );
    #CASHPOINTS -= ( .@amount * 100 );
    #KVMPOINTS += .@amount;
    dispbottom "Gained "+.@amount+" KVM Points.";

  14. Emistry's post in Flags of the castles do not appear in prontera was marked as the answer   
    check your npc in these folder
    trunk/npc/guild/
    trunk/npc/guild2/
  15. Emistry's post in where can I find mjolnir? imposible to refine? was marked as the answer   
    edit at the database to enable it...
    else...remove the checking of item is refineable or not inside ur script.
  16. Emistry's post in Reque auto get item when killed mob was marked as the answer   
    OnNPCKillEvent:
    if( killedrid == 2200 || killedrid == 2201 ){
        getitem 607,1;
        getitem 7539,1;
    }
    end;

  17. Emistry's post in Request werewolf was marked as the answer   
    isnt that this sprite is already included in the default data.grf ?
    it has been there for soooo loonnngggggg time ago....
     
    trunk/db/re/mob_db.txt
    1022,WEREWOLF,Werewolf,Werewolf,80,28600,0,11813,7289,2,2560,3280,65,35,1,97,60,1,135,52,10,10,2,0,40,163,200,1500,768,652,0,0,0,0,0,0,0,999,500,1034,4000,984,500,985,500,7017,800,0,0,1912,300,0,0,0,0,0,0  
     

  18. Emistry's post in how to add max weight capacity was marked as the answer   
    just edit the Weight value inside the file
    trunk/db/re/job_db1.txt

     
    For Example ...
    Novice level 1 + 1 STR = 200 k  Weight Limit
     

  19. Emistry's post in how to remove rathena svn character select 4 number password? was marked as the answer   
    trunk/conf/char_athena.conf
    //=================================== // Pincode system //=================================== // NOTE: Requires client 2011-03-09aragexeRE or newer. // A window is opened before you can select your character and you will have to enter a pincode by using only your mouse. // Default: yes pincode_enabled: yes  
    set to NO
  20. Emistry's post in Variables/Array Elements was marked as the answer   
    like this ?
    for( .@i = 0; .@i < getarraysize( .mvp ); .@i++ ) if( .monster == .mvp[.@i] ){ mes "It's MVP.."; close; } mes "It's not MVP."; close;
  21. Emistry's post in eathena healer during woe was marked as the answer   
    prontera,150,150,5 script Healer 99,{ if( !agitcheck() && !agitcheck2() ){ percentheal 100,50; // sc_start SC_BLESSING,360000,10; // sc_start SC_INCREASEAGI,360000,10; } end; }  
    refer agitcheck , agitcheck2
  22. Emistry's post in waiting room with server time was marked as the answer   
    prontera,155,181,5 script Sample 1002,{ end; OnInit: while( 1 ){ delwaitingroom; waitingroom " "+gettimestr( "%H:%M:%S %p",21 ),0; sleep 1000; } end; } refer Gettimestr
  23. Emistry's post in Simple Password activated NPC was marked as the answer   
    input @code$; if(@code$ != "1234") {  
    change the variable type to STRING ....since you are comparing with a STRING and not NUMERIC characters.
     
    or...
    input @code; if( @code != 1234 ) {
  24. Emistry's post in Healer with delay was marked as the answer   
    trunk/npc/custom/healer.txt
    set .@Delay,0; // Heal delay, in seconds
  25. Emistry's post in SQL problem after updating SVN was marked as the answer   
    trunk/sql-files/upgrades/upgrade_svn17086_log.sql
    trunk/sql-files/upgrades/upgrade_svn17086.sql
    trunk/sql-files/upgrades/upgrade_svn17080.sql
×
×
  • Create New...