Ammend Magic Rollback

[dheluxe]

when I create a trigger in my SQL it succesfully executed but my problem is all characters in game having rollback. what should i do? pls help and thanks a lot..

[MentaL]

[starstrokers]

welcome back...

[lourence8]

okies about ur problem are common problem with trigger conflict in ur DB

if u observe if u have autoRB in ur Chainfo

put 1 Alter trigger and End with 1 End Only

example

ALTER TRIGGER [dbo].[Auto_Reborn] ON [dbo].[ChaInfo]
after update
as
BEGIN

"YOUR AUTOREBORN SCRIPT HERE"

END

after the Word "END"

put ur amend magic like ammend tele like this

ALTER TRIGGER [dbo].[Auto_Reborn] ON [dbo].[ChaInfo]
after update
as
BEGIN

"YOUR AUTOREBORN SCRIPT HERE"

END

BEGIN
UPDATE [ChaInfo] SET [ChaInfo].ChaSaveMap = 175,
[ChaInfo].ChaSavePosX = -1,
[ChaInfo].ChaSavePosY = -1,
[ChaInfo].ChaSavePosZ = -1
FROM INSERTED
WHERE Inserted.ChaGuName = 'DestinyRanX'
and [ChaInfo].ChaMoney > 1
and [ChaInfo].ChaLevel > 1
and [ChaInfo].ChaNum = Inserted.ChaNum
and [ChaInfo].UserNum = Inserted.UserNum
END

u can make more ammend magic by starting to "BEGIN" and end up with the word "END"

my guide helps? just press thanks ^_^

good luck

[Eureka7]

@star- welcome back?

[starstrokers]

@star- welcome back?

-->>matagal din kaya sya wala sa rz

[dheluxe]

weew... is that so... well, thank you and more power... :D

[russhimi]

@star,what are u posting lol

[Eureka7]

starstrokers is just spamming :D