Message System

[™MaR™]

ناس كتير دلوقتي بتسال علي Message System دلوقتي ممكن تقدر تمسح ال Skills و تقدر تنزل الدم بتاع الشخصية عن طريق رسالة بتبعتها لاسم الشخصية بتاعتك و بعدين بتعمل تيليبورت .

SRO_VT_SHARD >> Programmability>>Stored Procedures>>_Memo_Add

Reset Skills

If (@TargetCharName like @SenderCharName and @Message = 'skills')
        Begin 
			declare @CharID int
            declare @TotalSP int 
            declare @TotalSPMastery int 
			set @CharID = (select CharID from _Char where CharName16 = @SenderCharName)
            SELECT @TotalSP = SUM(_RefSkill.ReqLearn_SP) FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '130'
            SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '130' 
            UPDATE _Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalSPMastery+200000 WHERE CharID=@CharID 
            DELETE _CharSkill FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '130' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625) 
            UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '130'  
        end

هتبعت رسالة لنفسك هتكتب skills و بعدين هتعمل تيليبورت و هيمسحلك كل ال Skills اللي في الشخصية .


Reset Points

If (@TargetCharName like @SenderCharName and @Message = 'points')
Begin 
            declare @Strength int 
            declare @Intellect int 
            declare @MaxLevel int 
            declare @RemainStatPoint int 
			set @CharID = (select CharID from _Char where CharName16 = @SenderCharName)
            select @MaxLevel = MaxLevel from _Char where CharID = @CharID 
            set @RemainStatPoint = (@MaxLevel*3)-3 
            set @MaxLevel = @MaxLevel+19 
            UPDATE _Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID 
        end

هتبعت رسالة لنفسك هتكتب points و بعدين هتعمل تيليبورت وهينزلك الدم بتاع الشخصية .


شكرا ,