Is possible remove 1 item of all players?

[Knight God]

is possible to remove the item XXXX all players in the database?
and how would the script or command?

 

[Elaney]

DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = 2160;

there you go just change 2160 to the item u want

 

[Knight God]

okay thanks!

 

[anotapreta]

My houses have much items but tile_Items is empyt, you know the problem? ;/

 

[Cykotitan]

then you're using binary storage, items are in house_data

while server is running set useHouseStorage = false, reload config and perform a server save
items should now appear in tile_items

 

[anotapreta]

I try this but don't work see my config

houseDataStorage = "binary"
saveGlobalStorage = true
useHouseDataStorage = false
storePlayerDirection = true
saveGameData = true


And in SQL have:

ALTER TABLE `tile_items`
ADD CONSTRAINT `tile_items_ibfk_1` FOREIGN KEY (`tile_id`) REFERENCES `tiles` (`id`) ON DELETE CASCADE;


what is this?



Complete:

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- [url]http://www.phpmyadmin.net[/url]
--
-- Servidor: localhost
-- Tempo de Geração: Jul 24, 2011 as 12:07 
-- Versão do Servidor: 5.5.8
-- Versão do PHP: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Banco de Dados: `ottibia`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `tile_items`
--

CREATE TABLE IF NOT EXISTS `tile_items` (
  `tile_id` int(10) unsigned NOT NULL,
  `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0',
  `sid` int(11) NOT NULL,
  `pid` int(11) NOT NULL DEFAULT '0',
  `itemtype` int(11) NOT NULL,
  `count` int(11) NOT NULL DEFAULT '0',
  `attributes` blob NOT NULL,
  UNIQUE KEY `tile_id` (`tile_id`,`world_id`,`sid`),
  KEY `sid` (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `tile_items`
--


--
-- Restrições para as tabelas dumpadas
--

--
-- Restrições para a tabela `tile_items`
--
ALTER TABLE `tile_items`
  ADD CONSTRAINT `tile_items_ibfk_1` FOREIGN KEY (`tile_id`) REFERENCES `tiles` (`id`) ON DELETE CASCADE;

EDIT: Now ok, I had a bug in /reload config