Location of Character stats now?

[rilex]

After the drop of the data column, where are the values stored for character agl, str, int, etc. are? Obvious columns are obvious in characters, just looking for these ones now that they've been moved somewhere.

[hunuza]

Right now they are not saved anymore but calculated on login.

What do you need them for? You should be able to calculate them yourself by base stats and equipped items + talents.

If you need it for some external scripts, we might maybe save them independent from usual character save, like only on logout or so...

Which do you need exactly?

[rilex]

For MicroManager. Right now I display the following stats:

Health (Current/Max)

Mana (Current/Max) (or Power etc)

Strength

Agility

Stamina

Intellect

Spirit

Amor

Holy, Arcane, Fire, Nature, Frost, Shadow Res %

Block %

Dodge %

Parry %

Melee Power %

Ranged Power %

Crit %

Range Crit %

[hunuza]

I think saving that data in a character_stats table would be the best choice. You should be able to configure whether you want it to be saved or not (if you don't use the data you don't need to waste resources on saving it). Saving it on character logout should be sufficient.

Any other suggestions?

[xeross155]

As it's not really needed to be saved in database perhaps a SOAP command to get them from the server ?

[FragFrog]

That will be a lot more expensive than a simple readout xeross155, especially if it's to be used for multiple characters at once (for example: a list of online characters with their base stats). Not entirely sure it's even possible at the moment either.

With that said, is the information not still cached in the big characters.data field? If not, I don't see how you could still implement this - it'd go a bit far to require MicroManager users to apply a core patch before they could use MM...

[darkstalker]

a SOAP interface to character stats would be really nice, no need to query them all the time, for stuff like armories or forum signatures you could make an external cache with saved values

[rilex]

SOAP would be a poor performer compared to pulling the data from a table with an index.

[VladimirMangos]

i not see any bad if this will saved in table if some option enabled. This will let choise (data/performence) by admin.

[xeross155]

Yeh either saving them in a table through the server or saving them by using a soap request and an external script, seems the internal function seems faster.

[hunuza]

Added new table character_stats in [9680].

Vladimir suggested to maybe add config to determine when to save (e.g. not only logout) which I consider to implement soon...

[DasBlub]

nice!

can this also be backported to mangos-0.12 ? this one still has the 'data' field...

[Darky88]

nice, nice, nice!!

Can add info about "defense" in the character stats?

Att DarkTerror

[rilex]

That's perfect, hunuza! And it looks like it is easily expandable if other stats are ever wanted

[Stillhard]

Now i can see me in my wow signature again... thx hunuza

[cyrex]

How can, for example, expertise, min damage, max damage be shown if it is not in character_stats

[hunuza]

You can either add it to character_stats or calculate it by equipped items...

[cyrex]

You can either add it to character_stats or calculate it by equipped items...

hehe i know. I was just wondering if in the code there was seomthing that could give the value directly into character_stats. Thanks buddy.

[bisonte]

You can either add it to character_stats or calculate it by equipped items...

How ? Simply add a new field to the table with the correct name ?

[darkstalker]

How ? Simply add a new field to the table with the correct name ?

you need to add the code that calculates it too