- 188
- 2017
- 13
- Location
- PA, USA
Some DBError log clean up and assigned the proper equipment to the creatures while I was at it.
Code:
-- --------------------------------------------------------------------------------------------------------------------
-- Repack version: 7.0.2
-- DBError.log Clean-up
-- Assign proper equipment
-- --------------------------------------------------------------------------------------------------------------------
-- Captured Mercenary Captain
UPDATE `creature_template` SET `equipment_id` = 32908 WHERE `entry` = 32908;
UPDATE `creature_equip_template` SET `itemEntry1` = 21573, `itemEntry2` = 21572 WHERE `entry` = 32908;
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 32908;
-- Apothecary Frye <Crown Chemical Co.>
UPDATE `creature_template` SET `equipment_id` = 36272 WHERE `entry` = 36272;
UPDATE `creature_equip_template` SET `itemEntry1` = 2198, `itemEntry2` = 2200 WHERE `entry` = 32908;
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 36272;
-- Loramus Thalipedes
UPDATE `creature_template` SET `equipment_id` = 41279 WHERE `entry` = 41279;
REPLACE INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) VALUES (41279, 1, 12482, 12482, 0);
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 41279;
-- Twilight Convert
UPDATE `creature_template` SET `equipment_id` = 42154 WHERE `entry` = 42154;
REPLACE INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) VALUES (42154, 1, 52517, 0, 0);
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 42154;
-- Skyshredder Crewmember
UPDATE `creature_template` SET `equipment_id` = 49006 WHERE `entry` = 49006;
REPLACE INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) VALUES (49006, 1, 31824, 0, 0);
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 49006;
-- Bilgewater Gunman <Bilgewater Battalion>
UPDATE `creature_template` SET `equipment_id` = 49009 WHERE `entry` = 49009;
REPLACE INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) VALUES (49009, 1, 49672, 0, 47568);
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 49009;
-- Doomguard Annihilator
UPDATE `creature_template` SET `equipment_id` = 55519 WHERE `entry` = 55519;
REPLACE INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) VALUES (55519, 1, 34876, 0, 0);
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 55519;
-- Doomguard Devastator
UPDATE `creature_template` SET `equipment_id` = 55739 WHERE `entry` = 55739;
REPLACE INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) VALUES (55739, 1, 32743, 32743, 0);
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` = 55739;
)