Мануал Полезные SQL запросы новичкам

Maxwell · 20 Май 2019

Доброго времени суток, решил добавить несколько запросов для новичков в сфере L2 серверов. Данные запросы подходят для серверов такие как L2J, L2RT.
При необходимости перевести на сборку других разработчиков Вам нужно будет изменить сам запрос. На примере первого запроса есть колонка "agro" с значением либо "0", либо "1". Могут встречаться сборки где колонка "agro" вписана как "agr" и так далее. Принцип я думаю всем понятен.
И так, погнали:

Все мобы не агрятся

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

Добавляем скилл всем новым чарам (за пример взят 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);

TakeMe · 18 Авг 2022

Пардон за наитупейший вопрос, но, я не смог найти ничего подобного на форуме. Как удалять из дропа ненужные тебе вещи к примеру ( книги, куски и т.д) если подобных данных нет в базе SQL. Более конкретно, сборка L2jMobius. Там нет подобных данных в самой базе сервера, когда-то давно занимался интерлюдом, никаких проблем не было с удалением из дроп-листа различных предметов. Но как быть в моем случае? Подскажите куда "копать", пожалуйста.

Civic · 18 Авг 2022

TakeMe написал(а):
Пардон за наитупейший вопрос, но, я не смог найти ничего подобного на форуме. Как удалять из дропа ненужные тебе вещи к примеру ( книги, куски и т.д) если подобных данных нет в базе SQL. Более конкретно, сборка L2jMobius. Там нет подобных данных в самой базе сервера, когда-то давно занимался интерлюдом, никаких проблем не было с удалением из дроп-листа различных предметов. Но как быть в моем случае? Подскажите куда "копать", пожалуйста.

Как пример в сборке L2jMobius HF дроп с мобов хранится в в ДП в самих НПС. game\data\stats\npcs
Ищите нужного моба и удаляете необходимые дроп.

XML:

        <dropLists>
            <drop>
                <item id="57" min="344" max="644" chance="70" /> <!-- Adena -->
                <item id="847" min="1" max="1" chance="0.105823286262512" /> <!-- Red Crescent Earring -->
                <item id="910" min="1" max="1" chance="0.0793674646968842" /> <!-- Necklace of Devotion -->
                <item id="1899" min="1" max="1" chance="1.71137226167655" /> <!-- Necklace of Devotion Chain -->
                <item id="890" min="1" max="1" chance="0.158736984693766" /> <!-- Ring of Devotion -->
                <item id="1874" min="1" max="1" chance="0.730172911341667" /> <!-- Oriharukon Ore -->
                <item id="1878" min="1" max="1" chance="4.38104890684986" /> <!-- Braided Hemp -->
                <item id="5220" min="1" max="1" chance="0.438106034564972" /> <!-- Metal Hardener -->
                <item id="2262" min="1" max="1" chance="0.170072076290131" /> <!-- Recipe: Elven Bow -->
                <item id="8600" min="1" max="1" chance="23.1" /> <!-- Herb of Life -->
                <item id="8601" min="1" max="1" chance="15.96" /> <!-- Greater Herb of Life -->
                <item id="8602" min="1" max="1" chance="2.94" /> <!-- Superior Herb of Life -->
                <item id="8603" min="1" max="1" chance="5.5" /> <!-- Herb of Mana -->
                <item id="8604" min="1" max="1" chance="4.73" /> <!-- Greater Herb of Mana -->
                <item id="8605" min="1" max="1" chance="0.77" /> <!-- Superior Herb of Mana -->
                <item id="8606" min="1" max="1" chance="5" /> <!-- Herb of Power -->
                <item id="8608" min="1" max="1" chance="5" /> <!-- Herb of Alacrity -->
                <item id="8610" min="1" max="1" chance="5" /> <!-- Herb of Critical Attack - Probability -->
                <item id="10655" min="1" max="1" chance="5" /> <!-- Herb of Vampiric Rage -->
                <item id="10656" min="1" max="1" chance="5" /> <!-- Herb of Critical Attack - Power -->
                <item id="8607" min="1" max="1" chance="5" /> <!-- Herb of Magic -->
                <item id="8609" min="1" max="1" chance="5" /> <!-- Herb of Casting Spd. -->
                <item id="8612" min="1" max="1" chance="0.33" /> <!-- Herb of the Warrior -->
                <item id="8613" min="1" max="1" chance="0.33" /> <!-- Herb of the Mystic -->
                <item id="8614" min="1" max="1" chance="0.34" /> <!-- Herb of Recovery -->
                <item id="8611" min="1" max="1" chance="10.34" /> <!-- Herb of Speed -->
                <item id="10657" min="1" max="1" chance="0.33" /> <!-- Herb of Doubt -->
                <item id="13028" min="1" max="1" chance="0.33" /> <!-- Vitality Replenishing Herb -->
            </drop>
            <spoil>
                <item id="1867" min="1" max="3" chance="52.0412" /> <!-- Animal Skin -->
                <item id="1932" min="1" max="1" chance="12.3908" /> <!-- Bone Helmet Design -->
                <item id="1931" min="1" max="1" chance="10.2042" /> <!-- Leather Boots Lining -->
            </spoil>
        </dropLists>

Возможно где то в конфигах есть пункт "Удалить со всего дропа необходимые предметы через ID (перечисление нужных)". Конкретно где и есть ли вообще не скажу, ибо не знаю данную сборку.

TakeMe · 18 Авг 2022

Civic написал(а):

Как пример в сборке L2jMobius HF дроп с мобов хранится в в ДП в самих НПС. game\data\stats\npcs
Ищите нужного моба и удаляете необходимые дроп.

XML:

        <dropLists>
            <drop>
                <item id="57" min="344" max="644" chance="70" /> <!-- Adena -->
                <item id="847" min="1" max="1" chance="0.105823286262512" /> <!-- Red Crescent Earring -->
                <item id="910" min="1" max="1" chance="0.0793674646968842" /> <!-- Necklace of Devotion -->
                <item id="1899" min="1" max="1" chance="1.71137226167655" /> <!-- Necklace of Devotion Chain -->
                <item id="890" min="1" max="1" chance="0.158736984693766" /> <!-- Ring of Devotion -->
                <item id="1874" min="1" max="1" chance="0.730172911341667" /> <!-- Oriharukon Ore -->
                <item id="1878" min="1" max="1" chance="4.38104890684986" /> <!-- Braided Hemp -->
                <item id="5220" min="1" max="1" chance="0.438106034564972" /> <!-- Metal Hardener -->
                <item id="2262" min="1" max="1" chance="0.170072076290131" /> <!-- Recipe: Elven Bow -->
                <item id="8600" min="1" max="1" chance="23.1" /> <!-- Herb of Life -->
                <item id="8601" min="1" max="1" chance="15.96" /> <!-- Greater Herb of Life -->
                <item id="8602" min="1" max="1" chance="2.94" /> <!-- Superior Herb of Life -->
                <item id="8603" min="1" max="1" chance="5.5" /> <!-- Herb of Mana -->
                <item id="8604" min="1" max="1" chance="4.73" /> <!-- Greater Herb of Mana -->
                <item id="8605" min="1" max="1" chance="0.77" /> <!-- Superior Herb of Mana -->
                <item id="8606" min="1" max="1" chance="5" /> <!-- Herb of Power -->
                <item id="8608" min="1" max="1" chance="5" /> <!-- Herb of Alacrity -->
                <item id="8610" min="1" max="1" chance="5" /> <!-- Herb of Critical Attack - Probability -->
                <item id="10655" min="1" max="1" chance="5" /> <!-- Herb of Vampiric Rage -->
                <item id="10656" min="1" max="1" chance="5" /> <!-- Herb of Critical Attack - Power -->
                <item id="8607" min="1" max="1" chance="5" /> <!-- Herb of Magic -->
                <item id="8609" min="1" max="1" chance="5" /> <!-- Herb of Casting Spd. -->
                <item id="8612" min="1" max="1" chance="0.33" /> <!-- Herb of the Warrior -->
                <item id="8613" min="1" max="1" chance="0.33" /> <!-- Herb of the Mystic -->
                <item id="8614" min="1" max="1" chance="0.34" /> <!-- Herb of Recovery -->
                <item id="8611" min="1" max="1" chance="10.34" /> <!-- Herb of Speed -->
                <item id="10657" min="1" max="1" chance="0.33" /> <!-- Herb of Doubt -->
                <item id="13028" min="1" max="1" chance="0.33" /> <!-- Vitality Replenishing Herb -->
            </drop>
            <spoil>
                <item id="1867" min="1" max="3" chance="52.0412" /> <!-- Animal Skin -->
                <item id="1932" min="1" max="1" chance="12.3908" /> <!-- Bone Helmet Design -->
                <item id="1931" min="1" max="1" chance="10.2042" /> <!-- Leather Boots Lining -->
            </spoil>
        </dropLists>

Возможно где то в конфигах есть пункт "Удалить со всего дропа необходимые предметы через ID (перечисление нужных)". Конкретно где и есть ли вообще не скажу, ибо не знаю данную сборку.

Спасибо за ответ. В датапаке по каждому мобу это в курсе, так как весь перековырял. Но это прям ооочень муторная работа, а вот насчёт конфигов, вероятнее всего конкретно в этой сборке, такой опции нет, насколько я помню. В других видел. В любом случае, я убедился, в своих догадках, всё таки как хорошо когда подобные вещи можно править через SQL запросы) Спасибо ещё раз. :Mlfy:

Civic · 18 Авг 2022

TakeMe написал(а):
Спасибо за ответ. В датапаке по каждому мобу это в курсе, так как весь перековырял. Но это прям ооочень муторная работа, а вот насчёт конфигов, вероятнее всего конкретно в этой сборке, такой опции нет, насколько я помню. В других видел. В любом случае, я убедился, в своих догадках, всё таки как хорошо когда подобные вещи можно править через SQL запросы) Спасибо ещё раз.

Укажите конкретную сборку, буду у ПК, посмотрю конфиги.

TakeMe · 18 Авг 2022

L2J_Mobius_CT_2.6_HighFive

Civic написал(а):
Укажите конкретную сборку, буду у ПК, посмотрю конфиги.

Это из последних исходников слитых мобиусом.

Civic · 18 Авг 2022

TakeMe написал(а):
L2J_Mobius_CT_2.6_HighFive

Это из последних исходников слитых мобиусом.

Либо я в глазики долблюсь, либо в сборке такого нет. В любом случае, если вы берете за основу данную сборку, то к ней есть исходы и при желании игнор дропа можно реализовать. Ну или вырезать ненужное в ручную

TakeMe · 18 Авг 2022

Civic написал(а):
Либо я в глазики долблюсь, либо в сборке такого нет. В любом случае, если вы берете за основу данную сборку, то к ней есть исходы и при желании игнор дропа можно реализовать. Ну или вырезать ненужное в ручную

Все правильно, там такого просто нет. Да, исходы есть, но это уже курить яву надо)

MaZz · 21 Авг 2022

TakeMe написал(а):
Спасибо за ответ. В датапаке по каждому мобу это в курсе, так как весь перековырял. Но это прям ооочень муторная работа, а вот насчёт конфигов, вероятнее всего конкретно в этой сборке, такой опции нет, насколько я помню. В других видел. В любом случае, я убедился, в своих догадках, всё таки как хорошо когда подобные вещи можно править через SQL запросы) Спасибо ещё раз.

Парсинг, нет не слышал

TakeMe · 21 Авг 2022

d3ndy написал(а):
Парсинг, нет не слышал

СлышОл, именно на этом варианте остановился, так как джава для меня пока тёмный лес.

Psycho · 21 Авг 2022

TakeMe написал(а):
Пардон за наитупейший вопрос, но, я не смог найти ничего подобного на форуме. Как удалять из дропа ненужные тебе вещи к примеру ( книги, куски и т.д) если подобных данных нет в базе SQL. Более конкретно, сборка L2jMobius. Там нет подобных данных в самой базе сервера, когда-то давно занимался интерлюдом, никаких проблем не было с удалением из дроп-листа различных предметов. Но как быть в моем случае? Подскажите куда "копать", пожалуйста.

Исключить из дропа все кроме адены. Отвечу за ранее: Это делается в исходниках. Без знаний языка сам врядли сделаешь.

iMax · 27 Июл 2023

Народ подскажите как сделать у всех мобов респ например 5 секунд?

WmzBot · 28 Июл 2023

iMax написал(а):
Народ подскажите как сделать у всех мобов респ например 5 секунд?

СБОРКА? просто у одних сборок спавн лист в базе данных, у других в xml файле, у вас где спавн лист хранится? если в базе то запросом, если в хмл, открываете все спавн листы в notepad++ и заменяете строку спавна на строку спавна с вашим временем(но и рб и остальные тоже 5 сек будут иметь спавн) так что писать скрипт, чтобы не всем менял.

Мануал Полезные SQL запросы новичкам

Дополнительные настройки

Maxwell

Auribus teneo lupum

kick

TakeMe

Путник

Civic

Пляшущий с бубном

TakeMe

Путник

Civic

Пляшущий с бубном

TakeMe

Путник

Civic

Пляшущий с бубном

TakeMe

Путник

MaZz

TakeMe

Путник

Psycho

Просветленный

iMax

Пляшущий с бубном

WmzBot

Поклонник кармы

Похожие темы