Jump to content
  • 0
Sign in to follow this  
Klutz

Moving from eathena

Question

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?

Share this post


Link to post
Share on other sites

8 answers to this question

Recommended Posts

  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

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:

 

Share this post


Link to post
Share on other sites
  • 0

 

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:

 

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

 

this commit say it doesn't support anymore

Share this post


Link to post
Share on other sites
  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

 

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 by Ragno

Share this post


Link to post
Share on other sites
  • 0

 

 

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

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.