ФорумПодскажите пожалуйста, как выключить со всех мобов дроп, и поставить дроп только адены и ещё некоторые позиции?
+3
maximov
SarGos
AloneLord
Участников: 7
Вопрос по мобам
AloneLord- Сообщения : 243
Дата регистрации : 2010-04-01
SarGos- Сообщения : 493
Дата регистрации : 2010-03-08
Возраст : 29
Откуда : Украина
+1AloneLord пишет:Подскажите пожалуйста, как выключить со всех мобов дроп, и поставить дроп только адены и ещё некоторые позиции?
maximov- Сообщения : 441
Дата регистрации : 2010-04-22
Запрос написать и применить. Напишите что надо я выложу запрос.
ArtiShok- Сообщения : 1144
Дата регистрации : 2010-03-10
- Код:
DELETE FROM droplist WHERE itemId != '57' AND itemId != 'нужный_ид' AND itemId != 'нужный_ид' AND itemId != 'нужный_ид' FROM npc WHERE type='L2Monster';
- Код:
DELETE FROM droplist WHERE itemId != '57' AND itemId != 'нужный_ид' AND itemId != 'нужный_ид' AND itemId != 'нужный_ид' FROM npc WHERE type='L2Monster' AND (level > '70' and level < '85');
AloneLord- Сообщения : 243
Дата регистрации : 2010-04-01
ArtiShok пишет:если надо по уровням:
- Код:
DELETE FROM droplist WHERE itemId != '57' AND itemId != 'нужный_ид' AND itemId != 'нужный_ид' AND itemId != 'нужный_ид' FROM npc WHERE type='L2Monster';
- Код:
DELETE FROM droplist WHERE itemId != '57' AND itemId != 'нужный_ид' AND itemId != 'нужный_ид' AND itemId != 'нужный_ид' FROM npc WHERE type='L2Monster' AND (level > '70' and level < '85');
команда
удаляет со всех мобов весь полностью дроп, оставляет только адену и нужный ID?DELETE FROM droplist WHERE itemId != '57' AND itemId != 'нужный_ид' AND itemId != 'нужный_ид' AND itemId != 'нужный_ид' FROM npc WHERE type='L2Monster';
ArtiShok- Сообщения : 1144
Дата регистрации : 2010-03-10
даAloneLord пишет:
удаляет со всех мобов весь полностью дроп, оставляет только адену и нужный ID?
maximov- Сообщения : 441
Дата регистрации : 2010-04-22
And level = 31;
AloneLord- Сообщения : 243
Дата регистрации : 2010-04-01
Пишу код
выкидывает ошибку
Если пишу просто с аденой:
выкидывает ошибку тоже:
как решить проблему?
DELETE FROM droplist WHERE itemId != '57' AND itemId != '6660' AND itemId != 6662' AND itemId != 6661' AND itemId != '6658' AND itemId != '6656' AND itemId != '6657' AND itemId != '6659' FROM npc WHERE type='L2Monster';
выкидывает ошибку
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' AND itemId != 6661' AND itemId != '6658' AND itemId != '6656' AND itemId != '6' at line 1
Если пишу просто с аденой:
DELETE FROM droplist WHERE itemId != '57' FROM npc WHERE type='L2Monster';
выкидывает ошибку тоже:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM npc WHERE type='L2Monster'' at line 1
как решить проблему?
maximov- Сообщения : 441
Дата регистрации : 2010-04-22
восклицательные знаки убери
Удаление хлама их дропа:
удалить все кроме адены:
DELETE FROM droplist WHERE itemId = '57';
удаление всего кроме кл скилов, адены, лайф стоунов
Удаление хлама их дропа:
- Спойлер:
- 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 = '57';
удаление всего кроме кл скилов, адены, лайф стоунов
- Спойлер:
- DELETE FROM `droplist` WHERE `itemId` NOT IN (57,6662,6656,6660,6659,6658,6657,8191,6360,6361,6362,8627,8633,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,959,955,951,947,729,960,956,952,948,730,6577,6575,6573,6571,6569,6578,6576,6574,6572,6570,8166,8165,8164,8163,8162,8161,8176,8169,8168,8167,8175,8160,8159,8158,8172,8171,8170,1419,6665,6666,6667,6668,6669,6670,6671,6672,6661);
AloneLord- Сообщения : 243
Дата регистрации : 2010-04-01
Вот, помогло, спасибо )
plavik- Сообщения : 184
Дата регистрации : 2010-03-08
Возраст : 32
Откуда : Дагестан
AloneLord пишет:Вот, помогло, спасибо )
еще есть 1 способ без всяких мучений с вашими sql запросами))
Берем Создаем Блокнот Изменяем Расширение на xml Вписываем Ваш Дроп и т.д И Закатываем Етот Файл С таким Же названием в zip архив (закидываем в папку faenor)
- Код:
<Event ID="Тут Что Хотите ток На англ)" Active="26 Oct 2005-6 Nov 2015">
<Droplist>
<AllDrop Items="тут свой айди"
Count="скоко штучек"
Chance="процент выпада">
</AllDrop>
</Droplist>
</Event>
Вот Вам Наглядный Пример:
- Код:
<Event ID="Adena" Active="26 Oct 2005-6 Nov 2015">
<Droplist>
<AllDrop Items="57"
Count="1000000"
Chance="100%">
</AllDrop>
</Droplist>
</Event>
тут я добавил 100% шанс на дроп адены как вы могли понять ко всем мобам ток тут по мобам) но можно конечно и как арти просто предложил еще 1 ваириант)
П.Сы: Поправьте Если я не прав)
Последний раз редактировалось: plavik (Чт Май 06, 2010 1:16 pm), всего редактировалось 1 раз(а)
maximov- Сообщения : 441
Дата регистрации : 2010-04-22
А вот за это спасибо! +1 МОЛОДЕЦ!
SarGos- Сообщения : 493
Дата регистрации : 2010-03-08
Возраст : 29
Откуда : Украина
вотетая хрень удаляет адены а хлам оставляет!!!maximov пишет:восклицательные знаки убери
Удаление хлама их дропа:
- Спойлер:
,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 = '57';
удаление всего кроме кл скилов, адены, лайф стоунов
- Спойлер:
ArtiShok- Сообщения : 1144
Дата регистрации : 2010-03-10
естественно будет удалять=))))SarGos пишет:вотетая хрень удаляет адены а хлам оставляет!!!maximov пишет:восклицательные знаки убери
Удаление хлама их дропа:
- Спойлер:
,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 = '57';
удаление всего кроме кл скилов, адены, лайф стоунов
- Спойлер:
DELETE FROM droplist WHERE itemId != '57';
оставит тока адену=))))
neonv1- Сообщения : 126
Дата регистрации : 2010-04-26
- Код:
UPDATE `droplist` SET `chance`='1000000' WHERE `itemId`='57';
SarGos- Сообщения : 493
Дата регистрации : 2010-03-08
Возраст : 29
Откуда : Украина
спасибо, ищо одно!!! эсли я щас етот запрос выполню, то на рейд босах оставяться яйца для клан скилов ?ArtiShok пишет:естественно будет удалять=))))SarGos пишет:вотетая хрень удаляет адены а хлам оставляет!!!maximov пишет:восклицательные знаки убери
Удаление хлама их дропа:
- Спойлер:
,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 = '57';
удаление всего кроме кл скилов, адены, лайф стоунов
- Спойлер:
DELETE FROM droplist WHERE itemId != '57';
оставит тока адену=))))
neonv1- Сообщения : 126
Дата регистрации : 2010-04-26
нетSarGos пишет:спасибо, ищо одно!!! эсли я щас етот запрос выполню, то на рейд босах оставяться яйца для клан скилов ?ArtiShok пишет:естественно будет удалять=))))SarGos пишет:вотетая хрень удаляет адены а хлам оставляет!!!maximov пишет:восклицательные знаки убери
Удаление хлама их дропа:
- Спойлер:
,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 = '57';
удаление всего кроме кл скилов, адены, лайф стоунов
- Спойлер:
DELETE FROM droplist WHERE itemId != '57';
оставит тока адену=))))
SarGos- Сообщения : 493
Дата регистрации : 2010-03-08
Возраст : 29
Откуда : Украина
гон!!!! и что тогда делать??neonv1 пишет:нетSarGos пишет:спасибо, ищо одно!!! эсли я щас етот запрос выполню, то на рейд босах оставяться яйца для клан скилов ?ArtiShok пишет:естественно будет удалять=))))SarGos пишет:вотетая хрень удаляет адены а хлам оставляет!!!maximov пишет:восклицательные знаки убери
Удаление хлама их дропа:
- Спойлер:
,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 = '57';
удаление всего кроме кл скилов, адены, лайф стоунов
- Спойлер:
DELETE FROM droplist WHERE itemId != '57';
оставит тока адену=))))
neonv1- Сообщения : 126
Дата регистрации : 2010-04-26
в конфигах яйца сними и все.Character.сfg
# Необходимы ли Life crystal для изучения клановых скилов
LifeCrystalNeeded = False
# Необходимы ли Life crystal для изучения клановых скилов
LifeCrystalNeeded = False
SarGos- Сообщения : 493
Дата регистрации : 2010-03-08
Возраст : 29
Откуда : Украина
спс!neonv1 пишет:в конфигах яйца сними и все.Character.сfg
# Необходимы ли Life crystal для изучения клановых скилов
LifeCrystalNeeded = False
AloneLord- Сообщения : 243
Дата регистрации : 2010-04-01
напомните, видел где-то, но не нашёл, и сам забыл...
Как "приземлить" моба на землю, а то парит в воздухе?
Как "приземлить" моба на землю, а то парит в воздухе?
maximov- Сообщения : 441
Дата регистрации : 2010-04-22
я такое с нпц делал, но один хрен. В его настройках смотри по Z.
AloneLord- Сообщения : 243
Дата регистрации : 2010-04-01
maximov пишет:я такое с нпц делал, но один хрен. В его настройках смотри по Z.
это знаю. а в каких именно настройках?
Admiralio- Сообщения : 47
Дата регистрации : 2010-04-26
Если я не ошибаюсь, то вам надо подправить высоту НПЦ.
Это мона поправить в БД, а именно: таблица "npc"; столбец "collision_heigth"
Это мона поправить в БД, а именно: таблица "npc"; столбец "collision_heigth"
maximov- Сообщения : 441
Дата регистрации : 2010-04-22
Или шифт клик)
Похожие темы
|
|
|