From b62ad5a955dfee690b7971b991e5ca692b7c2635 Mon Sep 17 00:00:00 2001 From: w1sht0l1v3 Date: Wed, 12 Sep 2012 06:15:50 +0300 Subject: Core/ToCr: Several fixes. Fix floor animation when destroyed. Add spawns for Highlord Tirion Fordring,Argent Mage and Portal to Dalaran. Remove Db spawn of Highlord Tirion Fordring. Correct tribute chest spawn location. Fix sql names for last commits. --- sql/updates/world/2012_09_10_14_world_misc.sql | 11 ----------- sql/updates/world/2012_09_10_15_world_misc.sql | 9 --------- sql/updates/world/2012_09_11_00_world_misc.sql | 11 +++++++++++ sql/updates/world/2012_09_12_00_world_misc.sql | 9 +++++++++ sql/updates/world/2012_09_12_01_world_creature.sql | 1 + 5 files changed, 21 insertions(+), 20 deletions(-) delete mode 100644 sql/updates/world/2012_09_10_14_world_misc.sql delete mode 100644 sql/updates/world/2012_09_10_15_world_misc.sql create mode 100644 sql/updates/world/2012_09_11_00_world_misc.sql create mode 100644 sql/updates/world/2012_09_12_00_world_misc.sql create mode 100644 sql/updates/world/2012_09_12_01_world_creature.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2012_09_10_14_world_misc.sql b/sql/updates/world/2012_09_10_14_world_misc.sql deleted file mode 100644 index 0f47f1bf2e9..00000000000 --- a/sql/updates/world/2012_09_10_14_world_misc.sql +++ /dev/null @@ -1,11 +0,0 @@ --- ToCr orbs - -SET @NPC_ORB1 := 34606; -- Frost Sphere -SET @NPC_ORB2 := 34649; -- Frost Sphere - -UPDATE `creature_template` SET `speed_walk`=1.2,`speed_run`=1.42,`InhabitType`=7 WHERE `entry` IN (@NPC_ORB1,@NPC_ORB2); - -DELETE FROM `creature_template_addon` WHERE `entry` IN (@NPC_ORB1,@NPC_ORB2); -INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`auras`) VALUES -(@NPC_ORB1,0,0x3000000,0x1,''), -(@NPC_ORB2,0,0x3000000,0x1,''); diff --git a/sql/updates/world/2012_09_10_15_world_misc.sql b/sql/updates/world/2012_09_10_15_world_misc.sql deleted file mode 100644 index 50896ce414c..00000000000 --- a/sql/updates/world/2012_09_10_15_world_misc.sql +++ /dev/null @@ -1,9 +0,0 @@ --- East Porticullis(195648): close and corrections -UPDATE `gameobject` SET `phaseMask`=1,`rotation2`=0.7071065,`rotation3`=0.707107,`spawntimesecs`=7200,`animprogress`=255,`state`=0 WHERE `guid`=151176; - --- North Portcullis(195650): delete extra spawn and corrections -DELETE FROM `gameobject` WHERE `guid`=150080; -UPDATE `gameobject` SET `phaseMask`=1,`rotation2`=0.7071065,`rotation3`=0.707107,`spawntimesecs`=7200,`animprogress`=255,`state`=1 WHERE `guid`=151178; - --- Web Door(195485): corrections -UPDATE `gameobject` SET `spawnMask`=15,`rotation2`=0.7071067,`rotation3`=0.7071068,`spawntimesecs`=7200,`animprogress`=255 WHERE `guid`=151192; diff --git a/sql/updates/world/2012_09_11_00_world_misc.sql b/sql/updates/world/2012_09_11_00_world_misc.sql new file mode 100644 index 00000000000..0f47f1bf2e9 --- /dev/null +++ b/sql/updates/world/2012_09_11_00_world_misc.sql @@ -0,0 +1,11 @@ +-- ToCr orbs + +SET @NPC_ORB1 := 34606; -- Frost Sphere +SET @NPC_ORB2 := 34649; -- Frost Sphere + +UPDATE `creature_template` SET `speed_walk`=1.2,`speed_run`=1.42,`InhabitType`=7 WHERE `entry` IN (@NPC_ORB1,@NPC_ORB2); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (@NPC_ORB1,@NPC_ORB2); +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`auras`) VALUES +(@NPC_ORB1,0,0x3000000,0x1,''), +(@NPC_ORB2,0,0x3000000,0x1,''); diff --git a/sql/updates/world/2012_09_12_00_world_misc.sql b/sql/updates/world/2012_09_12_00_world_misc.sql new file mode 100644 index 00000000000..50896ce414c --- /dev/null +++ b/sql/updates/world/2012_09_12_00_world_misc.sql @@ -0,0 +1,9 @@ +-- East Porticullis(195648): close and corrections +UPDATE `gameobject` SET `phaseMask`=1,`rotation2`=0.7071065,`rotation3`=0.707107,`spawntimesecs`=7200,`animprogress`=255,`state`=0 WHERE `guid`=151176; + +-- North Portcullis(195650): delete extra spawn and corrections +DELETE FROM `gameobject` WHERE `guid`=150080; +UPDATE `gameobject` SET `phaseMask`=1,`rotation2`=0.7071065,`rotation3`=0.707107,`spawntimesecs`=7200,`animprogress`=255,`state`=1 WHERE `guid`=151178; + +-- Web Door(195485): corrections +UPDATE `gameobject` SET `spawnMask`=15,`rotation2`=0.7071067,`rotation3`=0.7071068,`spawntimesecs`=7200,`animprogress`=255 WHERE `guid`=151192; diff --git a/sql/updates/world/2012_09_12_01_world_creature.sql b/sql/updates/world/2012_09_12_01_world_creature.sql new file mode 100644 index 00000000000..1b7fa2d78ef --- /dev/null +++ b/sql/updates/world/2012_09_12_01_world_creature.sql @@ -0,0 +1 @@ +DELETE FROM `creature` WHERE `id`=36095; -- cgit v1.2.3