Newbie Spellweaver
- Joined
- Apr 29, 2007
- Messages
- 43
- Reaction score
- 1
Hi. I want to share my reset stats procedure.
Level up points depends on Reset count, Second class and Marlon Quest presence. Also, 500kk zen will be paid.
Usage: EXECUTE ResetStats Nick where Nick is character name.
Also, i replaced MuWeb reset scripts with Stats Reset script. Modified files attached.
Sorry for russian language in characters.php You can use standard Characters.php from MuWeb developer- only modify zen count you'll take from players for resetting their stats. And don't forget to set ResetLevel = 1 in MuWeb admin panel
For reset system is better to use jobs. That's why i replaced MuWeb reset scripts with Stats Reset script.
Good luck!
Code:
CREATE PROCEDURE ResetStats
@charname1 varchar(10)
AS
begin
set nocount on
declare @charname varchar(10)
declare @find_id varchar(10)
Set @find_id = 'NOT'
select @find_id = S.Name from Character S INNER JOIN AccountCharacter I ON S.Name = I.GameIDC
where I.GameIDC = @charname1
UPDATE character SET
Money=Money-500000000,
Strength = Case when ((class = 0) OR (class = 1)) then 18 --DW SM
when ((class = 16) OR (class = 17)) then 28 --DK BK
when ((class = 32) OR (class = 33)) then 22 --Elf MElf
when (class = 48 ) then 26 --MG
when (class = 64) then 26 --DL
End,
Dexterity = Case when ((class = 0) OR (class = 1)) then 18 --DW SM
when ((class = 16) OR (class = 17)) then 20 --DK BK
when ((class = 32) OR (class = 33)) then 25 --Elf MElf
when (class = 48 ) then 26 --MG
when (class = 64) then 26 --DL
End,
Vitality = Case when ((class = 0) OR (class = 1)) then 15 --DW SM
when ((class = 16) OR (class = 17)) then 25 --DK BK
when ((class = 32) OR (class = 33)) then 20 --Elf MElf
when (class = 48 ) then 26 --MG
when (class = 64) then 26 --DL
End,
Energy = Case when ((class = 0) OR (class = 1)) then 30 --DW SM
when ((class = 16) OR (class = 17)) then 10 --DK BK
when ((class = 32) OR (class = 33)) then 15 --Elf MElf
when (class = 48 ) then 26 --MG
when (class = 64) then 26 --DL
End,
Leadership = Case when (class = 64) then 25
when ((class = 0) OR (class = 1)) then 0 --DW SM
when ((class = 16) OR (class = 17)) then 0 --DK BK
when ((class = 32) OR (class = 33)) then 0 --Elf MElf
when (class = 48 )
then 0 --MG
End,
LevelUpPoint = Case when (((class = 0) OR (class = 1)) AND clevel > 220) then
((clevel-220)*6)+(220*5)+(Resets*500)
when (((class = 0) OR (class = 1)) AND clevel < 220) then
(clevel*5)+(Resets*500)
when (((class = 16) OR (class = 17)) AND clevel > 220) then
((clevel-220)*6)+(220*5)+(Resets*500)
when (((class = 16) OR (class = 17)) AND clevel < 220) then
(clevel*5)+(Resets*500)
when (((class = 32) OR (class = 33)) AND clevel > 220) then
((clevel-220)*6)+(220*5)+(Resets*500)
when (((class = 32) OR (class = 33)) AND clevel < 220) then
(clevel*5)+(Resets*500)
when (class = 48 ) then
(clevel*7)+(Resets*650)
when (class = 64) then
(clevel*7)+(Resets*650)
End
WHERE Name = @charname1
end
GO
Level up points depends on Reset count, Second class and Marlon Quest presence. Also, 500kk zen will be paid.
Usage: EXECUTE ResetStats Nick where Nick is character name.
Also, i replaced MuWeb reset scripts with Stats Reset script. Modified files attached.
Sorry for russian language in characters.php You can use standard Characters.php from MuWeb developer- only modify zen count you'll take from players for resetting their stats. And don't forget to set ResetLevel = 1 in MuWeb admin panel
For reset system is better to use jobs. That's why i replaced MuWeb reset scripts with Stats Reset script.
Good luck!
Attachments
You must be registered for see attachments list
Last edited: