{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/8500","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/8500/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/8500/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/8500/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/8500","id":8796627,"number":8500,"title":"[CREATURE] All Orgrimmar NPCs ankle-deep in ground","user":{"login":"baric","id":2583860,"avatar_url":"https://avatars.githubusercontent.com/u/2583860?v=3","gravatar_id":"","url":"https://api.github.com/users/baric","html_url":"https://github.com/baric","followers_url":"https://api.github.com/users/baric/followers","following_url":"https://api.github.com/users/baric/following{/other_user}","gists_url":"https://api.github.com/users/baric/gists{/gist_id}","starred_url":"https://api.github.com/users/baric/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/baric/subscriptions","organizations_url":"https://api.github.com/users/baric/orgs","repos_url":"https://api.github.com/users/baric/repos","events_url":"https://api.github.com/users/baric/events{/privacy}","received_events_url":"https://api.github.com/users/baric/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/bounty","name":"bounty","color":"129e5e"},{"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/Priority-Cosmetic","name":"Priority-Cosmetic","color":"e102d8"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Sub-Miscellaneous","name":"Sub-Miscellaneous","color":"e10c02"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":22,"created_at":"2012-11-29T04:24:45Z","updated_at":"2016-01-28T07:55:04Z","closed_at":null,"body":"```sql\n--\n-- elevate Ogrimmar NPCs out of the ground. This can't be only on my TDB\n-- THIS SHOULD ONLY EXECUTE ONE TIME as it increases position_z\n--\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (3371, 3374, 3375, 3376, 3377, 3378, 3379, 3380, 3394, 4770, 4771, 6491, 6501, 6502, 6503, 6506, 6549, 6551, 6552, 6553, 6554, 6555, 6556, 7393, 7394, 7396, 10466, 54395, 88227);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (3371, 3374, 3375, 3376, 3377, 3378, 3379, 3380, 3394, 4770, 4771, 6491, 6501, 6502, 6503, 6506, 6549, 6551, 6552, 6553, 6554, 6555, 6556, 7393, 7394, 7396, 88227);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (3372, 3373, 3387, 3395, 3418, 4663, 4664, 4665, 6548, 6550, 6557, 6567, 7395);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (8521, 8524, 6561, 10299, 3349, 10463, 11790, 3476, 6597, 3472, 3615, 3473, 3613, 3648, 3474, 3471, 3422, 3646);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (10347, 3475, 3382, 7950, 1722, 208201, 208202, 7399, 3349, 3384, 10298, 10469);\nUPDATE creature SET position_z=position_z+0.30 WHERE guid IN (6611, 125681, 125682, 125683, 125685, 125686, 125687, 10464, 11789);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (7948, 6602, 4660, 6563, 7398, 11791, 7442, 6504, 6600, 7943, 4657, 6601, 11796, 4659, 7949, 8530, 4656);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (4661, 12325, 709, 708, 710, 706, 711, 707, 10350, 6599, 6605, 4652, 703, 10348, 4655, 6598, 4653, 4769, 6603, 4658, 8528, 7417, 4785, 6500, 10450, 8526, 6565, 10351);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (6560, 8522, 3476, 11792, 6564);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (6621, 6625, 6623, 4680, 6629, 3421, 7481, 6628, 6631, 4684, 4685, 3467, 34033, 4678, 34045);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (8525, 7416, 10462, 6630, 8529, 4666, 4667, 7415);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (4679, 6626, 7479, 4687, 6624, 4681, 6566, 11793, 4767, 4766, 7478, 4686, 6622, 4682);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (6604, 4654, 3477, 3560, 3571);\n\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (10468, 3388, 7451, 4728, 6558, 7971, 6610, 4762, 7443, 202481, 4671, 4668, 7946, 7968, 4672, 7969, 4676, 3426, 3468, 7970, 3430);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (3429, 3428, 7463, 3470, 4669, 3469, 4670, 7448, 7973, 7453, 6612, 7446, 4675, 7444, 6613, 4673, 6497, 6492, 6493, 6512, 6516);\nUPDATE creature SET position_z=position_z+0.15 WHERE guid IN (10297, 10353, 6608, 7447, 6620, 7449, 7972, 6606);\nUPDATE waypoint_data SET position_z=position_z+0.15 WHERE id IN (47600, 104700, 74210, 34660, 33860, 85270, 64960, 104670, 65620, 64940, 33490);\nUPDATE waypoint_data SET position_z=position_z+0.15 WHERE id IN (74210, 34660);\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/63631-creature-all-orgrimmar-npcs-ankle-deep-in-ground?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>"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/176041295","html_url":"https://github.com/TrinityCore/TrinityCore/issues/8500#issuecomment-176041295","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/8500","id":176041295,"user":{"login":"Kittnz","id":5845231,"avatar_url":"https://avatars.githubusercontent.com/u/5845231?v=3","gravatar_id":"","url":"https://api.github.com/users/Kittnz","html_url":"https://github.com/Kittnz","followers_url":"https://api.github.com/users/Kittnz/followers","following_url":"https://api.github.com/users/Kittnz/following{/other_user}","gists_url":"https://api.github.com/users/Kittnz/gists{/gist_id}","starred_url":"https://api.github.com/users/Kittnz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kittnz/subscriptions","organizations_url":"https://api.github.com/users/Kittnz/orgs","repos_url":"https://api.github.com/users/Kittnz/repos","events_url":"https://api.github.com/users/Kittnz/events{/privacy}","received_events_url":"https://api.github.com/users/Kittnz/received_events","type":"User","site_admin":false},"created_at":"2016-01-28T07:55:04Z","updated_at":"2016-01-28T07:55:04Z","body":"Indeed thats not the issue ;)"}}