Форум администраторов игровых серверов

Форум администраторов игровых серверов (https://forum.zone-game.info/TT.php)
-   Lineage II (https://forum.zone-game.info/forumdisplay.php?f=34)
-   -   Дроп (https://forum.zone-game.info/showthread.php?t=5079)

Rakitmiha 30.10.2009 15:13

Дроп
 
Мб кому нить пригодится

Запрос на удаление всех книг из дропа:
Код:

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;

http://img.zone-game.info/test/lineage/master.gif


Текущее время: 19:27. Часовой пояс GMT +3.

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd. Перевод: zCarot