diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2016_06_23_00_world.sql | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2016_06_23_00_world.sql b/sql/updates/world/3.3.5/2016_06_23_00_world.sql new file mode 100644 index 00000000000..49ec67454a3 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_06_23_00_world.sql @@ -0,0 +1,50 @@ +-- +SET @OGUID := 85065; -- 32 Required +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID AND @OGUID+31; +INSERT INTO `gameobject` (`guid`, `id`, `map`,`zoneId`,`areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`,`VerifiedBuild`) VALUES +(@OGUID,181371,1,0,0,1,1,1916.260620, -4339.434082, 21.460556, 2.969551,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+1,181371,1,0,0,1,1,1913.254395, -4333.927246, 21.604612, 4.351851,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+2,181371,1,0,0,1,1,1907.401245, -4337.044434, 21.677332, 6.107213,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+3,181371,1,0,0,1,1,1910.640137, -4342.747070, 21.676716, 5.887306,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+4,181371,1,0,0,1,1,-1028.846680, 293.187408, 135.844879, 1.204641,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+5,181371,1,0,0,1,1,-1030.881104, 297.332916, 136.117874, 6.148724,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+6,181371,1,0,0,1,1,-1027.052002, 299.510010, 136.164764, 4.558297,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+7,181371,1,0,0,1,1,-1024.677979, 295.472260, 136.143784, 3.823951,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+8,181371,1,0,0,1,1,8695.066406, 932.137634, 15.345254, 6.110,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+10,181371,1,0,0,1,1,8700.012695, 936.332153, 14.836842, 4.664,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+9,181371,1,0,0,1,1,8704.493164, 931.790894, 15.463143, 3.133,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+11,181371,1,0,0,1,1,8700.567383, 927.612854, 15.892158, 1.338,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+12,181371,0,0,0,1,1,-8833.281250, 855.614441, 99.411079, 2.575616,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+13,181371,0,0,0,1,1,-8834.824219, 861.003784, 99.434731, 3.883833,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+14,181371,0,0,0,1,1,-8840.805664, 860.021912, 99.391479, 4.602470,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+15,181371,0,0,0,1,1,-8839.428711, 853.691956, 99.298836, 0.486980,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+16,181371,0,0,0,1,1,-4701.214355, -1219.862183, 502.268250, 4.783111,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+17,181371,0,0,0,1,1,-4696.379395, -1224.597412, 502.304504, 2.941357,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+18,181371,0,0,0,1,1,-4702.767090, -1228.114258, 502.267609, 1.284167,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+19,181371,0,0,0,1,1,-4704.313477, -1222.943359, 502.269287, 1.830019,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+20,181371,0,0,0,1,1,1825.027954, 221.371674, 60.629555, 3.934886,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+21,181371,0,0,0,1,1,1823.459106, 214.621674, 60.507618, 2.686104,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+22,181371,0,0,0,1,1,1818.975342, 216.522690, 60.553699, 1.229190,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+23,181371,0,0,0,1,1,1819.281616, 221.073471, 60.566326, 5.925872,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+24,181371,530,0,0,1,1,9806.342773, -7244.069336, 26.683933, 1.731536,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+25,181371,530,0,0,1,1,9809.258789, -7237.612793, 26.686577, 2.387343,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+26,181371,530,0,0,1,1,9803.005859, -7236.524902, 26.655304, 3.757864,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+27,181371,530,0,0,1,1,9802.109375, -7242.179688, 26.474823, 5.874507,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+28,181371,530,0,0,1,1,-3790.196777, -11504.259766, -134.122711, 2.506965,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+29,181371,530,0,0,1,1,-3791.924805, -11498.497070, -134.097641, 4.148447,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+30,181371,530,0,0,1,1,-3797.747803, -11500.220703, -134.086700, 5.915591,0,0,0.945519,0.325568,180,100,0,0), +(@OGUID+31,181371,530,0,0,1,1,-3793.995361, -11506.169922, -134.113098, 6.198332,0,0,0.945519,0.325568,180,100,0,0); +DELETE FROM `game_event_gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+31 AND `eventEntry`=1; +INSERT INTO `game_event_gameobject` SELECT 1, gameobject.guid FROM `gameobject` WHERE gameobject.guid BETWEEN @OGUID+0 AND @OGUID+31; + +DELETE FROM `gameobject` WHERE `guid` IN (49312,165383,164812,164813,164814,164815,164816,164817,164818,164819,164820,164821,164822,164823,164825,164826,164827); +DELETE FROM `gameobject` WHERE `guid` IN (164906,164907,164908,164909,164910,164911,164913,164914,164915,164916,164917,164918,164919,164920,164921,164922,164923,164924); +DELETE FROM `game_event_gameobject` WHERE `guid` IN (49312,165383,164812,164813,164814,164815,164816,164817,164818,164819,164820,164821,164822,164823,164825,164826,164827); +DELETE FROM `game_event_gameobject` WHERE `guid` IN (164906,164907,164908,164909,164910,164911,164913,164914,164915,164916,164917,164918,164919,164920,164921,164922,164923,164924); +UPDATE `creature` SET `position_x`=1008.565002, `position_y`=-1452.775513, `position_z`=61.660973, `orientation`=5.272540 WHERE `guid`=212043; +UPDATE `gameobject` SET `position_x`=989.562012, `position_y`=-1453.469971, `position_z`=61.001099, `orientation`=4.9105 WHERE `guid`=17857; +UPDATE `gameobject` SET `position_x`=988.2767, `position_y`=-1440.3270, `position_z`=64.52133 WHERE `guid`=17853; +UPDATE `gameobject` SET `position_x`=984.8693, `position_y`=-1445.037, `position_z`=63.92835 WHERE `guid`=17860; +UPDATE `gameobject` SET `position_x`=-4223.839844, `position_y`=-12318.400391, `position_z`=2.47695 WHERE `guid`=165454; +UPDATE `creature` SET `position_x`=-4223.839844, `position_y`=-12318.400391, `position_z`=2.47695 WHERE `guid`=152373; +UPDATE `creature` SET `position_x`=-4217.176, `position_y`=-12309.458008, `position_z`=2.144819, `orientation`=5.988677 WHERE `guid`=212603; |