Use MuOnline
GO
ALTER TABLE [Character] ADD Relife_count tinyint DEFAULT 0 WITH VALUES
GO
CREATE TRIGGER ReLife ON [Character] AFTER UPDATE AS
UPDATE [Character] SET [Character].Relife_count=[Character].Relife_count+1,cLevel=1,Experience=0,MagicList=null,Inventory=null, PkTime=0,PkLevel=3,LevelUpPoint=[Character].Relife_count*100,[Character].Money=[Character].Money-100000000,Strength=18,Dexterity=18,Vitality=15,Energy=30,Life=60,MaxLife=60,Mana=60,MaxMana=60,MapNumber=0,MapPosX=140,MapPosY=120,MapDir=1
FROM inserted WHERE inserted.Clevel>=350 and inserted.PkLevel<=3 and inserted.Money>=100000000 and (inserted.class=0 or inserted.class=1) and [Character].name = Inserted.name
UPDATE [Character] SET [Character].Relife_count=[Character].Relife_count+1,cLevel=1,Experience=0,MagicList=null,Inventory=null, PkTime=0,PkLevel=3,LevelUpPoint=[Character].Relife_count*100,Money=[Character].Money-100000000,Strength=28,Dexterity=20,Vitality=25,Energy=10,Life=110,MaxLife=110,Mana=20,MaxMana=20,MapNumber=0,MapPosX=140,MapPosY=120,MapDir=1
FROM inserted WHERE inserted.Clevel>=350 and inserted.PkLevel<=3 and inserted.Money>=100000000 and (inserted.class=16 or inserted.class=17) and [Character].name = Inserted.name
UPDATE [Character] SET [Character].Relife_count=[Character].Relife_count+1,cLevel=1,Experience=0,MagicList=null,Inventory=null, PkTime=0,PkLevel=3,LevelUpPoint=[Character].Relife_count*100,[Character].Money=[Character].Money-100000000,Strength=22,Dexterity=25,Vitality=20,Energy=15,Life=80,MaxLife=80,Mana=30,MaxMana=30,MapNumber=3,MapPosX=175,MapPosY=100,MapDir=4
FROM inserted WHERE inserted.Clevel>=350 and inserted.PkLevel<=3 and inserted.Money>=100000000 and (inserted.class=32 or inserted.class=33) and [Character].name = Inserted.name
UPDATE [Character] SET [Character].Relife_count=[Character].Relife_count+1,cLevel=1,Experience=0,MagicList=null,Inventory=null, PkTime=0,PkLevel=3,LevelUpPoint=[Character].Relife_count*100,[Character].Money=[Character].Money-100000000,Strength=26,Dexterity=26,Vitality=26,Energy=26,Life=110,MaxLife=110,Mana=60,MaxMana=60,MapNumber=0,MapPosX=140,MapPosY=120,MapDir=1
FROM inserted WHERE inserted.Clevel>=350 and inserted.PkLevel<=3 and inserted.Money>=100000000 and inserted.class=48 and [Character].name = Inserted.name
UPDATE [Character] SET [Character].Relife_count=[Character].Relife_count+1,cLevel=1,Experience=0,MagicList=null,Inventory=null, PkTime=0,PkLevel=3,LevelUpPoint=[Character].Relife_count*100,[Character].Money=[Character].Money-100000000,Strength=30,Dexterity=26,Vitality=26,Energy=30,Life=110,MaxLife=110,Mana=60,MaxMana=60,MapNumber=0,MapPosX=140,MapPosY=120,MapDir=1
FROM inserted WHERE inserted.Clevel>=350 and inserted.PkLevel<=3 and inserted.Money>=100000000 and inserted.class=64 and [Character].name = Inserted.name
This sql script is created by my friend iiibbbmmm, and improved by myself today for everyone here.
*The reset times in the script is Relife_count, pls change it yourself if need.
*Formula:
LevelUpPoint = Relife_count * 100
you can change it if need.
*Conditions:
1. clevel >= 350
2. money>= 100000000
3. PkLevel <=3
you can change the conditions or add any other contition if need.
wish it's a help for you.
Last edited: