[help]Помогите Хачю внести скил в фиш нпса
Вот я хачю внести Лс скилы в Нпса каторый выдает фиш скилы помогите обьесните как это зделать
таблица в мускуле fishing_skills_trees
Мои соображения по этому поводу: Я нашол Sql фаил этот добавил туда скил лса ну копию как там занес это в базу DROP TABLE IF EXISTS `fishing_skill_trees`;
--
-- Table structure for fishing_skill_trees
--
CREATE TABLE IF NOT EXISTS `fishing_skill_trees` (
`skill_id` int(10) NOT NULL default '0',
`level` int(10) NOT NULL default '0',
`name` varchar(25) NOT NULL default '',
`sp` int(10) NOT NULL default '0',
`min_level` int(10) NOT NULL default '0',
`costid` int(10) NOT NULL default '0',
`cost` int(10) NOT NULL default '0',
`isfordwarf` int(1) NOT NULL default '0',
PRIMARY KEY (`skill_id`,`level`)
) TYPE=MyISAM;
--
-- Records for table fishing_skill_trees
--
INSERT INTO fishing_skill_trees VALUES
(1313,1,'Pumping',0,10,57,10,0),
(1313,2,'Pumping',0,12,57,50,0),
(1313,3,'Pumping',0,15,57,200,0),
(1313,4,'Pumping',0,17,57,300,0),
(1313,5,'Pumping',0,20,57,500,0),
(1313,6,'Pumping',0,22,57,800,0),
(1313,7,'Pumping',0,25,57,1600,0),
(1313,8,'Pumping',0,27,57,2600,0),
(1313,9,'Pumping',0,30,57,4000,0),
(1313,10,'Pumping',0,32,57,6700,0),
(1313,11,'Pumping',0,35,57,8000,0),
(1313,12,'Pumping',0,37,57,10000,0),
(1313,13,'Pumping',0,40,57,16000,0),
(1313,14,'Pumping',0,42,57,23000,0),
(1313,15,'Pumping',0,45,57,30000,0),
(1313,16,'Pumping',0,47,57,40000,0),
(1313,17,'Pumping',0,49,57,53000,0),
(1313,18,'Pumping',0,52,57,66000,0),
(1313,19,'Pumping',0,54,57,80000,0),
(1313,20,'Pumping',0,57,57,93000,0),
(1313,21,'Pumping',0,59,57,100000,0),
(1313,22,'Pumping',0,62,57,120000,0),
(1313,23,'Pumping',0,64,57,130000,0),
(1313,24,'Pumping',0,67,57,140000,0),
(1313,25,'Pumping',0,69,57,160000,0),
(1313,26,'Pumping',0,71,57,173000,0),
(1313,27,'Pumping',0,74,57,180000,0),
(1314,1,'Reeling',0,10,57,10,0),
(1314,2,'Reeling',0,12,57,50,0),
(1314,3,'Reeling',0,15,57,200,0),
(1314,4,'Reeling',0,17,57,300,0),
(1314,5,'Reeling',0,20,57,500,0),
(1314,6,'Reeling',0,22,57,800,0),
(1314,7,'Reeling',0,25,57,1600,0),
(1314,8,'Reeling',0,27,57,2600,0),
(1314,9,'Reeling',0,30,57,4000,0),
(1314,10,'Reeling',0,32,57,6700,0),
(1314,11,'Reeling',0,35,57,8000,0),
(1314,12,'Reeling',0,37,57,10000,0),
(1314,13,'Reeling',0,40,57,16000,0),
(1314,14,'Reeling',0,42,57,23000,0),
(1314,15,'Reeling',0,45,57,30000,0),
(1314,16,'Reeling',0,47,57,40000,0),
(1314,17,'Reeling',0,49,57,53000,0),
(1314,18,'Reeling',0,52,57,66000,0),
(1314,19,'Reeling',0,54,57,80000,0),
(1314,20,'Reeling',0,57,57,93000,0),
(1314,21,'Reeling',0,59,57,100000,0),
(1314,22,'Reeling',0,62,57,120000,0),
(1314,23,'Reeling',0,64,57,130000,0),
(1314,24,'Reeling',0,67,57,140000,0),
(1314,25,'Reeling',0,69,57,160000,0),
(1314,26,'Reeling',0,71,57,173000,0),
(1314,27,'Reeling',0,74,57,180000,0),
(1315,1,'Fishing Expertise',0,10,57,10,0),
(1315,2,'Fishing Expertise',0,12,57,50,0),
(1315,3,'Fishing Expertise',0,15,57,200,0),
(1315,4,'Fishing Expertise',0,17,57,300,0),
(1315,5,'Fishing Expertise',0,20,57,500,0),
(1315,6,'Fishing Expertise',0,22,57,800,0),
(1315,7,'Fishing Expertise',0,25,57,1600,0),
(1315,8,'Fishing Expertise',0,27,57,2600,0),
(1315,9,'Fishing Expertise',0,30,57,4000,0),
(1315,10,'Fishing Expertise',0,32,57,6700,0),
(1315,11,'Fishing Expertise',0,35,57,8000,0),
(1315,12,'Fishing Expertise',0,37,57,10000,0),
(1315,13,'Fishing Expertise',0,40,57,16000,0),
(1315,14,'Fishing Expertise',0,42,57,23000,0),
(1315,15,'Fishing Expertise',0,45,57,30000,0),
(1315,16,'Fishing Expertise',0,47,57,40000,0),
(1315,17,'Fishing Expertise',0,49,57,53000,0),
(1315,18,'Fishing Expertise',0,52,57,66000,0),
(1315,19,'Fishing Expertise',0,54,57,80000,0),
(1315,20,'Fishing Expertise',0,57,57,93000,0),
(1315,21,'Fishing Expertise',0,59,57,100000,0),
(1315,22,'Fishing Expertise',0,62,57,120000,0),
(1315,23,'Fishing Expertise',0,64,57,130000,0),
(1315,24,'Fishing Expertise',0,67,57,140000,0),
(1315,25,'Fishing Expertise',0,69,57,160000,0),
(1315,26,'Fishing Expertise',0,71,57,173000,0),
(1315,27,'Fishing Expertise',0,74,57,180000,0),
(1368,1,'Expand Dwarven Craft',0,10,7609,2000,1),
(1368,2,'Expand Dwarven Craft',0,20,7609,4000,1),
(1368,3,'Expand Dwarven Craft',0,30,7609,6000,1),
(1368,4,'Expand Dwarven Craft',0,40,7609,10000,1),
(1368,5,'Expand Dwarven Craft',0,50,7609,10000,1),
(1368,6,'Expand Dwarven Craft',0,60,7609,10000,1),
(1368,7,'Expand Dwarven Craft',0,70,7609,20000,1),
(1368,8,'Expand Dwarven Craft',0,76,7609,20000,1),
(1369,1,'Expand Common Craft',0,10,7609,2000,0),
(1369,2,'Expand Common Craft',0,20,7609,4000,0),
(1369,3,'Expand Common Craft',0,30,7609,6000,0),
(1369,4,'Expand Common Craft',0,40,7609,10000,0),
(1369,5,'Expand Common Craft',0,50,7609,10000,0),
(1369,6,'Expand Common Craft',0,60,7609,10000,0),
(1369,7,'Expand Common Craft',0,70,7609,20000,0),
(1369,8,'Expand Common Craft',0,76,7609,20000,0),
(1370,1,'Expand Trade',0,40,7609,10000,0),
(1370,2,'Expand Trade',0,55,7609,20000,0),
(1370,3,'Expand Trade',0,65,7609,40000,0),
(1371,1,'Expand Storage',0,10,7609,4000,0),
(1371,2,'Expand Storage',0,20,7609,8000,0),
(1371,3,'Expand Storage',0,30,7609,20000,0),
(1371,4,'Expand Storage',0,40,7609,20000,0),
(1371,5,'Expand Storage',0,50,7609,60000,0),
(1371,6,'Expand Storage',0,60,7609,60000,0),
(1371,7,'Expand Storage',0,70,7609,100000,0),
(1371,8,'Expand Storage',0,76,7609,100000,0),
(1372,1,'Expand Inventory',0,10,7609,4000,0),
(1372,2,'Expand Inventory',0,20,7609,8000,0),
(1372,3,'Expand Inventory',0,30,7609,20000,0),
(1372,4,'Expand Inventory',0,40,7609,20000,0),
(1372,5,'Expand Inventory',0,50,7609,60000,0),
(1372,6,'Expand Inventory',0,60,7609,60000,0),
(1372,7,'Expand Inventory',0,70,7609,100000,0),
(1372,8,'Expand Inventory',0,76,7609,100000,0),
(1312,1,'Fishing',0,10,57,1000,0);
(3103,1,'Item Skill:Fear',0,10,57,1000,0);
(3103,2,'Item Skill:Fear',0,10,57,2000,0);
(3103,3,'Item Skill:Fear',0,10,57,3000,0);
(3103,4,'Item Skill:Fear',0,10,57,4000,0);
(3103,5,'Item Skill:Fear',0,10,57,5000,0);
(3103,6,'Item Skill:Fear',0,10,57,6000,0);
(3103,7,'Item Skill:Fear',0,10,57,7000,0);
(3103,8,'Item Skill:Fear',0,10,57,8000,0);
(3103,9,'Item Skill:Fear',0,10,57,9000,0);
(3103,10,'Item Skill:Fear',0,10,57,10000,0);
и 0 реакцыи
?? какой ДРОП??
sterser: ?? какой ДРОП??
Где ты дроп увидел? В начале пишется drop что бы очистить толи удалить таблицу.
знач криво занес