Found my own answer. My query that I had adapted from the Defiant Armor drops (originally posted by Werebat) was the correct one. However, since I had originally created the lootdrop_id entry on an orc centurian in West commonlands, that entry already existed in a mob's loottable. Thus, when I ran the query below, it gave me an error that it already existed. I realized this after posting and removed the entry from the orc and then executed it again. It worked perfectly and after manually checking mobs lvl 5-19 in various zones, they all have the lootdrop_id in their loottable. I wanted to share the query just in case someone else wishes to accomplish the same thing. It's a regurgitation from others' scripts, but it may prove useful in certain scenarios. Please note my lootdrop_id number (100019) is from my database and would have to be replaced by your specific one. Again, it adds the lootdrop at 10% drop rate.
insert into loottable_entries select distinct loottable_id, 100019, 1, 10 from npc_types where loottable_id > 0 and level between 5 and 19;
|
Threaded Mode
