7.6.2005: v 4.0.15
Thanks to Garrath suggestion, SQLDecode/SQLEncode changed to work faster: SQLEncode is as slow as before, but SQLDecode is now very fast (it does nothing at all J ). If you have existing tables which are not NWN-FF standard, and if you use fields with texts that may have quotes in them (or “~”), then you may need to edit the end of ff_buildtable.nss and add some new FixQuotes instruction to convert those fields into the new NWN-FF 4.0.15+ format. If you may prefer to do it manually, you may use this SQL instruction for each text field that may have quotes (replace TableName and FieldName with the proper value). In that case, do it just before launching the new version of your module:
UPDATE TableName SET FieldName = REPLACE(FieldName,'~', '\'') WHERE LOCATE('~', FieldName)>0
Some bugs reported by Hacknisty are fixed (errors in a couple of SQL instructions).
The following nss files have changed: aps_include.nss, ff_buildtable, ff_include
The option [FFSpeech] Debug will now trace the detail of all speech only for a Debug value of 2 or higher. (before, was 1 or 2 for more details).
Here is the meaning for each value: 0 = only critical errors traced. 1 = details on Interface selection and some important warnings. 2 = detailed traced, including all text contents. 3 = very detailed traces.
Some new tries to avoid that @@@ error message when NWServer.exe is restarted. Unfortunately this message still sometimes occurs.
A new instruction NWNX!ODBC!DEBUG. This instruction will allow you to change the debug level of nwn-MySQL.dll or nwn-ODBC.dll from the scripts. It may be useful for instance when you want to get full debug information for only some specific parts of your script. A value of 0 will put the old value back ([MySQL] Debug).
The instruction NWNX!DLL introduced in version 4.0.14 didn’t work properly. It’s now fixed.
The plug-ins dll had sometimes a wrong name when compiled (nwnx-* instead of nwnx_*). This is fixed.
When no module activity is detected, the server still do not restart now until CPU usage drops to 0%.