[FIX] Base health increased 7%. 3.2 Shaman

[Raynar]

http://www.wowwiki.com/Patch_3.2.0

  Shaman
   * Base health increased by approximately 7% to correct for shamans having lower health than other classes. 

I use YTDB R51 and mangos 8781.

Here are the exact number from de wowarmory for the last 11 levels:

Lvl 80:

http://www.wowarmory.com/character-sheet.xml?r=Area+52&cn=Totempoke&gn=SO+GAI+IRL+OMG+FASHION

24910-17950=6960

Lvl 79:

http://eu.wowarmory.com/character-sheet.xml?r=Tyrande&cn=Mbwun&gn=Ejecutores+del+Niflheim

11757-5280=6477,00

Lvl 78:

http://eu.wowarmory.com/character-sheet.xml?r=Tyrande&cn=Hundert&gn=Ratas+a+la+Carrera

10087-4060=6027,00

Lvl 77:

http://eu.wowarmory.com/character-sheet.xml?r=Los+Errantes&cn=Sketman&gn=Spirit+of+Gaia

11999-6390=5609,00

Lvl 76:

http://eu.wowarmory.com/character-sheet.xml?r=Exodar&n=Makunlay

10559-5340=5219,00

Lvl 75:

http://eu.wowarmory.com/character-sheet.xml?r=Tyrande&n=Nin%C3%AE

10918-6060=4858,00

Lvl 74:

http://eu.wowarmory.com/character-sheet.xml?r=C%27Thun&cn=Chevignon

9831 - 5310=4521,00

Lvl 73:

http://eu.wowarmory.com/character-sheet.xml?r=Tyrande&n=Gagxan

8777-4570=4207,00

Lvl 72:

http://eu.wowarmory.com/character-sheet.xml?r=Los+Errantes&n=Ertedan

10015-6100=3915,00

Lvl 71:

http://eu.wowarmory.com/character-sheet.xml?r=Exodar&n=Chamanusco

(Tauren +5% base health)

(9036 - 5210)/1,05=3643,81

Lvl 70:

http://eu.wowarmory.com/character-sheet.xml?r=Exodar&n=Eshu

7200-3810=3390,00

The others lvls have been calculated with de Average.

DELETE from `player_classlevelstats` where `class` = 7;
INSERT INTO `player_classlevelstats` (`class`, `level`, `basehp`, `basemana`) VALUES
(7, 80, 6960, 4396),
(7, 79, 6447, 4252),
(7, 78, 6027, 4108),
(7, 77, 5609, 3965),
(7, 76, 5219, 3821),
(7, 75, 4858, 3677),
(7, 74, 4521, 3533),
(7, 73, 4207, 3389),
(7, 72, 3915, 3246),
(7, 71, 3644, 3102),
(7, 70, 3390, 2958),
(7, 69, 3131, 2814),
(7, 68, 2898, 2670),
(7, 67, 2675, 2527),
(7, 66, 2461, 2383),
(7, 65, 2258, 2239),
(7, 64, 2064, 2095),
(7, 63, 1880, 1951),
(7, 62, 1691, 1808),
(7, 61, 1525, 1664),
(7, 60, 1421, 1520),
(7, 59, 1324, 1501),
(7, 58, 1281, 1467),
(7, 57, 1228, 1448),
(7, 56, 1188, 1414),
(7, 55, 1148, 1395),
(7, 54, 1099, 1376),
(7, 53, 1062, 1342),
(7, 52, 1026, 1323),
(7, 51, 980, 1289),
(7, 50, 945, 1255),
(7, 49, 902, 1236),
(7, 48, 870, 1202),
(7, 47, 828, 1183),
(7, 46, 798, 1149),
(7, 45, 758, 1115),
(7, 44, 731, 1096),
(7, 43, 693, 1062),
(7, 42, 668, 1028),
(7, 41, 632, 1009),
(7, 40, 609, 975),
(7, 39, 576, 941),
(7, 38, 544, 922),
(7, 37, 523, 888),
(7, 36, 494, 854),
(7, 35, 465, 820),
(7, 34, 448, 786),
(7, 33, 421, 767),
(7, 32, 395, 733),
(7, 31, 371, 699),
(7, 30, 358, 665),
(7, 29, 335, 631),
(7, 28, 314, 598),
(7, 27, 294, 566),
(7, 26, 275, 535),
(7, 25, 256, 505),
(7, 24, 250, 476),
(7, 23, 234, 448),
(7, 22, 219, 421),
(7, 21, 205, 395),
(7, 20, 192, 370),
(7, 19, 181, 346),
(7, 18, 170, 323),
(7, 17, 160, 301),
(7, 16, 152, 280),
(7, 15, 144, 260),
(7, 14, 137, 241),
(7, 13, 129, 223),
(7, 12, 122, 206),
(7, 11, 114, 190),
(7, 10, 107, 175),
(7, 9, 99, 161),
(7, 8, 92, 148),
(7, 7, 84, 136),
(7, 6, 77, 125),
(7, 5, 69, 115),
(7, 4, 62, 106),
(7, 3, 54, 98),
(7, 2, 47, 91),
(7, 1, 40, 85);

[Sephiroth1983]

I doubt mangos added level 80 correct base health values for each class. Just for level 70 were perfect as I remember (DiSlord fixed those).

[bulek]

http://www.wowwiki.com/Patch_3.2.0

  Shaman
   * Base health increased by approximately 7% to correct for shamans having lower health than other classes. 

I have tried this sql and it works:

UPDATE `player_classlevelstats` SET `basehp`= `basehp` * 1.07 WHERE class = 7;

I use YTDB R51 and mangos 8781.

Your fix works only for new characters are created with the player but not for the old are already level 80:(

[DiffuSer]

bulek, you are wrong. Worked for all characters base stats.

[Dietrich]

bulek, you are wrong. Worked for all characters base stats.

Indeed, works as intended.

[bulek]

sry my fail , fix is correct

[Revils]

I think you should use fixed values rather the old value in db * 1.07 otherwise if you wrongly run the query more than once you'll keep increasing HP stat

[darkstalker]

it might be already fixed depending on your database provider too

[Raynar]

You are right.

Updated my first post with the secure method.

I use Mangos 8781 and latest rev of YTDB R51 and it isn't implemented.

[Cobra101]

I'm assuming what he/she/it meant was, possibly it won't work for max level characters. Since there's no level up to be done, there's no changes to be made. Either way, it does work. B)

[Raynar]

I'm assuming what he/she/it meant was, possibly it won't work for max level characters. Since there's no level up to be done, there's no changes to be made. Either way, it does work. B)

It works, try it

[Cobra101]

Just tossing in my theory on why it shouldn't. lol. But yes it does work. We've already got it @ PS.

[Raynar]

sorry, my english sucks!! My apologizes.

[VladimirMangos]

Only _proper_ data collection and calculation by each level base at armory data will accepted.

Like fast fix will not accepted.

[Raynar]

Ok, I'll do.

[Raynar]

First post updated with the armory data.

[Dietrich]

Only _proper_ data collection and calculation by each level base at armory data will accepted.

Like fast fix will not accepted.

All proper data collection was made for the last 11 levels, anything more needed?

[Raynar]

bump...

Most shamans on my list are level 80 NOW.

[przemratajczak]

http://www.warcrafter.net/sandbox i don't know if it can be reference tool but friend form offi shown me this as good working.you can compare it with characters from wowarmory and see if it works.

[Raynar]

Its a great work but the exact values of HP aren't correct

The search is very usefull. If VladimirMangos tell me anything more to do, I will use it.

[VladimirMangos]

when health or another stats checks need propertly check if total percent talents applied and remove this percent from toall value before subtract buff. I read that data updates, but i need find time to check it partly at least. As always too many task in queue (or random pool maybe).

[Raynar]

Yes, I had in mind talents and racial abilities to calculate the results.

Don't worry, no hurry. I just want to help.

[VladimirMangos]

As i check from start values must be: (7, 12, 114, 206), so aprox. recalculation work incorrectly and need check all levels.

And for 12 level is same as old value. Possible it updated not from start. So maybe possible less work do just by found point when value start different from already listed.

This more work ofc but will let have expected health really. Ofc, for 1-9 levels it still aprox. values.

Suggested by you levels for 70-80 as i check some correct.

Can you check other levels when possible... ?

[Raynar]

The problem is to find a shaman of each level in the armory T_T

I'll try...At least for de last 40 levels

[VladimirMangos]

I understand, i also have this problems when do with Dislord original table content.

If you will not find some this will not problems, just mark its and select value by near.

When i will review maybe i will attempt find some with some chance success.

Sometime goo remember links for characters with 1-2-3 level donw and recheck at next day