diff options
| author | Nay <dnpd.dd@gmail.com> | 2011-10-22 13:18:17 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-10-22 13:18:17 +0100 |
| commit | 362b528bbbec2a41604bc67af773d667a2c5044f (patch) | |
| tree | f2137903f3890c66a291d4dc4f028647f0248a6e /sql | |
| parent | e5c0be0a29e13f9ee519c353a56ef8c785f063c5 (diff) | |
Scripts/Quests: Fix quest What Do You Feed a Yeti, Anyway? (14112,14145)
Closes #2975
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2011_10_22_05_world_misc.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/world/2011_10_22_05_world_misc.sql b/sql/updates/world/2011_10_22_05_world_misc.sql new file mode 100644 index 00000000000..57e4f740530 --- /dev/null +++ b/sql/updates/world/2011_10_22_05_world_misc.sql @@ -0,0 +1,14 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_q14112_14145_chum_the_water'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(66741,'spell_q14112_14145_chum_the_water'); + +-- Template updates for creature 35071 (North Sea Mako) +UPDATE `creature_template` SET `faction_A`=14,`faction_H`=14,`baseattacktime`=2000,`InhabitType`=`InhabitType`&~1 WHERE `entry` IN (35071,35060,35061); -- North Sea * (Last 2 entries guessed) +UPDATE `creature_template` SET `faction_A`=1885,`faction_H`=1885,`baseattacktime`=2000 WHERE `entry`=35072; -- Angry Kvaldir +-- Addon data for creature 35071 (North Sea Mako) +DELETE FROM `creature_template_addon` WHERE `entry` IN (35071,35072,35060,35061); +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(35071,0,0,1,0, NULL), -- North Sea Mako +(35060,0,0,1,0, NULL), -- North Sea Thresher - guessed +(35061,0,0,1,0, NULL), -- North Sea Blue Shark - guessed +(35072,0,0,1,0, NULL); -- Angry Kvaldir |