diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2019_01_14_01_world.sql | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_01_14_01_world.sql b/sql/updates/world/3.3.5/2019_01_14_01_world.sql new file mode 100644 index 00000000000..f30a3c585f1 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_01_14_01_world.sql @@ -0,0 +1,56 @@ +-- +DELETE FROM `creature` WHERE `id` IN (23929); +DELETE FROM `spawn_group` WHERE `spawnType`=0 AND `spawnId` IN (143153,143154,143155,143156,143157,143158,143159,143160,143161,143162,143163,143164,143165,143166,143167,143168,143169,143170,143171,143172,143173,143174,143175,143176,143177,143178,143179,143180,143181,143182,143183,143184,143185,143186,143187,143188,143189,143190,143191,143192,143193,143194,143195,143196,143197,143198,143199,143200,143201,143202,143203,143204,143205,143206,143207,143208,143209,143210,143211,143212,143213,143214,143215,143216,143217,143218,143219); +DELETE FROM `creature` WHERE `guid` IN(95241,95242,95250,95251,95252,95253,95254,95258,95259,95261,95262,95299,95301,95302,95304,95305,95306,95308,95326,95327,95328,95331,95334,95337,95338,95343,95344,95393,95403,95405,95408,95413,95414,95416,95423,95425,95587,95980,95987,96294,96297,96301,96545,96546,96548,96549,96550,96551,96552,96553,96554); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`) VALUES +(95241, 23929, 571, 1, 1, 0, 0, 471.612, -6212.71, -5.36919, 1.20382, 300, 5, 0, 6986, 0, 1), +(95242, 23929, 571, 1, 1, 0, 0, 493.803, -6285.88, -58.7468, 6.20056, 300, 5, 0, 6986, 0, 1), +(95250, 23929, 571, 1, 1, 0, 0, 512.581, -6255.37, -14.0343, 0.246398, 300, 5, 0, 6986, 0, 1), +(95251, 23929, 571, 1, 1, 0, 0, 818.54, -6098.34, -5.68217, 5.19636, 300, 5, 0, 6986, 0, 1), +(95252, 23929, 571, 1, 1, 0, 0, 844.456, -6112.04, -7.57999, 3.81972, 300, 5, 0, 6986, 0, 1), +(95253, 23929, 571, 1, 1, 0, 0, 880.742, -6087.29, -5.54351, 1.75751, 300, 5, 0, 6986, 0, 1), +(95254, 23929, 571, 1, 1, 0, 0, 907.085, -6122.27, -7.45787, 0.316577, 300, 5, 0, 6986, 0, 1), +(95258, 23929, 571, 1, 1, 0, 0, 925.089, -6181.16, -7.20293, 3.05748, 300, 5, 0, 6986, 0, 1), +(95259, 23929, 571, 1, 1, 0, 0, 956.558, -6219.95, -7.65883, 2.06669, 300, 5, 0, 6986, 0, 1), +(95261, 23929, 571, 1, 1, 0, 0, 1126.54, -6512.13, -93.8311, 2.80764, 300, 7, 0, 7984, 0, 1), +(95262, 23929, 571, 1, 1, 0, 0, 1178.81, -6518.79, -90.5612, 6.11417, 300, 7, 0, 6986, 0, 1), +(95299, 23929, 571, 1, 1, 0, 0, 1379.53, -6552.85, -46.019, 0.718504, 300, 7, 0, 7984, 0, 1), +(95301, 23929, 571, 1, 1, 0, 0, 1721.45, -6352.31, -22.9513, 3.33158, 300, 7, 0, 7984, 0, 1), +(95302, 23929, 571, 1, 1, 0, 0, 1754.18, -6313.08, -10.1104, 3.33158, 300, 7, 0, 6986, 0, 1), +(95304, 23929, 571, 1, 1, 0, 0, 1779.65, -6286.15, -8.21856, 3.33158, 300, 7, 0, 6986, 0, 1), +(95305, 23929, 571, 1, 1, 0, 0, 1783, -6352.06, -14.9158, 3.33158, 300, 7, 0, 6986, 0, 1), +(95306, 23929, 571, 1, 1, 0, 0, 1814.02, -6245.94, 1.08775, 1.9964, 300, 7, 0, 6986, 0, 1), +(95308, 23929, 571, 1, 1, 0, 0, 1817.66, -6314.72, -13.1836, 3.33158, 300, 7, 0, 6986, 0, 1), +(95326, 23929, 571, 1, 1, 0, 0, 1844.47, -6346.61, -13.3827, 3.33158, 300, 7, 0, 7984, 0, 1), +(95327, 23929, 571, 1, 1, 0, 0, 1856.45, -6285.45, -2.71581, 3.33158, 300, 7, 0, 6986, 0, 1), +(95328, 23929, 571, 1, 1, 0, 0, 1894.82, -6322.45, -24.1063, 5.18349, 300, 7, 0, 6986, 0, 1), +(95331, 23929, 571, 1, 1, 0, 0, 1921.03, -6287.19, -31.274, 5.06961, 300, 7, 0, 6986, 0, 1), +(95334, 23929, 571, 1, 1, 0, 0, 2010.34, -6251.85, -20.7359, 4.34928, 300, 5, 0, 6986, 0, 1), +(95337, 23929, 571, 1, 1, 0, 0, 2031.83, -6193.31, -2.88364, 4.83639, 300, 5, 0, 6986, 0, 1), +(95338, 23929, 571, 1, 1, 0, 0, 2065.86, -6160.64, 0.922473, 1.86786, 300, 5, 0, 6986, 0, 1), +(95343, 23929, 571, 1, 1, 0, 0, 2078.55, -6124.3, 4.09472, 4.80558, 300, 5, 0, 6986, 0, 1), +(95344, 23929, 571, 1, 1, 0, 0, 2085.98, -6212.13, -4.94937, 4.47387, 300, 5, 0, 6986, 0, 1), +(95393, 23929, 571, 1, 1, 0, 0, 2086.73, -6257.11, -10.9662, 4.22691, 300, 7, 0, 7984, 0, 1), +(95403, 23929, 571, 1, 1, 0, 0, 2126.86, -6217.54, -2.98863, 1.14422, 300, 7, 0, 7984, 0, 1), +(95405, 23929, 571, 1, 1, 0, 0, 2128.64, -6154.08, 1.14941, 0.299923, 300, 7, 0, 7984, 0, 1), +(95408, 23929, 571, 1, 1, 0, 0, 2133.05, -6110.7, 6.14001, 0.484482, 300, 7, 0, 6986, 0, 1), +(95413, 23929, 571, 1, 1, 0, 0, 2161.19, -6121.27, 2.38701, 6.07652, 300, 7, 0, 7984, 0, 1), +(95414, 23929, 571, 1, 1, 0, 0, 2162.64, -6079.09, 6.37882, 2.66004, 300, 7, 0, 6986, 0, 1), +(95416, 23929, 571, 1, 1, 0, 0, 2162.79, -6223.53, -11.608, 5.65555, 300, 7, 0, 6986, 0, 1), +(95423, 23929, 571, 1, 1, 0, 0, 2168.99, -6181.02, -3.43245, 6.15506, 300, 7, 0, 7984, 0, 1), +(95425, 23929, 571, 1, 1, 0, 0, 2197.57, -6148.35, -3.24446, 0.181321, 300, 7, 0, 7984, 0, 1), +(95587, 23929, 571, 1, 1, 0, 0, 2225.07, -6122.42, -1.26454, 0.778221, 300, 7, 0, 6986, 0, 1), +(95980, 23929, 571, 1, 1, 0, 0, 2228.46, -6095.01, 0.641292, 1.92883, 300, 7, 0, 6986, 0, 1), +(95987, 23929, 571, 1, 1, 0, 0, 2232.88, -6172.52, -2.40829, 3.01661, 300, 7, 0, 6986, 0, 1), +(96294, 23929, 571, 1, 1, 0, 0, 2254.05, -6087.51, -1.46214, 1.92883, 300, 7, 0, 6986, 0, 1), +(96297, 23929, 571, 1, 1, 0, 0, 2257.04, -6131.05, -1.10401, 1.5165, 300, 7, 0, 7984, 0, 1), +(96301, 23929, 571, 1, 1, 0, 0, 2263.73, -6176.27, -2.97312, 1.22982, 300, 7, 0, 7984, 0, 1), +(96545, 23929, 571, 1, 1, 0, 0, 2282.29, -6143.66, 1.77784, 6.22102, 300, 7, 0, 7984, 0, 1), +(96546, 23929, 571, 1, 1, 0, 0, 2295.44, -6045.4, 1.5722, 4.76331, 300, 7, 0, 7984, 0, 1), +(96548, 23929, 571, 1, 1, 0, 0, 2305.99, -6079.17, -3.97087, 1.05309, 300, 7, 0, 7984, 0, 1), +(96549, 23929, 571, 1, 1, 0, 0, 2347.47, -6111.62, -4.16258, 0.961983, 300, 7, 0, 6986, 0, 1), +(96550, 23929, 571, 1, 1, 0, 0, 2348.24, -6051.99, 1.59496, 0.961983, 300, 7, 0, 7984, 0, 1), +(96551, 23929, 571, 1, 1, 0, 0, 2366.62, -6011.38, 1.22211, 5.06961, 300, 7, 0, 7984, 0, 1), +(96552, 23929, 571, 1, 1, 0, 0, 2387.5, -6095.04, -5.35687, 5.06961, 300, 7, 0, 6986, 0, 1), +(96553, 23929, 571, 1, 1, 0, 0, 2400.81, -6035.12, 1.05743, 2.87443, 300, 7, 0, 7984, 0, 1), +(96554, 23929, 571, 1, 1, 0, 0, 2414.95, -6053.88, -3.54154, 5.06961, 300, 7, 0, 6986, 0, 1); |