TrinityCore/TrinityCore — Issue #3734: [DB/FIX]Citizen of New Avalon should cast 'Terrified!' when entering combat
Author: Valcorb
Created: 2011-10-28 22:18:20+00:00
State: open

Code:
```sql
-- Cast Terrified! when Citizen of New Avalon enters combat
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=28941;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=28942;
DELETE FROM `smart_scripts` WHERE `entryorguid` IN (28941, 28942);
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
(28941, 0, 0, 0, 4, 0, 100, 0, 0, 0, 0, 0, 11, 52716, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Citizen of New Avalon 1 - if enter combat - fear'),
(28942, 0, 0, 0, 4, 0, 100, 0, 0, 0, 0, 0, 11, 52716, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Citizen of New Avalon 2 - if enter combat - fear');
```