Запрос На Лишний Дроп

[ILoveGF 435]

кто может дать sql запрос удоление всего лишнего дропа как ресурсы стрелы ну и тип кроме клан яиц и адэны и эпик бижи колов фа)

[taste 501]

понимаю что гуглить не модно легче на форум написать и ждать когда дадут готовое

[WhatEver 1]

Держи,разберешься.

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

Убираем из дропа весь мусор, кроме адены.

 

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

-------------------------------------------------------------------------------------------------------------------------------------

 

Удалить из дропа книжки и амулеты (для изучения скиллов).

 

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

-------------------------------------------------------------------------------------------------------------------------------------

 

Удалить из дропа банки.

 

DELETE FROM droplist WHERE itemId='1539';

DELETE FROM droplist WHERE itemId='5591';

DELETE FROM droplist WHERE itemId='5592';

-------------------------------------------------------------------------------------------------------------------------------------

 

Убираем из дропа всё кроме определеных предметов. Я к примеру возьму:

кроме Адены(57) и кроме Coin Of Luck(4037)

 

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

-------------------------------------------------------------------------------------------------------------------------------------

 

Удалить из дропа стрелы.

 

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

-------------------------------------------------------------------------------------------------------------------------------------