need query to set sell price in _RefObjCommon
need query to set sell price in _RefObjCommon
players start in my server with seal of start d10 items
they sell items to npc to farm gold
i know how to edit sell price manual at refobjecommn but hope someone make query better
Sell price ( D10 seal of star )
thanks
Re: need query to set sell price in _RefObjCommon
update _RefObjCommon set SellPrice = '1' where CodeName128 like 'ITEM_XXX'
Re: need query to set sell price in _RefObjCommon
Re: need query to set sell price in _RefObjCommon
UPDATE dbo.[_RefObjCommon] SET SellPrice=500 WHERE CodeName128 = 'ITEM_XXX'
OR
UPDATE dbo.[_RefObjCommon] SET SellPrice=500 WHERE CodeName128 like '%ITEM_XXX%'