Introducing rAthena to Hercules database converters.

J

jaBote

Community Contributors
Messages
2,037
Points
0
Github
jaBote
* 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!

* jaBote switches off @Ind mode *

 
Last edited by a moderator:
nice +999999999 to this
default_smile.png


 
Nice release Jabote! Thank you for taking the time on creating this converter for the community!

 
does this mean that we can convert our exsisting rathena to hercules without the need of installing a fresh copy?

 
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.

 
oh that great.

but is there and facility for converting my existing rathena into Hercules 

 
i tried to convert, all @autotrade merchant is still vending but without cart.  Did i miss something or this is normal?

 
It's a converter issue. Currently all `sc_data` gets pruned because of a safety measure, since rAthena SC IDs aren't the same as ours. Since carts are SCs, all merchants will have their carts released, much like Knights Peco Pecos or Hunters Falcons. Even people in Jail (SC_JAILED) get free, but there's currently no way to help with that. Think that, if we kept the current SC IDs, maybe you could permanently give SC_CASH_RECEIVEITEM (double exp rate for the user who has it) to someone that was jailed, for example (didn't check the numbers, this is just an exaggeration).

Will discuss with the rest of the staff for a way to get the most SCs as possible saved.

 
Last edited by a moderator:
Update on this matter sir? thank you so much....

Because i really have errors.. convert rathena to hercules.

 
You must log in or register to reply here.
Back
Top