NOTE: This document pertains to NWN1 v1.69 only, not NWN:Enhanced Edition! Please understand this before continuing.

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 reporoducable 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 biowares 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 functionallity.

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

There is also a prechacher tool build-into prc.jar and a stand-alone SQLite commandline tool. These are used to insert the 2da files into the database where they can be accessed quicker.

Many servers may already have NWNX setup, possibly already using NWNX-ODBC2 to provide database functionallity. Some servers use MySQL instead of SQLite as a database. In these cases, the precacher can be set to provide MySQL compatible syntax. (NOTE: I know little about non-SQLite databases, so I dont know how well this works or any details of it. If you have more information, please contact the PRC team so this manual can be updated)


The first step is to download the PRC Server Pack from here. If your using windows, you should get the .exe installer.
To install the PRC Server Pack, simply run the exe. It should automatically detect your NWN directory. After it has installed itself, it will offer to precache the 2das for you straght away.

If you are using another OS there is a .rar version as well, which should be extracted to your NWN directoy. 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. You may have to copy the out.sql file to wherever MySQL is installed. (NOTE: I know little about non-SQLite databases, so I dont know how well this works or any details of it. If you have more information, please contact the PRC team so this manual can be updated)

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 save!

Now that you have a populated database, you can go about setting up the ConvoCC
This is done mainly through the switch system. The minimum switches that should be set are:

PRC_CONVOCC_ENABLE	This enables the ConvoCC via the OnClientEnter event.
PRC_CONVOCC_USE_XP_FOR_NEW_CHAR	This uses zero XP on a character to mark them as new.
PRC_USE_DATABASE	Turn on database useage.
PRC_DB_SQLLITE or PRC_DB_MYSQL	Set it to the correct SQL syntax.
PRC_USE_LETOSCRIPT	Turn on Letoscript.
PRC_LETOSCRIPT_NWN_DIR	A string pointing to your NWN installation directory.

If you want further information on switches, see the prc_inc_switch script.

Symptom: Letoscript fails to find the NWN directory.

Check the PRC_LETOSCRIPT_NWN_DIR switch. Try different slash options, / // \ \\ as well as having a trailing slash or not.
Check you are using NWNX-Letoscipt build 24

Symptom: Not all options are displayed on occasion

This appears to be lag-related. Try selecting an option and then responding "no" to the confirmation. This should re-generate the list with all the options present, though it may take a few attempts.

Symptom: No options are present and the conversation cannot be aborted.

This is usually the result of a bug, you can use Alt-F4 to quit NWN without using Ctr-Alt-Delete.
Please report this including 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.