l2jnews создай свой сервер Lineage 2 сборки,база знаний

Скачать Counter-Strike 1.6

Чат

Популярные файлы

Статистика сайта

Сейчас онлайн пользователи:

Сборник полезных запросов mySQL для вашего собственного сервера л2

Инструкция для новичков по выполнению полезных sql запросов

Установить Шанс дропа Адены на параметр 100% (1000000=100%) вместо стандартных 70%

Установить цены на продажу всех предметов, всего оружия и всей брони по 0 Аден

Для заточки скиллов не требуется Опыть и SP

Удалить скил пенальти (Great Penalty)

Увеличить статы (Str,Int,Dex,Wit,Men,Con) всех персонажей в 2 раза

UPDATE `char_templates` SET `STR`='80' WHERE (SELECT ClassId) AND (str = '40');
UPDATE `char_templates` SET `STR`='44' WHERE (SELECT ClassId) AND (str = '22');
UPDATE `char_templates` SET `STR`='72' WHERE (SELECT ClassId) AND (str = '36');
UPDATE `char_templates` SET `STR`='42' WHERE (SELECT ClassId) AND (str = '21');
UPDATE `char_templates` SET `STR`='46' WHERE (SELECT ClassId) AND (str = '23');
UPDATE `char_templates` SET `STR`='54' WHERE (SELECT ClassId) AND (str = '27');
UPDATE `char_templates` SET `STR`='78' WHERE (SELECT ClassId) AND (str = '39');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `con`='54' WHERE (SELECT ClassId) AND (con = '27');
UPDATE `char_templates` SET `con`='72' WHERE (SELECT ClassId) AND (con = '36');
UPDATE `char_templates` SET `con`='50' WHERE (SELECT ClassId) AND (con = '25');
UPDATE `char_templates` SET `con`='64' WHERE (SELECT ClassId) AND (con = '32');
UPDATE `char_templates` SET `con`='48' WHERE (SELECT ClassId) AND (con = '24');
UPDATE `char_templates` SET `con`='94' WHERE (SELECT ClassId) AND (con = '47');
UPDATE `char_templates` SET `con`='62' WHERE (SELECT ClassId) AND (con = '31');
UPDATE `char_templates` SET `con`='90' WHERE (SELECT ClassId) AND (con = '45');
UPDATE `char_templates` SET `con`='86' WHERE (SELECT ClassId) AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (SELECT ClassId) AND (_int = '21');
UPDATE `char_templates` SET `_int`='82' WHERE (SELECT ClassId) AND (_int = '41');
UPDATE `char_templates` SET `_int`='46' WHERE (SELECT ClassId) AND (_int = '23');
UPDATE `char_templates` SET `_int`='74' WHERE (SELECT ClassId) AND (_int = '37');
UPDATE `char_templates` SET `_int`='50' WHERE (SELECT ClassId) AND (_int = '25');
UPDATE `char_templates` SET `_int`='88' WHERE (SELECT ClassId) AND (_int = '44');
UPDATE `char_templates` SET `_int`='36' WHERE (SELECT ClassId) AND (_int = '18');
UPDATE `char_templates` SET `_int`='62' WHERE (SELECT ClassId) AND (_int = '31');
UPDATE `char_templates` SET `_int`='40' WHERE (SELECT ClassId) AND (_int = '20');
UPDATE `char_templates` SET `men`='52' WHERE (SELECT ClassId) AND (men = '26');
UPDATE `char_templates` SET `men`='80' WHERE (SELECT ClassId) AND (men = '40');
UPDATE `char_templates` SET `men`='74' WHERE (SELECT ClassId) AND (men = '37');
UPDATE `char_templates` SET `men`='54' WHERE (SELECT ClassId) AND (men = '27');
UPDATE `char_templates` SET `men`='84' WHERE (SELECT ClassId) AND (men = '42');
UPDATE `char_templates` SET `men`='78' WHERE (SELECT ClassId) AND (men = '39');
UPDATE `char_templates` SET `men`='50' WHERE (SELECT ClassId) AND (men = '25');
UPDATE `char_templates` SET `STR`='80' WHERE (ClassId = '0') AND (str = '40');
UPDATE `char_templates` SET `con`='86' WHERE (ClassId = '0') AND (con = '43');
UPDATE `char_templates` SET `_int`='42' WHERE (ClassId = '0') AND (_int = '21');
UPDATE `char_templates` SET `dex`='60' WHERE (ClassId = '0') AND (dex = '30');
UPDATE `char_templates` SET `wit`='22' WHERE (ClassId = '0') AND (wit = '11');
UPDATE `char_templates` SET `wit`='22' WHERE (SELECT ClassId) AND (wit = '11');
UPDATE `char_templates` SET `wit`='40' WHERE (SELECT ClassId) AND (wit = '20');
UPDATE `char_templates` SET `wit`='28' WHERE (SELECT ClassId) AND (wit = '14');
UPDATE `char_templates` SET `wit`='46' WHERE (SELECT ClassId) AND (wit = '23');
UPDATE `char_templates` SET `wit`='24' WHERE (SELECT ClassId) AND (wit = '12');
UPDATE `char_templates` SET `wit`='38' WHERE (SELECT ClassId) AND (wit = '19');
UPDATE `char_templates` SET `wit`='30' WHERE (SELECT ClassId) AND (wit = '15');
UPDATE `char_templates` SET `wit`='20' WHERE (SELECT ClassId) AND (wit = '10');
UPDATE `char_templates` SET `dex`='60' WHERE (SELECT ClassId) AND (dex = '30');
UPDATE `char_templates` SET `dex`='42' WHERE (SELECT ClassId) AND (dex = '21');
UPDATE `char_templates` SET `dex`='70' WHERE (SELECT ClassId) AND (dex = '35');
UPDATE `char_templates` SET `dex`='48' WHERE (SELECT ClassId) AND (dex = '24');

Изменить стоимость нанесение краски на 5 аден

Добавить все клановые скиллы определенному клану

Установить, чтобы со всех НПЦ (мобов) падало от 1кк до 7кк Аден (данный запрос при рейтах x1. Если у вас рейты на адену, скажем x1000, то следует просто поделить данный запрос на 1000, тогда вы получите теже 1кк-7кк)

Убрать всем монстрам (мобам) статус Агрессивности

Установить всем игрокам количество адены, равное 789 аден

Поменять в инвентаре всем игрокам Ancient adena(id=5575) на Adena(id=57)

Сделать автоматический рестарт гейм сервера на 5 часов утра

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

Убрать из дропа все, кроме определенных предметов. Например, кроме Адены (ид=57) и Ancient Adena (ид=5575)

Все мобы не агрятся (подходит для RT, если вам не подходит, переделайте название колонки, то есть "agro" и значение (0))

SQL Автоизучение скилов 81+ для Freya сборок

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

Следуйщая страница с полезными sql запросами

Администрация не несёт ответственности за содержащие файлы на данном портале.
Все материалы на сайте принадлежат исключительно их владельцам!
Главный администратор сайта TheNega |

| Sitemap | Sitemap-Forum | RSS лента