Help how to remove Arena Coin from all players

04/17/2015 18:33 Immortality-Sro#1
Help how to remove Arena Coin from all players:confused::confused::confused:
04/17/2015 18:35 WickedNite.#2
by using the seek and destroy procedure.
04/17/2015 18:37 Immortality-Sro#3
How :D from where
04/17/2015 18:41 Snow*#4
Quote:
Originally Posted by magicanoo View Post
You know you can use seek and destroy procedure,right?

PHP Code:
exec _SEEK_N_DESTROY_ITEM 'ITEM_MALL_GLOBAL_CHATTING' 
úse search
04/17/2015 18:56 Royalblade*#5
Use this method if the server is ONLINE & People are logged in, ELSE use Seek & Destroy.
Reason: The DB will find a different "First empty slot" than the gameserver. This results in disconnects all over the place. Better safe than sorry.

UPDATE _items SET RefItemID = 12 WHERE RefItemID = IDHERE

This replaces all arena coins with another item (dont ask me what 12 is.. probably a 1dg swords).