l2j-server-datapack/sql/pledge_skill_trees.sql

DROP TABLE IF EXISTS `pledge_skill_trees`;
CREATE TABLE IF NOT EXISTS `pledge_skill_trees` (
  `skill_id` int(11) default NULL,
  `level` int(11) default NULL,
  `name` varchar(25) default NULL,
  `clan_lvl` int(11) default NULL,
  `Description` varchar(255) default NULL,
  `repCost` int(11) default NULL,
  `itemId` int(11) default NULL
);

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `pledge_skill_trees` VALUES
(370,1,'Clan Vitality',5,'Increases clan members Max HP. It only effects those who are of an Heir class or higher',500,8166),
(370,2,'Clan Vitality',5,'Increases clan members Max HP. It only effects those who are of an Heir class or higher',500,8166),
(370,3,'Clan Vitality',5,'Increases clan members Max HP. It only effects those who are of an Heir class or higher',500,8166),
(371,1,'Clan Spirituality',6,'Increases clan members Max CP. It only effects those who are of a Baron class or higher',800,8169),
(371,2,'Clan Spirituality',6,'Increases clan members Max CP. It only effects those who are of a Baron class or higher',800,8169),
(371,3,'Clan Spirituality',6,'Increases clan members Max CP. It only effects those who are of a Baron class or higher',800,8169),
(372,1,'Clan Essence',8,'Increases clan members Max MP. It only effects those who are of a Viscount class or higher',3900,8172),
(372,2,'Clan Essence',8,'Increases clan members Max MP. It only effects those who are of a Viscount class or higher',3900,8172),
(372,3,'Clan Essence',8,'Increases clan members Max MP. It only effects those who are of a Viscount class or higher',3900,8172),
(373,1,'Clan Lifeblood',5,'Increases the clan members HP regeneration. Only affects Heir class and above',500,8166),
(373,2,'Clan Lifeblood',5,'Increases the clan members HP regeneration. Only affects Heir class and above',500,8166),
(373,3,'Clan Lifeblood',5,'Increases the clan members HP regeneration. Only affects Heir class and above',500,8166),
(374,1,'Clan Morale',6,'Increases the clan members CP regeneration. Only affects Elder class and above',900,8169),
(374,2,'Clan Morale',6,'Increases the clan members CP regeneration. Only affects Elder class and above',900,8169),
(374,3,'Clan Morale',6,'Increases the clan members CP regeneration. Only affects Elder class and above',900,8169),
(375,1,'Clan Clarity',8,'Increases the clan members MP regeneration. Only affects Viscount class and above',3900,8172),
(375,2,'Clan Clarity',8,'Increases the clan members MP regeneration. Only affects Viscount class and above',3900,8172),
(375,3,'Clan Clarity',8,'Increases the clan members MP regeneration. Only affects Viscount class and above',3900,8172),
(376,1,'Clan Might',6,'Increases the clan members P. Atk. Only affects Knight class and above',1000,8163),
(376,2,'Clan Might',6,'Increases the clan members P. Atk. Only affects Knight class and above',1000,8163),
(376,3,'Clan Might',6,'Increases the clan members P. Atk. Only affects Knight class and above',1000,8163),
(377,1,'Clan Aegis',6,'Increases clan members P. Def. It only effects those who are of a Knight class or higher',1000,8166),
(377,2,'Clan Aegis',6,'Increases clan members P. Def. It only effects those who are of a Knight class or higher',1000,8166),
(377,3,'Clan Aegis',6,'Increases clan members P. Def. It only effects those who are of a Knight class or higher',1000,8166),
(378,1,'Clan Empowerment',8,'Increases clan members M. Atk. It only effects those who are of a Viscount class or higher',3900,8172),
(378,2,'Clan Empowerment',8,'Increases clan members M. Atk. It only effects those who are of a Viscount class or higher',3900,8172),
(378,3,'Clan Empowerment',8,'Increases clan members M. Atk. It only effects those who are of a Viscount class or higher',3900,8172),
(379,1,'Clan Magic Protection',5,'Increases clan members M. Def. It only effects those who are of an Heir class or higher',500,8163),
(379,2,'Clan Magic Protection',5,'Increases clan members M. Def. It only effects those who are of an Heir class or higher',500,8163),
(379,3,'Clan Magic Protection',5,'Increases clan members M. Def. It only effects those who are of an Heir class or higher',500,8163),
(380,1,'Clan Guidance',7,'Increases the clan members Accuracy. Only affects Baron class and above',1900,8160),
(380,2,'Clan Guidance',7,'Increases the clan members Accuracy. Only affects Baron class and above',1900,8160),
(380,3,'Clan Guidance',7,'Increases the clan members Accuracy. Only affects Baron class and above',1900,8160),
(381,1,'Clan Agility',8,'Increases the clan members Evasion. Only affects Baron class and above',4000,8160),
(381,2,'Clan Agility',8,'Increases the clan members Evasion. Only affects Baron class and above',4000,8160),
(381,3,'Clan Agility',8,'Increases the clan members Evasion. Only affects Baron class and above',4000,8160),
(382,1,'Clan Withstand-Attack',7,'Increases clan members Shield defense probability. It only effects those who are of a Viscount class or higher',800,8160),
(382,2,'Clan Withstand-Attack',7,'Increases clan members Shield defense probability. It only effects those who are of a Viscount class or higher',800,8160),
(382,3,'Clan Withstand-Attack',7,'Increases clan members Shield defense probability. It only effects those who are of a Viscount class or higher',800,8160),
(383,1,'Clan Shield Boost',6,'Increases clan members Shield P. Def. It only effects those who are of a Baron class or higher',800,8163),
(383,2,'Clan Shield Boost',6,'Increases clan members Shield P. Def. It only effects those who are of a Baron class or higher',800,8163),
(383,3,'Clan Shield Boost',6,'Increases clan members Shield P. Def. It only effects those who are of a Baron class or higher',800,8163),
(384,1,'Clan Cyclonic Resistance',7,'Increases clan members resistance to water and wind attacks. It only effects those who are of a Viscount class or higher',1800,8176),
(384,2,'Clan Cyclonic Resistance',7,'Increases clan members resistance to water and wind attacks. It only effects those who are of a Viscount class or higher',1800,8176),
(384,3,'Clan Cyclonic Resistance',7,'Increases clan members resistance to water and wind attacks. It only effects those who are of a Viscount class or higher',1800,8176),
(385,1,'Clan Magmatic Resistance',7,'Increase clan members resistance to fire/earth attacks. It only effects those who are of a Viscount class or higher',1800,8176),
(385,2,'Clan Magmatic Resistance',7,'Increase clan members resistance to fire/earth attacks. It only effects those who are of a Viscount class or higher',1800,8176),
(385,3,'Clan Magmatic Resistance',7,'Increase clan members resistance to fire/earth attacks. It only effects those who are of a Viscount class or higher',1800,8176),
(386,1,'Clan Fortitude',7,'Increases the clan members resistance to shock attacks. Only affects Viscount class and above',1000,8176),
(386,2,'Clan Fortitude',7,'Increases the clan members resistance to shock attacks. Only affects Viscount class and above',1000,8176),
(386,3,'Clan Fortitude',7,'Increases the clan members resistance to shock attacks. Only affects Viscount class and above',1000,8176),
(387,1,'Clan Freedom',7,'Increases the clan members resistance to hold attacks. Only affects Viscount class and above',1800,8176),
(387,2,'Clan Freedom',7,'Increases the clan members resistance to hold attacks. Only affects Viscount class and above',1800,8176),
(387,3,'Clan Freedom',7,'Increases the clan members resistance to hold attacks. Only affects Viscount class and above',1800,8176),
(388,1,'Clan Vigilance',7,'Increases the clan members resistance to sleep attacks. Only affects Viscount class and above',1800,8176),
(388,2,'Clan Vigilance',7,'Increases the clan members resistance to sleep attacks. Only affects Viscount class and above',1800,8176),
(388,3,'Clan Vigilance',7,'Increases the clan members resistance to sleep attacks. Only affects Viscount class and above',1800,8176),
(389,1,'Clan March',8,'Increases clan members Speed. It only effects those who are of a Count class or higher',3800,8175),
(389,2,'Clan March',8,'Increases clan members Speed. It only effects those who are of a Count class or higher',3800,8175),
(389,3,'Clan March',8,'Increases clan members Speed. It only effects those who are of a Count class or higher',3800,8175),
(390,1,'Clan Luck',7,'Decreases Exp. loss and the chance of other death penalties when killed by a monster or player. It only effects those who are of an Heir class or higher',2200,8175),
(390,2,'Clan Luck',7,'Decreases Exp. loss and the chance of other death penalties when killed by a monster or player. It only effects those who are of an Heir class or higher',2200,8175),
(390,3,'Clan Luck',7,'Decreases Exp. loss and the chance of other death penalties when killed by a monster or player. It only effects those who are of an Heir class or higher',2200,8175),
(391,1,'Clan Imperium',5,'Grants the privilege of Command Channel formation. It only effects Sage / Elder class and above',0,8176);