{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14880","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14880/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14880/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14880/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/14880","id":87999520,"number":14880,"title":"DB/Creature: Missing spawn for Shadowy Assassin","user":{"login":"Killyana","id":6587064,"avatar_url":"https://avatars.githubusercontent.com/u/6587064?v=3","gravatar_id":"","url":"https://api.github.com/users/Killyana","html_url":"https://github.com/Killyana","followers_url":"https://api.github.com/users/Killyana/followers","following_url":"https://api.github.com/users/Killyana/following{/other_user}","gists_url":"https://api.github.com/users/Killyana/gists{/gist_id}","starred_url":"https://api.github.com/users/Killyana/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Killyana/subscriptions","organizations_url":"https://api.github.com/users/Killyana/orgs","repos_url":"https://api.github.com/users/Killyana/repos","events_url":"https://api.github.com/users/Killyana/events{/privacy}","received_events_url":"https://api.github.com/users/Killyana/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":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-06-13T12:44:04Z","updated_at":"2015-06-13T14:38:14Z","closed_at":null,"body":"http://wotlk.openwow.com/npc=2434\r\nDrops http://wotlk.openwow.com/item=3668 that start a quest.\r\nrev. f5530c719b71\r\n``` sql\r\nSET @CGUID := xxxxxx; -- 4 free guid set by TC\r\nDELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+3;\r\nINSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `curhealth`, `MovementType`) VALUES\r\n(@CGUID+0, 2434, 0, 1, 1, -787, -392, 17.451, 0.458, 600, 15, 1536, 1),\r\n(@CGUID+1, 2434, 0, 1, 1, -779, -444, 21.207, 3.438, 600, 15, 1536, 1),\r\n(@CGUID+2, 2434, 0, 1, 1, -683, -377, 35.403, 2.841, 600, 15, 1536, 1),\r\n(@CGUID+3, 2434, 0, 1, 1, -613, -468, 33.300, 3.140, 600, 15, 1536, 1);"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/111715082","html_url":"https://github.com/TrinityCore/TrinityCore/issues/14880#issuecomment-111715082","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/14880","id":111715082,"user":{"login":"Killyana","id":6587064,"avatar_url":"https://avatars.githubusercontent.com/u/6587064?v=3","gravatar_id":"","url":"https://api.github.com/users/Killyana","html_url":"https://github.com/Killyana","followers_url":"https://api.github.com/users/Killyana/followers","following_url":"https://api.github.com/users/Killyana/following{/other_user}","gists_url":"https://api.github.com/users/Killyana/gists{/gist_id}","starred_url":"https://api.github.com/users/Killyana/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Killyana/subscriptions","organizations_url":"https://api.github.com/users/Killyana/orgs","repos_url":"https://api.github.com/users/Killyana/repos","events_url":"https://api.github.com/users/Killyana/events{/privacy}","received_events_url":"https://api.github.com/users/Killyana/received_events","type":"User","site_admin":false},"created_at":"2015-06-13T14:38:14Z","updated_at":"2015-06-13T14:38:14Z","body":"yes the event must be scripted:\r\nhttp://wowwiki.wikia.com/Shadowy_Assassin\r\nhttp://wowwiki.wikia.com/Southshore_Crier\r\n\r\nSouthshore Crier says: Hear ye! Hear ye! *pant pant* Be warned citizens of Southshore: assassins are heading to our fair town!\r\n\r\nSouthshore Crier says: Guards to your posts! They must be after the Magistrate again. He must be protected! They could come from any direction!\r\n\r\nSouthshore Cirer says: Assassins... save... th... Magistraaa...\r\n\r\n*Southshore Crier grabs the back of his neck and his eyes go wide.*\r\n*Southshore Cirer dies.*\r\n\r\nSouthshore Guard says: Protect the Magistrate at all costs. They could come from any direction!\r\n\r\nSouthshore Guard says: Get to your posts! Let no invader reach Southshore!\r\n\r\nSouthshore Guard says: Anyone suspicious is to be taken down quickly. Get to your posts as quickly as possible!\r\n\r\n\r\n\r\n"}}