From 669b926b8b9c76dd29eaf54bc40afde5340d0b8f Mon Sep 17 00:00:00 2001 From: Gacko Date: Mon, 25 Feb 2013 17:04:08 +0100 Subject: DB/SAI: Convert EAI for Stormforged Eradictor Forgot to do so in cb99c1d16aef4f4fc000aff7aaa3f63fadf4e9ef --- sql/updates/world/2013_02_25_00_world_smart_scripts.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2013_02_25_00_world_smart_scripts.sql (limited to 'sql') diff --git a/sql/updates/world/2013_02_25_00_world_smart_scripts.sql b/sql/updates/world/2013_02_25_00_world_smart_scripts.sql new file mode 100644 index 00000000000..b1576d4189e --- /dev/null +++ b/sql/updates/world/2013_02_25_00_world_smart_scripts.sql @@ -0,0 +1,5 @@ +DELETE FROM `smart_scripts` WHERE `entryorguid`=29861 AND `source_type`=0; +INSERT INTO `smart_scripts`(`entryorguid`,`source_type`,`id`,`event_type`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`target_type`,`comment`) VALUES +(29861,0,0,54,0,0,0,0,80,2986100,2,1,'Stormforged Eradictor - Just summoned - Call timed actionlist 2986100'), +(29861,0,1,0,3000,7000,14000,18000,11,56352,0,2,'Stormforged Eradictor - Cast Storm Punch'), +(29861,0,2,0,9000,12000,13000,18000,11,15588,0,0,'Stormforged Eradictor - Cast Thunderclap'); -- cgit v1.2.3 From 48c83afb04ba47f334a3eccaf33e6ffc4d5197d8 Mon Sep 17 00:00:00 2001 From: Gacko Date: Mon, 25 Feb 2013 17:12:16 +0100 Subject: DB/SAI: ... and remove the EAI. --- sql/updates/world/2013_02_25_01_world_creature_ai_scripts.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2013_02_25_01_world_creature_ai_scripts.sql (limited to 'sql') diff --git a/sql/updates/world/2013_02_25_01_world_creature_ai_scripts.sql b/sql/updates/world/2013_02_25_01_world_creature_ai_scripts.sql new file mode 100644 index 00000000000..e095414552c --- /dev/null +++ b/sql/updates/world/2013_02_25_01_world_creature_ai_scripts.sql @@ -0,0 +1 @@ +DELETE FROM `creature_ai_scripts` WHERE `creature_id`=29861; -- cgit v1.2.3 From 4bdc9e6f1cf104fc8f09ab2d9e7c7832c012e2d5 Mon Sep 17 00:00:00 2001 From: Vincent_Michael Date: Mon, 25 Feb 2013 22:05:30 +0100 Subject: DB/Areatrigger: Update areatrigger_teleport cords for The Eye of Eternity entrance --- sql/updates/world/2013_02_25_02_world_areatrigger_teleport.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 sql/updates/world/2013_02_25_02_world_areatrigger_teleport.sql (limited to 'sql') diff --git a/sql/updates/world/2013_02_25_02_world_areatrigger_teleport.sql b/sql/updates/world/2013_02_25_02_world_areatrigger_teleport.sql new file mode 100644 index 00000000000..aa74fd46810 --- /dev/null +++ b/sql/updates/world/2013_02_25_02_world_areatrigger_teleport.sql @@ -0,0 +1 @@ +UPDATE `areatrigger_teleport` SET `target_position_x`=728.055,`target_position_y`= 1329.03,`target_position_z`=275,`target_orientation`=5.51524 WHERE `id`=5290; -- The Eye of Eternity (entrance) -- cgit v1.2.3