DB/Misc: restore lost data

1 files changed, 15 insertions, 0 deletions

diff --git a/sql/updates/world/2013_06_21_00_world_creature.sql b/sql/updates/world/2013_06_21_00_world_creature.sql
new file mode 100644
index 00000000000..7749b46d5e4
--- /dev/null
+++ b/sql/updates/world/2013_06_21_00_world_creature.sql
@@ -0,0 +1,15 @@
+-- Restore Lost Data
+DELETE FROM `creature_addon` WHERE `guid` IN (14448,14449,14456,14458,14459);
+INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES 
+(14448,144480,1,0, '22766'),
+(14449,144490,1,0, '22766'),
+(14456,144560,1,0, '22766'),
+(14458,144580,1,0, '22766'),
+(14459,144590,1,0, '22766');
+
+DELETE FROM `creature_template_addon` WHERE `entry`=3457;
+INSERT INTO `creature_template_addon` (`entry`,`path_id`,`bytes2`,`mount`,`auras`) VALUES
+(3457,0,1,0, '22766');
+
+-- Fix respawn for Steelforged Defenders at Ulduar
+UPDATE `creature` SET `spawntimesecs`=7200 WHERE (`id`=33236);