Question - HP/MP 90 LV

So I've made a shit...
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
[Only registered and activated users can see links. Click Here To Register...]
look at mp

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

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

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

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.

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 >.>

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

Quote:

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)

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

Quote:

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