{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15117","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15117/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15117/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15117/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/15117","id":95881209,"number":15117,"title":"DB/Misc: Stable Master Xon'cha has wrong npcflag in creature_template","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},"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-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":5,"created_at":"2015-07-19T03:29:24Z","updated_at":"2015-07-21T15:44:49Z","closed_at":null,"body":"TrinityCore rev. 9578d91d2794 2015-07-14 21:54:54 +0200 (3.3.5 branch) (Win64, Release) \r\nDB: TDB 335.59 + updates\r\n\r\nhttp://wotlk.openwow.com/npc=9988\r\nhttp://www.wowhead.com/npc=9988/xoncha\r\nNPC ID 9988, Stable Master Xon'cha in Orgrimmar, has only got `npcflag = 1` in creature_template.\r\nThis only gives him a gossip window, no menu option to access the stable slots from flag `4194304`.\r\n\r\nA simple comparison between him and the nearest 2 stable masters in Razor Hill and Crossroads :\r\n```sql\r\nSELECT * FROM `creature_template` WHERE `name` IN (\"Xon'cha\",\"Shoja'my\",\"Sikwa\");\r\n```\r\n```\r\n entry  modelid1  name      subname        IconName  gossip_menu_id  faction  npcflag  speed_walk\r\n------  --------  --------  -------------  --------  --------------  -------  -------  ----------\r\n  9987      9262  Shoja'my  Stable Master  (NULL)              9821      126  4194305           1\r\n  9981      9254  Sikwa     Stable Master  (NULL)              9821       29  4194305           1\r\n  9988      9261  Xon'cha   Stable Master  (NULL)             11971       29        1           1\r\n```\r\n(Yes, I removed the unrelated/uninteresting columns from the output to simplify the overview.)\r\n\r\nSuggested fix:\r\n```sql\r\nUPDATE `creature_template` SET `npcflag`= 4194305 WHERE `entry`= 9988 AND `name`= \"Xon'cha\";\r\n```"},"comment":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/123379210","html_url":"https://github.com/TrinityCore/TrinityCore/issues/15117#issuecomment-123379210","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/15117","id":123379210,"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-07-21T15:44:49Z","updated_at":"2015-07-21T15:44:49Z","body":"OK, thanks for the clarification. :-) Submitting my updated SQL query here:\r\n```sql\r\n-- Creature ID 9988 \"Xon'cha\" is a Stable Master, npcflag is 4194304+1\r\nUPDATE `creature_template` SET `npcflag`= 4194305 WHERE `entry`= 9988;"}}