Нужно Пару Sql Запросиков)

[stasuk25 17]

Может у кого есть либо кто хорошо разбирается надо 2 SQL запроса

1.Удаление мусора от дропа.

2.И чтобы из мобов +78 падали определенные вещи.

Ну и 3 по возможности на всякий случай (На откат)

От "Спасибки" думаю не откажитесь)

[Ksardasok 149]

1. Delete from droplist where itemid not in (57,6656,6657,6658,6659,6660);

Перечисляй все нужные айпи через запятую, которые хочешь оставить.

2. insert into droplist (mobId, itemid, chance, min, max, category) select id, 4037, 1000000, 1, 1, 1 from npc where level>77 and type='l2monster';

3. Такого не бывает. Откат из бекапов только.

[RayWilliam 1]

А можно такой запрос, у меня х900

Мне надо в БС (Interlude) увеличить всем мобам дроп адены от 4кк до 12кк

И Шанс что упадёт 1 фа - 10 %

[Xeliken 142]

Удаление мусора

 

Скрытый текст

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

DELETE FROM droplist WHERE itemId='1864';

DELETE FROM droplist WHERE itemId='1865';

DELETE FROM droplist WHERE itemId='1866';

DELETE FROM droplist WHERE itemId='1868';

DELETE FROM droplist WHERE itemId='1869';

DELETE FROM droplist WHERE itemId='1870';

DELETE FROM droplist WHERE itemId='1871';

DELETE FROM droplist WHERE itemId='1872';

DELETE FROM droplist WHERE itemId='1873';

DELETE FROM droplist WHERE itemId='1874';

DELETE FROM droplist WHERE itemId='1875';

DELETE FROM droplist WHERE itemId='1876';

DELETE FROM droplist WHERE itemId='1877';

DELETE FROM droplist WHERE itemId='1878';

DELETE FROM droplist WHERE itemId='1879';

DELETE FROM droplist WHERE itemId='1880';

DELETE FROM droplist WHERE itemId='1881';

DELETE FROM droplist WHERE itemId='1882';

DELETE FROM droplist WHERE itemId='1884';

DELETE FROM droplist WHERE itemId='1885';

DELETE FROM droplist WHERE itemId='1895';

DELETE FROM droplist WHERE itemId='5549';

DELETE FROM droplist WHERE itemId='1886';

DELETE FROM droplist WHERE itemId='1887';

DELETE FROM droplist WHERE itemId='1888';

DELETE FROM droplist WHERE itemId='1890';

DELETE FROM droplist WHERE itemId='1891';

DELETE FROM droplist WHERE itemId='1892';

DELETE FROM droplist WHERE itemId='1893';

DELETE FROM droplist WHERE itemId='1889';

DELETE FROM droplist WHERE itemId='1894';

DELETE FROM droplist WHERE itemId='4039';

DELETE FROM droplist WHERE itemId='4040';

DELETE FROM droplist WHERE itemId='4041';

DELETE FROM droplist WHERE itemId='4042';

DELETE FROM droplist WHERE itemId='4043';

DELETE FROM droplist WHERE itemId='4044';

DELETE FROM droplist WHERE itemId='4046';

DELETE FROM droplist WHERE itemId='4047';

DELETE FROM droplist WHERE itemId='4045';

DELETE FROM droplist WHERE itemId='5550';

DELETE FROM droplist WHERE itemId='4048';

DELETE FROM droplist WHERE itemId='17';

DELETE FROM droplist WHERE itemId='1341';

DELETE FROM droplist WHERE itemId='1342';

DELETE FROM droplist WHERE itemId='1343';

DELETE FROM droplist WHERE itemId='1344';

DELETE FROM droplist WHERE itemId='1345';

DELETE FROM droplist WHERE itemId='4048';

DELETE FROM droplist WHERE itemId='1539';

DELETE FROM droplist WHERE itemId='5591';

DELETE FROM droplist WHERE itemId='5592';

DELETE FROM droplist WHERE itemId='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';