logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Getting started...:)

 
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related
View previous topic :: View next topic  
Author Message
Sagerious



Joined: 10 Jun 2006
Posts: 9

PostPosted: Fri Jun 16, 2006 9:46    Post subject: Getting started...:) Reply with quote

Okay, so...I hope no one minds if I start a noob thread so that i can refer back to this thread in order to see my progress and in order to see exactly what i had trouble with and how it was resolved in the future (see I'm thinking ahead!)

Okay, here's my status...

I am using MySQL. I have MySQL, MySQL Admin, and MySQLQuery Browser installed. GO ME!
(I also have a MySQL GUI thingy called SQLyog to help me get started)

I also think I created the nwn database, but...maybe not. Rolling Eyes

I have NwNx and the ODBC 2 plugin installed. I imported the .erf into the aps_demo.mod.

Then, using the Command Line, I started MySQL. Then, I logged into the demo mod and started clicking on the signs from left to right. Sadly, the third ones for both the string test and the object test laughed at me Sad For the string test, I got a bunch of "..................................." as the variable it was trying to retrieve. For the object test, I got TMI (too many instructions).

For reference, here is my nwnx.ini:

Quote:
; NWNX2 configuration file
; These are the default values for NWNX2. Values specified on the command
; line take precedence.

[NWNX]
ServerPort = 5121
ModuleName = "Monk Villiage.mod"
WatchdogProcess = yes
UpdateIntervalProcess = 5
WatchdogGamespy = no
UpdateIntervalGamespy = 20
GamespyRetries = 5
OldGamespyProtocol = no
RestartDelay = 5

[ODBC2]
; Log file
MaxLogSize = 512 ; in KByte
LogLevel = 2 ; 0=nothing, 1=only errors, 2=everything

; Use these two settings for the SQLite internal database
;source = sqlite
;file = sqlite.db

; Use these two settings for ODBC connections
;source = odbc
;dsn = nwn

; Use these five settings for MySQL connections
source = mysql
server = localhost
user = Sage
pwd = Sage
db = nwn

; Set hookscorco to false if you want to disable hooking of
; StoreCampaignObject and RetrieveCampaignObject entirely
hookscorco = true

[PROFILER]
MaxLogSize = 512 ; in KByte
LogLevel = 1 ; 1=overall statistics, 2=full script callstack


And, here is the log.0:

Quote:
NWN Extender V.2.6.1
(c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen
visit us at http://www.nwnx.org

* Loading plugins...
* Error: No plugins found
* NWNX2 activated.
* NWNX2 shutting down...
* NWNX2 shutdown successfull.


The log confuses me becasue I have the nwnx_odbc.dll dropped in my NWN folder...maybe it's looking in the wrong place?

Anyway...thanks in advance for your time Smile
Back to top
View user's profile Send private message
Sagerious



Joined: 10 Jun 2006
Posts: 9

PostPosted: Fri Jun 16, 2006 9:58    Post subject: Reply with quote

Doh!

*smacks self*

I fixed my own problem...I didn't have NwNx OR NWServer running! lol Smile

But, I'm sure I'll have more questions. Stay tuned!
Back to top
View user's profile Send private message
Sagerious



Joined: 10 Jun 2006
Posts: 9

PostPosted: Fri Jun 16, 2006 10:08    Post subject: Reply with quote

Okay, I've since learned that I don't necessariily have to leave NwNx running. I just have to start NWServer and load the mod in it with NwNx. Then I can shutdown NwNx, leave the NWServer up, sign in to the server, test it, and all is great.

BUT, my questions are...

(noob questions, but inquiring minds, you know...)

1) Why does the NWServer and the mod have to be loaded with NwNx?

2) Why do I have to sign on to the mod through gamespy in order for this to work, rather than just signing in to the mod on my local machine?
Back to top
View user's profile Send private message
dougnoel



Joined: 21 Mar 2005
Posts: 27
Location: VA

PostPosted: Fri Jun 16, 2006 22:12    Post subject: Reply with quote

Sagerious wrote:
2) Why do I have to sign on to the mod through gamespy in order for this to work, rather than just signing in to the mod on my local machine?

Not sure exactly what you're asking here, but I can log into my mod from another machine on the network using the LAN option instead of loading up Gamespy.
Back to top
View user's profile Send private message Send e-mail
Papillon
x-man


Joined: 28 Dec 2004
Posts: 1060
Location: Germany

PostPosted: Fri Jun 16, 2006 23:05    Post subject: Reply with quote

Sagerious wrote:
1) Why does the NWServer and the mod have to be loaded with NwNx?

Because this is where the magic happens Cool

nwnx.exe starts the server and then injects the library nwnx-module.dll into the server process, which in turn hooks the SetLocalString function (which is what it's all about). The executeable of nwnx then just monitors the server (process and gamespy watchdog), but other than that, it just idles and can be closed, as you already found out.
_________________
Papillon
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
Sagerious



Joined: 10 Jun 2006
Posts: 9

PostPosted: Sat Jun 17, 2006 2:05    Post subject: Reply with quote

dougnoel wrote:
Sagerious wrote:
2) Why do I have to sign on to the mod through gamespy in order for this to work, rather than just signing in to the mod on my local machine?

Not sure exactly what you're asking here, but I can log into my mod from another machine on the network using the LAN option instead of loading up Gamespy.


Okay, perhaps I just misinterpreted something. I tried using the aps_demo tests in several circumstances, just to see how it all worked, and I was only able to get it to work when I executed nwnx.exe and then access the module that had loaded in gamespy through NWServer.

Quote:
Quote:
Sagerious wrote:
1) Why does the NWServer and the mod have to be loaded with NwNx?


Because this is where the magic happens

nwnx.exe starts the server and then injects the library nwnx-module.dll into the server process, which in turn hooks the SetLocalString function (which is what it's all about). The executeable of nwnx then just monitors the server (process and gamespy watchdog), but other than that, it just idles and can be closed, as you already found out.


Okay, thank you. Now my curiousity is satisfied for the moment. Smile



Next, I will be learning MySQL and APS... wish me luck!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Database related All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group