Prototype download

[GodBeastX]

According to Obisidian, they are planning to put DB support in for the thanksgiving patch. It'll likely be a mirror of NWN1's crappy database support

Quick requestion, will the MySQL plugin support returned results instead of simply using the results of the last SQL call or is it too early to tell?

[yi]

the SQLGetData bug is coming from a bug inside FindSubString.
It seems like FindSubString cannot support "¬"

demonstration :
in SQLGetDate :
you should have

[mostal]

not only this control code buggued, but all specail caracters with nwn2 function...

[amphiprion]

but with a code like that, FindSubString give the good result

string str = "a¬a";
SendMessageToPC(oPC, "find by 170:" + IntToString(FindSubString(str, "¬")));
result is 1 (OK)


string str = "a¤a";
SendMessageToPC(oPC, "find by :" + IntToString(FindSubString(str, "¤")));
result is 1 (OK)

but something strange occurs
string str = "a¬¤a";
SendMessageToPC(oPC, "find by 170:" + IntToString(FindSubString(str, "¬")));
SendMessageToPC(oPC, "find by :" + IntToString(FindSubString(str, "¤")));

result 1 OK and result 3 (KO) ???

[Gryphyn]

This will most likely be caused due to UNICODE support in NWN2.

I believe (from what I've read) the character set is UTF8 so anything over 127 is encoded to be multi-byte.

Possibly when the Source becomes available, someone can add the UNICODE support. My understanding is that the 'Interface' still requires a Byte Stream for locating the 'data'.
Strings will need to consider both length in bytes, and in characters.

In the interim pick an ASCII char less than 127.

Cheers
Gryphyn

[Papillon]

Good news. This problem has been addressed in Prototype 1.02.

Have a look at my news post.
_________________
Papillon

[amphiprion]

Thanks papillon for your quick update

[yi]

It works fine Papillon
_________________
http://www.arkalym.com

[Urlord]

Maybe a silly question, but ya know, someone has to ask it!!!

Where do I download a copy of MySQL Lite? I have googled it and looked at MySQL.com and I find managers and extenders but not the actual application download.

I know I am getting old, but this is really scaring me!

EDIT - NEVER MIND. I was looking for MySQL Lite instead of SQLite. I found it.... DOH!!!
_________________
Jim (aka, Urlord)
Visit the Persistent World of Nymri

[Urlord]

After being told that version 1.03 doesn't need an SQLInit(), it is all set up now.

I have tested the SQLExecDirect(), SQLFetch() and SQLGetData() functions. and they all seem to be working fine. I will continue to test and if I run into any problems I will post them here.

QUESTION: Will you be building the MySQL Plug-In for MySQL 5? I really hope so because I would like to make use of Stored Proceedures in MySQL 5.

Thanks again Papillion for all you hard work.
_________________
Jim (aka, Urlord)
Visit the Persistent World of Nymri

[Papillon]

Ideally, I'd like one plugin that supports both MySQL versions. I had some troubles doing that with NWNX2, so it might no be possible... I haven't really looked into that.

If all else fails, there would have to be one MySQL plugin for each version.

Bottom line: Yes, MySQL 5 and 4 should be supported.
_________________
Papillon

[Urlord]

One thing I have noticed is if you save your module as a true .mod file, NWNX-Controller will automatically loads the mod in NWServer. However, if you save your module as a Directory, it does not automatically load the module in NWServer.

Has anyone else noticed this behavior and is it expected? I typically tend to save my modules as Directories.

It's no big deal to manually load the module in NWServer, I was just curious as to if this was normal.
_________________
Jim (aka, Urlord)
Visit the Persistent World of Nymri

[Urlord]

In my toolset, SQLStringToLocation and SQLStringToVector do not show up in the Script Assist listing. Any clue why this would be happening?
_________________
Jim (aka, Urlord)
Visit the Persistent World of Nymri

[Papillon]

I'm not sure how the ScriptAssist window parses the function comments and I haven't really looked into that yet. If you could find out why, that would be appreciated (but please post any findings in a new thread, thanks!).
_________________
Papillon

[Senalaya]

The script assistant can't display nested includes.

So, if you have

my_inc