Moving from eathena

[Klutz]

Hi,

I am upgrading my server from eAthena to Hercules.

I used to use sql tables on my old server.

How do i export the sql tables to Hecules txt files?

 

[Ragno]

Hi,

I am upgrading my server from eAthena to Hercules.

I used to use sql tables on my old server.

How do i export the sql tables to Hecules txt files?

Hercules doesn't use txt database, instead uses also sql db and provide two sql files for conversion:

Hercules\sql-files\upgrades\eAthena-logs-upgrade.sql

Hercules\sql-files\upgrades\eAthena-main-upgrade.sql

Both of them can be found on GitHub: https://github.com/HerculesWS/Hercules

If you want to export query sql into a txt file, I'm not used on it.

 

[Klutz]

How can i setup

Hi,

I am upgrading my server from eAthena to Hercules.

I used to use sql tables on my old server.

How do i export the sql tables to Hecules txt files?

Hercules doesn't use txt database, instead uses also sql db and provide two sql files for conversion:

Hercules\sql-files\upgrades\eAthena-logs-upgrade.sql

Hercules\sql-files\upgrades\eAthena-main-upgrade.sql

Both of them can be found on GitHub: https://github.com/HerculesWS/Hercules

If you want to export query sql into a txt file, I'm not used on it.

How can i setup the emulator to use the sql?

I couldn't find the option anywhere.

 

[Ragno]

How can i setup the emulator to use the sql?

I couldn't find the option anywhere.

Hercules uses sql as default (and only uses sql, doesn't use txt databases).

You may want to setup a new Hercules default server to explore and watch how Hercules works.

In this topic you can find a very good guide about how to install sql databases: http://herc.ws/board/topic/1574-tutorial-preparing-database-ragnarok-for-pre-compiled-hercules/

Here you can download a precompiled server: http://herc.ws/board/files/file/25-hercules-win32-for-ragexe-20130703/

And here you can find the newest version of hercules: https://github.com/HerculesWS/Hercules/

After having tested and experienced hercules, you may want to convert your sql databases from eAthena to Hercules with the tools provided on "sql-files\upgrades" folder:

• eAthena-logs-upgrade.sql
• eAthena-main-upgrade.sql

 

[Klutz]

How can i setup the emulator to use the sql?

I couldn't find the option anywhere.

Hercules uses sql as default (and only uses sql, doesn't use txt databases).

You may want to setup a new Hercules default server to explore and watch how Hercules works.

In this topic you can find a very good guide about how to install sql databases: http://herc.ws/board/topic/1574-tutorial-preparing-database-ragnarok-for-pre-compiled-hercules/

Here you can download a precompiled server: http://herc.ws/board/files/file/25-hercules-win32-for-ragexe-20130703/

And here you can find the newest version of hercules: https://github.com/HerculesWS/Hercules/

After having tested and experienced hercules, you may want to convert your sql databases from eAthena to Hercules with the tools provided on "sql-files\upgrades" folder:

• eAthena-logs-upgrade.sql
• eAthena-main-upgrade.sql

https://github.com/HerculesWS/Hercules/commit/95c3844754b1649aaa4866e1e65034ad24a1cafe

this commit say it doesn't support anymore

 

[4144]

Items, mobs, skills and other static things stored in conf files. This is not csv files like in eathena or rathena. This is special configuration format. See libconfig.

Dynamic data like accounts, characters, inventories etc, stored in sql.

 

[Ragno]

https://github.com/HerculesWS/Hercules/commit/95c3844754b1649aaa4866e1e65034ad24a1cafe

this commit say it doesn't support anymore

Items, mobs, skills and other static things stored in conf files. This is not csv files like in eathena or rathena. This is special configuration format. See libconfig.

Dynamic data like accounts, characters, inventories etc, stored in sql.

As @4144 said, Hercules uses .conf files with a structure more human readable. This is an example for item_db.conf:

{
Id: 1625
AegisName: "Healing_Staff"
Name: "Healing Staff"
Type: 4
Buy: 20
Weight: 400
Atk: 10
Matk: 105
Range: 1
Job: {
Acolyte: true
Priest: true
Monk: true
}
Loc: 2
WeaponLv: 3
EquipLv: 55
View: 10
Script: <"
bonus bAtkEle,Ele_Holy;
bonus bHealPower,(getrefine()*3/2);
">
},


However, if you still need to have updated item_db in sql format, you can convert the .conf file to .sql with this plugin:

https://github.com/HerculesWS/Hercules/wiki/Db2sql

 

[Klutz]

https://github.com/HerculesWS/Hercules/commit/95c3844754b1649aaa4866e1e65034ad24a1cafe

this commit say it doesn't support anymore

>Items, mobs, skills and other static things stored in conf files. This is not csv files like in eathena or rathena. This is special configuration format. See libconfig.

Dynamic data like accounts, characters, inventories etc, stored in sql.

As @4144 said, Hercules uses .conf files with a structure more human readable. This is an example for item_db.conf:

{
Id: 1625
AegisName: "Healing_Staff"
Name: "Healing Staff"
Type: 4
Buy: 20
Weight: 400
Atk: 10
Matk: 105
Range: 1
Job: {
Acolyte: true
Priest: true
Monk: true
}
Loc: 2
WeaponLv: 3
EquipLv: 55
View: 10
Script: <"
bonus bAtkEle,Ele_Holy;
bonus bHealPower,(getrefine()*3/2);
">
},


However, if you still need to have updated item_db in sql format, you can convert the .conf file to .sql with this plugin:

https://github.com/HerculesWS/Hercules/wiki/Db2sql

so lets make sure i understood everything,

Hercules doesn't support sql based item_db/item_db2 (that will be used by the map server)

And i need to move all my custom items to the text files (aka item_db.conf)

 

[Ragno]

so lets make sure i understood everything,

Hercules doesn't support sql based item_db/item_db2 (that will be used by the map server)

And i need to move all my custom items to the text files (aka item_db.conf)

Yes, and I forgot to mention, Haru provides support for convert item_db.txt and mob_db.txt to conf files:

http://haru.ws/hercules/

You can use that for conversion, but, if you have all your items in sql, then you need first to convert them previously to .txt (.csv format).