Introducing rAthena to Hercules database converters.

[jaBote 438]

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

Edited February 7, 2017 by Ridley

[icabit 4]

nice +999999999 to this

[Mystery 594]

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

[pr3p 39]

Awesome +10   nice release Jabote

[ossi0110 200]

well done jaBote

[themon 63]

Now more user will switch from rathena to hercules. +1

[SSky 2]

this is very helpful. ^^

[orange 4]

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

[jaBote 438]

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.

[orange 4]

oh that great.

 

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

[blackberie 0]

do you have opposite? hercules to rathena

[Mystery 594]

do you have opposite? hercules to rathena

Nah. We only have from eAthena / rAthena to Hercules. 

[karazu 33]

+1

[astralprojection 35]

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

[jaBote 438]

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.

[khael22 0]

Update on this matter sir? thank you so much....

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