Deleting items from inventory

[Jaroslaw1998]

i have 4 AStral Boards X Green (acount binding + Selling not allowet) how can i delete this items ;/ ?? plz help

 

[Zabuza]

Same here, i have alote of other items... any one knows ? :\

Delete char ? no no i have many quest done :\

 

[Jaroslaw1998]

there must be other way

 

[endar]

reset inventory to 0x0

 

[Jaroslaw1998]

maybe we can change this item to be sellable??

 

[chumpywumpy]

The items have an attribute set and changing them is harder than wiping storage. Just put everything you want to keep in your inventory and set storage to 0x0 as endar says.

 

[xz3r0x]

0x0 will couse an error in your server and will couse your client to halt (done that know that ) the better way is to set the data field of character to
0x03000000000005000000000000000000
it will erase all inventory and put a lvl1 healing potion in first slot.
Sql:

update dbo.cabal_Inventory_table set data  = 0x03000000000005000000000000000000 where characteridx = YOUR_CHAR_ID

and before querying the query ensure that u selected GAMEDB in your query analyzer


and one more thing character ids are located at cabal_character_table

 

[Jaroslaw1998]

that option remowe all my Inventory from slot I II and III but no remowe my warehouse???

 

[xz3r0x]

yes it just removes from your inventory, not equipped items not items in warehouse

if u wanna remove items from warehouse just change the table in the query to dbo.cabal_warehouse_table

 

[Jaroslaw1998]

thanks man it working i remove this boardrs

 

[Netgear]

it helps a lot^^ thx