diff options
| author | Helias <stefanoborzi32@gmail.com> | 2015-09-10 18:18:17 +0200 |
|---|---|---|
| committer | MitchesD <majklprofik@seznam.cz> | 2015-09-10 18:18:44 +0200 |
| commit | b194595c07762e0be0475b7e9f86be9de6f76a06 (patch) | |
| tree | e8fd9f01627ff3d6c22b443c2cecf3f4d7c6e5a2 | |
| parent | 056d7f8e5d2e3ca057eedbb8ebea8f8e3d95d436 (diff) | |
DB/Misc: added missing creature queststarter and questender in "Maelstrom"
Closes https://github.com/TrinityCore/TrinityCore/issues/15450
| -rw-r--r-- | sql/updates/world/2015_09_10_00_world.sql | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/sql/updates/world/2015_09_10_00_world.sql b/sql/updates/world/2015_09_10_00_world.sql new file mode 100644 index 00000000000..bd613a8c096 --- /dev/null +++ b/sql/updates/world/2015_09_10_00_world.sql @@ -0,0 +1,36 @@ +-- Darkmoon Island (5) +UPDATE `creature_template` SET `npcflag` = `npcflag`|2 WHERE `entry` = 90473; + +DELETE FROM `creature_queststarter` WHERE `id` IN (67370, 74056, 85519, 85546, 90473); +DELETE FROM `creature_questender` WHERE `id` IN (67370, 74056, 85519, 85546, 90473); + +INSERT INTO `creature_queststarter` VALUES +(67370, 32175), -- Jeremy Feasel, Darkmoon Pet Battle! +(74056, 33756), -- Malle Earnhard, Let's Keep Racing! +(74056, 37910), -- Malle Earnhard, The Real Race +(74056, 37819), -- Malle Earnhard, Welcome to the Darkmoon Races +(85519, 36471), -- Christoph VonFeasel, A New Darkmoon Challenger! +(85546, 36481), -- Ziggie Sparks, Firebird's Challenge +(90473, 37868), -- Patti Earnhard, More Big Racing! +(90473, 37911); -- Patti Earnhard, The Real Big Race + +INSERT INTO `creature_questender` VALUES +(67370, 32175), -- Jeremy Feasel, Darkmoon Pet Battle! +(74056, 33756), -- Malle Earnhard, Let's Keep Racing! +(74056, 37910), -- Malle Earnhard, The Real Race +(74056, 37819), -- Malle Earnhard, Welcome to the Darkmoon Races +(85519, 36471), -- Christoph VonFeasel, A New Darkmoon Challenger! +(85546, 36481), -- Ziggie Sparks, Firebird's Challenge +(90473, 37868), -- Patti Earnhard, More Big Racing! +(90473, 37911); -- Patti Earnhard, The Real Big Race + + +-- Depholm (1) +DELETE FROM `creature_queststarter` WHERE `id` IN (66815); +DELETE FROM `creature_questender` WHERE `id` IN (66815); + +INSERT INTO `creature_queststarter` VALUES +(66815, 31973); -- Bordin Steadyfist, Bordin Steadyfist + +INSERT INTO `creature_questender` VALUES +(66815, 31973); -- Bordin Steadyfist, Bordin Steadyfist |