StarMedia
Va asteptam in grupul nostru de pe facebook: Click

Distribuiţi
Vezi subiectul anteriorIn josVezi subiectul urmator
avatar
sKiLeTu
Extreme
Extreme
Mesaje : 960
Varsta : 23
Localizare : Moldova,Chisinau,Truseni
Sunt pe forum din : 29/12/2009

[Release] Dynamic Reset System

la data de Lun 28 Feb 2011, 20:47
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

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:

Quote:
Cod:
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:

Quote:
Cod:
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);
Finish

credits: Sylv3R
avatar
m4s4cru
Membru
Membru
Mesaje : 300
Varsta : 26
Localizare : Craiova
Sunt pe forum din : 16/02/2009

Re: [Release] Dynamic Reset System

la data de Mar 02 Aug 2011, 23:34
gg boss
Vezi subiectul anteriorSusVezi subiectul urmator
Permisiunile acestui forum:
Nu puteti raspunde la subiectele acestui forum