Скрипты для uCoz, Шаблоны для uCoz, cs 1.6 скачать, Скачать читы для cs 1.6 бесплатно, Патчи для cs, все для css, готовый сервер css, моды для css, модели оружия, все для FIFA11, все для PES2011, все для uCoz, Counter-Strike

Скачать Полезные SQL Запросы Lineage 2 бесплатно

С удовольствием представлю Вам небольшой список SQL-запросов для Lineage 2 Java-сервера.
Для использования нужно иметь Navicat или Phpmyadmin. Скачать их можно у нас на сайте l2pro.3dn.ru
Работа данных sql скриптов была проверена на множестве серверов и соответствует требованиям структуры таблиц среднестатистического java-эмулятора Lineage 2 сервера.

Скрипты помогут Вам продвинуть Ваш сервер среди остальных, тем самым продвижение сайта к которому привязан сервер - также пойдет прямым путем, а рост позиций в рейтингах, вроде L2Top - будет все выше и выше.

SQL запросы позволяют сделать с Вашего сервера - полностью уникальный и интересный сервер.

Перед использованием 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');

Умножает Шанс Дропа на 10 у всех РБ и Боссов, и ставит 100% где получилось больше 100%:
UPDATE droplist
SET chance =chance*10
WHERE mobId IN (SELECT id FROM npc WHERE type IN ("L2RaidBoss", "L2Boss"));

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

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

З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 `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);

Для скачивания файлов с Axe-Game.Ru необходимо
Зарегистрироваться или Авторизоваться

Копирование материала запрещено! Исключение если есть ссылка на источник L2pro.3dn.Ru

Просмотров: 5 | Комментариев0 | Добавил: Exclusive | Рейтинг: