logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
NWNX ODBC2
Goto page 1, 2  Next
 
Post new topic   Reply to topic    nwnx.org Forum Index -> Linux development
View previous topic :: View next topic  
Author Message
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Mon Apr 14, 2008 21:17    Post subject: NWNX ODBC2 Reply with quote

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
View user's profile Send private message Visit poster's website Yahoo Messenger
gabonacorp



Joined: 27 Dec 2007
Posts: 12

PostPosted: Tue Apr 15, 2008 0:05    Post subject: Reply with quote

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
View user's profile Send private message
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Tue Apr 15, 2008 0:58    Post subject: Reply with quote

You can just use the Windows documentation. The config keys are the same.
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
gabonacorp



Joined: 27 Dec 2007
Posts: 12

PostPosted: Tue Jul 08, 2008 22:42    Post subject: Re: NWNX ODBC2 Reply with quote

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
View user's profile Send private message
Borys



Joined: 21 May 2008
Posts: 10
Location: Poland

PostPosted: Thu Dec 18, 2008 9:39    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Mon Oct 18, 2010 0:35    Post subject: Reply with quote

I'm currently implementing object storage for placeables, triggers, etc.
_________________
In Soviet Russia, NWN plays you!
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
Ravine



Joined: 26 Jul 2006
Posts: 105

PostPosted: Mon Oct 18, 2010 12:32    Post subject: Reply with quote

Hooray Smile
Back to top
View user's profile Send private message
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Sun Nov 07, 2010 20:50    Post subject: Reply with quote

Uploaded the changes to SVN:
http://nwn.virusman.ru/trac/nwnx2-linux/changeset/365/

Complete release and updated NWScript libraries will be available later.
_________________
In Soviet Russia, NWN plays you!
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Fri Dec 03, 2010 19:27    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website Yahoo Messenger
MaxRock



Joined: 24 Jan 2008
Posts: 196

PostPosted: Fri Feb 25, 2011 4:44    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail MSN Messenger
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Fri Feb 25, 2011 7:03    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website Yahoo Messenger
MaxRock



Joined: 24 Jan 2008
Posts: 196

PostPosted: Fri Feb 25, 2011 19:01    Post subject: Reply with quote

Thank you. Works like a charm now
Back to top
View user's profile Send private message Send e-mail MSN Messenger
Timear



Joined: 23 Aug 2005
Posts: 31

PostPosted: Mon Feb 28, 2011 9:28    Post subject: Reply with quote

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
View user's profile Send private message
virusman



Joined: 30 Jan 2005
Posts: 1020
Location: Russia

PostPosted: Mon Feb 28, 2011 21:02    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website Yahoo Messenger
Ravine



Joined: 26 Jul 2006
Posts: 105

PostPosted: Wed Nov 02, 2011 19:50    Post subject: Reply with quote

The link above is not working anymore, can someone repost it please? Smile
thx
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    nwnx.org Forum Index -> Linux development All times are GMT + 2 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group