View Single Post
  #5  
Old 01-02-2014, 01:59 AM
haggzor
Fire Beetle
 
Join Date: Nov 2010
Location: Cincinnati, OH
Posts: 27
Default

This isn't a perfect fix, but I'm too lazy to write all new loot tables. This query will update *most* of the NPCs in Innothule (Classic, pre-revamp) to spawn with the loot tables (MAGELO-GEN) from their equivalents in InnothuleB (revamped Innothule). From there you can pick and choose individual items from the tables, but this covers most of it.

Code:
/* UPDATE LOOT TABLE FOR SKELETONS (was 87917) */

update  npc_types
set     loottable_id = 93161
where   id = 46008;

/* UPDATE LOOT TABLE FOR FROGLOKS (was 0) */

update  npc_types
set     loottable_id = 93162
where   id = 46015;

/* UPDATE LOOT TABLE FOR FROGLOK FISHERMAN (was 120) */

update  npc_types
set     loottable_id = 93163
where   id = 46012;

/* UPDATE LOOT TABLE FOR FROGLOK FORAGER (was 128) */

update  npc_types
set     loottable_id = 93164
where   id = 46013;

/* UPDATE LOOT TABLE FOR FROGLOK GUARD (was 116) */

update  npc_types
set     loottable_id = 93165
where   id = 65031;

/* UPDATE LOOT TABLE FOR FROGLOK TAD (was 108) */

update  npc_types
set     loottable_id = 93166
where   id = 46014;

/* UPDATE LOOT TABLE FOR FUNGUS MAN TRACKER (was 87909) */

update  npc_types
set     loottable_id = 93182
where   id = 46016;

/* UPDATE LOOT TABLE FOR FUNGUS SPORE (was 4880) */

update  npc_types
set     loottable_id = 93167
where   id = 46017;

/* UPDATE LOOT TABLE FOR KOBOLD HUNTER (was 5556) */

update  npc_types
set     loottable_id = 93169
where   id = 46024;

/* UPDATE LOOT TABLE FOR LESSER KOBOLD (was 5555) */

update  npc_types
set     loottable_id = 93171
where   id = 46026;

/* UPDATE LOOT TABLE FOR SWAMP ALLIGATOR (was 5635) */

update  npc_types
set     loottable_id = 93173
where   id = 46037;

/* UPDATE LOOT TABLE FOR WATER MOCASSIN (was 3624) */

update  npc_types
set     loottable_id = 93175
where   id = 46041;

/* UPDATE LOOT TABLE FOR DARK DEATHSINGER (was 0) */

update  npc_types
set     loottable_id = 93181
where   id = 46007;

/* UPDATE LOOT TABLE FOR GIANT WATER MOCASSIN (was 0) */

update  npc_types
set     loottable_id = 93183
where   id = 46019;
__________________
... and I just got killed by Gix... again.
Reply With Quote