View Single Post
  #9  
Old 12-22-2011, 05:45 PM
Burningsoul
Banned
 
Join Date: Oct 2009
Posts: 312
Default

That's what I was implying, and yes it's quite a daunting task. Given that he wants all items to drop, and there's 90,000+ items according to world.exe, that's a HUGE loottable entry

Thinking about it, something like the following would help a bit..

insert into lootdrop values (100001, 'Megaloots_1');
insert into lootdrop_entries select 100001, id, 1, 1, 1 from items where id>0 and id<101;
insert into loottable_entries select distinct loottable_id, 100001, 1, 4 from npc_types where loottable_id > 0 and level between 0 and 10;
(Shamelessly stolen and modified from the "Activating Defiant Drops" thread)

It would still take 900 Lootdrop Entries, and that's not even filtering the junk (Fire Procs and other placeholder items) that you wouldn't want. For giggles awhile back, I gave all level 1-10 Npcs a loottable with 30 100-item lootdrops. Loading up world and zone.exe took quite some time, I'd love to see it choke down aforementioned loottable
Reply With Quote