Difference between revisions of "Db2sql"
From Hercules Wiki
(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
- db/pre-re/item_db.conf (only in pre-renewal mode)
- db/re/item_db.conf (only in renewal mode)
- db/item_db2.conf
- db/pre-re/mob_db.conf (only in pre-renewal mode)
- db/re/mob_db.conf (only in renewal mode)
- db/mob_db2.conf
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.
