Stat ID's in Sql tables

[intodesi]

Anyone have any idea what the stat id's(str, int etc) are for the sql database? been looking for them, with no luck. any help would be apreciated.

[John Adams]

As stated previously, the database schema is in a constant state of flux at this time; nothing is solid. As far as I know, there is no stats fields aside from HP in an NPC record - but certain we are going to add them at some point. I myself am not sure how they play into NPCs just yet, ie., not sure if the server dynamically figures it out based on it's Heroic or difficulty status, etc.
I'd wait before creating such fields until we know more about how the server will handle NPC stats.

[intodesi]

ok. I di find the starting resists, I beleive, not sure though, in the

Code: Select all

starting_stats

table. But like you said, I think the starting stats for str int etc are hardcoded perhaps for now.

[Zcoretri]

I don't see a table called starting_stats
It looks to me that the table character_details holds the information you are looking for.

[intodesi]

using phpmyadmin they are at the bottum of the list
starting_items
starting_skillbar
starting_skills
starting_spells
starting_zones
but i see what you are talking about problem with character_details is that it holds the information of already created toons, i dont want to have to edit the stats of toons each time one is created but in the above tables i can edit where a toon will end up, what items they start with, and what resists they start wityh, but strength isnt in the starting_stats table.. Like i said above i think it may be hardcoded.. not sure.