Заточка скилов не требует XP и SP
UPDATE enchant_skill_trees SET sp=0;
UPDATE enchant_skill_trees SET exp=0;

Изменяет все заточеные вещи с 20 на 18
UPDATE`items`SET`enchant_level`='18'WHERE CONCAT(`enchant_level`)=20;

Меняет Ancient adena на adena всем игрокам
UPDATE`droplist`SET`itemId`='57'WHERE CONCAT(`itemId`)=5575;

Этот sql запрос позволит телепортироватся из тюрьмы
Update `characters` SET `jail_timer` = 0 where `jail_timer` > 0 and `online` = 0;
Update `characters` SET `in_jail` = 0 where `in_jail` > 0 and `online` = 0;
Update `characters` SET `karma` = 0 where `karma` > 0 and `online` = 0;

Удалить SpellBooks с дропа
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'spellbook' );

Удаление всего из дропа, кроме аден и других неболших полезностей(лайф_стоны, заточки, рб_бижа, вещи на клан_скилы с рб, всякие банки с острова дино, ключи, камни_аа и еще всякого)
DELETE FROM `droplist` WHERE `itemId` NOT IN (57,6662,6656,6660,6659,6658,6657,8191,6360,6361,6 362,8627,8633,8723,8724,8725,8726,8727,8728,8729,8 730,8731,8732,8733,8734,8735,8736,8737,8738,8739,8 740,8741,8742,8743,8744,8745,8746,8747,8748,8749,8 750,8751,8752,8753,8754,8755,8756,8757,8758,8759,8 760,8761,8762,959,955,951,947,729,960,956,952,948, 730,6577,6575,6573,6571,6569,6578,6576,6574,6572,6 570,8166,8165,8164,8163,8162,8161,8176,8169,8168,8 167,8175,8160,8159,8158,8172,8171,8170,1419,6665,6 666,6667,6668,6669,6670,6671,6672,6661);

Этoт зaпpoc ycтaнaвливaeт шaнc дpoпa нa 0.5%, гдe poднoй шaнc дpoпa мeньшe 0.5%
UPDATE `droplist` SET `chance` = '5000' WHERE `chance` <= '5000';

Назначить шанс выпадения рецептов
UPDATE droplist SET chance='1000000' WHERE id IN (SELECT item_id FROM etcitem WHERE type='recipe');

Убираем из дропа весь мусор, кроме аденки
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';

Удалить SpellBooks с дропа
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';

Делаем шанс дропа аден 100% (по стандарту ето 70%)
UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=57;

Дроп Festival Adena с мобов 75 +
INSERT INTO `droplist` (mobId, itemId, min, max, category, chance) SELECT id, 6673, 10, 30, 200, 1000000 FROM `npc` WHERE type = 'L2Monster' AND level > 75;

Удаление всех материалов и рецептов из дропа
DELETE FROM droplist WHERE itemid IN (SELECT item_id FROM etcitem WHERE item_type= 'material' OR item_type= 'recipe' );

Все вещи можно продать/обменять/удалить
UPDATE armor SET sellable="true";
UPDATE armor SET dropable="true";
UPDATE armor SET destroyable="true";
UPDATE armor SET tradeable="true";
UPDATE weapon SET sellable="true";
UPDATE weapon SET dropable="true";
UPDATE weapon SET destroyable="true";
UPDATE weapon SET tradeable="true";
UPDATE etcitem SET sellable="true";
UPDATE etcitem SET dropable="true";
UPDATE etcitem SET destroyable="true";
UPDATE etcitem SET tradeable="true";

Дроп 100 штук Gold Bar со всех РБ со 100% шансом
INSERT INTO `droplist` SELECT id, '3470','100','100','0','1000000' FROM `npc` WHERE `type` = 'L2RaidBoss';

Дроп Fire,Water,Earth,Wind,Dark,Divine Stone с 40% шансом
UPDATE `droplist` SET `droplist`.`chance`=400000 WHERE `droplist`.`itemId`=9546,
UPDATE `droplist` SET `droplist`.`chance`=400000 WHERE `droplist`.`itemId`=9547,
UPDATE `droplist` SET `droplist`.`chance`=400000 WHERE `droplist`.`itemId`=9548,
UPDATE `droplist` SET `droplist`.`chance`=400000 WHERE `droplist`.`itemId`=9549,
UPDATE `droplist` SET `droplist`.`chance`=400000 WHERE `droplist`.`itemId`=9550,
UPDATE `droplist` SET `droplist`.`chance`=400000 WHERE `droplist`.`itemId`=9551;

Изменяет шанс выпадения заточек
#D Scrolls Weapons and Armor
UPDATE`droplist`SET`chance`='10000'WHERE CONCAT(`itemId`)=955; UPDATE`droplist`SET`chance`='10000'WHERE CONCAT(`itemId`)=956; UPDATE`droplist`SET`chance`='5000'WHERE CONCAT(`itemId`)=957; UPDATE`droplist`SET`chance`='5000'WHERE CONCAT(`itemId`)=958;
#C Scrolls Weapons and Armor
UPDATE`droplist`SET`chance`='10000'WHERE CONCAT(`itemId`)=951; UPDATE`droplist`SET`chance`='10000'WHERE CONCAT(`itemId`)=952; UPDATE`droplist`SET`chance`='5000'WHERE CONCAT(`itemId`)=953; UPDATE`droplist`SET`chance`='5000'WHERE CONCAT(`itemId`)=954;
#B Scrolls Weapons and Armor
UPDATE`droplist`SET`chance`='10000'WHERE CONCAT(`itemId`)=947; UPDATE`droplist`SET`chance`='10000'WHERE CONCAT(`itemId`)=948; UPDATE`droplist`SET`chance`='5000'WHERE CONCAT(`itemId`)=949; UPDATE`droplist`SET`chance`='5000'WHERE CONCAT(`itemId`)=950;
#A Scrolls Weapons and Armor
UPDATE`droplist`SET`chance`='10000'WHERE CONCAT(`itemId`)=729; UPDATE`droplist`SET`chance`='10000'WHERE CONCAT(`itemId`)=730; UPDATE`droplist`SET`chance`='5000'WHERE CONCAT(`itemId`)=731; UPDATE`droplist`SET`chance`='5000'WHERE CONCAT(`itemId`)=732;
#S Scrolls Weapons and Armor
UPDATE`droplist`SET`chance`='10000'WHERE CONCAT(`itemId`)=959; UPDATE`droplist`SET`chance`='10000'WHERE CONCAT(`itemId`)=960; UPDATE`droplist`SET`chance`='5000'WHERE CONCAT(`itemId`)=961; UPDATE`droplist`SET`chance`='5000'WHERE CONCAT(`itemId`)=962;

Добавление вещи в дроплист ко всем мобам
INSERT INTO droplist (mobId, itemid,min, max, category, chance) SELECT id, ID Итема,'Min* Кол.','Max* Кол.', 'Категория', 'Шанс Дропа' FROM npc WHERE level > 1;

Запрос на полное удаление базы
DROP DATABASE `Имя БД`;

Вытаскивает чара из под текстур
UPDATE characters SET z=-3464, y=148505, x=83036 WHERE char_name='Ник чара';

Актуально для PvP серверов, как вариант иногда игроки пакупают слишком много заточек из-за чего их не пускает в игру, этот запрос удаляет заточки из инвентаря
DELETE from items where item_id=ID вещей and owner_id=ID чара;

Полное удаление Нпса с спавн листа
DELETE FROM spawnlist WHERE npc_templateid = ID NPC`a;

Полное удаление Нпса из БД
DELETE FROM npc WHERE id = ID NPC`a;

Изменить титул определенного нпса
UPDATE `npc` SET `title`='Титул' WHERE (`id`='ID NPC');

Изменить титул всем нпсам на сервере
UPDATE `npc` SET `title`='Титул'

Эти зaпpocы пoнижaют физ.aтк. в 1.2 paз y Mиниoнoв
UPDATE `npc` SET `patk` = `patk`*0.33 WHERE `type` = 'L2Minion';

Эти зaпpocы пoнижaют M.aтк. в 1.2 paз y Mиниoнoв
UPDATE `npc` SET `matk` = `matk`*0.33 WHERE `type` = 'L2Minion';

Эти зaпpocы пoнижaют pdef. в 1.2 paз y Mиниoнoв
UPDATE `npc` SET `pdef` = `pdef`*0.8 WHERE `type` = 'L2Minion';

Эти зaпpocы пoнижaют mdef. в 1.2 paз y Mиниoнoв
UPDATE `npc` SET `mdef` = `mdef`*0.8 WHERE `type` = 'L2Minion';

Запрос на открытие ХБ,в некоторых сборках при проходе квеста на хб он по просту не открываеться,точнее не выставляется 1 лвл ХБ в таблице.
INSERT INTO `hellbound` VALUES ('9999', '1800, '1', '1', '0');

Изменяем имя персонажу
UPDATE characters SET char_name='Новое Имя' WHERE char_name='Старое Имя'

Увеличить CP всех персонажей на 22% на 20 уровне. На 44% на 40 уровне. На 66% на 76 уровне
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.66 WHERE class_lvl = '76';
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.44 WHERE class_lvl = '40';
UPDATE lvlupgain SET defaultcpbase = Defaultcpbase * 1.22 WHERE class_lvl = '20';

Увеличить время восстановление маны в 10 раз
UPDATE lvlupgain SET defaultmpmod = defaultmpmod * 10.0;

Увеличить статы (Str,Int,Dex,Wit,Men,Con) всех персонажей в 2 раза
UPDATE `char_templates` SET `STR`='80' WHERE (SELECT ClassId) AND (str = '40');
UPDATE `char_templates` SET `STR`='44' WHERE (SELECT ClassId) AND (str = '22');
UPDATE `char_templates` SET `STR`='72' WHERE (SELECT ClassId) AND (str = '36');
UPDATE `char_templates` SET `STR`='42' WHERE (SELECT ClassId) AND (str = '21');
UPDATE `char_templates` SET `STR`='46' WHERE (SELECT ClassId) AND (str = '23');
UPDATE `char_templates` SET `STR`='54' WHERE (SELECT ClassId) AND (str = '27');
UPDATE `char_templates` SET `STR`='78' WHERE (SELECT ClassId) AND (str = '39');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `con`='54' WHERE (SELECT ClassId) AND (con = '27');
UPDATE `char_templates` SET `con`='72' WHERE (SELECT ClassId) AND (con = '36');
UPDATE `char_templates` SET `con`='50' WHERE (SELECT ClassId) AND (con = '25');
UPDATE `char_templates` SET `con`='64' WHERE (SELECT ClassId) AND (con = '32');
UPDATE `char_templates` SET `con`='48' WHERE (SELECT ClassId) AND (con = '24');
UPDATE `char_templates` SET `con`='94' WHERE (SELECT ClassId) AND (con = '47');
UPDATE `char_templates` SET `con`='62' WHERE (SELECT ClassId) AND (con = '31');
UPDATE `char_templates` SET `con`='90' WHERE (SELECT ClassId) AND (con = '45');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (SELECT ClassId) AND (_int = '21');
UPDATE `char_templates` SET `_int`='82' WHERE (SELECT ClassId) AND (_int = '41');
UPDATE `char_templates` SET `_int`='46' WHERE (SELECT ClassId) AND (_int = '23');
UPDATE `char_templates` SET `_int`='74' WHERE (SELECT ClassId) AND (_int = '37');
UPDATE `char_templates` SET `_int`='50' WHERE (SELECT ClassId) AND (_int = '25');
UPDATE `char_templates` SET `_int`='88' WHERE (SELECT ClassId) AND (_int = '44');
UPDATE `char_templates` SET `_int`='36' WHERE (SELECT ClassId) AND (_int = '18');
UPDATE `char_templates` SET `_int`='62' WHERE (SELECT ClassId) AND (_int = '31');
UPDATE `char_templates` SET `_int`='40' WHERE (SELECT ClassId) AND (_int = '20');
UPDATE `char_templates` SET `men`='52' WHERE (SELECT ClassId) AND (men = '26');
UPDATE `char_templates` SET `men`='80' WHERE (SELECT ClassId) AND (men = '40');
UPDATE `char_templates` SET `men`='74' WHERE (SELECT ClassId) AND (men = '37');
UPDATE `char_templates` SET `men`='54' WHERE (SELECT ClassId) AND (men = '27');
UPDATE `char_templates` SET `men`='84' WHERE (SELECT ClassId) AND (men = '42');
UPDATE `char_templates` SET `men`='78' WHERE (SELECT ClassId) AND (men = '39');
UPDATE `char_templates` SET `men`='50' WHERE (SELECT ClassId) AND (men = '25');
UPDATE `char_templates` SET `STR`='80' WHERE (ClassId = '0') AND (str = '40');
UPDATE `char_templates` SET `con`='86' WHERE (ClassId = '0') AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (ClassId = '0') AND (_int = '21');
UPDATE `char_templates` SET `dex`='60' WHERE (ClassId = '0') AND (dex = '30');
UPDATE `char_templates` SET `wit`='22' WHERE (ClassId = '0') AND (wit = '11');
UPDATE `char_templates` SET `wit`='22' WHERE (SELECT ClassId) AND (wit = '11');
UPDATE `char_templates` SET `wit`='40' WHERE (SELECT ClassId) AND (wit = '20');
UPDATE `char_templates` SET `wit`='28' WHERE (SELECT ClassId) AND (wit = '14');
UPDATE `char_templates` SET `wit`='46' WHERE (SELECT ClassId) AND (wit = '23');
UPDATE `char_templates` SET `wit`='24' WHERE (SELECT ClassId) AND (wit = '12');
UPDATE `char_templates` SET `wit`='38' WHERE (SELECT ClassId) AND (wit = '19');
UPDATE `char_templates` SET `wit`='30' WHERE (SELECT ClassId) AND (wit = '15');
UPDATE `char_templates` SET `wit`='20' WHERE (SELECT ClassId) AND (wit = '10');
UPDATE `char_templates` SET `dex`='60' WHERE (SELECT ClassId) AND (dex = '30');
UPDATE `char_templates` SET `dex`='42' WHERE (SELECT ClassId) AND (dex = '21');
UPDATE `char_templates` SET `dex`='70' WHERE (SELECT ClassId) AND (dex = '35');
UPDATE `char_templates` SET `dex`='48' WHERE (SELECT ClassId) AND (dex = '24');

Удаляет карму со всех игроков
UPDATE`characters`SET`karma`='0';

Дать всем персонажам 75-ого лвла 255 рекомендаций
UPDATE`characters`SET`rec_have`='255'WHERE CONCAT(`level`)=75;

Удалить всем рекомендации
UPDATE`characters`SET`rec_have`='0'WHERE CONCAT(`accesslevel`)=0;

Увеличить скорость бега всех персонажей на 20%
UPDATE char_templates SET MOVE_SPD = MOVE_SPD * 1.2;

Увеличить всем персонажам физическую защиту на 10%
UPDATE char_templates SET P_DEF = P_DEF * 1.1;

Увеличить всем персонажам магическую защиту на 10%
UPDATE char_templates SET M_DEF = M_DEF * 1.1;

Это запросы чтоб выдавать всем игрокам нублес
UPDATE `characters` SET `subpledge`='1'
UPDATE `characters` SET `nobless`='1'

А такой запрос выведет логин, IP с которого заходили последний раз на этот акк и уровень доступа для акков на которых нет чаров
SELECT `login`,`lastIP`,`access_level`
FROM `accounts` WHERE `login` NOT IN
(SELECT `account_name` FROM `characters`);

Удалить все аккаунты и персонажей, которые не соизволили появиться в игре в течении 3 месяцев
DELETE FROM characters WHERE lastAccess < 466560000;
DELETE FROM accounts WHERE lastactive < 466560000;

Запрос на добавлениям чарам ТОП нг при старте
REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 34, 26, 68, 4222, 558);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 34, 26, 68, 4222, 558);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 34, 26, 68, 4222, 558);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 34, 26, 257, 0, 558);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 34, 26, 87, 4222, 558);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 1105, 1102, 177, 0, 558);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 1105, 1102, 177, 0, 558);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 1105, 1102, 177, 0, 558);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 1105, 1102, 257, 0, 558);

Появление персонажа в топовом C Grade шмоте
REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 401, 2437, 2461, 499,6358);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 401, 2437, 2461, 499,6358);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 401, 2437, 2461, 499,6358);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 401, 2437, 2461, 499, 4710);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108471, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 401, 2437, 2461, 499, 4710);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 2430, 2454, 439, 471, 6313);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 2430, 2454, 439, 471, 6313);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 2430, 2454, 439, 471, 6313);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 2430, 2454, 439, 471, 6313);

Появление персонажа в топовом B Grade шмоте
REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 2392, 5739, 5723, 2417,6359);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 2392, 5739, 5723, 2417,6359);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 2392, 5739, 5723, 2417,6359);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 2392, 5739, 5723, 2417, 4719);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 1082415, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 2392, 5739, 5723, 2417, 4719);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 5732, 5716, 2406, 2415, 7722);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 5732, 5716, 2406, 2415, 7722);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 5732, 5716, 2406, 2415, 7722);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 5732, 5716, 2406, 2415, 7722);

Появление персонажа в топовом A Grade шмоте
REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 2395, 5787, 5775, 2419,8682);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 2395, 5787, 5775, 2419,8682);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 2395, 5787, 5775, 2419,8682);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 2395, 5787, 5775, 2419, 8788);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 2395, 5787, 5775, 2419, 8788);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 5779, 5767, 2407, 512, 5643);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 5779, 5767, 2407, 512, 5643);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 5779, 5767, 2407, 512, 5643);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 5779, 5767, 2407, 512, 5643);

Выдача новым персонажам вещей по классу/Магам: Arcana Mace и DC Robe Set/Войнам: Angel Slayer и Drac Light Set
REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 6379, 6381, 6380, 6382,6592);
REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 6379, 6381, 6380, 6382, 6583);
REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108512, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 6379, 6381, 6380, 6382, 6583);
REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 5779, 5767, 2407, 512, 6608);
REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 5779, 5767, 2407, 512, 6608);
REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 5779, 5767, 2407, 512, 6608);
REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 5779, 5767, 2407, 512, 6608);

Изменяем цвет имя Лорда определенного замка (Скобки обязательны)
UPDATE characters SET name_color="Код Цвета" WHERE obj_id IN (SELECT leader_id FROM clan_data WHERE hasCastle="Castle_ID");

Все персонажи могут крафтить не смотря на рассу
UPDATE char_templates SET canCraft="1";

Все игроки начинают игру в дионе
UPDATE `char_templates` SET `x`='18821',`y`='145176',`z`='-3135' WHERE (`ClassId`='0');
UPDATE `char_templates` SET `x`='18821',`y`='145176',`z`='-3135' WHERE (`ClassId`='10');
UPDATE `char_templates` SET `x`='18821',`y`='145176',`z`='-3135' WHERE (`ClassId`='18');
UPDATE `char_templates` SET `x`='18821',`y`='145176',`z`='-3135' WHERE (`ClassId`='25');
UPDATE `char_templates` SET `x`='18821',`y`='145176',`z`='-3135' WHERE (`ClassId`='31');
UPDATE `char_templates` SET `x`='18821',`y`='145176',`z`='-3135' WHERE (`ClassId`='38');
UPDATE `char_templates` SET `x`='18821',`y`='145176',`z`='-3135' WHERE (`ClassId`='44');
UPDATE `char_templates` SET `x`='18821',`y`='145176',`z`='-3135' WHERE (`ClassId`='49');
UPDATE `char_templates` SET `x`='18821',`y`='145176',`z`='-3135' WHERE (`ClassId`='53');

Все игроки начинают игру в годдарде
UPDATE `char_templates` SET `x`='147730',`y`='-56295',`z`='-2786' WHERE (`ClassId`='0');
UPDATE `char_templates` SET `x`='147730',`y`='-56295',`z`='-2786' WHERE (`ClassId`='10');
UPDATE `char_templates` SET `x`='147730',`y`='-56295',`z`='-2786' WHERE (`ClassId`='18');
UPDATE `char_templates` SET `x`='147730',`y`='-56295',`z`='-2786' WHERE (`ClassId`='25');
UPDATE `char_templates` SET `x`='147730',`y`='-56295',`z`='-2786' WHERE (`ClassId`='31');
UPDATE `char_templates` SET `x`='147730',`y`='-56295',`z`='-2786' WHERE (`ClassId`='38');
UPDATE `char_templates` SET `x`='147730',`y`='-56295',`z`='-2786' WHERE (`ClassId`='44');
UPDATE `char_templates` SET `x`='147730',`y`='-56295',`z`='-2786' WHERE (`ClassId`='49');
UPDATE `char_templates` SET `x`='147730',`y`='-56295',`z`='-2786' WHERE (`ClassId`='53');

Появление чаров в начале в Гиране(для пвп можно указать лвл 80 например и шмот начальный s)
REPLACE INTO char_templates VALUES (0, 'Human Fighter', 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, 83400, 147943, -3404, 0, '1.1', '1.188', 9, 23, '1.1', '1.188', 8, '23.5', 34, 26, 68, 4222, 5588);
REPLACE INTO char_templates VALUES (18, 'Elf Fighter', 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 83400, 147943, -3404, 0, '1.15', '1.242', '7.5', 24, '1.15', '1.242', '7.5', 23, 34, 26, 68, 4222, 5588);
REPLACE INTO char_templates VALUES (31, 'DE Fighter', 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 83400, 147943, -3404, 0, '1.14', '1.2312', '7.5', 24, '1.14', '1.2312', 7, '23.5', 34, 26, 68, 4222, 5588);
REPLACE INTO char_templates VALUES (44, 'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, 83400, 147943, -3404, 0, '1.06', '1.144800', 11.0, 28.0,1.06, '1.144800', 7.0, 27.0, 34, 26, 257, 0, 5588);
REPLACE INTO char_templates VALUES (53, 'Dwarf Fighter', 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 83400, 147943, -3404, 1, '1.09', '1.487196', 9, 18, '1.09', '1.487196', 5, 19, 34, 26, 87, 4222, 5588);
REPLACE INTO char_templates VALUES (10, 'Human Mage', 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, 83400, 147943, -3404, 0, '1.01', '0.87264' '7.5', '22.8', '1.01', '0.87264', '6.5', '22.5', 1105, 1102, 177, 0, 5588);
REPLACE INTO char_templates VALUES (25, 'Elf Mage', 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 83400, 147943, -3404, 0, '1.04', '0.89856', '7.5', 24, '1.04', '0.89856', '7.5', 23, 1105, 1102, 177, 0, 5588);
REPLACE INTO char_templates VALUES (38, 'DE Mage', 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 83400, 147943, -3404, 0, '1.14', '1.2312', '7.5', 24, '1.03', '0.88992', 7, '23.5', 1105, 1102, 177, 0, 5588);
REPLACE INTO char_templates VALUES (49, 'Orc Mage', 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, 83400, 147943, -3404, 0, '1.04', '0.89856', 7, '27.5', '1.04', '0.89856', 8, '25.5', 1105, 1102, 257, 0, 5588);

Дать определенному персонажу статус героя официально
INSERT INTO `heroes` VALUES ('ИД Чара', 'Ник Чара', 'ID профы', 'Побед', 'Игр');

Запрос который удалит неиспользуемые акки
DELETE FROM `accounts` WHERE `login` NOT IN
(SELECT `account_name` FROM `characters`);

Удаляет счёт пк/пвп со всех игроков
UPDATE`characters`SET`pkkills`='0';
UPDATE`characters`SET`pvpkills`='0';

Забанить всех игроков на сервере
UPDATE `characters` SET `accesslevel`='-100'

Забанить определенного персонажа.
UPDATE `characters` SET `accesslevel`='-100' WHERE (`obj_Id`='ИД Чара')

Написать титул определенному персонажу.
UPDATE `characters` SET `title`='Титул' WHERE `obj_Id`=ИД Чара

Написать титул всем персонажам на сервере.
UPDATE `characters` SET `title`='Титул'

Воть запрос на добавление всем расам Spoil.
INSERT INTO skill_trees VALUES (0,254,1,'Spoil',0,1);
INSERT INTO skill_trees VALUES (0,254,2,'Spoil',0,2);
INSERT INTO skill_trees VALUES (0,254,3,'Spoil',0,3);
INSERT INTO skill_trees VALUES (0,254,4,'Spoil',0,4);
INSERT INTO skill_trees VALUES (0,254,5,'Spoil',0,5);
INSERT INTO skill_trees VALUES (0,254,6,'Spoil',0,6);
INSERT INTO skill_trees VALUES (0,254,7,'Spoil',0,7);
INSERT INTO skill_trees VALUES (0,254,8,'Spoil',0,8);
INSERT INTO skill_trees VALUES (0,254,9,'Spoil',0,9);
INSERT INTO skill_trees VALUES (0,254,10,'Spoil',0,10);
INSERT INTO skill_trees VALUES (0,254,11,'Spoil',0,11);
INSERT INTO skill_trees VALUES (10,254,1,'Spoil',0,1);
INSERT INTO skill_trees VALUES (10,254,2,'Spoil',0,2);
INSERT INTO skill_trees VALUES (10,254,3,'Spoil',0,3);
INSERT INTO skill_trees VALUES (10,254,4,'Spoil',0,4);
INSERT INTO skill_trees VALUES (10,254,5,'Spoil',0,5);
INSERT INTO skill_trees VALUES (10,254,6,'Spoil',0,6);
INSERT INTO skill_trees VALUES (10,254,7,'Spoil',0,7);
INSERT INTO skill_trees VALUES (10,254,8,'Spoil',0,8);
INSERT INTO skill_trees VALUES (10,254,9,'Spoil',0,9);
INSERT INTO skill_trees VALUES (10,254,10,'Spoil',0,10);
INSERT INTO skill_trees VALUES (10,254,11,'Spoil',0,11);
INSERT INTO skill_trees VALUES (18,254,1,'Spoil',0,1);
INSERT INTO skill_trees VALUES (18,254,2,'Spoil',0,2);
INSERT INTO skill_trees VALUES (18,254,3,'Spoil',0,3);
INSERT INTO skill_trees VALUES (18,254,4,'Spoil',0,4);
INSERT INTO skill_trees VALUES (18,254,5,'Spoil',0,5);
INSERT INTO skill_trees VALUES (18,254,6,'Spoil',0,6);
INSERT INTO skill_trees VALUES (18,254,7,'Spoil',0,7);
INSERT INTO skill_trees VALUES (18,254,8,'Spoil',0,8);
INSERT INTO skill_trees VALUES (18,254,9,'Spoil',0,9);
INSERT INTO skill_trees VALUES (18,254,10,'Spoil',0,10);
INSERT INTO skill_trees VALUES (18,254,11,'Spoil',0,11);
INSERT INTO skill_trees VALUES (25,254,1,'Spoil',0,1);
INSERT INTO skill_trees VALUES (25,254,2,'Spoil',0,2);
INSERT INTO skill_trees VALUES (25,254,3,'Spoil',0,3);
INSERT INTO skill_trees VALUES (25,254,4,'Spoil',0,4);
INSERT INTO skill_trees VALUES (25,254,5,'Spoil',0,5);
INSERT INTO skill_trees VALUES (25,254,6,'Spoil',0,6);
INSERT INTO skill_trees VALUES (25,254,7,'Spoil',0,7);
INSERT INTO skill_trees VALUES (25,254,8,'Spoil',0,8);
INSERT INTO skill_trees VALUES (25,254,9,'Spoil',0,9);
INSERT INTO skill_trees VALUES (25,254,10,'Spoil',0,10);
INSERT INTO skill_trees VALUES (25,254,11,'Spoil',0,11);
INSERT INTO skill_trees VALUES (31,254,1,'Spoil',0,1);
INSERT INTO skill_trees VALUES (31,254,2,'Spoil',0,2);
INSERT INTO skill_trees VALUES (31,254,3,'Spoil',0,3);
INSERT INTO skill_trees VALUES (31,254,4,'Spoil',0,4);
INSERT INTO skill_trees VALUES (31,254,5,'Spoil',0,5);
INSERT INTO skill_trees VALUES (31,254,6,'Spoil',0,6);
INSERT INTO skill_trees VALUES (31,254,7,'Spoil',0,7);
INSERT INTO skill_trees VALUES (31,254,8,'Spoil',0,8);
INSERT INTO skill_trees VALUES (31,254,9,'Spoil',0,9);
INSERT INTO skill_trees VALUES (31,254,10,'Spoil',0,10);
INSERT INTO skill_trees VALUES (31,254,11,'Spoil',0,11);
INSERT INTO skill_trees VALUES (38,254,1,'Spoil',0,1);
INSERT INTO skill_trees VALUES (38,254,2,'Spoil',0,2);
INSERT INTO skill_trees VALUES (38,254,3,'Spoil',0,3);
INSERT INTO skill_trees VALUES (38,254,4,'Spoil',0,4);
INSERT INTO skill_trees VALUES (38,254,5,'Spoil',0,5);
INSERT INTO skill_trees VALUES (38,254,6,'Spoil',0,6);
INSERT INTO skill_trees VALUES (38,254,7,'Spoil',0,7);
INSERT INTO skill_trees VALUES (38,254,8,'Spoil',0,8);
INSERT INTO skill_trees VALUES (38,254,9,'Spoil',0,9);
INSERT INTO skill_trees VALUES (38,254,10,'Spoil',0,10);
INSERT INTO skill_trees VALUES (38,254,11,'Spoil',0,11);
INSERT INTO skill_trees VALUES (44,254,1,'Spoil',0,1);
INSERT INTO skill_trees VALUES (44,254,2,'Spoil',0,2);
INSERT INTO skill_trees VALUES (44,254,3,'Spoil',0,3);
INSERT INTO skill_trees VALUES (44,254,4,'Spoil',0,4);
INSERT INTO skill_trees VALUES (44,254,5,'Spoil',0,5);
INSERT INTO skill_trees VALUES (44,254,6,'Spoil',0,6);
INSERT INTO skill_trees VALUES (44,254,7,'Spoil',0,7);
INSERT INTO skill_trees VALUES (44,254,8,'Spoil',0,8);
INSERT INTO skill_trees VALUES (44,254,9,'Spoil',0,9);
INSERT INTO skill_trees VALUES (44,254,10,'Spoil',0,10);
INSERT INTO skill_trees VALUES (44,254,11,'Spoil',0,11);
INSERT INTO skill_trees VALUES (49,254,1,'Spoil',0,1);
INSERT INTO skill_trees VALUES (49,254,2,'Spoil',0,2);
INSERT INTO skill_trees VALUES (49,254,3,'Spoil',0,3);
INSERT INTO skill_trees VALUES (49,254,4,'Spoil',0,4);
INSERT INTO skill_trees VALUES (49,254,5,'Spoil',0,5);
INSERT INTO skill_trees VALUES (49,254,6,'Spoil',0,6);
INSERT INTO skill_trees VALUES (49,254,7,'Spoil',0,7);
INSERT INTO skill_trees VALUES (49,254,8,'Spoil',0,8);
INSERT INTO skill_trees VALUES (49,254,9,'Spoil',0,9);
INSERT INTO skill_trees VALUES (49,254,10,'Spoil',0,10);
INSERT INTO skill_trees VALUES (49,254,11,'Spoil',0,11);'

Удалить определенный скил с базы
DELETE FROM skill_trees WHERE skill_id = ID Скила;

Убрать Grade Penalty (штраф на грейд итемов)
DELETE FROM skill_trees WHERE skill_id = 239;

Newbie бафер (уже от грации) будет бафать вас от 1 лвла до 62
UPDATE helper_buff_list SET lower_level=1;
UPDATE helper_buff_list SET upper_level=62;

Добавляем всем нашим новичькам скилл, к примеру возьмем скилл Weight Limit
INSERT INTO skill_trees VALUES (0, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (10, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (18, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (25, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (31, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (38, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (44, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (49, 150, 1, "Weight Limit", 0, 1);
INSERT INTO skill_trees VALUES (53, 150, 1, "Weight Limit"", 0, 1);

Добавить всем персонажам скил нублеса при старте
INSERT INTO skill_trees VALUES (0, 1323, 1, "Noblesse Blessing", 0, 1);
INSERT INTO skill_trees VALUES (10, 1323, 1, "Noblesse Blessing", 0, 1);
INSERT INTO skill_trees VALUES (18, 1323, 1, "Noblesse Blessing", 0, 1);
INSERT INTO skill_trees VALUES (25, 1323, 1, "Noblesse Blessing", 0, 1);
INSERT INTO skill_trees VALUES (31, 1323, 1, "Noblesse Blessing", 0, 1);
INSERT INTO skill_trees VALUES (38, 1323, 1, "Noblesse Blessing", 0, 1);
INSERT INTO skill_trees VALUES (44, 1323, 1, "Noblesse Blessing", 0, 1);
INSERT INTO skill_trees VALUES (49, 1323, 1, "Noblesse Blessing", 0, 1);
INSERT INTO skill_trees VALUES (53, 1323, 1, "Noblesse Blessing"", 0, 1);

Добавить скилл Возвращение (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);

Добавить скилл GM Haste 1 lvl всем персонажам
INSERT INTO skill_trees VALUES (0, 7029, 1, "GM Haste", 0, 1);
INSERT INTO skill_trees VALUES (10, 7029, 1, "GM Haste", 0, 1);
INSERT INTO skill_trees VALUES (18, 7029, 1, "GM Haste", 0, 1);
INSERT INTO skill_trees VALUES (25, 7029, 1, "GM Haste", 0, 1);
INSERT INTO skill_trees VALUES (31, 7029, 1, "GM Haste", 0, 1);
INSERT INTO skill_trees VALUES (38, 7029, 1, "GM Haste", 0, 1);
INSERT INTO skill_trees VALUES (44, 7029, 1, "GM Haste", 0, 1);
INSERT INTO skill_trees VALUES (49, 7029, 1, "GM Haste", 0, 1);
INSERT INTO skill_trees VALUES (53, 7029, 1, "GM Haste", 0, 1);

SQL Автоизучение скилов 81+ для Freya сборок
REPLACE INTO `skill_trees` (`class_id`, `skill_id`, `level`, `name`, `sp`, `min_level`) VALUES
(108, 755, 1, 'Protection of Rune', 0, 82),
(108, 756, 1, 'Protection of Elemental', 0, 82),
(108, 757, 1, 'Protection of Alignment', 0, 82),
(108, 758, 1, 'Fighter''s Will', 0, 81),
(108, 759, 1, 'Archer''s Will', 0, 81),
(108, 767, 1, 'Expose Weak Point', 0, 81),
(108, 766, 1, 'Sixth Sense', 0, 81),
(108, 923, 1, 'Dual Dagger Mastery', 0, 81),
(108, 770, 1, 'Ghost Walking', 0, 83),
(108, 922, 1, 'Hide', 0, 81),
(109, 755, 1, 'Protection of Rune', 0, 82),
(109, 756, 1, 'Protection of Elemental', 0, 82),
(109, 757, 1, 'Protection of Alignment', 0, 82),
(109, 758, 1, 'Fighter''s Will', 0, 81),
(109, 759, 1, 'Archer''s Will', 0, 81),
(109, 924, 1, 'Seven Arrow', 0, 81),
(109, 946, 1, 'Silent Mind', 0, 81),
(109, 773, 1, 'Ghost Piercing', 0, 83),
(112, 755, 1, 'Protection of Rune', 0, 82),
(112, 756, 1, 'Protection of Elemental', 0, 82),
(112, 757, 1, 'Protection of Alignment', 0, 82),
(112, 945, 1, 'Magician''s Will', 0, 81),
(112, 1533, 1, 'Enlightenment', 0, 81),
(112, 1540, 1, 'Turn to Stone', 0, 81),
(112, 1507, 1, 'Lord of Vampire', 0, 83),
(106, 755, 1, 'Protection of Rune', 0, 82),
(106, 756, 1, 'Protection of Elemental', 0, 82),
(106, 757, 1, 'Protection of Alignment', 0, 82),
(106, 758, 1, 'Fighter''s Will', 0, 81),
(106, 759, 1, 'Archer''s Will', 0, 81),
(106, 760, 1, 'Anti Magic Armor', 0, 81),
(106, 766, 1, 'Sixth Sense', 0, 81),
(106, 913, 1, 'Deflect Magic', 0, 81),
(106, 788, 1, 'Pain of Shilen', 0, 83),
(106, 789, 1, 'Spirit of Shilen', 0, 83),
(107, 755, 1, 'Protection of Rune', 0, 82),
(107, 756, 1, 'Protection of Elemental', 0, 82),
(107, 757, 1, 'Protection of Alignment', 0, 82),
(107, 758, 1, 'Fighter''s Will', 0, 81),
(107, 759, 1, 'Archer''s Will', 0, 81),
(107, 766, 1, 'Sixth Sense', 0, 81),
(107, 913, 1, 'Deflect Magic', 0, 81),
(107, 915, 1, 'Dance of Berserker', 0, 83),
(111, 755, 1, 'Protection of Rune', 0, 82),
(111, 756, 1, 'Protection of Elemental', 0, 82),
(111, 757, 1, 'Protection of Alignment', 0, 82),
(111, 945, 1, 'Magician''s Will', 0, 81),
(111, 1496, 1, 'Servitor Barrier', 0, 81),
(111, 1497, 1, 'Excessive Loyalty', 0, 81),
(111, 1498, 1, 'Mutual Response', 0, 81),
(111, 930, 1, 'Spirit of the Demon', 0, 83),
(110, 755, 1, 'Protection of Rune', 0, 82),
(110, 756, 1, 'Protection of Elemental', 0, 82),
(110, 757, 1, 'Protection of Alignment', 0, 82),
(110, 945, 1, 'Magician''s Will', 0, 81),
(110, 1468, 1, 'Star Fall', 0, 81),
(110, 1532, 1, 'Enlightenmentt', 0, 81),
(110, 1494, 1, 'Hurricane Armor', 0, 83),
(117, 755, 1, 'Protection of Rune', 0, 82),
(117, 756, 1, 'Protection of Elemental', 0, 82),
(117, 757, 1, 'Protection of Alignment', 0, 82),
(117, 758, 1, 'Fighter''s Will', 0, 81),
(117, 759, 1, 'Archer''s Will', 0, 81),
(117, 767, 1, 'Expose Weak Point', 0, 81),
(117, 917, 1, 'Champion''s Favor', 0, 81),
(117, 947, 1, 'Lucky Strike', 0, 83),
(118, 755, 1, 'Protection of Rune', 0, 82),
(118, 756, 1, 'Protection of Elemental', 0, 82),
(118, 757, 1, 'Protection of Alignment', 0, 82),
(118, 758, 1, 'Fighter''s Will', 0, 81),
(118, 759, 1, 'Archer''s Will', 0, 81),
(118, 767, 1, 'Expose Weak Point', 0, 81),
(118, 917, 1, 'Champion''s Favor', 0, 81),
(118, 778, 1, 'Golem Armor', 0, 83),
(104, 755, 1, 'Protection of Rune', 0, 82),
(104, 756, 1, 'Protection of Elemental', 0, 82),
(104, 757, 1, 'Protection of Alignment', 0, 82),
(104, 945, 1, 'Magician''s Will', 0, 81),
(104, 1496, 1, 'Servitor Barrier', 0, 81),
(104, 1497, 1, 'Excessive Loyalty', 0, 81),
(104, 1498, 1, 'Mutual Response', 0, 81),
(104, 931, 1, 'Spirit of the Unicorn', 0, 83),
(105, 755, 1, 'Protection of Rune', 0, 82),
(105, 756, 1, 'Protection of Elemental', 0, 82),
(105, 757, 1, 'Protection of Alignment', 0, 82),
(105, 945, 1, 'Magician''s Will', 0, 81),
(105, 1533, 1, 'Enlightenment', 0, 81),
(105, 1540, 1, 'Turn to Stone', 0, 81),
(105, 1506, 1, 'Blessing of Eva', 0, 83),
(99, 755, 1, 'Protection of Rune', 0, 82),
(99, 756, 1, 'Protection of Elemental', 0, 82),
(99, 757, 1, 'Protection of Alignment', 0, 82),
(99, 758, 1, 'Fighter''s Will', 0, 81),
(99, 759, 1, 'Archer''s Will', 0, 81),
(99, 760, 1, 'Anti Magic Armor', 0, 81),
(99, 766, 1, 'Sixth Sense', 0, 81),
(99, 913, 1, 'Deflect Magic', 0, 81),
(99, 786, 1, 'Eva''s Will', 0, 83),
(99, 787, 1, 'Touch of Eva', 0, 83),
(102, 755, 1, 'Protection of Rune', 0, 82),
(102, 756, 1, 'Protection of Elemental', 0, 82),
(102, 757, 1, 'Protection of Alignment', 0, 82),
(102, 758, 1, 'Fighter''s Will', 0, 81),
(102, 759, 1, 'Archer''s Will', 0, 81),
(102, 924, 1, 'Seven Arrow', 0, 81),
(102, 946, 1, 'Silent Mind', 0, 81),
(102, 772, 1, 'Arrow Rain', 0, 83),
(103, 755, 1, 'Protection of Rune', 0, 82),
(103, 756, 1, 'Protection of Elemental', 0, 82),
(103, 757, 1, 'Protection of Alignment', 0, 82),
(103, 945, 1, 'Magician''s Will', 0, 81),
(103, 1468, 1, 'Star Fall', 0, 81),
(103, 1532, 1, 'Enlightenmentt', 0, 81),
(103, 1493, 1, 'Frost Armor', 0, 83),
(100, 755, 1, 'Protection of Rune', 0, 82),
(100, 756, 1, 'Protection of Elemental', 0, 82),
(100, 757, 1, 'Protection of Alignment', 0, 82),
(100, 758, 1, 'Fighter''s Will', 0, 81),
(100, 759, 1, 'Archer''s Will', 0, 81),
(100, 766, 1, 'Sixth Sense', 0, 81),
(100, 913, 1, 'Deflect Magic', 0, 81),
(100, 914, 1, 'Song of Purification', 0, 83),
(101, 755, 1, 'Protection of Rune', 0, 82),
(101, 756, 1, 'Protection of Elemental', 0, 82),
(101, 757, 1, 'Protection of Alignment', 0, 82),
(101, 758, 1, 'Fighter''s Will', 0, 81),
(101, 759, 1, 'Archer''s Will', 0, 81),
(101, 767, 1, 'Expose Weak Point', 0, 81),
(101, 766, 1, 'Sixth Sense', 0, 81),
(101, 923, 1, 'Dual Dagger Mastery', 0, 81),
(101, 769, 1, 'Wind Riding', 0, 83),
(101, 922, 1, 'Hide', 0, 81),
(93, 755, 1, 'Protection of Rune', 0, 82),
(93, 756, 1, 'Protection of Elemental', 0, 82),
(93, 757, 1, 'Protection of Alignment', 0, 82),
(93, 758, 1, 'Fighter''s Will', 0, 81),
(93, 759, 1, 'Archer''s Will', 0, 81),
(93, 767, 1, 'Expose Weak Point', 0, 81),
(93, 766, 1, 'Sixth Sense', 0, 81),
(93, 923, 1, 'Dual Dagger Mastery', 0, 81),
(93, 768, 1, 'Exciting Adventure', 0, 83),
(93, 922, 1, 'Hide', 0, 81),
(96, 755, 1, 'Protection of Rune', 0, 82),
(96, 756, 1, 'Protection of Elemental', 0, 82),
(96, 757, 1, 'Protection of Alignment', 0, 82),
(96, 945, 1, 'Magician''s Will', 0, 81),
(96, 1496, 1, 'Servitor Barrier', 0, 81),
(96, 1497, 1, 'Excessive Loyalty', 0, 81),
(96, 1498, 1, 'Mutual Response', 0, 81),
(96, 929, 1, 'Spirit of the Cat', 0, 83),
(94, 755, 1, 'Protection of Rune', 0, 82),
(94, 756, 1, 'Protection of Elemental', 0, 82),
(94, 757, 1, 'Protection of Alignment', 0, 82),
(94, 945, 1, 'Magician''s Will', 0, 81),
(94, 1467, 1, 'Meteor', 0, 81),
(94, 1532, 1, 'Enlightenmentt', 0, 81),
(94, 1492, 1, 'Flame Armor', 0, 83),
(97, 755, 1, 'Protection of Rune', 0, 82),
(97, 756, 1, 'Protection of Elemental', 0, 82),
(97, 757, 1, 'Protection of Alignment', 0, 82),
(97, 945, 1, 'Magician''s Will', 0, 81),
(97, 1533, 1, 'Enlightenment', 0, 81),
(97, 1540, 1, 'Turn to Stone', 0, 81),
(97, 1498, 1, 'Mutual Response', 0, 81),
(97, 1505, 1, 'Sublime Self-Sacrifice', 0, 83),
(89, 755, 1, 'Protection of Rune', 0, 82),
(89, 756, 1, 'Protection of Elemental', 0, 82),
(89, 757, 1, 'Protection of Alignment', 0, 82),
(89, 758, 1, 'Fighter''s Will', 0, 81),
(89, 759, 1, 'Archer''s Will', 0, 81),
(89, 767, 1, 'Expose Weak Point', 0, 81),
(89, 917, 1, 'Champion''s Favor', 0, 81),
(89, 774, 1, 'Dread Pool', 0, 83),
(88, 755, 1, 'Protection of Rune', 0, 82),
(88, 756, 1, 'Protection of Elemental', 0, 82),
(88, 757, 1, 'Protection of Alignment', 0, 82),
(88, 758, 1, 'Fighter''s Will', 0, 81),
(88, 759, 1, 'Archer''s Will', 0, 81),
(88, 767, 1, 'Expose Weak Point', 0, 81),
(88, 917, 1, 'Champion''s Favor', 0, 81),
(88, 775, 1, 'Weapon Blockade', 0, 83),
(88, 919, 1, 'Maximum Focus Sonic', 0, 83),
(91, 755, 1, 'Protection of Rune', 0, 82),
(91, 756, 1, 'Protection of Elemental', 0, 82),
(91, 757, 1, 'Protection of Alignment', 0, 82),
(91, 758, 1, 'Fighter''s Will', 0, 81),
(91, 759, 1, 'Archer''s Will', 0, 81),
(91, 760, 1, 'Anti Magic Armor', 0, 81),
(91, 766, 1, 'Sixth Sense', 0, 81),
(91, 913, 1, 'Deflect Magic', 0, 81),
(91, 761, 1, 'Seed of Revenge', 0, 83),
(91, 762, 1, 'Insane Crusher', 0, 83),
(91, 763, 1, 'Hell Scream', 0, 83),
(98, 755, 1, 'Protection of Rune', 0, 82),
(98, 756, 1, 'Protection of Elemental', 0, 82),
(98, 757, 1, 'Protection of Alignment', 0, 82),
(98, 945, 1, 'Magician''s Will', 0, 81),
(98, 1533, 1, 'Enlightenment', 0, 81),
(98, 1540, 1, 'Turn to Stone', 0, 81),
(98, 1498, 1, 'Mutual Response', 0, 81),
(98, 1542, 1, 'Counter Critical', 0, 83),
(90, 755, 1, 'Protection of Rune', 0, 82),
(90, 756, 1, 'Protection of Elemental', 0, 82),
(90, 757, 1, 'Protection of Alignment', 0, 82),
(90, 758, 1, 'Fighter''s Will', 0, 81),
(90, 759, 1, 'Archer''s Will', 0, 81),
(90, 760, 1, 'Anti Magic Armor', 0, 81),
(90, 766, 1, 'Sixth Sense', 0, 81),
(90, 913, 1, 'Deflect Magic', 0, 81),
(90, 784, 1, 'Spirit of Phoenix', 0, 83),
(90, 785, 1, 'Flame Icon', 0, 83),
(90, 912, 1, 'Summon Imperial Phoenix', 0, 83),
(92, 755, 1, 'Protection of Rune', 0, 82),
(92, 756, 1, 'Protection of Elemental', 0, 82),
(92, 757, 1, 'Protection of Alignment', 0, 82),
(92, 758, 1, 'Fighter''s Will', 0, 81),
(92, 759, 1, 'Archer''s Will', 0, 81),
(92, 924, 1, 'Seven Arrow', 0, 81),
(92, 946, 1, 'Silent Mind', 0, 81),
(92, 771, 1, 'Flame Hawk', 0, 83),
(95, 755, 1, 'Protection of Rune', 0, 82),
(95, 756, 1, 'Protection of Elemental', 0, 82),
(95, 757, 1, 'Protection of Alignment', 0, 82),
(95, 945, 1, 'Magician''s Will', 0, 81),
(95, 1467, 1, 'Meteor', 0, 81),
(95, 1532, 1, 'Enlightenmentt', 0, 81),
(95, 1495, 1, 'Vampiric Mist', 0, 83),
(133, 755, 1, 'Protection of Rune', 0, 82),
(133, 756, 1, 'Protection of Elemental', 0, 82),
(133, 757, 1, 'Protection of Alignment', 0, 82),
(133, 758, 1, 'Fighter''s Will', 0, 81),
(133, 759, 1, 'Archer''s Will', 0, 81),
(133, 767, 1, 'Expose Weak Point', 0, 81),
(133, 766, 1, 'Sixth Sense', 0, 81),
(133, 1532, 1, 'Enlightenment', 0, 81),
(133, 791, 1, 'Lightning Shock', 0, 83),
(134, 755, 1, 'Protection of Rune', 0, 82),
(134, 756, 1, 'Protection of Elemental', 0, 82),
(134, 757, 1, 'Protection of Alignment', 0, 82),
(134, 758, 1, 'Fighter''s Will', 0, 81),
(134, 759, 1, 'Archer''s Will', 0, 81),
(134, 790, 1, 'Wild Shot', 0, 83),
(131, 755, 1, 'Protection of Rune', 0, 82),
(131, 756, 1, 'Protection of Elemental', 0, 82),
(131, 757, 1, 'Protection of Alignment', 0, 82),
(131, 758, 1, 'Fighter''s Will', 0, 81),
(131, 759, 1, 'Archer''s Will', 0, 81),
(131, 767, 1, 'Expose Weak Point', 0, 81),
(131, 917, 1, 'Champion''s Favor', 0, 81),
(131, 948, 1, 'Eye for Eye', 0, 83),
(132, 755, 1, 'Protection of Rune', 0, 82),
(132, 756, 1, 'Protection of Elemental', 0, 82),
(132, 757, 1, 'Protection of Alignment', 0, 82),
(132, 758, 1, 'Fighter''s Will', 0, 81),
(132, 759, 1, 'Archer''s Will', 0, 81),
(132, 767, 1, 'Expose Weak Point', 0, 81),
(132, 766, 1, 'Sixth Sense', 0, 81),
(132, 1532, 1, 'Enlightenment', 0, 81),
(132, 791, 1, 'Lightning Shock', 0, 83),
(115, 755, 1, 'Protection of Rune', 0, 82),
(115, 756, 1, 'Protection of Elemental', 0, 82),
(115, 757, 1, 'Protection of Alignment', 0, 82),
(115, 945, 1, 'Magician''s Will', 0, 81),
(115, 1533, 1, 'Enlightenment', 0, 81),
(115, 1540, 1, 'Turn to Stone', 0, 81),
(115, 949, 1, 'Onslaught of Pa''agrio', 0, 83),
(115, 1509, 1, 'Seal of Limit', 0, 83),
(116, 755, 1, 'Protection of Rune', 0, 82),
(116, 756, 1, 'Protection of Elemental', 0, 82),
(116, 757, 1, 'Protection of Alignment', 0, 82),
(116, 945, 1, 'Magician''s Will', 0, 81),
(116, 1533, 1, 'Enlightenment', 0, 81),
(116, 1540, 1, 'Turn to Stone', 0, 81),
(116, 1543, 1, 'Great Fury', 0, 83),
(114, 755, 1, 'Protection of Rune', 0, 82),
(114, 756, 1, 'Protection of Elemental', 0, 82),
(114, 757, 1, 'Protection of Alignment', 0, 82),
(114, 758, 1, 'Fighter''s Will', 0, 81),
(114, 759, 1, 'Archer''s Will', 0, 81),
(114, 767, 1, 'Expose Weak Point', 0, 81),
(114, 917, 1, 'Champion''s Favor', 0, 81),
(114, 776, 1, 'Force of Destruction', 0, 83),
(114, 918, 1, 'Maximum Focus Force', 0, 83),
(113, 755, 1, 'Protection of Rune', 0, 82),
(113, 756, 1, 'Protection of Elemental', 0, 82),
(113, 757, 1, 'Protection of Alignment', 0, 82),
(113, 758, 1, 'Fighter''s Will', 0, 81),
(113, 759, 1, 'Archer''s Will', 0, 81),
(113, 767, 1, 'Expose Weak Point', 0, 81),
(113, 917, 1, 'Champion''s Favor', 0, 81),
(113, 777, 1, 'Demolition Impact', 0, 83),
(8, 821, 1, 'Shadow Step', 0, 72),
(23, 821, 1, 'Shadow Step', 0, 72),
(36, 821, 1, 'Shadow Step', 0, 72),
(43, 1500, 1, 'Improved Magic', 390000, 70),
(43, 1502, 1, 'Improved Critical Attack', 390000, 70),
(23, 819, 1, 'Evasion Chance', 0, 74),
(8, 820, 1, 'Evasion Haste', 0, 74),
(36, 818, 1, 'Evasion Counter', 0, 74),
(51, 1536, 1, 'Combat of Pa''agrio', 0, 70),
(51, 1538, 1, 'Condition of Pa''agrio', 0, 72),
(51, 1537, 1, 'Critical of Pa''agrio', 0, 74),
(93, 928, 1, 'Duel Blow', 0, 81),
(101, 928, 1, 'Duel Blow', 0, 81),
(108, 928, 1, 'Duel Blow', 0, 81),
(52, 1517, 1, 'Chant of Combat', 0, 70),
(52, 1535, 1, 'Chant of Movement', 0, 72),
(52, 1518, 1, 'Chant of Critical Attack', 0, 72),
(52, 1519, 1, 'Chant of Blood Awakening', 0, 74),
(17, 1499, 1, 'Improve Combat', 0, 70),
(17, 1501, 1, 'Improve Condition', 0, 70),
(30, 1503, 1, 'Improve Shield Defence', 0, 70),
(30, 1504, 1, 'Improve Movement', 0, 70),
(95, 1541, 1, 'Curse of Desparion', 0, 83),
(100, 764, 1, 'Curse of Desparion', 0, 76);

Возвращаем РБ бижу Боссам
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');

У РБ будет 5к хп
UPDATE `npc` SET `hp`='5000000' WHERE (SELECT id) AND npc.type='L2Raidboss';

Эти зaпpocы пoнижaют физ.aтк. и м.aтк в 5 paз, физ.зaщ. и м.зaщ. в 2 paзa y ГpэндБoccoв(Aнт, Baля и т.п.)
UPDATE `npc` SET `patk` = `patk`*0.2 WHERE `type` = 'L2GrandBoss';
UPDATE `npc` SET `matk` = `matk`*0.2 WHERE `type` = 'L2GrandBoss';
UPDATE `npc` SET `pdef` = `pdef`*0.5 WHERE `type` = 'L2GrandBoss';
UPDATE `npc` SET `mdef` = `mdef`*0.5 WHERE `type` = 'L2GrandBoss';

Все гранд босы станут 80 лвлом
UPDATE npc SET `level`=80 WHERE `type`="L2GrandBoss"

Добавить бижу в РБ, если вы удалили её
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');

Эти зaпpocы дeлaют вpeмя pecпaвнa PeйдБoccoв: мин.вpeмя - 1 чac, мaкc.вpeмя - 2 чaca
UPDATE `raidboss_spawnlist` SET `respawn_min_delay` = '3600';
UPDATE `raidboss_spawnlist` SET `respawn_max_delay` = '7200';

Респ нубл РБ (Баракиэль) 2 часа
UPDATE `raidboss_spawnlist` SET `respawn_min_delay`='7200', `respawn_max_delay`='7200' WHERE (`boss_id`='25325') AND (`loc_x`='91008') AND (`loc_y`='-85904') AND (`loc_z`='-2736');

Уменьшить защиту рейдбосов на 40%
UPDATE npc SET pdef = pdef * 0.6 WHERE type = 'L2RaidBoss';
UPDATE npc SET hp = hp * 0.6 WHERE type = 'L2RaidBoss';
UPDATE npc SET mdef = mdef * 0.6 WHERE type = 'L2RaidBoss';

Добавить все клановые скиллы определенному клану
INSERT INTO `clan_skills` VALUES
('ID Клана','370','3','Clan Vitality'),
('ID Клана','371','3','Clan Spirituality'),
('ID Клана','372','3','Clan Essence'),
('ID Клана','373','3','Clan Lifeblood'),
('ID Клана','374','3','Clan Morale'),
('ID Клана','375','3','Clan Clarity'),
('ID Клана','376','3','Clan Might'),
('ID Клана','377','3','Clan Aegis'),
('ID Клана','378','3','Clan Empowerment'),
('ID Клана','379','3','Clan Magic Protection'),
('ID Клана','380','3','Clan Guidance'),
('ID Клана','381','3','Clan Agility'),
('ID Клана','382','3','Clan Withstand-Attack'),
('ID Клана','383','3','Clan Shield Boost'),
('ID Клана','384','3','Clan Cyclonic Resistance'),
('ID Клана','385','3','Clan Magmatic Resistance'),
('ID Клана','386','3','Clan Fortitude'),
('ID Клана','387','3','Clan Freedom'),
('ID Клана','388','3','Clan Vigilance'),
('ID Клана','389','3','Clan March'),
('ID Клана','390','3','Clan Luck'),
('ID Клана','391','1','Clan Imperium');

Отчистка всех кланов
UPDATE`characters`SET`clanid`='0';

Шанс дропа клановых яиц 75%
UPDATE droplist SET chance='7500000' WHERE ItemId in (8158, 8159, 8160, 8161, 8162, 8163, 8164, 8165, 8166, 8167, 8168, 8169, 8170, 8171, 8172, 8173, 8174, 8175, 8176);

Изменить стоимость нанесение краски
UPDATE henna SET price=Цена;

Делает вес всех шмоток 1
update etcitem set weight=1 where weight > 1;
update weapon set weight=1 where weight > 1;
update armor set weight=1 where weight > 1;

Сделать телепорт бесплатным
UPDATE teleport SET price=0;

Все итемы по 5 адены
update etcitem set price=5 where price > 5;
update weapon set price=5 where price > 5;
update armor set price=5 where price > 5;

Сделать всех петов сильнее (классная вещь) или сделай себе ручного антараса
UPDATE `npc` SET `hp` = `hp` * 1.5 where type='L2Pet';
UPDATE `npc` SET `mp` = `mp` * 1.5 where type='L2Pet';
UPDATE `npc` SET `patk` = `patk` * 1.5 where type='L2Pet';
UPDATE `npc` SET `matk` = `matk` * 1.5 where type='L2Pet';
UPDATE `npc` SET `pdef` = `pdef` * 1.5 where type='L2Pet';
UPDATE `npc` SET `mdef` = `mdef` * 1.5 where type='L2Pet';
UPDATE `npc` SET `runspd` = `runspd` * 1.5 where type='L2Pet';

Усиливаем Guard'ов (p.def, m.def, p.atk, hp) на 50%
UPDATE `npc` SET `hp` = `hp` * 1.5 where type='L2Guard;
UPDATE `npc` SET `mp` = `mp` * 1.5 where type=''L2Guard';
UPDATE `npc` SET `patk` = `patk` * 1.5 where type=''L2Guard';
UPDATE `npc` SET `matk` = `matk` * 1.5 where type=''L2Guard';
UPDATE `npc` SET `pdef` = `pdef` * 1.5 where type=''L2Guard';
UPDATE `npc` SET `mdef` = `mdef` * 1.5 where type=''L2Guard';
UPDATE `npc` SET `runspd` = `runspd` * 1.5 where type=''L2Guard';

Добавляем им (мобам на дино острове) резист к стрелам
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22196','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22197','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22198','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22199','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22200','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22201','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22202','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22203','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22204','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22205','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22208','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22209','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22210','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22211','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22212','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22213','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22214','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22215','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22216','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22217','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22218','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22219','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22220','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22221','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22222','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22223','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22224','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22225','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22226','4071','4');
INSERT INTO `npcskills` (`npcid`,`skillid`,`level`) VALUES ('22227','4071','4');

Добавляем на острове дроп лоу А грейд пушек(0.25%)
INSERT INTO `droplist` VALUES ('22200','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22200','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22200','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22200','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22200','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22200','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22200','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22200','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22200','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22201','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22201','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22201','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22201','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22201','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22201','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22201','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22201','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22201','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22202','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22202','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22202','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22202','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22202','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22202','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22202','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22202','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22202','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22203','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22203','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22203','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22203','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22203','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22203','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22203','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22203','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22203','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22204','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22204','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22204','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22204','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22204','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22204','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22204','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22204','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22204','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22205','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22205','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22205','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22205','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22205','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22205','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22205','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22205','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22205','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22208','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22208','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22208','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22208','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22208','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22208','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22208','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22208','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22208','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22209','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22209','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22209','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22209','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22209','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22209','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22209','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22209','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22209','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22210','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22210','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22210','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22210','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22210','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22210','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22210','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22210','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22210','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22211','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22211','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22211','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22211','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22211','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22211','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22211','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22211','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22211','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22212','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22212','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22212','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22212','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22212','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22212','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22212','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22212','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22212','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22213','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22213','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22213','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22213','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22213','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22213','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22213','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22213','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22213','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22214','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22214','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22214','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22214','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22214','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22214','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22214','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22214','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22214','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22215','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22215','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22215','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22215','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22215','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22215','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22215','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22215','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22215','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22216','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22216','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22216','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22216','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22216','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22216','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22216','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22216','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22216','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22217','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22217','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22217','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22217','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22217','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22217','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22217','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22217','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22217','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22218','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22218','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22218','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22218','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22218','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22218','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22218','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22218','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22218','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22219','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22219','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22219','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22219','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22219','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22219','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22219','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22219','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22219','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22220','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22220','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22220','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22220','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22220','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22220','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22220','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22220','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22220','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22221','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22221','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22221','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22221','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22221','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22221','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22221','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22221','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22212','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22222','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22222','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22222','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22222','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22222','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22222','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22222','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22222','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22222','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22223','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22223','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22223','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22223','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22223','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22223','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22223','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22223','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22223','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22224','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22224','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22224','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22224','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22224','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22224','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22224','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22224','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22224','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22225','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22225','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22225','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22225','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22225','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22225','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22225','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22225','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22225','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22226','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22226','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22226','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22226','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22226','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22226','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22226','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22226','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22226','288','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22227','80','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22227','81','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22227','98','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22227','151','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22227','2504','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22227','4903','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22227','235','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22227','269','0','1','5','2500');
INSERT INTO `droplist` VALUES ('22227','288','0','1','5','2500');

INSERT INTO `droplist` SELECT id, '8166','1','2','11','1000000' FROM `npc` WHERE `type` = 'L2RaidBoss';
INSERT INTO `droplist` SELECT id, '8176','1','2','11','1000000' FROM `npc` WHERE `type` = 'L2RaidBoss';
INSERT INTO `droplist` SELECT id, '8163','1','2','11','1000000' FROM `npc` WHERE `type` = 'L2RaidBoss';
INSERT INTO `droplist` SELECT id, '8169','1','2','11','1000000' FROM `npc` WHERE `type` = 'L2RaidBoss';
INSERT INTO `droplist` SELECT id, '8160','1','2','11','1000000' FROM `npc` WHERE `type` = 'L2RaidBoss';
INSERT INTO `droplist` SELECT id, '8172','1','2','11','1000000' FROM `npc` WHERE `type` = 'L2RaidBoss';
INSERT INTO `droplist` SELECT id, '8175','1','2','11','1000000' FROM `npc` WHERE `type` = 'L2RaidBoss';