How to use RetrieveCampaignObject with FETCHMODE (nwnx odbc)

[soulforge3]

Hello,

I'm not actually a player on Avlis, I'm working on a persistent world called SoulForge. It has been around quite some time without any changes but now I'd like to add a few things to it.
So this is a guest question, I hope that's alright. I spoke to the friendly people on Avlis IRC chat and I was informed about this topic here. I'll go ahead with my question now
My goal is to have a chest with persistent storage for items using nwnx2-linux and the odmbc plugin.
I have nwnx2 and plugins working, I have the db connection working, the table exists. I can store items in the database using this:

Code: Select all

void PersstorStoreNew(string sPlayerName, object oSource)
{
    sPlayerName = SQLEncodeSpecialChars(sPlayerName);
    string sSQL = "INSERT INTO persistent_storage (PlayerName, StorageName, Object) VALUES('"+sPlayerName+"', 'default', %s)";
    SetLocalString(GetModule(), "NWNX!ODBC!SETSCORCOSQL", sSQL);
    object oItem = GetFirstItemInInventory(oSource);
    while(GetIsObjectValid(oItem))
    {
        StoreCampaignObject("NWNX", "-", oItem);
        oItem = GetNextItemInInventory(oSource);
    }
}

The above part is working, I see the entries showing up in the db.

Now it would be nice to retrieve items again. This is what I got:

Code: Select all

void PersstorRetrieveNew(object oPC, object oDestination)
{
    string sPlayerName = SQLEncodeSpecialChars(GetPCPlayerName(oPC));
    string sSQL = "SELECT Object from persistent_storage WHERE PlayerName = '"+sPlayerName+"' AND StorageName = 'default'";
    //SetLocalString(GetModule(), "NWNX!ODBC!SETSCORCOSQL", sSQL);
    SQLExecDirect(sSQL);
    object oItem = RetrieveCampaignObject("NWNX", "FETCHMODE", GetLocation(oDestination), oDestination);
    while(GetIsObjectValid(oItem))
    {
        oItem = RetrieveCampaignObject("NWNX", "FETCHMODE", GetLocation(oDestination), oDestination);
        SendMessageToPC(oPC, "valid item");
    }
}

This is not working. If I leave out the loop and the "FETCHMODE" I can retrieve a single object. This leads me to believe that either FETCHMODE is not working or more likely I'm using it wrong.
I would be happy about any pointers you can give me on this. Do you have anything for persistent item storage in place on Avlis? I don't necesarily need FETCHMODE to work, just a way to retrieve items from a sql resultset.
Thank you!

[tizmo]

Yes, we have a persistent chest system. I cannot directly give you the code, but here are a few things that you need to do:

- In your db table, store both a hash of the object and the object itself in 2 columns. Then when you insert the object, insert both the hash and object. Then when you want to get the object, query for the hash. If you want to allow for the storage of more than one of an item across your playerbase, instead of storing multiple object instances, you may want a separate table to store the hash, quantity, PC / container identification data. Then just store one object in the campaign object storage table.

- Don't use "FETCHMODE" to get the item, just use the "-" for the second argument like you have in the StoreCampaignObject() method.

- Don't do an SQLExecDirect() on the query to retrieve the object, you need to use SetLocalString(GetModule(),...) like you have commented there.

That should get you started.

[soulforge3]

Thank you! It took me a little while to figure out and it was not the direction I was going in originally but I get it now
I already have working storage, just need to improve a few details.
Thanks again and also thank you Gorgon from IRC, if you read this.

[PlasmaJohn]

Hey there.

Avlis' persistent storage is all menu (conversation) based.

I've been a bit out of the loop as far as NWN stuff goes so the following may have been mitigated by the NWNX crowd. Container events fail spectacularly when reporting stacked items making them hilariously prone to duplication exploits. Much rage coding has been spent trying to work around it but ultimately I gave up and went with convo's.