[Accepted] [PW] Red/Green Winter Hat from level 60 dungeons + Christmas Models

User avatar
Gnurg
Posts: 2420
Joined: 28 Jan 2013 19:38
Location: Oslo, Norway

[Accepted] [PW] Red/Green Winter Hat from level 60 dungeons + Christmas Models

#1 » Post by Gnurg » 15 Dec 2016 11:31

Could we for this Winter Veil make the Red and Green Winter Hat drop from the bosses, which has a Christmas model? After the event, we can remove them as we'd go TBC by next Winter Veil and maybe then we can move the hats to some of the level 70 bosses?

[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)
When turning them back, just use this one.

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)
[/hide]

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;
Last edited by Gnurg on 20 Dec 2016 23:14, edited 6 times in total.
HAI
CAN HAZ STDIO?
VISIBLE "HAI WORLD, IZ GNURF!"
KTHXBYE

User avatar
Skembic

Re: [PW] Red/Green Winter Hat from level 60 dungeons

#2 » Post by Skembic » 15 Dec 2016 12:03

Why do you want those hats anyway?

User avatar
Gnurg
Posts: 2420
Joined: 28 Jan 2013 19:38
Location: Oslo, Norway

Re: [PW] Red/Green Winter Hat from level 60 dungeons

#3 » Post by Gnurg » 15 Dec 2016 12:13

Skembic wrote:Why do you want those hats anyway?
For the Christmas spirit \o/
HAI
CAN HAZ STDIO?
VISIBLE "HAI WORLD, IZ GNURF!"
KTHXBYE

User avatar
Gnurg
Posts: 2420
Joined: 28 Jan 2013 19:38
Location: Oslo, Norway

Re: [PW] Red/Green Winter Hat from level 60 dungeons

#4 » Post by Gnurg » 15 Dec 2016 12:55

Actually there exists a Christmas skin for some of the bosses. Having the ones with the skin drop the item might be a better idea.

Image
HAI
CAN HAZ STDIO?
VISIBLE "HAI WORLD, IZ GNURF!"
KTHXBYE

User avatar
hjason3
Donor
Posts: 61
Joined: 11 Sep 2012 16:36
Location: USA

Re: [PW] Red/Green Winter Hat from level 60 dungeons

#5 » Post by hjason3 » 15 Dec 2016 13:00

Thats a cool idea

User avatar
Gnurg
Posts: 2420
Joined: 28 Jan 2013 19:38
Location: Oslo, Norway

Re: [PW] Red/Green Winter Hat from level 60 dungeons

#6 » Post by Gnurg » 15 Dec 2016 13:32

Updated the first post with Christmas models, and Vanilla and TBC loot.
HAI
CAN HAZ STDIO?
VISIBLE "HAI WORLD, IZ GNURF!"
KTHXBYE

User avatar
Flooded
Former Staff
Posts: 779
Joined: 23 Apr 2016 19:29

Re: [PW] Red/Green Winter Hat from level 60 dungeons

#7 » Post by Flooded » 15 Dec 2016 13:36

+1 - pls gief holiday spirit

User avatar
Nyeriah

Re: [PW] Red/Green Winter Hat from level 60 dungeons + Christmas Models

#8 » Post by Nyeriah » 15 Dec 2016 14:23

I guess it has nothing to do with the achievements

User avatar
Gnurg
Posts: 2420
Joined: 28 Jan 2013 19:38
Location: Oslo, Norway

Re: [PW] Red/Green Winter Hat from level 60 dungeons + Christmas Models

#9 » Post by Gnurg » 15 Dec 2016 15:38

Nyeriah wrote:I guess it has nothing to do with the achievements
The hat is part of one achievement, but it wouldn't be enough to give the Winter Veil title. You could always disable http://www.wowhead.com/achievement=277/tis-the-season until WotLK, I just want a Christmas outfit. ^_^
HAI
CAN HAZ STDIO?
VISIBLE "HAI WORLD, IZ GNURF!"
KTHXBYE

User avatar
Gnurg
Posts: 2420
Joined: 28 Jan 2013 19:38
Location: Oslo, Norway

Re: [PW] Red/Green Winter Hat from level 60 dungeons + Christmas Models

#10 » Post by Gnurg » 15 Dec 2016 23:43

I'll add the models, but is there no interest in the Winter Hats?
HAI
CAN HAZ STDIO?
VISIBLE "HAI WORLD, IZ GNURF!"
KTHXBYE

User avatar
hjason3
Donor
Posts: 61
Joined: 11 Sep 2012 16:36
Location: USA

Re: [PW] Red/Green Winter Hat from level 60 dungeons + Christmas Models

#11 » Post by hjason3 » 15 Dec 2016 23:57

I like the Christmas hats better than the outfits really

User avatar
Gnurg
Posts: 2420
Joined: 28 Jan 2013 19:38
Location: Oslo, Norway

Re: [PW] Red/Green Winter Hat from level 60 dungeons + Christmas Models

#12 » Post by Gnurg » 16 Dec 2016 13:40

Seeing as there is little to no interest in Winter Hats, I guess we'll reject this. Christmas boss models will be added though. :-)
HAI
CAN HAZ STDIO?
VISIBLE "HAI WORLD, IZ GNURF!"
KTHXBYE

User avatar
VanillaPVE
Posts: 42
Joined: 31 Aug 2015 06:17

Re: [PW] Red/Green Winter Hat from level 60 dungeons + Christmas Models

#13 » Post by VanillaPVE » 16 Dec 2016 16:31

+1 Here I would love to see the Christmas hats drop.

User avatar
lrctgl
Donor
Posts: 82
Joined: 19 Jan 2016 18:02

Re: [PW] Red/Green Winter Hat from level 60 dungeons + Christmas Models

#14 » Post by lrctgl » 16 Dec 2016 16:37

id like to see the winter hats aswell +1

User avatar
Sethicus7

Re: [PW] Red/Green Winter Hat from level 60 dungeons + Christmas Models

#15 » Post by Sethicus7 » 18 Dec 2016 14:50

I would like to have winter hats

Locked

Who is online

Users browsing this forum: No registered users and 3 guests