jaBote

Open the client with a hex editor, look for the string, then change it manually. It isn't way too hard but may be somewhat difficult if you haven't ever hexed anything. I suggest you to give it a try yourself. IDK what hex editors are currently in use, I still use XVI32 which is still good in my opinion. Here is its official webpage for download: http://www.chmaas.handshake.de/delphi/freeware/xvi32/xvi32.htm

I think that's not possible at the moment, but if you like you could make the US server as a proxy that connects to your Germany server quite quickly. I don't know how to make proxies yet so I still can't be of help on that matter. Sorry!

I don't know if either that item is bound or has a card compounded on a slot that is supposed not to be open.

Yeah, yommy is right, your account rates are 0 ATM so you won't get any exp or drops unless you either update that manually or update your whole server (including the SQL). About the announce, it can be disabled if you get your account rates back to normal (100) on the SQL table or, if you want to disable that for everyone no matter what their rates are, just disable that announce on /src/map/pc.c, line 10296 (don't forget to recompile!)

2 fully separate servers that use the same clients? Then it's on your clientinfo.xml, on your clientside, just duplicate everything inside the connection tag and edit whatever you like: <?xml version="1.0" encoding="euc-kr" ?><clientinfo><servicetype>korea</servicetype><servertype>sakray</servertype> <connection> <display>Ragnarok</display> <balloon>your first server</balloon> <desc>1st server</desc> <address>127.0.0.1</address> <port>6900</port> <version>26</version> <langtype>1</langtype> <registrationweb>flux.domain.com</registrationweb> <aid> <admin></admin> </aid> <loading> <image>loadingscreen01.jpg</image> </loading> </connection> <connection> <display>Ragnarok 2</display> <balloon>Your 2nd server</balloon> <desc>2nd server</desc> <address>192.168.1.1</address> <port>6900</port> <version>26</version> <langtype>1</langtype> <registrationweb>flux.domain.com</registrationweb> <aid> <admin></admin> </aid> <loading> <image>loadingscreen01.jpg</image> </loading> </connection></clientinfo>

Nobody tested...

Yeah, I know, but that's the client side, not the server side.

About that last thing, I think it's a serious name. Since I don't have access to script_commands.txt ATM, could you see if there's a way of destroying that map with the instance? Otherwise, maybe a bug weport should be filled out regarding this.

Well, you need to do that kind of workarounds for quite a lot situations on current scripting that I think they are quite more urgent than this (e.g. get an online user list, you have it as @command but no current scripting command does that without a SQL query, this is still missing since eAthena). I don't know where the problem is. Maybe you can mark the map with the src4instance mapflag and you'll possibly not need to do something like this, or you can even improve my example so that you won't get any errors: OnInit: set .next_i, 0; set .max_instance, 100; // I doubt there'll be 100 active instances on the server, so we'll reuse numbers and our map names won't be enormous due to the numbers // BlahblahblahOnMyInstanceStart: set .next_i, .next_i + 1; if (.next_i >= .max_instance) set .next_i, 0; // Blahblahblah

Get a var that is distinct for wach new party on the instance. For example: set .@i, 0;while (.@map$ == "") { // will fail until it finds a valid i, warning: possibility of getting lots of errors. set .@map$, instance_attachmap("1@farm", .@instance,1, "via" + .@i); set .@i, .@i + 1;} There are other cleaner methods to do this, but this one should work.

Maybe you have to remove it client-side? I'm sorry but I don't know neither if it's a client-side delay now how to remove it in that case.

So try that, make a mob have MvP exp > 0. Sorry for being brief but I'm on my cellphone.

For making a mob that is considered mvp: just set mvp exp greater than 0 on mob db.

Calculate the md5 hash for your client. For example, here: http://onlinemd5.com/ You'll get a file checksum for md5. Then simply copy that checksum on your configuration.

Most users don't know source editing. I don't myself, so I can't help you on this ATM. Hope someone else comes by and actually help you.

Yes, it is possible, but your server will only work within your LAN. Simply set your servers IP to your LAN IP and distribute a client that points to your LAN IP. Beware your LAN IP will sometimes change, thus making your users unable to connect unless you change your IP and make all the clients have the same IP and so...

You could delete its row (identified by Account ID on the `login` table), but all the rest of characters will still remain on the server without being wiped.

This means you still have to get a fresh copy of Hercules, but this does convert your rAthena MySQL databases to the format Hercules emulator expects to find, thus avoiding critical errors on runtime. As a side announcement, the main database converter has been updated with a query that deletes every row on the sc_data table (TRUNCATE TABLE) for safety purposes, since some status IDs are not the same in rAthena. This means all status changes recorded on that table will be gone, even for jailed users! Feel free to comment that query and preserve the status changes at your own risk. Thanks to awesome Yommy for reminding me of that! P.S.: it hasn't been that much of a hassle to release it since I already had that done, I just needed to revise it a bit and add the bank_vault saving query since rAthena has it on a different table than ours.

Quite awesome release. Thanks Neo! P.S.: Finding NEMO.

* 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 *

Haven't tested. It's supposed that, by doing that, the script will do something like this for you: @unloadnpcfile path/to/npc.txt@loadnpc path/to/npc.txt You specify the path to the NPC by yourself.

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!

yeah, unless you get update conflicts. In that case you'll have to resolve them manually.

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;}

Para ayudar estoy. Mi conocimiento por desgracia es limitado, así que es posible que no tenga respuesta para preguntas muy específicas, aunque tengo un par de compañeros hispanohablantes en este foro que se pasan y dan soporte también con cierta frecuencia. Aquí doy soporte en todo el foro, en inglés y español (y a veces en portugués) dada mi posición, aunque generalmente lo hago en el campo de mi especialidad (los scripts) y otras cosas básicas. Hercules y rAthena no somos comunidades enemistadas ni nada de eso: yo también doy soporte en rAthena (únicamente en la sección hispana) debido a que considero primordial impulsar el uso de estas comunidades frente a las grandes comunidades hispanas de RO (que para mi gusto lo que hacen es acumular guías viejas que no sirven en gran parte de las ocasiones). Simplemente iba a comentar que si no encuentras una respuesta aquí sobre scripts o cliente, las respuestas que te puedan dar a través del soporte de rAthena son ~95% compatibles con Hercules. Además, he de admitir que la comunidad hispana en rAthena es algo más activa que la de Hercules y que su moderador hispano, Ziu, es todo un hacha en lo que se refiere a dar soporte sobre clientes (aunque @M45T3R, el moderador hispano en Hercules tampoco es nada malo en cuanto a clientes). ¡Un saludo y me alegro de haber sido de ayuda!