Page 1 of 1
character_details table max hp, power etc [Resolved]
Posted: Sat Dec 05, 2009 2:31 am
by 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
Re: character_details table max hp, power etc
Posted: Sat Dec 05, 2009 9:45 am
by LethalEncounter
Yup, they were mixed up in the update statement and are now fixed. Good catch!
Re: character_details table max hp, power etc
Posted: Sat Dec 05, 2009 1:40 pm
by 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.
Re: character_details table max hp, power etc
Posted: Sat Dec 05, 2009 3:25 pm
by bolly
fast as lightning, cheers!
Re: character_details table max hp, power etc
Posted: Sat Dec 05, 2009 7:29 pm
by LethalEncounter
John Adams wrote: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.
Re: character_details table max hp, power etc
Posted: Sat Dec 05, 2009 7:36 pm
by 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.
Re: character_details table max hp, power etc [Resolved]
Posted: Sun Dec 06, 2009 9:01 am
by bolly
Tested this mornings revision and it works great, thanks!