How to delete Specific Item from all accounts in your Ragnarok database

1. Login to your phpmyadmin

2. Click to ragnarok database

3. Click to SQL

4. Copy and paste the following to SQL (change the 1142 to the item_id of item that you want to delete):

DELETE FROM `auction` WHERE nameid=1142;
DELETE FROM `cart_inventory` WHERE nameid=1142;
DELETE FROM `guild_storage` WHERE nameid=1142;
DELETE FROM `inventory` WHERE nameid=1142;
DELETE FROM `mail` WHERE nameid=1142;
DELETE FROM `storage` WHERE nameid=1142;

5. Click go below. Done!
  • 102 Users Found This Useful
Was this answer helpful?

Related Articles

Custom Items

Alternative Video Tutorial: https://youtu.be/cV11LJ0VDakFirst, let's take a look at the item_db...

Ragnarok Developer Tools

Hercules Forumhttp://hercules.ws/board/rAthena Forumhttp://rathena.org/board/GRF ToolBest GRF...

How to Change the Server Configuration

Changing the Max Level:» https://gomanilahost.net/knowledgebase/119/Edit-Max-Level.htmlChanging...

How to add Player Commands

  Here's a list of commands available:...