Code: Select all
DROP TABLE IF EXISTS `skill_trees`;CREATE TABLE `skill_trees` ( `class_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `skill_id` smallint(5) unsigned NOT NULL DEFAULT '0', `level` tinyint(3) unsigned NOT NULL DEFAULT '0', `name` varchar(40) NOT NULL DEFAULT '', `sp` int(10) unsigned NOT NULL DEFAULT '0', `min_level` tinyint(3) unsigned NOT NULL DEFAULT '0', `learned_by_npc` enum('true','false') NOT NULL DEFAULT 'true', `learned_by_fs` enum('true','false') NOT NULL DEFAULT 'false', PRIMARY KEY (`class_id`,`skill_id`,`level`)); -- GLOSSARY FOR CLASS ID'S -- HUMANS-- 0=Human Fighter | 1=Warrior | 2=Gladiator | 3=Warlord | 4=Human Knight | 5=Paladin-- 6=Dark Avenger | 7=Rogue | 8=Treasure Hunter | 9=Hawkeye | 10=Human Mystic | 11=Wizard-- 12=Sorcerer/ss | 13=Necromancer | 14=Warlock | 15=Cleric | 16=Bishop | 17=Prophet -- ELVES-- 18=Elven Fighter | 19=Elven Knight | 20=Temple Knight | 21=Swordsinger | 22=Elven Scout-- 23=Plains Walker | 24=Silver Ranger | 25=Elven Mystic | 26=Elven Wizard | 27=SpellSinger-- 28=Elemental Summoner | 29=Elven Oracle | 30=Elven Elder -- DARK ELVES-- 31=Dark Fighter | 32=Palus Knight | 33=Shillien Knight | 34=BladeDancer | 35=Assassin-- 36=Abyss Walker | 37=Phantom Ranger | 38=Dark Mystic | 39=Dark Wizard | 40=SpellHowler-- 41=Phantom Summoner | 42=Shillien Oracle | 43=Shillien Elder -- ORCS-- 44=Orc Fighter | 45=Orc Raider | 46=Destroyer | 47=Monk | 48=Tyrant | 49=Orc Mystic | 50=Orc Shaman-- 51=Overlord | 52=Warcryer -- DWARVES-- 53=Dwarven Fighter | 54=Scavenger | 55=Bounty Hunter | 56=Artisan | 57=Warsmith -- HUMANS 3rd Professions-- 88=Duelist | 89=DreadNought | 90=Phoenix Knight | 91=Hell Knight | 92=Sagittarius | 93=Adventurer-- 94=ArchMage | 95=Soultaker | 96=Arcana Lord | 97=Cardinal | 98=HieroPhant -- ELVES 3rd Professions-- 99=Evas Templar | 100=Sword Muse | 101=Wind Rider | 102=Moonlight Sentinel | 103=Mystic Muse-- 104=Elemental Master | 105=Evas Saint -- DARK ELVES 3rd Professions-- 106=Shillien Templar | 107=Spectral Dancer | 108=Ghost Hunter | 109=Ghost Sentinel | 110=Storm Screamer-- 111=Spectral Master | 112=Shillien Saint -- ORCS 3rd Professions-- 113=Titan | 114=Grand Khavatari | 115=Dominator | 116=Doomcryer -- DWARVES 3rd Professions-- 117=Fortune Seeker | 118=Maestro -- KAMAELS-- 123=Male Soldier | 124=Female Soldier | 125=Trooper | 126=Warder | 127=Berserker-- 128=Male Soul Breaker | 129=Female Soul Breaker | 130=Arbalester | 131=Doombringer | 132=Male Soul Hound-- 133=Female Soul Hound | 134=Trickster | 135=Inspector | 136=Judicator -- Human FighterINSERT INTO `skill_trees` VALUES(0,141,1,'Weapon Mastery',160,5,'true','false'),(0,226,1,'Relax',160,5,'true','false'),(0,141,1,'Weapon Mastery',160,5,'true','false'),(0,226,1,'Relax',160,5,'true','false'),(0,142,1,'Armor Mastery',160,5,'true','false'),(0,56,1,'Power Shot',50,5,'true','false'),(0,56,2,'Power Shot',50,5,'true','false'),(0,56,3,'Power Shot',50,5,'true','false'),(0,3,1,'Power Strike',50,5,'true','false'),(0,3,2,'Power Strike',50,5,'true','false'),(0,3,3,'Power Strike',50,5,'true','false'),(0,16,1,'Mortal Blow',50,5,'true','false'),(0,16,2,'Mortal Blow',50,5,'true','false'),(0,16,3,'Mortal Blow',50,5,'true','false'),(0,16,4,'Mortal Blow',370,10,'true','false'),(0,16,5,'Mortal Blow',370,10,'true','false'),(0,16,6,'Mortal Blow',370,10,'true','false'),(0,3,4,'Power Strike',370,10,'true','false'),(0,3,5,'Power Strike',370,10,'true','false'),(0,3,6,'Power Strike',370,10,'true','false'),(0,56,4,'Power Shot',370,10,'true','false'),(0,56,5,'Power Shot',370,10,'true','false'),(0,56,6,'Power Shot',370,10,'true','false'),(0,142,2,'Armor Mastery',550,10,'true','false'),(0,142,3,'Armor Mastery',550,10,'true','false'),(0,141,2,'Weapon Mastery',1100,10,'true','false'),(0,141,3,'Weapon Mastery',4000,15,'true','false'),(0,142,4,'Armor Mastery',2000,15,'true','false'),(0,142,5,'Armor Mastery',2000,15,'true','false'),(0,56,7,'Power Shot',1300,15,'true','false'),(0,56,8,'Power Shot',1300,15,'true','false'),(0,56,9,'Power Shot',1300,15,'true','false'),(0,3,7,'Power Strike',1300,15,'true','false'),(0,3,8,'Power Strike',1300,15,'true','false'),(0,3,9,'Power Strike',1300,15,'true','false'),(0,16,7,'Mortal Blow',1300,15,'true','false'),(0,16,8,'Mortal Blow',1300,15,'true','false'),(0,16,9,'Mortal Blow',1300,15,'true','false');
