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

[Jolin88]

dude try stayed logged in overnight even if you're at reborn level, keep enough gold in your account and after the night relog and see you will have more reborns than you're supposed to

[mk1489]

@jolin

yes i already try that 24hours at the market and i log out and poof, i only have 1 reborn.

[RockStarModeL]

Msg 208, Level 16, State 4, Procedure Auto_Reborn, Line 1
Invalid object name 'dbo.ChaInfo'.
i follow all the instructions
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

and i execute the script.....how come i have this error when i execute..?

"Msg 208, Level 16, State 4, Procedure Auto_Reborn, Line 1
Invalid object name 'dbo.ChaInfo'."

[truclan]

@mk1489

this is Excellent thxn for sharing your very helpful knowledge ^^

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

no bug at all Tested

[alamo2007]

can i req auto reborn with reset all quest ?

[gmbo0m69]

OMG! Can Anyone Give me a Step By Step Procedure?

Its My only Problem in my Server~_~

Thanks in Advance!

[Cath22]

Request.
Req. LV = 300
Req. Gold = 30m
Stats per RB = 300
Max RB = 100
for ep4
also may i ask if the characters will have there current stat after reborn?>

[excyllez09]

hi sis..


CAN U TEACH ME HOW TO MAKE RANONLINE PRIVATE SERVER.....

STEP BY STEP SIS


JUST CHAT ME IN THIS MESSENGER:mgabonilas ^^

god bless

[Cr4sher]

hi there,i have use Sir Abry autoreborn trigger.everything is just perfect,my only problem is the reborn count is always reset to 1,for example i have reach 2 reborn then when i check at player status page,it shown as 2 reborn,but in 30 minute it will change to 1 reborn again,there is no problem with stats or else,only the reborn count is rollback

here is the trigger which i use for my server,wonder which is wrong,please lend me some help here,thanks in advange

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

Update [ChaInfo] set [ChaInfo].ChaReborn = 1,[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 = 250*[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 5000000 -- Optional : Reborn cost 5m
From Inserted
Where Inserted.ChaLevel = 260 -- Level to reborn
and [ChaInfo].ChaReborn < 100 -- Max Reborn number
and [ChaInfo].ChaTribe = 1
and [ChaInfo].ChaName=inserted.ChaName 
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 5000000 -- Optional : Require 5m gold for reborn
and [ChaInfo].ChaOnline=0

Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaTribe = 2,
[ChaInfo].ChaClass = 16,
[ChaInfo].ChaReborn=1, -- will go back to 1 reborn after Change to MixClass
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = 1, -- stat points you get when you change into mix class
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 100000000 -- Optional : Chang MixClass cost 100m
From inserted
Where Inserted.ChaLevel = 260 --  Level to Change into MixClass
and [ChaInfo].ChaClass = 1
and [ChaInfo].ChaReborn = 20 -- Required RB to Change MixClass
and [ChaInfo].ChaMoney >= 100000000 -- Optional : Require 100m gold for Change MixClass
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaTribe = 2,
[ChaInfo].ChaClass = 16,
[ChaInfo].ChaReborn=1, -- will go back to 1 reborn after Change to MixClass
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = 1, -- stat points you get when you change into mix class
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 100000000 -- Optional : Chang MixClass cost 100m
From inserted
Where Inserted.ChaLevel = 260 --  Level to Change into MixClass
and [ChaInfo].ChaClass = 2
and [ChaInfo].ChaReborn = 20 -- Required RB to Change MixClass
and [ChaInfo].ChaMoney >= 100000000 -- Optional : Require 100m gold for Change MixClass
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaTribe = 2,
[ChaInfo].ChaClass = ***
[ChaInfo].ChaReborn=1, -- will go back to 1 reborn after Change to MixClass
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = 1, -- stat points you get when you change into mix class
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 100000000 -- Optional : Chang MixClass cost 100m
From inserted
Where Inserted.ChaLevel = 260 --  Level to Change into MixClass
and [ChaInfo].ChaClass = 4
and [ChaInfo].ChaReborn = 20 -- Required RB to Change MixClass
and [ChaInfo].ChaMoney >= 100000000 -- Optional : Require 100m gold for Change MixClass
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaTribe = 2,
[ChaInfo].ChaClass = ***
[ChaInfo].ChaReborn=1, -- will go back to 1 reborn after Change to MixClass
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = 1, -- stat points you get when you change into mix class
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 100000000 -- Optional : Chang MixClass cost 100m
From inserted
Where Inserted.ChaLevel = 300 --  Level to Change into MixClass
and [ChaInfo].ChaClass = 8
and [ChaInfo].ChaReborn = 20 -- Required RB to Change MixClass
and [ChaInfo].ChaMoney >= 100000000 -- Optional : Require 100m gold for Change MixClass
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

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 = 250*[ChaInfo].ChaReborn+1, -- how many stat points you get per reborn (+1 is reward stat you get from Change Mixclass)
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 10000000 -- Optional : Reborn cost 10m
From Inserted
Where Inserted.ChaLevel = 260 -- Level to reborn
and [ChaInfo].ChaReborn < 100 -- Max Reborn number
and [ChaInfo].ChaTribe = 2
and [ChaInfo].ChaClass = 16
and [ChaInfo].ChaName=inserted.ChaName 
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 10000000 -- Optional : Require 10m gold for reborn
and [ChaInfo].ChaOnline=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 = 250*[ChaInfo].ChaReborn+1, -- how many stat points you get per reborn (+1 is reward stat you get from Change Mixclass)
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 10000000 -- Optional : Reborn cost 10m
From Inserted
Where Inserted.ChaLevel = 260 -- Level to reborn
and [ChaInfo].ChaReborn < 100 -- Max Reborn number
and [ChaInfo].ChaTribe = 2
and [ChaInfo].ChaClass = 32
and [ChaInfo].ChaName=inserted.ChaName 
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 10000000 -- Optional : Require 10m gold for reborn
and [ChaInfo].ChaOnline=0

End

[mk1489]

hi there,i have use Sir Abry autoreborn trigger.everything is just perfect,my only problem is the reborn count is always reset to 1,for example i have reach 2 reborn then when i check at player status page,it shown as 2 reborn,but in 30 minute it will change to 1 reborn again,there is no problem with stats or else,only the reborn count is rollback

here is the trigger which i use for my server,wonder which is wrong,please lend me some help here,thanks in advange

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

Update [ChaInfo] set [ChaInfo].ChaReborn = 1,[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 = 250*[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 5000000 -- Optional : Reborn cost 5m
From Inserted
Where Inserted.ChaLevel = 260 -- Level to reborn
and [ChaInfo].ChaReborn < 100 -- Max Reborn number
and [ChaInfo].ChaTribe = 1
and [ChaInfo].ChaName=inserted.ChaName 
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 5000000 -- Optional : Require 5m gold for reborn
and [ChaInfo].ChaOnline=0

Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaTribe = 2,
[ChaInfo].ChaClass = 16,
[ChaInfo].ChaReborn=1, -- will go back to 1 reborn after Change to MixClass
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = 1, -- stat points you get when you change into mix class
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 100000000 -- Optional : Chang MixClass cost 100m
From inserted
Where Inserted.ChaLevel = 260 --  Level to Change into MixClass
and [ChaInfo].ChaClass = 1
and [ChaInfo].ChaReborn = 20 -- Required RB to Change MixClass
and [ChaInfo].ChaMoney >= 100000000 -- Optional : Require 100m gold for Change MixClass
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaTribe = 2,
[ChaInfo].ChaClass = 16,
[ChaInfo].ChaReborn=1, -- will go back to 1 reborn after Change to MixClass
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = 1, -- stat points you get when you change into mix class
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 100000000 -- Optional : Chang MixClass cost 100m
From inserted
Where Inserted.ChaLevel = 260 --  Level to Change into MixClass
and [ChaInfo].ChaClass = 2
and [ChaInfo].ChaReborn = 20 -- Required RB to Change MixClass
and [ChaInfo].ChaMoney >= 100000000 -- Optional : Require 100m gold for Change MixClass
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaTribe = 2,
[ChaInfo].ChaClass = ***
[ChaInfo].ChaReborn=1, -- will go back to 1 reborn after Change to MixClass
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = 1, -- stat points you get when you change into mix class
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 100000000 -- Optional : Chang MixClass cost 100m
From inserted
Where Inserted.ChaLevel = 260 --  Level to Change into MixClass
and [ChaInfo].ChaClass = 4
and [ChaInfo].ChaReborn = 20 -- Required RB to Change MixClass
and [ChaInfo].ChaMoney >= 100000000 -- Optional : Require 100m gold for Change MixClass
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaTribe = 2,
[ChaInfo].ChaClass = ***
[ChaInfo].ChaReborn=1, -- will go back to 1 reborn after Change to MixClass
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = 1, -- stat points you get when you change into mix class
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 100000000 -- Optional : Chang MixClass cost 100m
From inserted
Where Inserted.ChaLevel = 300 --  Level to Change into MixClass
and [ChaInfo].ChaClass = 8
and [ChaInfo].ChaReborn = 20 -- Required RB to Change MixClass
and [ChaInfo].ChaMoney >= 100000000 -- Optional : Require 100m gold for Change MixClass
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

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 = 250*[ChaInfo].ChaReborn+1, -- how many stat points you get per reborn (+1 is reward stat you get from Change Mixclass)
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 10000000 -- Optional : Reborn cost 10m
From Inserted
Where Inserted.ChaLevel = 260 -- Level to reborn
and [ChaInfo].ChaReborn < 100 -- Max Reborn number
and [ChaInfo].ChaTribe = 2
and [ChaInfo].ChaClass = 16
and [ChaInfo].ChaName=inserted.ChaName 
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 10000000 -- Optional : Require 10m gold for reborn
and [ChaInfo].ChaOnline=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 = 250*[ChaInfo].ChaReborn+1, -- how many stat points you get per reborn (+1 is reward stat you get from Change Mixclass)
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 10000000 -- Optional : Reborn cost 10m
From Inserted
Where Inserted.ChaLevel = 260 -- Level to reborn
and [ChaInfo].ChaReborn < 100 -- Max Reborn number
and [ChaInfo].ChaTribe = 2
and [ChaInfo].ChaClass = 32
and [ChaInfo].ChaName=inserted.ChaName 
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 10000000 -- Optional : Require 10m gold for reborn
and [ChaInfo].ChaOnline=0

End

i have experience that problem too.,

remove this..

Update [ChaInfo] set [ChaInfo].ChaReborn = 1,[ChaInfo].ChaTribe = 1
from Inserted
Where Inserted.ChaTribe = 0

[alamo2007]

bro, can i req autoreborn with reset quest too for my ep3 server? plz urgent ....


thx b4

[mk1489]

Add this in your autoreborn script.

[ChaInfo].ChaQuest = Null,

[tong2404]

I have error when execute script but I edit some script .

How to fix this ?

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

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

Update [ChaInfo] set [ChaInfo].ChaLevel = 330,
[ChaInfo].ChaStatMultiplyer = [ChaInfo].ChaReborn + 1,
[ChaInfo].ChaReborn = [ChaInfo].ChaReborn + 1,
[ChaInfo].ChaExp = 0,
[ChaInfo].ChaStRemain = 0,

From Inserted
Where Inserted.ChaLevel = 355
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 = 330
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].UserNum = inserted.UserNum
and [ChaInfo].ChaOnline = 0

End

I use this script

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

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

Update [ChaInfo] set [ChaInfo].ChaLevel = 330,
[ChaInfo].ChaStatMultiplyer = [ChaInfo].ChaReborn + 1,
[ChaInfo].ChaReborn = [ChaInfo].ChaReborn + 1,
[ChaInfo].ChaExp = 0,
[ChaInfo].ChaStRemain = 0,

From Inserted
Where Inserted.ChaLevel = 355
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 = 330
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].UserNum = inserted.UserNum
and [ChaInfo].ChaOnline = 0

End

[Cr4sher]

i have make some test regarding skip reborn using this script and....sad.....its still can jump jump jump

u will not jump reborn if u are only afk with enough gold,but if u ..... and ....,still can jump ...headache

[kimardz]

HAYZZZ I HAVE PROBLEM REGARDING AUTOREBORN HERE EVERYTIME MY GM CHARACTER REBORN WHICH I EDITED WITH STATS IN THE GMC, AFTER THE REBORN THE STATS ARE GONE

EXAMPLE: I HAVE 40K INT 5K DEX 3K POW 14.5KVIT AFTER THE REBORN back to its normal state 12int 20dex 8 pow 42vit


Im using this code from Sir Abry:

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

Update [ChaInfo] set [ChaInfo].ChaReborn = 1,[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 = 300*[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 50000000 -- Optional : Reborn cost 50m
From Inserted
Where Inserted.ChaLevel = 300 -- Level to reborn
and [ChaInfo].ChaReborn < 100 -- Max Reborn number
and [ChaInfo].ChaTribe = 1
and [ChaInfo].ChaName=inserted.ChaName 
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 50000000 -- Optional : Require 50m gold for reborn
and [ChaInfo].ChaOnline=0

Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaTribe = 2,
[ChaInfo].ChaClass = 16,
[ChaInfo].ChaReborn=1, -- will go back to 1 reborn after Change to MixClass
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = 5000, -- stat points you get when you change into mix class
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 1000000000 -- Optional : Chang MixClass cost 1b
From inserted
Where Inserted.ChaLevel = 300 --  Level to Change into MixClass
and [ChaInfo].ChaClass = 1
and [ChaInfo].ChaReborn = 51 -- Required RB to Change MixClass
and [ChaInfo].ChaMoney >= 1000000000 -- Optional : Require 1b gold for Change MixClass
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaTribe = 2,
[ChaInfo].ChaClass = 16,
[ChaInfo].ChaReborn=1, -- will go back to 1 reborn after Change to MixClass
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = 5000, -- stat points you get when you change into mix class
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 1000000000 -- Optional : Chang MixClass cost 1b
From inserted
Where Inserted.ChaLevel = 300 --  Level to Change into MixClass
and [ChaInfo].ChaClass = 2
and [ChaInfo].ChaReborn = 51 -- Required RB to Change MixClass
and [ChaInfo].ChaMoney >= 1000000000 -- Optional : Require 1b gold for Change MixClass
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaTribe = 2,
[ChaInfo].ChaClass = ***
[ChaInfo].ChaReborn=1, -- will go back to 1 reborn after Change to MixClass
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = 5000, -- stat points you get when you change into mix class
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 1000000000 -- Optional : Chang MixClass cost 1b
From inserted
Where Inserted.ChaLevel = 300 --  Level to Change into MixClass
and [ChaInfo].ChaClass = 4
and [ChaInfo].ChaReborn = 51 -- Required RB to Change MixClass
and [ChaInfo].ChaMoney >= 1000000000 -- Optional : Require 1b gold for Change MixClass
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaTribe = 2,
[ChaInfo].ChaClass = ***
[ChaInfo].ChaReborn=1, -- will go back to 1 reborn after Change to MixClass
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = 5000, -- stat points you get when you change into mix class
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 1000000000 -- Optional : Chang MixClass cost 1b
From inserted
Where Inserted.ChaLevel = 300 --  Level to Change into MixClass
and [ChaInfo].ChaClass = 8
and [ChaInfo].ChaReborn = 51 -- Required RB to Change MixClass
and [ChaInfo].ChaMoney >= 1000000000 -- Optional : Require 1b gold for Change MixClass
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

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 = 300*[ChaInfo].ChaReborn+5000, -- how many stat points you get per reborn (+5000 is reward stat you get from Change Mixclass)
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 100000000 -- Optional : Reborn cost 100m
From Inserted
Where Inserted.ChaLevel = 300 -- Level to reborn
and [ChaInfo].ChaReborn < 100 -- Max Reborn number
and [ChaInfo].ChaTribe = 2
and [ChaInfo].ChaClass = 16
and [ChaInfo].ChaName=inserted.ChaName 
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 100000000 -- Optional : Require 100m gold for reborn
and [ChaInfo].ChaOnline=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 = 300*[ChaInfo].ChaReborn+5000, -- how many stat points you get per reborn (+5000 is reward stat you get from Change Mixclass)
[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 Spirit you added to 0
[ChaInfo].ChaDex = 0, -- Set the number of Dex you added to 0
[ChaInfo].ChaIntel = 0, -- Set the number of Int you added to 0
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 100000000 -- Optional : Reborn cost 100m
From Inserted
Where Inserted.ChaLevel = 300 -- Level to reborn
and [ChaInfo].ChaReborn < 100 -- Max Reborn number
and [ChaInfo].ChaTribe = 2
and [ChaInfo].ChaClass = 32
and [ChaInfo].ChaName=inserted.ChaName 
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 100000000 -- Optional : Require 100m gold for reborn
and [ChaInfo].ChaOnline=0

End