NOTE: The ConvoCC is still a work-in-progress. Please report any bugs and issues you might have, after first checking that you have followed this guide, that the issues have not already been fixed, and that it is a reproducable bug. Make sure you include as much information as possible in reports, including at least what OS and database you are running, where you got the ConvoCC from, what haks you are using, how you precached the 2das, what character you are building, and exactly what steps you take to expose the bug. A screenshot of the bug as well as both the serverlog and NWNX-ODBC log files is also very helpful. Without reliable feedback and reports, I cannot improve the ConvoCC. Thank you for your cooperation.

This is a step-by-step guide on how to install the PRC Server Pack.
The PRC Server Pack is needed if you want to do any of the following:

-Use the Conversation Character Creator. This allows the creation of characters with new races, new classes or other custom content at level 1.

-Use the Letoscript enhancements for things such as permanent stat adjustments, etc.

-Use a database other than Bioware's to cache 2da information in.

The system is composed of several components. Firstly, there is NWNX2.

This is an application that hooks into memory locations of the NWServer in order to pass information
into and out of the game. It relies on plugins to provide functionality.

Two plugins are included in the PRC Server Pack:
One is a database plugin, NWNX-ODBC2, which is used to access an SQLite database.

The other is the NWNX-Letoscript plug-in Build 24.

There is also a precacher tool built into prc.jar and a stand-alone SQLite command line tool.  These are used to insert the 2DA files into the database where they can be accessed quicker.

Many servers may already have NWNX2 setup, possibly already using NWNX-ODBC2 to provide database functionality.  Some servers use MySQL instead of SQLite as a database.  In these cases, the precacher can be set to provide MySQL compatible syntax.

The first step is to download the PRC Server Pack.

If you're using Windows, you should get the .exe installer.

To install the PRC Server Pack, simply run the executable.  It should automatically detect your NWN directory. After it has installed itself, it will offer to precache the 2DAs for you straight away.

If you are using another OS there is a .rar version as well, which should be extracted to your NWN directory. Then you will need to manually start the precaching by running the "precache sqlite.bat" file (NOTE: I dont know anything about non-windows OS, so I dont know if a batch file applies or not. If you have more information, please contact the PRC team so this manual can be updated).

If you are looking to add the ConvoCC to an existing server, then you should use the method above (after making a full backup of course). If your existing server uses MySQL, then you will have to use the rar distribution and run "precache mysql.bat" instead. This will produce a file named "out.sql" which you should then run through your database tools. A command like "mysql -u USER -p DATABASENAME < out.sql > out.log" (replace USER and DATABASENAME with the values you use) should work.

Once the precacher has finished, you should have a ready populated database with all the 2DA information in it. This is needed so that SQL queries can be used to retrieve lists of feats etc, rather than lengthy loops over all the rows in the 2DAs.

If you need to precache the 2da files again in the future, for example a new PRC version is released, run the "precache sqlite.bat" file (or "precache mysql.bat" if using MySQL and then process the out.sql file as before) in your NWN directory. This will remove the tables that the precacher previously added, so it should preserve any other existing  data. However, it is probably a good idea to make a backup before you update, just to be safe!

Now that you have a populated database, you can go about setting up the ConvoCC