[Share] Reborn Script With Ammend Stats (Speacially For Ep6)

[jeiemXbytes08]

i've keep this script for long time and i use this in my previous server so i share it that someone talk me to share it .

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Auto_Reborn] ON [dbo].[ChaInfo]
after update
as
BEGIN


Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaReborn=[ChaInfo].ChaReborn + 1,
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 15000000,
[ChaInfo].ChaStRemain = (1*[ChaInfo].ChaReborn)

From Inserted
Where Inserted.ChaLevel = 300 -- Level to reborn
and [ChaInfo].ChaReborn < 350 -- Max Reborn number
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 15000000


DECLARE @MaxPowStats bigint, @MaxIntStats bigint,
@MaxDexStats bigint, @MaxVitStats bigint, @MaxStmStats bigint,
@StatPenalty bigint

SET @MaxPowStats = 30000
SET @MaxDexStats = 30000
SET @MaxIntStats = 30000
SET @MaxVitStats = 30000
SET @MaxStmStats = 30000
SET @StatPenalty = 7500



UPDATE [rangame1].[dbo].[ChaInfo]
SET
[ChaInfo].ChaStRemain = [ChaInfo].ChaStRemain +
(CASE WHEN inserted.[ChaPower] > @MaxPowStats THEN ( CASE WHEN @StatPenalty = 0 THEN (inserted.[ChaPower] - @MaxPowStats) ELSE 0 END) ELSE 0 END) +
(CASE WHEN inserted.ChaDex > @MaxDexStats THEN ( CASE WHEN @StatPenalty = 0 THEN (inserted.ChaDex - @MaxDexStats) ELSE 0 END) ELSE 0 END) +
(CASE WHEN inserted.ChaStrong > @MaxVitStats THEN ( CASE WHEN @StatPenalty = 0 THEN (inserted.ChaStrong - @MaxVitStats) ELSE 0 END) ELSE 0 END) +
(CASE WHEN inserted.ChaStrength > @MaxStmStats THEN ( CASE WHEN @StatPenalty = 0 THEN (inserted.ChaStrength - @MaxStmStats) ELSE 0 END) ELSE 0 END) +
(CASE WHEN inserted.ChaSpirit > @MaxIntStats THEN ( CASE WHEN @StatPenalty = 0 THEN (inserted.ChaSpirit - @MaxIntStats) ELSE 0 END) ELSE 0 END)
,[ChaInfo].ChaPower = CASE WHEN inserted.[ChaPower] > @MaxPowStats THEN (CASE WHEN @StatPenalty = 0 THEN @MaxPowStats ELSE (@MaxPowStats - @StatPenalty) END) ELSE inserted.[ChaPower] END
,[ChaInfo].ChaDex = CASE WHEN inserted.ChaDex > @MaxDexStats THEN (CASE WHEN @StatPenalty = 0 THEN @MaxDexStats ELSE (@MaxDexStats - @StatPenalty) END) ELSE inserted.ChaDex END
,[ChaInfo].ChaStrong = CASE WHEN inserted.ChaStrong > @MaxVitStats THEN (CASE WHEN @StatPenalty = 0 THEN @MaxVitStats ELSE (@MaxVitStats - @StatPenalty) END) ELSE inserted.ChaStrong END
,[ChaInfo].ChaStrength = CASE WHEN inserted.ChaStrength > @MaxStmStats THEN (CASE WHEN @StatPenalty = 0 THEN @MaxStmStats ELSE (@MaxStmStats - @StatPenalty) END) ELSE inserted.ChaStrength END
,[ChaInfo].ChaSpirit = CASE WHEN inserted.ChaSpirit > @MaxIntStats THEN (CASE WHEN @StatPenalty = 0 THEN @MaxIntStats ELSE (@MaxIntStats - @StatPenalty) END) ELSE inserted.ChaSpirit END
FROM inserted
WHERE inserted.[ChaName] = [ChaInfo].[ChaName]
and [ChaInfo].[ChaSpecial] = 0

End

How To Use :
Just Go To "RanGame1 > Tables > dbo.ChaInfo > Trigger > Right Click The Trigger > New Trigger" Then Paste and Execute it...

About The Reborn Script :
Level 300 Required To Reborn
15000000 Required Gold To Reborn
Max Reborn Is 350

About The Amend Stat Script :
Max Stats For Pow, Dex, Int, Vit, Stm : 30000
Stat Penalty is 7500

The Purpose of "Stat Penalty" when your put stats over your maxstats will be decreased by your Stats penalty ...

Note : You Can Change The Values By Your Own

Credit To : Sir Smarkies for Reborn Script(I know his is no longer here.)
And To Sir PrinceOfPersia for amend script..

Tools : Windows Calculator just kidding..

 

[Clocker]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

Nice re-share

---------- Post added at 12:04 PM ---------- Previous post was at 11:57 AM ----------

Msg 208, Level 16, State 6, Procedure Auto_Reborn, Line 33
Invalid object name 'dbo.Auto_Reborn'.

 

[jeiemXbytes08]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

@Clocker - just add ChaReborn in dbo.ChaInfo ....

dbo.ChaInfo > Right Click > Modify .. go to the bottom part add this

Column Name : ChaReborn
Data Type : smallint
Allow Nulls : no (uncheck)

 

[Clocker]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

I've done that. I still encounter this problem:

Msg 208, Level 16, State 6, Procedure Auto_Reborn, Line 33
Invalid object name 'dbo.Auto_Reborn'.

 

[jeiemXbytes08]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

@Clocker

try to Change The "ALTER" to CREATE in the top of script

 

[Clocker]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

Command(s) completed successfully. thank u

 

[jeiemXbytes08]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

@Clocker - good .. ok thanks

 

[-Jumong-]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

Theres no such thing as re-share. If this kind of file, script or guide been shared before use the old one. We dont allow re-shares of file, if its dead link for file to download, report it on dead link

 

[jeiemXbytes08]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

@Sir Jumong - ok sir .. im sorry..

 

[liusjul78]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

@jeiemXbytes08 .,, whats wrong with this sir?

Msg 207, Level 16, State 1, Procedure Auto_Reborn, Line 47
Invalid column name 'ChaSpecial'.

 

[jeiemXbytes08]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

@liusjul > do you have ChaSpecial in your dbo.CharInfo ?

 

[ryan313]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

i have this problem

Msg 208, Level 16, State 6, Procedure Auto_Reborn, Line 33
Invalid object name 'dbo.Auto_Reborn'.

and u said to Clocker that

try to Change The "ALTER" to CREATE in the top of script

DONT GET IT

 

[shins012]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

i have this problem

Msg 208, Level 16, State 6, Procedure Auto_Reborn, Line 33
Invalid object name 'dbo.Auto_Reborn'.

and u said to Clocker that

try to Change The "ALTER" to CREATE in the top of script

DONT GET IT

you see this script

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Auto_Reborn] ON [dbo].[ChaInfo]
after update
as
BEGIN


Update [ChaInfo] set [ChaInfo].ChaLevel=1,
[ChaInfo].ChaReborn=[ChaInfo].ChaReborn + 1,
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 12000000,
[ChaInfo].ChaStRemain = (1*[ChaInfo].ChaReborn)

From Inserted
Where Inserted.ChaLevel = 300 -- Level to reborn
and [ChaInfo].ChaReborn < 999 -- Max Reborn number
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaMoney >= 12000000


DECLARE @MaxPowStats bigint, @MaxIntStats bigint,
@MaxDexStats bigint, @MaxVitStats bigint, @MaxStmStats bigint,
@StatPenalty bigint

SET @MaxPowStats = 12000
SET @MaxDexStats = 12000
SET @MaxIntStats = 12000
SET @MaxVitStats = 7000
SET @MaxStmStats = 7000
SET @StatPenalty = 1500



UPDATE [rangame1].[dbo].[ChaInfo]
SET
[ChaInfo].ChaStRemain = [ChaInfo].ChaStRemain +
(CASE WHEN inserted.[ChaPower] > @MaxPowStats THEN ( CASE WHEN @StatPenalty = 0 THEN (inserted.[ChaPower] - @MaxPowStats) ELSE 0 END) ELSE 0 END) +
(CASE WHEN inserted.ChaDex > @MaxDexStats THEN ( CASE WHEN @StatPenalty = 0 THEN (inserted.ChaDex - @MaxDexStats) ELSE 0 END) ELSE 0 END) +
(CASE WHEN inserted.ChaStrong > @MaxVitStats THEN ( CASE WHEN @StatPenalty = 0 THEN (inserted.ChaStrong - @MaxVitStats) ELSE 0 END) ELSE 0 END) +
(CASE WHEN inserted.ChaStrength > @MaxStmStats THEN ( CASE WHEN @StatPenalty = 0 THEN (inserted.ChaStrength - @MaxStmStats) ELSE 0 END) ELSE 0 END) +
(CASE WHEN inserted.ChaSpirit > @MaxIntStats THEN ( CASE WHEN @StatPenalty = 0 THEN (inserted.ChaSpirit - @MaxIntStats) ELSE 0 END) ELSE 0 END)
,[ChaInfo].ChaPower = CASE WHEN inserted.[ChaPower] > @MaxPowStats THEN (CASE WHEN @StatPenalty = 0 THEN @MaxPowStats ELSE (@MaxPowStats - @StatPenalty) END) ELSE inserted.[ChaPower] END
,[ChaInfo].ChaDex = CASE WHEN inserted.ChaDex > @MaxDexStats THEN (CASE WHEN @StatPenalty = 0 THEN @MaxDexStats ELSE (@MaxDexStats - @StatPenalty) END) ELSE inserted.ChaDex END
,[ChaInfo].ChaStrong = CASE WHEN inserted.ChaStrong > @MaxVitStats THEN (CASE WHEN @StatPenalty = 0 THEN @MaxVitStats ELSE (@MaxVitStats - @StatPenalty) END) ELSE inserted.ChaStrong END
,[ChaInfo].ChaStrength = CASE WHEN inserted.ChaStrength > @MaxStmStats THEN (CASE WHEN @StatPenalty = 0 THEN @MaxStmStats ELSE (@MaxStmStats - @StatPenalty) END) ELSE inserted.ChaStrength END
,[ChaInfo].ChaSpirit = CASE WHEN inserted.ChaSpirit > @MaxIntStats THEN (CASE WHEN @StatPenalty = 0 THEN @MaxIntStats ELSE (@MaxIntStats - @StatPenalty) END) ELSE inserted.ChaSpirit END
FROM inserted
WHERE inserted.[ChaName] = [ChaInfo].[ChaName]
and [ChaInfo].[ChaSpecial] = 0

End


change the blue sign to CREATE .. get it ?

 

[liusjul78]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

@jeiemXbytes08, do you have a php reborn for this?

 

[jeiemXbytes08]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

@liusjul78 > no .. i don't have php reborn .. it's just a script when you reach the max level just LOGOUT and Re-LOGIN the char.. and char will reborned or simply back to level 1..

 

[IamDJDRB]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

Sir how to fix this

Msg 207, Level 16, State 1, Procedure Auto_Reborn, Line 48
Invalid column name 'ChaSpecial'.

 

[jeiemXbytes08]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

just add ChaSpecial on your dbo.ChaInfo

 

[ImMiremo]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

it has bug right? in market when afk for 1hours you will gain 1rb or level. so its better to use manual rb. ^^, but by the way thanks dude for this share ^^

 

[loyalz09]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

Msg 207, Level 16, State 1, Procedure Auto_Reborn, Line 14
Invalid column name 'ChaReborn'.


how about this??

 

[jeiemXbytes08]

Re: [Re-Share] Reborn Script With Ammend Stats (Speacially For Ep6)

@loyalz -- go to RanGame1 > Tables > dbo.ChaInfo > Rigth Click > Modify ,, then go to the bottom and type to Column Name "ChaReborn" , Data Type "int" Not Allow Nulls...