Изучение клан скиллов

[Ambrozie]

Интересует вопрос как реализовать изучение клан скиллов, без клан яиц.

Сборка La2Shark High five

[Ro_0TT]

А почему вы на форуме самой тимы этой сборки вопросы не задаете?)

[Ambrozie]

Там не отвечают =)

[L2scripts-Guard]

А изучение скилов у шарков в ДП или в базе?
Никогда их сборку толком и не видел, дадите ответ, помогу.

[Sisi]

датапак на сколько я помню.

[L2scripts-Guard]

pledge_skill_tree

Внутри все что надо вы найдете.

[Sisi]

sql

-- ----------------------------
-- Table structure for pledge_skill_trees
-- ----------------------------
DROP TABLE IF EXISTS `pledge_skill_trees`;
CREATE TABLE `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,
`itemCount` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `pledge_skill_trees` VALUES ('370', '1', 'Clan Body', '5', 'Increases clan members Max HP. It only effects those who are of an Heir class or higher', '1500', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('373', '1', 'Clan Regeneration', '5', 'Increases the clan members HP regeneration. Only affects Heir class and above', '1500', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('379', '1', 'Clan Magic Resistance', '5', 'Increases clan members M. Def. It only effects those who are of an Heir class or higher', '1500', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('391', '1', 'Clan Imperium', '5', 'Grants the privilege of Command Channel formation. It only effects Sage / Elder class and above', '0', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('371', '1', 'Clan Spirituality', '6', 'Increases clan members Max CP. It only effects those who are of a Baron class or higher', '2100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('374', '1', 'Clan Morale', '6', 'Increases the clan members CP regeneration. Only affects Elder class and above', '2600', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('376', '1', 'Clan Might', '6', 'Increases the clan members P. Atk. Only affects Knight class and above', '3000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('377', '1', 'Clan Shield', '6', 'Increases clan members P. Def. It only effects those who are of a Knight class or higher', '3000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('383', '1', 'Clan Shield Block', '6', 'Increases clan members Shield P. Def. It only effects those who are of a Baron class or higher', '2100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('370', '2', 'Clan Body', '7', 'Increases clan members Max HP. It only effects those who are of an Heir class or higher', '6900', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('371', '2', 'Clan Spirituality', '7', 'Increases clan members Max CP. It only effects those who are of a Baron class or higher', '5600', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('373', '2', 'Clan Regeneration', '7', 'Increases the clan members HP regeneration. Only affects Heir class and above', '6900', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('376', '2', 'Clan Might', '7', 'Increases the clan members P. Atk. Only affects Knight class and above', '6500', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('377', '2', 'Clan Shield', '7', 'Increases clan members P. Def. It only effects those who are of a Knight class or higher', '6500', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('379', '2', 'Clan Magic Resistance', '7', 'Increases clan members M. Def. It only effects those who are of an Heir class or higher', '6900', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('380', '1', 'Clan Guidance', '7', 'Increases the clan members Accuracy. Only affects Baron class and above', '5600', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('382', '1', 'Clan Shield Defense', '7', 'Increases clan members Shield defense probability. It only effects those who are of a Viscount class or higher', '5100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('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', '5100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('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', '5100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('386', '1', 'Clan Resist Shock', '7', 'Increases the clan members resistance to shock attacks. Only affects Viscount class and above', '5100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('387', '1', 'Clan Resist Hold', '7', 'Increases the clan members resistance to hold attacks. Only affects Viscount class and above', '5100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('388', '1', 'Clan Resist Sleep', '7', 'Increases the clan members resistance to sleep attacks. Only affects Viscount class and above', '5100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('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', '6900', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('371', '3', 'Clan Spirituality', '8', 'Increases clan members Max CP. It only effects those who are of a Baron class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('372', '1', 'Clan Soul', '8', 'Increases clan members Max MP. It only effects those who are of a Viscount class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('374', '2', 'Clan Morale', '8', 'Increases the clan members CP regeneration. Only affects Elder class and above', '13000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('375', '1', 'Clan Clarity', '8', 'Increases the clan members MP regeneration. Only affects Viscount class and above', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('376', '3', 'Clan Might', '8', 'Increases the clan members P. Atk. Only affects Knight class and above', '13000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('377', '3', 'Clan Shield', '8', 'Increases clan members P. Def. It only effects those who are of a Knight class or higher', '13000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('378', '1', 'Clan Empower', '8', 'Increases clan members M. Atk. It only effects those who are of a Viscount class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('380', '2', 'Clan Guidance', '8', 'Increases the clan members Accuracy. Only affects Baron class and above', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('381', '1', 'Clan Agility', '8', 'Increases the clan members Evasion. Only affects Baron class and above', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('382', '2', 'Clan Shield Defense', '8', 'Increases clan members Shield defense probability. It only effects those who are of a Viscount class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('383', '2', 'Clan Shield Block', '8', 'Increases clan members Shield P. Def. It only effects those who are of a Baron class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('384', '2', 'Clan Cyclonic Resistance', '8', 'Increases clan members resistance to water and wind attacks. It only effects those who are of a Viscount class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('385', '2', 'Clan Magmatic Resistance', '8', 'Increase clan members resistance to fire/earth attacks. It only effects those who are of a Viscount class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('386', '2', 'Clan Resist Shock', '8', 'Increases the clan members resistance to shock attacks. Only affects Viscount class and above', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('387', '2', 'Clan Resist Hold', '8', 'Increases the clan members resistance to hold attacks. Only affects Viscount class and above', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('388', '2', 'Clan Resist Sleep', '8', 'Increases the clan members resistance to sleep attacks. Only affects Viscount class and above', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('389', '1', 'Clan Wind Walk', '8', 'Increases clan members Speed. It only effects those who are of a Count class or higher', '11000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('390', '2', 'Clan Luck', '8', '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', '14000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('370', '3', 'Clan Body', '11', 'A clan member\'s Max HP increases by 6%. Effect applies after member level.', '13200', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('373', '3', 'Clan Regeneration', '11', 'A clan member\'s HP recovery bonus increases by 6%. Effect applies after member level.', '13200', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('379', '3', 'Clan Magic Resistance', '11', 'A clan member\'s M. Def. increases by 12%. Effect applies after member level.', '13200', '0', '0');

[gorodetskiy]

sql

-- ----------------------------
-- Table structure for pledge_skill_trees
-- ----------------------------
DROP TABLE IF EXISTS `pledge_skill_trees`;
CREATE TABLE `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,
`itemCount` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `pledge_skill_trees` VALUES ('370', '1', 'Clan Body', '5', 'Increases clan members Max HP. It only effects those who are of an Heir class or higher', '1500', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('373', '1', 'Clan Regeneration', '5', 'Increases the clan members HP regeneration. Only affects Heir class and above', '1500', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('379', '1', 'Clan Magic Resistance', '5', 'Increases clan members M. Def. It only effects those who are of an Heir class or higher', '1500', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('391', '1', 'Clan Imperium', '5', 'Grants the privilege of Command Channel formation. It only effects Sage / Elder class and above', '0', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('371', '1', 'Clan Spirituality', '6', 'Increases clan members Max CP. It only effects those who are of a Baron class or higher', '2100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('374', '1', 'Clan Morale', '6', 'Increases the clan members CP regeneration. Only affects Elder class and above', '2600', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('376', '1', 'Clan Might', '6', 'Increases the clan members P. Atk. Only affects Knight class and above', '3000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('377', '1', 'Clan Shield', '6', 'Increases clan members P. Def. It only effects those who are of a Knight class or higher', '3000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('383', '1', 'Clan Shield Block', '6', 'Increases clan members Shield P. Def. It only effects those who are of a Baron class or higher', '2100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('370', '2', 'Clan Body', '7', 'Increases clan members Max HP. It only effects those who are of an Heir class or higher', '6900', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('371', '2', 'Clan Spirituality', '7', 'Increases clan members Max CP. It only effects those who are of a Baron class or higher', '5600', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('373', '2', 'Clan Regeneration', '7', 'Increases the clan members HP regeneration. Only affects Heir class and above', '6900', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('376', '2', 'Clan Might', '7', 'Increases the clan members P. Atk. Only affects Knight class and above', '6500', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('377', '2', 'Clan Shield', '7', 'Increases clan members P. Def. It only effects those who are of a Knight class or higher', '6500', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('379', '2', 'Clan Magic Resistance', '7', 'Increases clan members M. Def. It only effects those who are of an Heir class or higher', '6900', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('380', '1', 'Clan Guidance', '7', 'Increases the clan members Accuracy. Only affects Baron class and above', '5600', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('382', '1', 'Clan Shield Defense', '7', 'Increases clan members Shield defense probability. It only effects those who are of a Viscount class or higher', '5100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('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', '5100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('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', '5100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('386', '1', 'Clan Resist Shock', '7', 'Increases the clan members resistance to shock attacks. Only affects Viscount class and above', '5100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('387', '1', 'Clan Resist Hold', '7', 'Increases the clan members resistance to hold attacks. Only affects Viscount class and above', '5100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('388', '1', 'Clan Resist Sleep', '7', 'Increases the clan members resistance to sleep attacks. Only affects Viscount class and above', '5100', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('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', '6900', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('371', '3', 'Clan Spirituality', '8', 'Increases clan members Max CP. It only effects those who are of a Baron class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('372', '1', 'Clan Soul', '8', 'Increases clan members Max MP. It only effects those who are of a Viscount class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('374', '2', 'Clan Morale', '8', 'Increases the clan members CP regeneration. Only affects Elder class and above', '13000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('375', '1', 'Clan Clarity', '8', 'Increases the clan members MP regeneration. Only affects Viscount class and above', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('376', '3', 'Clan Might', '8', 'Increases the clan members P. Atk. Only affects Knight class and above', '13000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('377', '3', 'Clan Shield', '8', 'Increases clan members P. Def. It only effects those who are of a Knight class or higher', '13000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('378', '1', 'Clan Empower', '8', 'Increases clan members M. Atk. It only effects those who are of a Viscount class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('380', '2', 'Clan Guidance', '8', 'Increases the clan members Accuracy. Only affects Baron class and above', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('381', '1', 'Clan Agility', '8', 'Increases the clan members Evasion. Only affects Baron class and above', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('382', '2', 'Clan Shield Defense', '8', 'Increases clan members Shield defense probability. It only effects those who are of a Viscount class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('383', '2', 'Clan Shield Block', '8', 'Increases clan members Shield P. Def. It only effects those who are of a Baron class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('384', '2', 'Clan Cyclonic Resistance', '8', 'Increases clan members resistance to water and wind attacks. It only effects those who are of a Viscount class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('385', '2', 'Clan Magmatic Resistance', '8', 'Increase clan members resistance to fire/earth attacks. It only effects those who are of a Viscount class or higher', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('386', '2', 'Clan Resist Shock', '8', 'Increases the clan members resistance to shock attacks. Only affects Viscount class and above', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('387', '2', 'Clan Resist Hold', '8', 'Increases the clan members resistance to hold attacks. Only affects Viscount class and above', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('388', '2', 'Clan Resist Sleep', '8', 'Increases the clan members resistance to sleep attacks. Only affects Viscount class and above', '12000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('389', '1', 'Clan Wind Walk', '8', 'Increases clan members Speed. It only effects those who are of a Count class or higher', '11000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('390', '2', 'Clan Luck', '8', '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', '14000', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('370', '3', 'Clan Body', '11', 'A clan member\'s Max HP increases by 6%. Effect applies after member level.', '13200', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('373', '3', 'Clan Regeneration', '11', 'A clan member\'s HP recovery bonus increases by 6%. Effect applies after member level.', '13200', '0', '0');
INSERT INTO `pledge_skill_trees` VALUES ('379', '3', 'Clan Magic Resistance', '11', 'A clan member\'s M. Def. increases by 12%. Effect applies after member level.', '13200', '0', '0');

Ответ кроется именно тут.
`itemId` int(11) DEFAULT NULL,
`itemCount` int(11) DEFAULT NULL
itemId - Айди итема которое используется, itemCount кол-во itemId для поднятия уровня.

[L2scripts-Guard]

Человек написал что в ДП Скил трис а не в базе.
Ответ кроется в том файле котором я указал выше.

[Ro_0TT]

Человек написал что в ДП Скил трис а не в базе.
Ответ кроется в том файле котором я указал выше.

В базе, все верно.