Сборник полезных запросов mySQL для вашего собственного сервера л2
Инструкция для новичков по выполнению полезных sql запросов
Есть несколько способов выполнить запрос. Я быстренько расскажу о том как сделать запрос для своего собстенного сервера л2 через Navicat for mySQL
Если вы уже поставили свой собственный сервер л2, то предполагаю, что Навикат (Navicat for mySQL) у вас уже есть. Ну а если нет, вы всегда можете его скачать либо с нашего сайта lasteam.ru, либо в официального сайта (скачать)
Хорошо. Скачали, поставили, теперь пора и запросы делать. Теперь открываем блокнот. Вписываем в него наш полезный mySQL запрос и сохраняем с разширением .sql
Затем входим в навикат, открываем соединение с нашей базой, нажимаем на базу правой кнопкой и выбираем Execute SQL file. В открывшемся окошке выбираем путь до нашего файла название.sql и успешно заливаем его в базу. И вуаля!
Установить Шанс дропа Адены на параметр 100% (1000000=100%) вместо стандартных 70%
Установить цены на продажу всех предметов, всего оружия и всей брони по 0 Аден
update weapon set price=1 where price > 1;
update armor set price=1 where price > 1;
Для заточки скиллов не требуется Опыть и SP
UPDATE enchant_skill_trees SET exp=0;
Удалить скил пенальти (Great Penalty)
Увеличить статы (Str,Int,Dex,Wit,Men,Con) всех персонажей в 2 раза
UPDATE `char_templates` SET `STR`='44' WHERE (SELECT ClassId) AND (str = '22');
UPDATE `char_templates` SET `STR`='72' WHERE (SELECT ClassId) AND (str = '36');
UPDATE `char_templates` SET `STR`='42' WHERE (SELECT ClassId) AND (str = '21');
UPDATE `char_templates` SET `STR`='46' WHERE (SELECT ClassId) AND (str = '23');
UPDATE `char_templates` SET `STR`='54' WHERE (SELECT ClassId) AND (str = '27');
UPDATE `char_templates` SET `STR`='78' WHERE (SELECT ClassId) AND (str = '39');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `con`='54' WHERE (SELECT ClassId) AND (con = '27');
UPDATE `char_templates` SET `con`='72' WHERE (SELECT ClassId) AND (con = '36');
UPDATE `char_templates` SET `con`='50' WHERE (SELECT ClassId) AND (con = '25');
UPDATE `char_templates` SET `con`='64' WHERE (SELECT ClassId) AND (con = '32');
UPDATE `char_templates` SET `con`='48' WHERE (SELECT ClassId) AND (con = '24');
UPDATE `char_templates` SET `con`='94' WHERE (SELECT ClassId) AND (con = '47');
UPDATE `char_templates` SET `con`='62' WHERE (SELECT ClassId) AND (con = '31');
UPDATE `char_templates` SET `con`='90' WHERE (SELECT ClassId) AND (con = '45');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (SELECT ClassId) AND (_int = '21');
UPDATE `char_templates` SET `_int`='82' WHERE (SELECT ClassId) AND (_int = '41');
UPDATE `char_templates` SET `_int`='46' WHERE (SELECT ClassId) AND (_int = '23');
UPDATE `char_templates` SET `_int`='74' WHERE (SELECT ClassId) AND (_int = '37');
UPDATE `char_templates` SET `_int`='50' WHERE (SELECT ClassId) AND (_int = '25');
UPDATE `char_templates` SET `_int`='88' WHERE (SELECT ClassId) AND (_int = '44');
UPDATE `char_templates` SET `_int`='36' WHERE (SELECT ClassId) AND (_int = '18');
UPDATE `char_templates` SET `_int`='62' WHERE (SELECT ClassId) AND (_int = '31');
UPDATE `char_templates` SET `_int`='40' WHERE (SELECT ClassId) AND (_int = '20');
UPDATE `char_templates` SET `men`='52' WHERE (SELECT ClassId) AND (men = '26');
UPDATE `char_templates` SET `men`='80' WHERE (SELECT ClassId) AND (men = '40');
UPDATE `char_templates` SET `men`='74' WHERE (SELECT ClassId) AND (men = '37');
UPDATE `char_templates` SET `men`='54' WHERE (SELECT ClassId) AND (men = '27');
UPDATE `char_templates` SET `men`='84' WHERE (SELECT ClassId) AND (men = '42');
UPDATE `char_templates` SET `men`='78' WHERE (SELECT ClassId) AND (men = '39');
UPDATE `char_templates` SET `men`='50' WHERE (SELECT ClassId) AND (men = '25');
UPDATE `char_templates` SET `STR`='80' WHERE (ClassId = '0') AND (str = '40');
UPDATE `char_templates` SET `con`='86' WHERE (ClassId = '0') AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (ClassId = '0') AND (_int = '21');
UPDATE `char_templates` SET `dex`='60' WHERE (ClassId = '0') AND (dex = '30');
UPDATE `char_templates` SET `wit`='22' WHERE (ClassId = '0') AND (wit = '11');
UPDATE `char_templates` SET `wit`='22' WHERE (SELECT ClassId) AND (wit = '11');
UPDATE `char_templates` SET `wit`='40' WHERE (SELECT ClassId) AND (wit = '20');
UPDATE `char_templates` SET `wit`='28' WHERE (SELECT ClassId) AND (wit = '14');
UPDATE `char_templates` SET `wit`='46' WHERE (SELECT ClassId) AND (wit = '23');
UPDATE `char_templates` SET `wit`='24' WHERE (SELECT ClassId) AND (wit = '12');
UPDATE `char_templates` SET `wit`='38' WHERE (SELECT ClassId) AND (wit = '19');
UPDATE `char_templates` SET `wit`='30' WHERE (SELECT ClassId) AND (wit = '15');
UPDATE `char_templates` SET `wit`='20' WHERE (SELECT ClassId) AND (wit = '10');
UPDATE `char_templates` SET `dex`='60' WHERE (SELECT ClassId) AND (dex = '30');
UPDATE `char_templates` SET `dex`='42' WHERE (SELECT ClassId) AND (dex = '21');
UPDATE `char_templates` SET `dex`='70' WHERE (SELECT ClassId) AND (dex = '35');
UPDATE `char_templates` SET `dex`='48' WHERE (SELECT ClassId) AND (dex = '24');
Изменить стоимость нанесение краски на 5 аден
Добавить все клановые скиллы определенному клану
('ид_клана','370','3','Clan Vitality'),
('ид_клана','371','3','Clan Spirituality'),
('ид_клана','372','3','Clan Essence'),
('ид_клана','373','3','Clan Lifeblood'),
('ид_клана','374','3','Clan Morale'),
('ид_клана','375','3','Clan Clarity'),
('ид_клана','376','3','Clan Might'),
('ид_клана','377','3','Clan Aegis'),
('ид_клана','378','3','Clan Empowerment'),
('ид_клана','379','3','Clan Magic Protection'),
('ид_клана','380','3','Clan Guidance'),
('ид_клана','381','3','Clan Agility'),
('ид_клана','382','3','Clan Withstand-Attack'),
('ид_клана','383','3','Clan Shield Boost'),
('ид_клана','384','3','Clan Cyclonic Resistance'),
('ид_клана','385','3','Clan Magmatic Resistance'),
('ид_клана','386','3','Clan Fortitude'),
('ид_клана','387','3','Clan Freedom'),
('ид_клана','388','3','Clan Vigilance'),
('ид_клана','389','3','Clan March'),
('ид_клана','390','3','Clan Luck'),
('ид_клана','391','1','Clan Imperium');
Установить, чтобы со всех НПЦ (мобов) падало от 1кк до 7кк Аден (данный запрос при рейтах x1. Если у вас рейты на адену, скажем x1000, то следует просто поделить данный запрос на 1000, тогда вы получите теже 1кк-7кк)
UPDATE `droplist` SET `droplist`.`max`=7000000 WHERE `droplist`.`itemId`=57;
Убрать всем монстрам (мобам) статус Агрессивности
UPDATE`npc`SET`aggro`='0'WHERE`type`='L2Monster';
UPDATE`npc`SET`aggro`='0'WHERE`type`='L2RaidBoss';
Установить всем игрокам количество адены, равное 789 аден
Поменять в инвентаре всем игрокам Ancient adena(id=5575) на Adena(id=57)
Сделать автоматический рестарт гейм сервера на 5 часов утра
Убрать из дропа все предметы, кроме адены
Убрать из дропа все, кроме определенных предметов. Например, кроме Адены (ид=57) и Ancient Adena (ид=5575)
Все мобы не агрятся (подходит для RT, если вам не подходит, переделайте название колонки, то есть "agro" и значение (0))
SQL Автоизучение скилов 81+ для Freya сборок
(108, 755, 1, 'Protection of Rune', 0, 82),
(108, 756, 1, 'Protection of Elemental', 0, 82),
(108, 757, 1, 'Protection of Alignment', 0, 82),
(108, 758, 1, 'Fighter''s Will', 0, 81),
(108, 759, 1, 'Archer''s Will', 0, 81),
(108, 767, 1, 'Expose Weak Point', 0, 81),
(108, 766, 1, 'Sixth Sense', 0, 81),
(108, 923, 1, 'Dual Dagger Mastery', 0, 81),
(108, 770, 1, 'Ghost Walking', 0, 83),
(108, 922, 1, 'Hide', 0, 81),
(109, 755, 1, 'Protection of Rune', 0, 82),
(109, 756, 1, 'Protection of Elemental', 0, 82),
(109, 757, 1, 'Protection of Alignment', 0, 82),
(109, 758, 1, 'Fighter''s Will', 0, 81),
(109, 759, 1, 'Archer''s Will', 0, 81),
(109, 924, 1, 'Seven Arrow', 0, 81),
(109, 946, 1, 'Silent Mind', 0, 81),
(109, 773, 1, 'Ghost Piercing', 0, 83),
(112, 755, 1, 'Protection of Rune', 0, 82),
(112, 756, 1, 'Protection of Elemental', 0, 82),
(112, 757, 1, 'Protection of Alignment', 0, 82),
(112, 945, 1, 'Magician''s Will', 0, 81),
(112, 1533, 1, 'Enlightenment', 0, 81),
(112, 1540, 1, 'Turn to Stone', 0, 81),
(112, 1507, 1, 'Lord of Vampire', 0, 83),
(106, 755, 1, 'Protection of Rune', 0, 82),
(106, 756, 1, 'Protection of Elemental', 0, 82),
(106, 757, 1, 'Protection of Alignment', 0, 82),
(106, 758, 1, 'Fighter''s Will', 0, 81),
(106, 759, 1, 'Archer''s Will', 0, 81),
(106, 760, 1, 'Anti Magic Armor', 0, 81),
(106, 766, 1, 'Sixth Sense', 0, 81),
(106, 913, 1, 'Deflect Magic', 0, 81),
(106, 788, 1, 'Pain of Shilen', 0, 83),
(106, 789, 1, 'Spirit of Shilen', 0, 83),
(107, 755, 1, 'Protection of Rune', 0, 82),
(107, 756, 1, 'Protection of Elemental', 0, 82),
(107, 757, 1, 'Protection of Alignment', 0, 82),
(107, 758, 1, 'Fighter''s Will', 0, 81),
(107, 759, 1, 'Archer''s Will', 0, 81),
(107, 766, 1, 'Sixth Sense', 0, 81),
(107, 913, 1, 'Deflect Magic', 0, 81),
(107, 915, 1, 'Dance of Berserker', 0, 83),
(111, 755, 1, 'Protection of Rune', 0, 82),
(111, 756, 1, 'Protection of Elemental', 0, 82),
(111, 757, 1, 'Protection of Alignment', 0, 82),
(111, 945, 1, 'Magician''s Will', 0, 81),
(111, 1496, 1, 'Servitor Barrier', 0, 81),
(111, 1497, 1, 'Excessive Loyalty', 0, 81),
(111, 1498, 1, 'Mutual Response', 0, 81),
(111, 930, 1, 'Spirit of the Demon', 0, 83),
(110, 755, 1, 'Protection of Rune', 0, 82),
(110, 756, 1, 'Protection of Elemental', 0, 82),
(110, 757, 1, 'Protection of Alignment', 0, 82),
(110, 945, 1, 'Magician''s Will', 0, 81),
(110, 1468, 1, 'Star Fall', 0, 81),
(110, 1532, 1, 'Enlightenmentt', 0, 81),
(110, 1494, 1, 'Hurricane Armor', 0, 83),
(117, 755, 1, 'Protection of Rune', 0, 82),
(117, 756, 1, 'Protection of Elemental', 0, 82),
(117, 757, 1, 'Protection of Alignment', 0, 82),
(117, 758, 1, 'Fighter''s Will', 0, 81),
(117, 759, 1, 'Archer''s Will', 0, 81),
(117, 767, 1, 'Expose Weak Point', 0, 81),
(117, 917, 1, 'Champion''s Favor', 0, 81),
(117, 947, 1, 'Lucky Strike', 0, 83),
(118, 755, 1, 'Protection of Rune', 0, 82),
(118, 756, 1, 'Protection of Elemental', 0, 82),
(118, 757, 1, 'Protection of Alignment', 0, 82),
(118, 758, 1, 'Fighter''s Will', 0, 81),
(118, 759, 1, 'Archer''s Will', 0, 81),
(118, 767, 1, 'Expose Weak Point', 0, 81),
(118, 917, 1, 'Champion''s Favor', 0, 81),
(118, 778, 1, 'Golem Armor', 0, 83),
(104, 755, 1, 'Protection of Rune', 0, 82),
(104, 756, 1, 'Protection of Elemental', 0, 82),
(104, 757, 1, 'Protection of Alignment', 0, 82),
(104, 945, 1, 'Magician''s Will', 0, 81),
(104, 1496, 1, 'Servitor Barrier', 0, 81),
(104, 1497, 1, 'Excessive Loyalty', 0, 81),
(104, 1498, 1, 'Mutual Response', 0, 81),
(104, 931, 1, 'Spirit of the Unicorn', 0, 83),
(105, 755, 1, 'Protection of Rune', 0, 82),
(105, 756, 1, 'Protection of Elemental', 0, 82),
(105, 757, 1, 'Protection of Alignment', 0, 82),
(105, 945, 1, 'Magician''s Will', 0, 81),
(105, 1533, 1, 'Enlightenment', 0, 81),
(105, 1540, 1, 'Turn to Stone', 0, 81),
(105, 1506, 1, 'Blessing of Eva', 0, 83),
(99, 755, 1, 'Protection of Rune', 0, 82),
(99, 756, 1, 'Protection of Elemental', 0, 82),
(99, 757, 1, 'Protection of Alignment', 0, 82),
(99, 758, 1, 'Fighter''s Will', 0, 81),
(99, 759, 1, 'Archer''s Will', 0, 81),
(99, 760, 1, 'Anti Magic Armor', 0, 81),
(99, 766, 1, 'Sixth Sense', 0, 81),
(99, 913, 1, 'Deflect Magic', 0, 81),
(99, 786, 1, 'Eva''s Will', 0, 83),
(99, 787, 1, 'Touch of Eva', 0, 83),
(102, 755, 1, 'Protection of Rune', 0, 82),
(102, 756, 1, 'Protection of Elemental', 0, 82),
(102, 757, 1, 'Protection of Alignment', 0, 82),
(102, 758, 1, 'Fighter''s Will', 0, 81),
(102, 759, 1, 'Archer''s Will', 0, 81),
(102, 924, 1, 'Seven Arrow', 0, 81),
(102, 946, 1, 'Silent Mind', 0, 81),
(102, 772, 1, 'Arrow Rain', 0, 83),
(103, 755, 1, 'Protection of Rune', 0, 82),
(103, 756, 1, 'Protection of Elemental', 0, 82),
(103, 757, 1, 'Protection of Alignment', 0, 82),
(103, 945, 1, 'Magician''s Will', 0, 81),
(103, 1468, 1, 'Star Fall', 0, 81),
(103, 1532, 1, 'Enlightenmentt', 0, 81),
(103, 1493, 1, 'Frost Armor', 0, 83),
(100, 755, 1, 'Protection of Rune', 0, 82),
(100, 756, 1, 'Protection of Elemental', 0, 82),
(100, 757, 1, 'Protection of Alignment', 0, 82),
(100, 758, 1, 'Fighter''s Will', 0, 81),
(100, 759, 1, 'Archer''s Will', 0, 81),
(100, 766, 1, 'Sixth Sense', 0, 81),
(100, 913, 1, 'Deflect Magic', 0, 81),
(100, 914, 1, 'Song of Purification', 0, 83),
(101, 755, 1, 'Protection of Rune', 0, 82),
(101, 756, 1, 'Protection of Elemental', 0, 82),
(101, 757, 1, 'Protection of Alignment', 0, 82),
(101, 758, 1, 'Fighter''s Will', 0, 81),
(101, 759, 1, 'Archer''s Will', 0, 81),
(101, 767, 1, 'Expose Weak Point', 0, 81),
(101, 766, 1, 'Sixth Sense', 0, 81),
(101, 923, 1, 'Dual Dagger Mastery', 0, 81),
(101, 769, 1, 'Wind Riding', 0, 83),
(101, 922, 1, 'Hide', 0, 81),
(93, 755, 1, 'Protection of Rune', 0, 82),
(93, 756, 1, 'Protection of Elemental', 0, 82),
(93, 757, 1, 'Protection of Alignment', 0, 82),
(93, 758, 1, 'Fighter''s Will', 0, 81),
(93, 759, 1, 'Archer''s Will', 0, 81),
(93, 767, 1, 'Expose Weak Point', 0, 81),
(93, 766, 1, 'Sixth Sense', 0, 81),
(93, 923, 1, 'Dual Dagger Mastery', 0, 81),
(93, 768, 1, 'Exciting Adventure', 0, 83),
(93, 922, 1, 'Hide', 0, 81),
(96, 755, 1, 'Protection of Rune', 0, 82),
(96, 756, 1, 'Protection of Elemental', 0, 82),
(96, 757, 1, 'Protection of Alignment', 0, 82),
(96, 945, 1, 'Magician''s Will', 0, 81),
(96, 1496, 1, 'Servitor Barrier', 0, 81),
(96, 1497, 1, 'Excessive Loyalty', 0, 81),
(96, 1498, 1, 'Mutual Response', 0, 81),
(96, 929, 1, 'Spirit of the Cat', 0, 83),
(94, 755, 1, 'Protection of Rune', 0, 82),
(94, 756, 1, 'Protection of Elemental', 0, 82),
(94, 757, 1, 'Protection of Alignment', 0, 82),
(94, 945, 1, 'Magician''s Will', 0, 81),
(94, 1467, 1, 'Meteor', 0, 81),
(94, 1532, 1, 'Enlightenmentt', 0, 81),
(94, 1492, 1, 'Flame Armor', 0, 83),
(97, 755, 1, 'Protection of Rune', 0, 82),
(97, 756, 1, 'Protection of Elemental', 0, 82),
(97, 757, 1, 'Protection of Alignment', 0, 82),
(97, 945, 1, 'Magician''s Will', 0, 81),
(97, 1533, 1, 'Enlightenment', 0, 81),
(97, 1540, 1, 'Turn to Stone', 0, 81),
(97, 1498, 1, 'Mutual Response', 0, 81),
(97, 1505, 1, 'Sublime Self-Sacrifice', 0, 83),
(89, 755, 1, 'Protection of Rune', 0, 82),
(89, 756, 1, 'Protection of Elemental', 0, 82),
(89, 757, 1, 'Protection of Alignment', 0, 82),
(89, 758, 1, 'Fighter''s Will', 0, 81),
(89, 759, 1, 'Archer''s Will', 0, 81),
(89, 767, 1, 'Expose Weak Point', 0, 81),
(89, 917, 1, 'Champion''s Favor', 0, 81),
(89, 774, 1, 'Dread Pool', 0, 83),
(88, 755, 1, 'Protection of Rune', 0, 82),
(88, 756, 1, 'Protection of Elemental', 0, 82),
(88, 757, 1, 'Protection of Alignment', 0, 82),
(88, 758, 1, 'Fighter''s Will', 0, 81),
(88, 759, 1, 'Archer''s Will', 0, 81),
(88, 767, 1, 'Expose Weak Point', 0, 81),
(88, 917, 1, 'Champion''s Favor', 0, 81),
(88, 775, 1, 'Weapon Blockade', 0, 83),
(88, 919, 1, 'Maximum Focus Sonic', 0, 83),
(91, 755, 1, 'Protection of Rune', 0, 82),
(91, 756, 1, 'Protection of Elemental', 0, 82),
(91, 757, 1, 'Protection of Alignment', 0, 82),
(91, 758, 1, 'Fighter''s Will', 0, 81),
(91, 759, 1, 'Archer''s Will', 0, 81),
(91, 760, 1, 'Anti Magic Armor', 0, 81),
(91, 766, 1, 'Sixth Sense', 0, 81),
(91, 913, 1, 'Deflect Magic', 0, 81),
(91, 761, 1, 'Seed of Revenge', 0, 83),
(91, 762, 1, 'Insane Crusher', 0, 83),
(91, 763, 1, 'Hell Scream', 0, 83),
(98, 755, 1, 'Protection of Rune', 0, 82),
(98, 756, 1, 'Protection of Elemental', 0, 82),
(98, 757, 1, 'Protection of Alignment', 0, 82),
(98, 945, 1, 'Magician''s Will', 0, 81),
(98, 1533, 1, 'Enlightenment', 0, 81),
(98, 1540, 1, 'Turn to Stone', 0, 81),
(98, 1498, 1, 'Mutual Response', 0, 81),
(98, 1542, 1, 'Counter Critical', 0, 83),
(90, 755, 1, 'Protection of Rune', 0, 82),
(90, 756, 1, 'Protection of Elemental', 0, 82),
(90, 757, 1, 'Protection of Alignment', 0, 82),
(90, 758, 1, 'Fighter''s Will', 0, 81),
(90, 759, 1, 'Archer''s Will', 0, 81),
(90, 760, 1, 'Anti Magic Armor', 0, 81),
(90, 766, 1, 'Sixth Sense', 0, 81),
(90, 913, 1, 'Deflect Magic', 0, 81),
(90, 784, 1, 'Spirit of Phoenix', 0, 83),
(90, 785, 1, 'Flame Icon', 0, 83),
(90, 912, 1, 'Summon Imperial Phoenix', 0, 83),
(92, 755, 1, 'Protection of Rune', 0, 82),
(92, 756, 1, 'Protection of Elemental', 0, 82),
(92, 757, 1, 'Protection of Alignment', 0, 82),
(92, 758, 1, 'Fighter''s Will', 0, 81),
(92, 759, 1, 'Archer''s Will', 0, 81),
(92, 924, 1, 'Seven Arrow', 0, 81),
(92, 946, 1, 'Silent Mind', 0, 81),
(92, 771, 1, 'Flame Hawk', 0, 83),
(95, 755, 1, 'Protection of Rune', 0, 82),
(95, 756, 1, 'Protection of Elemental', 0, 82),
(95, 757, 1, 'Protection of Alignment', 0, 82),
(95, 945, 1, 'Magician''s Will', 0, 81),
(95, 1467, 1, 'Meteor', 0, 81),
(95, 1532, 1, 'Enlightenmentt', 0, 81),
(95, 1495, 1, 'Vampiric Mist', 0, 83),
(133, 755, 1, 'Protection of Rune', 0, 82),
(133, 756, 1, 'Protection of Elemental', 0, 82),
(133, 757, 1, 'Protection of Alignment', 0, 82),
(133, 758, 1, 'Fighter''s Will', 0, 81),
(133, 759, 1, 'Archer''s Will', 0, 81),
(133, 767, 1, 'Expose Weak Point', 0, 81),
(133, 766, 1, 'Sixth Sense', 0, 81),
(133, 1532, 1, 'Enlightenment', 0, 81),
(133, 791, 1, 'Lightning Shock', 0, 83),
(134, 755, 1, 'Protection of Rune', 0, 82),
(134, 756, 1, 'Protection of Elemental', 0, 82),
(134, 757, 1, 'Protection of Alignment', 0, 82),
(134, 758, 1, 'Fighter''s Will', 0, 81),
(134, 759, 1, 'Archer''s Will', 0, 81),
(134, 790, 1, 'Wild Shot', 0, 83),
(131, 755, 1, 'Protection of Rune', 0, 82),
(131, 756, 1, 'Protection of Elemental', 0, 82),
(131, 757, 1, 'Protection of Alignment', 0, 82),
(131, 758, 1, 'Fighter''s Will', 0, 81),
(131, 759, 1, 'Archer''s Will', 0, 81),
(131, 767, 1, 'Expose Weak Point', 0, 81),
(131, 917, 1, 'Champion''s Favor', 0, 81),
(131, 948, 1, 'Eye for Eye', 0, 83),
(132, 755, 1, 'Protection of Rune', 0, 82),
(132, 756, 1, 'Protection of Elemental', 0, 82),
(132, 757, 1, 'Protection of Alignment', 0, 82),
(132, 758, 1, 'Fighter''s Will', 0, 81),
(132, 759, 1, 'Archer''s Will', 0, 81),
(132, 767, 1, 'Expose Weak Point', 0, 81),
(132, 766, 1, 'Sixth Sense', 0, 81),
(132, 1532, 1, 'Enlightenment', 0, 81),
(132, 791, 1, 'Lightning Shock', 0, 83),
(115, 755, 1, 'Protection of Rune', 0, 82),
(115, 756, 1, 'Protection of Elemental', 0, 82),
(115, 757, 1, 'Protection of Alignment', 0, 82),
(115, 945, 1, 'Magician''s Will', 0, 81),
(115, 1533, 1, 'Enlightenment', 0, 81),
(115, 1540, 1, 'Turn to Stone', 0, 81),
(115, 949, 1, 'Onslaught of Pa''agrio', 0, 83),
(115, 1509, 1, 'Seal of Limit', 0, 83),
(116, 755, 1, 'Protection of Rune', 0, 82),
(116, 756, 1, 'Protection of Elemental', 0, 82),
(116, 757, 1, 'Protection of Alignment', 0, 82),
(116, 945, 1, 'Magician''s Will', 0, 81),
(116, 1533, 1, 'Enlightenment', 0, 81),
(116, 1540, 1, 'Turn to Stone', 0, 81),
(116, 1543, 1, 'Great Fury', 0, 83),
(114, 755, 1, 'Protection of Rune', 0, 82),
(114, 756, 1, 'Protection of Elemental', 0, 82),
(114, 757, 1, 'Protection of Alignment', 0, 82),
(114, 758, 1, 'Fighter''s Will', 0, 81),
(114, 759, 1, 'Archer''s Will', 0, 81),
(114, 767, 1, 'Expose Weak Point', 0, 81),
(114, 917, 1, 'Champion''s Favor', 0, 81),
(114, 776, 1, 'Force of Destruction', 0, 83),
(114, 918, 1, 'Maximum Focus Force', 0, 83),
(113, 755, 1, 'Protection of Rune', 0, 82),
(113, 756, 1, 'Protection of Elemental', 0, 82),
(113, 757, 1, 'Protection of Alignment', 0, 82),
(113, 758, 1, 'Fighter''s Will', 0, 81),
(113, 759, 1, 'Archer''s Will', 0, 81),
(113, 767, 1, 'Expose Weak Point', 0, 81),
(113, 917, 1, 'Champion''s Favor', 0, 81),
(113, 777, 1, 'Demolition Impact', 0, 83),
(8, 821, 1, 'Shadow Step', 0, 72),
(23, 821, 1, 'Shadow Step', 0, 72),
(36, 821, 1, 'Shadow Step', 0, 72),
(43, 1500, 1, 'Improved Magic', 390000, 70),
(43, 1502, 1, 'Improved Critical Attack', 390000, 70),
(23, 819, 1, 'Evasion Chance', 0, 74),
(8, 820, 1, 'Evasion Haste', 0, 74),
(36, 818, 1, 'Evasion Counter', 0, 74),
(51, 1536, 1, 'Combat of Pa''agrio', 0, 70),
(51, 1538, 1, 'Condition of Pa''agrio', 0, 72),
(51, 1537, 1, 'Critical of Pa''agrio', 0, 74),
(93, 928, 1, 'Duel Blow', 0, 81),
(101, 928, 1, 'Duel Blow', 0, 81),
(108, 928, 1, 'Duel Blow', 0, 81),
(52, 1517, 1, 'Chant of Combat', 0, 70),
(52, 1535, 1, 'Chant of Movement', 0, 72),
(52, 1518, 1, 'Chant of Critical Attack', 0, 72),
(52, 1519, 1, 'Chant of Blood Awakening', 0, 74),
(17, 1499, 1, 'Improve Combat', 0, 70),
(17, 1501, 1, 'Improve Condition', 0, 70),
(30, 1503, 1, 'Improve Shield Defence', 0, 70),
(30, 1504, 1, 'Improve Movement', 0, 70),
(95, 1541, 1, 'Curse of Desparion', 0, 83),
(100, 764, 1, 'Curse of Desparion', 0, 76);
Сейчас онлайн пользователи:



