# Dynamic Reset System

1. ## Dynamic Reset System

I created 1 reset system, work and i think very good...

Normal Reset System:

first part reset:
If you under 50 reset

350lvl = 320 stat
351lvl = 322 stat, 2 stay stat bonus
352lvl = 324 stat, 4 stay stat bonus
400lvl = 420stat, 100 stay stat bonus

second part reset:
If you after 50 reset

380lvl = 320 stat
381lvl = 322 stat, 2 stay stat bonus
382lvl = 324 stat, 4 stay stat bonus
400lvl = 420 stat, 100 stay stat bonus

If you have 1reset in 400 lvl, you give:
320 stat + 100 stay stat, so you give 420 stat

If you have 5 reset in 350, 350, 350, 351, 400, you give:
320+320+320+(320+2)+(320+100) = 1702 stat

----------------------------------------------------------------

VIP system:

first part reset:
If you under 50 reset

350lvl = 330 stat
351lvl = 333 stat, 3 stay stat bonus
352lvl = 336 stat, 6 stay stat bonus
400lvl = 480stat, 150 stay stat bonus

second part reset:
If you after 50 reset

380lvl = 330 stat
381lvl = 333 stat, 3 stay stat bonus
382lvl = 336 stat, 6 stay stat bonus
400lvl = 480 stat, 150 stay stat bonus

If you have 1reset in 400 lvl, you give:
330 stat + 150 stay stat, so you give 480 stat

If you have 5 reset in 350, 350, 350, 351, 400, you give:
330+330+330+(330+3)+(330+150) = 1803 stat

Now SQL side:

You need under 50rr: 50 millio zen, lorencia, 350lvl
You need after 50rr: 50 millio zen, lorencia, 380lvl

Create in character table:
resetlvl / int / 4 / allow null <- no
resetvip / int / 4 / allow null <- no

Here the first part code:

Code:
```Use MuOnline;
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money =
Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0,
PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip
= 0) and (Resets < 50);
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money =
Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130,
PkTime = 0, PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 64) OR (class = 65)) AND (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0)
and (resetvip = 0) and (Resets < 50);
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money =
Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0,
PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip
= 1) and (Resets < 50);
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money =
Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130,
PkTime = 0, PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 64) OR (class = 65)) AND (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0)
and (resetvip = 1) and (Resets < 50);```
second part:

Code:
```Use MuOnline;
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money = Money - (50000000),
Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip = 0) and (Resets
>= 50);
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money = Money - (50000000),
Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0,
Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 64) OR (class = 65)) AND (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0) and (resetvip =
0) and (Resets >= 50);
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money = Money - (50000000),
Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip = 1) and (Resets
>= 50);
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money = Money - (50000000),
Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0,
Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 64) OR (class = 65)) AND (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0) and (resetvip =
1) and (Resets >= 50);```
By Sylv3R  Reply With Quote

2. ## Re: Dynamic Reset System

Approved  Reply With Quote

3. ## Re: Dynamic Reset System

How this work ?  Reply With Quote

4. ## Re: Dynamic Reset System

jajaja i am trolololo  Reply With Quote

5. ## Re: Dynamic Reset System  Reply With Quote

6. ## Re: Dynamic Reset System

Sorry pros,I'm noob ;) plz explain how to use it  Reply With Quote

7. ## Re: Dynamic Reset System

haha! :D

sorry for my bad english im argentinian ^^!  Reply With Quote

8. ## Re: Dynamic Reset System Originally Posted by Evil_spirit  Originally Posted by khuongck Sorry pros,I'm noob ;) plz explain how to use it Originally Posted by naguelsito haha! :D

sorry for my bad english im argentinian ^^!
You need to create a stored procedure on SQL Server  Reply With Quote

9. ## Re: Dynamic Reset System Originally Posted by Sylv3R69 I created 1 reset system, work and i think very good...

Normal Reset System:

first part reset:
If you under 50 reset

350lvl = 320 stat
351lvl = 322 stat, 2 stay stat bonus
352lvl = 324 stat, 4 stay stat bonus
400lvl = 420stat, 100 stay stat bonus

second part reset:
If you after 50 reset

380lvl = 320 stat
381lvl = 322 stat, 2 stay stat bonus
382lvl = 324 stat, 4 stay stat bonus
400lvl = 420 stat, 100 stay stat bonus

If you have 1reset in 400 lvl, you give:
320 stat + 100 stay stat, so you give 420 stat

If you have 5 reset in 350, 350, 350, 351, 400, you give:
320+320+320+(320+2)+(320+100) = 1702 stat

----------------------------------------------------------------

VIP system:

first part reset:
If you under 50 reset

350lvl = 330 stat
351lvl = 333 stat, 3 stay stat bonus
352lvl = 336 stat, 6 stay stat bonus
400lvl = 480stat, 150 stay stat bonus

second part reset:
If you after 50 reset

380lvl = 330 stat
381lvl = 333 stat, 3 stay stat bonus
382lvl = 336 stat, 6 stay stat bonus
400lvl = 480 stat, 150 stay stat bonus

If you have 1reset in 400 lvl, you give:
330 stat + 150 stay stat, so you give 480 stat

If you have 5 reset in 350, 350, 350, 351, 400, you give:
330+330+330+(330+3)+(330+150) = 1803 stat

Now SQL side:

You need under 50rr: 50 millio zen, lorencia, 350lvl
You need after 50rr: 50 millio zen, lorencia, 380lvl

Create in character table:
resetlvl / int / 4 / allow null <- no
resetvip / int / 4 / allow null <- no

Here the first part code:

Code:
```Use MuOnline;
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money =
Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0,
PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip
= 0) and (Resets < 50);
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money =
Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130,
PkTime = 0, PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 64) OR (class = 65)) AND (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0)
and (resetvip = 0) and (Resets < 50);
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money =
Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0,
PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip
= 1) and (Resets < 50);
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money =
Money - (50000000), Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130,
PkTime = 0, PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 64) OR (class = 65)) AND (clevel >= 350) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0)
and (resetvip = 1) and (Resets < 50);```
second part:

Code:
```Use MuOnline;
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money = Money - (50000000),
Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip = 0) and (Resets
>= 50);
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (320*(Resets+1))+((clevel-350)+(resetlvl))*2, Money = Money - (50000000),
Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0,
Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 64) OR (class = 65)) AND (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0) and (resetvip =
0) and (Resets >= 50);
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money = Money - (50000000),
Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0, Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (Leadership = 0) and (CtlCode = 0) and (resetvip = 1) and (Resets
>= 50);
UPDATE Character
SET clevel = 1, Experience = 0, resetlvl = (resetlvl+(clevel-350)), LevelUpPoint = (330*(Resets+1))+((clevel-350)+(resetlvl))*3, Money = Money - (50000000),
Strength = 30, Dexterity = 30, Vitality = 30, Energy = 30, Leadership = 30+(Resets*30), MapNumber = 0, MapPosX = 130, MapPosY = 130, PkTime = 0, PkLevel = 0,
Resets = Resets + 1
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id
COLLATE Latin1_general_CI_AI
WHERE ((class = 64) OR (class = 65)) AND (clevel >= 380) AND (MapNumber=0) AND (Money >= (50000000)) AND (ConnectStat = 0) and (CtlCode = 0) and (resetvip =
1) and (Resets >= 50);```
By Sylv3R
nice code this help a lot thanks for sharing... and btw to the people who dont know how it works? will just run this query to your db. :)  Reply With Quote

10. ## Re: Dynamic Reset System Originally Posted by naguelsito haha! :D

sorry for my bad english im argentinian ^^!

you need to READ MORE LOL !!!

to know how this thing work ,, @ AUTHOR

NICE RELEASE very helpfull !!!    Reply With Quote