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

[myopia666]

Hello to all sir's and ragezoner's, good evening! sir!! any script for autoreborn sir with remain skill and stats sir... with no bug sir??? i cant finalize here autoreborn information sir... if it is ok sir's?? please help me sir...

[KenWeiLL]

Based on Thread Starter's reborn script, I have this reborn:

USE [RanGame1]
GO
/****** Object:  Trigger [dbo].[Auto_Reborn]    Script Date: 05/04/2009 09:46:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER 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 < 32
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 = 1000*[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

Used for episode 3 database.
Supposed to have:
Max reborn: 32
Stats back to 0.
Level back to 1.
Stats remain per reborn: 1,000.

Problem:
At first reborn, it works. Characters stats are all back to 0. Pow, Dex, Int, etc.... Stats remain = 1000.
But on second reborn, stats remain is still 1000. Third reborn = 2,000. Fourth reborn = 3,000.

Supposed to be, 2nd reborn = 2,000. 3rd reborn = 3,000. 4th reborn = 4,000.

How do i fix this problem?

[mk1489]

@KenWeiLL

add this in your script

Update [ChaInfo] set [ChaInfo].ChaStatMultiplyer = [ChaInfo].ChaReborn + 1
From Inserted
Where Inserted.ChaName = inserted.ChaName 
and [ChaInfo].UserNum = inserted.UserNum

[KenWeiLL]

that code is already present in my script....

Update [ChaInfo] set [ChaInfo].ChaLevel = 1,
[ChaInfo].ChaStatMultiplyer = [ChaInfo].ChaReborn + 1,
[ChaInfo].ChaReborn = [ChaInfo].ChaReborn + 1,
[ChaInfo].ChaExp = 0,
[ChaInfo].ChaStRemain = 1000*[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

[Zero100]

okey now im having a weird situation after using the 1st page trigger ,the problem is
1=jump rb
2=cant make character always say cant use this name
3=cant dlete
my server is ep3 mixed ep4 server all okey until i try to set auto rb system
my server max lvl 220
wan make max reborn 25
can anybody make a simple trigger that can solve my problem or give link that teach how to make trigger.

[someD]

i have this error when i try to execute the file



can someone tell me what should i do

[jayrules2009]

sir where can i attach this trigger im using ep3 server sql2005 i can see the design table...

see my ss here hope you can help me..

[stephz09]

request ko po ito:FOR EP4 PO HA

Req. LV = 300
Req. Gold = 1M
Stats per RB = 200
Max RB = 50

[andrei07]

that's nice! :D

[silverkira06]

can i req for ep3 auto reborn script

i want max lvl 300
MAXRB=40

and how can i put a quest after reborn?