{"action":"created","issue":{"url":"https://api.github.com/repos/cmangos/wotlk-db/issues/30","repository_url":"https://api.github.com/repos/cmangos/wotlk-db","labels_url":"https://api.github.com/repos/cmangos/wotlk-db/issues/30/labels{/name}","comments_url":"https://api.github.com/repos/cmangos/wotlk-db/issues/30/comments","events_url":"https://api.github.com/repos/cmangos/wotlk-db/issues/30/events","html_url":"https://github.com/cmangos/wotlk-db/issues/30","id":190358787,"number":30,"title":"The Etymidian quest chain","user":{"login":"Darth-Postal","id":19946716,"avatar_url":"https://avatars.githubusercontent.com/u/19946716?v=3","gravatar_id":"","url":"https://api.github.com/users/Darth-Postal","html_url":"https://github.com/Darth-Postal","followers_url":"https://api.github.com/users/Darth-Postal/followers","following_url":"https://api.github.com/users/Darth-Postal/following{/other_user}","gists_url":"https://api.github.com/users/Darth-Postal/gists{/gist_id}","starred_url":"https://api.github.com/users/Darth-Postal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Darth-Postal/subscriptions","organizations_url":"https://api.github.com/users/Darth-Postal/orgs","repos_url":"https://api.github.com/users/Darth-Postal/repos","events_url":"https://api.github.com/users/Darth-Postal/events{/privacy}","received_events_url":"https://api.github.com/users/Darth-Postal/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2016-11-18T16:17:11Z","updated_at":"2016-11-22T18:19:51Z","closed_at":null,"body":"Found some issues with \"The Etymidian\" quest chain from Avatar of Freya in Sholazar Basin.\r\n\r\n1. q12803 \"Force of Nature\" should be skippable. You should be able to start the quest chain by picking q12561 \"An Issue of Trust\" directly from Avatar of Freya. [Source 1](http://www.wowhead.com/quest=12561/an-issue-of-trust#comments:id=1202312), [Source 2](http://www.wowhead.com/quest=12803/force-of-nature#comments:id=368259:reply=166704).\r\n\r\n2. **[UNRESOLVED]** Both q12803 \"Force of Nature\" and q12561 \"An Issue of Trust\" should require \"Cold Weather Flying\" ability. [Source 1](http://www.wowhead.com/npc=27801/avatar-of-freya#comments:id=467311:reply=60099), [Source 2](http://www.wowhead.com/quest=12803/force-of-nature#comments:id=449423).\r\n\r\n3. q12805 \"Salvaging Life's Strength\" should require q12611 \"Returned Sevenfold\" instead of q12612 \"The Fallen Pillar\" [Source](http://www.wowhead.com/quest=12612/the-fallen-pillar#comments:id=454709)\r\n\r\n4. q12620 \"The Lifewarden's Wrath\" should require completion of both q12617 \"Exterminate the Intruders\" and q12660 \"Weapons of Destruction\". Currently it only requires q12617 \"Exterminate the Intruders\". [Source](http://www.wowhead.com/quest=12617/exterminate-the-intruders#comments:id=368342)\r\n\r\n5. **[UNRESOLVED]** Quest item [i40397 \"Lifeblood Gem\"](http://www.wowhead.com/item=40397/lifeblood-gem) doesn't work. q12805 \"Salvaging Life's Strength\" cannot be completed.\r\n\r\n6. [NPC 28222 The Etymidian](http://www.wowhead.com/npc=28222) (It's the Vehicle one) should have Mana bar, because his spells use Mana. Currently has empty bar (UnitClass = 1). Mana bar can be seen [here](https://www.youtube.com/watch?v=s059jClsUuU).\r\n\r\n**PARTIAL** suggested fix:\r\n```sql\r\n-- Remove q12803 \"Force of Nature\" as requirement for q12561 \"An Issue of Trust\"\r\nUPDATE quest_template SET PrevQuestId = 0 WHERE entry = 12561;\r\n\r\n-- Make q12805 \"Salvaging Life's Strength\" require q12611 \"Returned Sevenfold\"\r\nUPDATE quest_template SET PrevQuestId = 12611 WHERE entry = 12805;\r\n\r\n-- Make q12620 \"The Lifewarden's Wrath\" require completion of both q12617 \"Exterminate the Intruders\" and q12660 \"Weapons of Destruction\"\r\nUPDATE quest_template SET NextQuestId = 12620 WHERE entry IN (12617, 12660);\r\nUPDATE quest_template SET PrevQuestId = 0 WHERE entry = 12620;\r\n\r\n-- Give The Etymidian his Mana bar\r\nUPDATE creature_template SET UnitClass = 2 WHERE entry = 28222;\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/cmangos/wotlk-db/issues/comments/262321608","html_url":"https://github.com/cmangos/wotlk-db/issues/30#issuecomment-262321608","issue_url":"https://api.github.com/repos/cmangos/wotlk-db/issues/30","id":262321608,"user":{"login":"Darth-Postal","id":19946716,"avatar_url":"https://avatars.githubusercontent.com/u/19946716?v=3","gravatar_id":"","url":"https://api.github.com/users/Darth-Postal","html_url":"https://github.com/Darth-Postal","followers_url":"https://api.github.com/users/Darth-Postal/followers","following_url":"https://api.github.com/users/Darth-Postal/following{/other_user}","gists_url":"https://api.github.com/users/Darth-Postal/gists{/gist_id}","starred_url":"https://api.github.com/users/Darth-Postal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Darth-Postal/subscriptions","organizations_url":"https://api.github.com/users/Darth-Postal/orgs","repos_url":"https://api.github.com/users/Darth-Postal/repos","events_url":"https://api.github.com/users/Darth-Postal/events{/privacy}","received_events_url":"https://api.github.com/users/Darth-Postal/received_events","type":"User","site_admin":false},"created_at":"2016-11-22T18:19:51Z","updated_at":"2016-11-22T18:19:51Z","body":"Also:\r\n```\r\n2>  ObjectMgr.cpp\r\n2>..\\..\\src\\game\\ObjectMgr.cpp(111): error C2065: 'CONDITION_FROM_SPELLCLICK': undeclared identifier\r\n```"}}
{"actor":{"display_login":"Darth-Postal"}}