+- 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: Navicat Command (/showthread.php?tid=1124)
- halohalo - 09-16-2012
Well, just to check it out, i friend is trying to add a item that can be droped my all mobs in t_npc. If he add it 1 per 1, it would take too long...there is any command for console to put the item and drop rate of that item to be add it to all mobs in game?
Item: 9238
Drop Rate probability: 300
Thanks for help
Regards
Halo
- Kotetsu - 09-16-2012
UPDATE t_npc SET a_item_19='9238';
UPDATE t_npc SET a_item_percent_19='300000';
1. Set all NPC (drop 19) at "9238" item.
2. Update all NPC for drop 19 x300
- halohalo - 09-16-2012
Thanks Cry