[Tutorial] Removing non-deletable cash items from inventory

[Patchouli]

I decided to write this after accidentally turning on "queueing" for the push item command.
That resulted in thousands of unwanted items in my inventory that I could not delete in-game.

I don't really know how to write queries, so here are some quotes from SanGawku and WAMVN:

Query method:

do a query like
Select * from Items where ownerid = 'your character id'

In heroes database, new query:
Select * from Item where OwnedId = your character id.
The new added item is the last result.
Delete record
Go back to select character screen and enter game again.

Manual method:
Note that I did this in Navicat. I don't know how to do it in other tools, but if you know how to edit databases, you should be able to do it in any database editing tool.

1. In-game, equip the items you want to keep, then click "sort" to automatically sort your inventory.
This is because equipped items will have low slot numbers in the database.
So should items that are in your regular bags.

2. Go to your heroes database, and make a copy of "Item" for backup.
Just in case something goes wrong and you want to start over.

3. Open up "Item".
You'll see these:
ID (item ID)
ItemClass (internal item name)
OwnerID (obtained from CharacterInfo, under "ID")
Count (number of the item)
Collection (?)
Slot (the number of the inventory slot the item is stored at)
Tradable (whether it can be traded)
Checksum (only seems to be used on gold... to protect against cheating?)

4. Right click Slot and select Sort Descending.
It should now sort all the high number slot items first.
If you have a lot of unwanted items, you'll be starting in the thousands and work your way down.

5. Select all the entries down to around slot 100 to 60 (depends on what you want to get rid of).
In Navicat, you can select entire entries by selecting via the leftmost column (small empty space with a >).
Navicat will only list 1000 records per page, so you will just have to do one page at a time.
You can also just click Refresh after each deletion, so that you don't have to change pages.

If you don't know how to select:
Select one entry, scroll down, hold shift and select another.
Everything in between the first selected and second selected entry should become selected.

6. Right click or go to Edit dropdown menu and select Delete Record.
That should do it. There will probably be a few items left over that you don't want.
You can try deleting them one by one. I recommend backing up the database between each deletion.

Relog and all should be well.

[MentaL]

[WAMVN]

In heroes database, new query:
Select * from Item where OwnedId = your character id.
The new added item is the last result.
Delete record
Go back to select character screen and enter game again.
Thats what i did.

[WAMVN]

Another way is make all items can be destructible/can be delete.
Open heroesContents.db3, new query :

update ItemClassInfo set Indestructible=0

There are about 16k+ records so it takes a long time.
But you can delete any item ingame now

[med1]

I decided to write this after accidentally turning on "queueing" for the push item command.
That resulted in thousands of unwanted items in my inventory that I could not delete in-game.

How do I turn it off?

[Patchouli]

If you don't want it to queue up, then use the HeroCommand service, Click the Other button with chinese text and it wont' queue up. It just pushes everything one time. Thats the way i do it

^ There's that. You can also empty the QueuedItem table to clear the cache of queued items.

[Anvis]

any idea about how to delete a character?

[WAMVN]

any idea about how to delete a character?

In heroes database.
You need your charater id from CharacterInfo table. Then use that id to delete records from Character and CharacterInfo table.

[Patchouli]

If you want to be extra thorough, you can sort by character/owner ID and delete the rows that are IDs of characters that existed before you made yours.
I don't think it matters that much, though. And if you make a mistake there'll be problems.