[Poradnik] Auto Learn Skilli 81+

Pokażę jak zrobić Auto Learn Forgotten Scroll

1. Wchodzimy w Navicacie do tabeli ''etcitem'' i odnajdujemy danego scrolla, na samym końcu znajdziemy ID statystyk danego Scrolla
2. Wchodzimy do GameServer\data\stats\skills i odnajdujemy plik xml w którym zawiera się ID z ostatniej kolumny z tabeli "etcitem" (jeśli jest to np. 2655 to edytujemy plik 2600-2699xml.
3. Wewnątrz pliku xml znajdziemy ID i odszukamy wpisu

Kod: [Zaznacz]

<set name="learnSkillId" val="XXXX"/>
gdzie XXXX to ID skill'a który dodawany jest do postaci po wyuczeniu Scroll'a

Gdy mamy już ID skill'a, wchodzimy do tabeli "skill_trees". Będziemy teraz musieli przypisać odnaleziony skill do wybranej przez nas klasy:
- wybieramy "class_id" (czyli ID klasy do której będzie dodany nasz skill'. Jeśli nie znamy ID klasy, możemy podejrzeć sobie ją w tabeli "classID"),
- wybieramy "skill_id" (czyli ID skilla który odnaleźliśmy, a który jest dodawany przez Scroll)
- wybieramy "lvl" (czyli lvl skilla który będzie wyuczony)
- wybieramy "name" (czyli nazwę)
- wybieramy "sp" (czyli SP niezbędne do wyczuenia skill'a)
- wybieramy "min_lvl" (czyli lvl który bedzie musiał posiadać gracz by wyuczyć się skill'a)

To tyle.

Wrzucę gotowy Skrypcik

Kod: [Zaznacz]

INSERT INTO `skill_trees` (`class_id`, `skill_id`, `level`, `name`, `sp`, `min_level`) VALUES
# DUELIST
(88, 759, 1, 'Archers Will', 0, 81),
(88, 767, 1, 'Expose Weak Point', 0, 81),
(88, 758, 1, 'Fighter Will', 0, 81),
(88, 917, 1, 'Final Secret', 0, 81),
(88, 757, 1, 'Protection of Alignment', 0, 82),
(88, 756, 1, 'Protection of Elemental', 0, 82),
(88, 755, 1, 'Protection of Rune', 0, 82),
(88, 919, 1, 'Maximum Focus Sonic', 0, 83),
(88, 775, 1, 'Weapon Blockade', 0, 83),
# DREADNOUGHT
(89, 759, 1, 'Archers Will', 0, 81),
(89, 767, 1, 'Expose Weak Point', 0, 81),
(89, 758, 1, 'Fighter Will', 0, 81),
(89, 917, 1, 'Final Secret', 0, 81),
(89, 757, 1, 'Protection of Alignment', 0, 82),
(89, 756, 1, 'Protection of Elemental', 0, 82),
(89, 755, 1, 'Protection of Rune', 0, 82),
(89, 774, 1, 'Dread Pool', 0, 83),
# PHOENIX KNIGHT
(90, 759, 1, 'Archers Will', 0, 81),
(90, 760, 1, 'Anti Magic Armor', 0, 81),
(90, 758, 1, 'Fighter Will', 0, 81),
(90, 913, 1, 'Deflect Magic', 0, 81),
(90, 766, 1, 'Sixth Sense', 0, 81),
(90, 757, 1, 'Protection of Alignment', 0, 82),
(90, 756, 1, 'Protection of Elemental', 0, 82),
(90, 755, 1, 'Protection of Rune', 0, 82),
(90, 785, 1, 'Flame Icon', 0, 83),
(90, 784, 1, 'Spirit of Phoenix', 0, 83),
(90, 912, 1, 'Summon Imperial Phoenix', 0, 83),
# HELL KNIGHT
(91, 759, 1, 'Archers Will', 0, 81),
(91, 760, 1, 'Anti Magic Armor', 0, 81),
(91, 758, 1, 'Fighter Will', 0, 81),
(91, 913, 1, 'Deflect Magic', 0, 81),
(91, 766, 1, 'Sixth Sense', 0, 81),
(91, 757, 1, 'Protection of Alignment', 0, 82),
(91, 756, 1, 'Protection of Elemental', 0, 82),
(91, 755, 1, 'Protection of Rune', 0, 82),
(91, 763, 1, 'Hell Scream', 0, 83),
(91, 761, 1, 'Seed of Revenge', 0, 83),
(91, 762, 1, 'Insane Crusher', 0, 83),
# TREASURE HUNTER / ADVENTURER
(8, 821, 1, 'Shadow Step', 0, 72),
(8, 820, 1, 'Evasion Haste', 0, 74),
(93, 759, 1, 'Archers Will', 0, 81),
(93, 758, 1, 'Fighter Will', 0, 81),
(93, 767, 1, 'Expose Weak Point', 0, 81),
(93, 766, 1, 'Sixth Sense', 0, 81),
(93, 922, 1, 'Hide', 0, 81),
(93, 923, 1, 'Dual Dagger Mastery', 0, 81),
(93, 757, 1, 'Protection of Alignment', 0, 82),
(93, 756, 1, 'Protection of Elemental', 0, 82),
(93, 755, 1, 'Protection of Rune', 0, 82),
(93, 768, 1, 'Exciting Adventure', 0, 83),
# SAGITTARIUS
(92, 759, 1, 'Archers Will', 0, 81),
(92, 758, 1, 'Fighter Will', 0, 81),
(92, 924, 1, 'Seven Arrow', 0, 81),
(92, 946, 1, 'Silent Mind', 0, 81),
(92, 757, 1, 'Protection of Alignment', 0, 82),
(92, 756, 1, 'Protection of Elemental', 0, 82),
(92, 755, 1, 'Protection of Rune', 0, 82),
(92, 771, 1, 'Flame Hawk', 0, 83),
# ARCHMAGE
(94, 1532, 1, 'Enlightenment', 0, 81),
(94, 945, 1, 'Magicians Will', 0, 81),
(94, 1467, 1, 'Meteor', 0, 81),
(94, 757, 1, 'Protection of Alignment', 0, 82),
(94, 756, 1, 'Protection of Elemental', 0, 82),
(94, 755, 1, 'Protection of Rune', 0, 82),
(94, 1492, 1, 'Flame Armor', 0, 83),
# SOULTAKER
(95, 1532, 1, 'Enlightenment', 0, 81),
(95, 945, 1, 'Magicians Will', 0, 81),
(95, 1467, 1, 'Meteor', 0, 81),
(95, 757, 1, 'Protection of Alignment', 0, 82),
(95, 756, 1, 'Protection of Elemental', 0, 82),
(95, 755, 1, 'Protection of Rune', 0, 82),
(95, 1495, 1, 'Vampiric Mist', 0, 83),
#ARCANA LORD
(96, 1497, 1, 'Excessive Loyalty', 0, 81),
(96, 945, 1, 'Magicians Will', 0, 81),
(96, 1498, 1, 'Mutual Response', 0, 81),
(96, 1496, 1, 'Servitor Barrier', 0, 81),
(96, 757, 1, 'Protection of Alignment', 0, 82),
(96, 756, 1, 'Protection of Elemental', 0, 82),
(96, 755, 1, 'Protection of Rune', 0, 82),
(95, 929, 1, 'Spirit of the Cat', 0, 83),
# CARDINAL
(97, 1533, 1, 'Enlightenment', 0, 81),
(97, 945, 1, 'Magicians Will', 0, 81),
(97, 1540, 1, 'Turn to Stone', 0, 81),
(97, 757, 1, 'Protection of Alignment', 0, 82),
(97, 756, 1, 'Protection of Elemental', 0, 82),
(97, 755, 1, 'Protection of Rune', 0, 82),
(97, 1505, 1, 'Sublime Self-Sacrifice', 0, 83),
# PROPHET / HIEROPHANT
(17, 1499, 1, 'Improved Combat', 0, 70),
(17, 1501, 1, 'improved Condition', 0, 70),
(98, 1533, 1, 'Enlightenment', 0, 81),
(98, 945, 1, 'Magicians Will', 0, 81),
(98, 1540, 1, 'Turn to Stone', 0, 81),
(98, 757, 1, 'Protection of Alignment', 0, 82),
(98, 756, 1, 'Protection of Elemental', 0, 82),
(98, 755, 1, 'Protection of Rune', 0, 82),
(98, 1542, 1, 'Counter Critical', 0, 83),
# EVAS TEMPLAR
(99, 759, 1, 'Archers Will', 0, 81),
(99, 760, 1, 'Anti Magic Armor', 0, 81),
(99, 758, 1, 'Fighter Will', 0, 81),
(99, 913, 1, 'Deflect Magic', 0, 81),
(99, 766, 1, 'Sixth Sense', 0, 81),
(99, 757, 1, 'Protection of Alignment', 0, 82),
(99, 756, 1, 'Protection of Elemental', 0, 82),
(99, 755, 1, 'Protection of Rune', 0, 82),
(99, 786, 1, 'Evas Will', 0, 83),
(99, 787, 1, 'Touch of Eva', 0, 83),
# SWORDMUSE
(100, 759, 1, 'Archers Will', 0, 81),
(100, 758, 1, 'Fighter Will', 0, 81),
(100, 913, 1, 'Deflect Magic', 0, 81),
(100, 766, 1, 'Sixth Sense', 0, 81),
(100, 757, 1, 'Protection of Alignment', 0, 82),
(100, 756, 1, 'Protection of Elemental', 0, 82),
(100, 755, 1, 'Protection of Rune', 0, 82),
(100, 914, 1, 'Song of Purification', 0, 83),
# PLAINSWALKER / WIND RAIDER
(23, 821, 1, 'Shadow Step', 0, 72),
(23, 819, 1, 'Evasion Chance', 0, 74),
(101, 759, 1, 'Archers Will', 0, 81),
(101, 758, 1, 'Fighter Will', 0, 81),
(101, 767, 1, 'Expose Weak Point', 0, 81),
(101, 766, 1, 'Sixth Sense', 0, 81),
(101, 922, 1, 'Hide', 0, 81),
(101, 923, 1, 'Dual Dagger Mastery', 0, 81),
(101, 757, 1, 'Protection of Alignment', 0, 82),
(101, 756, 1, 'Protection of Elemental', 0, 82),
(101, 755, 1, 'Protection of Rune', 0, 82),
(101, 769, 1, 'Wind Riding', 0, 83),
# MOONLIGHT SENTINEL
(102, 759, 1, 'Archers Will', 0, 81),
(102, 758, 1, 'Fighter Will', 0, 81),
(102, 924, 1, 'Seven Arrow', 0, 81),
(102, 946, 1, 'Silent Mind', 0, 81),
(102, 757, 1, 'Protection of Alignment', 0, 82),
(102, 756, 1, 'Protection of Elemental', 0, 82),
(102, 755, 1, 'Protection of Rune', 0, 82),
(102, 772, 1, 'Arrow Rain', 0, 83),
# MYSTIC MUSE
(103, 1532, 1, 'Enlightenment', 0, 81),
(103, 945, 1, 'Magicians Will', 0, 81),
(103, 1468, 1, 'Star Fall', 0, 81),
(103, 757, 1, 'Protection of Alignment', 0, 82),
(103, 756, 1, 'Protection of Elemental', 0, 82),
(103, 755, 1, 'Protection of Rune', 0, 82),
(103, 1493, 1, 'Frost Armor', 0, 83),
# ELEMENTAL MASTER
(104, 1497, 1, 'Excessive Loyalty', 0, 81),
(104, 945, 1, 'Magicians Will', 0, 81),
(104, 1498, 1, 'Mutual Response', 0, 81),
(104, 1496, 1, 'Servitor Barrier', 0, 81),
(104, 757, 1, 'Protection of Alignment', 0, 82),
(104, 756, 1, 'Protection of Elemental', 0, 82),
(104, 755, 1, 'Protection of Rune', 0, 82),
(104, 931, 1, 'Spirit of the Unicorn', 0, 83),
# ELVEN ELDER / EVA SAINT
(30, 1504, 1, 'Improved Movement', 0, 70),
(30, 1503, 1, 'improved Shield Defense', 0, 70),
(105, 1533, 1, 'Enlightenment', 0, 81),
(105, 945, 1, 'Magicians Will', 0, 81),
(105, 1540, 1, 'Turn to Stone', 0, 81),
(105, 757, 1, 'Protection of Alignment', 0, 82),
(105, 756, 1, 'Protection of Elemental', 0, 82),
(105, 755, 1, 'Protection of Rune', 0, 82),
(105, 1506, 1, 'Blessing of Eva', 0, 83),
# SHILLIEN TEMPLAR
(106, 759, 1, 'Archers Will', 0, 81),
(106, 760, 1, 'Anti Magic Armor', 0, 81),
(106, 758, 1, 'Fighter Will', 0, 81),
(106, 913, 1, 'Deflect Magic', 0, 81),
(106, 766, 1, 'Sixth Sense', 0, 81),
(106, 757, 1, 'Protection of Alignment', 0, 82),
(106, 756, 1, 'Protection of Elemental', 0, 82),
(106, 755, 1, 'Protection of Rune', 0, 82),
(106, 788, 1, 'Pain of Shilen', 0, 83),
(106, 789, 1, 'Spirit of Shilen', 0, 83),
# SPECTRAL DANCER
(107, 759, 1, 'Archers Will', 0, 81),
(107, 758, 1, 'Fighter Will', 0, 81),
(107, 913, 1, 'Deflect Magic', 0, 81),
(107, 766, 1, 'Sixth Sense', 0, 81),
(107, 757, 1, 'Protection of Alignment', 0, 82),
(107, 756, 1, 'Protection of Elemental', 0, 82),
(107, 755, 1, 'Protection of Rune', 0, 82),
(107, 915, 1, 'Dance of Berserker', 0, 83),
# ABISS WALKER / GHOST HUNTER
(36, 821, 1, 'Shadow Step', 0, 72),
(36, 818, 1, 'Evasion COUNTER', 0, 74),
(108, 759, 1, 'Archers Will', 0, 81),
(108, 758, 1, 'Fighter Will', 0, 81),
(108, 767, 1, 'Expose Weak Point', 0, 81),
(108, 766, 1, 'Sixth Sense', 0, 81),
(108, 922, 1, 'Hide', 0, 81),
(108, 923, 1, 'Dual Dagger Mastery', 0, 81),
(108, 757, 1, 'Protection of Alignment', 0, 82),
(108, 756, 1, 'Protection of Elemental', 0, 82),
(108, 755, 1, 'Protection of Rune', 0, 82),
(108, 770, 1, 'Ghost Walking', 0, 83),
# GHOST SENTINEL
(109, 759, 1, 'Archers Will', 0, 81),
(109, 758, 1, 'Fighter Will', 0, 81),
(109, 924, 1, 'Seven Arrow', 0, 81),
(109, 946, 1, 'Silent Mind', 0, 81),
(109, 757, 1, 'Protection of Alignment', 0, 82),
(109, 756, 1, 'Protection of Elemental', 0, 82),
(109, 755, 1, 'Protection of Rune', 0, 82),
(109, 773, 1, 'Ghost Piercing', 0, 83),
# STORM SCREAMER
(110, 1532, 1, 'Enlightenment', 0, 81),
(110, 945, 1, 'Magicians Will', 0, 81),
(110, 1468, 1, 'Star fall', 0, 81),
(110, 757, 1, 'Protection of Alignment', 0, 82),
(110, 756, 1, 'Protection of Elemental', 0, 82),
(110, 755, 1, 'Protection of Rune', 0, 82),
(110, 1494, 1, 'Hurricane Armor', 0, 83),
# SPECTRAL MASTER
(111, 1497, 1, 'Excessive Loyalty', 0, 81),
(111, 945, 1, 'Magicians Will', 0, 81),
(111, 1498, 1, 'Mutual Response', 0, 81),
(111, 1496, 1, 'Servitor Barrier', 0, 81),
(111, 757, 1, 'Protection of Alignment', 0, 82),
(111, 756, 1, 'Protection of Elemental', 0, 82),
(111, 755, 1, 'Protection of Rune', 0, 82),
(111, 930, 1, 'Spirit of the Demon', 0, 83),
# SHILLIEN ELDER / SHILLIEN SAINT
(43, 1502, 1, 'Improved Critical Attack', 0, 70),
(43, 1500, 1, 'improved Magic', 0, 70),
(112, 1533, 1, 'Enlightenment', 0, 81),
(112, 945, 1, 'Magicians Will', 0, 81),
(112, 1540, 1, 'Turn to Stone', 0, 81),
(112, 757, 1, 'Protection of Alignment', 0, 82),
(112, 756, 1, 'Protection of Elemental', 0, 82),
(112, 755, 1, 'Protection of Rune', 0, 82),
(112, 1507, 1, 'Lord of Vampire', 0, 83),
# TITAN
(113, 759, 1, 'Archers Will', 0, 81),
(113, 767, 1, 'Expose Weak Point', 0, 81),
(113, 758, 1, 'Fighter Will', 0, 81),
(113, 917, 1, 'Final Secret', 0, 81),
(113, 757, 1, 'Protection of Alignment', 0, 82),
(113, 756, 1, 'Protection of Elemental', 0, 82),
(113, 755, 1, 'Protection of Rune', 0, 82),
(113, 777, 1, 'Demolition Impact', 0, 83),
# GRAND KHAVATARI
(114, 759, 1, 'Archers Will', 0, 81),
(114, 767, 1, 'Expose Weak Point', 0, 81),
(114, 758, 1, 'Fighter Will', 0, 81),
(114, 917, 1, 'Final Secret', 0, 81),
(114, 757, 1, 'Protection of Alignment', 0, 82),
(114, 756, 1, 'Protection of Elemental', 0, 82),
(114, 755, 1, 'Protection of Rune', 0, 82),
(114, 776, 1, 'Force of Destruction', 0, 83),
(114, 918, 1, 'Maximum Focus Force', 0, 83),
# OVERLORD / DOMINATOR
(51, 1536, 1, 'Combat of Paagrio', 0, 70),
(51, 1538, 1, 'Condition of Paagrio', 0, 72),
(51, 1537, 1, 'Critical of Paagrio', 0, 74),
(115, 1533, 1, 'Enlightenment', 0, 81),
(115, 945, 1, 'Magicians Will', 0, 81),
(115, 1540, 1, 'Turn to Stone', 0, 81),
(115, 757, 1, 'Protection of Alignment', 0, 82),
(115, 756, 1, 'Protection of Elemental', 0, 82),
(115, 755, 1, 'Protection of Rune', 0, 82),
(115, 949, 1, 'Onslaught of Paagrio', 0, 83),
(115, 1509, 1, 'Seal of Limit', 0, 83),
# WARCRYER / DOOMCRYER
(52, 1517, 1, 'Chant of Combat', 0, 70),
(52, 1518, 1, 'Chant of Critical Attack', 0, 72),
(52, 1535, 1, 'Chant of Movement', 0, 72),
(52, 1519, 1, 'Chant of Blood Awakening', 0, 74),
(116, 1533, 1, 'Enlightenment', 0, 81),
(116, 945, 1, 'Magicians Will', 0, 81),
(116, 1540, 1, 'Turn to Stone', 0, 81),
(116, 757, 1, 'Protection of Alignment', 0, 82),
(116, 756, 1, 'Protection of Elemental', 0, 82),
(116, 755, 1, 'Protection of Rune', 0, 82),
(116, 1543, 1, 'Great Fury', 0, 83),
# FORTUNE SEEKER
(117, 759, 1, 'Archers Will', 0, 81),
(117, 767, 1, 'Expose Weak Point', 0, 81),
(117, 758, 1, 'Fighter Will', 0, 81),
(117, 917, 1, 'Final Secret', 0, 81),
(117, 757, 1, 'Protection of Alignment', 0, 82),
(117, 756, 1, 'Protection of Elemental', 0, 82),
(117, 755, 1, 'Protection of Rune', 0, 82),
(117, 947, 1, 'Lucky Strike', 0, 83),
# MAESTRO
(118, 759, 1, 'Archers Will', 0, 81),
(118, 767, 1, 'Expose Weak Point', 0, 81),
(118, 758, 1, 'Fighter Will', 0, 81),
(118, 917, 1, 'Final Secret', 0, 81),
(118, 757, 1, 'Protection of Alignment', 0, 82),
(118, 756, 1, 'Protection of Elemental', 0, 82),
(118, 755, 1, 'Protection of Rune', 0, 82),
(118, 778, 1, 'Golem Armor', 0, 83),
# DOOMBRINGER
(131, 759, 1, 'Archers Will', 0, 81),
(131, 767, 1, 'Expose Weak Point', 0, 81),
(131, 758, 1, 'Fighter Will', 0, 81),
(131, 917, 1, 'Final Secret', 0, 81),
(131, 757, 1, 'Protection of Alignment', 0, 82),
(131, 756, 1, 'Protection of Elemental', 0, 82),
(131, 755, 1, 'Protection of Rune', 0, 82),
(131, 948, 1, 'Eye for Eye', 0, 83),
# SOUL HOUND
(132, 759, 1, 'Archers Will', 0, 81),
(132, 758, 1, 'Fighter 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, 757, 1, 'Protection of Alignment', 0, 82),
(132, 756, 1, 'Protection of Elemental', 0, 82),
(132, 755, 1, 'Protection of Rune', 0, 82),
(132, 791, 1, 'Lightning Shock', 0, 83),
# SOUL HOUND
(133, 759, 1, 'Archers Will', 0, 81),
(133, 758, 1, 'Fighter 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, 757, 1, 'Protection of Alignment', 0, 82),
(133, 756, 1, 'Protection of Elemental', 0, 82),
(133, 755, 1, 'Protection of Rune', 0, 82),
(133, 791, 1, 'Lightning Shock', 0, 83),
# TRICKSTER
(134, 759, 1, 'Archers Will', 0, 81),
(134, 758, 1, 'Fighter Will', 0, 81),
(134, 757, 1, 'Protection of Alignment', 0, 82),
(134, 756, 1, 'Protection of Elemental', 0, 82),
(134, 755, 1, 'Protection of Rune', 0, 82),
(134, 790, 1, 'Wild Shot', 0, 83);