الموقع العربي الاول للعبة Silkroad Online - محتاج auto equipment D1

ضيف ده في ال AddLogChar_

كود PHP:

IF (@EventID = 22) begin exec dbo.AUTO_EQUIP end

واستخدم الكيوري ده

كود PHP:

USE [SRO_VT_SHARDlog] GO /****** Object: StoredProcedure [dbo].[AUTO_EQUIP] Script Date: 10/9/2014 2:32:41 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create procedure [dbo].[AUTO_EQUIP] @CharID int, @Data2 int as DECLARE @CharGender int =(select RefObjID from SRO_VT_SHARD.dbo._Char where CharID = @CharID) if (@CharGender between 1920 and 1932 or @CharGender between 14888 and 14900) begin -- female SET @CharGender = 0 end if (@CharGender between 1907 and 1919 or @CharGender between 14875 and 14887) begin -- male SET @CharGender = 1 end -- Auto Mastery Level -- Declare And Set some important thing ! Declare @OptLevel int = '5' If (@Data2 between 8 and 101) begin -- Item ID ! DECLARE @CurCharHeadID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 0 and inv.CharID = @CharID) ,@CurCharChestID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 1 and inv.CharID = @CharID) ,@CurCharShoulderID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 2 and inv.CharID = @CharID) ,@CurCharHandID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 3 and inv.CharID = @CharID) ,@CurCharLegsID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 4 and inv.CharID = @CharID) ,@CurCharFootID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 5 and inv.CharID = @CharID) ,@CurCharWepID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 6 and inv.CharID = @CharID) ,@CurCharShiledID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 7 and inv.CharID = @CharID) -- slot 8 unknown atm ,@CurCharEaringID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 9 and inv.CharID = @CharID) ,@CurCharNeckID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 10 and inv.CharID = @CharID) ,@CurCharLEFTRINGID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 11 and inv.CharID = @CharID) ,@CurCharRIGHTRINGID int =(select common.ID from SRO_VT_SHARD.dbo._RefObjCommon as common inner join SRO_VT_SHARD.dbo._Items as items on common.ID = items.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Items.ID64 = inv.ItemID where inv.Slot = 12 and inv.CharID = @CharID) -- item type DECLARE @TypeID1_Wep int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharWepID),@TypeID2_Wep int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharWepID),@TypeID3_Wep int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharWepID),@TypeID4_Wep int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharWepID) , @TypeID1_Head int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHeadID),@TypeID2_Head int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHeadID),@TypeID3_Head int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHeadID),@TypeID4_Head int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHeadID) , @TypeID1_Chest int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharChestID),@TypeID2_Chest int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharChestID),@TypeID3_Chest int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharChestID),@TypeID4_Chest int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharChestID) , @TypeID1_Shoulder int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShoulderID),@TypeID2_Shoulder int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShoulderID),@TypeID3_Shoulder int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShoulderID),@TypeID4_Shoulder int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShoulderID) , @TypeID1_Hand int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHandID),@TypeID2_Hand int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHandID),@TypeID3_Hand int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHandID),@TypeID4_Hand int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharHandID) , @TypeID1_Legs int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLegsID),@TypeID2_Legs int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLegsID),@TypeID3_Legs int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLegsID),@TypeID4_Legs int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLegsID) , @TypeID1_Foot int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharFootID),@TypeID2_Foot int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharFootID),@TypeID3_Foot int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharFootID),@TypeID4_Foot int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharFootID) , @TypeID1_Shiled int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShiledID),@TypeID2_Shiled int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShiledID),@TypeID3_Shiled int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShiledID),@TypeID4_Shiled int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharShiledID) , @TypeID1_Earing int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharEaringID),@TypeID2_Earing int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharEaringID),@TypeID3_Earing int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharEaringID),@TypeID4_Earing int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharEaringID) , @TypeID1_Neck int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharNeckID),@TypeID2_Neck int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharNeckID),@TypeID3_Neck int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharNeckID),@TypeID4_Neck int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharNeckID) , @TypeID1_LEFTRING int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLEFTRINGID),@TypeID2_LEFTRING int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLEFTRINGID),@TypeID3_LEFTRING int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLEFTRINGID),@TypeID4_LEFTRING int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharLEFTRINGID) , @TypeID1_RIGHTRING int =(select TypeID1 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharRIGHTRINGID),@TypeID2_RIGHTRING int =(select TypeID2 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharRIGHTRINGID),@TypeID3_RIGHTRING int =(select TypeID3 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharRIGHTRINGID),@TypeID4_RIGHTRING int =(select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @CurCharRIGHTRINGID) -- Next Item ID ! DECLARE @NextItemID_Wep int =(select top 1 ID from _RefObjCommon WITH (Nolock) where Service = 1 And TypeID1 = @TypeID1_Wep and TypeID2 = @TypeID2_Wep and TypeID3 = @TypeID3_Wep and TypeID4 = @TypeID4_Wep Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc) ,@NextItemID_Head int =(select Top 1 ID from _RefObjCommon where Link in(select ID from SRO_VT_SHARD.dbo._RefObjItem where ReqGender = @CharGender) and Service = 1 and TypeID1 = @TypeID1_Head and TypeID2 = @TypeID2_Head and TypeID3 = @TypeID3_Head and TypeID4 = @TypeID4_Head Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc) ,@NextItemID_Chest int =(select Top 1 ID from _RefObjCommon where Link in(select ID from SRO_VT_SHARD.dbo._RefObjItem where ReqGender = @CharGender) and Service = 1 and TypeID1 = @TypeID1_Chest and TypeID2 = @TypeID2_Chest and TypeID3 = @TypeID3_Chest and TypeID4 = @TypeID4_Chest Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc) ,@NextItemID_Shoulder int =(select Top 1 ID from _RefObjCommon where Link in(select ID from SRO_VT_SHARD.dbo._RefObjItem where ReqGender = @CharGender) and Service = 1 and TypeID1 = @TypeID1_Shoulder and TypeID2 = @TypeID2_Shoulder and TypeID3 = @TypeID3_Shoulder and TypeID4 = @TypeID4_Shoulder Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc) ,@NextItemID_Hand int =(select Top 1 ID from _RefObjCommon where Link in(select ID from SRO_VT_SHARD.dbo._RefObjItem where ReqGender = @CharGender) and Service = 1 and TypeID1 = @TypeID1_Hand and TypeID2 = @TypeID2_Hand and TypeID3 = @TypeID3_Hand and TypeID4 = @TypeID4_Hand Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc) ,@NextItemID_Legs int =(select Top 1 ID from _RefObjCommon where Link in(select ID from SRO_VT_SHARD.dbo._RefObjItem where ReqGender = @CharGender) and Service = 1 and TypeID1 = @TypeID1_Legs and TypeID2 = @TypeID2_Legs and TypeID3 = @TypeID3_Legs and TypeID4 = @TypeID4_Legs Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc) ,@NextItemID_Foot int =(select Top 1 ID from _RefObjCommon where Link in(select ID from SRO_VT_SHARD.dbo._RefObjItem where ReqGender = @CharGender) and Service = 1 and TypeID1 = @TypeID1_Foot and TypeID2 = @TypeID2_Foot and TypeID3 = @TypeID3_Foot and TypeID4 = @TypeID4_Foot Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc) ,@NextItemID_Shield int =(select top 1 ID from _RefObjCommon WITH (Nolock) where Service = 1 And TypeID1 = @TypeID1_Shiled and TypeID2 = @TypeID2_Shiled and TypeID3 = @TypeID3_Shiled and TypeID4 = @TypeID4_Shiled Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc) ,@NextItemID_Earing int =(select top 1 ID from _RefObjCommon WITH (Nolock) where Service = 1 And TypeID1 = @TypeID1_Earing and TypeID2 = @TypeID2_Earing and TypeID3 = @TypeID3_Earing and TypeID4 = @TypeID4_Earing Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc) ,@NextItemID_Neck int =(select top 1 ID from _RefObjCommon WITH (Nolock) where Service = 1 And TypeID1 = @TypeID1_Neck and TypeID2 = @TypeID2_Neck and TypeID3 = @TypeID3_Neck and TypeID4 = @TypeID4_Neck Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc) ,@NextItemID_LEFTRING int =(select top 1 ID from _RefObjCommon WITH (Nolock) where Service = 1 And TypeID1 = @TypeID1_LEFTRING and TypeID2 = @TypeID2_LEFTRING and TypeID3 = @TypeID3_LEFTRING and TypeID4 = @TypeID4_LEFTRING Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc) ,@NextItemID_RIGHTRING int =(select top 1 ID from _RefObjCommon WITH (Nolock) where Service = 1 And TypeID1 = @TypeID1_RIGHTRING and TypeID2 = @TypeID2_RIGHTRING and TypeID3 = @TypeID3_RIGHTRING and TypeID4 = @TypeID4_RIGHTRING Group by _RefObjCommon.ID,_RefObjCommon.reqlevel1 having (MAX(ReqLevel1)<=(Select CurLevel from SRO_VT_SHARD.dbo._Char where charid = @CharID)) Order By ReqLevel1 Desc) -- Update Items ! if (@NextItemID_Head is not null) begin update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Head , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '6',[MagParam1] = '257698037849',[MagParam2] = '128849019017',[MagParam3] = '21474836557',[MagParam4] = '1932735283349',[MagParam5] = '1932735283361',[MagParam6] = '25769803847',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '0' And CharID = @CharID) end if (@NextItemID_Chest is not null) begin update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Chest , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '6',[MagParam1] = '257698037849',[MagParam2] = '128849019017',[MagParam3] = '21474836557',[MagParam4] = '1932735283349',[MagParam5] = '1932735283361',[MagParam6] = '25769803847',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '1' And CharID = @CharID) end if (@NextItemID_Shoulder is not null) begin update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Shoulder , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '4',[MagParam1] = '257698037849',[MagParam2] = '128849019017',[MagParam3] = '21474836557',[MagParam4] = '21474836551',[MagParam5] = '0',[MagParam6] = '0',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '2' And CharID = @CharID) end if (@NextItemID_Hand is not null) begin update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Hand , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '4',[MagParam1] = '257698037849',[MagParam2] = '128849019017',[MagParam3] = '21474836557',[MagParam4] = '21474836551',[MagParam5] = '0',[MagParam6] = '0',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '3' And CharID = @CharID) end if (@NextItemID_Legs is not null) begin update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Legs , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '6',[MagParam1] = '257698037849',[MagParam2] = '128849019017',[MagParam3] = '21474836557',[MagParam4] = '1932735283349',[MagParam5] = '1932735283361',[MagParam6] = '25769803847',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '4' And CharID = @CharID) end if (@NextItemID_Foot is not null) begin update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Foot , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '4',[MagParam1] = '257698037849',[MagParam2] = '128849019017',[MagParam3] = '21474836557',[MagParam4] = '21474836551',[MagParam5] = '0',[MagParam6] = '0',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '5' And CharID = @CharID) end if (@NextItemID_Wep is not null) begin update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Wep , OptLevel = @OptLevel , Variance = '1524020653', [MagParamNum] = '5',[MagParam1] = '257698037849',[MagParam2] = '214748364913',[MagParam3] = '128849018981',[MagParam4] = '21474836557',[MagParam5] = '21474836551',[MagParam6] = '0',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '6' And CharID = @CharID) end if (@NextItemID_Shield is not null) begin update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Shield , OptLevel = @OptLevel , Variance = '450278829', [MagParamNum] = '4',[MagParam1] = '257698037849',[MagParam2] = '21474836557',[MagParam3] = '21474836551',[MagParam4] = '257698037885',[MagParam5] = '0',[MagParam6] = '0',[MagParam7] = '0',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '7' And CharID = @CharID) end if (@NextItemID_Earing is not null) begin update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Earing , OptLevel = @OptLevel , Variance = '429', [MagParamNum] = '7',[MagParam1] = '21474836557',[MagParam2] = '21474836551',[MagParam3] = '85899346099',[MagParam4] = '85899346087',[MagParam5] = '85899346105',[MagParam6] = '85899346093',[MagParam7] = '85899346111',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '9' And CharID = @CharID) end if (@NextItemID_Neck is not null) begin update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Neck , OptLevel = @OptLevel , Variance = '429', [MagParamNum] = '7',[MagParam1] = '21474836557',[MagParam2] = '21474836551',[MagParam3] = '85899346099',[MagParam4] = '85899346087',[MagParam5] = '85899346105',[MagParam6] = '85899346093',[MagParam7] = '85899346111',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '10' And CharID = @CharID) end if (@NextItemID_LEFTRING is not null) begin update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_LEFTRING , OptLevel = @OptLevel , Variance = '429', [MagParamNum] = '7',[MagParam1] = '21474836557',[MagParam2] = '21474836551',[MagParam3] = '85899346099',[MagParam4] = '85899346087',[MagParam5] = '85899346105',[MagParam6] = '85899346093',[MagParam7] = '85899346111',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '11' And CharID = @CharID) end if (@NextItemID_RIGHTRING is not null) begin update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_RIGHTRING , OptLevel = @OptLevel , Variance = '429', [MagParamNum] = '7',[MagParam1] = '21474836557',[MagParam2] = '21474836551',[MagParam3] = '85899346099',[MagParam4] = '85899346087',[MagParam5] = '85899346105',[MagParam6] = '85899346093',[MagParam7] = '85899346111',[MagParam8] = '0',[MagParam9] = '0',[MagParam10] = '0',[MagParam11] = '0',[MagParam12] = '0' Where ID64 in(Select ItemID from SRO_VT_SHARD.dbo._Inventory Where Slot = '12' And CharID = @CharID) end