{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16694","repository_url":"https://api.github.com/repos/TrinityCore/TrinityCore","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16694/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16694/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16694/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/16694","id":136935152,"number":16694,"title":"[6.x] DB/Spell: Teleport to Saurok Creation Pit. 6.x.x.","user":{"login":"ghost","id":10137,"avatar_url":"https://avatars.githubusercontent.com/u/10137?v=3","gravatar_id":"","url":"https://api.github.com/users/ghost","html_url":"https://github.com/ghost","followers_url":"https://api.github.com/users/ghost/followers","following_url":"https://api.github.com/users/ghost/following{/other_user}","gists_url":"https://api.github.com/users/ghost/gists{/gist_id}","starred_url":"https://api.github.com/users/ghost/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ghost/subscriptions","organizations_url":"https://api.github.com/users/ghost/orgs","repos_url":"https://api.github.com/users/ghost/repos","events_url":"https://api.github.com/users/ghost/events{/privacy}","received_events_url":"https://api.github.com/users/ghost/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"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Sub-Spells","name":"Sub-Spells","color":"e10c02"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-02-27T16:02:43Z","updated_at":"2016-05-13T12:56:33Z","closed_at":null,"body":"**Description**:\r\nTeleport to Saurok Creation Pit - not teleported.\r\n**Current behaviour**: Tell us what happens\r\nNot teleported, because don't have coordinates in DB.\r\n**Expected behaviour**: Tell us what should happen instead\r\nNeed add coords in DB.\r\n**Steps to reproduce the problem**:\r\n\r\n1.No\r\n2.No\r\n3.No\r\n\r\n**Branch(es)**: /6x\r\n6.x.x WoD\r\n**TC hash/commit**:https://github.com/TrinityCore/TrinityCore/commit/e40371909cd7e8c5ce29b96e46161bc88bf75b2c\r\n\r\n**TDB version**:Latest.\r\n\r\n**Operating system**:Win7/x64\r\n\r\n\r\n[//]: # (This template is for problem reports, for other type of reports edit it accordingly)\r\n[//]: # (If this is a crash report, include the crashlog with https://gist.github.com/)\r\n``` SQL\r\nDELETE FROM `spell_target_position`  WHERE `ID` = 140395;\r\nINSERT INTO `spell_target_position` (`ID`, `EffectIndex`, `MapID`, `PositionX`, `PositionY`, `PositionZ`) VALUES \r\n(140395,0,1098,5633.36,4679.78,55.6488,210.507);\r\n```\r\nSource from SpellWork 6.x.x.\r\n``` SQL\r\nID - 140395 Телепорт в яму создания сауроков\r\n=================================================\r\nDescription: 1098, 5633.36, 4679.78, 55.6488, 210.507\r\n\r\nCategory = 0, SpellIconID = 1, activeIconID = 0, SpellVisual = (7723,0)\r\nFamily SPELLFAMILY_GENERIC, flag [0] 0x00000000 [1] 0x00000000 [2] 0x00000000 [3] 0x00000000\r\n\r\nSpellSchoolMask = 1 (SPELL_SCHOOL_MASK_NORMAL)\r\nDamageClass = 0 (SPELL_DAMAGE_CLASS_NONE)\r\nPreventionType = 0 (SPELL_PREVENTION_TYPE_NONE)\r\n=================================================\r\nAttributes: 0x10000100 (SPELL_ATTR0_HIDE_IN_COMBAT_LOG, SPELL_ATTR0_CANT_USED_IN_COMBAT)\r\nAttributesEx2: 0x00000001 (SPELL_ATTR2_CAN_TARGET_DEAD)\r\n=================================================\r\nSpell Level = 0, base 0, max 0\r\n\r\nCategory = 0\r\nDispelType = 0 (DISPEL_NONE)\r\nMechanic = 0 (MECHANIC_NONE)\r\nSpellRange: (Id 4) \"Medium Range\":\r\n    MinRangeNegative = 0, MinRangePositive = 0\r\n    MaxRangeNegative = 30, MaxRangePositive = 30\r\n\r\nCast time (Id 1) = 0,00\r\n\r\nInterrupt Flags: 0x0000001F, AuraIF 0x00000000, ChannelIF 0x00000000\r\nChance = 0, charges - 0\r\n=================================================\r\nEffect 0: Id 5 (SPELL_EFFECT_TELEPORT_UNITS) DIFFICULTY_NONE\r\nBasePoints = 0\r\nTargets (25, 17) (TARGET_UNIT_TARGET_ANY, TARGET_DEST_DB)\r\n```\r\n"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/219035016","html_url":"https://github.com/TrinityCore/TrinityCore/issues/16694#issuecomment-219035016","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/16694","id":219035016,"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":"2016-05-13T12:56:33Z","updated_at":"2016-05-13T12:56:33Z","body":"One of the TC developers will add it to DB when they got time to do so (at an opportune time)."}}