From 9a33c7236b473c5d03ff8c43bb920d9785cde4e5 Mon Sep 17 00:00:00 2001 From: offl Date: Fri, 18 Sep 2020 17:24:46 +0300 Subject: DB/Gameobject: Add more Calcified Elven Gem & adjust respawn time --- sql/updates/world/3.3.5/2020_09_18_02_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/3.3.5/2020_09_18_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2020_09_18_02_world.sql b/sql/updates/world/3.3.5/2020_09_18_02_world.sql new file mode 100644 index 00000000000..fc0b07fc58e --- /dev/null +++ b/sql/updates/world/3.3.5/2020_09_18_02_world.sql @@ -0,0 +1,10 @@ +-- Respawn time https://www.wowhead.com/object=2712/calcified-elven-gem#comments:id=363573 +UPDATE `gameobject` SET `spawntimesecs` = 20 WHERE `id` = 2712; +-- They should be pooled, also more of them should be spawned +DELETE FROM `gameobject` WHERE `guid` IN (30002,30010,30011,30019,30022) AND `id` = 2712; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(30002, 2712, 0, 1, 1, -2311.438, -1775.693, -38.39598, 2.879789, 0, 0, 0, 1, 20, 255, 1, 0), +(30010, 2712, 0, 1, 1, -2346.703, -1622.398, -32.72837, 0.2967052, 0, 0, 0, 1, 20, 255, 1, 0), +(30011, 2712, 0, 1, 1, -2143.996, -1674.242, -46.47116, 3.769912, 0, 0, 0, 1, 20, 255, 1, 0), +(30019, 2712, 0, 1, 1, -2224.817, -1608.232, -54.79397, 2.33873, 0, 0, 0.920504, 0.3907318, 20, 255, 1, 12340), +(30022, 2712, 0, 1, 1, -2263.765, -1499.152, -42.05137, -0.26179, 0, 0, -0.130525, 0.991444, 20, 255, 1, 12340); -- cgit v1.2.3