[help]delete lapis

Hello what command should i use in db to delete an lapis from every player /inventory /gear.

like i want to remove 30 256 how i'do that? please help.

To delete from players inventory use this:

DELETE FROM PS_GameData.dbo.CharItems Where ItemUID = 'ItemCodeHere'

Then replace CharItems with Wh,GH.

Now, to delete lapises do something like this:

Update PS_GameData.dbo.CharItems
Set Gem1 = '0'
Where Gem1 = '7'

0 is to clear that spot on the item
7 is the ID, ex: craft lvl7 = 30007

Do the same for all slots on the items, Gem1,Gem2,Gem3,Gem4,Gem5,Gem6.

Thanks alot i have done with success