+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Off-Topic (The Outer World) (https://lckb.dev/forum/forumdisplay.php?fid=198)
+---- Forum: General Discussion (https://lckb.dev/forum/forumdisplay.php?fid=147)
+---- Thread: There is some query for this (v2)? (/showthread.php?tid=566)
- Wrong - 12-31-2011
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 - 12-31-2011
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 - 12-31-2011
thx alot
