From ee623a4006009e729ed4cfdd36aa9bb1525d72a9 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Sun, 19 Oct 2014 20:27:49 +0100 Subject: DB/Gameobject: Everfrost Chip Additional spawns of http://www.wowhead.com/object=193997 Everfrost Chip on top of the 2 already in db. --- sql/updates/world/2014_10_19_01_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/2014_10_19_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_10_19_01_world.sql b/sql/updates/world/2014_10_19_01_world.sql new file mode 100644 index 00000000000..a9a53a9afe6 --- /dev/null +++ b/sql/updates/world/2014_10_19_01_world.sql @@ -0,0 +1,10 @@ +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+7 AND `id`=193997; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID+0, 193997, 571, 1, 1, 7330.436, -2212.682, 800.4834, 4.258607, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67) +(@OGUID+1, 193997, 571, 1, 1, 7211.499, -2373.856, 781.449, 4.380776, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67) +(@OGUID+2, 193997, 571, 1, 1, 6973.803, -2096.827, 777.6375, 3.263772, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67) +(@OGUID+3, 193997, 571, 1, 1, 7310.712, -2812.066, 798.081, 1.570796, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67) +(@OGUID+4, 193997, 571, 1, 1, 7301.006, -2746.12, 749.5085, 0.157079, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67) +(@OGUID+5, 193997, 571, 1, 1, 7550.374, -3154.98, 840.1462, 4.415683, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67) +(@OGUID+6, 193997, 571, 1, 1, 7177.287, -3071.111, 862.2982, 0.6806767, 0, 0, 0, 1, 120, 255, 1), -- 193997 (Area: 67) +(@OGUID+7, 193997, 571, 1, 1, 7694.284, -3154.72, 869.7686, 3.769912, 0, 0, 0, 1, 120, 255, 1); -- 193997 (Area: 67) -- cgit v1.2.3