Query To Change Item Mall Silk Price

[hamada619]

here is the query

use SRO_VT_SHARD
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_%%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_%%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_%_2%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_%_2%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_%_3%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_%_3%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_EVENT_%%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_EVENT_%%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_%_HAT%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_%_HAT%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_%_HAT_2%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_%_HAT_2%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_%_HAT_3%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_%_HAT_3%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_EVENT_%_HAT'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_EVENT_%_HAT'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_%_ATTACH%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_%_ATTACH%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_%_ATTACH_2%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_%_ATTACH_2%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_M_%_ATTACH_3%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_%_ATTACH_3%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_EVENT_%_ATTACH%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_MALL_AVATAR_W_EVENT_%_ATTACH%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_FLUTE_WHITE%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_JINN%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_RAVEN%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_PENGUIN%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_KANGAROO%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_BEAR%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_FOX%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_MYOWON%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_SEOWON%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_RABBIT%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_SPOT_RABBIT%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_GOLDPIG%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_PINKPIG%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_GGLIDER%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_CAT%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_RACCOONDOG%'
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = XX
WHERE RefPackageItemCodeName like '%PACKAGE_ITEM_COS_P_BROWNIE%'

forgot : change the xx with the silk price

[•ᵔBeGodOfWarᵔ•]

Cool , ty and added into my thread

[ahmed4ever2u]

stop coping every thing like crazy !
and put some credits .

[Ferpa_]

Well, nice copy pasta from me