Problem Storing some objects, not others.

[lothoir]

I have two separate scripts, tables and objects to store. The persistent chest storage script works perfectly, however for my death system I can not store the corpse placeable. I have absolutely no idea what I am doing wrong, here are the two scripts along with the xp_mysql log file:


OnDisturb event for the chest:

[Dethia]

well I am able to save corpse objects, will take a look at your code but just wanted to say it's doable.

Ok I took a look at your code and I don't know why you are doing all that crazy stuff. You are able to simply copy the pc's corpse and treat the copy as an object, here is the code I use:

[lothoir]

I'm sorry, I should have explained what I'm doing: When a player dies I want to strip all of their gold and items and put it in a loot container that will appear next to their corpse, which will be a placeable without an inventory. Clicking on the corpse would destroy the placeable corpse and put a heavy object into their inventory, which can then be hauled back to town for some kind cleric to cast Raise Dead or Resurrection.

I want both the corpse and the loot container (including all of the loot within!) to be persistent between server resets. The module OnLoad script would read from the database and spawn the appropriate corpses and loot containers around the server where necessary.

I plan to eventually implement 'decay' where the corpses would turn to bone, and then eventually dust, as well allow 'burials' for rogues and assassins to hide their targets when all is done.

[Dethia]

well what you describe is still doable and it's doable both your way and my way.

If you look at my example I copy the pc, strip their items and spawn an invisible placeable for ppl to interact with. People can click on the placeable at which point they get a conversation to either pick up the corpse or leave it alone.

The main thing is that I do spawn 2 objects one a placeable and one the corpse.

Now you don't want to just strip items from the pc but add them to the inventory of some placeable which is fine.

What you need to be sure to do right though is the following. As far as I know you can't just save a container and all of it's contents with it (I may be wrong but I never tried). You would need to save the container and each individual item inside it. This is all doable and not too difficult either. But that's not all, if you want to avoid duping items, you need change the tag of every item you store in the database (this mostly pertains to stackable items), generally appending the tag with the item's id is fine. When the item is removed from the chest just return the tag name to normal.

Now looking at your script you are using a SetPersistentObject function which I am not familiar with sadly, I use the SCO/RCO functions.

My advice is for the corpse object since you have pre-made placeables you do not need to store the corpse but only it's resref. Just store the resref for the corpse and use the createobject function. You would simply need to make an OnModuleStart script that would load all the corpses when the module starts.

Lastly take a look at my thread:
http://www.nwnx.org/phpBB2/viewtopic.php?t=1515
Maybe it will help you in some way. If you have more specific questions don't hesitate to ask.

EDIT: I also think you shouldn't bother saving the container. Just have a set placeable, chest or whatnot that you will spawn near the corpse with the items being populated from the database. Give each unique corpse a unique ID and link the items to that ID. So all in all you only need to store the items and the resref of a specific corpse for a particular character.

[lothoir]

I used an nwnx_sql include file I found on these forums somewhere; here are the relevant functions:

[eeriegeek]

Virusman has just recently implemented placeable object storage http://nwnx.org/phpBB2/viewtopic.php?t=1083 for Linux. Is there a possibility the version of NWNX you are using doesn't support placeable storage (i.e. only supports item and creature storage)?

[Dethia]

well I have never tried to save placeables but we have been using persistent placeables on the server for years. Using resrefs imo is much better than storing a placeable object.

Again about the corpse you know you can store things like the player's name and the players description in the sql database as well it's just 2 text fields. Objects are big blob fields that often take up more memory. I will post the script we use to store persistent placeables as an example I hope it will at least help you with your issue.

[Gryphyn]

Firstly there is a know issue with Get/SetLocation - the generated string can exceed the length of the buffer allocation.
You need to increase the length of the buffer, or shorten the location string. (eg #POSITION_X# becomes #X# etc - with relevant code changes)

Secondly, the object being stored has a capped data length, while this is fine for most objects, quite a few (a lot) exceed this limit.

-and another plug-
I stopped work on my SQLServer plugin, but it has all the code changes needed to make NWNX database friendly - removing all the 'gotchas' and limitations of the original plugin. It's been so long, and no-one wants the improvements, including a, by far, easier NWScript command set (for the database novice) and functionality that fully supports the ODBC API.
PS. It's fully backwards compatible, so NWScript for MySQL will also work (without change) on SQLServer2005/8 (Express)

Cheers
Gryphyn

[MetaPhaze]

I haven't given much to the NWN community, I gave up on scripting and module building shortly after NWN was released because of the flaws that were in the multi-player system for the game... bioware later fixed a lot of the issues and some friends of mine got me back into NWN.

I spent 3 years developing one of the most advanced servers around using the neverwinter nights extender, and I have used or have plans to use every single plugin that nwnx2 supports.
I've added many things to NWN that many people didn't think possible, or that people thought would create server side lag on a server, or be too complicated to implement.

We have a great persistent world that no one plays much anymore, it will probably be the last nwn server running in the end.
I've written my own functions for my aps_include.nss file to handle the problems I've found with the standard aps functions...
We use these functions on our persistent world and have for the last 4 years. It's tested and there isn't much difference in how it works and how the original functions worked... in fact you won't notice much difference in locations and to the players it will seem exactly as they placed it...
We're dealing with floats and when you get to micro, nano, and pico position data your really not losing much... and it's not noticeable in the game.

These functions simply shorten the length of the floating point number to the right of the decimal point.

Have fun hope this helps you.

MetaPhaze

P.S.

feel free to use these functions however you wish, add to them, change them, distribute them, and please remember me in your code.

// written by MetaPhaze for aps_include.nss based on work by the aps team and nwnx2


string mpVectorToString(vector vVector)
{
return "#POSITION_X#" + FloatToString(vVector.x) + "#POSITION_Y#" + FloatToString(vVector.y) + "#POSITION_Z#" + FloatToString(vVector.z) + "#END#";
}

vector mpStringToVector(string sVector)
{
float fX, fY, fZ;
int iPos, iCount;
int iLen = GetStringLength(sVector);

if (iLen > 0)
{
iPos = FindSubString(sVector, "#POSITION_X#") + 12;
iCount = FindSubString(GetSubString(sVector, iPos, iLen - iPos), "#");
fX = StringToFloat(GetSubString(sVector, iPos, iCount));

iPos = FindSubString(sVector, "#POSITION_Y#") + 12;
iCount = FindSubString(GetSubString(sVector, iPos, iLen - iPos), "#");
fY = StringToFloat(GetSubString(sVector, iPos, iCount));

iPos = FindSubString(sVector, "#POSITION_Z#") + 12;
iCount = FindSubString(GetSubString(sVector, iPos, iLen - iPos), "#");
fZ = StringToFloat(GetSubString(sVector, iPos, iCount));
}

return Vector(fX, fY, fZ);
}

string mpLocationToString(location lLocation)
{
object oArea = GetAreaFromLocation(lLocation);
vector vPosition = GetPositionFromLocation(lLocation);
float fOrientation = GetFacingFromLocation(lLocation);
string sReturnValue = "";

if (GetIsObjectValid(oArea))
sReturnValue = "#AREA#" + GetTag(oArea) + "#POSITION_X#" + FloatToString(vPosition.x) + "#POSITION_Y#" + FloatToString(vPosition.y) + "#POSITION_Z#" + FloatToString(vPosition.z) + "#ORIENTATION#" + IntToString(FloatToInt(fOrientation)) + "#END#";

return sReturnValue;
}

location mpStringToLocation(string sLocation)
{
location lReturnValue;
object oArea;
vector vPosition;
float fOrientation, fX, fY, fZ;

int iPos, iCount;
int iLen = GetStringLength(sLocation);

if (iLen > 0)
{
iPos = FindSubString(sLocation, "#AREA#") + 6;
iCount = FindSubString(GetSubString(sLocation, iPos, iLen - iPos), "#");
oArea = GetObjectByTag(GetSubString(sLocation, iPos, iCount));

iPos = FindSubString(sLocation, "#POSITION_X#") + 12;
iCount = FindSubString(GetSubString(sLocation, iPos, iLen - iPos), "#");
fX = StringToFloat(GetSubString(sLocation, iPos, iCount));

iPos = FindSubString(sLocation, "#POSITION_Y#") + 12;
iCount = FindSubString(GetSubString(sLocation, iPos, iLen - iPos), "#");
fY = StringToFloat(GetSubString(sLocation, iPos, iCount));

iPos = FindSubString(sLocation, "#POSITION_Z#") + 12;
iCount = FindSubString(GetSubString(sLocation, iPos, iLen - iPos), "#");
fZ = StringToFloat(GetSubString(sLocation, iPos, iCount));

vPosition = Vector(fX, fY, fZ);

iPos = FindSubString(sLocation, "#ORIENTATION#") + 13;
iCount = FindSubString(GetSubString(sLocation, iPos, iLen - iPos), "#");
fOrientation = StringToFloat(GetSubString(sLocation, iPos, iCount));
int iOrientation = FloatToInt(fOrientation);
fOrientation = IntToFloat(iOrientation);
lReturnValue = Location(oArea, vPosition, fOrientation);
}

return lReturnValue;
}

Here is the implementation:

void SetPersistentLocation(object oObject, string sVarName, location lLocation, int iExpiration=0, string sTable="pwdata")
{
SetPersistentString(oObject, sVarName, mpLocationToString(lLocation), iExpiration, sTable);
}

location GetPersistentLocation(object oObject, string sVarName, string sTable="pwdata")
{
return mpStringToLocation(GetPersistentString(oObject, sVarName, sTable));
}

[MetaPhaze]

sorry for the indentation problem... seems that the forums stripped my tab spacings...

[MetaPhaze]

Oh, and HAPPY NEW YEAR!