{"action":"created","issue":{"url":"https://api.github.com/repos/unified-db/Database/issues/45","labels_url":"https://api.github.com/repos/unified-db/Database/issues/45/labels{/name}","comments_url":"https://api.github.com/repos/unified-db/Database/issues/45/comments","events_url":"https://api.github.com/repos/unified-db/Database/issues/45/events","html_url":"https://github.com/unified-db/Database/issues/45","id":61948899,"number":45,"title":"Elrodan and Aurosalia","user":{"login":"Ulduar","id":2470094,"avatar_url":"https://avatars.githubusercontent.com/u/2470094?v=3","gravatar_id":"","url":"https://api.github.com/users/Ulduar","html_url":"https://github.com/Ulduar","followers_url":"https://api.github.com/users/Ulduar/followers","following_url":"https://api.github.com/users/Ulduar/following{/other_user}","gists_url":"https://api.github.com/users/Ulduar/gists{/gist_id}","starred_url":"https://api.github.com/users/Ulduar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Ulduar/subscriptions","organizations_url":"https://api.github.com/users/Ulduar/orgs","repos_url":"https://api.github.com/users/Ulduar/repos","events_url":"https://api.github.com/users/Ulduar/events{/privacy}","received_events_url":"https://api.github.com/users/Ulduar/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-03-16T02:43:51Z","updated_at":"2015-03-16T11:16:46Z","closed_at":null,"body":"http://www.wowhead.com/npc=18743/elrodan\r\nhttp://www.wowhead.com/npc=18744/aurosalia\r\nThis unscrupulous magician must Elrodan timer to turn the poor thing out of combat Aurozaliyu a sheep or a giraffe or a snake. Or even in someone.\r\nFrom Trinity\r\n``` SQL\r\n-- SAI for Elrodan\r\nSET @ENTRY=18743;\r\nUPDATE `creature_template` SET `AIName`='SmartAI',`ScriptName`='' WHERE `entry`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE (`entryorguid`=@ENTRY AND `source_type`=0);\r\nDELETE FROM `smart_scripts` WHERE (`entryorguid`=@ENTRY*100 AND `source_type`=9);\r\nINSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES\r\n(@ENTRY,0,0,0,1,0,100,0,5000,8000,15000,25000,80,@ENTRY*100,0,0,0,0,0,1,0,0,0,0,0,0,0,'Elrodan - OOC - run script'),\r\n(@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,11,18744,20,0,0,0,0,0,'Elrodan - Script - Aurosalia say random'),\r\n(@ENTRY*100,9,1,0,0,0,100,0,3000,3000,3000,3000,11,32826,0,0,0,0,0,1,0,0,0,0,0,0,0,'Elrodan - Script - cast Polymorph Cast Visual');\r\n-- Aurosalia fix model\r\nUPDATE `creature_model_info` SET `modelid_other_gender`=0 WHERE `modelid`=18145;\r\n-- Aurosalia text\r\nDELETE FROM `creature_text` WHERE `entry`=18744;\r\nINSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES\r\n(18744,0,0, 'Stop!',1,0,100,5,0,0, 'Aurosalia'),\r\n(18744,0,1, 'Will you stop--',1,0,100,274,0,0, 'Aurosalia'),\r\n(18744,0,2, '',1,0,100,6,0,0, 'Aurosalia');\r\n```\r\nThanks Trinity \r\nhttps://github.com/TrinityCore/TrinityCore/search?utf8=%E2%9C%93&q=+Elrodan+%26+Aurosalia+"},"comment":{"url":"https://api.github.com/repos/unified-db/Database/issues/comments/81587861","html_url":"https://github.com/unified-db/Database/issues/45#issuecomment-81587861","issue_url":"https://api.github.com/repos/unified-db/Database/issues/45","id":81587861,"user":{"login":"xfurry","id":172444,"avatar_url":"https://avatars.githubusercontent.com/u/172444?v=3","gravatar_id":"","url":"https://api.github.com/users/xfurry","html_url":"https://github.com/xfurry","followers_url":"https://api.github.com/users/xfurry/followers","following_url":"https://api.github.com/users/xfurry/following{/other_user}","gists_url":"https://api.github.com/users/xfurry/gists{/gist_id}","starred_url":"https://api.github.com/users/xfurry/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xfurry/subscriptions","organizations_url":"https://api.github.com/users/xfurry/orgs","repos_url":"https://api.github.com/users/xfurry/repos","events_url":"https://api.github.com/users/xfurry/events{/privacy}","received_events_url":"https://api.github.com/users/xfurry/received_events","type":"User","site_admin":false},"created_at":"2015-03-16T11:16:46Z","updated_at":"2015-03-16T11:16:46Z","body":"I hope this is the last time when I have to tell you this:\r\n**When you submit a patch or a piece of code, please make the necessary transformations so it will be compatible with your core and DB.**\r\n\r\nSo please provide a patch compatible with UDB and cmangos, otherwise I'll have to reject this.\r\nNone of our developers are willing to spend time to make the code compatible with your DB.\r\nRather than that we can just develop it from scratch."}}