NWNX4 and an external MYSQL, as well as customizing tables

[Der Phobos]

First off I want to thank you for this, especialy after seeing obsidian's lacking ability to provide something like this.

I'm wondering if its possible to connect to an external mysql db, I have my server running on a 3.0 2gig ht machine and have the sql server running on dual 450s. I would like to connect to it, is it possible to do this? Also is it possible to customise the login and table configureation that nwnx4 writes too? I want to change around the row configuration to more cater my server.

[Papillon]

Yup, that's entirely possible.

Of course, the MySQL plugin still has to be done
_________________
Papillon

[Der Phobos]

Cool I'll continue sitting on my thumbs, but where might I find the table creation so I can change around what rows it implements into the sqlite.db?

[Papillon]

Only the demo module will create tables, and that is not done yet.

You can use any table structure you like, why do you want to change the existing (and really simple) pwdata table ? Just create your own tables and write the corresponding SQL statements to work with the data.
_________________
Papillon

[Der Phobos]

Well the base string is ok, however makes a few too many rows for my taste. What I'm implementing will be a single row per char with diffrent rows per varable, such as keeping everything thats currently in the string but breaking down the svar to seproate into a string for location and a intiger for completed quest as well as for waypoints, but rather than writing 3 lines, I'm planing on writing 1, to save seek times and redundant data.

[Grinning Fool]

I think to Papillion's point -- you can do that by implementing new tables and custom queries, instead of worrying about changing pwdata and the built-in support for it.

[Der Phobos]

As the sql querries are writen right now, its updating a single row per varable registering the user name and id. There is no current built in script to run it and I was only wondering if there was or if I would have to create an ingame activated function to run said script.

[Der Phobos]

Also, is there somewhere I can get the resources I would need to set up a mySQL plugin?