- 188
- 2017
- 13
- Location
- PA, USA
More assigned equipment fixes while cleaning up DBError log messages.
Code:
-- --------------------------------------------------------------------------------------------------------------------
-- Repack version: 7.0.2
-- DBError.log Clean-up
-- Assign proper equipment for the following NPC's
-- Hellscream Seadog, Kagtha, Miss Mayhem, Slinky Sharpshiv, Kobold Digger, Defias Blood Wizard
-- Defias Envoker, Defias Miner, Defias Digger, Goblin Engineer, Oaf Lackey, Defias Enforcer
-- Defias Shadowguard, Defias Squallshaper, Defias Pirate, Bilgewater Gunman
-- --------------------------------------------------------------------------------------------------------------------
REPLACE INTO `creature_equip_template` (`entry`, `id`, `itemEntry1`, `itemEntry2`, `itemEntry3`) VALUES
(42115, 1, 42507, 0, 42507),
(46889, 1, 10611, 10612, 0),
(46902, 1, 62229, 0, 0),
(46906, 1, 10616, 10616, 0),
(48229, 1, 1910, 0, 0),
(48417, 1, 35220, 0, 0),
(48418, 1, 29432, 0, 0),
(48419, 1, 0, 1910, 0),
(48420, 1, 0, 1910, 0),
(48439, 1, 1911, 0, 2552),
(48445, 1, 10612, 0, 0),
(48502, 1, 56172, 0, 0),
(48505, 1, 5281, 0, 0),
(48521, 1, 32610, 0, 0),
(48522, 1, 1897, 0, 0),
(49009, 1, 49672, 0, 47568);
UPDATE `creature_template` SET `equipment_id` = 42115 WHERE `entry` = 42115;
UPDATE `creature_template` SET `equipment_id` = 46889 WHERE `entry` = 46889;
UPDATE `creature_template` SET `equipment_id` = 46902 WHERE `entry` = 46902;
UPDATE `creature_template` SET `equipment_id` = 46906 WHERE `entry` = 46906;
UPDATE `creature_template` SET `equipment_id` = 48229 WHERE `entry` = 48229;
UPDATE `creature_template` SET `equipment_id` = 48417 WHERE `entry` = 48417;
UPDATE `creature_template` SET `equipment_id` = 48418 WHERE `entry` = 48418;
UPDATE `creature_template` SET `equipment_id` = 48419 WHERE `entry` = 48419;
UPDATE `creature_template` SET `equipment_id` = 48420 WHERE `entry` = 48420;
UPDATE `creature_template` SET `equipment_id` = 48439 WHERE `entry` = 48439;
UPDATE `creature_template` SET `equipment_id` = 48445 WHERE `entry` = 48445;
UPDATE `creature_template` SET `equipment_id` = 48502 WHERE `entry` = 48502;
UPDATE `creature_template` SET `equipment_id` = 48505 WHERE `entry` = 48505;
UPDATE `creature_template` SET `equipment_id` = 48521 WHERE `entry` = 48521;
UPDATE `creature_template` SET `equipment_id` = 48522 WHERE `entry` = 48522;
UPDATE `creature_template` SET `equipment_id` = 49009 WHERE `entry` = 49009;
UPDATE `creature` SET `equipment_id` = 0 WHERE `id` IN (42115, 46889, 46902, 46906, 48229, 48417, 48418, 48419, 48420, 48439, 48445, 48502, 48505, 48521, 48522, 49009);