[DB/Quest][12758][A Hero's Headgear] #9452

Closed
untaught opened this Issue Mar 17, 2013 · 4 comments

Comments

Projects
None yet
4 participants
Contributor

untaught commented Mar 17, 2013

Fix for the quest A Hero's Headgear.

Quest: http://www.wowhead.com/quest=12758
Stormwatcher's Head GO: http://www.wowhead.com/object=191179
Spell which summons Stormwatcher's Head: http://www.wowhead.com/spell=53162

UPDATE `creature_template` SET `ainame`='SmartAI',`scriptname`='' WHERE `entry`=28877;
DELETE FROM `creature_ai_scripts` WHERE `creature_id`=28877;
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `sourceentry`=53145;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(17,0,53145,0,0,31,1,3,28877,0,0,0,0,'', 'Set Stormwatcher as item requred target'),
(17,0,53145,0,0,36,1,0,0,0,1,0,0,'', 'Target need to be dead');
DELETE FROM `smart_scripts` WHERE `entryorguid`=28877 AND `source_type`=0;
INSERT 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
(28877,0,0,0,0,0,100,0,3000,5000,3000,5000,11,32018,0,0,0,0,0,2,0,0,0,0,0,0,0, 'Stormwatcher - In Combat - Cast Call Lightning'),
(28877,0,1,2,8,0,100,0,53145,0,0,0,11,53162,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Stormwatcher - On Spell Hit - Summon Stormwatcher''s Head' ),
(28877,0,2,0,61,0,100,0,0,0,0,0,44,2,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Stormwatcher - Link With Event 1 - Change Ingame Phase Mask to 2');

Gacko was assigned Mar 17, 2013

Nevadas commented Mar 25, 2013

Works fine! Thx!

Member

Gacko commented Mar 26, 2013

Thanks for testing, I will push it later...

@Gacko Gacko added a commit that referenced this issue Mar 26, 2013

@Gacko Gacko SAI/Quest: A Hero's Headgear (Thanks @untaught)
Solves: #9452
b788856
Contributor

Subv commented Mar 26, 2013

Subv closed this Mar 26, 2013

Member

Gacko commented Mar 26, 2013

Thanks Subv! Please do not forget e635ba5 if you are planning to pick this single fix.

... if someone could re-implement the close annotation in commits... that would be great.

@raczman raczman pushed a commit to raczman/TrinityCore that referenced this issue Apr 20, 2014

@Gacko Gacko SAI/Quest: A Hero's Headgear (Thanks @untaught)
Solves: #9452
fdb534b
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment