Последние ответы форума Реклама
Тема Раздел
Пишем бота для Lineage 2 [Delphi] #1 Программирование
Продам DownloaderBot [Торговля] Продажа
Все варианты обхода защит в одной теме! Актуальные уязвимости Lineage 2
Прямые руки или обход Smart Guard? Актуальные уязвимости Lineage 2
Как работать с потоками Delphi? Программирование
Куплю обход защиты СГ [Торговля] Продажа
(Уязвимость) Получаем админку на vBulletin Актуальные уязвимости Lineage 2

Очень часто, администраторы игровых серверов Lineage 2, разрабатывают сервер и встречаются с трудностями. Конечно, опытный пользователь сможет сам составить SQL Запросы, но если в деле только начинающий админ, то ему будет очень полезно прочесть 30 Отборных Запросов для Lineage 2. Сама польза исходя из всего этого - это готовые запросы, бывает, что просто из головы вылетает, тот запрос, который хочешь составить, поэтому для таких как я, статья:D

Вес всех вещей = 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','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');
 

Запросы понижают физ.атк. и м.атк в 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);
 

 

 

 

 

 

 

Комментариев: 0

Внимание, обнаружена ошибка
У вас нет доступа к комментированию, пожалуйста авторизуйтесь или зарегистрируйтесь на сайте!