Moving from eathena

[Klutz 2]

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 57]

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 2]

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 57]

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 2]

 

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 366]

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 57]

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

Edited March 10, 2017 by Ragno

[Klutz 2]

 

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 57]

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).