Warrior level stats bug...

If you take a close look to the [I]player_classlevelstats[/I] table in the world database, you'll notice that the warriors (class = 1) at level 10 have a base hp of 101 and at level 11 base hp = 100. Indeed, there is something wrong in the database. You can investigate closer and do a PR when you have some spare time.

Edit

Not only warriors loose hp when they grow up. Look closer at class 2, level 1 & 2 :)

I found a part of code in a posts:
switch(Class)
{
case WARRIOR:
if(Level else if(Level else if(Level >60) TotalHealthGain+=Level+100;
else TotalHealthGain+=2*Level-30;
break;
case HUNTER:
if(Level else if(Level >60) TotalHealthGain+=Level+45;
else TotalHealthGain+=Level+4;

if(Level else if(Level else if(Level>60)TotalManaGain+=Level+20;
else TotalManaGain+=45;
break;
case ROGUE:
if(Level else if(Level >60) TotalHealthGain+=Level+110;
else TotalHealthGain+=Level+2;
break;
case DRUID:
if(Level else if(Level >60) TotalHealthGain+=Level+55;
else TotalHealthGain+=Level;

if(Level else if(Level>60)TotalManaGain+=Level+25;
else TotalManaGain+=45;
break;
case MAGE:
if(Level else if(Level >60) TotalHealthGain+=Level+40;
else TotalHealthGain+=Level-8;

if(Level else if(Level>60)TotalManaGain+=Level+26;
else TotalManaGain+=51;
break;
case SHAMAN:
if(Level else if(Level >60) TotalHealthGain+=Level+75;
else TotalHealthGain+=Level+1;

if(Level else if(Level>60)TotalManaGain+=Level+70;
else TotalManaGain+=49;
break;
case WARLOCK:
if(Level else if(Level >60) TotalHealthGain+=Level+50;
else TotalHealthGain+=Level-2;

if(Level else if(Level>60)TotalManaGain+=Level+25;
else TotalManaGain+=51;
break;
case PALADIN:
if(Level else if(Level >60) TotalHealthGain+=Level+55;
else TotalHealthGain+=Level+4;

if(Level else if(Level>60)TotalManaGain+=Level+100;
else TotalManaGain+=42;
break;
case PRIEST:
if(Level else if(Level >60) TotalHealthGain+=Level+40;
else TotalHealthGain+=Level-6;

if(Level else if(Level else if(Level>60)TotalManaGain+=Level+35;
else TotalManaGain+=54;
break;
}

// Apply HP/Mana
lvl->HP = lastlvl.HP + TotalHealthGain;
lvl->Mana = lastlvl.Mana + TotalManaGain;
I don't know whether it's an offical code, but it seems like mangos use this code. So I check the warrior's HP in each level in WOW game, and the number is correct.I don't know how this basehp comes out in database, and don't know relationship between basehp and maxhp, but it works fine.
In game,when I set level from 1 to 2, the message states that you gain 9 hit point. But acturally it increase 19 hit point, and 9 is the two levels basehp subtraction. So maybe the sever return wrong parameter.

But I acturally find a mistake in database, while the warrior's level is 19, the hit point doesn't correct. So I modify the number and check it over and over agian, and finally I found the correct number.
And the fix is blow here.
update player_classlevelstats set basehp = 183 where class =1 and level =19;

I don't speak English, sorry for my poor English. :)