Auto Rb script

[kenjii012]

can someone share the auto Rb script w/ no rollback of stats and skills??



really need it...


thx in advnce

 

[jessgab]

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, -- Level that you get after reborn
[ChaInfo].ChaReborn=[ChaInfo].ChaReborn + 1, -- Reborn counter
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = (100*[ChaInfo].ChaReborn), -- how many stat points you get per reborn
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 2000000, -- Optional : Reborn cost 2m
[ChaInfo].ChaSkillPoint = (10*[ChaInfo].ChaReborn) -- Set the Skillpoints per reborn

From Inserted
Where Inserted.ChaLevel = 300 -- Level to reborn
and [ChaInfo].ChaReborn < 10 -- Max Reborn number
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 2000000 -- Optional : Require 2m gold for reborn

End

-----------------------
Just edit some parameters there to suit your need..hope it will Help you..

 

[kenjii012]

thx for the script...


working properly...

THREAD CLOSED

 

[Schneizel]

ey i don't understand @_@ can someone give some specific method?? [slow methods more like level 0/1 noob method like me wenkzz]

 

[kenjii012]

method like what???

triggering the script???

 

[Schneizel]

no... i meant where do i start, what do i must open slow methods but the script still like that

oh maybe you can put a red color if i can modify it like example i can modify the level so make it color red please

 

[PostOfTheYear]

Just modify the values .