How to remove...

[Kudzu]

How I can remove from all peoples in the game item with ID xxx?

 

[armitxe]

You can make it by a SQL Query...

I'm not so much pro in this, but i think it would be something like this:

UPDATE `player_items` DELETE `itemtype` = [COLOR="Red"]YOURITEMID[/COLOR];

How to execute a sql query?

	1. Enter into your phpmyadmin and click "SQL".
	2. Paste query there.
	3. Click "Execute"!

Hope it works..

1 suggestion... make a backup before you make that query, i don't know if it will work xD

Greetings.

 

[Cykotitan]

DELETE FROM `player_items` WHERE `itemtype` = 2500;

 

[Kudzu]

Thanks Cykotitan :_)

 

[Rozinx]

Watch out.
Do that for houses and depots too
Might be something like tileitems and depotitems

 

[Cykotitan]

DELETE FROM `player_depotitems`,`tile_items` WHERE `itemtype` = 2500;