{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16115","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16115/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16115/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16115/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/16115","id":123996726,"number":16115,"title":"[6.x] Challenge mode teleport spell_target_positions","user":{"login":"Foldor","id":3323434,"avatar_url":"https://avatars.githubusercontent.com/u/3323434?v=3","gravatar_id":"","url":"https://api.github.com/users/Foldor","html_url":"https://github.com/Foldor","followers_url":"https://api.github.com/users/Foldor/followers","following_url":"https://api.github.com/users/Foldor/following{/other_user}","gists_url":"https://api.github.com/users/Foldor/gists{/gist_id}","starred_url":"https://api.github.com/users/Foldor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Foldor/subscriptions","organizations_url":"https://api.github.com/users/Foldor/orgs","repos_url":"https://api.github.com/users/Foldor/repos","events_url":"https://api.github.com/users/Foldor/events{/privacy}","received_events_url":"https://api.github.com/users/Foldor/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Branch-6.x","name":"Branch-6.x","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":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-12-27T21:18:36Z","updated_at":"2015-12-30T02:42:40Z","closed_at":null,"body":"```sql\r\nDELETE FROM `spell_target_position`  WHERE `ID` IN (159898, 159901, 159895, 159896, 159897, 159900, 159899, 159902);\r\nINSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`, `VerifiedBuild`) VALUES \r\n(159898, 0, 1116, 32.4602, 2527.42, 103.606, 20779), -- Path of the Skies\r\n(159901, 0, 1116, 7117.57, 197.1, 145.211, 20779), -- Path of the Verdant\r\n(159895, 0, 1116, 7263.71, 4453.39, 129.221, 20779), -- Path of the Bloodmaul\r\n(159896, 0, 1116, 8850.58, 1370.09, 97.097, 20779), -- Path of the Iron Prow\r\n(159897, 0, 1116, 1489.18, 3075.6, 109.725, 20779), -- Path of the Vigilant\r\n(159900, 0, 1116, 7811.06, 542.615, 122.757, 20779), -- Path of the Dark Rail\r\n(159899, 0, 1116, 762.092, 130.033, 7.53102, 20779), -- Path of the Crescent Moon\r\n(159902, 0, 0, -7508.83, -1326.77, 301.364, 20779); -- Path of the Burning Mountain\r\n```\r\nRev: 9ab10d6e680ca835d1dfdfbceb9f18f330f994fc"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/167921987","html_url":"https://github.com/TrinityCore/TrinityCore/issues/16115#issuecomment-167921987","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16115","id":167921987,"user":{"login":"tkrokli","id":4903600,"avatar_url":"https://avatars.githubusercontent.com/u/4903600?v=3","gravatar_id":"","url":"https://api.github.com/users/tkrokli","html_url":"https://github.com/tkrokli","followers_url":"https://api.github.com/users/tkrokli/followers","following_url":"https://api.github.com/users/tkrokli/following{/other_user}","gists_url":"https://api.github.com/users/tkrokli/gists{/gist_id}","starred_url":"https://api.github.com/users/tkrokli/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tkrokli/subscriptions","organizations_url":"https://api.github.com/users/tkrokli/orgs","repos_url":"https://api.github.com/users/tkrokli/repos","events_url":"https://api.github.com/users/tkrokli/events{/privacy}","received_events_url":"https://api.github.com/users/tkrokli/received_events","type":"User","site_admin":false},"created_at":"2015-12-30T02:42:40Z","updated_at":"2015-12-30T02:42:40Z","body":"I just had some fun sorting the order of the IDs and spacing between the values, for readability.\r\n```sql\r\nDELETE FROM `spell_target_position`  WHERE `ID` IN (159895,159896,159897,159898,159899,159900,159901,159902);\r\nINSERT INTO `spell_target_position` (`ID`,`EffectIndex`,`MapID`,`PositionX`,`PositionY`,`PositionZ`,`VerifiedBuild`) VALUES \r\n(159895, 0, 1116, 7263.71, 4453.39, 129.221, 20779), -- Path of the Bloodmaul\r\n(159896, 0, 1116, 8850.58, 1370.09,  97.097, 20779), -- Path of the Iron Prow\r\n(159897, 0, 1116, 1489.18,  3075.6, 109.725, 20779), -- Path of the Vigilant\r\n(159898, 0, 1116, 32.4602, 2527.42, 103.606, 20779), -- Path of the Skies\r\n(159899, 0, 1116, 762.092, 130.033, 7.53102, 20779), -- Path of the Crescent Moon\r\n(159900, 0, 1116, 7811.06, 542.615, 122.757, 20779), -- Path of the Dark Rail\r\n(159901, 0, 1116, 7117.57,   197.1, 145.211, 20779), -- Path of the Verdant\r\n(159902, 0,    0,-7508.83,-1326.77, 301.364, 20779); -- Path of the Burning Mountain\r\n```\r\nFeel free to delete this post if you find it to be ridiculously redundant and superflous. :christmas_tree:"}}