[Partial Release] Rebirth-System - scroll based

[Anonymous-6723]

First of all it's a newbie code and it needs even more things to be added. I am not an SQL coder but this will work. It's based on puritysro's rebirth system which allows you to make X free resets then you have to pay for it. If you wanna add the same where it says _TableName you will have to add one more value and create one more scroll which will be available in item mall to change value form 1/0 and depending on this to allow/disallow +X resets. I guess you get my point. Won't give you script to create table as I said it's partial release only. (Use any other scroll that works for char name changing / pk clear / etc..)

 Spoiler

if(@JobID=xxxx)
DECLARE @MAXLEVEL INT
SET @MAXLEVEL = 100
BEGIN
declare @check int
declare @charcheck int
IF(NOT EXSITS(SELECT * FROM _TableName where CharID = @CharID))
BEGIN
insert into _TableName (CharID, CountRespawn, LastSTR, LastINT) VALUES (@CharID, 0, 20, 20)
END
select @check = CountRespawn from _TableName where CharID = @CharID
select @charcheck = count(*) from SRO_VT_SHARD.dbo._Char where CharID = @CharID and CurLevel = @MAXLEVEL
IF @check > 5
BEGIN
RETURN
END
IF @charcheck = 1
BEGIN
declare @str int
declare @int int
declare @plusvalue int
/* Options Menu */
set @plusvalue = 5 -- +5 str/int default
/* Options Menu */
update _TableName set LastSTR = LastSTR + @plusvalue, LastINT = LastINT + @plusvalue, countrespawn = countrespawn + 1 where CharID = @CharID
select @str = LastSTR from _TableName where CharID = @CharID
select @int = LastINT from _TableName where CharID = @CharID
update SRO_VT_SHARD.dbo._Char set CurLevel = 1, MaxLevel = 1, Strength = @str, Intellect = @int where CharID = @CharID
END

[Jimmy*]

seems useful thanks for sharing it

[鳳凰城]

Quiet good code.. simple and readable..

For those who'll say what jobid referrers to, its in addtimedjob proc. in shard database. and this mode is for that item -> query ****.

[Alexiuns]

looks bad

bad i will thank you because you try to help people

[Anonymous-6723]

Originally Posted by Alexiuns

looks bad

bad i will thank you because you try to help people

I explained this I think ^^. I made it while talking to phoenix and we just had a simple idea so this was only for a test. It needs way more coding to make it better and to work without any problems. But since there is nothing released about this system people could follow the main idea on the script and build their own ones

[Crue*]

thanks for sharing