Query to delete items from inventory.

[Kamus Dev]

Olá a todos, preciso de ajuda para criar uma consulta para excluir um item específico do inventário. Você poderia me ajudar com isso? Segue uma imagem do erro que estou encontrando.

 

[ZkaRu]

you dont need some query to delete it, if you change your iteminfo and deleted that item id from the iteminfo, just make some random item with that id, just copy i dont know, the row from the item id 1 and paste it on the id 2577, then u can log in and delete it without problem

 

[Bommster]

you dont need some query to delete it, if you change your iteminfo and deleted that item id from the iteminfo, just make some random item with that id, just copy i dont know, the row from the item id 1 and paste it on the id 2577, then u can log in and delete it without problem

You know, something similar is happening to me, but when I replace the item in the iteminfo it says another ID, and another, happened 3 times.
First failed with 8192, added this id to iteminfo using blade of enigma (id 776), then the game said ID 13328 and I did the same, added blade of enigma to that id also, but then the game said ID 9472 and also did the same but this time it keeps happening for Id 9472 (I know it could be random numbers).
Maybe there is a way to read the inventory of the character? I know look column could reference to what character has equiped but don't know if it also references to what it has in its inventory, do you know that?

Thanks.

 

[zLuke]

Inventory is stored in the dbo.Resource table
type id:
1 - inventory
2 - temp bag
3 - bank
The row in the table is encrypted using

char g_key[9] = "19800216";
int Encrypt(char* buf, int len, const char* pwd, int plen)
{
    int i;
    for(i = 0;i<plen;i++)
    {
        buf[i] = pwd[i] + g_key[i%8];
    }
    return i;
}

 

[Mothanna]

what database, source using , because it depends how you kitbag saved sumchek as %d or as lld
if you're using single database you can try this tool below if will work with your files, but if you're using multi db /x32 bit mostly won't work for u