diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_04_29_01_world.sql | 89 |
1 files changed, 89 insertions, 0 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 new file mode 100644 index 00000000000..4ab756e07ee --- /dev/null +++ b/sql/updates/world/3.3.5/2019_04_29_01_world.sql @@ -0,0 +1,89 @@ +-- +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); + +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 +(825, 573, 0, "Mysterious Snow Mound"), +(66815, 573, 0, "Mysterious Snow Mound"), +(8194, 574, 0, "Mysterious Snow Mound"), +(66816,574, 0, "Mysterious Snow Mound"), +(8195,575, 0, "Mysterious Snow Mound"), +(66817, 575, 0, "Mysterious Snow Mound"), +(8196,576, 0, "Mysterious Snow Mound"), +(66818, 576, 0, "Mysterious Snow Mound"), +(8197,577, 0, "Mysterious Snow Mound"), +(66819, 577, 0, "Mysterious Snow Mound"), +(8198,578, 0, "Mysterious Snow Mound"), +(66820, 578, 0, "Mysterious Snow Mound"), +(8199,579, 0, "Mysterious Snow Mound"), +(66821, 579, 0, "Mysterious Snow Mound"), +(8200,580, 0, "Mysterious Snow Mound"), +(66822, 580, 0, "Mysterious Snow Mound"), +(8201,581, 0, "Mysterious Snow Mound"), +(66823, 581, 0, "Mysterious Snow Mound"), +(8202,582, 0, "Mysterious Snow Mound"), +(66824, 582, 0, "Mysterious Snow Mound"), +(8203,583, 0, "Mysterious Snow Mound"), +(66825, 583, 0, "Mysterious Snow Mound"), +(8204,584, 0, "Mysterious Snow Mound"), +(66826, 584, 0, "Mysterious Snow Mound"), +(8205,585, 0, "Mysterious Snow Mound"), +(66827, 585, 0, "Mysterious Snow Mound"), +(8206,586, 0, "Mysterious Snow Mound"), +(66828, 586, 0, "Mysterious Snow Mound"), +(8207,587, 0, "Mysterious Snow Mound"), +(66829, 587, 0, "Mysterious Snow Mound"), +(8208,588, 0, "Mysterious Snow Mound"), +(66830, 588, 0, "Mysterious Snow Mound"), +(8209,589, 0, "Mysterious Snow Mound"), +(66831, 589, 0, "Mysterious Snow Mound"), +(8210,590, 0, "Mysterious Snow Mound"), +(66832, 590, 0, "Mysterious Snow Mound"), +(8211,591, 0, "Mysterious Snow Mound"), +(66833, 591, 0, "Mysterious Snow Mound"), +(8212,592, 0, "Mysterious Snow Mound"), +(66834, 592, 0, "Mysterious Snow Mound"); + +DELETE FROM `pool_template` WHERE `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_template` (`entry`, `max_limit`, `description`) VALUES +(573, 1, "Mysterious Snow Mound"), +(574, 1, "Mysterious Snow Mound"), +(575, 1, "Mysterious Snow Mound"), +(576, 1, "Mysterious Snow Mound"), +(577, 1, "Mysterious Snow Mound"), +(578, 1, "Mysterious Snow Mound"), +(579, 1, "Mysterious Snow Mound"), +(580, 1, "Mysterious Snow Mound"), +(581, 1, "Mysterious Snow Mound"), +(582, 1, "Mysterious Snow Mound"), +(583, 1, "Mysterious Snow Mound"), +(584, 1, "Mysterious Snow Mound"), +(585, 1, "Mysterious Snow Mound"), +(586, 1, "Mysterious Snow Mound"), +(587, 1, "Mysterious Snow Mound"), +(588, 1, "Mysterious Snow Mound"), +(589, 1, "Mysterious Snow Mound"), +(590, 1, "Mysterious Snow Mound"), +(591, 1, "Mysterious Snow Mound"), +(592, 1, "Mysterious Snow Mound"); |