character_details table max hp, power etc [Resolved]

[bolly]

When you zone there is a problem where the power field will take the value of max_hp and the hp field will take the value of max_power

Seems like the values are getting mixed up somewhere

[LethalEncounter]

Yup, they were mixed up in the update statement and are now fixed. Good catch!

[John Adams]

Weird, I thought we changed that months ago in the DB (the default values anyway). Was there something wrong in the code, too? Oops.

[bolly]

fast as lightning, cheers!

[LethalEncounter]

Weird, I thought we changed that months ago in the DB (the default values anyway). Was there something wrong in the code, too? Oops.

Yup, the values were switched in the query.

[John Adams]

Doh, well if I recall, the only thing I switched in character_details table update was that max_hp was 40 and max_power was 45 - but I think now I know why they were reversed. Not sure how I caught that, but I think it was when players died they revived with their values swapped. Never thought the code was at fault.

[bolly]

Tested this mornings revision and it works great, thanks!