Query To Change Item Mall Silk Price

02/12/2012 17:28 hamada619#1
here is the query

Quote:
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
02/12/2012 17:31 •ᵔBeGodOfWarᵔ•#2
Cool , ty and added into my thread ;)
02/12/2012 17:47 ahmed4ever2u#3
stop coping every thing like crazy !
and put some credits .
02/12/2012 19:57 Ferpa_#4
Well, nice copy pasta from me
[Only registered and activated users can see links. Click Here To Register...]