كود 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