{"action":"created","issue":{"url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/12752","labels_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/12752/labels{/name}","comments_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/12752/comments","events_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/12752/events","html_url":"https://github.com/TrinityCore/TrinityCore/issues/12752","id":39380273,"number":12752,"title":"Starting area creatures giving quests","user":{"login":"DDuarte","id":530940,"avatar_url":"https://avatars.githubusercontent.com/u/530940?v=3","gravatar_id":"","url":"https://api.github.com/users/DDuarte","html_url":"https://github.com/DDuarte","followers_url":"https://api.github.com/users/DDuarte/followers","following_url":"https://api.github.com/users/DDuarte/following{/other_user}","gists_url":"https://api.github.com/users/DDuarte/gists{/gist_id}","starred_url":"https://api.github.com/users/DDuarte/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DDuarte/subscriptions","organizations_url":"https://api.github.com/users/DDuarte/orgs","repos_url":"https://api.github.com/users/DDuarte/repos","events_url":"https://api.github.com/users/DDuarte/events{/privacy}","received_events_url":"https://api.github.com/users/DDuarte/received_events","type":"User","site_admin":false},"labels":[{"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-Core","name":"Comp-Core","color":"FF6600"},{"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":29,"created_at":"2014-08-03T21:49:21Z","updated_at":"2015-07-12T14:12:20Z","closed_at":null,"body":"<a href=\"https://github.com/DDuarte\"><img src=\"https://avatars.githubusercontent.com/u/530940?v=1\" align=\"left\" width=\"96\" height=\"96\" hspace=\"10\"></img></a> **Issue by [DDuarte](https://github.com/DDuarte)**\n_Sunday Jan 20, 2013 at 03:27 GMT_\n_Originally opened as https://github.com/TrinityCore/TrinityCore_4.3.4_DB_Alpha/issues/91_\n\n----\n\nFrom https://github.com/TrinityCore/TrinityCore/issues/9004, by @akira6968:\r\n\r\n> Whole server freshly compiled (and DB) on 32bit Windows7 VMware\r\n> MySQL 5.1.51\r\n> Visual Studio C++ 2008\r\n> OpenSSL 1.0.1c\r\n> \r\n> Issue:\r\n> Starting area creatures have quests (every creature lol)\r\n> Once accepted, the creatures (being the ones that are the object of the quests) are yellow (neutral).\r\n> \r\n> Versions:\r\n> TrinityCore rev. 2013-01-19 18:36:39 +0100 (a5e7936) (Win32, Release)\r\n> TDB_full_434.02_2012_08_30 + Updates_02 (thru 211_creature.sql) + src/sql/updates/world/ (2013_01_19_00 thru 2013_01_19_06 which were just committed a few hours ago and not in the Updates_02 repo)\r\n> \r\n> Server.log:\r\n> Unknown action type 48\r\n> Creature (GUID: 138202 Entry: 44614) has wrong spell 0 defined in auras field.\r\n> Creature (GUID: 138203 Entry: 44614) has wrong spell 0 defined in auras field.\r\n> (several more of these)\r\n> \r\n> Sorry....can't see a way to add the 4.3.4 tag...\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/3466910-starting-area-creatures-giving-quests?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/120722676","html_url":"https://github.com/TrinityCore/TrinityCore/issues/12752#issuecomment-120722676","issue_url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/12752","id":120722676,"user":{"login":"msoky","id":3620508,"avatar_url":"https://avatars.githubusercontent.com/u/3620508?v=3","gravatar_id":"","url":"https://api.github.com/users/msoky","html_url":"https://github.com/msoky","followers_url":"https://api.github.com/users/msoky/followers","following_url":"https://api.github.com/users/msoky/following{/other_user}","gists_url":"https://api.github.com/users/msoky/gists{/gist_id}","starred_url":"https://api.github.com/users/msoky/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/msoky/subscriptions","organizations_url":"https://api.github.com/users/msoky/orgs","repos_url":"https://api.github.com/users/msoky/repos","events_url":"https://api.github.com/users/msoky/events{/privacy}","received_events_url":"https://api.github.com/users/msoky/received_events","type":"User","site_admin":false},"created_at":"2015-07-12T14:12:20Z","updated_at":"2015-07-12T14:12:20Z","body":"so, this can be pushed:\r\nDELETE FROM creature_queststarter WHERE id IN (706,808,3102,10556,15274,37070,37073,37112,39317,42223);\r\nUPDATE creature_template SET npcflag=0 WHERE entry IN (706,808,3102,10556,15274,37070,37073,37112,39317,42223);"}}