™MaR™
18-02-2015, 10:49 PM
http://www2.0zz0.com/2013/07/13/06/635523581.gif
http://www2.0zz0.com/2013/07/13/08/573080992.png
ناس كتير دلوقتي بتسال علي 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+@TotalS PMastery+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,115 26,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 و بعدين هتعمل تيليبورت وهينزلك الدم بتاع الشخصية .
شكرا ,
http://www2.0zz0.com/2013/07/13/08/573080992.png
ناس كتير دلوقتي بتسال علي 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+@TotalS PMastery+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,115 26,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 و بعدين هتعمل تيليبورت وهينزلك الدم بتاع الشخصية .
شكرا ,