Navicat problem

[sumkid]

I had made my own item and they worked but then when I copied a thread and and made a new row and pasted it in to the row(I changed the id of the first one and then copied and then changed the id back and pasted into a new row)and then did .dbreload in-game and then I added my new weapon and then I went to my bag and I noticed a question mark(the question mark was the item) and I put the cursur over the question mark and the game crashed I looked back in navicat and couldn't find the problem but then I notice Before the field name 1 there was another field I have never seen and it said field 4 and all the items were negative 1 for that field should I just delete the field or keep it.:confused:



By the way can someone tell me if it is possible to make your own commands and if it is how?

[dragonchat20]

The question mark in the backpack is from one of the item fields in in SQL file not being added. I think it is 'inventorytype'. Look it up and if it says 0 then that is your problem.

To Fix the Question mark:
Clear you cache. Find an item with the same 'displayID' as the one that you want to use, scroll across and look for the 'inventorytype' column. Enter the value from that area into the one of the item that you want to use.

Or you can post your SQL file here and I will fix it for you.