{"comment":{"created_at":"2011-10-12T22:33:11Z","body":"will work on it.","updated_at":"2011-10-12T22:33:11Z","url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/comments/2387863","id":2387863,"user":{"avatar_url":"https://secure.gravatar.com/avatar/db38caa9de45dd4e02fb9577e9461a9e?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/Kapoeira","id":563936,"login":"Kapoeira"}},"action":"created","issue":{"number":3402,"created_at":"2011-10-08T08:45:21Z","pull_request":{"diff_url":null,"patch_url":null,"html_url":null},"body":"```sql\r\n-- Fix quest Fires Over Skettis\r\nSET @TRIGGER := 22991;\r\nSET @EGG := 185549;\r\nSET @SKYBLAST := 39844;\r\n \r\n-- Old Unit flag was 33555200.\r\nUPDATE `creature_template` SET `AIName`= 'SmartAI',`unit_flags`=33554432 WHERE `entry`=@TRIGGER;\r\nUPDATE `gameobject_template` SET `AIName`= 'SmartGameObjectAI' WHERE `entry`=@EGG;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@TRIGGER AND `source_type`=0;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@EGG AND `source_type`=1;\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(@EGG,1,0,1, 8,0,100,0x01,@SKYBLAST,0,0,0,41,500,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Monstrous Kaliri Egg - On Skyguard Blasting Charge hit - Despawn'),\r\n(@TRIGGER,0,0,1,8,0,100,0x01,@SKYBLAST,0,0,0,33,@TRIGGER,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Monstrous Kaliri Egg Trigger - On Skyguard Blasting Charge hit - Give kill credit'),\r\n(@TRIGGER,0,1,0,61,0,100,0,0,0,0,0,41,500,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Monstrous Kaliri Egg Trigger - Linked event - Despawn after 500 ms');\r\n \r\nDELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=@SKYBLAST;\r\nINSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES\r\n(13,0,@SKYBLAST,0,18,0,@EGG,0,0,'', 'Skyguard Blasting Charge - Limit GO targets to Monstrous Kaliri Egg'),\r\n(13,0,@SKYBLAST,0,18,1,@TRIGGER,0,0,'', 'Skyguard Blasting Charge - Limit NPC targets to Monstrous Kaliri Egg Trigger');\r\n```\r\n\r\nTested, working as for the kill credit. Considering despawning the eggs","comments":4,"title":"[Quest/Fix] Fires Over Skettis","updated_at":"2011-10-12T22:33:11Z","url":"https://api.github.com/repos/TrinityCore/TrinityCore/issues/3402","id":1851649,"assignee":null,"milestone":null,"closed_at":null,"user":{"avatar_url":"https://secure.gravatar.com/avatar/db38caa9de45dd4e02fb9577e9461a9e?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","url":"https://api.github.com/users/Kapoeira","id":563936,"login":"Kapoeira"},"html_url":"https://github.com/TrinityCore/TrinityCore/issues/3402","labels":[],"state":"open"},"legacy":{"issue_id":1851649,"comment_id":2387863}}