From 73623d5dcd703cf88117e51b0b302eb90e04efc7 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Mon, 27 Apr 2015 18:09:54 +0100 Subject: DB/Gameobject: Serpentshrine Cavern Missing GO spawns from Serpentshrine Cavern Including the objects for Vjash's bridge, @Kittnz will push fix to cpp script to make this work properly as even though this was already scripted (but no gos, there was still slight issue with existing cpp script (ie activating same part of bridge 3 times instead of all 3 parts. (cherry picked from commit 192ba1f4a7d5daa63d49c548981de203371d36ba) --- .../world/2015_11_01_06_world_2015_04_27_00.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/world/2015_11_01_06_world_2015_04_27_00.sql (limited to 'sql') diff --git a/sql/updates/world/2015_11_01_06_world_2015_04_27_00.sql b/sql/updates/world/2015_11_01_06_world_2015_04_27_00.sql new file mode 100644 index 00000000000..53b3b686ec2 --- /dev/null +++ b/sql/updates/world/2015_11_01_06_world_2015_04_27_00.sql @@ -0,0 +1,19 @@ +SET @OGUID := 29765; + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+9 AND `id` IN(184203,184204,184205,185114,185115,185117,185118,184566,184567,184568); +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID+0, 184203, 548, 3, 169, 26.32847, -654.4946, 15.47422, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- 184203 (Area: 0) +(@OGUID+1, 184204, 548, 3, 169, 26.32847, -654.4946, 15.47422, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- 184204 (Area: 0) +(@OGUID+2, 184205, 548, 3, 169, 26.32847, -654.4946, 15.47422, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- 184205 (Area: 0) +(@OGUID+3, 185114, 548, 3, 169, 457.4108, -555.2696, -6.996453, 1.832595, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 185114 (Area: 0) +(@OGUID+4, 185115, 548, 3, 169, 373.1394, -465.1063, 30.71642, 3.228859, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 185115 (Area: 0) +(@OGUID+5, 185117, 548, 3, 169, -245.7294, -381.393, -0.187039, 2.879789, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 185117 (Area: 0) +(@OGUID+6, 185118, 548, 3, 169, 123.2582, -432.3567, -1.196554, 4.799657, 0, 0, 1, -4.371139E-08, 7200, 255, 0), -- 185118 (Area: 0) +(@OGUID+7, 184566, 530, 1, 169, 811.1944, 6872.574, -66.931, 0, 0, 0, 1, -4.371139E-08, 120, 255, 1), -- 184566 (Area: 3905) +(@OGUID+8, 184567, 530, 1, 169, 811.1944, 6859.181, -66.931, 3.141593, 0, 0, 1, -4.371139E-08, 120, 255, 1), -- 184567 (Area: 3905) +(@OGUID+9, 184568, 548, 3, 169, 47.75674, -581.8289, 4.655592, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1); -- 184568 (Area: 0) + +UPDATE `gameobject_template` SET `faction`=1375, `flags`=32 WHERE `entry`IN(184203,184204,184205); +UPDATE `gameobject_template` SET `flags`=16 WHERE `entry`IN(185114,185115,185117,185118); +UPDATE `gameobject_template` SET `flags`=2 WHERE `entry`=184566; +UPDATE `gameobject_template` SET `flags`=32 WHERE `entry`=184568; -- cgit v1.2.3