View previous topic :: View next topic |
Author |
Message |
virusman
Joined: 30 Jan 2005 Posts: 1020 Location: Russia
|
Posted: Mon Apr 14, 2008 21:17 Post subject: NWNX ODBC2 |
|
|
NWNX ODBC2 0.3.2 (with MySQL, PostgreSQL and SQLite support) is ready, but I can't figure out the makefile and dependencies stuff, so you'll have to wait for the final build. The sources for 0.3.2 will be uploaded to SVN in a few days.
In the meantime, here is statically compiled NWNX ODBC2 0.3 (which means that it doesn't require mysqlclient libraries) with some SQLite support:
http://data.virusman.ru/nwn/nwnx_odbc-0.3-static-sqlite.rar |
|
Back to top |
|
|
gabonacorp
Joined: 27 Dec 2007 Posts: 12
|
Posted: Tue Apr 15, 2008 0:05 Post subject: |
|
|
sorry virusman, but could you write some documentation for this? I am a newbie for Linux, but i can configure the windows sqlite with the documentation, and if I have some guide I am sure that I can make it with the Linux version.
thank you! |
|
Back to top |
|
|
virusman
Joined: 30 Jan 2005 Posts: 1020 Location: Russia
|
Posted: Tue Apr 15, 2008 0:58 Post subject: |
|
|
You can just use the Windows documentation. The config keys are the same. |
|
Back to top |
|
|
gabonacorp
Joined: 27 Dec 2007 Posts: 12
|
Posted: Tue Jul 08, 2008 22:42 Post subject: Re: NWNX ODBC2 |
|
|
virusman wrote: | NWNX ODBC2 0.3.2 (with MySQL, PostgreSQL and SQLite support) is ready, but I can't figure out the makefile and dependencies stuff, so you'll have to wait for the final build. |
virusman, do you have any news about the final build? |
|
Back to top |
|
|
Borys
Joined: 21 May 2008 Posts: 10 Location: Poland
|
Posted: Thu Dec 18, 2008 9:39 Post subject: |
|
|
Yup, im waiting too. When server exit i got bad looking messages:
Code: | *** glibc detected *** ./nwserver: free(): invalid pointer: 0x0dc55ab0 ***
======= Backtrace: =========
/lib/libc.so.6[0xb7e396d0]
/lib/libc.so.6(__libc_free+0x89)[0xb7e3ad59]
/usr/lib/gcc/i686-pc-linux-gnu/4.1.2/libstdc++.so.6(_ZdlPv+0x21)[0xb7d9c1c1]
[...] |
NWN Extender v2.7-beta4
NWNX2 ODBC2 version 0.3 for Linux.
MySql 4.1.21, Gentoo i686 32bit |
|
Back to top |
|
|
virusman
Joined: 30 Jan 2005 Posts: 1020 Location: Russia
|
Posted: Mon Oct 18, 2010 0:35 Post subject: |
|
|
I'm currently implementing object storage for placeables, triggers, etc. _________________ In Soviet Russia, NWN plays you! |
|
Back to top |
|
|
Ravine
Joined: 26 Jul 2006 Posts: 105
|
Posted: Mon Oct 18, 2010 12:32 Post subject: |
|
|
Hooray |
|
Back to top |
|
|
virusman
Joined: 30 Jan 2005 Posts: 1020 Location: Russia
|
|
Back to top |
|
|
virusman
Joined: 30 Jan 2005 Posts: 1020 Location: Russia
|
Posted: Fri Dec 03, 2010 19:27 Post subject: |
|
|
This update adds object (BLOB) storage in DB for placeables, stores and triggers.
The nwscript library and documentation are not ready yet, but if anyone needs it now, I can show some examples. _________________ In Soviet Russia, NWN plays you! |
|
Back to top |
|
|
MaxRock
Joined: 24 Jan 2008 Posts: 196
|
Posted: Fri Feb 25, 2011 4:44 Post subject: |
|
|
What exactly does "ApplyInventoryLoadPatch" do?
I'm assuming it enables the loading of a store's or placeable's inventory? (Mine are all coming back empty.)
EDIT:
Ok, I think I figured it out.
It's the jump/check for CServerExoApp__GetGameObject, right? When I change "0F 85" (jne) to "0F 84" (je) at 0x00464EF8, it does load the inventory. (This is for the windows version, btw)
Does that sound about right? |
|
Back to top |
|
|
virusman
Joined: 30 Jan 2005 Posts: 1020 Location: Russia
|
Posted: Fri Feb 25, 2011 7:03 Post subject: |
|
|
Since save/load has been designed for savegames, it saves ObjectID in the GFF structure. The inventory load function checks if the object with the same ObjectID exists, and if it does, the item is ignored. This patch fixes this problem by blocking GFF read of field "ObjectID" to always create new items with new ObjectID.
The correct address in Windows is 0x00464ED4 / 0x0051F606. _________________ In Soviet Russia, NWN plays you! |
|
Back to top |
|
|
MaxRock
Joined: 24 Jan 2008 Posts: 196
|
Posted: Fri Feb 25, 2011 19:01 Post subject: |
|
|
Thank you. Works like a charm now |
|
Back to top |
|
|
Timear
Joined: 23 Aug 2005 Posts: 31
|
Posted: Mon Feb 28, 2011 9:28 Post subject: |
|
|
virusman wrote: | This update adds object (BLOB) storage in DB for placeables, stores and triggers.
The nwscript library and documentation are not ready yet, but if anyone needs it now, I can show some examples. |
Can you please provide me (or us) with a simple example on how to use your new STOREOBJECT and RETRIEVEOBJECT hooks?
Currently i know how to use the normal StoreCampaignObject and RetrieveCampaignObject-Functions in conjunction with SETSCORCOSQL, but i have no idea how those new hooks have to be used.
Are they called by SetLocalObject / SetLocalLocation? How can i set the SQL-command?
Thanks in advance |
|
Back to top |
|
|
virusman
Joined: 30 Jan 2005 Posts: 1020 Location: Russia
|
Posted: Mon Feb 28, 2011 21:02 Post subject: |
|
|
New object types require a bit different call for custom SCO/RCO.
Here is the part of the NWScript library that implements SCO/RCO:
http://pastebin.com/8xrpdux0 _________________ In Soviet Russia, NWN plays you! |
|
Back to top |
|
|
Ravine
Joined: 26 Jul 2006 Posts: 105
|
Posted: Wed Nov 02, 2011 19:50 Post subject: |
|
|
The link above is not working anymore, can someone repost it please?
thx |
|
Back to top |
|
|
|