|
USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE%'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE%'
|