{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15450","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15450/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15450/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15450/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/15450","id":105101082,"number":15450,"title":"[6.x] Fix missing creature queststarter and questender in \"Maelstrom\"","user":{"login":"Helias","id":519778,"avatar_url":"https://avatars.githubusercontent.com/u/519778?v=3","gravatar_id":"","url":"https://api.github.com/users/Helias","html_url":"https://github.com/Helias","followers_url":"https://api.github.com/users/Helias/followers","following_url":"https://api.github.com/users/Helias/following{/other_user}","gists_url":"https://api.github.com/users/Helias/gists{/gist_id}","starred_url":"https://api.github.com/users/Helias/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Helias/subscriptions","organizations_url":"https://api.github.com/users/Helias/orgs","repos_url":"https://api.github.com/users/Helias/repos","events_url":"https://api.github.com/users/Helias/events{/privacy}","received_events_url":"https://api.github.com/users/Helias/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-09-06T15:52:55Z","updated_at":"2015-09-06T19:16:09Z","closed_at":null,"body":"DB rev: 6.02\r\nCore rev: https://github.com/TrinityCore/TrinityCore/commit/344c32c1239305d0c335f96c08dc4597d66e8c29\r\n\r\nThe Maelstrom NPCs that start or end quests.\r\n\r\n(Only 3 zones remains with missing queststarter/ender)\r\n\r\n```SQL\r\n-- Darkmoon Island (5)\r\nUPDATE `creature_template` SET `npcflag` = `npcflag`|2 WHERE `entry` = 90473;\r\n\r\nDELETE FROM `creature_queststarter` WHERE `id` IN (67370, 74056, 85519, 85546, 90473);\r\nDELETE FROM `creature_questender` WHERE `id` IN (67370, 74056, 85519, 85546, 90473);\r\n\r\nINSERT INTO `creature_queststarter` VALUES\r\n(67370, 32175), -- Jeremy Feasel, Darkmoon Pet Battle!\r\n(74056, 33756), -- Malle Earnhard, Let's Keep Racing!\r\n(74056, 37910), -- Malle Earnhard, The Real Race\r\n(74056, 37819), -- Malle Earnhard, Welcome to the Darkmoon Races\r\n(85519, 36471), -- Christoph VonFeasel, A New Darkmoon Challenger!\r\n(85546, 36481), -- Ziggie Sparks, Firebird's Challenge\r\n(90473, 37868), -- Patti Earnhard, More Big Racing!\r\n(90473, 37911); -- Patti Earnhard, The Real Big Race\r\n\r\nINSERT INTO `creature_questender` VALUES\r\n(67370, 32175), -- Jeremy Feasel, Darkmoon Pet Battle!\r\n(74056, 33756), -- Malle Earnhard, Let's Keep Racing!\r\n(74056, 37910), -- Malle Earnhard, The Real Race\r\n(74056, 37819), -- Malle Earnhard, Welcome to the Darkmoon Races\r\n(85519, 36471), -- Christoph VonFeasel, A New Darkmoon Challenger!\r\n(85546, 36481), -- Ziggie Sparks, Firebird's Challenge\r\n(90473, 37868), -- Patti Earnhard, More Big Racing!\r\n(90473, 37911); -- Patti Earnhard, The Real Big Race\r\n\r\n\r\n-- Depholm (1)\r\nDELETE FROM `creature_queststarter` WHERE `id` IN (66815);\r\nDELETE FROM `creature_questender` WHERE `id` IN (66815);\r\n\r\nINSERT INTO `creature_queststarter` VALUES\r\n(66815, 31973); -- Bordin Steadyfist, Bordin Steadyfist\r\n\r\nINSERT INTO `creature_questender` VALUES\r\n(66815, 31973); -- Bordin Steadyfist, Bordin Steadyfist\r\n```"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/138116009","html_url":"https://github.com/TrinityCore/TrinityCore/issues/15450#issuecomment-138116009","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15450","id":138116009,"user":{"login":"Helias","id":519778,"avatar_url":"https://avatars.githubusercontent.com/u/519778?v=3","gravatar_id":"","url":"https://api.github.com/users/Helias","html_url":"https://github.com/Helias","followers_url":"https://api.github.com/users/Helias/followers","following_url":"https://api.github.com/users/Helias/following{/other_user}","gists_url":"https://api.github.com/users/Helias/gists{/gist_id}","starred_url":"https://api.github.com/users/Helias/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Helias/subscriptions","organizations_url":"https://api.github.com/users/Helias/orgs","repos_url":"https://api.github.com/users/Helias/repos","events_url":"https://api.github.com/users/Helias/events{/privacy}","received_events_url":"https://api.github.com/users/Helias/received_events","type":"User","site_admin":false},"created_at":"2015-09-06T19:16:09Z","updated_at":"2015-09-06T19:16:09Z","body":"Sorry I removed the \"Wandering Isle\" fixes, I extracted the zones of Maelstrom and unintentionally I made some double fixes."}}