[HIDE]
USE SRO_VT_SHARD
GO
UPDATE _RefShopGoods set Service ='0' where RefPackageItemCodeName ='PACKAGE_ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_11'
UPDATE _RefScrapOfPackageItem SET Service ='0' where RefPackageItemCodeName ='PACKAGE_ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_11'
UPDATE _RefPricePolicyOfItem SET Service ='0' where RefPackageItemCodeName ='PACKAGE_ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_11'
Update _RefPackageItem SET Service = '0' where CodeName128 ='PACKAGE_ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_11'
-- service 1 ise item aktif 0 ise deaktif --
-- if the service of item is 1 then the item is active in the game--
-- if the service of item is 0 then the item is deactive in the game--
-- do not forget to do txt procedures--
[/HIDE]
USE SRO_VT_SHARD
GO
UPDATE _RefShopGoods set Service ='0' where RefPackageItemCodeName ='PACKAGE_ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_11'
UPDATE _RefScrapOfPackageItem SET Service ='0' where RefPackageItemCodeName ='PACKAGE_ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_11'
UPDATE _RefPricePolicyOfItem SET Service ='0' where RefPackageItemCodeName ='PACKAGE_ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_11'
Update _RefPackageItem SET Service = '0' where CodeName128 ='PACKAGE_ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_11'
-- service 1 ise item aktif 0 ise deaktif --
-- if the service of item is 1 then the item is active in the game--
-- if the service of item is 0 then the item is deactive in the game--
-- do not forget to do txt procedures--
[/HIDE]
