Полезные SQL запросы для сборок lineage 2

UPDATE npc SET agro='0' WHERE type='L2Monster';

DELETE FROM char_templates WHERE ClassId=0; 
DELETE FROM char_templates WHERE ClassId=10; 
DELETE FROM char_templates WHERE ClassId=18; 
DELETE FROM char_templates WHERE ClassId=25; 
DELETE FROM char_templates WHERE ClassId=31; 
DELETE FROM char_templates WHERE ClassId=38; 
DELETE FROM char_templates WHERE ClassId=44; 
DELETE FROM char_templates WHERE ClassId=49; 
DELETE FROM char_templates WHERE ClassId=53; 

INSERT INTO 'char_templates' VALUES 
(0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 80, 6, 41, 300, 333, 33, 44, 33, 115, 81900, 140425, -124265, -1929, 0, 1.10, 1.188000, 9.0, 23.0, 1.10, 1.188000, 8.0, 23.5, 1147, 1146, 10, 2369, 5588), 
(10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 3, 54, 6, 41, 300, 333, 28, 40, 28, 120, 62500, 140425, -124265, -1929, 0, 1.01, 0.872640, 7.5, 22.8, 1.01, 0.872640, 6.5, 22.5, 425, 461, 6, 5588, 0), 
(18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 80, 6, 41, 300, 333, 36, 46, 36, 125, 73000, 140425, -124265, -1929, 0, 1.15, 1.242000, 7.5, 24.0, 1.15, 1.242000, 7.5, 23.0, 1147, 1146, 10, 2369, 5588), 
(25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 3, 54, 6, 41, 300, 333, 30, 41, 30, 122, 62400, 140425, -124265, -1929, 0, 1.04, 0.898560, 7.5, 24.0, 1.04, 0.898560, 7.5, 23.0, 425, 461, 6, 5588, 0), 
(31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 80, 6, 41, 300, 333, 35, 45, 35, 122, 69000, 140425, -124265, -1929, 0, 1.14, 1.231200, 7.5, 24.0, 1.14, 1.231200, 7.0, 23.5, 1147, 1146, 10, 2369, 5588), 
(38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 3, 54, 6, 41, 300, 333, 29, 41, 29, 122, 61000, 140425, -124265, -1929, 0, 1.14, 1.231200, 7.5, 24.0, 1.03, 0.889920, 7.0, 23.5, 425, 461, 6, 5588, 0), 
(44, 'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 80, 6, 41, 300, 333, 31, 42, 31, 117, 87000, 140425, -124265, -1929, 0, 1.06, 1.144800, 11.0, 28.0, 1.06, 1.144800, 7.0, 27.0, 1147, 1146, 2368, 2369, 5588), 
(49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 3, 54, 6, 41, 300, 333, 30, 41, 30, 121, 68000, 140425, -124265, -1929, 0, 1.04, 0.898560, 7.0, 27.5, 1.04, 0.898560, 8.0, 25.5, 425, 461, 2368, 5588, 0), 
(53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 80, 6, 41, 300, 333, 33, 43, 33, 115, 83000, 140425, -124265, -1929, 1, 1.09, 1.487196, 9.0, 18.0, 1.09, 1.487196, 5.0, 19.0, 1147, 1146, 10, 2370, 5588);

REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -83063, 150791, -3133, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588); 
REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000,  -83063, 150791, -3133, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 34, 26, 68, 4222, 5588); 
REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000,  -83063, 150791, -3133, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 34, 26, 68, 4222, 5588); 
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000,  -83063, 150791, -3133, 0, '1.06', '1.144800', 11.0, 28.0,1.06, '1.144800', 7.0, 27.0, 34, 26, 257, 0, 5588); 
REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000,  -83063, 150791, -3133, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 34, 26, 87, 4222, 5588); 
REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500,  -83063, 150791, -3133, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588); 
REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400,  -83063, 150791, -3133, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 1105, 1102, 177, 0, 5588); 
REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000,  -83063, 150791, -3133, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 1105, 1102, 177, 0, 5588); 
REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000,  -83063, 150791, -3133, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 1105, 1102, 257, 0, 5588);

INSERT INTO global_tasks (task,type,last_activation,param1,param2,param3) VALUES ('restart','TYPE_GLOBAL_TASK','0','1','04:50:00','600');

INSERT INTO skill_trees VALUES (0, 150, 1, 'Weight Limit', 0, 1);   
INSERT INTO skill_trees VALUES (10, 150, 1, 'Weight Limit', 0, 1);   
INSERT INTO skill_trees VALUES (18, 150, 1, 'Weight Limit', 0, 1);   
INSERT INTO skill_trees VALUES (25, 150, 1, 'Weight Limit', 0, 1);   
INSERT INTO skill_trees VALUES (31, 150, 1, 'Weight Limit', 0, 1);   
INSERT INTO skill_trees VALUES (38, 150, 1, 'Weight Limit', 0, 1);   
INSERT INTO skill_trees VALUES (44, 150, 1, 'Weight Limit', 0, 1);   
INSERT INTO skill_trees VALUES (49, 150, 1, 'Weight Limit', 0, 1);   
INSERT INTO skill_trees VALUES (53, 150, 1, 'Weight Limit'', 0, 1);

REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3,   
47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8,   
'23.5', 34, 26, 68, 4222, 5588);   
REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345,   
249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5',   
23, 34, 26, 68, 4222, 5588);   
REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342,   
226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7,   
'23.5', 34, 26, 68, 4222, 5588);   
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318,   
226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0,1.06, '1.144800',   
7.0, 27.0, 34, 26, 257, 0, 5588);   
REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48,   
327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09',   
'1.487196', 5, 19, 34, 26, 87, 4222, 5588);   
REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303,   
333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01',   
'0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588);   
REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312,   
386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856',   
'7.5', 23, 1105, 1102, 177, 0, 5588);   
REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309,   
316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7,   
'23.5', 1105, 1102, 177, 0, 5588);   
REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312,   
265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856',   
8, '25.5', 1105, 1102, 257, 0, 5588);

DELETE FROM 'droplist' WHERE ('itemId'!='57') AND ('category'='-1')

UPDATE 'droplist' SET 'droplist'.'chance'=1000000 WHERE 'droplist'.'itemId'=57;

update etcitem set price=5 where price > 1;   
update weapon set price=5 where price > 1;   
update armor set price=5 where price > 1;

update etcitem set weight=1 where weight> 1; 
update weapon set weight=1 where weight> 1; 
update armor set weight=1 where weight > 1;

DELETE FROM droplist WHERE itemId in (1674,1675,1676,1677,1678,1679,1680,1681,1682,1683 ,1684,1685,1686,1687,1688,1689,1690,1691,1692,1693 ,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703 ,1704,1705,1706,1707,1708,1709,1710,1711,1712,1713 ,1714,1715,1716,1717,1718,1719,1720,1721,1722,1723 ,1724,1725,1726,1727,1728,1729,1730,1731,1732,1733 ,1734,1735,1736,1737,1738,1739,1740,1741,1742,1743 ,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753 ,1754,1755,1756,1757,1758,1759,1760,1761,1762,1763 ,1764,1765,1766,1767,1768,1769,1770,1771,1772,1773 ,1774,1775,1776,1777,1778,1779,1780,1781,1782,1783 ,1784,1785,1864,1865,1866,1867,1868,1869,1870,1871 ,1872,1873,1874,1875,1876,1877,1878,1879,1880,1881 ,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891 ,1892,1893,1894,1895,1896,1897,1898,1899,1900,1901 ,1902,1903,1904,1905,1906,1907,1908,1909,1910,1911 ,1912,1913,1914,1915,1916,1917,1918,1919,1920,1921 ,1922,1923,1924,1925,1926,1927,1928,1929,1930,1931 ,1932,1933,1934,1935,1936,1937,1938,1939,1940,1941 ,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951 ,1952,1953,1954,1955,1956,1957,1958,1959,1960,1961 ,1962,1963,1964,1965,1966,1967,1968,1969,1970,1971 ,1972,1973,1974,1975,1976,1977,1978,1979,1980,1981 ,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991 ,1992,1993,1994,1995,1996,1997,1998,1999,2000,2001 ,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011 ,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021 ,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031 ,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041 ,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051 ,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061 ,2062,2063,2064,2065,2066,2067,2068,2069,2070,2071 ,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081 ,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091 ,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101 ,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111 ,2112,2113,2114,2115,2116,2117,2118,2119,2120,2121 ,2122,2123,2124,2125,2126,2127,2128,2129,2130,2131 ,2132,2133,2134,2508,2917,2918,2919,2920,2921,2922 ,2923,2924,2925,2926,2927,2928,2929,2930,2931,2932 ,2933,2934,2935,2936,2937,2938,2939,2940,2941,2942 ,2943,2944,2945,2946,2947,2948,2949,2950,2951,2952 ,2953,2954,2955,2956,2957,2958,2959,2960,2961,2962 ,2963,2964,2965,2966,2967,2968,2969,3031,4039,4040 ,4041,4042,4043,4044,4045,4046,4047,4048,4049,4050 ,4051,4052,4053,4054,4055,4056,4057,4058,4059,4060 ,4061,4062,4063,4064,4065,4066,4067,4068,4069,4070 ,4071,4072,4073,4074,4075,4076,4077,4078,4079,4080 ,4081,4082,4083,4084,4085,4086,4087,4088,4089,4090 ,4091,4092,4093,4094,4095,4096,4097,4098,4099,4100 ,4101,4102,4103,4104,4105,4106,4107,4108,4109,4110 ,4111,4112,4113,4114,4115,4116,4117,4118,4119,4120 ,4121,4438,4439,5220,5478,5479,5480,5481,5482,5483 ,5484,5485,5486,5487,5488,5489,5490,5491,5492,5493 ,5494,5495,5496,5497,5498,5499,5500,5501,5502,5503 ,5504,5505,5506,5507,5508,5509,5510,5511,5512,5513 ,5514,5515,5516,5517,5518,5519,5520,5521,5522,5523 ,5524,5525,5526,5527,5528,5529,5530,5531,5532,5533 ,5534,5535,5536,5537,5538,5539,5540,5541,5542,5543 ,5544,5545,5546,5547,5548,5549,5550,5551,5552,5553 ,5554,5556,5557,5558,5559,5757,5758,5759,5760,5761 ,5762,5763,5764,6341,6342,6343,6344,6345,6346,6688 ,6689,6690,6691,6692,6693,6694,6695,6696,6697,6698 ,6699,6700,6701,6702,6703,6704,6705,6706,6707,6708 ,6709,6710,6711,6712,6713,6714,6904,6905,6906,6907 ,6908,6909,6910,6911,6912,6913,6914,6915,6916,7579 ,7684,7685,7686,7687,7688,7697,7698,8327,8328,8329 ,8330,8331,8332,8333,8334,8335,8336,8337,8338,8339 ,8340,8341,8342,8343,8344,8345,8346,8347,8348,8349 ,8351,8352,8353,8354,8355,8356,8357,8358,8359,8373 ,8374,8375,8376,8377,8378,8553,8658,8712,8713,8714 ,8715,8716,8717,8718,8719,8720,8721,8722,8723,8724 ,8725,8726,8727,8728,8729,8730,8731,8732,8733,8734 ,8735,8736,8737,8738,8739,8740,8741,8742,8743,8744 ,8745,8746,8747,8748,8749,8750,8751,8752,8753,8754 ,8755,8756,8757,8758,8759,8760,8761,8762,8764,8773 ,8777,8778,8781,8783,8784,8787,8868,8873,8874,8875 ,8876,9168,9169,9170,9530,9531,9532,9533,9534,9535 ,9536,9537,9538,9539,9540,9541,9542,9543,9544,9545 ,9573,9574,9575,9576,9616,9617,9618,9619,9620,9621 ,9622,9623,9624,9628,9629,9630,9631,9675,9693,9785 ,9991,9992,9993,10272,10397,10398,10399,10400,1040 1,10402,10403,10404,10405,10406,10407,10483,10484, 10485,10486,10546,10547);

DELETE FROM droplist WHERE itemId='1864'; 
DELETE FROM droplist WHERE itemId='1865'; 
DELETE FROM droplist WHERE itemId='1866'; 
DELETE FROM droplist WHERE itemId='1867'; 
DELETE FROM droplist WHERE itemId='1868'; 
DELETE FROM droplist WHERE itemId='1869'; 
DELETE FROM droplist WHERE itemId='1870'; 
DELETE FROM droplist WHERE itemId='1871'; 
DELETE FROM droplist WHERE itemId='1872'; 
DELETE FROM droplist WHERE itemId='1873'; 
DELETE FROM droplist WHERE itemId='1874'; 
DELETE FROM droplist WHERE itemId='1875'; 
DELETE FROM droplist WHERE itemId='1876'; 
DELETE FROM droplist WHERE itemId='1877'; 
DELETE FROM droplist WHERE itemId='1878'; 
DELETE FROM droplist WHERE itemId='1879'; 
DELETE FROM droplist WHERE itemId='1880'; 
DELETE FROM droplist WHERE itemId='1881'; 
DELETE FROM droplist WHERE itemId='1882'; 
DELETE FROM droplist WHERE itemId='1883'; 
DELETE FROM droplist WHERE itemId='1884'; 
DELETE FROM droplist WHERE itemId='1885'; 
DELETE FROM droplist WHERE itemId='1886'; 
DELETE FROM droplist WHERE itemId='1887'; 
DELETE FROM droplist WHERE itemId='1888'; 
DELETE FROM droplist WHERE itemId='1889'; 
DELETE FROM droplist WHERE itemId='1890'; 
DELETE FROM droplist WHERE itemId='1891'; 
DELETE FROM droplist WHERE itemId='1892'; 
DELETE FROM droplist WHERE itemId='1893'; 
DELETE FROM droplist WHERE itemId='1894'; 
DELETE FROM droplist WHERE itemId='1895';

INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000'); 
INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000'); 
INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000'); 
INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000'); 
INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000'); 
INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000'); 
INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000');

мин.вpeмя - 1 чac 
мaкc.вpeмя - 2 чaca
UPDATE 'raidboss_spawnlist' SET 'respawn_min_delay' = '3600'; 
UPDATE 'raidboss_spawnlist' SET 'respawn_max_delay' = '7200';

DELETE FROM droplist WHERE itemId='1864';
DELETE FROM droplist WHERE itemId='1865';
DELETE FROM droplist WHERE itemId='1866';
DELETE FROM droplist WHERE itemId='1868';
DELETE FROM droplist WHERE itemId='1869';
DELETE FROM droplist WHERE itemId='1870';
DELETE FROM droplist WHERE itemId='1871';
DELETE FROM droplist WHERE itemId='1872';
DELETE FROM droplist WHERE itemId='1873';
DELETE FROM droplist WHERE itemId='1874';
DELETE FROM droplist WHERE itemId='1875';
DELETE FROM droplist WHERE itemId='1876';
DELETE FROM droplist WHERE itemId='1877';
DELETE FROM droplist WHERE itemId='1878';
DELETE FROM droplist WHERE itemId='1879';
DELETE FROM droplist WHERE itemId='1880';
DELETE FROM droplist WHERE itemId='1881';
DELETE FROM droplist WHERE itemId='1882';
DELETE FROM droplist WHERE itemId='1884';
DELETE FROM droplist WHERE itemId='1885';
DELETE FROM droplist WHERE itemId='1895';
DELETE FROM droplist WHERE itemId='5549';
DELETE FROM droplist WHERE itemId='1886';
DELETE FROM droplist WHERE itemId='1887';
DELETE FROM droplist WHERE itemId='1888';
DELETE FROM droplist WHERE itemId='1890';
DELETE FROM droplist WHERE itemId='1891';
DELETE FROM droplist WHERE itemId='1892';
DELETE FROM droplist WHERE itemId='1893';
DELETE FROM droplist WHERE itemId='1889';
DELETE FROM droplist WHERE itemId='1894';
DELETE FROM droplist WHERE itemId='4039';
DELETE FROM droplist WHERE itemId='4040';
DELETE FROM droplist WHERE itemId='4041';
DELETE FROM droplist WHERE itemId='4042';
DELETE FROM droplist WHERE itemId='4043';
DELETE FROM droplist WHERE itemId='4044';
DELETE FROM droplist WHERE itemId='4046';
DELETE FROM droplist WHERE itemId='4047';
DELETE FROM droplist WHERE itemId='4045';
DELETE FROM droplist WHERE itemId='5550';
DELETE FROM droplist WHERE itemId='4048';

DELETE FROM droplist WHERE itemId='17';
DELETE FROM droplist WHERE itemId='1341';
DELETE FROM droplist WHERE itemId='1342';
DELETE FROM droplist WHERE itemId='1343';
DELETE FROM droplist WHERE itemId='1344';
DELETE FROM droplist WHERE itemId='1345';
DELETE FROM droplist WHERE itemId='4048';

DELETE FROM droplist WHERE itemId='1539';
DELETE FROM droplist WHERE itemId='5591';
DELETE FROM droplist WHERE itemId='5592';

DELETE FROM droplist WHERE itemId='2508';

DELETE FROM droplist WHERE itemId='736';
DELETE FROM droplist WHERE itemId='1829';
DELETE FROM droplist WHERE itemId='1830';
DELETE FROM droplist WHERE itemId='737';
DELETE FROM droplist WHERE itemId='1538';

DELETE FROM 'droplist' WHERE 'itemId'=1047;
DELETE FROM 'droplist' WHERE 'itemId'=1048;
DELETE FROM 'droplist' WHERE 'itemId'=1049;
DELETE FROM 'droplist' WHERE 'itemId'=1050;
DELETE FROM 'droplist' WHERE 'itemId'=1047;
DELETE FROM 'droplist' WHERE 'itemId'=1050;
DELETE FROM 'droplist' WHERE 'itemId'=1051;
DELETE FROM 'droplist' WHERE 'itemId'=1052;
DELETE FROM 'droplist' WHERE 'itemId'=1053;
DELETE FROM 'droplist' WHERE 'itemId'=1054;
DELETE FROM 'droplist' WHERE 'itemId'=1055;
DELETE FROM 'droplist' WHERE 'itemId'=1056;
DELETE FROM 'droplist' WHERE 'itemId'=1057;
DELETE FROM 'droplist' WHERE 'itemId'=1058;
DELETE FROM 'droplist' WHERE 'itemId'=1059;
DELETE FROM 'droplist' WHERE 'itemId'=1095;
DELETE FROM 'droplist' WHERE 'itemId'=1096;
DELETE FROM 'droplist' WHERE 'itemId'=1097;
DELETE FROM 'droplist' WHERE 'itemId'=1098;
DELETE FROM 'droplist' WHERE 'itemId'=1099;
DELETE FROM 'droplist' WHERE 'itemId'=1150;
DELETE FROM 'droplist' WHERE 'itemId'=1151;
DELETE FROM 'droplist' WHERE 'itemId'=1152;
DELETE FROM 'droplist' WHERE 'itemId'=1377;
DELETE FROM 'droplist' WHERE 'itemId'=1378;
DELETE FROM 'droplist' WHERE 'itemId'=1379;
DELETE FROM 'droplist' WHERE 'itemId'=1380;
DELETE FROM 'droplist' WHERE 'itemId'=1380;
DELETE FROM 'droplist' WHERE 'itemId'=1382;
DELETE FROM 'droplist' WHERE 'itemId'=1383;
DELETE FROM 'droplist' WHERE 'itemId'=1384;
DELETE FROM 'droplist' WHERE 'itemId'=1385;
DELETE FROM 'droplist' WHERE 'itemId'=1386;
DELETE FROM 'droplist' WHERE 'itemId'=1387;
DELETE FROM 'droplist' WHERE 'itemId'=1388;
DELETE FROM 'droplist' WHERE 'itemId'=1389;
DELETE FROM 'droplist' WHERE 'itemId'=1390;
DELETE FROM 'droplist' WHERE 'itemId'=1391;
DELETE FROM 'droplist' WHERE 'itemId'=1392;
DELETE FROM 'droplist' WHERE 'itemId'=1393;
DELETE FROM 'droplist' WHERE 'itemId'=1394;
DELETE FROM 'droplist' WHERE 'itemId'=1395;
DELETE FROM 'droplist' WHERE 'itemId'=1396;
DELETE FROM 'droplist' WHERE 'itemId'=1397;
DELETE FROM 'droplist' WHERE 'itemId'=1398;
DELETE FROM 'droplist' WHERE 'itemId'=1399;
DELETE FROM 'droplist' WHERE 'itemId'=1400;
DELETE FROM 'droplist' WHERE 'itemId'=1401;
DELETE FROM 'droplist' WHERE 'itemId'=1402;
DELETE FROM 'droplist' WHERE 'itemId'=1403;
DELETE FROM 'droplist' WHERE 'itemId'=1404;
DELETE FROM 'droplist' WHERE 'itemId'=1405;
DELETE FROM 'droplist' WHERE 'itemId'=1406;
DELETE FROM 'droplist' WHERE 'itemId'=1407;
DELETE FROM 'droplist' WHERE 'itemId'=1408;
DELETE FROM 'droplist' WHERE 'itemId'=1409;
DELETE FROM 'droplist' WHERE 'itemId'=1410;
DELETE FROM 'droplist' WHERE 'itemId'=1411;
DELETE FROM 'droplist' WHERE 'itemId'=1412;
DELETE FROM 'droplist' WHERE 'itemId'=1413;
DELETE FROM 'droplist' WHERE 'itemId'=1414;
DELETE FROM 'droplist' WHERE 'itemId'=1415;
DELETE FROM 'droplist' WHERE 'itemId'=1416;
DELETE FROM 'droplist' WHERE 'itemId'=1417;
DELETE FROM 'droplist' WHERE 'itemId'=1418;
DELETE FROM 'droplist' WHERE 'itemId'=1512;
DELETE FROM 'droplist' WHERE 'itemId'=1513;
DELETE FROM 'droplist' WHERE 'itemId'=1514;
DELETE FROM 'droplist' WHERE 'itemId'=1516;
DELETE FROM 'droplist' WHERE 'itemId'=1515;
DELETE FROM 'droplist' WHERE 'itemId'=1517;
DELETE FROM 'droplist' WHERE 'itemId'=1518;
DELETE FROM 'droplist' WHERE 'itemId'=1519;
DELETE FROM 'droplist' WHERE 'itemId'=1520;
DELETE FROM 'droplist' WHERE 'itemId'=1521;
DELETE FROM 'droplist' WHERE 'itemId'=1522;
DELETE FROM 'droplist' WHERE 'itemId'=1523;
DELETE FROM 'droplist' WHERE 'itemId'=1524;
DELETE FROM 'droplist' WHERE 'itemId'=1525;
DELETE FROM 'droplist' WHERE 'itemId'=1526;
DELETE FROM 'droplist' WHERE 'itemId'=1527;
DELETE FROM 'droplist' WHERE 'itemId'=1528;
DELETE FROM 'droplist' WHERE 'itemId'=1528;
DELETE FROM 'droplist' WHERE 'itemId'=1530;
DELETE FROM 'droplist' WHERE 'itemId'=1531;
DELETE FROM 'droplist' WHERE 'itemId'=1532;
DELETE FROM 'droplist' WHERE 'itemId'=1533;
DELETE FROM 'droplist' WHERE 'itemId'=1534;
DELETE FROM 'droplist' WHERE 'itemId'=1535;
DELETE FROM 'droplist' WHERE 'itemId'=1536;
DELETE FROM 'droplist' WHERE 'itemId'=1537;
DELETE FROM 'droplist' WHERE 'itemId'=1667;
DELETE FROM 'droplist' WHERE 'itemId'=1668;
DELETE FROM 'droplist' WHERE 'itemId'=1669;
DELETE FROM 'droplist' WHERE 'itemId'=1670;
DELETE FROM 'droplist' WHERE 'itemId'=1671;
DELETE FROM 'droplist' WHERE 'itemId'=1856;
DELETE FROM 'droplist' WHERE 'itemId'=3038;
DELETE FROM 'droplist' WHERE 'itemId'=3039;
DELETE FROM 'droplist' WHERE 'itemId'=3040;
DELETE FROM 'droplist' WHERE 'itemId'=3041;
DELETE FROM 'droplist' WHERE 'itemId'=3042;
DELETE FROM 'droplist' WHERE 'itemId'=3043;
DELETE FROM 'droplist' WHERE 'itemId'=3044;
DELETE FROM 'droplist' WHERE 'itemId'=3045;
DELETE FROM 'droplist' WHERE 'itemId'=3046;
DELETE FROM 'droplist' WHERE 'itemId'=3047;
DELETE FROM 'droplist' WHERE 'itemId'=3048;
DELETE FROM 'droplist' WHERE 'itemId'=3049;
DELETE FROM 'droplist' WHERE 'itemId'=3050;
DELETE FROM 'droplist' WHERE 'itemId'=3051;
DELETE FROM 'droplist' WHERE 'itemId'=3052;
DELETE FROM 'droplist' WHERE 'itemId'=3053;
DELETE FROM 'droplist' WHERE 'itemId'=3054;
DELETE FROM 'droplist' WHERE 'itemId'=3055;
DELETE FROM 'droplist' WHERE 'itemId'=3056;
DELETE FROM 'droplist' WHERE 'itemId'=3057;
DELETE FROM 'droplist' WHERE 'itemId'=3058;
DELETE FROM 'droplist' WHERE 'itemId'=3059;
DELETE FROM 'droplist' WHERE 'itemId'=3060;
DELETE FROM 'droplist' WHERE 'itemId'=3061;
DELETE FROM 'droplist' WHERE 'itemId'=3062;
DELETE FROM 'droplist' WHERE 'itemId'=3063;
DELETE FROM 'droplist' WHERE 'itemId'=3064;
DELETE FROM 'droplist' WHERE 'itemId'=3065;
DELETE FROM 'droplist' WHERE 'itemId'=3066;
DELETE FROM 'droplist' WHERE 'itemId'=3067;
DELETE FROM 'droplist' WHERE 'itemId'=3068;
DELETE FROM 'droplist' WHERE 'itemId'=3069;
DELETE FROM 'droplist' WHERE 'itemId'=3070;
DELETE FROM 'droplist' WHERE 'itemId'=3071;
DELETE FROM 'droplist' WHERE 'itemId'=3072;
DELETE FROM 'droplist' WHERE 'itemId'=3073;
DELETE FROM 'droplist' WHERE 'itemId'=3074;
DELETE FROM 'droplist' WHERE 'itemId'=3075;
DELETE FROM 'droplist' WHERE 'itemId'=3076;
DELETE FROM 'droplist' WHERE 'itemId'=3077;
DELETE FROM 'droplist' WHERE 'itemId'=3078;
DELETE FROM 'droplist' WHERE 'itemId'=3079;
DELETE FROM 'droplist' WHERE 'itemId'=3080;
DELETE FROM 'droplist' WHERE 'itemId'=3081;
DELETE FROM 'droplist' WHERE 'itemId'=3082;
DELETE FROM 'droplist' WHERE 'itemId'=3083;
DELETE FROM 'droplist' WHERE 'itemId'=3084;
DELETE FROM 'droplist' WHERE 'itemId'=3085;
DELETE FROM 'droplist' WHERE 'itemId'=3086;
DELETE FROM 'droplist' WHERE 'itemId'=3087;
DELETE FROM 'droplist' WHERE 'itemId'=3088;
DELETE FROM 'droplist' WHERE 'itemId'=3089;
DELETE FROM 'droplist' WHERE 'itemId'=3090;
DELETE FROM 'droplist' WHERE 'itemId'=3091;
DELETE FROM 'droplist' WHERE 'itemId'=3092;
DELETE FROM 'droplist' WHERE 'itemId'=3093;
DELETE FROM 'droplist' WHERE 'itemId'=3094;
DELETE FROM 'droplist' WHERE 'itemId'=3095;
DELETE FROM 'droplist' WHERE 'itemId'=3096;
DELETE FROM 'droplist' WHERE 'itemId'=3097;
DELETE FROM 'droplist' WHERE 'itemId'=3098;
DELETE FROM 'droplist' WHERE 'itemId'=3099;
DELETE FROM 'droplist' WHERE 'itemId'=3100;
DELETE FROM 'droplist' WHERE 'itemId'=3101;
DELETE FROM 'droplist' WHERE 'itemId'=3102;
DELETE FROM 'droplist' WHERE 'itemId'=3103;
DELETE FROM 'droplist' WHERE 'itemId'=3104;
DELETE FROM 'droplist' WHERE 'itemId'=3105;
DELETE FROM 'droplist' WHERE 'itemId'=3106;
DELETE FROM 'droplist' WHERE 'itemId'=3107;
DELETE FROM 'droplist' WHERE 'itemId'=3108;
DELETE FROM 'droplist' WHERE 'itemId'=3109;
DELETE FROM 'droplist' WHERE 'itemId'=3110;
DELETE FROM 'droplist' WHERE 'itemId'=3111;
DELETE FROM 'droplist' WHERE 'itemId'=3112;
DELETE FROM 'droplist' WHERE 'itemId'=3113;
DELETE FROM 'droplist' WHERE 'itemId'=3114;
DELETE FROM 'droplist' WHERE 'itemId'=3115;
DELETE FROM 'droplist' WHERE 'itemId'=3116;
DELETE FROM 'droplist' WHERE 'itemId'=3117;
DELETE FROM 'droplist' WHERE 'itemId'=3118;
DELETE FROM 'droplist' WHERE 'itemId'=3429;
DELETE FROM 'droplist' WHERE 'itemId'=3430;
DELETE FROM 'droplist' WHERE 'itemId'=3431;
DELETE FROM 'droplist' WHERE 'itemId'=3432;
DELETE FROM 'droplist' WHERE 'itemId'=3941;
DELETE FROM 'droplist' WHERE 'itemId'=3942;
DELETE FROM 'droplist' WHERE 'itemId'=3944;
DELETE FROM 'droplist' WHERE 'itemId'=4200;
DELETE FROM 'droplist' WHERE 'itemId'=4201;
DELETE FROM 'droplist' WHERE 'itemId'=4202;
DELETE FROM 'droplist' WHERE 'itemId'=4203;
DELETE FROM 'droplist' WHERE 'itemId'=4206;
DELETE FROM 'droplist' WHERE 'itemId'=4207;
DELETE FROM 'droplist' WHERE 'itemId'=4208;
DELETE FROM 'droplist' WHERE 'itemId'=4906;
DELETE FROM 'droplist' WHERE 'itemId'=4907;
DELETE FROM 'droplist' WHERE 'itemId'=4908;
DELETE FROM 'droplist' WHERE 'itemId'=4909;
DELETE FROM 'droplist' WHERE 'itemId'=4910;
DELETE FROM 'droplist' WHERE 'itemId'=4911;
DELETE FROM 'droplist' WHERE 'itemId'=4912;
DELETE FROM 'droplist' WHERE 'itemId'=4913;
DELETE FROM 'droplist' WHERE 'itemId'=4914;
DELETE FROM 'droplist' WHERE 'itemId'=4916;
DELETE FROM 'droplist' WHERE 'itemId'=4917;
DELETE FROM 'droplist' WHERE 'itemId'=4918;
DELETE FROM 'droplist' WHERE 'itemId'=4919;
DELETE FROM 'droplist' WHERE 'itemId'=4920;
DELETE FROM 'droplist' WHERE 'itemId'=4922;
DELETE FROM 'droplist' WHERE 'itemId'=4923;
DELETE FROM 'droplist' WHERE 'itemId'=4924;
DELETE FROM 'droplist' WHERE 'itemId'=4928;
DELETE FROM 'droplist' WHERE 'itemId'=4929;
DELETE FROM 'droplist' WHERE 'itemId'=4930;
DELETE FROM 'droplist' WHERE 'itemId'=4931;
DELETE FROM 'droplist' WHERE 'itemId'=4932;
DELETE FROM 'droplist' WHERE 'itemId'=4933;
DELETE FROM 'droplist' WHERE 'itemId'=4934;
DELETE FROM 'droplist' WHERE 'itemId'=4935;
DELETE FROM 'droplist' WHERE 'itemId'=5013;
DELETE FROM 'droplist' WHERE 'itemId'=5014;
DELETE FROM 'droplist' WHERE 'itemId'=5015;
DELETE FROM 'droplist' WHERE 'itemId'=5809;
DELETE FROM 'droplist' WHERE 'itemId'=5810;
DELETE FROM 'droplist' WHERE 'itemId'=5811;
DELETE FROM 'droplist' WHERE 'itemId'=5812;
DELETE FROM 'droplist' WHERE 'itemId'=5813;
DELETE FROM 'droplist' WHERE 'itemId'=5814;
DELETE FROM 'droplist' WHERE 'itemId'=5815;
DELETE FROM 'droplist' WHERE 'itemId'=5816;
DELETE FROM 'droplist' WHERE 'itemId'=6350;
DELETE FROM 'droplist' WHERE 'itemId'=6351;
DELETE FROM 'droplist' WHERE 'itemId'=6352;
DELETE FROM 'droplist' WHERE 'itemId'=6395;
DELETE FROM 'droplist' WHERE 'itemId'=6396;
DELETE FROM 'droplist' WHERE 'itemId'=6397;
DELETE FROM 'droplist' WHERE 'itemId'=6398;
DELETE FROM 'droplist' WHERE 'itemId'=7638;
DELETE FROM 'droplist' WHERE 'itemId'=7639;
DELETE FROM 'droplist' WHERE 'itemId'=7640;
DELETE FROM 'droplist' WHERE 'itemId'=7641;
DELETE FROM 'droplist' WHERE 'itemId'=7642;
DELETE FROM 'droplist' WHERE 'itemId'=7643;
DELETE FROM 'droplist' WHERE 'itemId'=7644;
DELETE FROM 'droplist' WHERE 'itemId'=7645;
DELETE FROM 'droplist' WHERE 'itemId'=7646;
DELETE FROM 'droplist' WHERE 'itemId'=7647;
DELETE FROM 'droplist' WHERE 'itemId'=7648;
DELETE FROM 'droplist' WHERE 'itemId'=7649;
DELETE FROM 'droplist' WHERE 'itemId'=7650;
DELETE FROM 'droplist' WHERE 'itemId'=7651;
DELETE FROM 'droplist' WHERE 'itemId'=7652;
DELETE FROM 'droplist' WHERE 'itemId'=7653;
DELETE FROM 'droplist' WHERE 'itemId'=7654;
DELETE FROM 'droplist' WHERE 'itemId'=7655;
DELETE FROM 'droplist' WHERE 'itemId'=7656;
DELETE FROM 'droplist' WHERE 'itemId'=7657;
DELETE FROM 'droplist' WHERE 'itemId'=7658;
DELETE FROM 'droplist' WHERE 'itemId'=7659;
DELETE FROM 'droplist' WHERE 'itemId'=7660;
DELETE FROM 'droplist' WHERE 'itemId'=7661;
DELETE FROM 'droplist' WHERE 'itemId'=7652;
DELETE FROM 'droplist' WHERE 'itemId'=7663;
DELETE FROM 'droplist' WHERE 'itemId'=7664;
DELETE FROM 'droplist' WHERE 'itemId'=7665;
DELETE FROM 'droplist' WHERE 'itemId'=7666;
DELETE FROM 'droplist' WHERE 'itemId'=7667;
DELETE FROM 'droplist' WHERE 'itemId'=7668;
DELETE FROM 'droplist' WHERE 'itemId'=7669;
DELETE FROM 'droplist' WHERE 'itemId'=7670;
DELETE FROM 'droplist' WHERE 'itemId'=7671;
DELETE FROM 'droplist' WHERE 'itemId'=7672;
DELETE FROM 'droplist' WHERE 'itemId'=7673;
DELETE FROM 'droplist' WHERE 'itemId'=7674;
DELETE FROM 'droplist' WHERE 'itemId'=7675;
DELETE FROM 'droplist' WHERE 'itemId'=7676;
DELETE FROM 'droplist' WHERE 'itemId'=7835;
DELETE FROM 'droplist' WHERE 'itemId'=8380;
DELETE FROM 'droplist' WHERE 'itemId'=8381;
DELETE FROM 'droplist' WHERE 'itemId'=8382;
DELETE FROM 'droplist' WHERE 'itemId'=8383;
DELETE FROM 'droplist' WHERE 'itemId'=8384;
DELETE FROM 'droplist' WHERE 'itemId'=8385;
DELETE FROM 'droplist' WHERE 'itemId'=8386;
DELETE FROM 'droplist' WHERE 'itemId'=8387;
DELETE FROM 'droplist' WHERE 'itemId'=8388;
DELETE FROM 'droplist' WHERE 'itemId'=8389;
DELETE FROM 'droplist' WHERE 'itemId'=8390;
DELETE FROM 'droplist' WHERE 'itemId'=8391;
DELETE FROM 'droplist' WHERE 'itemId'=8392;
DELETE FROM 'droplist' WHERE 'itemId'=8393;
DELETE FROM 'droplist' WHERE 'itemId'=8394;
DELETE FROM 'droplist' WHERE 'itemId'=8395;
DELETE FROM 'droplist' WHERE 'itemId'=8396;
DELETE FROM 'droplist' WHERE 'itemId'=8397;
DELETE FROM 'droplist' WHERE 'itemId'=8398;
DELETE FROM 'droplist' WHERE 'itemId'=8399;
DELETE FROM 'droplist' WHERE 'itemId'=8400;
DELETE FROM 'droplist' WHERE 'itemId'=8401;
DELETE FROM 'droplist' WHERE 'itemId'=8402;
DELETE FROM 'droplist' WHERE 'itemId'=8616;
DELETE FROM 'droplist' WHERE 'itemId'=8617;
DELETE FROM 'droplist' WHERE 'itemId'=8877;
DELETE FROM 'droplist' WHERE 'itemId'=8878;
DELETE FROM 'droplist' WHERE 'itemId'=8879;
DELETE FROM 'droplist' WHERE 'itemId'=8880;
DELETE FROM 'droplist' WHERE 'itemId'=8881;
DELETE FROM 'droplist' WHERE 'itemId'=8882;
DELETE FROM 'droplist' WHERE 'itemId'=8883;
DELETE FROM 'droplist' WHERE 'itemId'=8884;
DELETE FROM 'droplist' WHERE 'itemId'=8885;
DELETE FROM 'droplist' WHERE 'itemId'=8886;
DELETE FROM 'droplist' WHERE 'itemId'=8888;
DELETE FROM 'droplist' WHERE 'itemId'=8889;
DELETE FROM 'droplist' WHERE 'itemId'=8890;
DELETE FROM 'droplist' WHERE 'itemId'=8891;
DELETE FROM 'droplist' WHERE 'itemId'=8945;
DELETE FROM 'droplist' WHERE 'itemId'=8946;

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' );

DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' );

DELETE FROM droplist WHERE itemId NOT IN (57,4037,8191,6662,6661,6660,6659,6658,6657,6656,8762,8160,8163,8166,8169,8172,8175,8176);

DELETE FROM droplist 
WHERE mobid NOT IN (SELECT id FROM npc WHERE TYPE = 'L2GrandBoss') 
AND mobid NOT IN (SELECT id FROM npc WHERE TYPE = 'L2RaidBoss') 
AND itemid NOT IN (SELECT item_id FROM weapon) 
AND itemid NOT IN (SELECT item_id FROM armor) 
AND itemid NOT IN (SELECT item_id FROM etcitem WHERE name LIKE 'adena') 
AND itemid NOT IN (SELECT item_id FROM etcitem WHERE name LIKE '%life stone%') 
AND itemid NOT IN (SELECT item_id FROM etcitem WHERE name LIKE '%seal stone%') 
AND itemid NOT IN (SELECT item_id FROM etcitem WHERE name LIKE '%enchant%' AND item_type = 'scroll')

DELETE FROM droplist WHERE itemId NOT IN (57,4037);

INSERT INTO skill_trees VALUES (0, 1050, 2, 'Return', 0, 1);
INSERT INTO skill_trees VALUES (10, 1050, 2, 'Return', 0, 1);
INSERT INTO skill_trees VALUES (18, 1050, 2, 'Return', 0, 1);
INSERT INTO skill_trees VALUES (25, 1050, 2, 'Return', 0, 1);
INSERT INTO skill_trees VALUES (31, 1050, 2, 'Return', 0, 1);
INSERT INTO skill_trees VALUES (38, 1050, 2, 'Return', 0, 1);
INSERT INTO skill_trees VALUES (44, 1050, 2, 'Return', 0, 1);
INSERT INTO skill_trees VALUES (49, 1050, 2, 'Return', 0, 1);
INSERT INTO skill_trees VALUES (53, 1050, 2, 'Return', 0, 1);
INSERT INTO skill_trees VALUES (123, 1050, 2, 'Return', 0, 1);
INSERT INTO skill_trees VALUES (124, 1050, 2, 'Return', 0, 1);

INSERT INTO 'clan_skills' VALUES
('ид_клана','370','3','Clan Vitality'),
('ид_клана','371','3','Clan Spirituality'),
('ид_клана','372','3','Clan Essence'),
('ид_клана','373','3','Clan Lifeblood'),
('ид_клана','374','3','Clan Morale'),
('ид_клана','375','3','Clan  Clarity'),
('ид_клана','376','3','Clan  Might'),
('ид_клана','377','3','Clan Aegis'),
('ид_клана','378','3','Clan Empowerment'),
('ид_клана','379','3','Clan Magic Protection'),
('ид_клана','380','3','Clan Guidance'),
('ид_клана','381','3','Clan Agility'),
('ид_клана','382','3','Clan Withstand-Attack'),
('ид_клана','383','3','Clan Shield Boost'),
('ид_клана','384','3','Clan Cyclonic Resistance'),
('ид_клана','385','3','Clan Magmatic Resistance'),
('ид_клана','386','3','Clan Fortitude'),
('ид_клана','387','3','Clan Freedom'),
('ид_клана','388','3','Clan Vigilance'),
('ид_клана','389','3','Clan March'),
('ид_клана','390','3','Clan Luck'),
('ид_клана','391','1','Clan Imperium');

UPDATE enchant_skill_trees SET sp=0;
UPDATE enchant_skill_trees SET exp=0;

DELETE FROM skill_trees WHERE skill_id = 239;

UPDATE 'raidboss_spawnlist' SET 'respawn_min_delay' = '3600';
UPDATE 'raidboss_spawnlist' SET 'respawn_max_delay' = '7200';

UPDATE 'npc' SET 'hp'='5000000' WHERE (SELECT id) AND npc.type='L2Raidboss';

INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000');
INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000');
INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000');
INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000');
INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000');
INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000');
INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000');

REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588);
REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 34, 26, 68, 4222, 5588);
REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 34, 26, 68, 4222, 5588);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0 ,1.06, '1.144800', 7.0, 27.0, 34, 26, 257, 0, 5588);
REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 34, 26, 87, 4222, 5588);
REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588);
REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 1105, 1102, 177, 0, 5588);
REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 1105, 1102, 177, 0, 5588);
REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 1105, 1102, 257, 0, 5588);

REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 395, 2424, 2448, 417,225);
REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 395, 2424, 2448, 417,225);
REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 395, 2424, 2448, 417,225);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0,1.06, '1.144800', 7.0, 27.0, 395, 2424, 2448, 417, 2499);
REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 1082426, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 395, 2424, 2448, 417, 2499);
REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 437, 470, 2450, 2426, 188);
REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 437, 470, 2450, 2426, 188);
REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 437, 470, 2450, 2426, 188);
REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 437, 470, 2450, 2426, 188);

REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 401, 2437, 2461, 499,6358);
REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 401, 2437, 2461, 499,6358);
REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 401, 2437, 2461, 499,6358);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0,1.06, '1.144800', 7.0, 27.0, 401, 2437, 2461, 499, 4710);
REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108471, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 401, 2437, 2461, 499, 4710);
REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 2430, 2454, 439, 471, 6313);
REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 2430, 2454, 439, 471, 6313);
REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 2430, 2454, 439, 471, 6313);
REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 2430, 2454, 439, 471, 6313);

REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 2392, 5739, 5723, 2417,6359);
REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 2392, 5739, 5723, 2417,6359);
REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 2392, 5739, 5723, 2417,6359);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, '1.06', '1.144800', 11.0, 28.0,1.06, '1.144800', 7.0, 27.0, 2392, 5739, 5723, 2417, 4719);
REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 1082415, -174026, -400, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 2392, 5739, 5723, 2417, 4719);
REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, '1.01', '0.87264', '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 5732, 5716, 2406, 2415, 7722);
REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 5732, 5716, 2406, 2415, 7722);
REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, '1.14', '1.2312', '7.5',
24, '1.04', '0.89856', '7.5', 23, 5732, 5716, 2406, 2415, 7722);

Теги: Полезные SQL запросы, Sql, Для новичков

Если ссылка на файл уже не работает нажмите на кнопку Нужно Авторизоватся и напишите в окне для жалобы "битая ссылка".
После этого файл будет перезалит в течении суток.

 Благодарностей: 2

kamilka, johnblack1996