What to store...what to store

[fgetce]

Starting the tables structure soon and was wondering what does the community consider to be the most important data store is?

The things I was thinking to store would be:

Character Attributes (but not modifier because they should be dynamic)

Character Hitpoints (what their hitpoint were when they logged out or at least what they were before the server crashed)

Character Equipment (would like an opinion on the importance of this one)

Quests (track the ones they have but have not done and the ones they have and have completed)

Journals (information they character gains)

Location (character location for later login)

Vendor Inventory (Will use Gryphyn's vendor system)

Housing (who owns what)

Storage (Bank storage of gold and items)

What do you track in the DB? What is important data to store and what can be left up to the whim of the game?


Anyway just looking for helpful ideas. I am also wondering where the persistent quest journal for the nwnx is? I saw the one on nwvault but that uses the Bioware DB standard.

[Rami_Ahmed]

[fgetce]

So instead of storing character attributes store Feats and spells? Are you refering to spells incase a unscrupulous user casts all their spells and relogs to regain them all without resting?

What would be the importance of storing Feats?

Would calling ExportSingleCharacter() once an hour be fine? How about every 15 minutes so there are about 4 exports within an hour? Should this be on a heartbeat script (I hate heartbeat scripts) or can the nwserver manage exports?

Some quests will be stored permanently, which are story driven and have specific rewards. Other quests that are repeatable are stored temporarily. Temp ones are usually stored until you complete it then they are removed so you could start it up again. The collect the bandit scalps is one such quest.

I will look over knat's global and make the changes to use nwnx2.

Housing will be a challenge to determine what needs storage. Anyone know of a good existing system out there? I looked over hunters persistent housing and SLATES system on the nwvault, but not sure which is the better system. Has any one had success with either of these?

The project is moving along fine.

[Rami_Ahmed]

[fgetce]

I understand the storing the hitpoints when they log out and when they log in I can apply magical damage to reduce their full hit points to where they were when they left the game.

Character has max 55 hitpoints and logs out with 21 hit points. When they relog in 21 hours later, they will have full hit points so I take the db record of 21 hit points for that character, subtract it from 55 which gives me 34 and than apply 34 magical damage to the max 55 hit points to set them to 21 hit points where they were when they logged out (or something like that). Not sure if their is a better solution.

However, I am having trouble understanding how to track and apply feats used. Anyone have an example of how they track feat use and apply that when the pc logs back in?

[Rami_Ahmed]

I use an include file made by EPOlson for Hitpoints/Feats & Spell uses. My version is heavily modified though. If you head over to The Neverwinter Nights Vault and find EPOlson's "PWHelper", you can fish out an include file called "pw_inc_anticheat", which does all that stuff.

[fgetce]

Thanks. I got it and will sort through it later.

Do you know of other helpful scripts on nwvault?

I have many files and scripts from there but it can be difficult finding what you need.

Things I am looking for include setting up a campsite, cooking food on a campfire (both meat and fish). I also am looking for a good fishing mod. I have DHFishing version 2 but I would have to edit it for my needs as the fish included with it do not fit well with the campaign world of forgotten realms. Everything else I believe I have covered like persistent storage, player housing, crafting (using CNR), Knat's Persistent journal system (set to use nwnx2).

Thanks again.

[Grim]

Don't know if you'd still need this, but I did a conversion of Knat's system to use NWNX2.

http://nwvault.ign.com/View.php?view=scripts.Detail&id=2443
_________________
Grim Havoc
Systems guy for Mists of the Mordri
(now private)

[fgetce]

[fgetce]

[fgetce]

Never mind Grim, I figured it out. You can create the journal entry through the journal editor and link it to the Plot ID through NWNX2.


I do have a question on player locations.

What function do you use to get the players current position in the game? Is it X:Y:Z coords?

How should it be stored? As a string? Int? I assumed string.

Thanks for the help. I owe alot to the people who came before me.

[Rami_Ahmed]

[virusman]

[fgetce]

Here is my onclientexit code inside of main()

[FunkySwerve]

IIRC, you can't store location info across resets, because the way they are asigned shiftes. You have to reconstruct it via area tags, and vectors, or something along those lines. There are many threads in the Bioware forums about this, should you need more details.
Funky