NWNX ODBC2 object storage engine

[NoMercy]

Most most excelent :)

[Blacksting]

Hmmmm.... my tests so far do not look promising. The nwnx_odbc log does not show an SCO/RCO intercept but the Bio DB is no longer being accessed. I am investigating further.

An old persistent chest trying to retrieve standard RCO data crashed the nwnx_odbc.dll.

[Papillon]

If hookscorco = true in the ini file, the functions are hooked entirely. But checking on the database name is a nice idea.... hmm...
_________________
Papillon

[Senalaya]

If you want to leave some room for customization, you should check, whether the database name -starts- with "NWNX!".

Also, just as an idea:
- database name: "NWNX!LETO"
- variable name: "gfffile"
could be used to transfer the blob to and from nwnx_leto with the identifer 'gfffile' without doing the SQL-DB access.

[Primogenitor]

Good news, this was the last reason for using the bioware database and can be totally disposed of now. And that local variables is stored on creatures is one more improvement over bioware.

[Papillon]

Just posted version 0.90. This was more difficult than I thought, but it works ok now.

The database string needs to be "NWNX" for the new functions, anything else for the original Bioware functions.

The variable name can be used for further functionality, e.g. leto.
_________________
Papillon

[dragonsong]

I wish I could take a look for myself, but I'm off in Penn doing MCSE boot camp for the next week. This all sounds very cool, though.

I'm happy to coordinate in any way I can to get the Unicorn builds of LetoScript up to spec for these updates. I hadn't even got FPT built into the new engine yet, so the timing seems just perfect.

It's great to see the NWN developer community still alive and kicking hard.
_________________
- dragonsong

[Blacksting]

Papillon: That was quick thanks That means we have to change the "aps_include" GetPersistent function code right?

[Papillon]

Alternatively, you could take the updated aps_include from the demo module.
_________________
Papillon

[Blacksting]

Hmmm..... I am getting a log of the RCO but it no longer seems to be functioning. Am I the only one having this problem? The SCO works fine. The DB table is filled. When I open the chest for filling the chest is empty.

I am using the "FETCHMODE" code.

[Papillon]

Works for me. Did you double check that you rebuilt the module and/or are using the aps_demo module that came with version 0.90 ?
_________________
Papillon

[Trelantris]

We are running on the original alpha version of the ODBC released with NWNx2. We used this extensivly to build a DB system for MySQL, on our Persistant World (Realms of Myth). If we upgrade to the ODBC2 functionality, will the original code port? All our systems (from the encounter system, Trade Skills, and a persistant chest system (modified version of the test stuff you'd put out) are based on the ODBC connection and functions.

You guys rock, by the way!

[Papillon]

Yes, ODBC2 is 100% backwards compatible to the older ODBC plugin.
_________________
Papillon

[SHoward]

Does this mean we can get a Linux port soon?

[dguntner]