Question - HP/MP 90 LV

[misshannahminx]

So I've made a ****...
Just look at my MP :
Any help to right change it ? I mean it's full str but mp sux :/ what i really need to modify and how much.
And that start stat point is 270.
Is that good for 90lv?
Help me
Gime the right query :/
Thanx and hugs.jpg

look at mp

[anton9500]

Lol 1165 mp at lv 90
you have more mp in lv 30

[intercsaki]

Lol, 1k mp. I don't know, honestly, but you f*cked up something professionally, never seen such thing.

[Callum]

[FoxRayz]

I've seen the same thing back at the time SWSRO was open but it was as a normal player, what you could do is to get into the SMC and increase the INT manually.

[Fatality™]

Well as I can see ur trying to make pvp server on which u start with lv 90. So to fix that u have to go to the Stored Procedure _AddNewChar and edit the stats to fit the lv 90. I don't have sql atm so I can't give u a screenshot >.>

[Neko*]

so simple ...
and so DUMP !


U added level 90 character
without the bounce 3 stats point of each level
just the auto-add level stat points

so u just want to change ur _AddNewChar Stored Producers
and add stats point to have the total stats in level 90 like normal system
i calculated it for ...
just add remaning stat points = 356
so that character will start with 356 stat points after he us it on STR or INT , he will get the normal stats of normal character


or just replace this area of the querey with this

INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,
LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,
GetDate(), 90, 90, 1500000, 356, 200, 200,200, 1, 1, 1, 1)

[AllStars-Minty]

The right values for the HP and MP for a pure str lvl 90 should be : STR: 376 HP: 21908 INT: 109 MP :6350 . I hope that helps.

Best regards,
Minty - AllStarsSRO Community Manager

[Neko*]

Originally Posted by AllStars-Minty

The right values for the HP and MP for a pure str lvl 90 should be : STR: 376 HP: 21908 INT: 109 MP :6350 . I hope that helps.

Best regards,
Minty - AllStarsSRO Community Manager

but the new character already has 20str and 20 int on creation
so the remaining stat points should be 376-20 = 356