Список полезных Sql запросов. Часть 2
![Список полезных Sql запросов. Часть 2 Список полезных Sql запросов. Часть 2](/uploads/posts/2010-05/L2maxi.ru_navicat-for-mysql-8.0.26.jpg)
Не так давно мы публиковали небольшой материал, посвященный полезным sql запросам для сервера, с помощью которых вы можете без каких-либо усилий изменить многие вещи на сервере (убрать лишний дроп, изменить стартовое место появление всех персонажей и изменить вещи, которые на них будут надеты). Сегодня мы продолжим этот материал, но уже с большим размахом.
Удаление всех ресурсов
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='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='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='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='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`=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);
Удаление дропа всего, кроме дропа с РБ, эпиков, брони и оружия, адены, лайф стоунов, камней печати и енчант скроллов
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')
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 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');
('ид_клана','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;
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';
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');
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');
>> Ява сервера » F.A.Q., Список полезных Sql запросов. Часть 2
![]() |
Список полезных Sql запросов. Часть 3 Продолжаем полезную тему с sql запросами. В 3 части мы познакомимся с такими вещами как: изменять стартовый шмот у персонажей, узнаем запросы связанные с ценой и аденой и научимся изменение статов |
![]() |
Книги по Linux Продолжаю выкладывать мануалы и различные фичи для Линуксоидов. В данном архиве вы найдёте огромное кол-во гайдов по Linux системам |
![]() |
Привязка сервера к динамическим ip с помощью No-IP Если у вас динамический IP, то без этой программы вам не обойтись. Данный сервис привязывает домен к вашему IP, тем самым делает интернет протокол постоянным (неизменяемым). |
Разместил: mrdaniel
Прочитано: 30014
Информация
Посетители, находящиеся в группе Гость, не могут оставлять комментарии в данной новости.
Посетители, находящиеся в группе Гость, не могут оставлять комментарии в данной новости.
Реклама
Навигация
→ Главная
→ Наши Услуги
→ Рекламодателям
→ Форум
→ Lineage 2
» Клиенты
» Новости
» Мувики
» Файлы
» Статьи/Гайды
» Квесты
» Галерея
→ Java
» Сборки серверов
» Исходники
» Дополнения
» Модели
» Защита
» Web
» Шаблоны
» Программы
» Geodata
» F.A.Q.
» Скидки на покупку
» Биографии
→ Чит Раздел
» Боты
» Баги
» Файлы
» Статьи
» L2 Interlude изменение хроник
» Понятие сборки сервера L2
» Скачать клиент L2 бесплатно
» Суть квестов для Lineage 2
» Создание пиратских серверов L2
» Создаём свой сервер L2
» Скачать сервер L2
→ Наши Услуги
→ Рекламодателям
→ Форум
→ Lineage 2
» Клиенты
» Новости
» Мувики
» Файлы
» Статьи/Гайды
» Квесты
» Галерея
→ Java
» Сборки серверов
» Исходники
» Дополнения
» Модели
» Защита
» Web
» Шаблоны
» Программы
» Geodata
» F.A.Q.
» Скидки на покупку
» Биографии
→ Чит Раздел
» Боты
» Баги
» Файлы
» Статьи
» L2 Interlude изменение хроник
» Понятие сборки сервера L2
» Скачать клиент L2 бесплатно
» Суть квестов для Lineage 2
» Создание пиратских серверов L2
» Создаём свой сервер L2
» Скачать сервер L2
Популярные новости
Опрос
Используете ли вы "Вход через Вконтакте" на нашем сайте? |
Облако тегов
Архив новостей
Февраль 2019 (4)
Январь 2019 (5)
Декабрь 2018 (4)
Ноябрь 2018 (4)
Октябрь 2018 (4)
Сентябрь 2018 (4)
Январь 2019 (5)
Декабрь 2018 (4)
Ноябрь 2018 (4)
Октябрь 2018 (4)
Сентябрь 2018 (4)
Август 2018 (4)
Июль 2018 (4)
Июнь 2018 (5)
Май 2018 (4)
Апрель 2018 (5)
Март 2018 (4)
Февраль 2018 (4)
Январь 2018 (4)
Декабрь 2017 (4)
Ноябрь 2017 (4)
Октябрь 2017 (4)
Сентябрь 2017 (4)
Август 2017 (4)
Июль 2017 (4)
Июнь 2017 (4)
Май 2017 (4)
Апрель 2017 (4)
Март 2017 (4)
Февраль 2017 (4)
Январь 2017 (4)
Декабрь 2016 (5)
Ноябрь 2016 (4)
Октябрь 2016 (4)
Сентябрь 2016 (4)
Август 2016 (4)
Июль 2016 (4)
Июнь 2016 (4)
Май 2016 (6)
Апрель 2016 (4)
Март 2016 (3)
Февраль 2016 (12)
Январь 2016 (19)
Декабрь 2015 (18)
Ноябрь 2015 (21)
Октябрь 2015 (20)
Сентябрь 2015 (29)
Август 2015 (37)
Июль 2015 (29)
Июнь 2015 (31)
Май 2015 (32)
Апрель 2015 (33)
Март 2015 (22)
Февраль 2015 (61)
Январь 2015 (61)
Декабрь 2014 (65)
Ноябрь 2014 (14)
Октябрь 2014 (15)
Сентябрь 2014 (3)
Август 2014 (14)
Июль 2014 (18)
Июнь 2014 (48)
Май 2014 (60)
Апрель 2014 (55)
Март 2014 (61)
Февраль 2014 (56)
Январь 2014 (60)
Декабрь 2013 (62)
Ноябрь 2013 (59)
Октябрь 2013 (62)
Сентябрь 2013 (60)
Август 2013 (70)
Июль 2013 (64)
Июнь 2013 (57)
Май 2013 (76)
Апрель 2013 (90)
Март 2013 (113)
Февраль 2013 (143)
Январь 2013 (137)
Декабрь 2012 (95)
Ноябрь 2012 (107)
Октябрь 2012 (185)
Сентябрь 2012 (143)
Август 2012 (116)
Июль 2012 (173)
Июнь 2012 (172)
Май 2012 (118)
Апрель 2012 (109)
Март 2012 (67)
Февраль 2012 (105)
Январь 2012 (70)
Декабрь 2011 (81)
Ноябрь 2011 (75)
Октябрь 2011 (111)
Сентябрь 2011 (106)
Август 2011 (112)
Июль 2011 (136)
Июнь 2011 (68)
Май 2011 (117)
Апрель 2011 (116)
Март 2011 (137)
Февраль 2011 (131)
Январь 2011 (44)
Декабрь 2010 (23)
Ноябрь 2010 (27)
Октябрь 2010 (32)
Сентябрь 2010 (14)
Август 2010 (27)
Июль 2010 (42)
Июнь 2010 (38)
Май 2010 (93)
Апрель 2010 (76)
Март 2010 (59)
Февраль 2010 (40)
Январь 2010 (53)
Декабрь 2009 (25)
Ноябрь 2009 (7)
Октябрь 2009 (2)
Сентябрь 2009 (26)
Август 2009 (32)
Июль 2009 (33)
Июнь 2009 (38)
Май 2009 (93)
Апрель 2009 (109)
Март 2009 (90)
Февраль 2009 (100)
Январь 2009 (14)
Июль 2018 (4)
Июнь 2018 (5)
Май 2018 (4)
Апрель 2018 (5)
Март 2018 (4)
Февраль 2018 (4)
Январь 2018 (4)
Декабрь 2017 (4)
Ноябрь 2017 (4)
Октябрь 2017 (4)
Сентябрь 2017 (4)
Август 2017 (4)
Июль 2017 (4)
Июнь 2017 (4)
Май 2017 (4)
Апрель 2017 (4)
Март 2017 (4)
Февраль 2017 (4)
Январь 2017 (4)
Декабрь 2016 (5)
Ноябрь 2016 (4)
Октябрь 2016 (4)
Сентябрь 2016 (4)
Август 2016 (4)
Июль 2016 (4)
Июнь 2016 (4)
Май 2016 (6)
Апрель 2016 (4)
Март 2016 (3)
Февраль 2016 (12)
Январь 2016 (19)
Декабрь 2015 (18)
Ноябрь 2015 (21)
Октябрь 2015 (20)
Сентябрь 2015 (29)
Август 2015 (37)
Июль 2015 (29)
Июнь 2015 (31)
Май 2015 (32)
Апрель 2015 (33)
Март 2015 (22)
Февраль 2015 (61)
Январь 2015 (61)
Декабрь 2014 (65)
Ноябрь 2014 (14)
Октябрь 2014 (15)
Сентябрь 2014 (3)
Август 2014 (14)
Июль 2014 (18)
Июнь 2014 (48)
Май 2014 (60)
Апрель 2014 (55)
Март 2014 (61)
Февраль 2014 (56)
Январь 2014 (60)
Декабрь 2013 (62)
Ноябрь 2013 (59)
Октябрь 2013 (62)
Сентябрь 2013 (60)
Август 2013 (70)
Июль 2013 (64)
Июнь 2013 (57)
Май 2013 (76)
Апрель 2013 (90)
Март 2013 (113)
Февраль 2013 (143)
Январь 2013 (137)
Декабрь 2012 (95)
Ноябрь 2012 (107)
Октябрь 2012 (185)
Сентябрь 2012 (143)
Август 2012 (116)
Июль 2012 (173)
Июнь 2012 (172)
Май 2012 (118)
Апрель 2012 (109)
Март 2012 (67)
Февраль 2012 (105)
Январь 2012 (70)
Декабрь 2011 (81)
Ноябрь 2011 (75)
Октябрь 2011 (111)
Сентябрь 2011 (106)
Август 2011 (112)
Июль 2011 (136)
Июнь 2011 (68)
Май 2011 (117)
Апрель 2011 (116)
Март 2011 (137)
Февраль 2011 (131)
Январь 2011 (44)
Декабрь 2010 (23)
Ноябрь 2010 (27)
Октябрь 2010 (32)
Сентябрь 2010 (14)
Август 2010 (27)
Июль 2010 (42)
Июнь 2010 (38)
Май 2010 (93)
Апрель 2010 (76)
Март 2010 (59)
Февраль 2010 (40)
Январь 2010 (53)
Декабрь 2009 (25)
Ноябрь 2009 (7)
Октябрь 2009 (2)
Сентябрь 2009 (26)
Август 2009 (32)
Июль 2009 (33)
Июнь 2009 (38)
Май 2009 (93)
Апрель 2009 (109)
Март 2009 (90)
Февраль 2009 (100)
Январь 2009 (14)
Реклама