[Release]Reborn (Rebirth) system NO BUGS

[Bastiras Online]

We all remember the nice Silkroad WS server, which worked with the new "Reborn" system, but alas, for some reason, after closing it, practically did not see such servers, and I also saw that many people are wondering how to do something like that. Since I do not see the answers to these questions and since all the scripts that are in the public domain with errors, I decided to publish my tested version to you, there are no errors in it and it works perfectly on 110 cap, if you need you can easy change it to other cap, it's not hard!

Database

_RefObjCommon

PHP Code:

1    45561    ITEM_REBORN_SCROLL    ???    xxx    SN_ITEM_REBORN_SCROLL    SN_ITEM_REBORN_SCROLL_TT_DESC    0    0    3    3    3    1    180000    3    0    1    1    1    255    3    1    0    0    1    0    5000    0    0    0    75    1500    1    110    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_scroll.bsr    item\etc\scroll_return_01.ddj    xxx    xxx    61661 


_RefObjItem

PHP Code:

61661    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    2000    ????    1    ??????                                                                                                                               -1    RESURRECT    1000    COOLTIME:0x00000000    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0 


_AddLogItem

PHP Code:

            IF (  @Operation =   '41') AND @ItemRefID  = '45561' -- Reborn scroll
            BEGIN
            UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET CurLevel = 1, ExpOffset = 0, RemainStatPoint = 5 WHERE CharID=@CharID
            END 


If you need to change the number of stats received for Reborn change 5 in RemainStatPoint = 5 to any other number!


Client
Itemdata

PHP Code:

1    45561    ITEM_REBORN_SCROLL    ???    xxx    SN_ITEM_REBORN_SCROLL    SN_ITEM_REBORN_SCROLL_TT_DESC    0    0    3    3    3    1    180000    3    0    1    1    1    255    3    1    0    0    1    0    5000    0    0    0    75    1500    1    110    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_scroll.bsr    item\etc\scroll_return_01.ddj    xxx    xxx    5000    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    2000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 


textdata_object

PHP Code:

1    SN_ITEM_REBORN_SCROLL                                Reborn Scroll
1    SN_ITEM_REBORN_SCROLL_TT_DESC                                After using this scroll, your level will drop to 1 level, but you will receive 5 stat points. 


How is this Release different from others? Many people were clever and wrote a script without testing it, yes, it worked, but there were errors, let's say some people reduced CurLevel and MaxLevel to 1 level, but if you reduce MaxLevel to 1 level, after you start killing monsters and get a new level you get +3 stats and this is bad, since the scroll will not work correctly, also this scroll can be used only at 110 level... Use it and you will see the difference yourself.

Good luck, we are waiting for new servers with the Rebirth system

[JellyBitz]

"RemainStatPoint = 5 + RemainStatPoint" Probably...

[Laag#82]

Originally Posted by JellyBitz

"RemainStatPoint = 5 + RemainStatPoint" Probably...

Hello,

two

RemainStatPoint += 5

[ASKSRO_1]

错误很多 没有限制~！！

[taivipsalip]

there was an error when i finished rebirth at lvl 1 and exited the game all my points were lost

[Judgelemental]

Originally Posted by Bastiras Online

.

I've had this script for quite some time now, everything is great and all, however sometimes my characters crash and this error appears in the GameServer, any idea why?



I couldn't find said procedure, not even online.

[Cyrillus Rigid]

Originally Posted by Judgelemental

I've had this script for quite some time now, everything is great and all, however sometimes my characters crash and this error appears in the GameServer, any idea why?



I couldn't find said procedure, not even online.

this problem not from Re*th system
check _AddLogChar,_AddLogItem

maybe there missing Addons_GS DB
ur files not complate

[taivipsalip]

anyone have a way to add the rebirth scroll to the server without error

[Judgelemental]

Originally Posted by Cyrillus Rigid

this problem not from Re*th system
check _AddLogChar,_AddLogItem

maybe there missing Addons_GS DB
ur files not complate

Yes, because I added a table that checks if you have reborn already and if you have, you cannot do it again.

Anyway, no big deal, it's disabled, I was just wondering what went wrong with it and why I got that error.

Here's the procedure.

 Spoiler

PHP Code:

--Rebirth System
set @Charname = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
declare @tworebirth int

set @tworebirth = (select  COUNT(*) FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID)
declare @level90 tinyint = (select CurLevel from SRO_VT_SHARD.dbo._Char Where CharID =  @CharID)

 IF (@Operation = 41) 
BEGIN
    IF (@ItemRefID = 41840)
    begin
            
            If @tworebirth = '1'
begin

If((SELECT COUNT(*) FROM SRO_VT_SHARD.dbo._CharRebirth WHERE CharName16 = @Charname) = '0') 
begin
if @level90 = 90
begin
insert into SRO_VT_SHARD.dbo._CharRebirth(CharName16, Reward) values (@Charname, '0')
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET Strength = 20, Intellect = 20, MaxLevel = 1, CurLevel = 1, ExpOffset = 0, SExpOffset = 0, RemainStatPoint = 0, RemainSkillPoint = RemainSkillPoint + '500000' WHERE CharID=@CharID
 if(@Operation = '41' )
              BEGIN
              IF (  @ItemRefID =   '41840')
              BEGIN
              
       
        
        Declare @cname16 varchar(256);
        SET @cname16 = (Select charname16 from SRO_VT_SHARD.DBO._Char WITH(NOLOCK) where CharID = @CharID)
        
            DELETE SRO_VT_SHARD.DBO._CharSkill FROM SRO_VT_SHARD.DBO._RefSkill, SRO_VT_SHARD.DBO._CharSkill WITH(NOLOCK) WHERE SRO_VT_SHARD.DBO._RefSkill.ID=SRO_VT_SHARD.DBO._CharSkill.SkillID AND SRO_VT_SHARD.DBO._CharSkill.CharID=@CharID AND SRO_VT_SHARD.DBO._RefSkill.ReqCommon_MasteryLevel1 <= '110' AND SRO_VT_SHARD.DBO._RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625)
            UPDATE SRO_VT_SHARD.DBO._CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '110'  
             IF (  @ItemRefID =   '41840')
              BEGIN
              begin
                   exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,'ITEM_MALL_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,0
                exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,'ITEM_ETC_150EXP_BASIC',20,0
                exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,'ITEM_COS_C_PEGASUS_SCROLL',50,0 
                exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,'ITEM_MALL_OPEN_MARKET_TICKET',1,0 
                exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,'ITEM_MALL_CHAR_SKIN_CHANGE_SCROLL',1,0 
                end
            END
             END
             end
             end








end
end
end
end