Emistry

perhaps this might help? https://rathena.org/board/topic/105789-utility-sql-job-changer/

getinventorylist; for(.@i = 0; .@i < @inventorylist_count; .@i++) { for (.@r = 1; .@r <= 5; .@r++) { .@random_bonus_id_array[.@r] = getd("inventorylist_option_id"+.@r+"["+.@i+"]"); .@random_bonus_value_array[.@r] = getd("inventorylist_option_value"+.@r+"["+.@i+"]"); .@random_bonus_param_array[.@r] = getd("inventorylist_option_parameter"+.@r+"["+.@i+"]"); } if (!@inventorylist_identify[.@i]) { delitem3 @inventorylist_id[.@i], 1, 0, @inventorylist_refine[.@i], @inventorylist_attribute[.@i], @inventorylist_card1[.@i], @inventorylist_card2[.@i], @inventorylist_card3[.@i], @inventorylist_card4[.@i], .@random_bonus_id_array, .@random_bonus_value_array, .@random_bonus_param_array; getitem3 @inventorylist_id[.@i], 1, 1, @inventorylist_refine[.@i], @inventorylist_attribute[.@i], @inventorylist_card1[.@i], @inventorylist_card2[.@i], @inventorylist_card3[.@i], @inventorylist_card4[.@i], .@random_bonus_id_array, .@random_bonus_value_array, .@random_bonus_param_array; .@count++; } } if (.@count) dispbottom .@count +" items identified."; you can try like this.... you should avoid any tricks that using atcommands. Imagine if you keep a log for every single usage of atcommands in your server, your server gonna overflooded with unnecessary logs.

.@aid = getcharid(3); getpartymember getcharid(1), 2; .@count = $@partymembercount; copyarray(.@pt_aid, $@partymemberaid, .@count); for (.@i = 0; .@i < .@count; .@i++) if (attachrid(.@pt_aid[.@i])) { .@total_base_lv += BaseLevel; .@count++; } attachrid(.@aid); mes "average level of your party are "+ (.@total_base_lv / .@count); close; you can try like this...

.@party_leader_aid = getpartyleader(getcharid(1), 1); if (attachrid(.@party_leader_aid)) { if (Hp < 1) { getpartymember getcharid(1), 2; .@count = $@partymembercount; copyarray(.@pt_aid, $@partymemberaid, .@count); for (.@i = 0; .@i < .@count; .@i++) if (.@pt_aid[.@i] != .@party_leader_aid) if (attachrid(.@pt_aid[.@i])) { dispbottom "Your party leader is dead."; detachrid; } } detachrid; } you can try like this...

prontera,155,181,5 script Sample#prtg_cas01 4_F_KAFRA01,{ .@gid = getcharid(1); .@map$ = strnpcinfo(2); .@guild_id = getcastledata(.@map$, 1); if (.@guild_id) { if (.@gid == .@guild_id) { mes "your guild owned this castle."; if (getcharid(0) == getguildmasterid(.@gid)) { mes "You're guild master."; } else { mes "You're guild member."; } } else { mes "Your guild doesn't own this castle."; } } else { mes "Castle aren't occupied by any guild yet."; } close; } something like this?

while (input (.@email$,5,39)); query_sql ( "UPDATE `login` SET `email` = '"+escape_sql(.@email$)+"' WHERE `account_id` LIKE "+.@accountid+"");

check if you have any npc script that give bonus statuses check if your src are edited check if your item_db are edited check if your job_db2.txt are edited

if (getequiprefinerycnt(EQI_ARMOR) > 10) downrefitem EQI_ARMOR, 1;

- script WoEScheduler -1,{ OnHour00: OnInit: disablenpc "WoECoreSystemProntera"; disablenpc "WoECoreSystemPayon"; disablenpc "WoECoreSystemGeffen"; disablenpc "WoECoreSystemAldebran"; disablenpc "WoECoreSystemArunafeltz"; disablenpc "WoECoreSystemSchwaltzvalt"; .@day = gettime(5); if (.@day == 1 || .@day == 16) enablenpc "WoECoreSystemProntera"; else if (.@day == 2 || .@day == 19) enablenpc "WoECoreSystemPayon"; else if (.@day == 4 || .@day == 22) enablenpc "WoECoreSystemGeffen"; else if (.@day == 7 || .@day == 25): enablenpc "WoECoreSystemAldebran"; else if (.@day == 10 || .@day == 28) enablenpc "WoECoreSystemArunafeltz"; else if (.@day == 13 || .@day == 29) enablenpc "WoECoreSystemSchwaltzvalt"; end; } you can try something like this.... disable it using OnInit ... and enable it whenever you need it.

OnInit: if (strnpcinfo(2) != "") end;

that's because you duplicated the main script that generate the shop. prontera,143,99,5 duplicate(Rewards) Rewards#prt 114 alberta,139,71,5 duplicate(Rewards) Rewards#alb 114 morocc,127,77,5 duplicate(Rewards) Rewards#mrc 114 geffen,97,71,5 duplicate(Rewards) Rewards#gef 114 you can fix it by adding this line under the OnInit label.. OnInit: if (strnpcinfo(1) != "") end;

prontera,155,181,5 script Sample#rent 4_F_KAFRA1,{ for (.@i = 0; .@i < .item_id_size; .@i++) if (!countitem(.item_id[.@i])) rentitem .item_id[.@i], .rental_duration; end; OnInit: .rental_duration = 3600; setarray .item_id, 5001, 5002, 5003; .item_id_size = getarraysize(.item_id); end; }

nice one ? a space station ... that's rare to see some unique idea for map nowadays ..

Hi, First of all would like to thank you @Anacondaqq for create & supporting the topic for such a long time, and answering everyone's questions as much as he can. The topic getting so popular among the members which assist them to setup their very first server. Out of curiosity, I have spent several hours to take a look into the topic for the huge amount of replies. But I stumbled when it came down to the replies made by members. There are often some members asking for help in the middle of the process to setup the server, which is great, they stay in the topic and asking relevant questions. But for the rest? They are often out of the topics and non-stop asking for repetitive questions again and again. Do you all actually know what's the purpose of this setup guide topic are made? Its to help you to setup the server, nothing else, especially customization for your server. You all shall focus on the setup issues, shouldn't be asking anything out of the topic. This topic doesn't serve to assist you to customize your server settings, change the source code and npc scripts. Ex: How to change my server EXP rate? How to add npc script, source modification? How to make it online? (seriously? did you even read the topic title?) I have seen many member asking for the same questions over and over again. These questions already have their own area to ask for it. Check the support / release forum. These forum exists to provide support for their respective categories. Kindly make use of the search feature in the forum, most of the questions that you all could think of, are most likely already asked by others and answered by someone in the past. So, use it and stop being a spoon-feed baby. Basically, the moment you manage to setup the server, and login into the game, then you're done. You've completed and successfully setup the server already, the topic has served it purpose. Anything beyond this points aren't relevant to this topic anymore, ask at the appropriate forum. So, do us a favor, ask in the correct forum for each of your questions, feel free to ask any of the moderator around if you're not sure which forum to post. Any non-relevant posts made for the topic will be removed if found. I've basically removed roughly ~20 pages of replies from this topic, lol. Thank for the time reading, and sorry for the bad english as well as if my post make any of you feel uncomfortable.

npc/custom/woe_controller.txt

store some helpful info that allow your script to check it, so that the script could tell if there already exists someone claimed it before. ex. store a value into a variable/database, and have the script check for it when another player try to claim it. sample like freebie script are your easy target for references.

- script sample -1,{ OnPCStatCalcEvent: if(countitem(7129)) { bonus bAllStats, 100; end; }

.@aid = getcharid(0); for(.@i = getarraysize(.char_id) - 1; .@i >= 0; .@i--) { if (.char_id[.@i] == .@aid) deletearray .char_id[.@i],1; } you could do it this way as well, loop from the end to the start... this way you wont need to worry to recalculate the index in case you're intend to continue removing all the duplicates data in the array.

- script sample -1,{ OnPCStatCalcEvent: if (karmapoints > 1000) bonus bCrit,10; else if (karmapoints > 2000) bonus bCrit,20; else if (Karmapoints > 300) bonus bCrit,30; end; }

he already stated you haven't purchased any single file using your current account. refer the post above. show him. no others but only admin could.

@Functor should have done it in the first place. After all, he is basically offering a third-party-services. rAthena has been too leniant with him. Its not something new that he often indirectly caused other user being scammed, and the user himself failed to do some research before get scammed by imposters. Its more like the owner doesn't even care anymore. lol Perhaps time for a change/update?

itemID,........,{ }, { changelook LOOK_HEAD_BOTTOM, callfunc("func_WingSprite", 1); }, { changelook LOOK_HEAD_BOTTOM, 0; } function script func_WingSprite { switch (BaseJob) { case Job_Knight: return (Sex) ? <wing_sprite_id_1> : <wing_sprite_id_2>; case Job_Crusader: return (Sex) ? <wing_sprite_id_1> : <wing_sprite_id_2>; case Job_Blacksmith: return (Sex) ? <wing_sprite_id_1> : <wing_sprite_id_2>; case Job_Alchemist: return (Sex) ? <wing_sprite_id_1> : <wing_sprite_id_2>; case Job_Hunter: return (Sex) ? <wing_sprite_id_1> : <wing_sprite_id_2>; case Job_Bard: return <wing_sprite_id_1>; case Job_Dancer: return <wing_sprite_id_2>; case Job_Wizard: return (Sex) ? <wing_sprite_id_1> : <wing_sprite_id_2>; case Job_Sage: return (Sex) ? <wing_sprite_id_1> : <wing_sprite_id_2>; case Job_Priest: return (Sex) ? <wing_sprite_id_1> : <wing_sprite_id_2>; case Job_Monk: return (Sex) ? <wing_sprite_id_1> : <wing_sprite_id_2>; default: return; } return; }

you need the custom src mod for the costume script command.

on duplicate key update `points` = `points` + "+rand(100,1000); on duplicate key update `points` = `points` + " + .@points;

configure the new exp needed to up the level here. db/re/job_exp.txt