From 9c2767b7f4c4bd9e954d3793b11c2bbcf7870b26 Mon Sep 17 00:00:00 2001
From: ZxBiohazardZx <zxbiohazardzx@gmail.com>
Date: Sat, 21 Jan 2012 13:41:16 +0100
Subject: DB/Creature: put proper spawns from sniff for 7th Legion Rifleman 
 and converted EAI to SAI

Should fix lagging of the Naxxramas area
---
 sql/updates/world/2012_01_21_00_world_creature.sql | 11 +++++++++++
 sql/updates/world/2012_01_21_00_world_sai.sql      | 11 +++++++++++
 2 files changed, 22 insertions(+)
 create mode 100644 sql/updates/world/2012_01_21_00_world_creature.sql
 create mode 100644 sql/updates/world/2012_01_21_00_world_sai.sql

(limited to 'sql')

diff --git a/sql/updates/world/2012_01_21_00_world_creature.sql b/sql/updates/world/2012_01_21_00_world_creature.sql
new file mode 100644
index 00000000000..8424969b9fb
--- /dev/null
+++ b/sql/updates/world/2012_01_21_00_world_creature.sql
@@ -0,0 +1,11 @@
+-- Spawns from sniff
+SET @GUID := 40279; -- set value 
+DELETE FROM `creature` WHERE `id`=27791;
+INSERT IGNORE INTO creature 
+ (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`MovementType`)
+ VALUES 
+(@GUID+0,27791,571,1,'0x00000001',0,0,3653.64233,-1204.21200,102.420319,4.04458666,120, 0, 0),
+(@GUID+1,27791,571,1,'0x00000001',0,0,3673.77515,-1213.68188,102.420319,4.08126450,120, 0, 0),
+(@GUID+2,27791,571,1,'0x00000001',0,0,3674.53735,-1175.28369,102.420288,1.78801400,120, 0, 0),
+(@GUID+3,27791,571,1,'0x00000001',0,0,3684.37158,-1180.27942,102.420288,1.22173047,120, 0, 0);
+
diff --git a/sql/updates/world/2012_01_21_00_world_sai.sql b/sql/updates/world/2012_01_21_00_world_sai.sql
new file mode 100644
index 00000000000..6d80bb4a853
--- /dev/null
+++ b/sql/updates/world/2012_01_21_00_world_sai.sql
@@ -0,0 +1,11 @@
+-- 7th Legion Rifleman SAI (replaces EAI)
+SET @ENTRY   := 27791; -- NPC entry
+SET @SPELL1  := 62312; -- Cast Net
+SET @SPELL2  := 50092; -- Cast Shoot
+UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=@ENTRY;
+DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@ENTRY;
+DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=@ENTRY;
+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
+(@ENTRY,0,0,0,4,0,100,0,0,0,0,0,11,@SPELL1,0,0,0,0,0,2,0,0,0,0,0,0,0,"7th Legion Rifleman - On Aggro - Cast Net"),
+(@ENTRY,0,1,0,0,0,100,0,500,3500,5000,6000,11,@SPELL2,0,0,0,0,0,2,0,0,0,0,0,0,0,"7th Legion Rifleman - In Combat - Cast Shoot"),
+(@ENTRY,0,2,0,2,0,100,1,0,15,0,0,25,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"7th Legion Rifleman - At 15% HP - Flee");
\ No newline at end of file
-- 
cgit v1.2.3