DB/Gameobject: Add more Calcified Elven Gem & adjust respawn time

(cherry picked from commit 9a33c7236b473c5d03ff8c43bb920d9785cde4e5)

1 files changed, 26 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_02_26_05_world_2020_09_18_02_world.sql b/sql/updates/world/master/2022_02_26_05_world_2020_09_18_02_world.sql
new file mode 100644
index 00000000000..ce27e72c1fe
--- /dev/null
+++ b/sql/updates/world/master/2022_02_26_05_world_2020_09_18_02_world.sql
@@ -0,0 +1,26 @@
+DELETE FROM `gameobject` WHERE `id`=2712;
+
+-- 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
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(16915, 2712, 0, '0', 0, -2278.12, -1764, -29.885, 0.349066, 0, 0, 0.173648, 0.984808, 20, 100, 1, 0),
+(16914, 2712, 0, '0', 0, -2208.79, -1749.48, -64.7426, 0.855211, 0, 0, 0.414693, 0.909961, 20, 100, 1, 0),
+(16795, 2712, 0, '0', 0, -2298.33, -1623.97, -65.0526, -2.00713, 0, 0, -0.843392, 0.537299, 20, 100, 1, 0),
+(15046, 2712, 0, '0', 0, -2292.4, -1676.4, -62.0808, -1.39626, 0, 0, -0.642786, 0.766046, 20, 100, 1, 0),
+(15042, 2712, 0, '0', 0, -2294.67, -1563.63, -39.7692, 2.40855, 0, 0, 0.93358, 0.35837, 20, 100, 1, 0),
+(30011, 2712, 0, '0', 0, -2144, -1674.24, -46.4712, 3.76991, 0, 0, 0, 1, 20, 255, 1, 0),
+(30010, 2712, 0, '0', 0, -2346.7, -1622.4, -32.7284, 0.296705, 0, 0, 0, 1, 20, 255, 1, 0),
+(30002, 2712, 0, '0', 0, -2311.44, -1775.69, -38.396, 2.87979, 0, 0, 0, 1, 20, 255, 1, 0),
+(30022, 2712, 0, '0', 0, -2263.76, -1499.15, -42.0514, -0.26179, 0, 0, -0.130525, 0.991444, 20, 255, 1, 12340),
+(30019, 2712, 0, '0', 0, -2224.82, -1608.23, -54.794, 2.33873, 0, 0, 0.920504, 0.390732, 20, 255, 1, 12340),
+(100066, 2712, 0, '0', 0, -2165.82, -1741.98, -52.3526, 2.80998, 0, 0, 0.986286, 0.165048, 20, 0, 1, 0);
+
+DELETE FROM `gameobject_addon` WHERE `guid` IN (16915, 16914, 16795, 15046, 15042, 30011, 30010, 30002, 30022, 30019, 100066);
+INSERT INTO `gameobject_addon` (`guid`, `parent_rotation0`, `parent_rotation1`, `parent_rotation2`, `parent_rotation3`, `invisibilityType`, `invisibilityValue`) VALUES
+(15042, 0, 0, 0.93358, 0.358368, 0, 0),
+(15046, 0, 0, 0.642788, -0.766044, 0, 0),
+(16795, 0, 0, 0.843391, -0.5373, 0, 0),
+(16914, 0, 0, 0.414693, 0.909961, 0, 0),
+(16915, 0, 0, 0.173648, 0.984808, 0, 0),
+(100066, 0, 0, 0.986286, 0.165048, 0, 0);