AutoEquiptment_D10 how to change it to max Dg 9 ?
the problem is i dont know to change it .
im using ORTAI
check screens
check procedure
the problem is i dont know to change it .
im using ORTAI
check screens
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[AutoEquiptment_D10] Script Date: 11/23/2015 5:08:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[AutoEquiptment_D10]
@CharID int,
@Data2 int
as
-- this is auto eqiupment system by Skull soil
-- Male Or Female !!
DECLARE @CharGender int =(select RefObjID from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
if (@CharGender between 1907 and 1919 or @CharGender between 14875 and 14887)
begin
SET @CharGender = 1
end
if (@CharGender between 1920 and 1932 or @CharGender between 14888 and 14900)
begin
SET @CharGender = 0
end
-- Auto Mastery Level
-- Declare And Set some importent thing !
Declare @OptLevel int = '3'
-- Item ID !
DECLARE @CurCharHeadID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 0 and inv.CharID = @CharID)
,@CurCharChestID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 1 and inv.CharID = @CharID)
,@CurCharShoulderID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 2 and inv.CharID = @CharID)
,@CurCharHandID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 3 and inv.CharID = @CharID)
,@CurCharLegsID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 4 and inv.CharID = @CharID)
,@CurCharFootID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 5 and inv.CharID = @CharID)
,@CurCharWepID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 6 and inv.CharID = @CharID)
,@CurCharShiledID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 7 and inv.CharID = @CharID)
,@CurCharEaringID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 9 and inv.CharID = @CharID)
,@CurCharNeckID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 10 and inv.CharID = @CharID)
,@CurCharLEFTRINGID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 11 and inv.CharID = @CharID)
,@CurCharRIGHTRINGID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 12 and inv.CharID = @CharID)
-- item Type ID !
DECLARE @TypeID1_Wep int =(select TypeID1 from _RefObjCommon where ID = @CurCharWepID),@TypeID2_Wep int =(select TypeID2 from _RefObjCommon where ID = @CurCharWepID),@TypeID3_Wep int =(select TypeID3 from _RefObjCommon where ID = @CurCharWepID),@TypeID4_Wep int =(select TypeID4 from _RefObjCommon where ID = @CurCharWepID)
, @TypeID1_Head int =(select TypeID1 from _RefObjCommon where ID = @CurCharHeadID),@TypeID2_Head int =(select TypeID2 from _RefObjCommon where ID = @CurCharHeadID),@TypeID3_Head int =(select TypeID3 from _RefObjCommon where ID = @CurCharHeadID),@TypeID4_Head int =(select TypeID4 from _RefObjCommon where ID = @CurCharHeadID)
, @TypeID1_Chest int =(select TypeID1 from _RefObjCommon where ID = @CurCharChestID),@TypeID2_Chest int =(select TypeID2 from _RefObjCommon where ID = @CurCharChestID),@TypeID3_Chest int =(select TypeID3 from _RefObjCommon where ID = @CurCharChestID),@TypeID4_Chest int =(select TypeID4 from _RefObjCommon where ID = @CurCharChestID)
, @TypeID1_Shoulder int =(select TypeID1 from _RefObjCommon where ID = @CurCharShoulderID),@TypeID2_Shoulder int =(select TypeID2 from _RefObjCommon where ID = @CurCharShoulderID),@TypeID3_Shoulder int =(select TypeID3 from _RefObjCommon where ID = @CurCharShoulderID),@TypeID4_Shoulder int =(select TypeID4 from _RefObjCommon where ID = @CurCharShoulderID)
, @TypeID1_Hand int =(select TypeID1 from _RefObjCommon where ID = @CurCharHandID),@TypeID2_Hand int =(select TypeID2 from _RefObjCommon where ID = @CurCharHandID),@TypeID3_Hand int =(select TypeID3 from _RefObjCommon where ID = @CurCharHandID),@TypeID4_Hand int =(select TypeID4 from _RefObjCommon where ID = @CurCharHandID)
, @TypeID1_Legs int =(select TypeID1 from _RefObjCommon where ID = @CurCharLegsID),@TypeID2_Legs int =(select TypeID2 from _RefObjCommon where ID = @CurCharLegsID),@TypeID3_Legs int =(select TypeID3 from _RefObjCommon where ID = @CurCharLegsID),@TypeID4_Legs int =(select TypeID4 from _RefObjCommon where ID = @CurCharLegsID)
, @TypeID1_Foot int =(select TypeID1 from _RefObjCommon where ID = @CurCharFootID),@TypeID2_Foot int =(select TypeID2 from _RefObjCommon where ID = @CurCharFootID),@TypeID3_Foot int =(select TypeID3 from _RefObjCommon where ID = @CurCharFootID),@TypeID4_Foot int =(select TypeID4 from _RefObjCommon where ID = @CurCharFootID)
, @TypeID1_Shiled int =(select TypeID1 from _RefObjCommon where ID = @CurCharShiledID),@TypeID2_Shiled int =(select TypeID2 from _RefObjCommon where ID = @CurCharShiledID),@TypeID3_Shiled int =(select TypeID3 from _RefObjCommon where ID = @CurCharShiledID),@TypeID4_Shiled int =(select TypeID4 from _RefObjCommon where ID = @CurCharShiledID)
, @TypeID1_Earing int =(select TypeID1 from _RefObjCommon where ID = @CurCharEaringID),@TypeID2_Earing int =(select TypeID2 from _RefObjCommon where ID = @CurCharEaringID),@TypeID3_Earing int =(select TypeID3 from _RefObjCommon where ID = @CurCharEaringID),@TypeID4_Earing int =(select TypeID4 from _RefObjCommon where ID = @CurCharEaringID)
, @TypeID1_Neck int =(select TypeID1 from _RefObjCommon where ID = @CurCharNeckID),@TypeID2_Neck int =(select TypeID2 from _RefObjCommon where ID = @CurCharNeckID),@TypeID3_Neck int =(select TypeID3 from _RefObjCommon where ID = @CurCharNeckID),@TypeID4_Neck int =(select TypeID4 from _RefObjCommon where ID = @CurCharNeckID)
, @TypeID1_LEFTRING int =(select TypeID1 from _RefObjCommon where ID = @CurCharLEFTRINGID),@TypeID2_LEFTRING int =(select TypeID2 from _RefObjCommon where ID = @CurCharLEFTRINGID),@TypeID3_LEFTRING int =(select TypeID3 from _RefObjCommon where ID = @CurCharLEFTRINGID),@TypeID4_LEFTRING int =(select TypeID4 from _RefObjCommon where ID = @CurCharLEFTRINGID)
, @TypeID1_RIGHTRING int =(select TypeID1 from _RefObjCommon where ID = @CurCharRIGHTRINGID),@TypeID2_RIGHTRING int =(select TypeID2 from _RefObjCommon where ID = @CurCharRIGHTRINGID),@TypeID3_RIGHTRING int =(select TypeID3 from _RefObjCommon where ID = @CurCharRIGHTRINGID),@TypeID4_RIGHTRING int =(select TypeID4 from _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 @Data2 between '90' and '94' begin
if (@NextItemID_Head is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Head , OptLevel = @OptLevel , Variance = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '12' And CharID = @CharID)
end
end
GO
/****** Object: StoredProcedure [dbo].[AutoEquiptment_D10] Script Date: 11/23/2015 5:08:48 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[AutoEquiptment_D10]
@CharID int,
@Data2 int
as
-- this is auto eqiupment system by Skull soil
-- Male Or Female !!
DECLARE @CharGender int =(select RefObjID from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
if (@CharGender between 1907 and 1919 or @CharGender between 14875 and 14887)
begin
SET @CharGender = 1
end
if (@CharGender between 1920 and 1932 or @CharGender between 14888 and 14900)
begin
SET @CharGender = 0
end
-- Auto Mastery Level
-- Declare And Set some importent thing !
Declare @OptLevel int = '3'
-- Item ID !
DECLARE @CurCharHeadID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 0 and inv.CharID = @CharID)
,@CurCharChestID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 1 and inv.CharID = @CharID)
,@CurCharShoulderID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 2 and inv.CharID = @CharID)
,@CurCharHandID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 3 and inv.CharID = @CharID)
,@CurCharLegsID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 4 and inv.CharID = @CharID)
,@CurCharFootID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 5 and inv.CharID = @CharID)
,@CurCharWepID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 6 and inv.CharID = @CharID)
,@CurCharShiledID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 7 and inv.CharID = @CharID)
,@CurCharEaringID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 9 and inv.CharID = @CharID)
,@CurCharNeckID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 10 and inv.CharID = @CharID)
,@CurCharLEFTRINGID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 11 and inv.CharID = @CharID)
,@CurCharRIGHTRINGID int =(select Top 1 Item.RefItemID from SRO_VT_SHARD.dbo._Items as Item inner join _RefObjCommon as common on common.ID = item.RefItemID inner Join SRO_VT_SHARD.dbo._Inventory as inv on Item.ID64 = inv.ItemID where inv.Slot = 12 and inv.CharID = @CharID)
-- item Type ID !
DECLARE @TypeID1_Wep int =(select TypeID1 from _RefObjCommon where ID = @CurCharWepID),@TypeID2_Wep int =(select TypeID2 from _RefObjCommon where ID = @CurCharWepID),@TypeID3_Wep int =(select TypeID3 from _RefObjCommon where ID = @CurCharWepID),@TypeID4_Wep int =(select TypeID4 from _RefObjCommon where ID = @CurCharWepID)
, @TypeID1_Head int =(select TypeID1 from _RefObjCommon where ID = @CurCharHeadID),@TypeID2_Head int =(select TypeID2 from _RefObjCommon where ID = @CurCharHeadID),@TypeID3_Head int =(select TypeID3 from _RefObjCommon where ID = @CurCharHeadID),@TypeID4_Head int =(select TypeID4 from _RefObjCommon where ID = @CurCharHeadID)
, @TypeID1_Chest int =(select TypeID1 from _RefObjCommon where ID = @CurCharChestID),@TypeID2_Chest int =(select TypeID2 from _RefObjCommon where ID = @CurCharChestID),@TypeID3_Chest int =(select TypeID3 from _RefObjCommon where ID = @CurCharChestID),@TypeID4_Chest int =(select TypeID4 from _RefObjCommon where ID = @CurCharChestID)
, @TypeID1_Shoulder int =(select TypeID1 from _RefObjCommon where ID = @CurCharShoulderID),@TypeID2_Shoulder int =(select TypeID2 from _RefObjCommon where ID = @CurCharShoulderID),@TypeID3_Shoulder int =(select TypeID3 from _RefObjCommon where ID = @CurCharShoulderID),@TypeID4_Shoulder int =(select TypeID4 from _RefObjCommon where ID = @CurCharShoulderID)
, @TypeID1_Hand int =(select TypeID1 from _RefObjCommon where ID = @CurCharHandID),@TypeID2_Hand int =(select TypeID2 from _RefObjCommon where ID = @CurCharHandID),@TypeID3_Hand int =(select TypeID3 from _RefObjCommon where ID = @CurCharHandID),@TypeID4_Hand int =(select TypeID4 from _RefObjCommon where ID = @CurCharHandID)
, @TypeID1_Legs int =(select TypeID1 from _RefObjCommon where ID = @CurCharLegsID),@TypeID2_Legs int =(select TypeID2 from _RefObjCommon where ID = @CurCharLegsID),@TypeID3_Legs int =(select TypeID3 from _RefObjCommon where ID = @CurCharLegsID),@TypeID4_Legs int =(select TypeID4 from _RefObjCommon where ID = @CurCharLegsID)
, @TypeID1_Foot int =(select TypeID1 from _RefObjCommon where ID = @CurCharFootID),@TypeID2_Foot int =(select TypeID2 from _RefObjCommon where ID = @CurCharFootID),@TypeID3_Foot int =(select TypeID3 from _RefObjCommon where ID = @CurCharFootID),@TypeID4_Foot int =(select TypeID4 from _RefObjCommon where ID = @CurCharFootID)
, @TypeID1_Shiled int =(select TypeID1 from _RefObjCommon where ID = @CurCharShiledID),@TypeID2_Shiled int =(select TypeID2 from _RefObjCommon where ID = @CurCharShiledID),@TypeID3_Shiled int =(select TypeID3 from _RefObjCommon where ID = @CurCharShiledID),@TypeID4_Shiled int =(select TypeID4 from _RefObjCommon where ID = @CurCharShiledID)
, @TypeID1_Earing int =(select TypeID1 from _RefObjCommon where ID = @CurCharEaringID),@TypeID2_Earing int =(select TypeID2 from _RefObjCommon where ID = @CurCharEaringID),@TypeID3_Earing int =(select TypeID3 from _RefObjCommon where ID = @CurCharEaringID),@TypeID4_Earing int =(select TypeID4 from _RefObjCommon where ID = @CurCharEaringID)
, @TypeID1_Neck int =(select TypeID1 from _RefObjCommon where ID = @CurCharNeckID),@TypeID2_Neck int =(select TypeID2 from _RefObjCommon where ID = @CurCharNeckID),@TypeID3_Neck int =(select TypeID3 from _RefObjCommon where ID = @CurCharNeckID),@TypeID4_Neck int =(select TypeID4 from _RefObjCommon where ID = @CurCharNeckID)
, @TypeID1_LEFTRING int =(select TypeID1 from _RefObjCommon where ID = @CurCharLEFTRINGID),@TypeID2_LEFTRING int =(select TypeID2 from _RefObjCommon where ID = @CurCharLEFTRINGID),@TypeID3_LEFTRING int =(select TypeID3 from _RefObjCommon where ID = @CurCharLEFTRINGID),@TypeID4_LEFTRING int =(select TypeID4 from _RefObjCommon where ID = @CurCharLEFTRINGID)
, @TypeID1_RIGHTRING int =(select TypeID1 from _RefObjCommon where ID = @CurCharRIGHTRINGID),@TypeID2_RIGHTRING int =(select TypeID2 from _RefObjCommon where ID = @CurCharRIGHTRINGID),@TypeID3_RIGHTRING int =(select TypeID3 from _RefObjCommon where ID = @CurCharRIGHTRINGID),@TypeID4_RIGHTRING int =(select TypeID4 from _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 @Data2 between '90' and '94' begin
if (@NextItemID_Head is not null)
begin
update SRO_VT_SHARD.dbo._Items set RefItemID = @NextItemID_Head , OptLevel = @OptLevel , Variance = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '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 = '0', [MagParamNum] = '0',[MagParam1] = '0',[MagParam2] = '0',[MagParam3] = '0',[MagParam4] = '0',[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 = '12' And CharID = @CharID)
end
end