Jump to content

alkhaleej

Members
 View Profile  See their activity

  • Posts

    58

  • Joined

  • Last visited

 Content Type 

Posts posted by alkhaleej

    Save Character SQL Item Data

    in Scripting Support

    Posted

    let me guess ...

    you are trying to write an utility script which search for all characters with a certain mvp card ID

    if the player has the mvp card ID, the gm can then proceed to remove the card

     

    You've guessed it right Annie. I'll try *getinventorylist; instead. Thank you for the reply.

    Save Character SQL Item Data

    in Scripting Support

    Posted

    Please help. I want to save a character's item data on sql using script. I searched and found this:

     

    http://rathena.org/board/topic/76537-save-character-data/

     

    but is not specific to what I would like to happen.

     

    The reason I want this is to check a card and delete it on its actual location the same time the script will check for it.

     

    Can

    *getinventorylist;

    do this job? I've read about this inside 

     

    trunk/doc/script_commands.txt

    Help on script: Kicking a player with a certain item in his inventory

    in Scripting Support

    Posted · Edited by alkhaleej

    Can anyone please help me on this script:

     

    I want to kick a certain player that is online if he has a certain item in his inventory and will delete that entry from `inventory` table afterwards. I have a script below but it is not doing anything except for the delete part.

     

     

    query_sql "SELECT `char_id` FROM `inventory` WHERE `nameid` = '1599'",.@IHLD;
query_sql "SELECT `name` FROM `char` WHERE `char_id` = '.@IHLD'",.@IHLDNAME$;
atcommand "@kick "+.@IHLDNAME$;
query_sql "DELETE FROM `inventory` WHERE `nameid` = '1599'";

    Soul Linker Weapon Problem

    in Graphics Support

    Posted

    I made a folder for the directory of Soul Linker weapon based from this:

     

    Reference_Sheet

    and this:

    http://ratemyserver.net/riot_bible/riot_bible.txt

     

    data\sprite\Àΰ£Á·\¼Ò¿ï¸µÄ¿

     

    and placed 4 filenames there:

     

    ¼Ò¿ï¸µÄ¿_¿©_1600.act

     

    ¼Ò¿ï¸µÄ¿_¿©_1600.spr

     

    ¼Ò¿ï¸µÄ¿_³²_1600.act

     

    ¼Ò¿ï¸µÄ¿_³²_1600.spr

     

    for a custom rod.

     

    My sprite is not showing whereas I am inside the range of the rod and I have made 6 other customs aside from this and they are all working.

     

    My only question is: ¼Ò¿ï¸µÄ¿_ = Soul Linker Weapon folder? Any help will be appreciated.

    • Upvote 2

    Help in 3rd job skill restriction on a certain map

    in Database Support

    Posted

    Added a new zone on npc\mapflag\restricted.txt

     

    2009rwc_04 mapflag restricted 8

     

    added the following on my db\re\skill_nocast_db.txt

     

    //----------------------------------------------------------------------------
// Zone 8 - LMS (custom)
//----------------------------------------------------------------------------
51,4096  //TF_HIDING
135,4096 //AS_CLOAKING
2033,4096 //GC_CLOAKINGEXCEED
528,4096 //NJ_KASUMIKIRI
2247,4096 //RA_CAMOUFLAGE
2290,4096 //SC_INVISIBILITY

     

    Observation:

     

    Working Skills:

    TF_HIDING

    AS_CLOAKING

    NJ_KASUMIKIRI

     

    Not Working Skills:

    GC_CLOAKINGEXCEED

    RA_CAMOUFLAGE

    SC_INVISIBILITY

     

    It seems 3rd job skills are not restricted. Any help would appreciated.

    help in lms script

    in Scripting Support

    Posted

    Anyone can help with this lms modified script:

     

    Problem: Whenever someone goes inside Mr. Banker is there and if he clicks him even if he is alone in the LMS map, he will get the prize even before starting the LMS.

     

    -    script    LMSAnnouncer    -1,{
 
OnClock0005:
OnClock0605:
OnClock1205:
OnClock1805:
 
    enablenpc "lmswarp";
    delwaitingroom;
    waitingroom "Register LMS Now",0;
    announce "[ LMS Event ] : The Last Man Standing Event will be starting shortly.",0,0xFF6633;
        sleep2 3000;
    announce "[ LMS Event ] : Those who want to play, please proceed to the main town and look for the event portal.",0,0xFF6633;
        sleep2 2000;
    announce "[ LMS Event ] : The portal is going to close in one minute..",0,0xFF6633;
        sleep2 60000;
    announce "[ LMS Event ] : The portal has been closed.",0,0xFF6633;
        sleep 5000;
    announce "[ LMS Event ] : Next event will start in 2 hours.",0,0xFF6633;
        delwaitingroom;
        disablenpc "lmswarp";
        stopnpctimer;
        pvpoff "2009rwc_04";
            mapannounce "2009rwc_04","[ LMS Event ] : The Last Man Standing Event will start shortly.",0,0xFF6633;
                sleep2 5000;
            mapannounce "2009rwc_04","[ LMS Event ] : Before we start, please take note on some few reminders:",0,0xFF6633;
                sleep2 5000;
            mapannounce "2009rwc_04","[ LMS Event ] : Using Cloaking, Hiding or similar in nature skills is strictly prohibited.",0,0xFF6633;
                sleep2 5000;
            mapannounce "2009rwc_04","[ LMS Event ] : Only the Last Man Standing will win this event!!",0,0xFF6633;
                sleep2 5000;
            mapannounce "2009rwc_04","[ LMS Event ] : What are we waiting for?.. Let's get ready to rumble!!...",0,0xFF6633;
                sleep2 5000;
            mapannounce "2009rwc_04","[ LMS Event ] : Get ready at the count of 5 we will start!",0,0xFF6633;
                sleep2 5000;
                    for( set .@s,5; .@s > 0; set .@s,.@s - 1 ){
                        mapannounce "2009rwc_04","[ LMS Event ] : "+.@s+" seconds to go ~ !!",0,0xFF6633;
                            sleep2 1000;
                    }
 
    pvpon "2009rwc_04";
    enablenpc "Mr. Banker";
    initnpctimer;
end;
 
OnTimer5000:
    if(getmapusers("2009rwc_04") == 0){
        announce "[ LMS Event ] : Event cancelled due to lack of participants.",0,0xFF6633;
        stopnpctimer;
    }else if(getmapusers("2009rwc_04") == 1){
        mapannounce "2009rwc_04","Mr. Banker: Please talk to me to get your prize..",0,0xFF6633;
        pvpoff "2009rwc_04";
        stopnpctimer;
    }else if(getmapusers("2009rwc_04") == 2){
        mapannounce "2009rwc_04","[ LMS Event ] : Last 2 Brave warriors are still alive!",0,0xFF6633;
        initnpctimer;
    }
end;
 
OnInit:
    disablenpc "Mr. Banker";
    disablenpc "lmswarp";
end;
}
 
//--------------------------
2009rwc_04,43,58,6    script    Mr. Banker    56,{
    if(getmapusers("2009rwc_04") > 1){
    npctalk "Only the last Survivor can talk with me.";
end;
}
    mes "[Banker]";
    mes "Congrats. You've won.";
        next;
    announce "[ LMS Event ] : We have a winner! well done "+strcharinfo(0)+".",0,0xFF6633;
        set #CASHPOINTS, #CASHPOINTS + 50; // Change This item id to what ever you want . item id,amount
        set #kill_point,0;
        dispbottom "You have obtained 50 Cash Points.";
    mes "I will warp you now to the main town.";
        close2;
        warp "alexandria",158,139;
        disablenpc "Mr. Banker";
    end;
 
OnInit:
    while(1){
    delwaitingroom;
    waitingroom "["+getmapusers("2009rwc_04")+"] Participants ",0;
    sleep 1000;
    }
end;
 
 
OnPCDieEvent:
    if( strcharinfo(3) != "2009rwc_04")end;
        set #kill_point, 0;
        announce ""+strcharinfo(0)+" died and is out of the game!.",bc_all,0xFF6633;
        sleep2 100;
        atcommand "@alive";
        sleep2 100;
        warp "alexandria",158,139;
        end;
        
OnPCKillEvent:
    if( strcharinfo(3) != "2009rwc_04")end;
    set #kill_point,#kill_point+1;
        if ( #kill_point % 4 == 0) {
        announce ""+strcharinfo(0)+" have made 4 consecutive kills!! He will be granted an item.",bc_all,0xFF6633;
        getitem 7227, 1;
        }
    end;
    
}
 
//-----------------------------------------------------------------------------------
//------------------Warp Portal------------------------------------------------------
alexandria,158,134,0    warp    lmswarp    2,2,2009rwc_04,0,0
//-----------------------------------------------------------------------------------
// == Mapflags
2009rwc_04    mapflag    nowarp
2009rwc_04    mapflag    nowarpto
2009rwc_04    mapflag    noteleport
2009rwc_04    mapflag    nosave
2009rwc_04    mapflag    nomemo
2009rwc_04    mapflag    nobranch
2009rwc_04    mapflag    pvp_noparty
2009rwc_04    mapflag    pvp_noguild
2009rwc_04    mapflag    restricted    1

    Unidentified Items > Zeny

    in Script Requests

    Posted · Edited by Patskie
    Change topic name to make it accurate

    Can anyone help me on how to add something to this to:
     
    • Sell my unidentified items depending on their standard selling price to NPC
    • If user have Overcharge skill, they can obtain the additional increase of price as well
     
    getinventorylist;
                 for(set .@i,0; .@i < @inventorylist_count; set .@i,.@i+1){
                        if(@inventorylist_identify[.@i] == 0){

                 close;
                 }
          }
}
     
    something like
     
    • getiteminfo(<item ID>,<type>)

     

    where type is 1 right? but i can't make it work.

     



    topic should have been Unidentified items > Zeny. I am sorry for that

    Count Misc items and trade for a particular Item with same quantity

    in Script Requests

    Posted

    I got to read about this script which I think will be helpful to my server:

     

    http://rathena.org/board/topic/81204-script-command-for-checking-item-types/

     

    I just would like to request a npc which will count the misc and do not display it instead exchange all misc for a single item of the same count.

     

    Say 110 fluff, 40 jellopy and 50 clover = 1 item of 200 pcs.

     

    can i use the .@found++ variable and use getitem <itemno>,.@found ?

    Skill cannot be used and blocked black

    in Client-side Support

    Posted

    Mine is 99/70.

    for 3rd? and can you please state the SVN you are using?

     

     

     

     

    thank you for you reply.

    where can I find job_exp.txt? I've searched it everywhere and not found it. I did not change anything from jobchanger

     

    trunk\db\re > renewal

    trunk\db\pre-re > non-renewal

     

    mind if you tell us what is the max base level and job level setting of your server?

    You did not answer my question.

    oh, i am sorry, sir. my mistake.

    max b level 150

    max job level 70

    What SVN are you using?

    Skill cannot be used and blocked black

    in Client-side Support

    Posted · Edited by alkhaleej

    thank you for you reply.

    where can I find job_exp.txt? I've searched it everywhere and not found it. I did not change anything from jobchanger

     

    trunk\db\re > renewal

    trunk\db\pre-re > non-renewal

     

    mind if you tell us what is the max base level and job level setting of your server?

    You did not answer my question.

    Mailbox: Cannot click "Write" tab

    in General Support

    Posted

    Client: 2012-07-16a

     

    Rathena Version: 17407

     

    Problem: Clicking the "Write" tab does nothing

     

    Facts:

     

    - no error msgs on server side

    - no error msgs on client side

    - can't click the "Write" tab

    - mail is on "Inbox" tab only

    - changed the mapflag where the mailbox is to "mapflag town"

    - i just don't know what to do here now.

    - please help

×
×
  • Create New...