• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Dynamic Reset System

Sylv3R69

Sylv3R69

Newbie Spellweaver
10 Happy Years
Joined
Aug 12, 2007
Messages
53
Reaction score
4
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
 
The Best DDoS Protected Servers
Evil_spirit

Evil_spirit

Newbie Spellweaver
Joined
Jun 3, 2008
Messages
83
Reaction score
2
anyone can understand about this thread? and what season to use it for?
 
N

naguelsito

Newbie Spellweaver
Joined
Oct 13, 2010
Messages
18
Reaction score
3
you need put the download LOL!!!

haha! :D

sorry for my bad english im argentinian ^^!
 
S

Saige

The Observer!
500 Posts 10 Happy Years
Joined
Oct 18, 2010
Messages
558
Reaction score
45
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
Click to expand...

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. :)
 
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
146
Guests online
12,039
Total visitors
12,185
Totals may include hidden visitors.

Forum statistics

Threads
429,198
Messages
4,590,913
Members
281,307
Latest member
ismodev
Most visitors online was 12720 , on 2 May 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top