24-02-2015, 08:03 PM
|
#11
|
|
|
• الانـتـسـاب » Jul 2013
|
|
• رقـم العـضـويـة » 112689
|
|
• المشـــاركـات » 1,050
|
|
• الـدولـة » Egypt - Tanta
|
|
• الـهـوايـة » always try for a best features
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 34
|
|
|
 
|
.gif)
رد: مشكلة فى skills recall scroll
خد سطور اي سكرول من اللى موجوده ع الـ AddLogItem او من instant return scroll وضيفها بعد متعمل ريستور .. وخد الـ Procedure دا حطه فى AddLogItem
|
|
|
IF (@Operation = 41) And @ItemRefID = 'Scroll RefObjID'
Begin
Declare @TotalSP int
Declare @TotalSPMastery int
Select @TotalSP = SUM(SRO_VT_SHARD.._RefSkill.ReqLearn_SP) From SRO_VT_SHARD.._RefSkill, SRO_VT_SHARD.._CharSkill Where SRO_VT_SHARD.._RefSkill.ID=SRO_VT_SHARD.._CharSkill.SkillID AND SRO_VT_SHARD.._CharSkill.CharID=@CharID AND SRO_VT_SHARD.._RefSkill.ReqCommon_MasteryLevel1 <= '130'
Select @TotalSPMastery = SUM(SRO_VT_SHARD.._RefLevel.Exp_M) From SRO_VT_SHARD.._CharSkillMastery, SRO_VT_SHARD.._RefLevel Where SRO_VT_SHARD.._RefLevel.Lvl=SRO_VT_SHARD.._CharSkillMastery.Level AND SRO_VT_SHARD.._CharSkillMastery.CharID=@CharID AND SRO_VT_SHARD.._CharSkillMastery.Level <= '130'
Update SRO_VT_SHARD.._Char Set RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalSPMastery+200000 Where CharID=@CharID
Delete SRO_VT_SHARD.._CharSkill From SRO_VT_SHARD.._RefSkill, SRO_VT_SHARD.._CharSkill Where SRO_VT_SHARD.._RefSkill.ID=SRO_VT_SHARD.._CharSkill.SkillID AND SRO_VT_SHARD.._CharSkill.CharID=@CharID AND SRO_VT_SHARD.._RefSkill.ReqCommon_MasteryLevel1 <= '130' AND SRO_VT_SHARD.._RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625)
Update SRO_VT_SHARD.._CharSkillMastery Set Level='0' Where CharID=@CharID AND Level <= '130'
End
|
|
|
|
|