{"issue":{"state":"closed","created_at":"2011-07-18T15:35:12Z","updated_at":"2011-11-24T22:45:05Z","user":{"gravatar_id":"ebb5e4a8258afc76638959c8fe85375d","id":902450,"url":"https://api.github.com/users/theblast","login":"theblast","avatar_url":"https://secure.gravatar.com/avatar/ebb5e4a8258afc76638959c8fe85375d?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"comments":6,"body":"Линк - http://www.wowhead.com/quest=12049\r\nЛинк към клипче как се минава - http://www.youtube.com/watch?v=E21LKCT_xSQ\r\nТябва да се съберат 6 Seared Jormungar Meat (http://www.wowhead.com/item=36731), те са в Jormungar Meat (http://www.wowhead.com/object=188434), което се получава при взривяването на Hulking Jormungar (http://www.wowhead.com/npc=26293) с Potent Explosive Charges (http://www.wowhead.com/item=36732). Експлозивът трябва да се хвърли в устата на червея, когато си я отвори (цитат от wowhead: The time that you throw the explosive into the Jormungar's mouth is when it does an emote: \"The Hulking Jormungar falters for a moment, opening its mouth wide.\"). Проблемът е, че тук Hulking Jormungar не си отваря устата, а Potent Explosive Charges може да се хвърли по всяко време, но не взривява червея (всъщност при натискане върху иконката на Potent Explosive Charges се активира само cooldown-a на предмета без други видими индикации, та не знам дали въобще работи).","assignee":null,"id":1242404,"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"labels":[{"name":"Quests","color":"ededed","url":"https://api.github.com/repos/DragonFire/Dragon/labels/Quests"}],"number":97,"title":"[Hard to Swallow] - Quest - B - #12049","closed_at":"2011-11-23T17:54:11Z","html_url":"https://github.com/DragonFire/Dragon/issues/97","url":"https://api.github.com/repos/DragonFire/Dragon/issues/97","milestone":null},"action":"created","comment":{"created_at":"2011-11-24T22:45:05Z","updated_at":"2011-11-24T22:45:05Z","user":{"gravatar_id":"8f4ba659ea739a1d13f4a866e13042f5","id":937520,"url":"https://api.github.com/users/nelegalno","login":"nelegalno","avatar_url":"https://secure.gravatar.com/avatar/8f4ba659ea739a1d13f4a866e13042f5?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"body":"bongobg, колко пъти трябва да ти посоча къде се намира кода който оправя quest-a да работи както трябва (blizzlike) преди да го видиш??? Ако и това долу не ти е достатъчно вече назнам какво да направя:\r\n\r\n```SQL\r\n-- [Q] Hard to Swallow\r\n\r\n-- Hulking Jormungar SAI\r\nSET @ENTRY := 26293;\r\nSET @SPELL_CORROSIVE_POISON := 50293;\r\nSET @SPELL_GRENADE := 47305;\r\nSET @SPELL_EXPLOSION := 47311;\r\nUPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;\r\nDELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ENTRY,@ENTRY*100,@ENTRY*100+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(@ENTRY,0,0,0,0,0,100,0,6000,7000,11000,13000,11,@SPELL_CORROSIVE_POISON,0,0,0,0,0,2,0,0,0,0,0,0,0,\"Hulking Jormungar - In Combat - Cast Corrode Flesh\"),\r\n(@ENTRY,0,1,0,2,0,100,1,0,80,0,0,80,@ENTRY*100,0,2,0,0,0,1,0,0,0,0,0,0,0,\"Hulking Jormungar - At 80% HP - Run Script\"),\r\n(@ENTRY*100,9,0,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,2,0,0,0,0,0,0,0,\"Hulking Jormungar - On Script - Say Line 0\"),\r\n(@ENTRY*100,9,1,0,0,0,100,0,0,0,0,0,22,1,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Hulking Jormungar - On Script - Set Phase 1\"),\r\n(@ENTRY*100,9,2,0,0,0,100,0,5000,5000,0,0,22,0,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Hulking Jormungar - On Script - Set Phase 0\"),\r\n(@ENTRY,0,2,0,8,1,100,0,@SPELL_GRENADE,0,0,0,80,@ENTRY*100+1,0,2,0,0,0,1,0,0,0,0,0,0,0,\"Hulking Jormungar - On Spellhit (P1) - Run Script\"),\r\n(@ENTRY*100+1,9,0,0,0,0,100,0,3000,3000,0,0,11,@SPELL_EXPLOSION,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Hulking Jormungar - On Script - Cast Quest - Jormungar Explosion Spell Spawner\"),\r\n(@ENTRY*100+1,9,1,0,0,0,100,0,0,0,0,0,37,0,0,0,0,0,0,1,0,0,0,0,0,0,0,\"Hulking Jormungar - On Script - Die\");\r\n\r\n-- Text\r\nDELETE FROM `creature_text` WHERE `entry`=@ENTRY;\r\nINSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES\r\n(@ENTRY,0,0,\"The Hulking Jormungar falters for a moment, opening its mouth wide.\",41,0,100,0,0,0,\"Hulking Jormungar\");\r\n\r\n-- Potent Explosive Charge conditions\r\nDELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=@SPELL_GRENADE;\r\nINSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES\r\n(13,0,@SPELL_GRENADE,0,18,1,@ENTRY,0,0,'',\"Potent Explosive Charge only targets Hulking Jormungar\"),\r\n(13,0,@SPELL_GRENADE,0,20,80,0,0,0,'',\"Potent Explosive Charge requires target to be below 80% HP\");\r\n\r\n-- Quest - Jormungar Explosion Spell Spawner triggers the meat throw spells\r\nDELETE FROM `spell_linked_spell` WHERE `spell_trigger`=@SPELL_EXPLOSION;\r\nINSERT INTO `spell_linked_spell` (`spell_trigger`,`spell_effect`,`type`,`comment`) VALUES\r\n(@SPELL_EXPLOSION,47925,0,\"Quest - Jormungar Explosion Spell Spawner triggers Quest - Jormungar Explosion Summon Object\"),\r\n(@SPELL_EXPLOSION,47924,0,\"Quest - Jormungar Explosion Spell Spawner triggers Quest - Jormungar Explosion Summon Object\"),\r\n(@SPELL_EXPLOSION,47309,0,\"Quest - Jormungar Explosion Spell Spawner triggers Quest - Jormungar Explosion Summon Object\");\r\n\r\n-- Jormungar Meat SAI\r\nSET @ENTRY := 26699;\r\nUPDATE `creature_template` SET `AIname`='SmartAI',`unit_flags`=`unit_flags`|33554432,`flags_extra`=`flags_extra`|128 WHERE `entry`=@ENTRY;\r\nDELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY;\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,54,0,100,0,0,0,0,0,50,188434,120000,0,0,0,0,1,0,0,0,0,0,0,0,\"Jormungar Meat - Just Summoned - Summon Jormungar Meat\");\r\n\r\n-- Give Jormungar Meat quest item loot\r\nDELETE FROM `gameobject_loot_template` WHERE `entry`=23442;\r\nINSERT INTO `gameobject_loot_template` (`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES\r\n(23442,36731,-100,1,0,1,1);\r\n```","id":2869783,"url":"https://api.github.com/repos/DragonFire/Dragon/issues/comments/2869783"}}