Core/OutdoorPvP: Move remaining outdoorpvp spawns to db

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_07_18_03_world.sql b/sql/updates/world/master/2022_07_18_03_world.sql
new file mode 100644
index 00000000000..a59e1ce4a70
--- /dev/null
+++ b/sql/updates/world/master/2022_07_18_03_world.sql
@@ -0,0 +1,13 @@
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 23303 AND 23313;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnDifficulties`, `phaseUseFlags`, `PhaseId`, `PhaseGroup`, `terrainSwapMap`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `ScriptName`, `VerifiedBuild`) VALUES
+(23303, 183104, 530, 0, 0, '0', 0, 0, 0, -1, -3081.65, 5335.03, 17.1853, -2.146750, 0, 0, 0.878817, -0.477159, 0, 0, 1, '', 0),
+(23304, 183411, 530, 0, 0, '0', 0, 0, 0, -1, -2939.90, 4788.73, 18.9870, 2.775070, 0, 0, 0.983255, 0.182236, 0, 0, 1, '', 0),
+(23305, 183412, 530, 0, 0, '0', 0, 0, 0, -1, -3174.94, 4440.97, 16.2281, 1.867500, 0, 0, 0.803857, 0.594823, 0, 0, 1, '', 0),
+(23306, 183413, 530, 0, 0, '0', 0, 0, 0, -1, -3603.31, 4529.15, 20.9077, 0.994838, 0, 0, 0.477159, 0.878817, 0, 0, 1, '', 0),
+(23307, 183414, 530, 0, 0, '0', 0, 0, 0, -1, -3812.37, 4899.30, 17.7249, 0.087266, 0, 0, 0.043619, 0.999048, 0, 0, 1, '', 0),
+(23308, 182175, 530, 0, 0, '0', 0, 0, 0, -1, -471.462, 3451.09, 34.6432, 0.174533, 0, 0, 0.087156, 0.996195, 0, 0, 1, '', 0),
+(23309, 182174, 530, 0, 0, '0', 0, 0, 0, -1, -184.889, 3476.93, 38.2050, -0.017453, 0, 0, 0.008727, -0.999962, 0, 0, 1, '', 0),
+(23310, 182173, 530, 0, 0, '0', 0, 0, 0, -1, -290.016, 3702.42, 56.6729, 0.034907, 0, 0, 0.017452, 0.999848, 0, 0, 1, '', 0),
+(23311, 183514, 530, 0, 0, '0', 0, 0, 0, -1, -467.078, 3528.17, 64.7121, 3.14159, 0, 0, 1.000000, 0.000000, 0, 0, 1, '', 0),
+(23312, 182525, 530, 0, 0, '0', 0, 0, 0, -1, -187.887, 3459.38, 60.0403, -3.12414, 0, 0, 0.999962, -0.008727, 0, 0, 1, '', 0),
+(23313, 183515, 530, 0, 0, '0', 0, 0, 0, -1, -289.610, 3696.83, 75.9447, 3.12414, 0, 0, 0.999962, 0.008727, 0, 0, 1, '', 0);