Elentan

Giantkin, you should try to compile the module with the prc command line compiler (I don´t know how to work with it, but in the PRC forums there´s plenty of information about those problems).

Horred, I finally get the thing to work, your module is a good remake of old good Nordock, but I´m afraid my computer is too weak to run the server, the databases, and play with it as player/DM, and I can´t use another computer for now, because we have not enough for everybody and this ends in someone not being able to play or use his computer for anything else

So, I´m thinking if you could give some guidelines about taking out the database thing, since in a LAN enviroment I don´t need any persistence because I always can save my game, and the databases get a lot of power juice from a computer. It seems that the original CNR 3.5 works without database inclusion, and I´ve tried to run this without mysql, but my game blows up before finishing to load the module (I think it´s because the prc cc, and with the java cc I don´t need such things). So, can you give some hints about what scripts I must take out for this to work without database support?? I know this must sound annoying for you and other players, but not everyone uses PW and server multiplaying.

Thanks

See you

Elentan

Hi,

I´m running version 5 at the moment, and the only bad syntax messages I get in the log are from cnr_components saying the values are duplicated... So, if the database entries for cnr_components don´t need to be duplicated in the tables for any obscure (for me) reason, since all these values were introduced before the errors (they are exactly the same, the errors told me but I got sure about it watching the code a little), it´s safe now. I hope it works, I´ve not be able to play the module yet!!!

So, now RL matters call me, so I´m getting out from home some hours. How long can this database construction thing take? It´s neccesary to log into the game for creating the PRC convo tables, or anything else before playing the server finally?? I may not change the module for the mini-PRC db creator one, best not to touch this if I can help If it takes several hours is ok for me, I don´t plan to use my computer today, and also I´ve others in the network if neccesary.

So, as far as I can tell from what I´ve read, the only thing now is wating for the database to finish building, if I´m wrong, please, tell me.

Horred, I´m terribly sorry if you sensed I was trying to bitch you. I was angry, and maybe I should not have used something like wasting time even if quoting it for making it sound less harsh. You have made a incredible work here, and if you have been able to make the database thing function without a great experience in those matters, I can only praise you, myself a total noob in these things. So, please, accept my apologies, and try to understand that pleople like me, without experience in servers, can become very frustrated if they don´t understand what´s going on. And I thank you Horred for making this module, there too few PRC-CEP ones out there, I hope beetwen all of us here at the forums we can make it work for almost anybody, including myself

See you, people, and thanks for the help

Elentan

Well, I´ve "wasted" a ton of hours today trying to get this thing going, but it seems today I´m out of luck...

I´m no modder, no programmer-scripter or whatever it seems needed to do certains things in NwN, only a normal gamer here. It was hard enough to get the PRC-CEP convo to work with some modules and with the spanish tlks I had, but this is worst, I´ve no clue about what´s wrong!!

Lets try to make this monster work. I´ve NwNserver 1.65 (from the normal install, it seems silly to me to make another standalone server if I already have the full game working here; this is only for LAN playing, I´ve no intentions of making an online srver by now) and with SOU and HOTU, everything working good. I also have CEP 1.51 (I keep the standard tlk as I´m not going to change it to spanish before everything is working as it should, less problems this way ) and PRC 2.2c (the same about the tlk).

So, I install Nordock Plagued CEP-PRC version 4 (which I´m redownloading now for sure). I don´t like autoinstalers, so I get the files with winrar (version 3.11), and get the hak, tlk and module in their places.

After that, I install Mysql version 4.0.23, as it seems the 4.1 doesn´t work with this. I installed the mysqld-max-nt as some other post here suggested in a webguide, and created an user named nwnuser with the password, the flushing and granting of privileges and all those things. Exactly:

mysqladmin -u root shutdown
mysqld-max-nt ?install
net start mysql
mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('typepasswordhere');
DELETE FROM mysql.user WHERE User = '';
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'nwnuser'@'localhost'
-> IDENTIFIED BY 'nwnuser' WITH GRANT OPTION;
SET PASSWORD FOR 'nwnuser'@'localhost' = PASSWORD('nwnuser');
QUIT
EXIT

Well, after that, I install the Control Center version 0.9.4 and make the localhost thing with the user nwnuser and all those things. First I made a database nwn and made an sql query at its tables with:

USE nwn;
CREATE TABLE pwdata (
player varchar(64) default '',
tag varchar(64) default '',
name varchar(64) default '',
val text,
expire int(11) default '0',
last timestamp(14) NOT NULL,
KEY idx (player,tag,name)
) TYPE=MyISAM;

I tested the connection and it had no problems (also I used the default port 3306

Well, now it gets tricky... It seems no one is sure about what package is needed for NwnX and FF. I´ve tried every combination of everything possible here, and run into many problems, ranging from no connection to database, an odd problem with nwnserver that searched for an wp something dll, and things like that. After much reading and frustration, I ve this in nwn directory:

nwnx_leto.dll and LetoScript.dll from nwnxleto-build-03+18

Leto.exe Leto.ini List.leto.xml Taskpad.exe Taskpad.ini and the directories from Leto v3

MadCHook.dll nwnx-module.dll nwnx2.exe and nwnx.ini from nwnx 2.61 (finally didn´t bother to put the nwnx_odbc_254 or 253 files because they all get overwriten with the FF ones

libmySQL.dll nwnx_odbc.dll nwnx_FFspeech.dll nwnx_MySQLSpeech.dll nwn-MySQL.dll nwnx_functions.dll MadCodeHooklib.dll FF_translator.exe StoreItems.exe BinTracer.exe Speech-Mysql.exe and nwn-mysql.exe all from the FF 4012 package

I tried several nwn-ff.ini files but nothing worked well, so I tried the mod FF includes and worked out that it must be something about the code Horred used to setup persistence or the ini file to work with the module. Horred ini crashes everything before starting... So I used the default ini file from FF, and set it up with some changes for Horred module. At the time its like this:

[MySQL]
Debug=1
host=localhost
user=nwnuser
password=nwnuser
database=nwn
port=0
[FFSpeech]
Debug=1
FilterserverIP=1
NetworkInterface=0
NIC_IP=0.0.0.0
[UdpDump]
NetworkInterface=1
[NWNServer]
StartDir=.
ServerName=NWN-FF Server
PlayerPassword=
DMPassword=FFFF
NWServerExeName=NWServer
Module=Nordock-CEP-PRC-Plagued
Difficulty=3
MinLevel=1
MaxLevel=20
MaxClient=64
Port=5121
Autosave=0
WithAdvancedHeuristics=1
IP=127.0.0.1
TimeSlice=20
Priority=0
InitialDelayS=60
bModuleFeedBack=1
DllName=NWN-MySQL.dll
OtherServerParam=
SQL_PlayerCount=SELECT COUNT(*) FROM idplayer WHERE Actif=1
SQL_DMCount=SELECT COUNT(*) FROM idplayer WHERE Actif=1 AND DM=1
StoreBinaryData=1
MaxCounter=30000
LogProcessing=1
[Global]
LogDirectory=.\%y_%m_%d
HideAllWindows=0
[Profiler]
WriteDetailedTextFile=1
CSV_Field_Separator=,
UseProfiler=1

I know there some things that must be setup as well, not sure what is wrong.
The speech part works after I installed the third party program FF put on the file. FF creates the database, and everything seems ok launching from nwn-mysql.exe and then, everything go wrong Here is an excerpt from the log:

NWN-FF Version 4.0.12 Copyright © 2004 FastFrench
(Based on APS/NWN Extender - Copyright © 2003 Ingmar Stieger (Papillon))
[Fri Mar 04 22:33:25 2005] NWN-MySQL Version 4.0.12 main DLL started.
(speech plugin) * Extension "FFSPEECH" is loaded.
* Extension "FUNCTIONS" is loaded.
* Extension "LETO" is loaded.
* NWNX_MYSQLSPEECH.dll skipped: a Speech plugin is allready loaded
* NWNX_ODBC.dll skipped: this NWN-FF main dll has allready MySQL DataBase build-in support
! Bad syntax (EXEC): "ALTER TABLE `pwdata` DROP INDEX `idx`" (Can't DROP 'idx'. Check that column/key exists)
! Bad syntax (EXEC): "INSERT INTO cnr_misc (player,tag,name,val,expire) VALUES('~','NordockCEPPRCPlagued','CnrBoolBuildRecipeDatabase','1',0)" (Duplicate entry '~' for key 1)
! Bad syntax (EXEC): "INSERT INTO cnr_misc (player,tag,name,val,expire) VALUES('~','NordockCEPPRCPlagued','cnrAnvilMaster_DeviceLoaded','0',0)" (Duplicate entry '~' for key 1)
and it keeps going and going with bad syntax at the time going...

So, anybody has any clue about whats going on????? This is getting very awfull for me, I expected something easier... And everybody who tries to help seem to have a different idea of what is better for the server setup, but none works in this computer (have a Windows XP service pack 1 here, and everything else works wonderfully). It seems to me that the database structure has some problem, but neither I know of this things, nor about what Horred did on the module.

Please, the people with working modules there, help us!! My buddies are growing with frustation as I can´t get this masterpiece work for our LAN, and I don´t have much more time to experiment with settings I don´t understand fully, RL is getting harsh lately. If you have and idea about the problem with setting up the cnr tables, or I´m missing something in the nwn root that I should have, please tell me. And a last thing, if I get this working, how much time it takes to make the tables and what have I got to do from then to finish the server setup before playing? (I must lplay from the same computer I run the server, I hope it´s not a problem, and also I´ve no IIS server or Apache or whatever, I don´t intend this for outside LAN connections, hope they aren´t needed in my case).

Thanks for all, and excuse my poor english and this BIG post ( Hope it has not becomed a crying rant for anybody)

See you!!

Elentan, very frustrated