diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2014-08-21 22:37:00 +0100 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2014-08-21 22:37:00 +0100 |
| commit | a2365939a29bc0288b7667ac6004be114c852e8e (patch) | |
| tree | e901ea13e84f678387276b9b444bbed55ef0e27d /sql | |
| parent | b56229b18609b17241a1733efed8c09df7e5f6e9 (diff) | |
DB/SAI: Son of Cenarius
delete the permament spawns of Treant Ally at each Son of Cenarius and script Son of Cenerius to summon these using the proper spell.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2014_08_21_03_world_sai.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2014_08_21_03_world_sai.sql b/sql/updates/world/2014_08_21_03_world_sai.sql new file mode 100644 index 00000000000..cfc9aabbc95 --- /dev/null +++ b/sql/updates/world/2014_08_21_03_world_sai.sql @@ -0,0 +1,6 @@ +DELETE FROM `creature` WHERE `id`=5806; + +UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` =4057; +DELETE FROM `smart_scripts` WHERE `entryorguid` =4057 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 +(4057, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 7993, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Son of Cenarius - On Spawn - Cast Summon Treant Ally (Self)'); |