Db2sql

From Hercules Wiki
Revision as of 18:37, 16 September 2016 by Haru (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contents

Files Converted

Description

This plugin converts the item database configuration files for use with SQL servers.


Compiling

The plugin needs to be compiled. If you've already compiled your server and/or other plugins, input these commands:

./configure
make plugin.db2sql

Windows

In Windows, compile the db2sql plugin in Visual Studio.


Enabling db2sql

Next, the plugin needs to be enabled in conf/plugins.conf:

plugins_list: [
	/* Enable HPMHooking when plugins in use rely on Hooking */
	//"HPMHooking",
	"db2sql",
	//"sample",
	//"other",
]


Usage

To use the converter, update your changes in the desired item database (using db/item_db2.conf for customisations is recommended); then, run this command:

./map-server --db2sql

Windows

In Windows, run db2sql.bat in the root directory.


Output

The resulting files will be output in the sql-files folder as sql-files/item_db.sql, sql-files/item_db_re.sql, and sql-files/item_db2.sql.