[hide="Applied, though done differently"]To turn them in the Christmas model, use this one.
Code: Select all
-- Christmas Models
-- Vanilla
UPDATE `creature_template` SET `modelid1` = 15732 WHERE `entry` = 1853; -- Darkmaster Gandling (Green)
UPDATE `creature_template` SET `modelid1` = 15733 WHERE `entry` = 10997; -- Cannon Master Willey (Red)
UPDATE `creature_template` SET `modelid1` = 15734 WHERE `entry` = 11486; -- Prince Tortheldrin (Green)
UPDATE `creature_template` SET `modelid1` = 15735 WHERE `entry` = 9019; -- Emperor Dagrand Thaurissan (Red)
UPDATE `creature_template` SET `modelid1` = 15736 WHERE `entry` = 10429; -- Warchief Rend Blackhand
UPDATE `creature_template` SET `modelid1` = 15760 WHERE `entry` = 10899; -- Goraluk Anvilcrack
-- TBC
UPDATE `creature_template` SET `modelid1` = 22800 WHERE `entry` IN (16807, 20568); -- Grand Warlock Netherkurse (Green)
UPDATE `creature_template` SET `modelid1` = 22801 WHERE `entry` IN (18732, 20653); -- Grandmaster Vorpil (Green)
UPDATE `creature_template` SET `modelid1` = 22802 WHERE `entry` IN (18373, 20306); -- Exarch Maladaar (Green)
UPDATE `creature_template` SET `modelid1` = 22803 WHERE `entry` IN (17862, 20521); -- Captain Skarloc (Red)
UPDATE `creature_template` SET `modelid1` = 22804 WHERE `entry` IN (19221, 21536); -- Nethermancer Sepethrea (Red)
UPDATE `creature_template` SET `modelid1` = 22805 WHERE `entry` IN (17975, 21558); -- High Botanist Frewyinn (Red)
Code: Select all
-- Normal Models
-- Vanilla
UPDATE `creature_template` SET `modelid1` = 11070 WHERE `entry` = 1853; -- Darkmaster Gandling (Green)
UPDATE `creature_template` SET `modelid1` = 10674 WHERE `entry` = 10997; -- Cannon Master Willey (Red)
UPDATE `creature_template` SET `modelid1` = 11256 WHERE `entry` = 11486; -- Prince Tortheldrin (Green)
UPDATE `creature_template` SET `modelid1` = 8807 WHERE `entry` = 9019; -- Emperor Dagrand Thaurissan (Red)
UPDATE `creature_template` SET `modelid1` = 9778 WHERE `entry` = 10429; -- Warchief Rend Blackhand
UPDATE `creature_template` SET `modelid1` = 10222 WHERE `entry` = 10899; -- Goraluk Anvilcrack
-- TBC
UPDATE `creature_template` SET `modelid1` = 16628 WHERE `entry` IN (16807, 20568); -- Grand Warlock Netherkurse (Green)
UPDATE `creature_template` SET `modelid1` = 18535 WHERE `entry` IN (18732, 20653); -- Grandmaster Vorpil (Green)
UPDATE `creature_template` SET `modelid1` = 17715 WHERE `entry` IN (18373, 20306); -- Exarch Maladaar (Green)
UPDATE `creature_template` SET `modelid1` = 17387 WHERE `entry` IN (17862, 20521); -- Captain Skarloc (Red)
UPDATE `creature_template` SET `modelid1` = 19166 WHERE `entry` IN (19221, 21536); -- Nethermancer Sepethrea (Red)
UPDATE `creature_template` SET `modelid1` = 19045 WHERE `entry` IN (17975, 21558); -- High Botanist Frewyinn (Red)
Code: Select all
-- Vanilla Loot
DELETE FROM `creature_loot_template` WHERE `Entry` IN(9019, 10997) AND `Item` = 21524;
DELETE FROM `creature_loot_template` WHERE `Entry` IN(1853, 11486) AND `Item` = 21525;
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(9019, 21524, 0, 100, 0, 1, 0, 1, 1, "Red Winter Hat"),
(10997, 21524, 0, 100, 0, 1, 0, 1, 1, "Red Winter Hat"),
(1853, 21525, 0, 100, 0, 1, 0, 1, 1, "Green Winter Hat"),
(11486, 21525, 0, 100, 0, 1, 0, 1, 1, "Green Winter Hat");
Code: Select all
-- TBC Loot
DELETE FROM `creature_loot_template` WHERE `Entry` IN(17862, 20521, 19221, 21536, 17975, 21558) AND `Item` = 21524;
DELETE FROM `creature_loot_template` WHERE `Entry` IN(16807, 20568, 18732, 20653, 18373, 20306) AND `Item` = 21525;
INSERT INTO `creature_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES
(17862, 21524, 0, 100, 0, 1, 0, 1, 1, "Red Winter Hat"),
(20521, 21524, 0, 100, 0, 1, 0, 1, 1, "Red Winter Hat"),
(19221, 21524, 0, 100, 0, 1, 0, 1, 1, "Red Winter Hat"),
(21536, 21524, 0, 100, 0, 1, 0, 1, 1, "Red Winter Hat"),
(17975, 21524, 0, 100, 0, 1, 0, 1, 1, "Red Winter Hat"),
(21558, 21524, 0, 100, 0, 1, 0, 1, 1, "Red Winter Hat"),
(16807, 21525, 0, 100, 0, 1, 0, 1, 1, "Green Winter Hat"),
(20568, 21525, 0, 100, 0, 1, 0, 1, 1, "Green Winter Hat"),
(18732, 21525, 0, 100, 0, 1, 0, 1, 1, "Green Winter Hat"),
(20653, 21525, 0, 100, 0, 1, 0, 1, 1, "Green Winter Hat"),
(18373, 21525, 0, 100, 0, 1, 0, 1, 1, "Green Winter Hat"),
(20306, 21525, 0, 100, 0, 1, 0, 1, 1, "Green Winter Hat");
Code: Select all
-- Remove all the Christmas Hats from Vanilla and TBC npcs
DELETE FROM `creature_loot_template` WHERE `Entry` IN(9019, 10997, 17862, 20521, 19221, 21536, 17975) AND `Item` = 21524;
DELETE FROM `creature_loot_template` WHERE `Entry` IN(1853, 11486, 16807, 20568, 18732, 20653, 18373, 20306) AND `Item` = 21525;