diff options
| -rw-r--r-- | sql/updates/world/master/2018_03_11_00_world_2016_11_26_05_world.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_03_11_00_world_2016_11_26_05_world.sql b/sql/updates/world/master/2018_03_11_00_world_2016_11_26_05_world.sql new file mode 100644 index 00000000000..50bb538f1f4 --- /dev/null +++ b/sql/updates/world/master/2018_03_11_00_world_2016_11_26_05_world.sql @@ -0,0 +1,16 @@ +SET @guid:=9696; +DELETE FROM `gameobject` WHERE `id` IN (179502, 142144, 142145) AND `map`=429; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`, `VerifiedBuild`) VALUES +(@guid+0, 142144, 429, 2, 67.4486, -467.225, -58.6226, -1.95477, 0, 0, -0.829037, 0.559194, 86400, 255, 1, 0), +(@guid+1, 142144, 429, 2, 24.717, -468.53, -4.25922, -2.02458, 0, 0, -0.848048, 0.52992, 86400, 255, 1, 0), +(@guid+2, 142144, 429, 2, 68.1034, -669.629, -25.1653, -2.19912, 0, 0, -0.891006, 0.453991, 86400, 255, 1, 0), +(@guid+3, 142144, 429, 2, -46.1853, -432.413, 16.4136, 0.174532, 0, 0, 0.0871553, 0.996195, 86400, 255, 1, 0), +(@guid+4, 142144, 429, 2, -110.419, -419.615, -58.6047, -2.47837, 0, 0, -0.945519, 0.325567, 86400, 255, 1, 0), +(@guid+5, 142145, 429, 2, 73.1442, -234.595, -56.461, -0.506145, 0, 0, -0.25038, 0.968148, 86400, 255, 1, 0), +(@guid+6, 142145, 429, 2, -29.2692, -335.209, -51.8413, 0.767944, 0, 0, 0.374606, 0.927184, 86400, 255, 1, 0), +(@guid+7, 142145, 429, 2, -27.8809, -392.48, -58.6137, 1.39626, 0, 0, 0.642787, 0.766045, 86400, 255, 1, 0), +(@guid+8, 142145, 429, 2, 107.133, -465.386, -3.27357, 1.95477, 0, 0, 0.829038, 0.559192, 86400, 255, 1, 0), +(@guid+9, 142145, 429, 2, -77.444, -438.764, -58.612, 2.79252, 0, 0, 0.984807, 0.173652, 86400, 255, 1, 0), +(@guid+10, 142145, 429, 2, 39.6528, -322.045, -52.2932, 1.25664, 0, 0, 0.587786, 0.809016, 86400, 255, 1, 0), +(@guid+11, 142145, 429, 2, 38.4777, -391.213, -58.6108, 1.32645, 0, 0, 0.615661, 0.788011, 86400, 255, 1, 0), +(@guid+12, 179502, 429, 2, 277.695, -423.25, -120.04, -2.92342, 0, 0, -0.994056, 0.108872, 86400, 255, 1, 0); |