rebirth system

[che929]

rebirth system

    -------------------------------------------------------- rebirth by che....
    declare @Strength int
            declare @Intellect int
            declare @MaxLevel int
            declare @ReMainStatPoint int
            declare @tworebirth int
            declare @Charname varchar(120)
            set @Charname = (select CharName16 from sro_vt_Shard_che.dbo._Char where CharID @CharID)
            select @MaxLevel = MaxLevel from sro_vt_Shard_che.DBO._Char where CharID = @CharID
            set @tworebirth = (select  COUNT(*) FROM sro_vt_Shard_che.dbo._Char WHERE CharID = @CharID)
             declare @TotalSP int
            declare @TotalSPMastery int
            SELECT @TotalSP = SUM(sro_vt_Shard_che.dbo._RefSkill.ReqLearn_SP) FROM sro_vt_Shard_che.DBO._RefSkill, sro_vt_Shard_che.DBO._CharSkill WHERE sro_vt_Shard_che.dbo._RefSkill.ID=sro_vt_Shard_che.dbo._CharSkill.SkillID AND sro_vt_Shard_che.dbo._CharSkill.CharID @CharID AND sro_vt_Shard_che.dbo._RefSkill.ReqCommon_MasteryLevel1 <= '120'
            SELECT @TotalSPMastery = SUM(sro_vt_Shard_che.dbo._RefLevel.Exp_M) FROM sro_vt_Shard_che.DBO._CharSkillMastery, sro_vt_Shard_che.DBO._RefLevel WHERE sro_vt_Shard_che.dbo._RefLevel.Lvl=sro_vt_Shard_che.dbo._CharSkillMastery.Level AND sro_vt_Shard_che.dbo._CharSkillMastery.CharID @CharID AND sro_vt_Shard_che.dbo._CharSkillMastery.Level <= '120'
    IF (@Operation = 41) -- scroll is used
BEGIN
    IF (@ItemRefID = 103062) -- rebirth scroll
    begin
            
            If @tworebirth = '1')
begin


If((SELECT COUNT(*) FROM sro_vt_Shard_che.dbo._CharRebirth WHERE CharName16 @Charname) = '0')
begin
insert into sro_vt_Shard_che.dbo._CharRebirth(CharName16, Reward) values @Charname, '0')
end
else 
begin
If((SELECT COUNT(*) FROM sro_vt_Shard_che.dbo._CharRebirth WHERE CharName16 @Charname And Reward = '0' And [No] <= 50000) = '1')
begin
update sro_vt_Shard_che.dbo._CharRebirth set Reward = 1 where CharName16 = @Charname
            set @ReMainStatPoint =  @MaxLevel*3+25)-3
            set @MaxLevel = @MaxLevel+19
            Update sro_vt_Shard_che.DBO._Char SET MaxLevel=120, CurLevel=120 WHERE CharID @CharID
            UPDATE sro_vt_Shard_che.DBO._CHAR SET Strength @MaxLevel, Intellect @MaxLevel, RemainStatPoint @ReMainStatPoint WHERE CharID @CharID
            UPDATE sro_vt_Shard_che.DBO._Char SET RemainSkillPoint=RemainSkillPoint @TotalSP @TotalSPMastery+200000 WHERE CharID @CharID
            DELETE sro_vt_Shard_che.DBO._CharSkill FROM sro_vt_Shard_che.DBO._RefSkill, sro_vt_Shard_che.DBO._CharSkill WHERE sro_vt_Shard_che.dbo._RefSkill.ID=sro_vt_Shard_che.dbo._CharSkill.SkillID AND sro_vt_Shard_che.dbo._CharSkill.CharID @CharID AND sro_vt_Shard_che.dbo._RefSkill.ReqCommon_MasteryLevel1 <= '125' AND sro_vt_Shard_che.dbo._RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625)
            UPDATE sro_vt_Shard_che.DBO._CharSkillMastery SET Level='0' WHERE CharID @CharID AND Level <= '125'
        end
        end
        end
        end
        end

Query:

CREATE TABLE [dbo].[_CharRebirth](
    [No] [int] IDENTITY(1,1) NOT NULL,
    [CharName16] [varchar](max) NULL,
    [Reward] [int] NULL,
 CONSTRAINT [PK_rebirthRewards] PRIMARY KEY CLUSTERED 
(
    [No] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


GO
SET ANSI_PADDING OFF
GO

Scroll:
http://files.fm/g/dhgaqek#aa/rebirth.txt

[MentaL]

[Free2DoM]

Thx Bro

[blackway33]

Old but thank you :)

[tvquan90]

please help me, i dont add it in my server

[isozy]

Why does in every silkroad thread theres a motherfucking arab saying "old but thx", like, shut the fuck up.

[bares1993]

Che for President (Y)

[tvquan90]

please help me che :(

[che929]

Why does in every silkroad thread theres a motherfucking arab saying "old but thx", like, shut the fuck up.

[tvquan90]

che, please help me to setup rebirth system

- - - Updated - - -

where is add

-------------------------------------------------------- rebirth by che....
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @ReMainStatPoint int
declare @tworebirth int
declare @Charname varchar(120)
set @Charname = (select CharName16 from sro_vt_Shard_che.dbo._Char where CharID @CharID)
select @MaxLevel = MaxLevel from sro_vt_Shard_che.DBO._Char where CharID = @CharID
set @tworebirth = (select COUNT(*) FROM sro_vt_Shard_che.dbo._Char WHERE CharID = @CharID)
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM(sro_vt_Shard_che.dbo._RefSkill.ReqLearn_SP) FROM sro_vt_Shard_che.DBO._RefSkill, sro_vt_Shard_che.DBO._CharSkill WHERE sro_vt_Shard_che.dbo._RefSkill.ID=sro_vt_Shard_che.dbo._CharSkill.SkillID AND sro_vt_Shard_che.dbo._CharSkill.CharID @CharID AND sro_vt_Shard_che.dbo._RefSkill.ReqCommon_MasteryLevel1 <= '120'
SELECT @TotalSPMastery = SUM(sro_vt_Shard_che.dbo._RefLevel.Exp_M) FROM sro_vt_Shard_che.DBO._CharSkillMastery, sro_vt_Shard_che.DBO._RefLevel WHERE sro_vt_Shard_che.dbo._RefLevel.Lvl=sro_vt_Shard_che.dbo._CharSkillMastery.Level AND sro_vt_Shard_che.dbo._CharSkillMastery.CharID @CharID AND sro_vt_Shard_che.dbo._CharSkillMastery.Level <= '120'
IF (@Operation = 41) -- scroll is used
BEGIN
IF (@ItemRefID = 103062) -- rebirth scroll
begin

If @tworebirth = '1')
begin


If((SELECT COUNT(*) FROM sro_vt_Shard_che.dbo._CharRebirth WHERE CharName16 @Charname) = '0')
begin
insert into sro_vt_Shard_che.dbo._CharRebirth(CharName16, Reward) values @Charname, '0')
end
else
begin
If((SELECT COUNT(*) FROM sro_vt_Shard_che.dbo._CharRebirth WHERE CharName16 @Charname And Reward = '0' And [No] <= 50000) = '1')
begin
update sro_vt_Shard_che.dbo._CharRebirth set Reward = 1 where CharName16 = @Charname
set @ReMainStatPoint = @MaxLevel*3+25)-3
set @MaxLevel = @MaxLevel+19
Update sro_vt_Shard_che.DBO._Char SET MaxLevel=120, CurLevel=120 WHERE CharID @CharID
UPDATE sro_vt_Shard_che.DBO._CHAR SET Strength @MaxLevel, Intellect @MaxLevel, RemainStatPoint @ReMainStatPoint WHERE CharID @CharID
UPDATE sro_vt_Shard_che.DBO._Char SET RemainSkillPoint=RemainSkillPoint @TotalSP @TotalSPMastery+200000 WHERE CharID @CharID
DELETE sro_vt_Shard_che.DBO._CharSkill FROM sro_vt_Shard_che.DBO._RefSkill, sro_vt_Shard_che.DBO._CharSkill WHERE sro_vt_Shard_che.dbo._RefSkill.ID=sro_vt_Shard_che.dbo._CharSkill.SkillID AND sro_vt_Shard_che.dbo._CharSkill.CharID @CharID AND sro_vt_Shard_che.dbo._RefSkill.ReqCommon_MasteryLevel1 <= '125' AND sro_vt_Shard_che.dbo._RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625)
UPDATE sro_vt_Shard_che.DBO._CharSkillMastery SET Level='0' WHERE CharID @CharID AND Level <= '125'
end
end
end
end
end

Please help me, i try add it

[fuddreckers2]

that's pacific one right i know that you copy it from database when you was working with hassan crap man crap

[tvquan90]

please help me add system here in my server

[ilowe]

hi first script where add ?

[che929]

hi first script where add ?

Addlogitem

[ilowe]

Addlogitem

sro_vt_shard ?

[che929]

sro_vt_shard ?

sro_vt_log

[ilowe]

adjusted according to the level of ?
the hunter level 7 and give it to the line 1 stat

[Eroticus]

can you repload rebirth ?

[NadaZayed]

Can anyone re-upload the scroll ??

[Eroticus]

Up. !

Really sorry :P

[DACKERexe]

Can u please upload the scroll again lol??

[calipra]

pls ready upload

[evilheart]

reupload pls

[blapanda]

Lazy tards.
You guys won't even bother reading the procedures and assuming that even a regular scroll will work for a reborn system, right?

Create a usual teleport scroll and parse it as the item ID of 103062 into your _RefObjCommon (or change the item ID statment at your procedure. Search for it, don't ask me where to change that one). If you cannot do this little step, then you should consider giving up on game development, which you haven't started anyways.

[sallam2]

reupload scroll @che929