aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorCarbenium <carbenium@outlook.com>2016-01-22 19:37:22 +0100
committerCarbenium <carbenium@outlook.com>2016-01-22 19:37:22 +0100
commitd3be63d0c8dc9444c1edd649bad6193bf065a25d (patch)
tree1b0b5bb90814cad1eb4e12289e70426e13cf9e5b
parent657b7ccbb93c7f670f2564affc9a2a86c7f088c5 (diff)
Fix some linebreaks in 2016_01_22_00_world.sql
-rw-r--r--sql/updates/world/2016_01_22_00_world.sql15
1 files changed, 5 insertions, 10 deletions
diff --git a/sql/updates/world/2016_01_22_00_world.sql b/sql/updates/world/2016_01_22_00_world.sql
index 1d07adce996..cbed70ae503 100644
--- a/sql/updates/world/2016_01_22_00_world.sql
+++ b/sql/updates/world/2016_01_22_00_world.sql
@@ -953,8 +953,7 @@ UPDATE `gameobject` SET `guid`=66473 WHERE `guid`=568;
--
SET @OGUID := 20927;
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+7;
-INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `Verified
-Build`) VALUES
+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
(@OGUID+0, 191814, 571, 67, 4439, 1, 1, 7337.65, -3049.82, 841.367, 1.22173, 0, 0, 0, 1, 120, 255, 1, 0),
(@OGUID+1, 191814, 571, 67, 4439, 1, 1, 7254.24, -3021.71, 846.695, 0.488691, 0, 0, 0, 1, 120, 255, 1, 0),
(@OGUID+2, 191814, 571, 67, 4439, 1, 1, 7330, -3292.08, 859.143, 5.55015, 0, 0, 0, 1, 120, 255, 1, 0),
@@ -967,8 +966,7 @@ Build`) VALUES
--
SET @OGUID := 21622;
DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+2;
-INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `Verified
-Build`) VALUES
+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
(@OGUID+0, 202211, 668, 4820, 4820, 3, 1, 5242.83, 1623.45, 784.15, 5.81195, 0, 0, 0, 1, -7200, 255, 1, 15595),
(@OGUID+1, 202211, 668, 4820, 4820, 3, 1, 5225.2, 1589.1, 808.551, 5.81195, 0, 0, 0, 1, -7200, 255, 1, 15595),
(@OGUID+2, 202211, 668, 4820, 4820, 3, 1, 5233.98, 1606.31, 796.254, 5.81195, 0, 0, 0, 1, -7200, 255, 1, 15595);
@@ -998,8 +996,7 @@ INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseId`,`position_x`,`
UPDATE `gameobject` SET `guid`=380 WHERE `guid`=20;
-INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `Verified
-Build`) VALUES
+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
(2568, 188514, 578, 4228, 4228, 3, 1, 1209.71, 1334.59, 192.375, 1.10828, 0, 0, 0.526214, 0.850352, 180, 0, 1, 0),
(2730, 183043, 530, 3521, 3648, 1, 1, 907.398, 5773.45, 10.7675, -1.58825, 0, 0, 0.71325, -0.700909, 60, 100, 1, 0);
@@ -1026,8 +1023,7 @@ INSERT INTO gameobject (guid,id,map,spawnMask,phaseId,position_x,position_y,posi
(@OGUID+3,186813,571,1,1,1596.3,-3904.79,79.5351,-2.67035,0,0,0,0,5,0,1);
DELETE FROM gameobject WHERE id IN (194241);
-INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `Verified
-Build`) VALUES
+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
(6068, 194241, 571, 65, 4256, 1, 1, 4606.72, -1606.91, 156.659, 1.62734, 0, 0, 0.726811, 0.686837, 300, 0, 1, 0),
(6069, 194241, 571, 65, 4256, 1, 1, 4596.78, -1606.69, 156.659, 1.5488, 0, 0, 0.699286, 0.714842, 300, 0, 1, 0),
(6070, 194241, 571, 65, 4256, 1, 1, 4597.1, -1594.08, 156.658, 1.53702, 0, 0, 0.695063, 0.718949, 300, 0, 1, 0),
@@ -1047,8 +1043,7 @@ DELETE FROM `gameobject` WHERE `guid`=21080;
UPDATE `gameobject` SET `guid`=21080 WHERE `guid`=1910;
DELETE FROM `gameobject` WHERE `guid` IN (25020,25042,32360,35793,35829,67867);
-INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseId`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `Verified
-Build`) VALUES
+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
(25020, 184109, 530, 3523, 3737, 1, 1, 4006.81, 1517.19, -115.933, -1.6057, 0, 0, 0.71934, -0.694658, 181, 100, 1, 0),
(25042, 184143, 530, 3523, 3723, 1, 1, 2760.88, 3203.82, 153.994, -0.558505, 0, 0, 0.275637, -0.961262, 181, 100, 1, 0),
(32360, 185324, 532, 3457, 3457, 1, 1, -11080.6, -1876.43, 219.869, -1.79769, 0, 0, 0, 1, 180, 255, 0, 0),