Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Database/World Building
Reload this Page PoN / SsraTemple Boss Loottables

Archive::Database/World Building Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 03-04-2004, 07:00 PM
Daeath
Sarnak
  
Join Date: Feb 2004
Posts: 55
Default PoN / SsraTemple Boss Loottables
Here ya go... been goofin' around with loot last couple days and made entries for the named NPC's in PoN and SsraTemple zones. Didn't include spells, and only a couple of the 'plain-vanilla' mobs have accurate loot. Should work for any DB as long as the naming scheme is simular to MW's. Feel free to modify the chance values- I have it default to 100% drop of all items in table - did this for a raid I did with my buddies, didn't feel like camping the same boss mob for all his stuff.

Code:
#SsraTemple Loot

# Begin Zhroushe_Mezhkazh Loot
INSERT INTO loottable VALUES ('8030', 'Zhroushe_Mezhkazh', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8030', '8030', '2', '100');
INSERT INTO lootdrop VALUES ('8030', 'Zhroushe_Mezhkazh');
INSERT INTO lootdrop_entries VALUES ('8030', '19700', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8030', '19543', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8030 WHERE (name LIKE '%Zhroushe_Mezhkazh%');
# End Loot

# Begin Vyzh`dra_the_Exiled Loot
INSERT INTO loottable VALUES ('8031', 'Vyzh`dra_the_Exiled', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8031', '8031', '16', '100');
INSERT INTO lootdrop VALUES ('8031', 'Vyzh`dra_the_Exiled');
INSERT INTO lootdrop_entries VALUES ('8031', '22196', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8031', '27314', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '7822', 1, 1, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '28834', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '28810', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '26848', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '26545', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '27313', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '28836', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '7826', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '28840', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '10046', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '28844', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '27311', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '27312', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8031', '19535', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8031 WHERE (name LIKE '%Vyzh`dra_the_Exiled%');
# End Loot

# Begin SSra_Taskmaster Loot
INSERT INTO loottable VALUES ('8032', 'SSra_Taskmaster', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8032', '8032', '7', '100');
INSERT INTO lootdrop VALUES ('8032', 'SSra_Taskmaster');
INSERT INTO lootdrop_entries VALUES ('8032', '32529', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8032', '22915', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8032', '6207', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8032', '22901', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8032', '7698', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8032', '24542', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8032', '17118', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8032 WHERE (name LIKE '%Taskmaster_Zerumaz%');
UPDATE npc_types SET loottable_id = 8032 WHERE (name LIKE '%Taskmaster_Zhe`Vozh%');
UPDATE npc_types SET loottable_id = 8032 WHERE (name LIKE '%Taskmaster_Kavamezh%');
UPDATE npc_types SET loottable_id = 8032 WHERE (name LIKE '%Taskmaster_Keuzozh%');
UPDATE npc_types SET loottable_id = 8032 WHERE (name LIKE '%Taskmaster_Mikazha%');
UPDATE npc_types SET loottable_id = 8032 WHERE (name LIKE '%Taskmaster_Revan`Kezh%');
UPDATE npc_types SET loottable_id = 8032 WHERE (name LIKE '%Taskmaster_Vezhkah%');
# End Loot

# Begin Xerkizh_the_Creator Loot
INSERT INTO loottable VALUES ('8033', 'Xerkizh_the_Creator', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8033', '8033', '19', '100');
INSERT INTO lootdrop VALUES ('8033', 'Xerkizh_the_Creator');
INSERT INTO lootdrop_entries VALUES ('8033', '22196', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8033', '30537', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8033', '28824', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8033', '28811', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8033', '28849', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8033', '28857', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8033', '26809', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8033', '30538', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8033', '26562', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8033', '28842', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8033', '28854', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8033', '26535', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8033', '30568', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8033', '30567', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8033', '30479', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8033', '28820', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8033', '28845', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8033', '26593', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8033', '26563', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8033 WHERE (name LIKE '%Xerkizh_the_Creator%');
# End Loot

# Begin The_Shissar_Magister Loot
INSERT INTO loottable VALUES ('8034', 'The_Shissar_Magister', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8034', '8034', '2', '100');
INSERT INTO lootdrop VALUES ('8034', 'The_Shissar_Magister');
INSERT INTO lootdrop_entries VALUES ('8034', '19703', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8034', '63165', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8034 WHERE (name LIKE '%The_Shissar_Magister%');
# End Loot

# Begin Vyzh`dra_the_Cursed Loot
INSERT INTO loottable VALUES ('8035', 'Vyzh`dra_the_Cursed', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8035', '8035', '20', '100');
INSERT INTO lootdrop VALUES ('8035', 'Vyzh`dra_the_Cursed');
INSERT INTO lootdrop_entries VALUES ('8035', '22196', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8035', '27316', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8035', '28855', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8035', '7825', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8035', '30534', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8035', '26580', 1, 1, '2');  
INSERT INTO lootdrop_entries VALUES ('8035', '30541', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8035', '26567', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8035', '30565', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8035', '27315', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8035', '38826', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8035', '28806', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8035', '30562', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8035', '30527', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8035', '65288', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8035', '26819', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8035', '6615', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8035', '30564', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8035', '7823', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8035', '30563', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8035 WHERE (name LIKE '%Vyzh`dra_the_Cursed%');
# End Loot

# Begin Spiritward_Trilzic Loot
INSERT INTO loottable VALUES ('8036', 'Spiritward_Trilzic', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8036', '8036', '1', '100');
INSERT INTO lootdrop VALUES ('8036', 'Spiritward_Trilzic');
INSERT INTO lootdrop_entries VALUES ('8036', '8212', 1, 0, '2');
UPDATE npc_types SET loottable_id = 8036 WHERE (name LIKE '%Spiritward_Trilzic%');
# End Loot

# Begin Rutin_Kylong Loot
INSERT INTO loottable VALUES ('8037', 'Rutin_Kylong', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8037', '8037', '2', '100');
INSERT INTO lootdrop VALUES ('8037', 'Rutin_Kylong');
INSERT INTO lootdrop_entries VALUES ('8037', '8205', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8037', '22196', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8037 WHERE (name LIKE '%Rutin_Kylong%');
# End Loot

# Begin SsraTemple_Rhozth Loot
INSERT INTO loottable VALUES ('8038', 'SsraTemple_Rhozth', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8038', '8038', '2', '100');
INSERT INTO lootdrop VALUES ('8038', 'SsraTemple_Rhozth');
INSERT INTO lootdrop_entries VALUES ('8038', '6210', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8038', '7678', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8038 WHERE (name LIKE '%Rhozth_Ssravizh%');
UPDATE npc_types SET loottable_id = 8038 WHERE (name LIKE '%Rhozth_Ssrakezh%');
# End Loot

# Begin Rhag'Zhezum Loot
INSERT INTO loottable VALUES ('8039', 'Rhag'Zhezum', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8039', '8039', '10', '100');
INSERT INTO lootdrop VALUES ('8039', 'Rhag'Zhezum');
INSERT INTO lootdrop_entries VALUES ('8039', '22196', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8039', '30558', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8039', '26512', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8039', '26543', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8039', '26827', 1, 1, '2');  
INSERT INTO lootdrop_entries VALUES ('8039', '28817', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8039', '28812', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8039', '30560', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8039', '30559', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8039', '26501', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8039 WHERE (name LIKE '%Rhag`Zhezum%');
# End Loot

# Begin Rhag`Mozdezh Loot
INSERT INTO loottable VALUES ('8040', 'Rhag`Mozdezh', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8040', '8040', '15', '100');
INSERT INTO lootdrop VALUES ('8040', 'Rhag`Mozdezh');
INSERT INTO lootdrop_entries VALUES ('8040', '22196', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8040', '30555', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8040', '28841', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8040', '26521', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8040', '26516', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8040', '28802', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8040', '30557', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8040', '28837', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8040', '30554', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8040', '30556', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8040', '32531', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8040', '28828', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8040', '28807', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8040', '26505', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8040', '32526', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8040 WHERE (name LIKE '%Rhag`Mozdezh%');
# End Loot

# Begin Nerla_Kunzar Loot
INSERT INTO loottable VALUES ('8041', 'Nerla_Kunzar', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8041', '8041', '4', '100');
INSERT INTO lootdrop VALUES ('8041', 'Nerla_Kunzar');
INSERT INTO lootdrop_entries VALUES ('8041', '8207', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8041', '8204', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8041', '8203', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8041', '7966', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8041 WHERE (name LIKE '%Nerla_Kunzar%');
# End Loot

# Begin Kalin_Nathsar Loot
INSERT INTO loottable VALUES ('8042', 'Kalin_Nathsar', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8042', '8042', '2', '100');
INSERT INTO lootdrop VALUES ('8042', 'Kalin_Nathsar');
INSERT INTO lootdrop_entries VALUES ('8042', '8210', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8042', '8208', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8042 WHERE (name LIKE '%Kalin_Nathsar%');
# End Loot

# Begin High_Priest_of_Ssraeshza Loot
INSERT INTO loottable VALUES ('8043', 'High_Priest_of_Ssraeshza', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8043', '8043', '18', '100');
INSERT INTO lootdrop VALUES ('8043', 'High_Priest_of_Ssraeshza');
INSERT INTO lootdrop_entries VALUES ('8043', '22196', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8043', '26556', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8043', '28831', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8043', '28805', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8043', '28852', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8043', '26558', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8043', '26605', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8043', '30525', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8043', '28821', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8043', '28825', 1, 1, '2');  
INSERT INTO lootdrop_entries VALUES ('8043', '30528', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8043', '65288', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8043', '30531', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8043', '26594', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8043', '30529', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8043', '28838', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8043', '30526', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8043', '26603', 1, 1, '2');  
UPDATE npc_types SET loottable_id = 8043 WHERE (name LIKE '%High_Priest_of_Ssraeshza%');
# End Loot

# Begin Emperor_Ssraeshza Loot
INSERT INTO loottable VALUES ('8044', 'Emperor_Ssraeshza', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8044', '8044', '13', '100');
INSERT INTO lootdrop VALUES ('8044', 'Emperor_Ssraeshza');
INSERT INTO lootdrop_entries VALUES ('8044', '26585', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8044', '26749', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8044', '26599', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8044', '30569', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8044', '8359', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8044', '31226', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8044', '26604', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8044', '30566', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8044', '26564', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8044', '26587', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8044', '26584', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8044', '30570', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8044', '21809', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8044 WHERE (name LIKE '%Emperor_Ssraeshza%');
# End Loot

# Begin Defiler_Juzlix Loot
INSERT INTO loottable VALUES ('8045', 'Defiler_Juzlix', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8045', '8045', '2', '100');
INSERT INTO lootdrop VALUES ('8045', 'Defiler_Juzlix');
INSERT INTO lootdrop_entries VALUES ('8045', '8216', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8045', '8212', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8045 WHERE (name LIKE '%Defiler_Juzlix%');
# End Loot

# Begin Blood_of_Ssraeshza Loot
INSERT INTO loottable VALUES ('8046', 'Blood_of_Ssraeshza', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8046', '8046', '5', '100');
INSERT INTO lootdrop VALUES ('8046', 'Blood_of_Ssraeshza');
INSERT INTO lootdrop_entries VALUES ('8046', '26582', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8046', '26579', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8046', '26553', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8046', '26549', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8046', '26552', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8046 WHERE (name LIKE '%Blood_of_Ssraeshza%');
# End Loot

# Begin Arch_Lich_Rhag`Zadune Loot
INSERT INTO loottable VALUES ('8047', 'Arch_Lich_Rhag`Zadune', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8047', '8047', '19', '100');
INSERT INTO lootdrop VALUES ('8047', 'Arch_Lich_Rhag`Zadune');
INSERT INTO lootdrop_entries VALUES ('8047', '22196', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8047', '26590', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8047', '28850', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8047', '30524', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8047', '30548', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8047', '26581', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8047', '30535', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8047', '7826', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8047', '28830', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8047', '28833', 1, 1, '2');  
INSERT INTO lootdrop_entries VALUES ('8047', '30571', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8047', '30549', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8047', '30536', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8047', '26819', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8047', '26595', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8047', '28815', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8047', '26555', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8047', '28846', 1, 1, '2');  
INSERT INTO lootdrop_entries VALUES ('8047', '28804', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8047 WHERE (name LIKE '%Arch_Lich_Rhag`Zadune%');
# End Loot

# Begin Advisor_Zekuzh Loot
INSERT INTO loottable VALUES ('8048', 'Advisor_Zekuzh', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8048', '8048', '4', '100');
INSERT INTO lootdrop VALUES ('8048', 'Advisor_Zekuzh');
INSERT INTO lootdrop_entries VALUES ('8048', '10033', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8048', '10031', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8048', '10034', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8048', '19718', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8048 WHERE (name LIKE '%Advisor_Zekuzh%');
# End Loot

# Begin Commander_Zazuzh Loot
INSERT INTO loottable VALUES ('8049', 'Commander_Zazuzh', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8049', '8049', '4', '100');
INSERT INTO lootdrop VALUES ('8049', 'Commander_Zazuzh');
INSERT INTO lootdrop_entries VALUES ('8049', '21812', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8049', '21817', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8049', '21802', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8049', '21807', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8049', '19716', 1, 0, '42');
INSERT INTO lootdrop_entries VALUES ('8049', '19711', 1, 0, '42');  
UPDATE npc_types SET loottable_id = 8049 WHERE (name LIKE '%Commander_Zazuzh%');
# End Loot

# Begin Commander_Zherozsh Loot
INSERT INTO loottable VALUES ('8050', 'Commander_Zherozsh', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8050', '8050', '4', '100');
INSERT INTO lootdrop VALUES ('8050', 'Commander_Zherozsh');
INSERT INTO lootdrop_entries VALUES ('8050', '21817', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8050', '22915', 1, 0, '12');  
INSERT INTO lootdrop_entries VALUES ('8050', '21802', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8050', '19717', 1, 0, '42');  
INSERT INTO lootdrop_entries VALUES ('8050', '19710', 1, 0, '42');  
UPDATE npc_types SET loottable_id = 8050 WHERE (name LIKE '%Commander_Zherozsh%');
# End Loot

# Begin A_Glyphed_Covered_Serpent Loot
INSERT INTO loottable VALUES ('8051', 'A_Glyphed_Covered_Serpent', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8051', '8051', '11', '100');
INSERT INTO lootdrop VALUES ('8051', 'A_Glyphed_Covered_Serpent');
INSERT INTO lootdrop_entries VALUES ('8051', '22196', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8051', '30545', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8051', '7821', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8051', '30546', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8051', '30542', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8051', '28836', 1, 1, '2');  
INSERT INTO lootdrop_entries VALUES ('8051', '7820', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8051', '30544', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8051', '30547', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8051', '30543', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8051', '28809', 1, 1, '2');  
UPDATE npc_types SET loottable_id = 8051 WHERE (name LIKE '%A_Glyphed_Covered_Serpent%');
# End Loot

# Begin shissar_assassin Loot
INSERT INTO loottable VALUES ('8052', 'shissar_assassin', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8052', '8052', '5', '100');
INSERT INTO lootdrop VALUES ('8052', 'shissar_assassin');
INSERT INTO lootdrop_entries VALUES ('8052', '19702', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8052', '26502', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8052', '22915', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8052', '32529', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8052', '63166', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8052 WHERE (name LIKE '%shissar_assassin%');
# End Loot

# Begin disciple_yelwinz Loot
INSERT INTO loottable VALUES ('8053', 'disciple_yelwinz', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8053', '8053', '3', '100');
INSERT INTO lootdrop VALUES ('8053', 'disciple_yelwinz');
INSERT INTO lootdrop_entries VALUES ('8053', '65278', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8053', '8212', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8053', '8215', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8053 WHERE (name LIKE '%disciple_yelwinz%');
# End Loot
Code:
#PoN Loot

# Begin BLOOD_RAVEN Loot
INSERT INTO loottable VALUES ('8000', 'blood_raven', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8000', '8000', '3', '100');
INSERT INTO lootdrop VALUES ('8000', 'blood_raven');
INSERT INTO lootdrop_entries VALUES ('8000', '26681', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8000', '29750', 1, 1, '2'); 
INSERT INTO lootdrop_entries VALUES ('8000', '20895', 1, 1, '2'); 
INSERT INTO lootdrop_entries VALUES ('8000', '9587', 1, 1, '2'); 
INSERT INTO lootdrop_entries VALUES ('8000', '26683', 1, 1, '2'); 
INSERT INTO lootdrop_entries VALUES ('8000', '26682', 1, 1, '2'); 
UPDATE npc_types SET loottable_id = 8000 WHERE (name LIKE '%blood_raven%');
# End BLOOD_RAVEN Loot

# Begin BULLYRAG_BAT Loot
INSERT INTO loottable VALUES ('8001', 'bullyrag_bat', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8001', '8001', '1', '100');
INSERT INTO lootdrop VALUES ('8001', 'bullyrag_bat');
INSERT INTO lootdrop_entries VALUES ('8001', '11415', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8001', '11897', 1, 1, '2'); 
INSERT INTO lootdrop_entries VALUES ('8001', '29112', 1, 1, '2'); 
UPDATE npc_types SET loottable_id = 8001 WHERE (name LIKE '%bullyrag_bat%');
# End BULLYRAG_BAT Loot

# Begin CONSTRUCT_OF_NIGHTMARES Loot
INSERT INTO loottable VALUES ('8002', 'construct_of_nightmares', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8002', '8002', '3', '100');
INSERT INTO lootdrop VALUES ('8002', 'construct_of_nightmares');
INSERT INTO lootdrop_entries VALUES ('8002', '26039', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8002', '9258', 1, 1, '2'); 
INSERT INTO lootdrop_entries VALUES ('8002', '11423', 1, 1, '2'); 
INSERT INTO lootdrop_entries VALUES ('8002', '29112', 1, 1, '2'); 
INSERT INTO lootdrop_entries VALUES ('8002', '13633', 1, 1, '2'); 
INSERT INTO lootdrop_entries VALUES ('8002', '29131', 1, 1, '2'); 
INSERT INTO lootdrop_entries VALUES ('8002', '26615', 1, 1, '2'); 
UPDATE npc_types SET loottable_id = 8002 WHERE (name LIKE '%construct_of_nightmare%');
# End Loot

# Begin GLOOM_NIGHTMARE Loot
INSERT INTO loottable VALUES ('8003', 'gloom_nightmare', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8003', '8003', '1', '100');
INSERT INTO lootdrop VALUES ('8003', 'gloom_nightmare');
INSERT INTO lootdrop_entries VALUES ('8003', '29112', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8003', '28709', 1, 1, '2'); 
UPDATE npc_types SET loottable_id = 8003 WHERE (name LIKE '%gloom_nightmare%');
# End Loot

# Begin FEARSOME_HOBGOBLIN Loot
INSERT INTO loottable VALUES ('8004', 'fearsome_hobgoblin', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8004', '8004', '2', '100');
INSERT INTO lootdrop VALUES ('8004', 'fearsome_hobgoblin');
INSERT INTO lootdrop_entries VALUES ('8004', '11422', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8004', '9465', 1, 1, '2'); 
INSERT INTO lootdrop_entries VALUES ('8004', '29538', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8004', '26672', 1, 1, '2'); 
UPDATE npc_types SET loottable_id = 8004 WHERE (name LIKE '%gloom_nightmare%');
# End Loot

# Begin HOBGOBLIN Loot
INSERT INTO loottable VALUES ('8006', 'hobgoblin', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8006', '8006', '6', '100');
INSERT INTO lootdrop VALUES ('8006', 'hoboglin');
INSERT INTO lootdrop_entries VALUES ('8006', '9465', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8006', '22503', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8006', '29538', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8006', '10037', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8006', '29112', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8006', '26674', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8006', '29752', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8006', '26672', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8006', '26679', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8006', '10028', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8006', '15981', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8006', '15970', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8006', '26673', 1, 0, '2');
UPDATE npc_types SET loottable_id = 8006 WHERE (name LIKE '%hobgoblin%');
# End Loot

# Begin GNARLED_TREANT Loot
INSERT INTO loottable VALUES ('8007', 'gnarled_treant', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8007', '8007', '3', '100');
INSERT INTO lootdrop VALUES ('8007', 'gnarled_treant');
INSERT INTO lootdrop_entries VALUES ('8007', '26685', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8007', '26684', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8007', '12083', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8007', '30196', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8007', '29499', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8007', '26686', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8007 WHERE (name LIKE '%gnarled_treant%');
# End Loot

# Begin mephit Loot
INSERT INTO loottable VALUES ('8008', 'mephit', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8008', '8008', '2', '100');
INSERT INTO lootdrop VALUES ('8008', 'mephit');
INSERT INTO lootdrop_entries VALUES ('8008', '29112', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8008', '29744', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8008', '29228', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8008', '29525', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8008', '31597', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8008', '4238', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8008 WHERE (name LIKE 'a_mephit__');
UPDATE npc_types SET loottable_id = 8008 WHERE (name LIKE 'a_misery_mephit__');
UPDATE npc_types SET loottable_id = 8008 WHERE (name LIKE 'an_agony_mephit__');
# End Loot

# Begin ponightmare_spider Loot
INSERT INTO loottable VALUES ('8009', 'ponightmare_spider', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8009', '8009', '4', '50');
INSERT INTO lootdrop VALUES ('8009', 'ponightmare_spider');
INSERT INTO lootdrop_entries VALUES ('8009', '29985', 1, 0, '2');
UPDATE npc_types SET loottable_id = 8009 WHERE (name LIKE '%loathsome_creeper%');
UPDATE npc_types SET loottable_id = 8009 WHERE (name LIKE '%predatory_creeper%');
UPDATE npc_types SET loottable_id = 8009 WHERE (name LIKE '%rapacious_hatchling%');
# End Loot

# Begin nettling_wraith Loot
INSERT INTO loottable VALUES ('8010', 'nettling_wraith', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8010', '8010', '1', '100');
INSERT INTO lootdrop VALUES ('8010', 'nettling_wraith');
INSERT INTO lootdrop_entries VALUES ('8010', '29112', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8010', '29299', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8010 WHERE (name LIKE '%nettling_wraith%');
# End Loot

# Begin ponightmare_nightstalker Loot
INSERT INTO loottable VALUES ('8011', 'ponightmare_nightstalker', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8011', '8011', '1', '60');
INSERT INTO lootdrop VALUES ('8011', 'ponightmare_nightstalker');
INSERT INTO lootdrop_entries VALUES ('8011', '27640', 1, 0, '2');
UPDATE npc_types SET loottable_id = 8011 WHERE (name LIKE '%nightstalker%');
# End Loot

# Begin ravenous_nightstalker Loot
INSERT INTO loottable VALUES ('8012', 'ravenous_nightstalker', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8012', '8012', '3', '100');
INSERT INTO lootdrop VALUES ('8012', 'ravenous_nightstalker');
INSERT INTO lootdrop_entries VALUES ('8012', '26664', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8012', '20895', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8012', '26663', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8012', '26665', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8012', '9587', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8012', '26679', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8012 WHERE (name LIKE '%ravenous_nightstalker%');
# End Loot

# Begin slarghilug Loot
INSERT INTO loottable VALUES ('8013', 'slarghilug', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8013', '8013', '4', '100');
INSERT INTO lootdrop VALUES ('8013', 'slarghilug');
INSERT INTO lootdrop_entries VALUES ('8013', '29112', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8013', '29527', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8013', '7017', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8013', '28786', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8013', '26656', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8013', '24577', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8013', '26654', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8013', '26655', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8013 WHERE (name LIKE '%slarghilug%');
# End Loot

# Begin tar`dak_hunter Loot
INSERT INTO loottable VALUES ('8014', 'tar`dak_hunter', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8014', '8014', '2', '100');
INSERT INTO lootdrop VALUES ('8014', 'tar`dak_hunter');
INSERT INTO lootdrop_entries VALUES ('8014', '26659', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8014', '26658', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8014', '29112', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8014', '26657', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8014', '9319', 1, 0, '2');
UPDATE npc_types SET loottable_id = 8014 WHERE (name LIKE '%tar`dak_hunter%');
# End Loot

# Begin ponightmare_bat Loot
INSERT INTO loottable VALUES ('8015', 'ponightmare_bat', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8015', '8015', '1', '60');
INSERT INTO lootdrop VALUES ('8015', 'ponightmare_bat');
INSERT INTO lootdrop_entries VALUES ('8015', '26670', 1, 0, '2');
UPDATE npc_types SET loottable_id = 8015 WHERE (name LIKE '%terror_bat%');
UPDATE npc_types SET loottable_id = 8015 WHERE (name LIKE '%torment_bat%');
UPDATE npc_types SET loottable_id = 8015 WHERE (name LIKE '%tremulous_bat%');
# End Loot

# Begin ponightmare_banshee Loot
INSERT INTO loottable VALUES ('8016', 'ponightmare_banshee', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8016', '8016', '3', '100');
INSERT INTO lootdrop VALUES ('8016', 'ponightmare_banshee');
INSERT INTO lootdrop_entries VALUES ('8016', '24084', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8016', '29112', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8016', '26660', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8016', '26661', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8016', '28710', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8016', '26662', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8016 WHERE (name LIKE '%vexed_banshee%');
UPDATE npc_types SET loottable_id = 8016 WHERE (name LIKE '%ethereal_banshee%');
UPDATE npc_types SET loottable_id = 8016 WHERE (name LIKE '%wailing_banshee%');
# End Loot

# Begin virulent_arachnid Loot
INSERT INTO loottable VALUES ('8017', 'virulent_arachnid', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8017', '8017', '2', '100');
INSERT INTO lootdrop VALUES ('8017', 'virulent_arachnid');
INSERT INTO lootdrop_entries VALUES ('8017', '28282', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8017', '26653', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8017', '26652', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8017', '26651', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8017 WHERE (name LIKE '%virulent_arachnid%');
# End Loot

# Begin infernal_consort Loot
INSERT INTO loottable VALUES ('8018', 'infernal_consort', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8018', '8018', '2', '100');
INSERT INTO lootdrop VALUES ('8018', 'infernal_consort');
INSERT INTO lootdrop_entries VALUES ('8018', '19145', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8018', '16157', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8018', '14048', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8018', '29131', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8018 WHERE (name LIKE '%infernal_consort%');
# End Loot

# Begin deyid_the_twisted Loot
INSERT INTO loottable VALUES ('8019', 'deyid_the_twisted', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8019', '8019', '4', '100');
INSERT INTO lootdrop VALUES ('8019', 'deyid_the_twisted');
INSERT INTO lootdrop_entries VALUES ('8019', '7138', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8019', '21868', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8019', '25222', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8019', '29131', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8019 WHERE (name LIKE '%deyid_the_twisted%');
# End Loot

# Begin hobgoblin_anguish_lord Loot
INSERT INTO loottable VALUES ('8020', 'hobgoblin_anguish_lord', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8020', '8020', '4', '100');
INSERT INTO lootdrop VALUES ('8020', 'hobgoblin_anguish_lord');
INSERT INTO lootdrop_entries VALUES ('8020', '25991', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8020', '24593', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8020', '19147', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8020', '22991', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8020 WHERE (name LIKE '%hobgoblin_anguish_lord%');
# End Loot

# Begin mujaki_the_devourer Loot
INSERT INTO loottable VALUES ('8021', 'mujaki_the_devourer', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8021', '8021', '5', '100');
INSERT INTO lootdrop VALUES ('8021', 'mujaki_the_devourer');
INSERT INTO lootdrop_entries VALUES ('8021', '15845', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8021', '5742', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8021', '15830', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8021', '32546', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8021', '27700', 1, 0, '2');
UPDATE npc_types SET loottable_id = 8021 WHERE (name LIKE '%mujaki_the_devourer%');
# End Loot

# Begin terror_matriarch Loot
INSERT INTO loottable VALUES ('8022', 'terror_matriarch', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8022', '8022', '4', '100');
INSERT INTO lootdrop VALUES ('8022', 'terror_matriarch');
INSERT INTO lootdrop_entries VALUES ('8022', '11329', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8022', '6470', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8022', '7138', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8022', '29298', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8022 WHERE (name LIKE '%terror_matriarch%');
# End Loot

# Begin untel`dak Loot
INSERT INTO loottable VALUES ('8023', 'untel`dak', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8023', '8023', '4', '100');
INSERT INTO lootdrop VALUES ('8023', 'untel`dak');
INSERT INTO lootdrop_entries VALUES ('8023', '22964', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8023', '29112', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8023', '14924', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8023', '20519', 1, 0, '2');  
UPDATE npc_types SET loottable_id = 8023 WHERE (name LIKE '%untel`dak%');
# End Loot

# Begin vhaksiz_the_shade Loot
INSERT INTO loottable VALUES ('8024', 'vhaksiz_the_shade', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8024', '8024', '7', '100');
INSERT INTO lootdrop VALUES ('8024', 'vhaksiz_the_shade');
INSERT INTO lootdrop_entries VALUES ('8024', '16663', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8024', '22983', 1, 0, '2');  
INSERT INTO lootdrop_entries VALUES ('8024', '29112', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8024', '11032', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8024', '28801', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8024', '13687', 1, 0, '2');
INSERT INTO lootdrop_entries VALUES ('8024', '29131', 1, 0, '2');
UPDATE npc_types SET loottable_id = 8024 WHERE (name LIKE '%vhaksiz_the_shade%');
# End Loot

# Begin ponightmare_wraith Loot
INSERT INTO loottable VALUES ('8025', 'ponightmare_wraith', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8025', '8025', '1', '60');
INSERT INTO lootdrop VALUES ('8025', 'ponightmare_wraith');
INSERT INTO lootdrop_entries VALUES ('8025', '26680', 1, 0, '2');
UPDATE npc_types SET loottable_id = 8025 WHERE (name LIKE '%wraith__') AND level>50;
# End Loot

# Begin FIENDISH_CONSORT Loot
INSERT INTO loottable VALUES ('8005', 'fiendish_consort', 0, 0, 0);
INSERT INTO loottable_entries VALUES ('8005', '8005', '2', '80');
INSERT INTO lootdrop VALUES ('8005', 'fiendish_consort');
INSERT INTO lootdrop_entries VALUES ('8005', '16157', 1, 1, '2');
INSERT INTO lootdrop_entries VALUES ('8005', '14048', 1, 1, '2');  
UPDATE npc_types SET loottable_id = 8005 WHERE (name LIKE '%fiendish_consort%');
# End Loot
Bon Apetite!
Reply With Quote
  #2  
Old 03-04-2004, 07:22 PM
Monrezz's Avatar
Monrezz
Dragon
  
Join Date: Mar 2003
Location: #loc
Posts: 745
Default
Wow, thanks for this. I'm sure it will be merged into MW. Keep them coming, it would be great to have loot drop off the boss mobs
__________________

kRPG Profile
Reply With Quote
  #3  
Old 03-13-2004, 06:24 PM
Jezebell
Discordant
  
Join Date: Feb 2004
Location: Florida
Posts: 441
Default
Whats the easiest way to source this into the database?
__________________
Eru, the Creator of Arda
ServerOwner for The First Age
An EQEMulator Roleplaying [Custom-Legit] Server
The First Age Website
Running on: Asus A7N8X-Deluxe, AMD Athlon XP 2100+, Geil 1024MB PC3200 Ultra DDR RAM,
WD 40GB 7200rpm ATA-100 HDD, Visiontek 128MB Geforce4 TI 4400, Windows XP Pro SP2
Reply With Quote
  #4  
Old 03-13-2004, 07:43 PM
Shadow-Wolf
Dragon
  
Join Date: Oct 2003
Posts: 511
Default
easy copy n paste the stuff into notepad save it as loot.sql in your mysql\bin folder and open the mysql console
then type in the following:
use eqemu(orwhatever your db is named);
source loot.sql;
and there ya go.
Reply With Quote
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

   

All times are GMT -4. The time now is 07:54 PM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3