![]() |
|
There is some query for this (v2)? - Printable Version +- 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 ![]() |