Полезные SQL Запросы Lineage 2

Поиск в этой теме

Опции темы

Полезные SQL Запросы Lineage 2

Warhangel

Опубликовано 14-03-2017 05:01

Супер Администратор

Сообщений: 2693
Вас поблагодарили: 29
раз(а) в 25 сообщениях
Зарегистрирован: 24.03.10
Со дня регистрации: 5738

Откуда: Россия

Скрыть награды

header=[Награда №1] body=[Медаль Создателя]

Перед использованием sql-запросов обязательно делаем backup базы!

Вес всех вещей = 0

Код выделить всё

UPDATE `etcitem` SET `weight`=0 WHERE `weight`>0;

UPDATE `armor` SET `weight`=0 WHERE `weight`>0;

UPDATE `weapon` SET `weight`=0 WHERE `weight`>0;

Полное удаление Нпса из БД

Код выделить всё

DELETE FROM spawnlist WHERE npc_templateid = 50000;

DELETE FROM npc WHERE id = 50000;

Удаление всех вещей с определённым ID у определнного персонажа.

Код выделить всё

DELETE * FROM items WHERE item_id=(ид того что удалить) AND owner_id=(ИД перса, у которого удалить)

Снижение цен продажи вещей в магазины до 1 адены:

Код выделить всё

update etcitem set price=1 where price > 1;

update weapon set price=1 where price > 1;

update armor set price=1 where price > 1;

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

Код выделить всё

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

Устанавливаем шанс дропа аден 100% вместо 70%

Код выделить всё

UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=57;

Удаляем из дропа всё, кроме вещей с ID 57, 77, 107

Код выделить всё

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

Удаление дропа(мусор):

Код выделить всё

DELETE FROM droplist WHERE itemId='1864';

DELETE FROM droplist WHERE itemId='1865';

DELETE FROM droplist WHERE itemId='1866';

DELETE FROM droplist WHERE itemId='1868';

DELETE FROM droplist WHERE itemId='1869';

DELETE FROM droplist WHERE itemId='1870';

DELETE FROM droplist WHERE itemId='1871';

DELETE FROM droplist WHERE itemId='1872';

DELETE FROM droplist WHERE itemId='1873';

DELETE FROM droplist WHERE itemId='1874';

DELETE FROM droplist WHERE itemId='1875';

DELETE FROM droplist WHERE itemId='1876';

DELETE FROM droplist WHERE itemId='1877';

DELETE FROM droplist WHERE itemId='1878';

DELETE FROM droplist WHERE itemId='1879';

DELETE FROM droplist WHERE itemId='1880';

DELETE FROM droplist WHERE itemId='1881';

DELETE FROM droplist WHERE itemId='1882';

DELETE FROM droplist WHERE itemId='1884';

DELETE FROM droplist WHERE itemId='1885';

DELETE FROM droplist WHERE itemId='1895';

DELETE FROM droplist WHERE itemId='5549';

DELETE FROM droplist WHERE itemId='1886';

DELETE FROM droplist WHERE itemId='1887';

DELETE FROM droplist WHERE itemId='1888';

DELETE FROM droplist WHERE itemId='1890';

DELETE FROM droplist WHERE itemId='1891';

DELETE FROM droplist WHERE itemId='1892';

DELETE FROM droplist WHERE itemId='1893';

DELETE FROM droplist WHERE itemId='1889';

DELETE FROM droplist WHERE itemId='1894';

DELETE FROM droplist WHERE itemId='4039';

DELETE FROM droplist WHERE itemId='4040';

DELETE FROM droplist WHERE itemId='4041';

DELETE FROM droplist WHERE itemId='4042';

DELETE FROM droplist WHERE itemId='4043';

DELETE FROM droplist WHERE itemId='4044';

DELETE FROM droplist WHERE itemId='4046';

DELETE FROM droplist WHERE itemId='4047';

DELETE FROM droplist WHERE itemId='4045';

DELETE FROM droplist WHERE itemId='5550';

DELETE FROM droplist WHERE itemId='4048';

Стрелы

Код выделить всё

DELETE FROM droplist WHERE itemId='17';

DELETE FROM droplist WHERE itemId='1341';

DELETE FROM droplist WHERE itemId='1342';

DELETE FROM droplist WHERE itemId='1343';

DELETE FROM droplist WHERE itemId='1344';

DELETE FROM droplist WHERE itemId='1345';

DELETE FROM droplist WHERE itemId='4048';

Potions

Код выделить всё

DELETE FROM droplist WHERE itemId='1539';

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

Возвращаем РБ бижу Боссам

Код выделить всё

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

Добавляем скил Weight Limit всем персонажам.

Код выделить всё

INSERT INTO skill_trees VALUES (0,150,2,'Weight Limit',0,1);

INSERT INTO skill_trees VALUES (10,150,2,'Weight Limit',0,1);

INSERT INTO skill_trees VALUES (18,150,2,'Weight Limit',0,1);

INSERT INTO skill_trees VALUES (25,150,2,'Weight Limit',0,1);

INSERT INTO skill_trees VALUES (31,150,2,'Weight Limit',0,1);

INSERT INTO skill_trees VALUES (38,150,2,'Weight Limit',0,1);

INSERT INTO skill_trees VALUES (44,150,2,'Weight Limit',0,1);

INSERT INTO skill_trees VALUES (49,150,2,'Weight Limit',0,1);

INSERT INTO skill_trees VALUES (53,150,2,'Weight Limit',0,1);

Добавляем скил Noblesse Blessingt всем персонажам

Код выделить всё

INSERT INTO skill_trees VALUES (0,1323,2,'Noblesse Blessing',0,1);

INSERT INTO skill_trees VALUES (10,1323,2,'Noblesse Blessing',0,1);

INSERT INTO skill_trees VALUES (18,1323,2,'Noblesse Blessing',0,1);

INSERT INTO skill_trees VALUES (25,1323,2,'Noblesse Blessing',0,1);

INSERT INTO skill_trees VALUES (31,1323,2,'Noblesse Blessing',0,1);

INSERT INTO skill_trees VALUES (38,1323,2,'Noblesse Blessing',0,1);

INSERT INTO skill_trees VALUES (44,1323,2,'Noblesse Blessing',0,1);

INSERT INTO skill_trees VALUES (49,1323,2,'Noblesse Blessing',0,1);

INSERT INTO skill_trees VALUES (53,1323,2,'Noblesse Blessing',0,1);

Авторестарт

Код выделить всё

INSERT INTO global_tasks VALUES (id, 'restart', 'TYPE_GLOBAL_TASK', '0', '1', '03:00:00', '600');

'03:00:00' - время рестарта по часовому поясу сервера, '600' - продолжительность рестарта, в сек.

Умножает Шанс Дропа на 10 у всех РБ и Боссов, и ставит 100% где получилось больше 100%:

Код выделить всё

UPDATE droplist

SET chance =chance*10

WHERE mobId IN (SELECT id FROM npc WHERE type IN ("L2RaidBoss", "L2Boss"));



UPDATE droplist

SET chance=1000000

WHERE chance > 1000000;



UPDATE droplist

SET chance =chance*10

WHERE mobId IN (SELECT id FROM npc WHERE type IN ("L2RaidBoss", "L2Boss"));



UPDATE droplist

SET chance=1000000

WHERE chance > 1000000;

Увеличиваем М.Деф на Дино острове всем динозаврам:

Код выделить всё

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22196');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22197');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22198');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22199');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22200');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22201');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22202');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22203');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22204');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22205');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22208');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22209');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22210');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22211');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22212');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22213');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22214');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22215');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22216');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22217');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22218');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22219');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22220');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22221');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22222');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22223');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22224');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22225');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22226');

UPDATE `npc` SET `mdef`='2000' WHERE (`id`='22227');

Добавляем им (мобам на дино острове) резист к стрелам:

Код выделить всё

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', 9;2500');

INSERT INTO `droplist` VALUES ('22200','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22201','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22202','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22203','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22204','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22205','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22208','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22209','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22210','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22211','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22212','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22213','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22214','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22215','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22216','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22217','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22218','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22219','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22220','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22221','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22222','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22223','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22224','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22225','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22226','4903','0','1','5', 9;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', 9;2500');

INSERT INTO `droplist` VALUES ('22227','4903','0','1','5', 9;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');

Запросы понижают физ.атк. и м.атк в 3 раза, физ.защ. и м.защ. в 1.2 раз у РейдБоссо

Код выделить всё

UPDATE `npc` SET `patk` = `patk`*0.33 WHERE `type` = 'L2RaidBoss';

UPDATE `npc` SET `matk` = `matk`*0.33 WHERE `type` = 'L2RaidBoss';

UPDATE `npc` SET `pdef` = `pdef`*0.8 WHERE `type` = 'L2RaidBoss';

UPDATE `npc` SET `mdef` = `mdef`*0.8 WHERE `type` = 'L2RaidBoss';

Запросы понижают физ.атк, м.атк. и физ.защ, м.защ в 1.2 раз у мобов:

Код выделить всё

UPDATE `npc` SET `patk` = `patk`*0.8 WHERE `type` = 'L2Monster';

UPDATE `npc` SET `matk` = `matk`*0.8 WHERE `type` = 'L2Monster';

UPDATE `npc` SET `pdef` = `pdef`*0.8 WHERE `type` = 'L2Monster';

UPDATE `npc` SET `mdef` = `mdef`*0.8 WHERE `type` = 'L2Monster';

Зaпpocы пoнижaют физ.aтк. и м.aтк в 3 paзa, физ.зaщ. и м.зaщ. в 1.2 paз y Mиниoнoв:

Код выделить всё

UPDATE `npc` SET `patk` = `patk`*0.33 WHERE `type` = 'L2Minion';

UPDATE `npc` SET `matk` = `matk`*0.33 WHERE `type` = 'L2Minion';

UPDATE `npc` SET `pdef` = `pdef`*0.8 WHERE `type` = 'L2Minion';

UPDATE `npc` SET `mdef` = `mdef`*0.8 WHERE `type` = 'L2Minion';



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

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

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

Все игроки начинают игру в дионе

Код выделить всё

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

Добавить всем РБ в дроп Coin of Luck(id 4073), в количестве от 1 до 4 и с шансом 47%

Код выделить всё

INSERT INTO `droplist` (mobId, itemId, min, max, category, chance) SELECT id, 4037, 1, 4, 0, 470000 FROM `npc` WHERE type = 'L2RaidBoss';

Удаление всех аккаунтов с уровнем доступа 100

Код выделить всё

DELETE FROM `accounts` WHERE (`access_level`='100');

Удаляем всё, кроме вещей с ID 57, 77, 107.

Код выделить всё

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

Нубы в лудшем No 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", 33, 27, 219, 68, 625);

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, 33, 27, 219, 68, 625);

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", 33, 27, 219, 68, 625);

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, 33, 27, 219, 257, 625);

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, 33, 27, 219, 68, 625);

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, 68, 625);

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, 68, 625);

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, 68, 625);

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, 177, 257, 625);

Вывести всех персонажей, их аккаунты и вещи, чья заточка выше 25 и уровнень доступа < 1.

Код выделить всё

SELECT c.`account_name` `аккаунт`, c.`char_name` `чар`, c.`level`, a.`name` `броня`, a.`bodypart`, w.`name` `оружие`, s.`name` `прочее`, s.`item_type` `тип`, i.`enchant_level` `заточка`

FROM `characters` c

JOIN `items` i ON i.`enchant_level` > 25 AND c.`charId` = i.`owner_id` AND c.`accesslevel` < 1

LEFT JOIN `etcitem` s ON s.`item_id` = i.`item_id`

LEFT JOIN `armor` a ON a.`item_id` = i.`item_id`

LEFT JOIN `weapon` w ON w.`item_id` = i.`item_id`

ORDER BY c.`account_name`;

Увеличить респаун мобов в 2 раза

Код выделить всё

UPDATE `spawnlist` SET `respawn_delay` = `respawn_delay`*2 WHERE `npc_templateid` IN (SELECT `idTemplate` FROM `npc` WHERE `class` LIKE "%Monster%");

Шанс дропа клановых яиц 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);

Game новости

Game сервисы

Инфо сервисы