diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_04_29_01_world.sql | 40 |
1 files changed, 20 insertions, 20 deletions
diff --git a/sql/updates/world/3.3.5/2019_04_29_01_world.sql b/sql/updates/world/3.3.5/2019_04_29_01_world.sql index 4ab756e07ee..8427d8bba26 100644 --- a/sql/updates/world/3.3.5/2019_04_29_01_world.sql +++ b/sql/updates/world/3.3.5/2019_04_29_01_world.sql @@ -1,26 +1,26 @@ -- DELETE FROM `gameobject` WHERE `guid` IN (825, 8194, 8195, 8196, 8197, 8198, 8199, 8200, 8201, 8202, 8203, 8204, 8205, 8206, 8207, 8208, 8209, 8210, 8211, 8212); INSERT INTO `gameobject` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES -(825, 195308, 571, 0, 0, 1, 7, 7326.46, -923.578, 914.087, 0, 0, 0, 0, 1, 180, 255, 1), -(8194, 195308, 571, 0, 0, 1, 7, 7320.05, -1242.42, 909.002, 0, 0, 0, 0, 1, 180, 255, 1), -(8195, 195308, 571, 0, 0, 1, 7, 7261.76, -1275.06, 914.546, 0, 0, 0, 0, 1, 180, 255, 1), -(8196, 195308, 571, 0, 0, 1, 7, 7337.08, -1046.75, 907.057, 0, 0, 0, 0, 1, 180, 255, 1), -(8197, 195308, 571, 0, 0, 1, 7, 7293.53, -999.875, 914.484, 0, 0, 0, 0, 1, 180, 255, 1), -(8198, 195308, 571, 0, 0, 1, 7, 7346.73, -1392.32, 911.173, 0, 0, 0, 0, 1, 180, 255, 1), -(8199, 195308, 571, 0, 0, 1, 7, 7256.35, -876.125, 924.237, 0, 0, 0, 0, 1, 180, 255, 1), -(8200, 195308, 571, 0, 0, 1, 7, 7162.58, -1479.2, 925.278, 0, 0, 0, 0, 1, 180, 255, 1), -(8201, 195308, 571, 0, 0, 1, 7, 7348.25, -1163.22, 913.775, 0, 0, 0, 0, 1, 180, 255, 1), -(8202, 195308, 571, 0, 0, 1, 7, 7352.58, -1112.15, 908.569, 0, 0, 0, 0, 1, 180, 255, 1), -(8203, 195308, 571, 0, 0, 1, 7, 7207.87, -1488.51, 920.22, 0, 0, 0, 0, 1, 180, 255, 1), -(8204, 195308, 571, 0, 0, 1, 7, 7214.34, -1043.6, 934.94, 0, 0, 0, 0, 1, 180, 255, 1), -(8205, 195308, 571, 0, 0, 1, 7, 7304.95, -1307.5, 905.533, 0, 0, 0, 0, 1, 180, 255, 1), -(8206, 195308, 571, 0, 0, 1, 7, 7291.75, -901.76, 924.944, 0, 0, 0, 0, 1, 180, 255, 1), -(8207, 195308, 571, 0, 0, 1, 7, 7238.52, -1465.82, 913.924, 0, 0, 0, 0, 1, 180, 255, 1), -(8208, 195308, 571, 0, 0, 1, 7, 7193.51, -1436.03, 917.522, 0, 0, 0, 0, 1, 180, 255, 1), -(8209, 195308, 571, 0, 0, 1, 7, 7425.66, -1194.59, 903.687, 0, 0, 0, 0, 1, 180, 255, 1), -(8210, 195308, 571, 0, 0, 1, 7, 7296.8, -1430.41, 910.388, 0, 0, 0, 0, 1, 180, 255, 1), -(8211, 195308, 571, 0, 0, 1, 7, 7386.99, -1243.72, 903.339, 0, 0, 0, 0, 1, 180, 255, 1), -(8212, 195308, 571, 0, 0, 1, 7, 7260.81, -1369.21, 912.281, 0, 0, 0, 0, 1, 180, 255, 1); +(825, 195309, 571, 0, 0, 1, 7, 7326.46, -923.578, 914.087, 0, 0, 0, 0, 1, 180, 255, 1), +(8194, 195309, 571, 0, 0, 1, 7, 7320.05, -1242.42, 909.002, 0, 0, 0, 0, 1, 180, 255, 1), +(8195, 195309, 571, 0, 0, 1, 7, 7261.76, -1275.06, 914.546, 0, 0, 0, 0, 1, 180, 255, 1), +(8196, 195309, 571, 0, 0, 1, 7, 7337.08, -1046.75, 907.057, 0, 0, 0, 0, 1, 180, 255, 1), +(8197, 195309, 571, 0, 0, 1, 7, 7293.53, -999.875, 914.484, 0, 0, 0, 0, 1, 180, 255, 1), +(8198, 195309, 571, 0, 0, 1, 7, 7346.73, -1392.32, 911.173, 0, 0, 0, 0, 1, 180, 255, 1), +(8199, 195309, 571, 0, 0, 1, 7, 7256.35, -876.125, 924.237, 0, 0, 0, 0, 1, 180, 255, 1), +(8200, 195309, 571, 0, 0, 1, 7, 7162.58, -1479.2, 925.278, 0, 0, 0, 0, 1, 180, 255, 1), +(8201, 195309, 571, 0, 0, 1, 7, 7348.25, -1163.22, 913.775, 0, 0, 0, 0, 1, 180, 255, 1), +(8202, 195309, 571, 0, 0, 1, 7, 7352.58, -1112.15, 908.569, 0, 0, 0, 0, 1, 180, 255, 1), +(8203, 195309, 571, 0, 0, 1, 7, 7207.87, -1488.51, 920.22, 0, 0, 0, 0, 1, 180, 255, 1), +(8204, 195309, 571, 0, 0, 1, 7, 7214.34, -1043.6, 934.94, 0, 0, 0, 0, 1, 180, 255, 1), +(8205, 195309, 571, 0, 0, 1, 7, 7304.95, -1307.5, 905.533, 0, 0, 0, 0, 1, 180, 255, 1), +(8206, 195309, 571, 0, 0, 1, 7, 7291.75, -901.76, 924.944, 0, 0, 0, 0, 1, 180, 255, 1), +(8207, 195309, 571, 0, 0, 1, 7, 7238.52, -1465.82, 913.924, 0, 0, 0, 0, 1, 180, 255, 1), +(8208, 195309, 571, 0, 0, 1, 7, 7193.51, -1436.03, 917.522, 0, 0, 0, 0, 1, 180, 255, 1), +(8209, 195309, 571, 0, 0, 1, 7, 7425.66, -1194.59, 903.687, 0, 0, 0, 0, 1, 180, 255, 1), +(8210, 195309, 571, 0, 0, 1, 7, 7296.8, -1430.41, 910.388, 0, 0, 0, 0, 1, 180, 255, 1), +(8211, 195309, 571, 0, 0, 1, 7, 7386.99, -1243.72, 903.339, 0, 0, 0, 0, 1, 180, 255, 1), +(8212, 195309, 571, 0, 0, 1, 7, 7260.81, -1369.21, 912.281, 0, 0, 0, 0, 1, 180, 255, 1); DELETE FROM `pool_gameobject` WHERE `pool_entry` IN (573, 574, 575, 576, 577, 578, 579, 580, 581, 582, 583, 584, 585, 586, 587, 588, 589, 590, 591, 592); INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`) VALUES |