[Req] Auto Reborn Script (remain stat)

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)

Quote:

---

Originally Posted by jeiemXbytes08

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)

---

sir i have have a problem w/ ur script can u help me plss

"Msg 207, Level 16, State 1, Procedure Auto_Reborn, Line 6
Invalid column name 'ChaReborn'."

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 ^^