Mumbles

Hi.
 
Are you trying to make a direct upgrade from rAthena to Hercules by running our upgrades on top of a rAthena database? This doesn't work that way.
 
Try to get your rAthena database to its original state, then make a backup and work on the backup. Try using these upgrades I've just revised:
 
This one for the main database upgrade:
-- rAthena to Hercules main database upgrade query.-- This upgrades a FULLY UPGRADED rAthena to a FULLY UPGRADED Hercules-- Please don't use if either rAthena or Hercules launched a SQL update after last revision date of this file.-- Remember to make a backup before applying.-- We are not liable for any data loss this may cause.-- Apply in the same database you applied your main.sql-- Last revision: November 10, 2013, 19:00-- Drop table `skillcooldown` since it's not used in HerculesDROP TABLE IF EXISTS `skillcooldown`;-- Upgrades for table `cart_inventory`ALTER TABLE `cart_inventory` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';-- Upgrades for table `char`ALTER TABLE `char` DROP COLUMN `moves`, ADD `slotchange` SMALLINT(3) UNSIGNED NOT NULL default '0', ADD `char_opt` INT( 11 ) UNSIGNED NOT NULL default '0', ADD `font` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0';-- Upgrades for table `guild_storage`ALTER TABLE `guild_storage` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';-- Upgrades for table `inventory`ALTER TABLE `inventory` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';---- Table structure for table `sql_updates`--CREATE TABLE IF NOT EXISTS `sql_updates` ( `timestamp` int(11) unsigned NOT NULL, `ignored` enum('Yes','No') NOT NULL DEFAULT 'No', PRIMARY KEY (`timestamp`)) ENGINE=MyISAM;-- Existent updates to enterINSERT INTO `sql_updates` (`timestamp`) VALUES (1360858500);INSERT INTO `sql_updates` (`timestamp`) VALUES (1360951560);INSERT INTO `sql_updates` (`timestamp`) VALUES (1362445531);INSERT INTO `sql_updates` (`timestamp`) VALUES (1362528000);INSERT INTO `sql_updates` (`timestamp`) VALUES (1362794218);INSERT INTO `sql_updates` (`timestamp`) VALUES (1364409316);INSERT INTO `sql_updates` (`timestamp`) VALUES (1366075474);INSERT INTO `sql_updates` (`timestamp`) VALUES (1366078541);INSERT INTO `sql_updates` (`timestamp`) VALUES (1381354728);INSERT INTO `sql_updates` (`timestamp`) VALUES (1381423003);INSERT INTO `sql_updates` (`timestamp`) VALUES (1382892428);INSERT INTO `sql_updates` (`timestamp`) VALUES (1383162785);INSERT INTO `sql_updates` (`timestamp`) VALUES (1383167577);INSERT INTO `sql_updates` (`timestamp`) VALUES (1383205740);INSERT INTO `sql_updates` (`timestamp`) VALUES (1383955424);-- Updates to table `storage`ALTER TABLE `storage` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', MODIFY `bound` tinyint(1) unsigned NOT NULL default '0';---- Table structure for table `account_data`--CREATE TABLE IF NOT EXISTS `account_data` ( `account_id` int(11) unsigned NOT NULL default '0', `bank_vault` int(11) unsigned NOT NULL default '0', `base_exp` TINYINT( 4 ) UNSIGNED NOT NULL default '100', `base_drop` TINYINT( 4 ) UNSIGNED NOT NULL default '100', `base_death` TINYINT( 4 ) UNSIGNED NOT NULL default '100', PRIMARY KEY (`account_id`)) ENGINE=MyISAM; -- Saving bank_vault data from rAthena's login table-- to our account_data table. There may be some not working cases.INSERT INTO `account_data` (`account_id`, `bank_vault`) SELECT `account_id`, `bank_vault` FROM `login` WHERE `bank_vault` > 0 ;-- Dropping bank_vault column from login tableALTER TABLE `login` DROP COLUMN `bank_vault`; upaste.me mirror: http://upaste.me/7fbc8490ebb57a6a
 
 
And this one for the logs database:
-- rAthena to Hercules log database upgrade query.-- This upgrades a FULLY UPGRADED rAthena to a FULLY UPGRADED Hercules-- Please don't use if either rAthena or Hercules launched a SQL update after last revision date of this file.-- Remember to make a backup before applying.-- We are not liable for any data loss this may cause.-- Apply in the same database you applied your logs.sql-- Last revision: November 10, 2013, 19:00-- Upgrades to table `picklog`ALTER TABLE `picklog` MODIFY `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U') NOT NULL default 'P';-- Drop table `cashlog` since it's not used in HerculesDROP TABLE IF EXISTS `cashlog`; upaste.me mirror: http://upaste.me/a011849121f6f38c
 
Hope this helps you!

* jaBote switches on @Ind mode *
 
rAthena to Hercules database converters
 
Hello~! What?!
I've observed a big rise of rAthena to Hercules database conversion requests this week, so I've just revised again the converters I made before and will be releasing on the repository so that people can find them more easily. What does that do?
We have two new .SQL files on our repository that make the conversion easy. One is for applying on the main ragnarok table (sql-files/rathena-main-upgrade.sql) and the other is for the logs one (sql-files/rathena-logs-upgrade.sql).Please remember to make a backup prior to converting the database, just in case something goes wrong. This is meant to convert a fully upgraded rAthena to a fully upgraded Hercules. If you have some uninstalled rAthena upgrades please install them first. Avoid using it if there has been an upgrade posted in rAthena newer than the date of the converter or, at least, you didn't apply it or know how to undo the changes (remember that main.sql is usually fully upgraded both in Hercules and in rAthena). Some data (especially the data we don't use here on Hercules may be lost on the conversion). We'll not be resposible for this. How does it work?
Plain and simple: just load them on the respective databases you have in rAthena, as if they were the original main.sql or logs.sql. Obviously enough, they won't work if you don't have CREATE, ALTER, INDEX and DROP permissions (and maybe others too) for the user(s) you'll be running this. These converters will NOT work if you changed the table names. Special thanks
rAthena staff for their database structure and upgrades. Hercules staff for the database structure and upgrades. All the users that requested the converters in their respective topics. for suggesting this to be committed to the repository. @Haru for last minute corrections. Disclaimer
As I warned before, there may be some intended or unintended data loss. Please make a backup before applying. This may get outdated quite quicly without me noticing about that. If that's so, please make a pull request or ping me to update the converter when I have time. I've avoided to name the files as "upgrades" here on the topic, but I've named them like that to make them have the name structure as the eAthena upgrade. This is NOT an offense to rAthena staff by any means. People are requesting this, so I made the conversion process easy for them, much like rAthena made a converter from eAthena and nobody got offended. Just that. Links~u!
Main database converter commit. Logs database converter commit. * jaBote switches off @Ind mode *

The last time I checked, colour-coding signified hidden socket enchantments or broken equipment.
 
Knife - 1 hidden socket
Knife - 2 hidden sockets
Knife - 3 hidden sockets
Knife - 4 hidden sockets
Knife - broken
 
 
What's a "hidden socket?"
A hidden socket is a socket (commonly known as a "card slot") that has been enchanted and/or is not shown on the client data as having that many enchantable sockets. For example, if you have a Knife [0] with a card or enchantment, its name may turn lime or turquoise. These types of items are usually obtained by faulty/deliberate scripts that enchant into nonexistent sockets or an outdated slotcounttable.txt in your data folder or GRF.

You can run the following command:
YourClient.exe -Replay or make a bat file(if you want players to use it) inside your RO folder.
 
@echo off cd /d "%~dp0" start YourClient.exe -Replay exit  

you could make a script for that
 
- script reloadnpcfile -1,{OnInit: bindatcmd "reloadnpcfile",strnpcinfo(3)+"::OnAtcommand"; end;OnAtcommand: if (getgmlevel() < 99) end; atcommand "@unloadnpcfile " + .@atcmd_parameters$[0]; atcommand "@loadnpc " + .@atcmd_parameters$[0]; message strcharinfo(0), "NPC file " + .@atcmd_parameters$[0] + " reloaded if you didn't get any problem with the other commands. AVOID RELOADING ANY MOBS OR MAPFLAGS WITH THIS COMMAND."; end;}

The command @killmonster2 <map name> is not working..
 
Instead of using the command @killmonster2 <map name>, use killmonsterall instead.
 
 
*killmonsterall "<map name>"{,<type>};This command will kill all monsters on a specified map name, regardless of how they were spawned or what they are without triggering any event label attached to them, unless you specify 1 for type parameter. In this case, mob death labels will be allowed totrigger when there is no player. Any other number for this parameter won't be recognized. 

http://rathena.org/board/topic/74196-walkable-and-talkable-npc/?p=155955
 
try  Annie's script
 
 
prontera,156,177,5  script  kdjfhkshf2  100,{  end;OnInit:  .@interval = 5;  .@step = 5;  while (1) {    sleep .@interval * 1000;    getmapxy .@map$, .@x, .@y, 1;    while ( checkcell( .@map$, .@npc_x = .@x + rand( -.@step, .@step ), .@npc_y = .@y + rand( -.@step, .@step ), cell_chknopass ) );      npcwalkto .@npc_x, .@npc_y;      npctalk callfunc( "F_RandMes", 2,      "I'm talking.", // 1      "Hello!" // 2    );  }  end;}

Olrox is definitely gonna like that Poring .
it looks good but then again I'm no expert to figure out the intricate details .
 
 
if thats bad english i welcome it

Sample ( a shop selling poring card for 500 zeny and fabre card for 1000 zeny ) :
prontera,150,150,0 shop Sample 100,4001:500,4002:1000 Reference ( https://raw.github.com/HerculesWS/Hercules/master/doc/script_commands.txt ) : 
** Define a shop/cashshop NPC.-%TAB%shop%TAB%<NPC Name>%TAB%<sprite id>,<itemid>:<price>{,<itemid>:<price>...}<map name>,<x>,<y>,<facing>%TAB%shop%TAB%<NPC Name>%TAB%<sprite id>,<itemid>:<price>{,<itemid>:<price>...}This will define a shop NPC, which, when triggered (which can only be doneby clicking) will cause a shop window to come up. No code whatsoever runsin shop NPCs and you can't change the prices otherwise than by editing thescript itself (no variables even exist at this point of scripting, sodon't even bother trying to use them).The item id is the number of item in the 'item_db.txt' database. If Priceis set to -1, the 'buy price' given in the item database will be used.Otherwise, the price you gave will be used for this item, which is how youcreate differing prices for items in different shops.You can alternatively use "cashshop" in place of "shop" to use the CashShop interface, allowing you to buy items with special points (Currentlystored as account vars in global_reg #CASHPOINTS and #KAFRAPOINTS). Thistype of shop will not allow you to sell items at it, you may only purchaseitems here. The layout used to define sale items still count, and"<price>" refers to how many points will be spent purchasing the them.

Set use_md5_passwords to yes in conf/login-server.conf:
// Store passwords as MD5 hashes instead of plaintext ?// NOTE: Will not work with clients that use <passwordencrypt>use_MD5_passwords: yes  
If you've already done this and are still experiencing errors, execute sql-files/tools/convert_passwords.sql in your main schema to convert your existing passwords into MD5 hashes.

Try adding this somewhere:
delwall "Wall Name";  
 
Here's the documentation for setwall and delwall: http://herc.ws/wiki/Setwall

Hello.
 
Some status change names were changed some months ago, so some items may not work.
 
Here's an online comparison between old and new status change names I made at that time (and it's still mostly valid) so that people can compare what's the new and old names for them: http://www.diffnow.com/?report=kze0y New name is on the left, old names are on the right.
 
Just try to fix the SC names on your NPC by changing the names that appear on the right to the ones that appear on the left.
Please remember that using an old/invalid SC name will make its value default to 0, which means stone curse by that list.
 
Hope I helped you.

you can edit the statspoins per lvl in the statpoint.txt file
 
https://github.com/HerculesWS/Hercules/blob/master/db/re/statpoint.txt

what does each line represents/means ?
starting from 48 down to 6058?
 
 
Edit: AH ok.... I got it//// thanks +1

in: npc/custom/jobmaster.txt
Search line:
set .ThirdClass,1;    // Enable third classes? (1: yes / 0: no)
Change for:
set .ThirdClass,0;    // Enable third classes? (1: yes / 0: no)

Yes
- script autobuffs -1,{OnPCLoginEvent: addtimer 60000,"autobuffs::OnBuffs"; end;OnBuffs: sc_start SC_INC_AGI,240000,10; sc_start SC_BLESSING,240000,10; specialeffect2 EF_INCAGILITY; specialeffect2 EF_BLESSING; addtimer 60000,"autobuffs::OnBuffs"; end;}

Just set a map with the gvg mapflag, either with the setmapflag or the gvgon and gvgoff script commands:
 
*gvgon "<map name>";*gvgoff "<map name>";These commands will turn GVG mode for the specified maps on and off, setting up appropriate map flags. In GVG mode, maps behave as if during the time of WoE, even though WoE itself may or may not actually be in effect.  
Or you can even use the GM commands @gvgon or @gvgoff ingame on the same map if you want.

The problem is that your  Hercules server is not updated.
 
your Item DB use the NEW Format for itemskills , but your server want the old format.
 
 
just update your server to latest rev and compile him and all should work fine
 
 
here you can see what files have changed in the commit
 
https://github.com/HerculesWS/Hercules/commit/e3d71d9455de45d5a9417dbebd74aa49a0e7ae6a

Its 2 totally different things.
you can check the comparison of Git and SVN 
https://git.wiki.kernel.org/index.php/GitSvnComparison
Discussion: http://stackoverflow.com/questions/871/why-is-git-better-than-subversion

Maybe this can help you a bit:
http://git-scm.com/book/en/Getting-Started-Git-Basics
 
Also, I must note the fact that you can actively participate on the emulator's development when using Git, by sending pull requests via Github. Check this guide!

Go to src/config. Open renewal.h . 
look for 
 
and change to (quote it)
 
 
Then go to trunk/conf/battle/skill.conf
look for this
 Change 150 to your desired Dex. 

Then recompile

http://herc.ws/wiki/Packets#0x7f5

I've reached a very similar SQL to yours, please compare and remember to make a backup before applying (I haven't tested them but there shouldn't be problems):
 
-- rAthena to Hercules main database upgrade query.-- Please don't use if too outdated.-- Remember to make a backup before applying.-- Apply in the same database you applied your main.sql-- Last revision: November 2, 2013-- Drop table `skillcooldown` since it's not used in HerculesDROP TABLE IF EXISTS `skillcooldown`;-- Upgrades for table `cart_inventory`ALTER TABLE `cart_inventory` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', DROP COLUMN `bound`;-- Upgrades for table `char`ALTER TABLE `char` DROP COLUMN `moves`, ADD `slotchange` SMALLINT(3) UNSIGNED NOT NULL default '0', ADD `char_opt` INT( 11 ) UNSIGNED NOT NULL default '0', ADD `font` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0';-- Upgrades for table `guild_storage`ALTER TABLE `guild_storage` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', DROP COLUMN `bound`;-- Upgrades for table `inventory`ALTER TABLE `inventory` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', DROP COLUMN `bound`;---- Table structure for table `sql_updates`--CREATE TABLE IF NOT EXISTS `sql_updates` ( `timestamp` int(11) unsigned NOT NULL, `ignored` enum('Yes','No') NOT NULL DEFAULT 'No', PRIMARY KEY (`timestamp`)) ENGINE=MyISAM;-- Existent updates to enterINSERT INTO `sql_updates` (`timestamp`) VALUES (1360858500);INSERT INTO `sql_updates` (`timestamp`) VALUES (1360951560);INSERT INTO `sql_updates` (`timestamp`) VALUES (1362445531);INSERT INTO `sql_updates` (`timestamp`) VALUES (1362528000);INSERT INTO `sql_updates` (`timestamp`) VALUES (1362794218);INSERT INTO `sql_updates` (`timestamp`) VALUES (1364409316);INSERT INTO `sql_updates` (`timestamp`) VALUES (1366075474);INSERT INTO `sql_updates` (`timestamp`) VALUES (1366078541);INSERT INTO `sql_updates` (`timestamp`) VALUES (1381354728);INSERT INTO `sql_updates` (`timestamp`) VALUES (1381423003);INSERT INTO `sql_updates` (`timestamp`) VALUES (1382892428);INSERT INTO `sql_updates` (`timestamp`) VALUES (1383167577);-- Updates to table `storage`ALTER TABLE `storage` MODIFY `equip` INT(11) UNSIGNED NOT NULL default '0', DROP COLUMN `bound`;---- Table structure for table `account_data`--CREATE TABLE IF NOT EXISTS `account_data` ( `account_id` int(11) unsigned NOT NULL default '0', `bank_vault` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`account_id`)) ENGINE=MyISAM; uPaste.me mirror: http://upaste.me/7fbc8490ebb57a6a 
Also, even if not needed, here's the log upgrade query:
-- rAthena to Hercules log database upgrade query.-- Please don't use if too outdated.-- Remember to make a backup before applying.-- Apply in the same database you applied your logs.sql-- Last revision: November 2, 2013-- Upgrades to table `picklog`ALTER TABLE `picklog` MODIFY `type` enum('M','P','L','T','V','S','N','C','A','R','G','E','B','O','I','X','D','U','$') NOT NULL default 'P';-- Drop table `cashlog` since it's not used in HerculesDROP TABLE IF EXISTS `cashlog`;uPaste.me mirror: http://upaste.me/a011849121f6f38c 
Hope it's useful.

goto skill_db.txt then find the skill you want to disable then add // before the skill id

Or, if you want to disable skills on certain maps only, you could do that in your map_zone_db.conf file: db/pre-re/map_zone_db.conf for pre-renewal servers or db/re/map_zone_db.conf for renewal servers.