We need help editing HP per reset.

[Stanizzle]

So we have a brilliant idea to balance out PVP on the server even at high resets. Simply increasing the Max HP that a player could have.

The idea is that every reset, a player's MAX HP goes up by X amount. We want to make a script for this, except we can't figure out where exactly the Max HP is stored.

We know that we will have to edit the monsters' damage to balance out the PVE as well, we'll do that, but the only thing we are struggling is the MAX HP, and where it's defined. We know that the HP that is stored in the DB char table shows how much HP a player has OUT of the max HP. We need to find out where the Max HP per level is stored, so we can edit it!

For example. My character has 100/200 HP. We know that 100 is stored in the chartable in the DB, and what we're struggling to find is where the 200 is stored, and how can we raise it?

WHERE IS MAX HP DEFINED! Someone, please give us some helpful insight on this. Thank you very much in advance.

[MentaL]

[Alphakilo23]

Have you tried to reverse engineer your reset script?

[xXxAxXx]

The reset script we understand how it works.I dont think you understood what we want to do so let me explain better.
Lets take a FB character with lvl 0.The max HP that char can get at lvl 0 is 330
In the GAMEDB.dbo.cabal_character_table the field HP is defining the Characters HP not the Maximum HP(in this case is 330)
We also discovered that 1 point of HP in the database is 65537

We also know that for every level you make your max HP is increases 330->332->335 and so on....
Where is that defined in the game?so we can se how it works and maibe if lucky we will improve the pvp system.

[PunkS7yle]

Just increase their HP mastery level...it can go up to 255.

[xXxAxXx]

Just increase their HP mastery level...it can go up to 255.

Can you give more details please?

[Alphakilo23]

I've got the gist. I have never ran across this value stored in the DB. I cba to set up a test server atm, but I'd profile the SQL server to see what actually happens when a character levels up. Or when the max HP changes in general (due to equipment, skills (like HP mastery), etc.).

For profiling, I'd recommend this utitlity. It's free, and I find it more comfortable to use than the Microsoft solution, but you have to register.

[Stanizzle]

Just increase their HP mastery level...it can go up to 255.

I want it to be based on resets. Here's the issue:

There were a few solutions presented. 1, your offer, which we thought about, and 2, an earlier posted fix with the defense given per stat point. BUT HERE'S THE PROBLEM WITH THAT. Even though you will be evening out PVP at LATER resets, you will now be unbalancing PVP at earlier resets.

With the HP mastery level adjustment, a person who is at 1 reset will be able to receive the same amount of HP as a person with 300 rests. So for the lower reset players, the damage will be WAY too weak to kill players with the equal amount of resets that hey have. So even though we will balance out PVP at high resets, we will UNbalance PVP at low resets.

With the defense per stat point adjustment, the person at a low reset pvping a person with same amount of resets (low resets) will take forever to kill the other due to the lack of a damage boost, so same issue occurs.

We need to adjust it BASED ON RESETS, so adding HP PER RESET, or adding defense PER RESET. There is no other way around it. The adjustment has to be made PER RESET.

Any other thoughts anyone? And I really appreciate your interest and thought that you guys are putting into this. It definitely doesn't go unnoticed. Thank you for your thoughts and replies.

[S37uP!Update]

Well,i don't know if this will help you,but i'll give a try.

You can try to add a stored procedure like that :

UPDATE cabal_character_table SET HP = (AMOUNT HP) WHERE Resets = (AMOUNT RESETS)

Eg. UPDATE cabal_character_table SET HP = 15000 WHERE Resets = 100

PS:If you add a line for update at every reset will make the SQL to create lag i guess,i suggest you to do that like every 50 resets or depend about what is the maxim resets on your server.

[xXxAxXx]

Well,i don't know if this will help you,but i'll give a try.

You can try to add a stored procedure like that :

UPDATE cabal_character_table SET HP = (AMOUNT HP) WHERE Resets = (AMOUNT RESETS)

Eg. UPDATE cabal_character_table SET HP = 15000 WHERE Resets = 100

PS:If you add a line for update at every reset will make the SQL to create lag i guess,i suggest you to do that like every 50 resets or depend about what is the maxim resets on your server.

Yes i know how to make SP and what to give the problem is that you cant give more the the max lvl atribuited by the current lvl of the character.So i can make the SP put at 10 resets the HP to 1000 but once he gets in the game with lvl 1 after the 10 reset the characters life will be the max defined at lvl 1 wich is 330
I am shure that if we all work togheter we will find a solution for this.

[S37uP!Update]

Yes i know how to make SP and what to give the problem is that you cant give more the the max lvl atribuited by the current lvl of the character.So i can make the SP put at 10 resets the HP to 1000 but once he gets in the game with lvl 1 after the 10 reset the characters life will be the max defined at lvl 1 wich is 330
I am shure that if we all work togheter we will find a solution for this.

Yes,that's true,well...i guess this will gonna need to change some values in .scp files too,because let's say that we will figure out how to solve the DB things,but the server files have some configurations...right now i'm lookin in the DB to see how this work,maybe i can figure out where hp is linked and how he work...i will come later with a reply or edit with my result,if i found one.

[xXxAxXx]

We allready looked throw the files of the server to without succes.Nothing about maxHP.

[S37uP!Update]

So how did you figured out that 1 point of HP in the database is 65537?

[xXxAxXx]

Actually Stan found out.I will tell him now to come and explain. ;)

[SpeedDevil]

So how did you figured out that 1 point of HP in the database is 65537?

Probably checking a characters HP and dividing the number in the database by the number in-game?

[xXxAxXx]

He created a char, i looked at he HP value, he went in game and let the HP full recharge ,i looked again at the HP value the compared the values and did what SpeedDevil sed above.