-- "See to the Survivors"

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=46268;

DELETE FROM `smart_scripts` WHERE  `entryorguid`=46268;
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
(46268, 0, 0, 0, 8, 0, 100, 0, 86264, 0, 0, 0, 33, 46268, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Cast spell - give credit'),
(46268, 0, 1, 0, 8, 0, 100, 0, 86264, 0, 0, 0, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cast spell - despawn');

DELETE FROM `conditions` WHERE  `SourceEntry`=86264;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(17, 0, 86264, 0, 0, 31, 1, 3, 46268, 0, 0, 0, "", "cast spell doar pentru npc 46258");

-- "What's Left Behind"

UPDATE `creature_template` SET `exp`=2, `Health_mod`=110 WHERE  `entry`=42184;
UPDATE `creature_template` SET `lootid`=42184, `questItem1`=57987 WHERE  `entry`=42184;

DELETE FROM `creature_loot_template` WHERE  `entry`=42184 AND `item`=57987;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(42184, 57987, 89, 1, 0, 1, 1);

-- "No Tanks!"

UPDATE `creature_template` SET `npcflag`=0, `AIName`='SmartAI' WHERE `entry`=42224;

DELETE FROM `smart_scripts` WHERE  `entryorguid`=42224;
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
(42224, 0, 0, 1, 8, 0, 100, 1, 79751, 0, 100, 120, 33, 42224, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On Spell Hit - Give Kill Credit'),
(42224, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 37, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Spell Hit - Die');

DELETE FROM `conditions` WHERE  `SourceEntry`=79751;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(17, 0, 79751, 0, 0, 31, 1, 3, 42224, 0, 0, 0, "", "cast spell doar pentru npc 42224");

-- "Paint it Black"

UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=42291;

DELETE FROM `smart_scripts` WHERE  `entryorguid`=42291;
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
(42291, 0, 0, 1, 8, 0, 100, 0, 79781, 0, 0, 0, 33, 42796, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'On Spell Hit - Give Kill Credit'),
(42291, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 1000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'On Spell Hit - Despawn');