Author Topic: SQL DB!  (Read 5636 times)

Offline Mercy

  • Hero Member
  • *****
  • Posts: I am a geek!!
    • View Profile
    • Email
SQL DB!
« on: December 30, 2006, 03:49:17 AM »
Anyone know how to set up and configure a SQL DB for NWN, a server using NWNX also. I figured you would Mo, but if you do post here or PM me. Thanks! :D
Elessar: why is the shit coming from his head?
Anheg: cause its japanese?

Offline Soul Sojourner

  • Resident Awesome
  • Global Moderator
  • Hero Member
  • *****
  • Posts: 2748
  • Nothing is true; everything is permitted.
    • View Profile
    • Email
SQL DB!
« Reply #1 on: December 30, 2006, 07:29:19 AM »
For NWN, or for NWN2? My guess is NWN as you said, correct?

Offline Mercy

  • Hero Member
  • *****
  • Posts: I am a geek!!
    • View Profile
    • Email
SQL DB!
« Reply #2 on: December 30, 2006, 11:18:05 AM »
Yes nwn.
Elessar: why is the shit coming from his head?
Anheg: cause its japanese?

Offline 420

  • Hero Member
  • *****
  • Posts: 4087
    • View Profile
    • Email
SQL DB!
« Reply #3 on: December 30, 2006, 12:02:39 PM »
Quote
Anyone know how to set up and configure a SQL DB for NWN, a server using NWNX also. I figured you would Mo, but if you do post here or PM me. Thanks! :D
[snapback]33347[/snapback]
I've been putting off learning SQL but Throbble has done a bit of it. Iy would be nice to have a real database for Smith Hold. I'll ask her to post what she knows here.

-420

Offline Mo

  • Administrator
  • Hero Member
  • *****
  • Posts: 3051
    • MSN Messenger - cochy@msn.com
    • View Profile
    • http://lucidmagic.net
    • Email
SQL DB!
« Reply #4 on: December 30, 2006, 04:04:14 PM »
Well first you need to download and install MySql.  After you do that, create the db and password and associate info in the nwnx scripts.  After that it just a matter of using the 3-5 nwnx scripting commands to read and write info to the db.  The included documentation is very good.  After that the only thing you need to learn are the SQL commands.  Just type SQL commands in Google and you'll have no problem finding good documentation about the SELECT, INSERT etc commands.

Offline Mercy

  • Hero Member
  • *****
  • Posts: I am a geek!!
    • View Profile
    • Email
SQL DB!
« Reply #5 on: December 30, 2006, 05:42:07 PM »
Thanks Mo you rock!
Elessar: why is the shit coming from his head?
Anheg: cause its japanese?