Delete Items?

[=sinister=]

I thought I deleted them, but the aren't gone! how do you delete items?

[2dgreengiant]

in sqlyog or navicat you can select it then hit delete, refresh the database and it should be gone

[CairiFEA]

If you mean from your inventory?

Delete the item, do .saveall (if you del and the server crashes, you get the item back)


If you want deleted from the database,

Find the item, delete the entry. A good helper now to ensure ppl dont get random items, delete that ID from the playeritems table as well. Just sort the list of ID and delete all the entries that have your item.


Cheers,

[TheSpidey]

Or,
DELETE FROM items WHERE entry=1337 LIMIT 1
will remove item with entry 1
or
DELETE FROM items WHERE name1 LIKE "%gladiator%"
will remove all items with "gladiator" in their name

[=sinister=]

Ok I need to delete these entries: 99991, 99992, 99993
I tried DELETE FROM items WHERE entry=99992 LIMIT 1, but it didn't do anything

mysql> DELETE FROM items WHERE entry=99992 LIMIT 1
->

[=sinister=]

The weird thing is, I click my database and go the the table "items" in navicat, I search for 99991, 99992, and 99993, and it doesn't show anything, but ingame I can type .additem 99991 and I get the item wtf

[*Alexz*]

did you restart server after?

[TheSpidey]

Delete your cache.

[=sinister=]

Yes, I restarted my server
And how do I delete my cache?

[Succy]

Go into your World of Warcraft Folder. There is a folder called Cache. Delete that folder. The folder will come back after, but everything will work fine. That's needed when you for example rename an Item already seen or renaming a mob/npc you've already seen!

[=sinister=]

...
99991 and 99993 need to be deleted now
I delete them, they are NOT in the freaking database..
I restart the server, delete my cache / whatever, log in. .additem 99991 and I got it...
IT'S NOT IN THE DATABSE WHY THE HELL IS IT SHOWING UP WTF

[TheSpidey]

Delete the WDB folder in your wow installation too.
Make sure you're not running the game when you do it

[=sinister=]

Finally got it, thank you all who helped!