DB/Misc: Sync 6.x gameobject spawns with 3.3.5a

1 files changed, 115 insertions, 0 deletions

diff --git a/sql/updates/world/2016_01_22_01_world.sql b/sql/updates/world/2016_01_22_01_world.sql
new file mode 100644
index 00000000000..657b58c150d
--- /dev/null
+++ b/sql/updates/world/2016_01_22_01_world.sql
@@ -0,0 +1,115 @@
+--
+DELETE FROM `gameobject` WHERE `guid` =6008;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(6008, 186487, 571, 0, 0, 1, 1, 2821.75, -3603.67, 245.555, 3.49556, 0, 0, 0.984379, -0.176061, -300, 0, 1, 0);
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 14830 AND 14835;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(14830, 186959, 571, 0, 0, 1, 1, 276.169, -5755.25, 268.456, 0, 0, 0, 0, 1, 120, 255, 1, 0),
+(14831, 186959, 571, 0, 0, 1, 1, 278.529, -5758.35, 268.456, 0, 0, 0, 0, 1, 120, 255, 1, 0),
+(14832, 186959, 571, 0, 0, 1, 1, 280.852, -5761.4, 268.456, 0, 0, 0, 0, 1, 120, 255, 1, 0),
+(14833, 186959, 571, 0, 0, 1, 1, 158.707, -5823.32, 7.00682, 0, 0, 0, 0, 1, 120, 255, 1, 0),
+(14834, 186959, 571, 0, 0, 1, 1, 157.202, -5712.16, 189.315, 0, 0, 0, 0, 1, 120, 255, 1, 0),
+(14835, 186959, 571, 0, 0, 1, 1, 255.534, -5891.36, 82.9929, 0, 0, 0, 0, 1, 120, 255, 1, 0);
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 66937 AND 66963;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(66937, 187567, 530, 0, 0, 1, 1, 9757.14, -7186.15, 23.5062, 2.89724, 0, 0, 0, 1, 120, 255, 1, 0),
+(66938, 187567, 530, 0, 0, 1, 1, 9799.12, -7310.61, 35.2336, 2.19912, 0, 0, 0, 1, 120, 255, 1, 0),
+(66939, 187567, 530, 0, 0, 1, 1, 9790.95, -7316.39, 35.2356, 2.23402, 0, 0, 0, 1, 120, 255, 1, 0),
+(66940, 187567, 530, 0, 0, 1, 1, 9752.51, -7336.51, 34.976, 1.91986, 0, 0, 0, 1, 120, 255, 1, 0),
+(66941, 187567, 530, 0, 0, 1, 1, 9724.5, -7346.25, 34.9555, 1.91986, 0, 0, 0, 1, 120, 255, 1, 0),
+(66942, 187567, 530, 0, 0, 1, 1, 9743.4, -7339.75, 34.9457, 1.90241, 0, 0, 0, 1, 120, 255, 1, 0),
+(66943, 187567, 530, 0, 0, 1, 1, 9734.03, -7343.02, 35.0236, 1.90241, 0, 0, 0, 1, 120, 255, 1, 0),
+(66944, 187567, 530, 0, 0, 1, 1, 9767.38, -7480.58, 28.1816, 3.194, 0, 0, 0, 1, 120, 255, 1, 0),
+(66945, 187567, 530, 0, 0, 1, 1, 9767.38, -7495.05, 28.2891, 3.05433, 0, 0, 0, 1, 120, 255, 1, 0),
+(66946, 187567, 530, 0, 0, 1, 1, 9694.37, -7495.96, 25.6203, 1.6057, 0, 0, 0, 1, 120, 255, 1, 0),
+(66947, 187567, 530, 0, 0, 1, 1, 9683.36, -7495.41, 26.9979, 1.53589, 0, 0, 0, 1, 120, 255, 1, 0),
+(66948, 187567, 530, 0, 0, 1, 1, 9638.37, -7397.28, 22.6856, 4.7822, 0, 0, 0, 1, 120, 255, 1, 0),
+(66949, 187567, 530, 0, 0, 1, 1, 9672.39, -7495.99, 25.6702, 1.53589, 0, 0, 0, 1, 120, 255, 1, 0),
+(66950, 187567, 530, 0, 0, 1, 1, 9648.39, -7152.3, 23.2634, 1.5708, 0, 0, 0, 1, 120, 255, 1, 0),
+(66951, 187567, 530, 0, 0, 1, 1, 9665.87, -7135.83, 23.1602, 3.10665, 0, 0, 0, 1, 120, 255, 1, 0),
+(66952, 187567, 530, 0, 0, 1, 1, 9631.14, -7135.58, 23.118, 6.26573, 0, 0, 0, 1, 120, 255, 1, 0),
+(66953, 187567, 530, 0, 0, 1, 1, 9648.53, -7119.09, 23.2984, 4.72984, 0, 0, 0, 1, 120, 255, 1, 0),
+(66954, 187567, 530, 0, 0, 1, 1, 9485.03, -7132.4, 24.4308, 0, 0, 0, 0, 1, 120, 255, 1, 0),
+(66955, 187194, 530, 0, 0, 1, 1, 9955, -7098.57, 59.8619, 3.99681, 0, 0, 0, 1, 120, 255, 1, 0),
+(66956, 187194, 530, 0, 0, 1, 1, 10007.3, -7030.9, 57.9729, 4.06662, 0, 0, 0, 1, 120, 255, 1, 0),
+(66957, 187194, 530, 0, 0, 1, 1, 10002.2, -7202.47, 44.0678, 1.46608, 0, 0, 0, 1, 120, 255, 1, 0),
+(66958, 187194, 530, 0, 0, 1, 1, 10010.7, -7199.17, 44.221, 2.47837, 0, 0, 0, 1, 120, 255, 1, 0),
+(66959, 187194, 530, 0, 0, 1, 1, 9992.33, -7205.06, 44.0625, 2.18166, 0, 0, 0, 1, 120, 255, 1, 0),
+(66960, 187194, 530, 0, 0, 1, 1, 9952.42, -7232.27, 43.9028, 2.23402, 0, 0, 0, 1, 120, 255, 1, 0),
+(66961, 187194, 530, 0, 0, 1, 1, 9945.5, -7242.05, 43.9058, 2.79252, 0, 0, 0, 1, 120, 255, 1, 0),
+(66962, 187235, 530, 0, 0, 1, 1, 9982.97, -7098.83, 47.705, 6.05629, 0, 0, 0, 1, 120, 255, 1, 0),
+(66963, 187235, 530, 0, 0, 1, 1, 9987.12, -7093.6, 47.705, 5.25344, 0, 0, 0, 1, 120, 255, 1, 0);
+
+DELETE FROM `gameobject` WHERE `guid` BETWEEN 79521 AND 79583;
+INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
+(79521, 187567, 530, 0, 0, 1, 1, -690.793, 2724.94, 100.929, 6.26573, 0, 0, 0, 1, 120, 255, 1, 0),
+(79522, 178425, 530, 0, 0, 1, 1, -3949.44, -11658.7, -138.711, 3.14159, 0, 0, 0, 1, 120, 255, 1, 0),
+(79523, 178746, 530, 0, 0, 1, 1, -3954.36, -11657.6, -138.704, 2.51327, 0, 0, 0, 1, 120, 255, 1, 0),
+(79524, 178428, 530, 0, 0, 1, 1, -3951.38, -11661.3, -138.977, 0.750491, 0, 0, 0, 1, 120, 255, 1, 0),
+(79525, 178428, 530, 0, 0, 1, 1, -3953.23, -11658.6, -138.758, 2.42601, 0, 0, 0, 1, 120, 255, 1, 0),
+(79526, 178428, 530, 0, 0, 1, 1, -3951.49, -11658.7, -138.743, 4.67748, 0, 0, 0, 1, 120, 255, 1, 0),
+(79527, 178429, 530, 0, 0, 1, 1, -3950.01, -11652.9, -138.642, 5.35816, 0, 0, 0, 1, 120, 255, 1, 0),
+(79528, 178429, 530, 0, 0, 1, 1, -3950.75, -11660.4, -138.764, 5.65487, 0, 0, 0, 1, 120, 255, 1, 0),
+(79529, 178430, 530, 0, 0, 1, 1, -3952.52, -11660.6, -138.769, 3.38594, 0, 0, 0, 1, 120, 255, 1, 0),
+(79530, 178430, 530, 0, 0, 1, 1, -3949.49, -11654, -138.634, 1.95477, 0, 0, 0, 1, 120, 255, 1, 0),
+(79531, 178430, 530, 0, 0, 1, 1, -3951.28, -11659.1, -138.332, 1.0472, 0, 0, 0, 1, 120, 255, 1, 0),
+(79532, 178431, 530, 0, 0, 1, 1, -3952.4, -11660.7, -138.465, 2.42601, 0, 0, 0, 1, 120, 255, 1, 0),
+(79533, 178431, 530, 0, 0, 1, 1, -3950.72, -11659.4, -138.947, 1.13446, 0, 0, 0, 1, 120, 255, 1, 0),
+(79534, 178432, 530, 0, 0, 1, 1, -3950.49, -11661.7, -138.98, 6.07375, 0, 0, 0, 1, 120, 255, 1, 0),
+(79535, 178432, 530, 0, 0, 1, 1, -3951.25, -11654.2, -138.652, 4.46804, 0, 0, 0, 1, 120, 255, 1, 0),
+(79536, 178432, 530, 0, 0, 1, 1, -3952.46, -11659, -138.753, 2.70526, 0, 0, 0, 1, 120, 255, 1, 0),
+(79537, 178433, 530, 0, 0, 1, 1, -3949.59, -11660.9, -138.969, 4.92183, 0, 0, 0, 1, 120, 255, 1, 0),
+(79538, 178433, 530, 0, 0, 1, 1, -3953.01, -11659.6, -138.762, 1.81514, 0, 0, 0, 1, 120, 255, 1, 0),
+(79539, 178433, 530, 0, 0, 1, 1, -3950.47, -11653.6, -138.645, 4.01426, 0, 0, 0, 1, 120, 255, 1, 0),
+(79540, 187567, 530, 0, 0, 1, 1, -4213.73, -11685.4, -130.823, 0.942477, 0, 0, 0, 1, 120, 255, 1, 0),
+(79541, 187567, 530, 0, 0, 1, 1, -4145.8, -11745.6, -124.153, 2.02458, 0, 0, 0, 1, 120, 255, 1, 0),
+(79542, 187567, 530, 0, 0, 1, 1, -4205.99, -12527.1, 50.1278, 0.715585, 0, 0, 0, 1, 120, 255, 1, 0),
+(79543, 187567, 530, 0, 0, 1, 1, -4152.04, -12529.4, 49.5232, 2.67035, 0, 0, 0, 1, 120, 255, 1, 0),
+(79544, 187567, 530, 0, 0, 1, 1, -4171.05, -13734.4, 82.0874, 2.77507, 0, 0, 0, 1, 120, 255, 1, 0),
+(79545, 187567, 530, 0, 0, 1, 1, -4054.65, -13772.3, 84.3948, 5.88176, 0, 0, 0, 1, 120, 255, 1, 0),
+(79546, 187235, 530, 0, 0, 1, 1, -4214.63, -12476, 45.0741, 5.49779, 0, 0, 0, 1, 120, 255, 1, 0),
+(79547, 187235, 530, 0, 0, 1, 1, -4212.53, -12510.3, 45.4441, 0.226893, 0, 0, 0, 1, 120, 255, 1, 0),
+(79548, 187235, 530, 0, 0, 1, 1, -4209.38, -12517.7, 45.8172, 0.331611, 0, 0, 0, 1, 120, 255, 1, 0),
+(79549, 187235, 530, 0, 0, 1, 1, -4185.71, -12504.8, 44.3613, 3.56047, 0, 0, 0, 1, 120, 255, 1, 0),
+(79550, 187235, 530, 0, 0, 1, 1, -4158.14, -12463.1, 45.0814, 3.71755, 0, 0, 0, 1, 120, 255, 1, 0),
+(79551, 187235, 530, 0, 0, 1, 1, -4176.96, -12494, 44.361, 1.36136, 0, 0, 0, 1, 120, 255, 1, 0),
+(79552, 187235, 530, 0, 0, 1, 1, -4171.62, -12506.6, 44.3613, 5.55015, 0, 0, 0, 1, 120, 255, 1, 0),
+(79553, 187235, 530, 0, 0, 1, 1, -4153.74, -12484.6, 44.5134, 3.90954, 0, 0, 0, 1, 120, 255, 1, 0),
+(79554, 187235, 530, 0, 0, 1, 1, -4158.64, -12533.3, 45.452, 2.1293, 0, 0, 0, 1, 120, 255, 1, 0),
+(79555, 187235, 530, 0, 0, 1, 1, -3928.31, -11712.5, -135.206, 5.14872, 0, 0, 0, 1, 120, 255, 1, 0),
+(79556, 187235, 530, 0, 0, 1, 1, -3938.11, -11702, -135.276, 1.50098, 0, 0, 0, 1, 120, 255, 1, 0),
+(79557, 187235, 530, 0, 0, 1, 1, -3891.19, -11640.7, -134.491, 1.29154, 0, 0, 0, 1, 120, 255, 1, 0),
+(79558, 187235, 530, 0, 0, 1, 1, -3919.52, -11642, -134.831, 0.209439, 0, 0, 0, 1, 120, 255, 1, 0),
+(79559, 187235, 530, 0, 0, 1, 1, -3905.64, -11638.8, -134.663, 5.86431, 0, 0, 0, 1, 120, 255, 1, 0),
+(79560, 187235, 530, 0, 0, 1, 1, -3943.94, -11674.1, -135.239, 3.59538, 0, 0, 0, 1, 120, 255, 1, 0),
+(79561, 187235, 530, 0, 0, 1, 1, -3939.98, -11660.9, -135.145, 3.87463, 0, 0, 0, 1, 120, 255, 1, 0),
+(79562, 187235, 530, 0, 0, 1, 1, -3943.49, -11689.1, -135.289, 0.610863, 0, 0, 0, 1, 120, 255, 1, 0),
+(79563, 187235, 530, 0, 0, 1, 1, -3931.24, -11649.4, -135.003, 1.71042, 0, 0, 0, 1, 120, 255, 1, 0),
+(79564, 187235, 530, 0, 0, 1, 1, -3877.95, -11647.3, -134.368, 4.67748, 0, 0, 0, 1, 120, 255, 1, 0),
+(79565, 187235, 530, 0, 0, 1, 1, -4040.37, -11581.4, -138.452, 0.680677, 0, 0, 0, 1, 120, 255, 1, 0),
+(79566, 187235, 530, 0, 0, 1, 1, -4025.33, -11590.4, -138.328, 1.76278, 0, 0, 0, 1, 120, 255, 1, 0),
+(79567, 187235, 530, 0, 0, 1, 1, -4006.57, -11572.7, -138.042, 2.67035, 0, 0, 0, 1, 120, 255, 1, 0),
+(79568, 187235, 530, 0, 0, 1, 1, -4228.95, -11818.9, -115.935, 0.802851, 0, 0, 0, 1, 120, 255, 1, 0),
+(79569, 187235, 530, 0, 0, 1, 1, -4048.5, -13778.9, 75.0158, 0.296705, 0, 0, 0, 1, 120, 255, 1, 0),
+(79570, 187193, 530, 0, 0, 1, 1, -3929.13, -11744.8, -138.612, 0.628317, 0, 0, 0, 1, 120, 255, 1, 0),
+(79571, 187193, 530, 0, 0, 1, 1, -3970.78, -11722.9, -138.836, 1.51844, 0, 0, 0, 1, 120, 255, 1, 0),
+(79572, 187193, 530, 0, 0, 1, 1, -3862, -11617.4, -136.833, 4.93928, 0, 0, 0, 1, 120, 255, 1, 0),
+(79573, 187193, 530, 0, 0, 1, 1, -3935.25, -11599.7, -138.455, 5.65487, 0, 0, 0, 1, 120, 255, 1, 0),
+(79574, 187193, 530, 0, 0, 1, 1, -3903.5, -11599.6, -137.786, 3.927, 0, 0, 0, 1, 120, 255, 1, 0),
+(79575, 187193, 530, 0, 0, 1, 1, -3821.2, -11515.7, -138.644, 1.51844, 0, 0, 0, 1, 120, 255, 1, 0),
+(79576, 187193, 530, 0, 0, 1, 1, -3843.45, -11503.5, -139.098, 0.785397, 0, 0, 0, 1, 120, 255, 1, 0),
+(79577, 187193, 530, 0, 0, 1, 1, -3753.63, -11517.7, -134.327, 2.09439, 0, 0, 0, 1, 120, 255, 1, 0),
+(79578, 187193, 530, 0, 0, 1, 1, -3898.61, -11445.3, -132.852, 0.104719, 0, 0, 0, 1, 120, 255, 1, 0),
+(79579, 187193, 530, 0, 0, 1, 1, -3732.54, -11501, -134.029, 2.37364, 0, 0, 0, 1, 120, 255, 1, 0),
+(79580, 187193, 530, 0, 0, 1, 1, -3657.6, -11491.4, -119.097, 1.98967, 0, 0, 0, 1, 120, 255, 1, 0),
+(79581, 187193, 530, 0, 0, 1, 1, -3640.53, -11468.6, -118.809, 3.01941, 0, 0, 0, 1, 120, 255, 1, 0),
+(79582, 187193, 530, 0, 0, 1, 1, -3903.45, -11420.8, -132.774, 0.191985, 0, 0, 0, 1, 120, 255, 1, 0),
+(79583, 187193, 530, 0, 0, 1, 1, -3985.04, -11695.9, -139.366, 5.74214, 0, 0, 0, 1, 120, 255, 1, 0);
+
+UPDATE `creature` SET `PhaseId`=169 WHERE `PhaseId`=1;
+UPDATE `creature` SET `PhaseId`=172 WHERE `PhaseId`=8;
+UPDATE `creature` SET `PhaseId`=174 WHERE `PhaseId`=32;
+UPDATE `creature` SET `PhaseId`=175 WHERE `PhaseId`=64;
+UPDATE `creature` SET `PhaseId`=176 WHERE `PhaseId`=128;