USE [SRO_VT_SHARD] UPDATE _RefObjCommon SET [TypeID1]= 3, [TypeID2]= 2, [TypeID3]= 1, [TypeID4]= 1, ReqLevelType1 = 1, ReqLevel1 = 12, AssocFile1_128 = 'GP:5000' WHERE ID Between 9280 and 9285 UPDATE _RefObjItem SET Desc1_128 = 'COS_GUILD_CH_SOLDIER1_120' WHERE ID = 5753 UPDATE _RefObjItem SET Desc1_128 = 'COS_GUILD_CH_SOLDIER2_120' WHERE ID = 5754 UPDATE _RefObjItem SET Desc1_128 = 'COS_GUILD_CH_SOLDIER3_120' WHERE ID = 5755 UPDATE _RefObjItem SET Desc1_128 = 'COS_GUILD_CH_SOLDIER4_120' WHERE ID = 5756 UPDATE _RefObjItem SET Desc1_128 = 'COS_GUILD_CH_SOLDIER5_120' WHERE ID = 5757 UPDATE _RefObjItem SET Desc1_128 = 'COS_GUILD_CH_SOLDIER6_120' WHERE ID = 5758 EXEC _GetMediaLines,2,'%ITEM_GUILD%SOLDIER%'