Query to Delete All items by CharName

[arabcart]

Hello Brothers
i want Query to Delete Item By CHar Name
1 - Query to Delete from Inventory
2 - Query to Delete from Chest

[MentaL]

[DieEyes]

USE [SRO_VT_SHARD_INIT]

exec _SEEK_N_DESTROY_ITEM 'ITEM Code here'

This query will delete item from all game,

but you can continue it with where character16= "Character name"

will be something like that i think.

[Hell S Ing]

Thise one will clear all the vaults.


Code:
UPDATE warehouse
SET Items=(1)
----------------------


Thise one for deleting all the items from inventories.


Code:
UPDATE Character
SET inventory=(1)
----------------------