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