|
Project Manager
Join Date: Oct 2009
Posts: 14,460
|
|
Quote:
Originally Posted by Honest
[You must be logged in to view images. Log in or Register.]
I can continue to post links if needed but it appears that they were all at lvl 35.
|
Thanks, fixed those.
To give an idea of which npcs do not have loottables, or loottables that are broken/bad, here they are:
Quote:
Quote:
select distinct npt.name,npt.loottable_id from npc_types npt join spawnentry spt on (spt.npcid=npt.id) left join spawn2 sp2 on (sp2.spawngroupid=spt.spawngroupid)
where spt.chance > '0' and sp2.zone = 'skyshrine' and npt.loottable_id not in (7478,7441,6414,11498,11484) // loottables completed and applied
and npt.class <> '41' and npt.race <> '127' // not vendors or invisible men
order by npt.level asc, npt.name asc // lowest lvls first, ordered by name
|
Merec, a_crystal_spider, Osino, Propron, Norsirx, Ahcaz, Bartender_Chalgoc, Bartender_Diphenyl, Bartender_Helvit, Bartender_Ovalene, Bouncer_Boulder, Commander_Leuz, Sarot, Yaced, Abudan_Fe`Dhar, Adwetram_Fe`Dhar, Asteinnon_Fe`Dhar, Chymot, Crendatha_Fe`Dhar, Elaend_Fe`Dhar, Erepon, Fardonad_Fe`Dhar, Jendavudd_Fe`Dhar, Komawin_Fe`Dhar, Lothieder_Fe`Dhar, Nalelin_Fe`Dhar, Ocoenydd_Fe`Dhar, Onerind_Fe`Dhar, Orthor_Velic, Qynydd_Fe`Dhar, Tetragon_Velic, Umykith_Fe`Dhar, Zalerez, Anex, a_hungry_cube, Bezeb, Lyphor, Beeliz_Fe`Dhar, Polhidrix_Velic, Suez, Saliz_Fe`Dhar, Telnaq, Laegdric_Fe`Dhar, Meonyc_Fe`Dhar, Oct_Velic, Zeldaile_Fe`Dhar, Zynil, a_shambling_cube, Veobryn_Fe`Dhar, Blodoc_Fe`Dhar, Calexic_Fe`Dhar, Dygwyn_Fe`Dhar, Lararith, Poalgin_Fe`Dhar, Pyrox, Jaylorx, Kalacs_Fe`Dhar, Nalginor_Fe`Dhar, Oazyln_Fe`Dhar, Qalcnic_Fe`Dhar, Teoc_Fe`Dhar, Tycyn_Fe`Dhar, Ualkic_Fe`Dhar, Wealrn_Fe`Dhar, Elyshum_Fe`Dhar, Jaelk, Taegria_Fe`Dhar, Vobryn_Fe`Dhar, Morachii_Fe`Dhar, Vellyn_Fe`Dhar, Dalshim_Fe`Dhar, Medry_Fe`Dhar, Riran_Fe`Dhar, Talgixn_Fe`Dhar, Tyddyn_Fe`Dhar, a_large_velium_statue, Tonvan_Fe`Dhar, a_Dalgortha, a_kromzek_spy, Elder_Hajnix, Elder_Kajind, Elder_Kalur, Laoch_Jaklor, Laoch_Uljux, Laoch_Yailin, Laoch_Zelnair, Laoch_Yubtin, Laoch_Zalbryn, #Eldriaks_Fe`Dhar, Laoch_Sabtooth, Laoch_Yralix, Tri_Velic, #Supreme_Laochsmith_Psorin, Laoch_Maljix, Laoch_Zialben, #Ralgyn, Invisman, Laoch_Juklax, Laoch_Nablibx, Laoch_Salthz, Laoch_Yilnor, Quadrix_Velic, Zaldin_Fe`Dhar, Laoch_Aewern, Laoch_Drazifs, Laoch_Ealkiq, Laoch_Laeor, Laoch_Drixnal, Lignark, The_Seer, Laoch_Chief_Seti, #Oglard, a_Huge_Gargoyle_Guard, Jualicn, Lawyla, Placlis, Talnifs, Talon_Velic, A_Huge_Golem_Sentry
|
So, if you fight one of the npcs on the list, you should expect either no loot or incorrect loot. These need researching, tables created and applied. Usually the way it works is there are many npcs with the same tables. Since this is a work in progress, I thought I would share some of the behind the scenes action. |