{"action":"created","issue":{"url":"https://api.github.com/repos/dalaranwow/dalaran-wow/issues/3340","repository_url":"https://api.github.com/repos/dalaranwow/dalaran-wow","labels_url":"https://api.github.com/repos/dalaranwow/dalaran-wow/issues/3340/labels{/name}","comments_url":"https://api.github.com/repos/dalaranwow/dalaran-wow/issues/3340/comments","events_url":"https://api.github.com/repos/dalaranwow/dalaran-wow/issues/3340/events","html_url":"https://github.com/dalaranwow/dalaran-wow/issues/3340","id":157828993,"number":3340,"title":"DB/Creature: Mebok Mizzyrix - Events","user":{"login":"Rushor","id":5568820,"avatar_url":"https://avatars.githubusercontent.com/u/5568820?v=3","gravatar_id":"","url":"https://api.github.com/users/Rushor","html_url":"https://github.com/Rushor","followers_url":"https://api.github.com/users/Rushor/followers","following_url":"https://api.github.com/users/Rushor/following{/other_user}","gists_url":"https://api.github.com/users/Rushor/gists{/gist_id}","starred_url":"https://api.github.com/users/Rushor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rushor/subscriptions","organizations_url":"https://api.github.com/users/Rushor/orgs","repos_url":"https://api.github.com/users/Rushor/repos","events_url":"https://api.github.com/users/Rushor/events{/privacy}","received_events_url":"https://api.github.com/users/Rushor/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/dalaranwow/dalaran-wow/labels/Classic","name":"Classic","color":"fbca04"},{"url":"https://api.github.com/repos/dalaranwow/dalaran-wow/labels/Miscelaneous","name":"Miscelaneous","color":"fad8c7"},{"url":"https://api.github.com/repos/dalaranwow/dalaran-wow/labels/NPC","name":"NPC","color":"207de5"},{"url":"https://api.github.com/repos/dalaranwow/dalaran-wow/labels/Quests","name":"Quests","color":"fbca04"}],"state":"closed","locked":false,"assignee":{"login":"Rushor","id":5568820,"avatar_url":"https://avatars.githubusercontent.com/u/5568820?v=3","gravatar_id":"","url":"https://api.github.com/users/Rushor","html_url":"https://github.com/Rushor","followers_url":"https://api.github.com/users/Rushor/followers","following_url":"https://api.github.com/users/Rushor/following{/other_user}","gists_url":"https://api.github.com/users/Rushor/gists{/gist_id}","starred_url":"https://api.github.com/users/Rushor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rushor/subscriptions","organizations_url":"https://api.github.com/users/Rushor/orgs","repos_url":"https://api.github.com/users/Rushor/repos","events_url":"https://api.github.com/users/Rushor/events{/privacy}","received_events_url":"https://api.github.com/users/Rushor/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2016-06-01T05:54:09Z","updated_at":"2016-06-04T18:16:12Z","closed_at":"2016-06-03T20:05:57Z","body":"two events should be executed after completing the quests from this creature\r\n\r\nfix:\r\n\r\n```sql\r\n-- Mebok Mizzyrix SAI\r\nSET @ENTRY := 3446;\r\nUPDATE `creature_template` SET `AIName`=\"SmartAI\" WHERE `entry`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0;\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,20,0,100,0,865,0,0,0,80,@ENTRY*100+00,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Mebok Mizzyrix - On Quest 'Raptor Horns' Finished - Run Script\"),\r\n(@ENTRY,0,1,0,19,0,100,0,1221,0,0,0,80,@ENTRY*100+01,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Mebok Mizzyrix - On Quest 'Blueleaf Tubers' Taken - Run Script\");\r\n\r\n-- Actionlist SAI\r\nSET @ENTRY := 344600;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Mebok Mizzyrix - On Script - Say Line 0\"),\r\n(@ENTRY,9,1,0,0,0,100,0,2000,2000,0,0,11,17550,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Mebok Mizzyrix - On Script - Cast 'Purification'\"),\r\n(@ENTRY,9,2,0,0,0,100,0,4000,4000,0,0,5,34,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Mebok Mizzyrix - On Script - Play Emote 34\"),\r\n(@ENTRY,9,3,0,0,0,100,0,4000,4000,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Mebok Mizzyrix - On Script - Say Line 1\");\r\n\r\n-- Actionlist SAI\r\nSET @ENTRY := 344601;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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,9,0,0,0,0,100,0,0,0,0,0,1,4,0,0,0,0,0,21,20,0,0,0,0,0,0,\"Mebok Mizzyrix - On Script - Say Line 4\"),\r\n(@ENTRY,9,1,0,0,0,100,0,2000,2000,0,0,69,0,0,0,0,0,0,8,0,0,0,-929.023,-3696.98,7.97395,1.7352,\"Mebok Mizzyrix - On Script - Move To Position\"),\r\n(@ENTRY,9,2,0,0,0,100,0,3000,3000,0,0,5,25,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Mebok Mizzyrix - On Script - Play Emote 25\"),\r\n(@ENTRY,9,3,0,0,0,100,0,3000,3000,0,0,69,0,0,0,0,0,0,8,0,0,0,-928.778,-3697.25,7.99705,6.17741,\"Mebok Mizzyrix - On Script - Move To Position\"),\r\n(@ENTRY,9,4,0,0,0,100,0,1000,1000,0,0,69,0,0,0,0,0,0,8,0,0,0,-928.982,-3697.23,8.06642,3.08923,\"Mebok Mizzyrix - On Script - Move To Position\");\r\n\r\nSET @ENTRY := 3446;\r\n\r\nDELETE FROM `creature_text` WHERE `entry`= @ENTRY;\r\nINSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES\r\n(@ENTRY,0,0,\"Now let's try it...\",   12,0,100, 7,0,0,2078,0,'Mebok Mizzyrix on Quest 865 rewarded'),\r\n(@ENTRY,1,0,\"Ugh!  That's terrible!\",12,0,100,33,0,0,2079,0,'Mebok Mizzyrix on Quest 865 rewarded');\r\n```"},"comment":{"url":"https://api.github.com/repos/dalaranwow/dalaran-wow/issues/comments/223770127","html_url":"https://github.com/dalaranwow/dalaran-wow/issues/3340#issuecomment-223770127","issue_url":"https://api.github.com/repos/dalaranwow/dalaran-wow/issues/3340","id":223770127,"user":{"login":"Golganeth","id":5057942,"avatar_url":"https://avatars.githubusercontent.com/u/5057942?v=3","gravatar_id":"","url":"https://api.github.com/users/Golganeth","html_url":"https://github.com/Golganeth","followers_url":"https://api.github.com/users/Golganeth/followers","following_url":"https://api.github.com/users/Golganeth/following{/other_user}","gists_url":"https://api.github.com/users/Golganeth/gists{/gist_id}","starred_url":"https://api.github.com/users/Golganeth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Golganeth/subscriptions","organizations_url":"https://api.github.com/users/Golganeth/orgs","repos_url":"https://api.github.com/users/Golganeth/repos","events_url":"https://api.github.com/users/Golganeth/events{/privacy}","received_events_url":"https://api.github.com/users/Golganeth/received_events","type":"User","site_admin":false},"created_at":"2016-06-04T18:16:12Z","updated_at":"2016-06-04T18:16:12Z","body":"Event is only triggered for 865, not 1221\r\n\r\n[20:14:45]Mebok Mizzyrix says: Now let's try it...\r\n[20:14:55]Mebok Mizzyrix says: Ugh!  That's terrible!\r\n\r\n1221 doesn't seem to trigger anything."}}
{"actor":{"display_login":"Golganeth"}}