-
We need help editing HP per reset.
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.
-
Re: We need help editing HP per reset.
Have you tried to reverse engineer your reset script?
-
Re: We need help editing HP per reset.
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.
-
Re: We need help editing HP per reset.
Just increase their HP mastery level...it can go up to 255.
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
PunkS7yle
Just increase their HP mastery level...it can go up to 255.
Can you give more details please?
-
Re: We need help editing HP per reset.
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.
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
PunkS7yle
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.
-
Re: We need help editing HP per reset.
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.
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
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.
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.
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
Popa Andrei
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.
-
Re: We need help editing HP per reset.
We allready looked throw the files of the server to without succes.Nothing about maxHP.
-
Re: We need help editing HP per reset.
So how did you figured out that 1 point of HP in the database is 65537?
-
Re: We need help editing HP per reset.
Actually Stan found out.I will tell him now to come and explain. ;)
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
S37uP!Update
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?
-
Re: We need help editing HP per reset.
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.
-
Re: We need help editing HP per reset.
So you just looked in cabal_character_table at your char HP right?Well,i don't know but i checked all stored procedures part by part and all tables but i couldn't find something with hp per level,or something similar,so i think finally this is from .scp files,i don't know...
-
Re: We need help editing HP per reset.
It could be defined in the cabalmain.exe to?
We looked to in the database but now its good that you confir to that nothing about Max Hp there.Now let`s se again the srv files..
-
Re: We need help editing HP per reset.
Well,i found something intresting in rank.scp,i don't know if is per level but here is :
Code:
[BattleStyleData] AttackCoef MagAttCoef DefensCoef AttckRCoef DefenRCoef StatMaxAtt StatMagAtt StatDefens StatAttckR StatDefenR InitHP InitMP DeltaHP DeltaMP MinDmgRate
0 <null> <null> <null> <null> <null> <null> <null> <null> <null> <null> <null> <null> <null> <null> <null>
1 8,-5 5,-4 6,-6 7,-7 7,-7 3000,2000,0 1000,1000,3000 1500,1500,0 4000,17500,4000 2000,10000,1000 50 20 30 10 80
2 7,-4 5,-4 6,-6 10,-10 10,-10 2500,2500,0 1000,1000,3500 1500,1500,0 20000,20000,4000 12000,12000,1000 50 20 30 10 90
3 5,-4 8,-7 7,-6 7,-7 7,-7 2000,1000,1000 0,1000,3500 1250,1250,750 4000,17500,4000 1500,10000,4000 40 30 20 20 85
4 5,-5 6,-5 5,-5 8,-7 7,-7 2000,1200,1000 0,1800,3000 1250,1250,750 4000,17500,4000 1000,10000,1500 40 30 20 20 85
5 6,-2 5,-4 7,-6 8,-7 3,-3 2500,2300,1000 500,2500,2900 2500,1800,1100 4000,17500,4000 2000,10000,1000 45 25 25 15 85
6 6,-3 5,-4 6,-6 8,-8 5,-5 2400,2300,1000 500,2500,2850 1250,1250,1000 4000,17500,4000 1000,10000,1000 45 25 25 15 85
Code:
[New_HP] Style BDelta
0 1 500
1 2 389
2 3 79
3 4 184
4 5 310
5 6 310
-
Re: We need help editing HP per reset.
[New_HP] We allready tried changing that but nothing happend.Also changed delta and initHP and still nothing
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
Popa Andrei
[New_HP] We allready tried changing that but nothing happend.Also changed delta and initHP and still nothing
Did you change that in the client as well?
-
Re: We need help editing HP per reset.
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
S37uP!Update
Well,i found something intresting in rank.scp,i don't know if is per level but here is :
Code:
[BattleStyleData] AttackCoef MagAttCoef DefensCoef AttckRCoef DefenRCoef StatMaxAtt StatMagAtt StatDefens StatAttckR StatDefenR InitHP InitMP DeltaHP DeltaMP MinDmgRate
0 <null> <null> <null> <null> <null> <null> <null> <null> <null> <null> <null> <null> <null> <null> <null>
1 8,-5 5,-4 6,-6 7,-7 7,-7 3000,2000,0 1000,1000,3000 1500,1500,0 4000,17500,4000 2000,10000,1000 50 20 30 10 80
2 7,-4 5,-4 6,-6 10,-10 10,-10 2500,2500,0 1000,1000,3500 1500,1500,0 20000,20000,4000 12000,12000,1000 50 20 30 10 90
3 5,-4 8,-7 7,-6 7,-7 7,-7 2000,1000,1000 0,1000,3500 1250,1250,750 4000,17500,4000 1500,10000,4000 40 30 20 20 85
4 5,-5 6,-5 5,-5 8,-7 7,-7 2000,1200,1000 0,1800,3000 1250,1250,750 4000,17500,4000 1000,10000,1500 40 30 20 20 85
5 6,-2 5,-4 7,-6 8,-7 3,-3 2500,2300,1000 500,2500,2900 2500,1800,1100 4000,17500,4000 2000,10000,1000 45 25 25 15 85
6 6,-3 5,-4 6,-6 8,-8 5,-5 2400,2300,1000 500,2500,2850 1250,1250,1000 4000,17500,4000 1000,10000,1000 45 25 25 15 85
Code:
[New_HP] Style BDelta
0 1 500
1 2 389
2 3 79
3 4 184
4 5 310
5 6 310
Under DeltaHP column, that's the HP that have been increased every level.
Example: Row 1 which is BattleStyle = 1 (Warrior) DeltaHP = 30
means it gives 3 HP every level. :)
already tested and implement on my server. dont forget to change on client side to see the effect of your modification.
-
Re: We need help editing HP per reset.
Yes,that's why you didn't see the modifications because the client side must be modified too,and is exactly how i tought,that can't be from DB...i sayd that from the beggining...
-
Re: We need help editing HP per reset.
Tomorow Stan will look in the client files because he is more int that then me.I am with the DB stuff and site, and well be back with a reply ;)
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
mikkomoley
Under DeltaHP column, that's the HP that have been increased every level.
Example: Row 1 which is BattleStyle = 1 (Warrior) DeltaHP = 30
means it gives 3 HP every level. :)
already tested and implement on my server. dont forget to change on client side to see the effect of your modification.
This would work in increasing HP per level, but how can I make this turn into increasing HP per reset?
Another solution would be this: Is there any way that I can make an attribute give HP? The more resets a player has, the more stats the player has. if I can balance out each attribute point to give X amount of HP, then that would be based on stats, which is based on resets.
So two follow up questions due to your good information.
1. How can I change the HP per reset using the information of changing the HP per level?
2. How can I make stats like STR, DEX, INT give +1 MAX HP per stat point?
Thank you very much for all of your interest and input again. You guys are really great and inspire us to do some great work.
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
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.
THE PROGRAM IS AWSEOME.
Now best thing is a test server and what what SP are runned when lvling(if there is any)
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
Popa Andrei
Tomorow Stan will look in the client files because he is more int that then me.I am with the DB stuff and site, and well be back with a reply ;)
-------------------------------------------------------------------
I hate when you guy come here ask for help and when you manage to resolve the issue ALL of you comes with "Solve" close the thread please.That is not how this works.If you open a thread and ask for help and you manage to solve the issue post your solution to,someone else may need it.
STOP BEING LECHERS DUDES
Sorry for off topic but someone must "palm" this guys...
-------------------------------------------------------------------
Sorry to give you your own message...but that's exactly how i guessed from the beggining...
-
Re: We need help editing HP per reset.
we didnt solved anything.Today we were(me and Stan) both busy.And dont wory,if we find a solutiong we are going to share.I know you want this to implemented in your server and i repet if we all work togheter like we did now on this we can acomplish more ;)
Tomorow after 17:00 we will come with what we have succeded to do or not.
Regards.
-
Re: We need help editing HP per reset.
No,i don't want it :P my server have already solved the PVP/PVE bllance,this is for other ppl.
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
S37uP!Update
No,i don't want it :P my server have already solved the PVP/PVE bllance,this is for other ppl.
Yes but i am shure thtat you incresed the defense or just the hp/level.
We want to change that to HP / resets ;)
-
Re: We need help editing HP per reset.
:) Not really,until maxim resets PVE is ballanced,after that when you reach maxim resets PVP will be ballanced automatically(Some SQL SP),and in this way the PVP/PVE is ballanced :P
-
Re: We need help editing HP per reset.
-
Re: We need help editing HP per reset.
No,because i don't know how this work,i payd some one to do that for me,if you wish i can give you his contact ID , just PM me,maybe he will do it for free for you,but i wanted to help you here because i don't like the way to pay some one who learned from somewhere.
Really now,i really don't know how he do it,but he do it.
-
Re: We need help editing HP per reset.
Dont need it at the moment.I want to make an identic test server on mi pc ussing virtualbox and use the tool that Alpha showed to me in post nr 6 to se what happens in the database.I am shure that tool will help me alot.
Like i sed before i will update once i have something good to share.
EDIT: Your inbox of PM is full.Noone can send PM`s to you atm.Empty it.
-
Re: We need help editing HP per reset.
Uhmm,well maybe if you need me to look into my server for some changes,i can help you with that i guess...
My PM :
Inbox contains 0 messages.
You have 0 messages stored, of a total 100 allowed.
-
Re: We need help editing HP per reset.
After strugeling for 1 day to setup the test server( in never thought that making the srv on windows is so hard) i made it and used DataSql Profiler to se if there is an SP trigerd when leveling up and unfortunately there is not :|
Mi gues is that this is defined by the game engine.
Now lets se what else can we find out with the sql profiler :D
Going to make more test with it. ;)
S37uP!Update check your usercp setting because you have disabled the option to recive PM`s that is why noone can send you pms.
-
Re: We need help editing HP per reset.
-
Re: We need help editing HP per reset.
Ok i have tried it all,purify epaulet,potion,everything that give extra maxHP but no SP runned in the database.
How is this defined in the game.What triggers when you get more maxHP to a char?
-
Re: We need help editing HP per reset.
Well i looked into my db's and all trigers are only for features like,Premium update,maps code,reputation,this kind of options,nothing with max hp.
-
Re: We need help editing HP per reset.
But you sed your is fixed.Can you give more details on how its working ingame,i mean what stats has a max resets user(attr,defr,at,def...)
-
Re: We need help editing HP per reset.
Ok,i will ask a some one from my staff to make a list,i'm a litte busy with solveing the LAG ISSUE,that stress me out...i will reply here the list when is done.
-
Re: We need help editing HP per reset.
i think its impossible
cuz no one official game not have reset abilyties
also cabal not have vitality stat like on mu as example
i suggest you up hp per class rank, but for balanse make more strong mobs for class rank 12-18
can make sp with something like this set hp=hp+(hp*0,3)
Posted via Mobile Device
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
Avalansh93
i think its impossible
cuz no one official game not have reset abilyties
also cabal not have vitality stat like on mu as example
i suggest you up hp per class rank, but for balanse make more strong mobs for class rank 12-18
can make sp with something like this set hp=hp+(hp*0,3)
Posted via Mobile Device
Nothing is imposible,mu online official doesn't have reset system,but the reset system was added in some files like :
http://forum.ragezone.com/f197/igcn-...de-3-a-821792/ :
Character Resets displayed on Character Selection List - HOT
Character Resets displayed in 'C' window - HOT
----------------------------------------------
Well , nothing is imposible,is hard but not imposible :tongue:
-
Re: We need help editing HP per reset.
With a little help from Speedy we have a idea how to make this.
We made a new skill based on the vitality mastery except the user of this skill will be to give at every new lvl 30000 extra maxHP points.
Now the problem is to make the skill to be leveled up only at our desired resets,we know that to make the skills have an upgrade limited based on resets from in game its very hard(almost impossible)because that will mean changing the server binary.
BUT
If i manage to make a web interface that manages the skills (like BalQ`s cabal toolz),well... That will resolve our issue and will offer the players the way of getting that skill and update it when available.
Got your attention ha? :8:
Here is how the skills are stored in the database.
(BIG THANKS TO SPEEDY FOR HELPING FIGURE IT OUT)
The skills are saved in binary data in the GAMEDB.dbo.cabal_skilllist_table
This is the data of the skills of an character
Code:
0x4D01014654010148550101497C01014E7D01014F7E0101507F0101519001014BCF011452A5010166A6010167
Now if we take this data separate the first 0x and the rest will make them into groups of 8 we will get the Skill-Level-Slot
Quote:
0x 4D010146 54010148 55010149 7C01014E 7D01014F 7E010150 7F010151 9001014B CF011452 A5010166 A6010167
Lets take the first one
In the code above first 4 reprezents the skill
4D01 = in dec data is 333 SKILL
NOTE: when converting the skill from hex to dec you must swap the data from 4D01 to 014D
01 = in dec data is 1 LEVEL
46 = in dec data is 70 SLOT USED
If someone is interested in working with me on this contact me.
Regards.
-
Re: We need help editing HP per reset.
Does anyone know how to change skill level based on resets through the site or something of that sort?
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
Stanizzle
Does anyone know how to change skill level based on resets through the site or something of that sort?
Which site? ^-^
You can change the skill level via a GM Tool (take a look in the Release Sektion).
The Skill level change per reset, thats like swaping hp per reset.
But you have to work with the SQL as far as i know.
Greetz
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
Stanizzle
Does anyone know how to change skill level based on resets through the site or something of that sort?
Just check for values,
if resets = 30 run an SQL query that will increase the chars skill level to 15.
-
Re: We need help editing HP per reset.
well, we need an sql query that will read the skill level, read the number of resets, and then decode the binary data, change the binary data, encode it again, upload it based on resets, and save it... It's complex.
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
Stanizzle
well, we need an sql query that will read the skill level, read the number of resets, and then decode the binary data, change the binary data, encode it again, upload it based on resets, and save it... It's complex.
Want us to upgrade your server as well ? Maybe take care of it for you ?
/sarcasm off.
It's not complex at all, just check the values posted on the last page.
-
Re: We need help editing HP per reset.
If you need mssql queries KLICK ME HARD
Greetz
-
Re: We need help editing HP per reset.
Anyone have something actually helpful? If you have nothing useful to post, please refrain from posting here, thanks.
-
Re: We need help editing HP per reset.
As far as I can tell, the replies you got were helpful (if not a little sarcastic...). You are asking for general help now for creating a stored procedure that really doesn't have much to do with CABAL. You know where the data you need is stored, so all you need to do now is learn how to create a stored procedure. Google is an excellent place to start, and schneemann even provided you with a link to the MSDN page for stored procedures. I'm afraid RaGEZONE isn't a soup kitchen. People will be quite unwilling to just do all of the work for you. You will need to put some effort in, yourself.
-
Re: We need help editing HP per reset.
Quote:
Originally Posted by
Stanizzle
Anyone have something actually helpful? If you have nothing useful to post, please refrain from posting here, thanks.
GTFO, even after I told you what to do you want us to do it for you too ?
Piece of advice .. HIRE SOMEONE.
-
Re: We need help editing HP per reset.
I'd be willing to pay someone to write this stored procedure for me. Point me in the direction of someone who can do it. =)
-
Re: We need help editing HP per reset.
Try the Merchant Zone, not here.
