Флудо-баг-репорты в одной теме (часть четвертая)

[MENZ411]

часть 2-я

UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=61314, `action_param2`=0 WHERE  `entryorguid`=15274 AND `source_type`=0 AND `id`=0 AND `link`=0;
UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=61314, `action_param2`=0 WHERE  `entryorguid`=15274 AND `source_type`=0 AND `id`=1 AND `link`=0;
UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=61314, `action_param2`=0 WHERE  `entryorguid`=15274 AND `source_type`=0 AND `id`=2 AND `link`=0;
UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=61314, `action_param2`=0 WHERE  `entryorguid`=15274 AND `source_type`=0 AND `id`=3 AND `link`=0;
UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=61314, `action_param2`=0 WHERE  `entryorguid`=15274 AND `source_type`=0 AND `id`=4 AND `link`=0;

DELETE FROM `conditions` WHERE  `SourceTypeOrReferenceId`=22 AND `SourceGroup`=7 AND `SourceEntry`=23219 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=29 AND `ConditionTarget`=0 AND `ConditionValue1`=23439 AND `ConditionValue2`=15 AND `ConditionValue3`=0;
UPDATE `smart_scripts` SET `event_type`=11, `event_param2`=0, `action_param2`=0 WHERE  `entryorguid`=23219 AND `source_type`=0 AND `id`=1 AND `link`=0;
UPDATE `smart_scripts` SET `action_type`=45, `action_param1`=1, `action_param2`=1, `target_type`=19, `target_param1`=23439, `target_param2`=10, `comment`='Blackwind Warp Chaser - On Death - Set Data on Hungry Nether Ray' WHERE  `entryorguid`=23219 AND `source_type`=0 AND `id`=6 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=23219 AND `source_type`=0 AND `id`=2 AND `link`=0;
DELETE FROM `smart_scripts` WHERE  `entryorguid`=23219 AND `source_type`=0 AND `id`=5 AND `link`=0;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE  `entry`=23439;
INSERT INTO `smart_scripts` VALUES 
(23439, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 11, 41427, 0, 0, 0, 0, 0, 21, 10, 0, 0, 0, 0, 0, 0, 'Hungry Nether Ray - On Data Set - Cast on Master');

DELETE FROM `smart_scripts` WHERE  `entryorguid`=23652 AND `source_type`=0 AND `id`=0 AND `link`=0;
UPDATE `creature_template` SET `AIName`='' WHERE  `entry`=23652;

UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=43341 WHERE  `entryorguid`=23678 AND `source_type`=0 AND `id`=6 AND `link`=7;

#UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=43174 WHERE  `entryorguid`=23689 AND `source_type`=0 AND `id`=2 AND `link`=0;
#UPDATE `smart_scripts` SET `action_type`=11, `action_param1`=43174 WHERE  `entryorguid`=24170 AND `source_type`=0 AND `id`=1 AND `link`=0;

DELETE FROM `smart_scripts` WHERE  `entryorguid`=24108 AND `source_type`=0 AND `id`=0 AND `link`=0;
UPDATE `creature_template` SET `AIName`='' WHERE  `entry`=24108;