{"action":"closed","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/7683","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/7683/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/7683/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/7683/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/7683","id":6711545,"number":7683,"title":"[NPC/FIX] Vyragosa (32630) & Time-Lost Proto-Drake (32491)","user":{"login":"nelegalno","id":937520,"avatar_url":"https://avatars.githubusercontent.com/u/937520?v=3","gravatar_id":"","url":"https://api.github.com/users/nelegalno","html_url":"https://github.com/nelegalno","followers_url":"https://api.github.com/users/nelegalno/followers","following_url":"https://api.github.com/users/nelegalno/following{/other_user}","gists_url":"https://api.github.com/users/nelegalno/gists{/gist_id}","starred_url":"https://api.github.com/users/nelegalno/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nelegalno/subscriptions","organizations_url":"https://api.github.com/users/nelegalno/orgs","repos_url":"https://api.github.com/users/nelegalno/repos","events_url":"https://api.github.com/users/nelegalno/events{/privacy}","received_events_url":"https://api.github.com/users/nelegalno/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Branch-3.3.5a","name":"Branch-3.3.5a","color":"188846"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Comp-Database","name":"Comp-Database","color":"FF6600"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Feedback-PatchFix","name":"Feedback-PatchFix","color":"d7e102"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":16,"created_at":"2012-09-07T11:09:12Z","updated_at":"2016-01-04T16:29:39Z","closed_at":"2016-01-04T16:29:39Z","body":"This fixes the 25sec respawn of the NPC's and adds the extra Vyragosa spawn to the pool.\r\n\r\nI believe some of the spawn locations are invalid:\r\nTime-Lost Proto-Drake GUIDs: 202477, 202478, 202479 and 202480\r\nVyragosa GUIDs: 202457, 202458, 202459 and 202460\r\nFor the three on the right I'm certain - the one on the bottom left not so much: http://i48.tinypic.com/ibgyup.png\r\n\r\nP.S. I'm guessing that GUIDs 202475/202455 and 202478/202458 are spawn points for Dirkee.\r\n\r\nBTW Is my assumption that if I use mother_pool=60002 it'll use the old pool_template.entry=60002 correct? Or should I create a new pool_template for the 2 new entries?\r\n\r\n```SQL\r\n-- Vyragosa (32630) & Time-Lost Proto-Drake (32491) fix by nelegalno\r\n\r\nSET @POOL := 60002;\r\n\r\n-- Vyragosa set respawn to 6h (current 25 sec)\r\nUPDATE `creature` SET `spawntimesecs`=21600 WHERE `id`=32630;\r\n\r\n-- Time-Lost Proto-Drake set respawn to 6h (current 25 sec)\r\nUPDATE `creature` SET `spawntimesecs`=21600 WHERE `id`=32491;\r\n\r\nDELETE FROM `pool_creature` WHERE `pool_entry`=60002; -- Remove old pool\r\n\r\nDELETE FROM `pool_pool` WHERE `pool_id` IN (32491,32630) AND `mother_pool`=@POOL;\r\nINSERT INTO `pool_pool` (`pool_id`, `mother_pool`, `chance`, `description`) VALUES\r\n(32630,@POOL,80,\"Vyragosa (32630)\"),\r\n(32491,@POOL,20,\"Time-Lost Proto Drake (32491)\");\r\n\r\nDELETE FROM `pool_creature` WHERE `pool_entry` in (32491,32630);\r\nINSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES\r\n-- spawns 1-20 for both NPCs are from old pool\r\n(202461,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 1\"),\r\n(202462,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 2\"),\r\n(202463,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 3\"),\r\n(202464,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 4\"),\r\n(202465,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 5\"),\r\n(202466,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 6\"),\r\n(202467,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 7\"),\r\n(202468,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 8\"),\r\n(202469,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 9\"),\r\n(202470,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 10\"),\r\n(202471,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 11\"),\r\n(202472,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 12\"),\r\n(202473,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 13\"),\r\n(202474,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 14\"),\r\n(202475,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 15\"),\r\n(202476,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 16\"),\r\n(202477,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 17\"),\r\n(202478,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 18\"),\r\n(202479,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 19\"),\r\n(202480,32491,0,\"Time-Lost Proto Drake (32491) - Spawn 20\"),\r\n(202441,32630,0,\"Vyragosa (32630) - Spawn 1\"),\r\n(202442,32630,0,\"Vyragosa (32630) - Spawn 2\"),\r\n(202443,32630,0,\"Vyragosa (32630) - Spawn 3\"),\r\n(202444,32630,0,\"Vyragosa (32630) - Spawn 4\"),\r\n(202445,32630,0,\"Vyragosa (32630) - Spawn 5\"),\r\n(202446,32630,0,\"Vyragosa (32630) - Spawn 6\"),\r\n(202447,32630,0,\"Vyragosa (32630) - Spawn 7\"),\r\n(202448,32630,0,\"Vyragosa (32630) - Spawn 8\"),\r\n(202449,32630,0,\"Vyragosa (32630) - Spawn 9\"),\r\n(202450,32630,0,\"Vyragosa (32630) - Spawn 10\"),\r\n(202451,32630,0,\"Vyragosa (32630) - Spawn 11\"),\r\n(202452,32630,0,\"Vyragosa (32630) - Spawn 12\"),\r\n(202453,32630,0,\"Vyragosa (32630) - Spawn 13\"),\r\n(202454,32630,0,\"Vyragosa (32630) - Spawn 14\"),\r\n(202455,32630,0,\"Vyragosa (32630) - Spawn 15\"),\r\n(202456,32630,0,\"Vyragosa (32630) - Spawn 16\"),\r\n(202457,32630,0,\"Vyragosa (32630) - Spawn 17\"),\r\n(202458,32630,0,\"Vyragosa (32630) - Spawn 18\"),\r\n(202459,32630,0,\"Vyragosa (32630) - Spawn 19\"),\r\n(202460,32630,0,\"Vyragosa (32630) - Spawn 20\"),\r\n-- spawned in TDB but not in the old pool\r\n(202602,32630,0,\"Vyragosa (32630) - Spawn 21\");\r\n\r\n```\r\n\r\n<bountysource-plugin>\r\n---\r\nWant to back this issue? **[Post a bounty on it!](https://www.bountysource.com/issues/64073-npc-fix-vyragosa-32630-time-lost-proto-drake-32491?utm_campaign=plugin&utm_content=tracker%2F1310&utm_medium=issues&utm_source=github)** We accept bounties via [Bountysource](https://www.bountysource.com/?utm_campaign=plugin&utm_content=tracker%2F1310&utm_medium=issues&utm_source=github).\r\n</bountysource-plugin>"}}