{"action":"opened","issue":{"url":"https://api.github.com/repos/OregonCore/OregonCore/issues/1075","labels_url":"https://api.github.com/repos/OregonCore/OregonCore/issues/1075/labels{/name}","comments_url":"https://api.github.com/repos/OregonCore/OregonCore/issues/1075/comments","events_url":"https://api.github.com/repos/OregonCore/OregonCore/issues/1075/events","html_url":"https://github.com/OregonCore/OregonCore/issues/1075","id":125715974,"number":1075,"title":"Wrong db update in repository (2796_database_fix) (BB #1075)","user":{"login":"OregonAsari","id":16568392,"avatar_url":"https://avatars.githubusercontent.com/u/16568392?v=3","gravatar_id":"","url":"https://api.github.com/users/OregonAsari","html_url":"https://github.com/OregonAsari","followers_url":"https://api.github.com/users/OregonAsari/followers","following_url":"https://api.github.com/users/OregonAsari/following{/other_user}","gists_url":"https://api.github.com/users/OregonAsari/gists{/gist_id}","starred_url":"https://api.github.com/users/OregonAsari/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/OregonAsari/subscriptions","organizations_url":"https://api.github.com/users/OregonAsari/orgs","repos_url":"https://api.github.com/users/OregonAsari/repos","events_url":"https://api.github.com/users/OregonAsari/events{/privacy}","received_events_url":"https://api.github.com/users/OregonAsari/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/OregonCore/OregonCore/labels/migrated","name":"migrated","color":"337AB7"},{"url":"https://api.github.com/repos/OregonCore/OregonCore/labels/Priority:%20Low","name":"Priority: Low","color":"bfe5bf"},{"url":"https://api.github.com/repos/OregonCore/OregonCore/labels/Type:%20Bug","name":"Type: Bug","color":"fad8c7"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-01-08T23:28:59Z","updated_at":"2016-01-08T23:29:00Z","closed_at":null,"body":"This issue was migrated from bitbucket.\n**Original Reporter:** PadreWoW\n**Original Date:** 24.07.2015 14:08:12 GMT+0000\n**Original Priority:** minor\n**Original Type:** bug\n**Original State:** resolved\n**Direct Link:** https://bitbucket.org/oregon/oregoncore/issues/1075\n<hr>\nErrors are here:\r\n\r\n\r\n```\r\n#!c++\r\n\r\n-- QuestChance requires - until conditions are merged in\r\nINSERT INTO creature_loot_template (`entry`,`item`,`ChanceOrQuestChance`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) values (21477,31372,-100,0,1,1,0,0,0);\r\nINSERT INTO creature_loot_template (`entry`,`item`,`ChanceOrQuestChance`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`) values (21478,31372,-100,0,1,1,0,0,0);\r\n\r\n\r\n-- Goblin sponsorship fix, nothing was wrong with this quest\r\nUPDATE creature SET position_x = '-11949.5', position_y = '-500.392', position_z = '30.7014', orientation = '5.06145' WHERE guid = '2208';\r\nDELETE FROM creature_loot_template WHERE entry='4723' AND item='5851';\r\nINSERT INTO creature_loot_template (`entry`,`item`,`ChanceOrQuestChance`,`groupid`,`mincountOrRef`,`maxcount`,`lootcondition`,`condition_value1`,`condition_value2`)\r\n values (4723,5852,-100,0,1,1,0,0,0);\r\n\r\n```\r\n\r\nThere are no ChanceOrQuestChance column in creature_loot_template any more!"}}