Difference between revisions of "Db2sql"

From Hercules Wiki
Jump to: navigation, search
(Created page with "== Files Converted == * {{git|db/pre-re/item_db.conf}} * {{git|db/re/item_db.conf}} * {{git|db/item_db2.conf}} == Description == This plugin converts the item database confi...")
 
(Added mob_db to the list of converted files)
 
Line 1: Line 1:
 
== Files Converted ==
 
== Files Converted ==
* {{git|db/pre-re/item_db.conf}}
+
* {{git|db/pre-re/item_db.conf}} (only in pre-renewal mode)
* {{git|db/re/item_db.conf}}
+
* {{git|db/re/item_db.conf}} (only in renewal mode)
 
* {{git|db/item_db2.conf}}
 
* {{git|db/item_db2.conf}}
 
+
* {{git|db/pre-re/mob_db.conf}} (only in pre-renewal mode)
 +
* {{git|db/re/mob_db.conf}} (only in renewal mode)
 +
* {{git|db/mob_db2.conf}}
  
 
== Description ==
 
== Description ==

Latest revision as of 18:37, 16 September 2016

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.