{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/18172","repository_url":"https://api.github.com/repos/TrinityCore/TrinityCore","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/18172/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/18172/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/18172/events","html_url":"https://github.com/TrinityCore/TrinityCore/pull/18172","id":186143248,"number":18172,"title":"Core/GameObject: spawn linked traps at gameobject creation instead of using DB spawns.","user":{"login":"SnapperRy","id":19622383,"avatar_url":"https://avatars.githubusercontent.com/u/19622383?v=3","gravatar_id":"","url":"https://api.github.com/users/SnapperRy","html_url":"https://github.com/SnapperRy","followers_url":"https://api.github.com/users/SnapperRy/followers","following_url":"https://api.github.com/users/SnapperRy/following{/other_user}","gists_url":"https://api.github.com/users/SnapperRy/gists{/gist_id}","starred_url":"https://api.github.com/users/SnapperRy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SnapperRy/subscriptions","organizations_url":"https://api.github.com/users/SnapperRy/orgs","repos_url":"https://api.github.com/users/SnapperRy/repos","events_url":"https://api.github.com/users/SnapperRy/events{/privacy}","received_events_url":"https://api.github.com/users/SnapperRy/received_events","type":"User","site_admin":false},"labels":[{"id":36087725,"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Branch-3.3.5a","name":"Branch-3.3.5a","color":"188846","default":false},{"id":26232644,"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Comp-Core","name":"Comp-Core","color":"FF6600","default":false},{"id":124090,"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Feedback-PatchFix","name":"Feedback-PatchFix","color":"d7e102","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-10-30T15:36:58Z","updated_at":"2016-11-01T21:21:51Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/pulls/18172","html_url":"https://github.com/TrinityCore/TrinityCore/pull/18172","diff_url":"https://github.com/TrinityCore/TrinityCore/pull/18172.diff","patch_url":"https://github.com/TrinityCore/TrinityCore/pull/18172.patch"},"body":"**Changes proposed:**\r\n\r\nTitle says it all. Recent changes only affect gameobjects spawned via spell effects, but there are also a lot of spawned gameobjects that should also spawn a linked trap and respawn/despawn it.\r\n\r\nGUID list comes from:\r\n\r\n``` sql\r\nSELECT `guid` FROM `gameobject`\r\n WHERE `id` IN (SELECT `data7`  FROM `gameobject_template` WHERE `type`=3)\r\n    OR `id` IN (SELECT `data3`  FROM `gameobject_template` WHERE `type`=1)\r\n    OR `id` IN (SELECT `data2`  FROM `gameobject_template` WHERE `type`=8)\r\n    OR `id` IN (SELECT `data12` FROM `gameobject_template` WHERE `type`=10)\r\n ORDER BY `guid`;\r\n```\r\n\r\nA bit ugly, but apparently the gameobject table doesn't like delete queries by id.\r\n\r\nCloses #11328.\r\n\r\n**Target branch(es):** 3.3.5\r\n\r\n**Tests performed:** tested and working.\r\n"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/257701880","html_url":"https://github.com/TrinityCore/TrinityCore/pull/18172#issuecomment-257701880","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/18172","id":257701880,"user":{"login":"SnapperRy","id":19622383,"avatar_url":"https://avatars.githubusercontent.com/u/19622383?v=3","gravatar_id":"","url":"https://api.github.com/users/SnapperRy","html_url":"https://github.com/SnapperRy","followers_url":"https://api.github.com/users/SnapperRy/followers","following_url":"https://api.github.com/users/SnapperRy/following{/other_user}","gists_url":"https://api.github.com/users/SnapperRy/gists{/gist_id}","starred_url":"https://api.github.com/users/SnapperRy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SnapperRy/subscriptions","organizations_url":"https://api.github.com/users/SnapperRy/orgs","repos_url":"https://api.github.com/users/SnapperRy/repos","events_url":"https://api.github.com/users/SnapperRy/events{/privacy}","received_events_url":"https://api.github.com/users/SnapperRy/received_events","type":"User","site_admin":false},"created_at":"2016-11-01T21:21:51Z","updated_at":"2016-11-01T21:21:51Z","body":"@tkrokli yep, it does fix that one too, albeit indirectly (main fix for that issue was 5d9d25d, but that only works for objects spawned by spells). Nice find :) was hard to find due to misleading title."}}
{"actor":{"display_login":"SnapperRy"}}