مشكلة في Procedure لـSkill Scroll

[iRock]

USE [SRO_VT_LOG] ---- Warrior Skills Scroll ---------------------------------- Declare @CharObjID Int, @MasteryCount Int, @MasteryID Int Select @CharObjID = RefObjID From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID Set @MasteryCount = (Select Count (*) From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and Level > 0) IF (@ItemRefID = 41806) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarrior] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarrior] Where Service = 1 END END END END ---- Dagger Skills Scroll ---------------------------------- IF (@ItemRefID = 41807) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsRogue] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsRogue] Where Service = 1 END END END END ---- Wizard Skills Scroll ---------------------------------- IF (@ItemRefID = 41805) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWizard] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWizard] Where Service = 1 End END END End ---- Warlock Skills Scroll ---------------------------------- IF (@ItemRefID = 41810) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarlock] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarlock] Where Service = 1 End END End End -- Bard Skills Scroll ------------------------------- IF (@ItemRefID = 41809) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBard] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBard] Where Service = 1 End END End End -- Claric Skills Scroll --------------------------------- IF (@ItemRefID = 41808) Begin IF @CharObjID > 3000 Begin IF @MasteryCount between 0 and 1 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsClaric] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsClaric] Where Service = 1 End End End END ---- Bicheon Skills Scroll ---------------------------------- IF (@ItemRefID = 41800) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBicheon] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBicheon] Where Service = 1 End END End End ---- Heuksal Skills Scroll ---------------------------------- IF (@ItemRefID = 41799) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsHeuksal] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsHeuksal] Where Service = 1 End END END End ---- Pacheon Skills Scroll ---------------------------------- IF (@ItemRefID = 41798) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsPacheon] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsPacheon] Where Service = 1 End END End End ---- Cold Skills Scroll ------------------------------- IF (@ItemRefID = 41803) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsCold] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsCold] Where Service = 1 End End End End ---- Lightning Skills Scroll ------------------------------------- IF (@ItemRefID = 41802) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsLightning] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsLightning] Where Service = 1 End End End End ---- Fire Skills Scroll -------------------------------- IF (@ItemRefID = 41801) Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsFire] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsFire] Where Service = 1 End End End End ---- Force Skills Scroll --------------------------------- IF (@ItemRefID = 41804) -- RefObjCommon ID Begin IF @CharObjID < 3000 Begin IF @MasteryCount between 0 and 2 Begin Set @MasteryID = (Select MasteryID From [dbo].[_SkillsForce] Where MasteryID Is Not Null) IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1) Begin Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsForce] Where Service = 1 End End End END

Error

Msg 137, Level 15, State 2, Line 5 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 6 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 7 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 14 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 16 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 17 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 18 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 25 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 32 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 34 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 35 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 36 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 43 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 50 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 52 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 53 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 54 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 61 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 68 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 70 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 71 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 72 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 80 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 87 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 89 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 90 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 91 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 99 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 106 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 108 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 109 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 110 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 117 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 124 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 126 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 127 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 128 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 136 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 143 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 145 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 146 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 147 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 155 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 162 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 164 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 165 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 166 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 174 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 181 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 183 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 184 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 185 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 193 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 200 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 202 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 203 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 204 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 212 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 219 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 221 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 222 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 223 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 231 Must declare the scalar variable "@ItemRefID". Msg 137, Level 15, State 2, Line 238 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 240 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 241 Must declare the scalar variable "@CharID". Msg 137, Level 15, State 2, Line 242 Must declare the scalar variable "@CharID".

انا بستخدم SQL Server 2008 R2 Express

يا ريت لو حد يقولي ايه الغلط اللي في الـ Procedure عشان اصلحه و الـError ده ميطلعش تاني