Dastgir

ROratiorio's CalcX, they have note on aboveThis calculator appears to be growing obsolete due to lack of updates,please head over to http://calc.irowiki.org for better results! About irowiki Calculation:Hercules follow kRO. iRO and kRO may have different calculation due to difference in their episodes or other things.. lets wait for core dev to confirm.

Added at v1.2

#Event_Points are the variables that are Account Bounded and not Character bounded. and a Account contains minimum 9 characters.. So how can I display a specific player name? Or get any chracter name from that account?

After viewing the packets, I see there is no 20140212 Packets. (don't know if previous and that client packets are same or not) 2014 Client Packets that are already in repo: 201401152014020520140305 I haven't tested 20140305, but 2014-02-05 works fine.

its not SQL fault, its mob_skill_db.sql fault, if it was Large File Error, it would have shown that error , not SYNTAX ERROR(#1064). Try to use files from this, https://github.com/dastgir/Hercules/tree/mob_skill_db/sql-files and check if you error (I don't get error with some fixes in the file that is pushed to that repo) On the Other hand, one can use PhpMyAdmin's Import function too for importing files, instead of copy-pasting the contents.

Can you show us the query? since I cannot find that query on line 86 How I can show it to you if I am using phpMyAdmin? Can you show us mob_skill_db.sql, I think you told that is the one you are importing..

Can you show us the query? since I cannot find that query on line 86

Yeah, I still don't get it, how I can check the server version. Those servers check those list, disable all npc's beyond that episode, and says that they are on episode x.y

have you changed PACKETVER? (src/common/mmo.h) and have you disabled Packet Encryption? then please check if value of packet_obfucation is proper (conf/battle/client.conf) // Whether to enable the official packet obfuscation support (good vs WPE)// 0: disabled// 1: optional (not recommended) -- identifies whether it is required// 2: enabled (recommended)packet_obfuscation: 1

#Event_point and #T_Event_Point are account variables, so what should be displayed on ranking along with those variables values?

You can check episode list here: http://herc.ws/board/topic/3554-ragnarok-episode-timeline/

why want packet lengths? botting?

first of all, I posted the script part,2) can you tell exact variable, you told #Event_Points on first line and Event_Point on second line.

You can use search function always...(http://herc.ws/board/topic/5363-item-dbconf-to-item-dbtxt/) Follow Dastgir's link. @mysterious, I think he meant, can server read txt files. @Azul, Emulator don't read txt.. but you can convert conf to txt via (http://herc.ws/board/topic/5363-item-dbconf-to-item-dbtxt/) and then convert it back to conf when you are done with editing via (https://github.com/HerculesWS/Hercules/blob/master/tools/itemdbconverter.pl) or (http://haru.ws/hercules/itemdbconverter)

Some SQL Query to help: Delete atcommandlog and other logs older than 1 month: (2592000 = (60sec*60min*24hours*30days)) DELETE FROM `atcommandlog` WHERE UNIX_TIMESTAMP(`atcommand_date`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `picklog` WHERE UNIX_TIMESTAMP(`time`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `zenylog` WHERE UNIX_TIMESTAMP(`time`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `branchlog` WHERE UNIX_TIMESTAMP(`branch_date`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `mvplog` WHERE UNIX_TIMESTAMP(`mvp_date`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `npclog` WHERE UNIX_TIMESTAMP(`npc_date`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `chatlog` WHERE UNIX_TIMESTAMP(`time`)<(UNIX_TIMESTAMP(NOW())-2592000);DELETE FROM `loginlog` WHERE UNIX_TIMESTAMP(`time`)<(UNIX_TIMESTAMP(NOW())-2592000);

It doesn't do that, You might have to setup external scripts for that.

OnRanking: mes "[Ranking System]"; query_sql "SELECT `char_reg_num_db`.`value`,`char`.`name` FROM `char` INNER JOIN `char_reg_num_db` ON `char_reg_num_db`.`char_id`=`char`.`char_id` WHERE `char_reg_num_db`.`key`='Event_Point' ORDER BY `char_reg_num_db`.`value` DESC LIMIT 10",.@value,.@name$; for (.@i=0; .@i<getarraysize(.@value); .@i++){ mes (.@i+1)+".) ["+ .@name$[.@i] +"] - "+ .@value[.@i]; } deletearray .@name$[0],10; deletearray .@value$[0],10; close; if the variable is Event_Point, this would work.

It can be as big as your hard disk capacity (i.e until your hd space runs out)P.S: Those tables are not read only, server writes in it too.

in rA, strcmp: *strcmp("<string>","<string>")This command compares two strings are returns a value: 1: string 1 > string 2 0: strings are equal -1: string 1 < string 2 and in the script, it checks for 0, so we can directly compare . and about getserverdef, we have it other way round, we directly define constant : https://github.com/HerculesWS/Hercules/commit/950e3ebcdbbde96b090fa681ce88ecf4069f2f64 (Implemented in this commit)

Change Following Things:(I have not seen script, but just saw your error in console) - if ( !strcmp(strnpcinfo(0), .npc_name$) ) {+ if ( .npc_name$ == strnpcinfo(0) ) { - .server_max_level = getserverdef( VAR_MAX_LEVEL ); + .server_max_level = MAX_LEVEL;

int pc_additem(struct map_session_data *sd,struct item *item_data,int amount,e_log_pick_type log_type){ struct item_data *data; int i; unsigned int w; nullpo_retr(1, sd); nullpo_retr(1, item_data); if( item_data->nameid <= 0 || amount <= 0 ) return 1; if( amount > MAX_AMOUNT ) return 5;+ + if ( !pc_get_group_level(sd) &&+ ( item_data->nameid == 512 || item_data->nameid == 7227 )+ ){+ return 1;+ } data = itemdb->search(item_data->nameid); if( data->stack.inventory && amount > data->stack.amount ) {// item stack limitation return 7; } It would not add the item to inventory..

You should have https://github.com/ROClientSide/Translation/tree/master/Data/luafiles514/lua%20files/quest/ Folder. IF you are using 2013 client then use this quest_function.lub: https://github.com/ROClientSide/Translation/blob/master/Data/luafiles514/lua%20files/quest/2013/quest_function.lub

Update your kRO. OR Extract this imf.rar to data/imf/

Get Translated "System/itemInfo.lua" https://raw.githubusercontent.com/ROClientSide/Translation/master/System/itemInfo.lua

dunno the reason why when I modify the max_level 175 to 1000 plug-in will crash map server I don't think modifying the max_level would make plug-in crash map-server, can you provide core-dump?