{"action":"opened","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/18664","repository_url":"https://api.github.com/repos/TrinityCore/TrinityCore","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/18664/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/18664/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/18664/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/18664","id":198108190,"number":18664,"title":"[Master] DB/Creature Gnomeregan details fix","user":{"login":"Heaven31415","id":16988850,"avatar_url":"https://avatars.githubusercontent.com/u/16988850?v=3","gravatar_id":"","url":"https://api.github.com/users/Heaven31415","html_url":"https://github.com/Heaven31415","followers_url":"https://api.github.com/users/Heaven31415/followers","following_url":"https://api.github.com/users/Heaven31415/following{/other_user}","gists_url":"https://api.github.com/users/Heaven31415/gists{/gist_id}","starred_url":"https://api.github.com/users/Heaven31415/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Heaven31415/subscriptions","organizations_url":"https://api.github.com/users/Heaven31415/orgs","repos_url":"https://api.github.com/users/Heaven31415/repos","events_url":"https://api.github.com/users/Heaven31415/events{/privacy}","received_events_url":"https://api.github.com/users/Heaven31415/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-12-30T06:05:46Z","updated_at":"2016-12-30T06:05:46Z","closed_at":null,"body":"[//]: # (***************************************************************)\r\n[//]: # (** DON'T DELETE THIS TEMPLATE ELSE YOUR ISSUE WILL BE CLOSED **)\r\n[//]: # (***************************************************************)\r\n\r\n**Description:** In gnome starting zone (Gnomeregan) I have encountered 3 small problems:\r\na) 3 S.A.F.E Operatives had wrong position\r\nb) Injured Gnomes were standing and were missing aura with green visual effect.\r\nc) Most of S.A.F.E Operatives were missing equipment (I'm aware that not all of them have it)\r\n\r\nUsing sniffer on build 23222 I have managed to fix those issues with this SQL queries:\r\n\r\n~~~SQL\r\n-- Incorrect S.A.F.E Operatives positions\r\nUPDATE `creature` SET `position_x`= -4982.51 ,`position_y`= 841.753,`position_z`= 276.3153, `orientation` =  4.639863 WHERE `guid`= 304615;\r\nUPDATE `creature` SET `position_x`= -4986.46 ,`position_y`= 842.205,`position_z`= 276.3153, `orientation` =  4.510144 WHERE `guid`= 304616;\r\nUPDATE `creature` SET `position_x`= -4990.14 ,`position_y`= 842.663,`position_z`= 276.3153, `orientation` =  4.867120 WHERE `guid`= 304617;\r\n\r\n-- Injured Gnomes aura and state\r\nUPDATE `creature_template_addon` SET `bytes1` = 3, `auras` = \"80653\" WHERE `entry`= 46447;\r\nUPDATE `creature` SET `equipment_id` = 1 WHERE `guid` IN (304587,304588,304589,304593,304602,304609,304610,304615,304616,304617,304647,304653);\r\n\r\n-- S.A.F.E Operatives missing equipment\r\nDELETE FROM `creature_addon` WHERE `guid` IN (304587,304588,304589,304593,304602,304609,304610,304615,304616,304617,304647,304653);\r\nINSERT INTO `creature_addon` (`guid`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `aiAnimKit`, `movementAnimKit`, `meleeAnimKit`, `auras`) VALUES \r\n(304587, 0, 0, 0, 2, 0, 0, 0, 0, 0),\r\n(304588, 0, 0, 0, 2, 0, 0, 0, 0, 0),\r\n(304589, 0, 0, 0, 2, 0, 0, 0, 0, 0),\r\n(304593, 0, 0, 0, 2, 0, 0, 0, 0, 0),\r\n(304602, 0, 0, 0, 2, 0, 0, 0, 0, 0),\r\n(304609, 0, 0, 0, 2, 0, 0, 0, 0, 0),\r\n(304610, 0, 0, 0, 2, 0, 0, 0, 0, 0),\r\n(304615, 0, 0, 0, 2, 0, 0, 0, 0, 0),\r\n(304616, 0, 0, 0, 2, 0, 0, 0, 0, 0),\r\n(304617, 0, 0, 0, 2, 0, 0, 0, 0, 0),\r\n(304647, 0, 0, 0, 2, 0, 0, 0, 0, 0),\r\n(304653, 0, 0, 0, 2, 0, 0, 0, 0, 0);\r\n~~~\r\n\r\n**Branch(es):** master\r\n\r\n**TC rev. hash/commit:**  5c1503f85976\r\n\r\n**TDB version:**  TDB 703.00\r\n\r\n**Operating system:**  Windows 7 Ultimate with SP1\r\n\r\n\r\n[//]: # (This template is for problem reports. For other types of report, edit it accordingly.)\r\n[//]: # (If this is a crash report, include the crashlog with https://gist.github.com/)\r\n[//]: # (For fixes containing C++, create a Pull Request.)\r\n"}}
{"actor":{"display_login":"Heaven31415"}}