APS/NWNX released

Papillon · Post by **Papillon** » Tue Jan 28, 2003 3:58 pm

We are happy to announce to the NWN Community that the Avlis Team has released the first public version of APS/NWNX, a real-time Open Database Connectivity (ODBC) interface for Neverwinter Nights.<p>Get it from nwvault: <a href="http://nwvault.ign.com/Files/other/data ... PS/NWNX</a>

DreaM · Post by **DreaM** » Tue Jan 28, 2003 5:42 pm

A little prob. I follow all the steps in the readme in order to createthe database (access) but when i test it with your module, it tells me that nwn extender is not on. What can I do with this??
Thanks a lot.

DreaM · Post by **DreaM** » Tue Jan 28, 2003 5:52 pm

I've realized that the extender doesn't detect my module load, after module load, it keeps saying "waiting for the module".

Silent Agent · Post by **Silent Agent** » Tue Jan 28, 2003 6:00 pm

I have it downloaded, my problem is MySQL. I downloaded the free one, and launched the setup.exe from winzip, it said it would do what is needed, and created folder. However, not all the files were extracted to the folder. Is that all there is, should I not have some type of MySQL icon to launch the interface or what? As you can tell this is not my field

I realize this is not a support forum for MySQL, so if no ones wants to help, so be it. If you can offer some help, please do. I really would like to use what you have made, as it sounds as good and possibly better then what BW will come up with given what they have said thus far on the topic.

Thanks - Silent

Papillon · Post by **Papillon** » Tue Jan 28, 2003 6:05 pm

Silent, have a look at my answer on the Bioware board. I experienced the same surprise like you when I installed MySQL on Windows for the first time. The setup programm does install an icon, it's just a bit hidden... goto Start->Programs->Startup. A shortcut to MySQLAdmin should be there. Click on it and the database will load in the background. Make sure you install MySQL Control Center, too. It makes your live a lot easier.

Papillon · Post by **Papillon** » Tue Jan 28, 2003 6:06 pm

Originally posted by DreaM
I've realized that the extender doesn't detect my module load, after module load, it keeps saying "waiting for the module".

What language version is nwserver.exe ? If it's anything other than english you should send me a screenshot, please (before the module loaded and after that).

Silent Agent · Post by **Silent Agent** » Tue Jan 28, 2003 6:11 pm

I must be doing this wrong then, I only see adobe gamma loader.exe and ms office under start up. If i can just use access, and its already here (i have xp pro) then i might as well do that? Sorry if these questions are obvious. I can verify if the access driver is present if I knew where to look for it (do'h), then maybe I could use that instead. Once I do this once and get it bookmarked i will be fine if you have the patience.

Silent

Papillon · Post by **Papillon** » Tue Jan 28, 2003 6:16 pm

Please follow the instructions in "IV. Setting up a database for NWNX". That section describes everything you need to do to set your access database up.

Silent Agent · Post by **Silent Agent** » Tue Jan 28, 2003 6:17 pm

Ok, I have at least verified that I have your extender in the right place. I loaded, and it opens the server.exe, I load the module and I get the "Server ready. Running init stage..." text, but then of course it does not find anything and shuts itself down after say 20 seconds. So now I just need a access or MySQL db named NWN correct?

Silent

Silent Agent · Post by **Silent Agent** » Tue Jan 28, 2003 6:22 pm

Originally posted by Papillon
Please follow the instructions in "IV. Setting up a database for NWNX". That section describes everything you need to do to set your access database up.

Did not see "the other" doc, trying it now. Thanks

Silent Agent · Post by **Silent Agent** » Tue Jan 28, 2003 6:42 pm

This should be illegal man!

So yeah, my database is working and I got the expected messages. Thanks (for you patience moslty). I haven't got the time to test with my own data today, but will soon once I get the erf installed and maybe store some NPC conversation variables or whatever.

I will report with my success story and any suggestions or problems found. Thanks again.

Cheers - Silent

Dukar_Rizulin · Post by **Dukar_Rizulin** » Tue Jan 28, 2003 7:55 pm

well i've gotten past the problem by creating the tables and feilds manually but just so you know the signs in the modules you made didn't work for me

but all the rest works nicely this is 50th level geek stuff Awsome job

Papillon · Post by **Papillon** » Tue Jan 28, 2003 8:18 pm

Dukar_Rizulin, what database are you using ? The demo_createtable script is designed for Access only.

Cryo · Post by **Cryo** » Tue Jan 28, 2003 8:55 pm

I have the same problem that Dream describe.

When I load the test mod, it keeps saying "waiting for the module".
I've tried a lot of things, but no success.

I have a french version of nwn.

Tx for all your work for the nwn community.

Cryo

Papillon · Post by **Papillon** » Tue Jan 28, 2003 8:57 pm

Cryo, send me the screenshots I mentioned above. Thanks.

DreaM · Post by **DreaM** » Tue Jan 28, 2003 11:47 pm

I have the spanish version and here you can see the screenshot before and after module load.
screenBeforeAfter.jpg
I hope it can be solved, thanks for all.

Dukar_Rizulin · Post by **Dukar_Rizulin** » Tue Jan 28, 2003 11:59 pm

any chance you could show us how to create the pwdata table and feidls in side of nwn using the SQLExecDirect() thing?

Papillon · Post by **Papillon** » Wed Jan 29, 2003 12:07 am

DreaM: Thanks. I'll add the spanish string to NWNX tomorrow and post a new version.

Dukar_Rizulin: Yeah sure. Open the included module "aps_demo" and have a look at the script "demo_createtable". There is an example for Access and one for MySQL in there.

Shade Shadowbane · Post by **Shade Shadowbane** » Wed Jan 29, 2003 1:23 am

Papillon,

I connect fine to the database (MySQL, ODBC) and I matched all my connections as they appear in the MySQL Control Center...

However, after every SQL Command in the Extender, I receive a
! SQL Error:

From what I can tell, I don't have proper rights to MySQL through ODBC somehow... i.e. it won't create the table... though I can't figure out why...

Any ideas?

SS

Shade Shadowbane · Post by **Shade Shadowbane** » Wed Jan 29, 2003 1:26 am

Forget it... stupid pills didn't wear off yet... the above post solved it... needs the MySQL commands

Sorry... I'll test it

SS

Shade Shadowbane · Post by **Shade Shadowbane** » Wed Jan 29, 2003 2:38 am

I lied again...

still getting:

! SQL Error:

for every command... Everything appears to work right... just a problem with the ODBC config I would imagine... So still hunting for assistance...

Thanks

SS

Post by **Orleron** » Wed Jan 29, 2003 3:03 am

Shade Shadowbane,

I have seen this happen to us whenever I forget to build the module. After you import the APS make sure you build and compile every script in the module before you run it the first time.

Shade Shadowbane · Post by **Shade Shadowbane** » Wed Jan 29, 2003 3:49 am

I'm using your aps_demo mod, and I did recompile it...

I'm just stumped... I think it has something to do with permissions... but I can't be certain...

I've never used MySQL before, which we (TORIL) will need as we are developing a large initial mod for our PW (600 overland areas, 250 underdark, etc...)... but MySQL seems simple enough...

SS

Shade Shadowbane · Post by **Shade Shadowbane** » Wed Jan 29, 2003 4:27 am

Got it... Just stripped MySQL from the system and reinstalled it from scratch... good to go...

Thanks again

oh... and by the way... THANK YOU!!!!!!!!!!

SS

Timendainum · Post by **Timendainum** » Wed Jan 29, 2003 6:08 am

I'm having a problem. When I load the demo module, everything works correctly.

Stores and retrieves data.

When I integrated into my mod, the server loads up and says:
* Found 0 bytes for requests, 4096 bytes for responses
* Connecting to ODBC DSN nwn
* Init complete.

When I load the demo mod
it says
* Found 1024 bytes for requests, 4096 bytes for responses

What am I doing wrong?

The World of Avlis

APS/NWNX released

APS/NWNX released

need some help as well

sorry..

LOL

Problem with creating tabled while in nwn

Mysql call from inside nwn?