News

[Papillon]

@Morpheus: There will be an ODBC plugin in the future.

Development update 03.11.2006:

I haven't received my copy of NWN2 yet, so right now it is difficult to set a release date for the prototype (i.e. alpha) version. I think it is going to be in the next few days. Please do not expect a fully developed version with all the bells and whistles - it will be a functional prototype, not a finished application with a shiny GUI in the first few weeks.

The first database plugin (SQLite) is done and seems to work fine, although I did not get a chance to fully test it. Right after the first release, the plan is to continue work on the plugin interface, and after that is done, move on to the other plugins like SQL2005, MySQL, and so on. I will probably not do all by myself, though, so you can expect more open development tasks in this forum soon.
_________________
Papillon

[mostal]

if you want a beta or alpha tester, i can help you...My module is ready for SQL database and wait for your plugins

And it will be a pleasure to help U

[Papillon]

Development update 11.11.2006:

Prototype 1.02 (Version 4.0.0.2) is available.

I fixed the problem with the SQLGetData function not recognizing the columns by simply throwing everything out and redoing the way resultsets and columns are handled. Now you can have bigger rows, bigger columns, it is considerably faster, and the hack of using a special separater is gone.

Have fun!

* 11.11.2006: Version: 4.0.0.2 (Prototype 1.02)
- Rewrote and optimized parts sql_include und xp_sqlite
- SQLInit() function is no longer necessary and thus has been removed
- Fetching resultsets with SQLFetch() is now 25% faster
- Fetching columns with SQLGetData() is now 25% faster
- SQLGetData() retrieves columns directly from the SQL plugin, thus eliminating the need for a special separator character
- There is no longer a size limit for result set rows, since columns are fetched individually
- New function SQLGetDataText() for retrieving large columns (e.g. 1024 bytes, no hard limit)

* 05.11.2006: Version: 4.0.0.1 (Prototype 1)
- Initial release of first prototype version
_________________
Papillon

[mostal]

Papillon,

nwserver.exe still crash when player exit game. Do you have any idea ?
Someone else have same problems ?

[mostal]

papillon, here is my msn adress to talk together if you want: roller.94@hotmail.fr

[sstacha]

FYI

I downloaded and tried 1.02 today and I was able to successfully get a test using both Get and Set Persistant string as well as an ExceuteDirect.

Tested using "select * from pwdata where player = GetPCPlayerName(oPlayer) and tag = GetName(oPlayer) and name = "area" (the variable name that I wanted to store for this player). I then did a getData(4) for the value and it worked perfectly. The data was saved using SetPersistantData(oPlayer, "area", GetTag(GetArea(oPlayer))) and I also tested that I got the same value back with the GetPersistantData() call.

Nice work!

[Papillon]

Great!

One request: Please restrict yourself to one or two posts in the news thread. If you want to discuss a longer topic, then create a new one. I've split the discussion about the crash, you can find it here.
_________________
Papillon

[Papillon]

Development update 12.11.2006:

Prototype 1.03 (Version 4.0.0.3) is available.

- Fixed a crash situation on player exit
- New functions for querying NWNX and plugin status: NWNXInstalled, NWNXGetPluginCount, NWNXGetPluginClass (example)
_________________
Papillon

[Urlord]

I downloaded version 1.03 and set everything up. When I imported the erf, only 1 script imported (the OnLoad script was missing). No problem, i dewnloaded version 1.01 and imported just the OnLoad script from the erf.

When I compile All Scripts, the OnLoad script throws an error. It appears that sqlinit() is not in the include file.

Have I missed something major somewhere?

Also, has anyone got an SQL script for creating test tables?
_________________
Jim (aka, Urlord)
Visit the Persistent World of Nymri

[amphiprion]

There is no error in the 1.03 erf, there is no more need of SQLInit() (so no more onLoad pecific script for nwnx4)

[Urlord]

[Papillon]

Development update 18.11.2006:

- New function SQLGetAffectedRows() returns the number of rows that were affected by the last INSERT, UPDATE, or DELETE operation.
- INSERT, UPDATE, and DELETE no longer overwrite the active resultset.
- New functions NWNXGetPluginSubClass, NWNXGetPluginVersion, and NWNXGetPluginDescription for getting additional data on a plugin

1) Here's an example of what can be done with the better resultset handling.

The code fetches two rows from a test table, then inserts a new row, then fetches a third row from the original result set.

[Urlord]

This is awesome Papillion. I can't tell you how many times I had to write testing routines with NWN2 just to find out if a Plug-in was properly installed. Thanks a heap!

Is prototype 1.04 available for download yet? I don't see it on the Download page, but the ChangLog shows the changed.
_________________
Jim (aka, Urlord)
Visit the Persistent World of Nymri

[Papillon]

Development update 18.11.2006 (part 2):

Prototype 1.04 (Version 4.0.0.4) is available.

- MySQL plugin released
- Timer plugin + include file released

MySQL plugin has been tested with MySQL 4.1 and 5.0. Linking against the mysql library became quite an adventure today. MySQL AB seems to use Visual C++ 2003, while I use the 2005 version. This leads to all kinds of nasty problems, effectively, you can not use their binary static library. I had to recompile it on 2005 to make it work. No problem, though, I'll just include the files with the source so everyone who wants to compile the MySQL plugin can save herself some headache

NOTE: Only have either xp_sqlite.dll or xp_mysql.dll in the nwnx4 directory! Rename the one you do not want to use to e.g. off_xp_mysql.dll or simply delete it. If you have both in the directory, nwnx.txt will tell you which one got activated, and which one was skipped !


Have fun!
_________________
Papillon

[Grinning Fool]

Excellent news. Should have a set of demos available in short order.