sorry 4 dis post it was a mistake
Printable View
sorry 4 dis post it was a mistake
Here's Your Request:
CREATE TRIGGER [dbo].[Auto_Reborn] ON [dbo].[ChaInfo]
after update
as
BEGIN
Update [ChaInfo] set [ChaInfo].ChaReborn = 0,[ChaInfo].ChaTribe = 1
from Inserted
Where Inserted.ChaTribe = 0
Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaReborn=[ChaInfo].ChaReborn + 1,
[ChaInfo].ChaExp=0,
[ChaInfo].ChaStRemain = (100*[ChaInfo].ChaReborn),
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 2000000,
[ChaInfo].ChaSkillPoint = (10*[ChaInfo].ChaReborn)
From Inserted
Where Inserted.ChaLevel = 240
and [ChaInfo].ChaReborn < 100
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 2000000
End
Here's the script that you need...
Reborn Lvl: 240
Max Reborn: 100 (you can edit this if you want)
no Rollback of skills and stats.. (remain stats)
Before Setup Continues plz make a Column
RanGame1>>Tables>>ChaInfo>>right click at ChaInfo then Click Design
u have see ChaNum and blablabla...Look ChaReborn..if u cannot have please do like this...>>Colum Name- ChaRebron Data Type- smallint and last 1 Allow Nulls just click tick there..
Good Luck ^^