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

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

Все мобы не агрятся (подходит для RT, если вам не подходит, переделайте название колонки, то есть 'agro' и значение (0))

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);

Авторестарт гейм сервера (время измените, сейчас стоит '04:50:00') :

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

Добавляем скилл всем новым чарам (за пример взят Weight Limit - 'ID класа которому даётся скилл', 'id скила', 'лвл скила', 'имя скила', ...) ) :

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);

Всем чарам при создании даётся лучшый NG шмот:

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')

Шанс дропа адены 100%:

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

Итемы в магазинах по 1 адене:

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мя pecпaвнa PeйдБoccoв:

мин.в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';

Костей (Cursed Bone)

DELETE FROM droplist WHERE itemId='2508';

Свитки телепортации (SOE)

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')

Удаление всех вещей с ID 57 (Adena) и 4037 (CoL)

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

Запросы на связанные со скиллами

Добавить скилл 'Возвращение' (Return) всем персонажам

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');

Для заточки скиллов не требуется Опыть и SP

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

Удалить скил пенальти (Great Penalty)

DELETE FROM skill_trees WHERE skill_id = 239;

Изменение Рейд Боссов и Эпик Боссов

Сделать респ всех Рейд Боссов от 1 до 2 часов

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

Повысить всем Рейд Боссам хп до 5кк

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');

Запросы на стартовый шмот у персонажей

Появление персонажа в топовом No-Grade шмоте

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);

Появление персонажа в топовом D Grade шмоте

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);

Появление персонажа в топовом C Grade шмоте

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);

Появление персонажа в топовом B Grade шмоте

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

Категория: Создание сервера Lineage 2 » Как создать свой сервер Lineage 2 | Для новичков

6927

3-11-2011, 15:59

Blayzer

Похожие новости

Удобные SQL Запросы для L2J

Как создать Эвент в Lineage 2 [Мануал]

[Мануал] по настройке TvT

мануал как сделать фарм зону

Коментарии

Информация

Посетители, находящиеся в группе Гости, не могут оставлять комментарии к данной публикации.