[Release](Updated) SQL Trigger AutoReborn System Ep3/Ep4

[Michael(Kenji)]

@Genjou

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

Update [ChaInfo] set [ChaInfo].ChaLevel=300, -- Level that you get after reborn
[ChaInfo].ChaReborn=[ChaInfo].ChaReborn + 1, -- Reborn counter
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = (500*[ChaInfo].ChaReborn), -- how many stat points you get per reborn
---[ChaInfo].ChaPower = 0, -- Set the number of Pow you added to 0
---[ChaInfo].ChaStrong = 0, -- Set the number of Vit you added to 0
---[ChaInfo].ChaStrength = 0, -- Set the number of Stm you added to 0
---[ChaInfo].ChaSpirit = 0, -- Set the number of Int you added to 0
---[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 500000000, -- Optional : Reborn cost 2m
---[ChaInfo].ChaSkillPoint = (10*[ChaInfo].ChaReborn), -- Set the Skillpoints per reborn
---[ChaInfo].ChaSkills = NULL, -- Optional : Forget all skills after reborn
---[ChaInfo].ChaSkillSlot = NULL, -- Optional : Delete shortcut list of skills
---[ChaInfo].ChaQuest = NULL -- Optional : Delete quest list (need restart all quests) after reborn

From Inserted
Where Inserted.ChaLevel = 250 -- Level to reborn
and [ChaInfo].ChaReborn < 5 -- Max Reborn number
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaBright >= 0 -- Optional : Require 0 or more attr for reborn
and [ChaInfo].ChaMoney >= 1 -- Optional : Require 2m gold for reborn

End 

[mk1489]

@Genjou

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 = 3000+[ChaInfo].ChaStRemain, -- how many stat points you get per reborn
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 500000000 -- Optional : Reborn cost 500m
From Inserted
Where Inserted.ChaLevel = 300 -- Level to reborn
and [ChaInfo].ChaReborn < 5 -- Max Reborn number
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 500000000 -- Optional : Require 500m gold for reborn
and [ChaInfo].ChaOnline=0

End

[mk1489]

bump~

1st post updated.

[jeiemXbytes08]

Thnks For Sharing.............

^_^..

[bernZ07]

thanx man....☺☺☺

[Jolin88]

every single reborn script in this topic is copyed from Tammy's reborn topic (learn to SQL script yourself don't copy without credits bastards!)
And they ALL have the dual reborn bug
try get the reborn level and don't relog and see the reborn counter go up and up every hour

[mk1489]

hmm.. im just sharing wat i did, and 1st of all i don't know who's Tammy's ^_^, and about the bug i already test it, no jump reborn w/ this script. I'm not bastard :P

@Jolin if you think i copy this trigger, ok i will put credits to Tammy

[the_eliter]

@Jolin88

try get the reborn level and don't relog and see the reborn counter go up and up every hour

sir this is my current problem, im using your RB script

[mk1489]

@Jolin

Where Inserted.ChaLevel = 300 -- Level to reborn
and [ChaInfo].ChaReborn < 100 -- Max Reborn number
and [ChaInfo].ChaName=inserted.ChaName 
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 30000000 -- Optional : Require 30m gold for reborn
and [ChaInfo].ChaOnline=0

as you can see the code, i put chaonline=0 so they need to be offline to reborn, so this script will not function if they are online.

[the_eliter]

^
^
^
^
bro i thnk chaonline 0 is useless :D look at my RB :D simple script but always jump :))

Update ChaInfo
set [ChaInfo].ChaLevel= 1,,
[ChaInfo].ChaReborn = [ChaInfo].ChaReborn +1,
[ChaInfo].ChaStRemain = [ChaInfo].ChaStRemain + 400 + (200*([ChaInfo].ChaReborn)),
[ChaInfo].ChaExp=0,
[ChaInfo].ChaPower = 0,
[ChaInfo].ChaStrong = 0,
[ChaInfo].ChaStrength = 0,
[ChaInfo].Chaspirit = 0,
[ChaInfo].ChaDex = 0,
[ChaInfo].ChaIntel = 0
from inserted
where inserted.ChaLevel = 275
and [ChaInfo].ChaReborn < 100
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].UserNum = inserted.UserNum
and [ChaInfo].ChaOnline = 0

[mk1489]

i dunno why, im using this script in my shop pserver. i dont have any problem here.

[mk1489]

bump~ 1st post updated.
i learned how to make triggers, I don't copy and paste ^_^

[Jolin88]

even the comments on the script are same like the one from Tammy
but whatever, your script does have RB bug, even with chaonline = 0
try it if you don't believe me

[mk1489]

there's anyone have already tried this script?
if there is please kindly post your comment here if there is jump reborn or bugs,
i think the sql srver 2k5 sp3 will help the fix the jump reborn? coz i update my sql server 2k5 and i dont have any problem about this jump reborn, and im using 64bit of sql server, management, and dotnet.

After 24hours in market observing if this trigger will jump reborn. This script 100% working and no jump reborn. Try it yourself to believe it I'm not saying this if its not working for me.

How to install?

1. Open your SQL manager and go to RanGame1 > Tables > ChaInfo
2. Rightclick dbo.ChaInfo and click Design Table
Go to the bottom of the list that appears
there at the Column name put "ChaReborn"
datatype : Smallint
allow "NULL"

3. Rightclick dbo.ChaInfo and click Design Table
Go to the bottom of the list that appears
there at the Column name put "ChaStatMultiplyer"
datatype : Smallint
no "NULL"
and set Default Value or Binding to 1

4. Rightclick dbo.ChaInfo and click Design Table
Go to the bottom of the list that appears
there at the Column name put "ChaRebornQuery"
datatype : Smallint
no "NULL"
and set Default Value or Binding to 0

Req. LV = 300
Req. Gold = 30m
Stats per RB = 300
Max RB = 100

execute this script

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

Update [ChaInfo] set [ChaInfo].ChaRebornQuery = 1,
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 30000000
From Inserted
Where Inserted.ChaLevel = 300 
and [ChaInfo].ChaReborn < 100
and [ChaInfo].ChaName = inserted.ChaName 
and [ChaInfo].UserNum = inserted.UserNum
and [ChaInfo].ChaOnline = 0
and [ChaInfo].ChaMoney >= 30000000 

Update [ChaInfo] set [ChaInfo].ChaLevel = 1, 
[ChaInfo].ChaStatMultiplyer = [ChaInfo].ChaReborn + 1,
[ChaInfo].ChaReborn = [ChaInfo].ChaReborn + 1, 
[ChaInfo].ChaExp = 0,
[ChaInfo].ChaStRemain = 300*[ChaInfo].ChaStatMultiplyer,
[ChaInfo].ChaPower = 0,
[ChaInfo].ChaStrong = 0,
[ChaInfo].ChaStrength = 0,
[ChaInfo].ChaSpirit = 0, 
[ChaInfo].ChaDex = 0, 
[ChaInfo].ChaIntel = 0
From Inserted
Where Inserted.ChaLevel = 300
and [ChaInfo].ChaName = inserted.ChaName 
and [ChaInfo].UserNum = inserted.UserNum
and [ChaInfo].ChaOnline = 0
and [ChaInfo].ChaRebornQuery = 1

Update [ChaInfo] set [ChaInfo].ChaRebornQuery = 0
From Inserted
Where Inserted.ChaLevel = 1
and [ChaInfo].ChaName = inserted.ChaName 
and [ChaInfo].UserNum = inserted.UserNum
and [ChaInfo].ChaOnline = 0

End

[Tonz]

i got auto reborn scripton my ep4 server its working Fine no bugs no rb jumps.
reborn on lvl 250
300 points per rb
10 skill points per rb
100 max rb
30m rb cost

the prob is how to take off the delete quest..
so i make my server no quest..