release Integrating NoTXT Functionality into Your Database

[Black_Rose©]

This guide will walk you through the process of configuring your database to support the NoTXT feature, which allows you to switch between using text files and SQL for your game asset management. Follow these steps carefully to ensure a smooth implementation.

Step-by-Step Configuration

Step 1: Modify Main.cpp

First, you need to edit the Main.cpp file located in the "db/src" directory. Add the following code snippet beneath your existing includes at the top of the file:

This is the hidden content, please

• Sign In
• or
• Sign Up

Step 2: Update the Disable Hot Backup

Next, locate the declaration for int iDisableHotBackup; and add the following lines directly underneath:

This is the hidden content, please

• Sign In
• or
• Sign Up

Step 3: Adjust ClientManager.h

Open the ClientManager.h file within the "db/src" directory. Replace these lines:

This is the hidden content, please

• Sign In
• or
• Sign Up

Step 4: Update ClientManagerBoot.cpp

In the ClientManagerBoot.cpp file, insert the following line at the top:

This is the hidden content, please

• Sign In
• or
• Sign Up

Step 5: Modify InitializeMobTable

 

This is the hidden content, please

• Sign In
• or
• Sign Up

Apply the same replacement for the InitializeItemTable method as well.

Step 6: Update InitializeTables Logic

 

This is the hidden content, please

• Sign In
• or
• Sign Up

Step 7: Implement SQL Functions

Finally, add the following functions to your file to facilitate SQL initialization:

This is the hidden content, please

• Sign In
• or
• Sign Up

Step 8: Create the SQL Table

Next, you need to create the item_proto_table.sql file with the following SQL commands:

This is the hidden content, please

• Sign In
• or
• Sign Up

You can alternatively use the "Design table" feature in Navicat to adjust your item_proto, just remember to rearrange the vnum_range column to be the second column after vnum.

Step 9: Update Configuration

Lastly, ensure that your configuration file (conf.txt) has the following line added:

This is the hidden content, please

• Sign In
• or
• Sign Up

This line sets the system to use SQL instead of text files. A value of 0 would switch back to the TXT format.

Acknowledgments

Special thanks to the contributors for sharing invaluable code snippets.

Change Log

• Implemented NoTXT feature by switching from TXT file reading to SQL.