Jump to content

cutekram

Members
  • Posts

    30
  • Joined

  • Last visited

Posts posted by cutekram

  1. On 11/4/2019 at 6:00 AM, Functor said:

    Hello! You have already asked about "Body Relocation + Spider Web" and got the solution: 

    https://rathena.org/board/topic/118958-block-body-relocation-while-spider-web/

    But it is without checking the status of "Ankle Snare".

    The final solution:

    Open ../src/map/skill.cpp and in the function skill_castend_pos2 after:

    	case MO_BODYRELOCATION:
    		if (unit_movepos(src, x, y, 2, 1)) {

    add:

    			if(sc && (sc->data[SC_SPIDERWEB] || sc->data[SC_ANKLE]))
    				break;

     

    THANK YOU!!

     

  2. I need help pls how to fix this i put this onto my SQL 
     

    1. /*
    2.  
    3. DROP TABLE IF EXISTS `mission_board`;
    4. CREATE TABLE IF NOT EXISTS `mission_board` (
    5. `id` int(11) unsigned NOT NULL,
    6. `title` varchar(30) NOT NULL default '',
    7. `desc` varchar(255) NOT NULL default '',
    8. `mob_list` varchar(50) NOT NULL default '',
    9. `mob_qty` varchar(50) NOT NULL default '',
    10. `item_list` varchar(50) NOT NULL default '',
    11. `item_qty` varchar(50) NOT NULL default '',
    12. `class_limitation` int(11) unsigned NOT NULL default '0',
    13. `class_branch` int(11) unsigned NOT NULL default '0',
    14. `min_lv` smallint(6) unsigned NOT NULL default '1',
    15. `max_lv` smallint(6) unsigned NOT NULL default '99',
    16. `repeat` smallint(6) unsigned NOT NULL default '0',
    17. `duration` int(11) unsigned NOT NULL default '0',
    18. `reward_list` varchar(50) NOT NULL default '',
    19. `reward_qty` varchar(50) NOT NULL default '',
    20. `base_exp` int(11) unsigned NOT NULL default '0',
    21. `job_exp` int(11) unsigned NOT NULL default '0',
    22. `zeny` int(11) unsigned NOT NULL default '0',
    23. `cash` int(11) unsigned NOT NULL default '0',
    24. `aid` int(11) unsigned NOT NULL default '0',
    25. `name` varchar(30) NOT NULL default '',
    26. `time_update` datetime NOT NULL default '0000-00-00 00:00:00',
    27. `npc_id` varchar(255) NOT NULL default '',
    28. `redo_delay` smallint(6) unsigned NOT NULL default '0',
    29. PRIMARY KEY (`id`)
    30. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    31.  
    32.  
    33. DROP TABLE IF EXISTS `player_mission`;
    34. CREATE TABLE IF NOT EXISTS `player_mission` (
    35. `id` int(11) unsigned NOT NULL,
    36. `mission_id` int(11) unsigned NOT NULL,
    37. `aid` int(11) unsigned NOT NULL default '0',
    38. `cid` int(11) unsigned NOT NULL default '0',
    39. `name` varchar(30) NOT NULL default '',
    40. `mob_hunt` varchar(50) NOT NULL default '',
    41. `expire` int(11) unsigned NOT NULL default '0',
    42. `starting` datetime NOT NULL default '0000-00-00 00:00:00',
    43. `completion` datetime NOT NULL default '0000-00-00 00:00:00',
    44. PRIMARY KEY (`id`)
    45. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    46.  
    47. */

      then rest is the script but i have this error
    48.  
    49. : DB error - Table 'ragnarok.mission_board' doesnt exist
      [Debug]: at script.c:16142 - SELECT 'id IN ( SELECT 'id FROM 'mission_board ect ect ect


      Can someone can help me pls.?
  3. can someone can help me how can i change this into monday to friday exp rate 20x20x time around 19:00 to 21:00 PM please help me thank you

    //===== EinherjarRO Scripts ================================== 
    //= Floating Rates
    //===== By: ================================================== 
    //= Stolao
    //===== Current Version: ===================================== 
    //= 1.07
    //===== Compatible With: ===================================== 
    //= rAthena SVN
    //===== Description: ========================================= 
    //= Floating Rates
    //===== Uses: ================================================
    //= Exp and Item Rates Change Dynaimcally based on Online
    //= Player count and a configurable variables
    //===== Comments: ============================================
    //= [stolao]
    //= Optimize]
    //= In Game Menu / @Command?
    //===== Additional Comments: =================================
    //= 1.00 Origional Make
    //= 1.01 Removed Unessisary Line
    //= 1.02 Added Config
    //= 1.03 Made auto collect base rates
    //= 1.04 Fixed a bug where would keep increasing every hour
    //= 1.05 Made Multipliers into an array
    //= 1.06 Fixed typos
    //= 1.07 Fixed Set -> setarray
    //===== Contact Ifo: =========================================
    //= [stolao] 
    //============================================================
     
    - script floating_rate -1,{
    OnMinute30:
    set .@i, getusers(1);
    set .@r, rand(.Random[0],.Random[1]);
    setbattleflag( "base_exp_rate", .R[0] + (.@r + .@i) * .ExpMulti[0]);
    setbattleflag( "job_exp_rate", .R[1] + (.@r + .@i) * .ExpMulti[1]);
    setbattleflag( "item_rate_common", .R[2] + (.@r + .@i) * .ItemMulti[0]);
    setbattleflag( "item_rate_heal", .R[3] + (.@r + .@i) * .ItemMulti[1]);
    setbattleflag( "item_rate_use", .R[4] + (.@r + .@i) * .ItemMulti[2]);
    setbattleflag( "item_rate_equip", .R[5] + (.@r + .@i) * .ItemMulti[3]);
    atcommand "@reloadmobdb";
    Announce "[server]: Rates are now "+getbattleflag("base_exp_rate")/100+""+((getbattleflag("base_exp_rate")%100)?"."+getbattleflag("base_exp_rate")%100:"")+"/"+getbattleflag("job_exp_rate")/100+""+((getbattleflag("job_exp_rate")%100)?"."+getbattleflag("job_exp_rate")%100:"")+"/"+getbattleflag("item_rate_common")/100+""+((getbattleflag("item_rate_common")%100)?"."+getbattleflag("item_rate_common")%100:"")+" !",8;
    end;
     
    OnInit:
    // Multiplier Per Player and .Random
    // Each point is .01x Increase in exp rates
    // [0] = Base Exp
    // [1] = Job Exp
    //    eg: rand = 75 , getuser = 100, Multi = 3
    //    rates will be increase by 5.25x
    setarray .ExpMulti ,3,3;
     
    // Multiplier Per Player and .Random
    // Each point is .01x Increase in exp rates
    // [0] = Common Items
    // [1] = Healing Items
    // [2] = Useable Items
    // [3] = Equipment Items
    //    eg: rand = 75 , getuser = 100, Multi = 1
    //    rates will be increase by 1.75x
    setarray .ItemMulti,1,1,1,1;
     
    // The Random Variable Min and Max
    // [0] = Min
    // [1] = Max
    setarray .Random,0,100;
    end;
     
    OnInterIfInitOnce:
    // Dont Touch
    // Used to collect the base rates
    setarray .R, getbattleflag("base_exp_rate"), getbattleflag("job_exp_rate"), getbattleflag("item_rate_common"), getbattleflag("item_rate_heal"), getbattleflag("item_rate_use"), getbattleflag("item_rate_equip");
    end;
    }
  4. Hi Guys i would like to ask if how can i change the time into 3 hours on this script thanks for advance
     

    //FAST TYPE EVENT
    //Credits to Emistry for making the script
    //Paulinds for requesting the script, details & idea.
     
    prontera,146,172,5 script Fast-Type Event 421,{
    
    if(getgmlevel() >= 99) callsub L_GM;
    if( !.Event ) {
            mes "There is no Event right now.";
    } else if ( .String$ == "" ) {
            npctalk "Wait for the next round..";
    
    } else {
            mes "Type the Correct Sentences.";
            mes "^FF0000" + .String$ + "^000000";
            input .@Type$;
            if( .String$ == "" ) {
                    announce "Sorry, " + strcharinfo(0) + " is a bit slow..",0;
                    close;
            }
            if ( .String$ == .@Type$ && .Event ) {
                    getitem 7227, 1; //EDIT THE PRIZE HERE
                    announce "Fast-Type Event: " + strcharinfo(0) + " typed the correct string!",0;
                    set .String$, "";
                    set .Round, .Round + 1;
                    donpcevent "Fast-Type Event::OnStart2";
            } else {
                    announce "" + strcharinfo(0) + " mispelled some strings XD",0;
            }
    }
    close;
    
    OnMinute00:
    OnMinute60:
    if(.Event) end;
    donpcevent "Fast-Type Event::OnStart";
    end;
    
    OnStart:
    announce "Fast-Type Event has started at Prontera 146 172 !",0;
    L_Begin:
    set .Event, 1;
    set .String$, "";
    while( getstrlen( .String$ ) < .Length ){
            set .String$,.String$ + .List$[ rand( getarraysize( .List$ ) ) ];
    }
    announce "Round "+(.Round+1)+" Started !",0;
    end;
    
    OnStart2:
    sleep2 5000;
    if(.Round == .Rounds) {
            if(!.Event) end;
            announce "Fast-Type Event: Event is over!",0;
            set .Event, 0;
            set .Round, 0;
            end;
    }
    if(!.Event) end;
    announce "Fast-Type Event: Next round starts in 5 seconds...",0;
    sleep2 5000;
    if(!.Event) end;
    goto L_Begin;
    
    L_GM:
    mes "Fast-Type event is" + (.Event?"^00FF00 ON^000000":"^FF0000 OFF^000000");
    if(select((!.Event?"^00FF00Start":"^FF0000End") + " Event^000000","Normal Player") == 2) return;
    switch(.Event) {
            case 1:
                    set .Event, 0;
                    set .Round, 0;
                    set .String$, "";
                    announce "Fast-Type Event: A GM has ended the event.",0; break;
            default:
                    donpcevent "Fast-Type Event::OnStart";
    }
    close;
    
    OnInit:
    set .Length,28; //EDIT THE LENGTH OF CHARACTERS TO BE TYPED
    set .Rounds,3; //EDIT THE ROUNDS
    setarray .List$,";","B","_","D","E","%","=","H","I","J","/","L","M","N","6","P","Q","]","S","T",","; //YOU CAN ADD LETTERS, DIGITS & SYMBOLS HERE..
    end;
    }
    
  5. Hi guys would you mind if i request a Script that called Card Trader.? What it does is they actually sell there cards or Exchange there card into Old Card Album. 4 pcs of normal cards = into 1 Pcs Old Card Album. can you please help me? thank you  /no1

×
×
  • Create New...