Jump to content

utofaery

Members
 View Profile  See their activity

  • Posts

    228

  • Joined

  • Last visited

  • Days Won

    3

 Content Type 

Posts posted by utofaery

    [Guide]: Lightweight compiler for Windows for replacement heavy Visual Studio IDE. Compile rAthena faster. Save your bandwidth and disk space.

    in Windows Support

    Posted · Edited by utofaery

    Since vc++ 2017 v141 toolset (x86 x64)  is not available

    on previous post you mentioned to use visual c++ build tools from workload page 

    is that you are suggesting??  to install to skip or avoid installing the huge default installation??

    If it is so, that makes the download size up to 3.19GB may include installed sizes too.

     

    Notes: 

    Window is running 7 x32 if that matters since you stated yours running win10

    Homunculus S and sql read

    in Rejected

    Posted

    Yes. Well the case would be npc script which grant player skill

    with call homunculus and rest resurrect homunculus.

    And rathena always make reset skill added by script command

    Eg. skill "bash",1; by npc script to archer

    Then after status change that skill is gone.

    And so I wish for an npc script to clean out leftover

    In table char, skill_homunculus,

    if linked homunculus non-exists anymore.

    Then @makehomun or by skill can create homunculus again.

    Homunculus S and sql read

    in Rejected

    Posted

    Sir your script is superb. And there is something stuff came up.

    Sometimes if homunculus is owned by profession other than alchemist,

    Sql data related to the homunculus is not deleted

    in table char and skill_homunculus, when delete or somehow.

    So I was hoping if there is way to clean not existing homunculus data in the db by script or not?

    Homunculus S and sql read

    in Rejected

    Posted · Edited by utofaery

    Thank you for your helping hand,  Aleos.

     

     

    prontera,154,182,4 script SQLTest 90,{
query_sql "SELECT `prev_class` FROM `homunculus` WHERE `char_id` = "+getcharid(0)+" LIMIT 1", .@prev_class;
if (.@prev_class == gethominfo(1) ) {
mes .@prev_class+" "+gethominfo(1);
close;
}
else
{
mes .@prev_class;
mes gethominfo(1);
close;
}
}
     

    Now everytime I talk to that npc it shows something like:

     

    [Warning]: Unexpected type for argument 1. Expected string.
[Debug]: Data: variable name='.@prev_class' index=0
[Debug]: Function: mes
[Debug]: Source (NPC): SQLTest at prontera (154,182)
[Warning]: Unexpected type for argument 1. Expected string.
[Debug]: Data: number value=6009
[Debug]: Function: mes
[Debug]: Source (NPC): SQLTest at prontera (154,182)

    Homunculus S and sql read

    in Rejected

    Posted

     

    You can already do this. Just do a query on the 'homunculus' table and grab the `prev_class` to get the ID of the homunculus' previous class.

     

    Sir if you will please give me example on how I would do that.

    I am not good at all at sql than I could create npc script which sell stuff.

    Something like

    I have trigger the npc script then script checks

    for my homunculus prev_class through query_sql

    then the script would go on

    if prev_class a then action 1 ...

    Homunculus S and sql read

    in Rejected

    Posted

    Well here goes.

     

    I was hoping there could be something like read

    homunculus S previous form before mutation

    so that I could make quest script from that.

     

    Eg. Bayeri  from  Amistr

    And so on.

     

    Will be glad if this can be added in thank you.

    setcart function unequip remove item baselevel

    in Scripting Support

    Posted

    1

    So I was trying to make an equip,

    which give cart 1-5 base on Baselevel's range when equipped.

    function to be called from onequip script

    function header

    ｛

    if (baselevel ＜= 40) setcart 1;

    if (baselevel ＜= 65) setcart 2;

    if (baselevel ＜= 80) setcart 3;

    if (baselevel ＜= 90) setcart 4;

    if (baselevel ＜= 99) setcart 5;

    return;

    ｝

    How should I make it to be

    range level1 till level40 get cart1

    range level41 till level 65get cart 2

    and so on?

    2

    over the unequip script field

    what should I code in to make it remove any cart? ｛setcart;｝ or ｛setcart 0;｝

    doesn't work or do they?

    H>Job name in korean and ascii

    in Client Requests

    Posted · Edited by utofaery

    Here's the thing.

    Desktop I am using were installed with east asian language pack.

    and I cant change the language shown in Regional and Language.

    Deepfreeze is installed so any changes will be wipe out once restarted.

    Therefore anybody would be so kind to give me,

    korean name of job in data folder

    I can view korean text but unbollox convert to weird chinese word thanks.

    Choosing Desktop Parts

    in Off Topic

    Posted

    Thanks for providing suggestion over how I should choose now I can use my hard earn money to buy one PC...

     

    What about the cooling option is it really require since weather here are usually rainy and sunny (tropical country).

     

    How long should I keep PC up and running then put it to a rest and start running again?

    Choosing Desktop Parts

    in Off Topic

    Posted

    I was planning on getting a new desktop but I need help and suggestion about what kind of parts should I choose.

    The Desktop would run

    window XP

    but I was wondering about the processor, motherboard and ram that would do best to run ragnarok?

    Not server but client.

    Q > portablity of rathena?

    in Installation Support

    Posted · Edited by utofaery

    RaSql sometimes failed to remove virtual drives.

    like now I got drive z

    <this happens when heidiSql failed to start at first run>

    <should I wait for it to initialized at first run?>

    and mysql runs at drive y

    <stop mysql batch files only removes drive y>

    <so what should I do if it doesn't remove drive z?>

    Q > portablity of rathena?

    in Installation Support

    Posted

    Is there any way to find portable sql for use with rathena?

    Coz I could only use rathena on deepfreeze enabled computer.

    you can use rathena on linux or windows base pc, its nothing to do with deepfreeze

    If you SQL is on the web, your rathena folder already is portable. (i guess)

    @Thanna

    What I really mean is that if I restart my pc,

    then Deepfreeze flush all modifications away so I need portable mysql or something alike.

    @rafoka

    What I really want is Portable SQL,

    because it's a headache adding all the sql db again and again.

    After each restart deepfreeze flush all changes away.

    And I can't put anything on pc except usb drive.

×
×
  • Create New...