Delete items all players?

[Mercury 5]

Hi, I'm Developing a small system and i need all users to delete items, I am using several functions but none do what I want Because the server cache does not allow me to delete items to all users, anyone knows how Could do something like? what I need is that the server is restarted, and remove a specific item to all players regardless of where the item is (deleting from SQL tables)

 

PD: Sorry me bad english

[TAUMP 1177]

player.item? maybe

[metin2team 816]

1. stop the server.

2. truncate player.item.

3. start the server.

 

or copy the item purge command and make one for the players and make it accessible by lua

 

when login begin

    pc.item_purge()

end

 

Edited August 1, 2015 by metin2team

[HellBoy 229]

a quest to remove item when he logs like metin2team posted above or turn of sv go player table and make a query to change that item vnum in item table into a potion one for example

 

for sql :

UPDATE `item` SET `vnum`='xxxx' WHERE (`vnum`='yyyyy')

 

login quest:

 

when login begin

pc.removeitem("xxxxxx", 200)

end