{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15722","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15722/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15722/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15722/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/15722","id":111962210,"number":15722,"title":"3.3.5 Quest 9528","user":{"login":"Tauriella","id":10637389,"avatar_url":"https://avatars.githubusercontent.com/u/10637389?v=3","gravatar_id":"","url":"https://api.github.com/users/Tauriella","html_url":"https://github.com/Tauriella","followers_url":"https://api.github.com/users/Tauriella/followers","following_url":"https://api.github.com/users/Tauriella/following{/other_user}","gists_url":"https://api.github.com/users/Tauriella/gists{/gist_id}","starred_url":"https://api.github.com/users/Tauriella/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Tauriella/subscriptions","organizations_url":"https://api.github.com/users/Tauriella/orgs","repos_url":"https://api.github.com/users/Tauriella/repos","events_url":"https://api.github.com/users/Tauriella/events{/privacy}","received_events_url":"https://api.github.com/users/Tauriella/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/Branch-6.x","name":"Branch-6.x","color":"188846"},{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/labels/Comp-C++Script","name":"Comp-C++Script","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-Quests","name":"Sub-Quests","color":"e10c02"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-10-17T12:54:59Z","updated_at":"2015-11-17T04:53:10Z","closed_at":null,"body":"TrinityCore rev. d4f2367c6bfe 2015-10-16 11:16:30 +0200 (HEAD branch)\r\n\r\nhttp://de.wowhead.com/quest=9528/ein-hilferuf\r\n\r\nMagwin falls into the water.\r\n\r\n![wowscrnshot_101715_141358](https://cloud.githubusercontent.com/assets/10637389/10558835/c12825b6-74de-11e5-8df4-f14f87f811d3.jpg)\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/157267420","html_url":"https://github.com/TrinityCore/TrinityCore/issues/15722#issuecomment-157267420","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15722","id":157267420,"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":"2015-11-17T04:53:10Z","updated_at":"2015-11-17T04:53:10Z","body":"@joslyn-liu : to change only 1 value like `InhabitType`, you don't need to do a full `DELETE FROM` / `INSERT INTO` pair. Use `UPDATE` / `SET` instead:\r\n```sql\r\nUPDATE `creature_template` SET `InhabitType` = 1 WHERE `entry` = 17312;\r\n```\r\n... although I think NPCs are supposed to be able to swim. Don't know about this one, though."}}