mangosR2/scriptdev2 — pull request #223 by Ulduar (2013-08-04 14:01:18+00:00)
Title: Create DB fix in Ulduar

-- Creature id: 33772

UPDATE creature_template SET AIName='EventAI' WHERE entry=33772;

DELETE FROM creature_ai_scripts WHERE creature_id=33772;

INSERT INTO creature_ai_scripts VALUES

('3377201','33772','0','0','100','7','6000','11000','13000','18000','11','64429','4','0','0','0','0','0','0','0','0','0','Faceless Horror - Cast Death Grip'),

('3377202','33772','0','0','100','7','6000','8000','8000','12000','11','63722','8','0','0','0','0','0','0','0','0','0','Faceless Horror - Cast Shadow Crash'),

('3377203','33772','0','0','100','7','15000','18000','25000','36000','11','63703','0','0','0','0','0','0','0','0','0','0','Faceless Horror - Cast Void Wave'),

('3377204','33772','2','0','100','6','40','0','0','0','11','63710','0','2','11','63708','0','6','0','0','0','0','Faceless Horror - Cast Void Barrier at 40% HP and summon Void Beast');

-- Script id: 33806

DELETE FROM dbscripts_on_creature_death WHERE id=33806;

INSERT INTO dbscripts_on_creature_death VALUES

(33806,1,15,63723,0,0,0,0,0,0,0,0,0,0,0,0,''),

(33806,1,14,63710,0,33772,50000,0,0,0,0,0,0,0,0,0,'');

-- Script id: 33136

DELETE FROM dbscripts_on_creature_death WHERE id=33136;

INSERT INTO dbscripts_on_creature_death VALUES

(33136,0,18,1000,0,0,0,0,0,0,0,0,0,0,0,0,'');

-- Script id: 33988

DELETE FROM dbscripts_on_creature_death WHERE id=33988;

INSERT INTO dbscripts_on_creature_death VALUES

(33988,0,18,1000,0,0,0,0,0,0,0,0,0,0,0,0,'');

DELETE FROM `spell_script_target` WHERE `entry` = 70079;

INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES

('62978', '1', '33292'); -- Summon Guardian Yogg-Saron