Dynamic Reset System

Sylv3R69 · Feb 22, 2011

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

MuIsBest · Feb 24, 2011

Approved

19871986 · Feb 24, 2011

How this work ?

Atomixx · Feb 24, 2011

jajaja i am trolololo

Evil_spirit · Feb 25, 2011

anyone can understand about this thread? and what season to use it for?

khuongck · Feb 25, 2011

Sorry pros,I'm noob

plz explain how to use it

naguelsito · Feb 25, 2011

you need put the download LOL!!!

haha!

sorry for my bad english im argentinian ^^!

foxfirediego · Feb 25, 2011

Evil_spirit said:
anyone can understand about this thread? and what season to use it for?

khuongck said:
Sorry pros,I'm noob plz explain how to use it

naguelsito said:
you need put the download LOL!!!

haha!

sorry for my bad english im argentinian ^^!

You need to create a stored procedure on SQL Server

Saige · Feb 25, 2011

Sylv3R69 said:

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.

tutero69 · Feb 26, 2011

naguelsito said:
you need put the download LOL!!!

haha!

sorry for my bad english im argentinian ^^!

you need to READ MORE LOL !!!

to know how this thing work ,, :grr:

@ AUTHOR

NICE RELEASE very helpfull !!! :thumbup:

Welcome!

Dynamic Reset System

Sylv3R69

Newbie Spellweaver

MuIsBest

Legend

19871986

High'nLows

Atomixx

Initiate Mage

Evil_spirit

Newbie Spellweaver

khuongck

Experienced Elementalist

naguelsito

Newbie Spellweaver

foxfirediego

Junior Spellweaver

Saige

The Observer!

tutero69

Supreme Arcanarch

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor