Scripts/Spells: Fixed Friend or Fowl achievement

3 files changed, 11 insertions, 0 deletions

diff --git a/sql/scripts/world_scripts_full.sql b/sql/scripts/world_scripts_full.sql
index 763ff8e3e8a..bad41ed0452 100644
--- a/sql/scripts/world_scripts_full.sql
+++ b/sql/scripts/world_scripts_full.sql
@@ -1892,6 +1892,7 @@ INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
 ( 69892, 'spell_generic_clone_weapon'),
 ( 57593, 'spell_generic_clone_weapon'),
 ( 52408, 'spell_gen_seaforium_blast'),
+( 25281, 'spell_gen_turkey_marker'),
 -- instances
 -- Black Temple
 ( 41475, 'spell_boss_lady_malande_shield'),
diff --git a/sql/updates/world/2011_05_07_00_world_sai.sql b/sql/updates/world/2011_05_07_00_world_sai.sql
new file mode 100644
index 00000000000..8f3ed2a213c
--- /dev/null
+++ b/sql/updates/world/2011_05_07_00_world_sai.sql
@@ -0,0 +1,7 @@
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (23801,24746,29594);
+
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (23801,24746,29594);
+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
+(23801,0,0,0,6,0,100,1,0,0,0,0,85,25281,2,0,0,0,0,7,0,0,0,0,0,0,0,'Turkey - Cast Marker on death'),
+(24746,0,0,0,6,0,100,1,0,0,0,0,85,25281,2,0,0,0,0,7,0,0,0,0,0,0,0,'Fjord Turkey - Cast Marker on death'),
+(29594,0,0,0,6,0,100,1,0,0,0,0,85,25281,2,0,0,0,0,7,0,0,0,0,0,0,0,'Angry Turkey - Cast Marker on death');
diff --git a/sql/updates/world/2011_05_07_00_world_spell_script_names.sql b/sql/updates/world/2011_05_07_00_world_spell_script_names.sql
new file mode 100644
index 00000000000..caa7d2a407c
--- /dev/null
+++ b/sql/updates/world/2011_05_07_00_world_spell_script_names.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_gen_turkey_marker';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(25281, 'spell_gen_turkey_marker');