diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_05_11_05_world_335.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_05_11_05_world_335.sql b/sql/updates/world/3.3.5/2020_05_11_05_world_335.sql new file mode 100644 index 00000000000..35de8fa47e0 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_05_11_05_world_335.sql @@ -0,0 +1,20 @@ +-- Use the corrects gobs (Herbs) in The Barrens +UPDATE `gameobject` SET `id`=3725 WHERE `id`=1617 AND `guid` IN (462, 473, 482, 484, 488, 489, 507, 520, 532, 533, 542, 562, 585, 589, 593, 604, 605, 606, 620, 630, 632, 650, 659, 671, 681, 689, 696, 700, 705, 723, 729, 730, 731, 775, 782, 785, 795, 812, 824, 847, 852, 878, 879, 892, 904, 905, 906, 907, 908, 909, 910, 913, 918, 927, 928, 935, 945, 946, 947, 950, 983, 994, 998, 1002, 1004, 1011, 1013, 1026, 1034, 1039, 1040, 1051, 1078, 1082, 1085, 1086, 1087, 1089, 1100, 1106, 1107, 1130, 1131, 1138, 1146, 1166, 1168, 1169, 1170, 1193, 1218, 1234, 1255, 1258); +UPDATE `gameobject` SET `id`=3724 WHERE `id`=1618 AND `guid` IN (1346, 1355, 1372, 1373, 1375, 1376, 1395, 1398, 1404, 1410, 1411, 1412, 1413, 1414, 1419, 1429, 1434, 1440, 1459, 1464, 1470, 1471, 1475, 1480, 1481, 1485, 1490, 1505, 1506, 1509, 1511, 1512, 1513, 1514, 1522, 1524, 1528, 1536, 1538, 1539, 1544, 1550, 1559, 1560, 1563, 1567, 1573, 1575, 1584, 1592, 1594, 1606, 1622, 1630, 1633, 1634, 1642, 1644, 1649, 1661, 1662, 1663, 1665, 1667, 1668, 1677, 1693, 1702, 1704, 1714, 1730, 1737, 1742); +UPDATE `gameobject` SET `id`=3726 WHERE `id`=1619 AND `guid` IN (1755, 1756, 1757, 1759, 1761, 1764, 1765, 1767, 1776, 1779, 1781, 1782, 1783, 1787, 1792, 1793, 1796, 1797, 1798, 1802, 1804, 1807, 1808, 1809, 1813, 1814, 1815, 1816, 1823, 1830, 1833, 1837, 1842, 1843, 1844, 1845, 1846, 1852, 1853, 1854, 1855, 1856, 1857, 1859, 1861, 1864, 1866, 1868, 1896, 1897, 1898, 1899, 1900, 1901, 1902, 1903, 1905, 1907, 1908, 1911, 1913, 1917, 1918, 1919, 1920, 1921, 1925, 1926, 1928, 1930, 1931, 1932, 1934, 1935, 1936, 1942, 1943, 1944, 1945, 1946, 1950, 1957, 1958, 1959, 1960, 1961, 1963, 1965, 1967, 1968, 1972, 1975, 1977, 1978, 1979, 1980, 1983, 1984, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1995, 1997, 1998, 1999, 2003, 2004, 2005, 2006, 2007, 2009, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2028, 2029, 2030, 2040, 2041, 2050, 2060, 2061, 2062, 2063, 2064, 2066, 2067, 2068, 2069, 2071, 2072, 2078, 2079, 2080); +UPDATE `gameobject` SET `id`=3727 WHERE `id`=1620 AND `guid` IN (2082, 2084, 2085, 2088, 2089, 2091, 2092, 2094, 2095, 2098, 2099, 2103, 2104, 2106, 2107, 2108, 2109, 2122, 2123, 2125, 2128, 2130, 2135, 2136, 2138, 2139, 2141, 2142, 2143, 2144, 2145, 2146, 2147, 2151, 2152, 2153, 2154, 2156, 2159, 2160, 2161, 2162, 2165, 2166, 2168, 2170, 2171, 2174, 2176, 2177, 2178, 2179, 2180, 2181, 2182, 2183, 2186, 2188, 2191, 2192, 2193, 2194, 2196, 2198, 2199, 2200, 2201, 2202, 2203, 2204, 2205, 2206, 2207, 2209, 2211, 2212, 2213, 2219, 2220, 2222, 2223, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2245, 2246, 2247, 2253, 2257, 2258, 2259, 2261, 2262, 2263, 2264, 2267, 2268, 2270, 2271, 2272, 2274, 2277, 2280, 2281, 2285, 2287, 2289, 2290, 2291, 2292, 2293, 2296, 2297, 2304, 2308, 2310, 2311, 2312, 2313, 2314, 2315, 2317, 2318, 2328, 2333, 2334, 2337, 2339, 2340, 2341, 2343, 2344, 2345, 2347, 2348, 2349, 2350, 2351, 2355, 2358, 2361, 2362, 2363, 2364, 2369, 2375, 2377, 2378, 2382, 2383, 2384, 2385, 2386, 2387, 2388, 2389, 2390, 2391, 2392, 2393, 2395, 2397, 2400, 2401, 2405, 2406, 2419, 2423, 2424, 2426, 2427, 2429, 2430, 2433, 2434, 2436, 2445, 2446, 2447, 2450, 2455, 2461, 2462, 2463, 2464, 2470, 2471, 2472, 2474, 2475, 2482, 2483, 2486, 2487, 2488, 2489, 2492, 2494, 2495, 2496, 2501, 2503, 2504, 2506, 2507, 2508, 2509, 2512, 2513, 2515, 2520, 2522, 2523, 2528, 2534, 2535, 2536, 2537, 2538, 2539); +UPDATE `gameobject` SET `id`=3729 WHERE `id`=1621 AND `guid` IN (2542, 2549, 2551, 2554, 2559, 2562, 2564, 2565, 2567, 2569, 2574, 2590, 2591, 2599, 2610, 2611, 2615, 2620, 2621, 2625, 2634, 2643, 2644, 2646, 2648, 2652, 2659, 2667, 2668, 2677, 2678, 2691, 2695, 2699, 2716, 2717, 2719, 2722, 2723, 2724, 2725, 2728, 2729, 2732, 2737, 2743, 2747, 2751, 2754, 2756, 2758, 2760, 2762, 2763, 2766, 2767, 2770, 2772, 2781, 2783, 2789, 2807, 2814, 2817, 2822, 2824, 2825, 2826, 2835, 2836, 2857, 2859, 2865, 2880, 2881, 2883, 2884, 2885, 2886, 2887, 2893, 2898, 2902, 2905, 2906, 2907); +UPDATE `gameobject` SET `id`=3730 WHERE `id`=1622 AND `guid` IN (2928, 2930, 2950, 2951, 2952, 2954, 2971, 3006, 3015, 3028, 3032, 3047, 3049, 3056, 3058, 3098, 3099, 3100, 3101, 3102, 3103, 3104, 3105, 3106, 3107, 3134, 3135, 3143, 3157, 3201, 3226, 3245, 3260, 3261, 3262, 3270, 3271, 3272, 3274, 3275, 3276, 3303, 3328, 3329, 3342, 3350, 3351, 3352, 3361, 3368, 3375, 3376, 3406, 3409, 3410, 3451, 3452, 3453, 3455, 3458, 3464, 3465, 3469, 3478, 3494, 3495, 3496, 3497, 3498, 3505, 3524, 3538, 3549, 3558, 3574, 3575, 3579, 3591, 3595, 3621, 3667, 3692, 3693, 3694, 3703, 3708, 3734, 3735, 3736, 3739, 3793, 3812, 3813, 3827, 3852, 3854, 3862); +DELETE FROM `gameobject` WHERE `id` IN (3725, 3729, 3730, 3726, 3727,3724) AND `guid` IN (14489, 14488, 14487, 14486, 14485, 14482, 14481, 14480, 14479, 14478, 14477, 14476, 14475, 14474, 14473, 14472, 14471, 14470, 14468, 14467, 14464, 14463, 14462, 14460, 14459, 14458, 14457, 14456, 14455, 14454, 14453, 14452, 14451, 14450, 14446, 14302, 14301, 14298, 14297, 14236, 14204, 14203, 14202, 14201, 14200, 14199, 14187, 14184, 14008, 13969, 13821, 13820, 13702, 13701, 13700, 13699, 13698, 13697, 13696, 13695, 13694, 13693, 13692, 13691, 13690, 13689, 13688, 13687, 13686, 13685, 13684, 13675, 13674, 13673, 13639, 13629, 13628, 13624, 13622, 13620, 13619, 13605, 13602, 13601, 13600, 13599, 13598, 13597, 13596, 13595, 13591, 13590, 13589, 13588, 13587, 13586, 13585, 13584, 13583, 13582, 13581, 13580, 13579, 13578, 13577, 13576, 13575, 13574, 13573, 13572, 13571, 13570, 13568, 13567, 13566, 13565, 13564, 13563, 13562, 13561, 13560, 13559, 13558, 13557, 13556, 13555, 13554, 13553, 13552, 13551, 13550, 13549, 13548, 13547, 13546, 13545, 30205, 30889, 30894, 31974, 31975, 31976, 31978, 32011, 32014, 32015, 32017, 32519, 33549, 33553, 33557, 35024, 63421, 63422, 63423, 63424, 63425, 63426, 63427, 63428, 63429, 63430, 63431, 65121, 65122, 65123, 86351, 86352, 86353, 86354, 86355, 86356, 86357, 86358, 86359, 86360, 86361, 86362, 86363, 86364, 86365, 86366, 86367, 86368, 86369, 86370, 86371, 86372, 86373, 86374, 86375, 86376, 86377, 86378, 86379, 86380, 86381, 87283, 87284, 87285, 87286, 87287, 87288, 87289, 87290, 87291, 87292, 87293, 87294, 87295, 87296, 87484); +DELETE FROM `gameobject` WHERE `guid` IN (2094, 2474); +DELETE FROM `gameobject_addon` WHERE `guid` IN (2474, 14489, 14488, 14487, 14486, 14485, 14482, 14480, 14479, 14478, 14477, 14476, 14475, 14474, 14473, 14472, 14471, 14470, 14468, 14467, 14464, 14463, 14462, 14460, 14459, 14458, 14456, 14455, 14454, 14453, 14452, 14451, 14450, 14446, 14302, 14301, 14298, 14297, 14236, 14204, 14203, 14202, 14201, 14200, 14199, 14187, 14184, 14008, 13969, 13821, 13820, 13702, 13701, 13700, 13699, 13698, 13697, 13696, 13695, 13694, 13693, 13692, 13691, 13690, 13689, 13688, 13687, 13686, 13685, 13684, 13675, 13674, 13673, 13639, 13629, 13628, 13624, 13622, 13620, 13619, 13605, 13602, 13601, 13600, 13599, 13598, 13597, 13596, 13595, 13591, 13590, 13589, 13588, 13587, 13586, 13585, 13584, 13583, 13582, 13581, 13580, 13579, 13578, 13577, 13576, 13575, 13574, 13573, 13572, 13571, 13570, 13568, 13567, 13566, 13565, 13564, 13563, 13562, 13561, 13560, 13559, 13558, 13557, 13556, 13555, 13554, 13553, 13552, 13551, 13550, 13549, 13548, 13547, 13546, 13545, 30205, 30889, 30894, 31974, 31975, 31976, 31978, 32011, 32014, 32015, 32017, 32519, 33549, 33553, 33557, 35024); +DELETE FROM `spawn_group` WHERE `spawntType`=1 AND `spawnId` IN (2094, 2474, 13545, 13546, 13547, 13548, 13549, 13550, 13551, 13552, 13553, 13554, 13555, 13556, 13557, 13558, 13559, 13560, 13561, 13562, 13563, 13564, 13565, 13566, 13567, 13568, 13570, 13571, 13572, 13573, 13574, 13575, 13576, 13577, 13578, 13579, 13580, 13581, 13582, 13583, 13584, 13585, 13586, 13587, 13588, 13589, 13590, 13591, 13595, 13596, 13597, 13598, 13599, 13600, 13601, 13602, 13605, 13619, 13620, 13622, 13624, 13628, 13629, 13639, 13673, 13674, 13675, 13684, 13685, 13686, 13687, 13688, 13689, 13690, 13691, 13692, 13693, 13694, 13695, 13696, 13697, 13698, 13699, 13700, 13701, 13702, 13820, 13821, 13969, 14008, 14184, 14187, 14199, 14200, 14201, 14202, 14203, 14204, 14236, 14297, 14298, 14301, 14302, 14446, 14450, 14451, 14452, 14453, 14454, 14455, 14456, 14457, 14458, 14459, 14460, 14462, 14463, 14464, 14467, 14468, 14470, 14471, 14472, 14473, 14474, 14475, 14476, 14477, 14478, 14479, 14480, 14481, 14482, 14485, 14486, 14487, 14488, 14489, 30205, 30889, 30894, 31974, 31975, 31976, 31978, 32011, 32014, 32015, 32017, 32519, 33549, 33553, 33557, 35024, 63421, 63422, 63423, 63424, 63425, 63426, 63427, 63428, 63429, 63430, 63431, 65121, 65122, 65123, 86351, 86352, 86353, 86354, 86355, 86356, 86357, 86358, 86359, 86360, 86361, 86362, 86363, 86364, 86365, 86366, 86367, 86368, 86369, 86370, 86371, 86372, 86373, 86374, 86375, 86376, 86377, 86378, 86379, 86380, 86381, 87283, 87284, 87285, 87286, 87287, 87288, 87289, 87290, 87291, 87292, 87293, 87294, 87295, 87296, 87484); +-- Add Root Sample loot only in herbs spawned in The Barrens +DELETE FROM `gameobject_loot_template` WHERE `Entry` IN (1414,1415,1416,1417,1418,1419,1420,1421,1733,1734,2511,2512,2513,2514,2515,2516) AND `Item` = 5056; +INSERT INTO `gameobject_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`) VALUES +(2511,5056,0,100,1,1,0,1,1), +(2512,5056,0,100,1,1,0,1,1), +(2513,5056,0,100,1,1,0,1,1), +(2514,5056,0,100,1,1,0,1,1), +(2515,5056,0,100,1,1,0,1,1), +(2516,5056,0,100,1,1,0,1,1); |