There is some query for this (v2)?

[Wrong]

Hi guys, I really need a query to remove all the drops from all mobs except the money, Id very very gratefull.

 

Thx, regards and happy new year!

[donwon]

UPDATE t_npc SET a_item_0 =;

UPDATE t_npc SET a_item_1 =;

UPDATE t_npc SET a_item_2 =;

UPDATE t_npc SET a_item_3 =;

UPDATE t_npc SET a_item_4 =;

UPDATE t_npc SET a_item_5 =;

UPDATE t_npc SET a_item_6 =;

UPDATE t_npc SET a_item_7 =;

UPDATE t_npc SET a_item_8 =;

UPDATE t_npc SET a_item_9 =;

UPDATE t_npc SET a_item_10 =;

UPDATE t_npc SET a_item_11 =;

UPDATE t_npc SET a_item_12 =;

UPDATE t_npc SET a_item_13 =;

UPDATE t_npc SET a_item_14 =;

UPDATE t_npc SET a_item_15 =;

UPDATE t_npc SET a_item_16 =;

UPDATE t_npc SET a_item_17 =;

UPDATE t_npc SET a_item_18 =;

UPDATE t_npc SET a_item_19 =;

I Belive this will work i tested it it removes all items Hope this helps This will not remove gold from mobs just the items

[Wrong]

thx alot