· 8 years ago · Aug 09, 2018, 04:12 AM
1DROP TABLE IF EXISTS `npc`;
2CREATE TABLE `npc` (
3 `id` decimal(11,0) NOT NULL DEFAULT '0',
4 `idTemplate` int(11) NOT NULL DEFAULT '0',
5 `name` varchar(200) DEFAULT NULL,
6 `serverSideName` int(1) DEFAULT '0',
7 `title` varchar(45) DEFAULT '',
8 `serverSideTitle` int(1) DEFAULT '0',
9 `race` int(11) NOT NULL DEFAULT '-1',
10 `collision_radius` decimal(5,2) DEFAULT NULL,
11 `collision_height` decimal(5,2) DEFAULT NULL,
12 `level` decimal(2,0) DEFAULT NULL,
13 `sex` varchar(6) DEFAULT NULL,
14 `type` varchar(20) DEFAULT NULL,
15 `attackrange` int(11) DEFAULT NULL,
16 `hp` decimal(8,0) DEFAULT NULL,
17 `mp` decimal(8,0) DEFAULT NULL,
18 `hpreg` decimal(8,2) DEFAULT NULL,
19 `mpreg` decimal(5,2) DEFAULT NULL,
20 `str` decimal(7,0) DEFAULT NULL,
21 `con` decimal(7,0) DEFAULT NULL,
22 `dex` decimal(7,0) DEFAULT NULL,
23 `int` decimal(7,0) DEFAULT NULL,
24 `wit` decimal(7,0) DEFAULT NULL,
25 `men` decimal(7,0) DEFAULT NULL,
26 `exp` decimal(9,0) DEFAULT NULL,
27 `sp` decimal(8,0) DEFAULT NULL,
28 `patk` decimal(5,0) DEFAULT NULL,
29 `pdef` decimal(5,0) DEFAULT NULL,
30 `matk` decimal(5,0) DEFAULT NULL,
31 `mdef` decimal(5,0) DEFAULT NULL,
32 `atkspd` decimal(3,0) DEFAULT NULL,
33 `aggro` decimal(6,0) DEFAULT NULL,
34 `matkspd` decimal(4,0) DEFAULT NULL,
35 `rhand` decimal(5,0) DEFAULT NULL,
36 `lhand` decimal(5,0) DEFAULT NULL,
37 `armor` decimal(1,0) DEFAULT NULL,
38 `walkspd` decimal(3,0) DEFAULT NULL,
39 `runspd` decimal(3,0) DEFAULT NULL,
40 `faction_id` varchar(40) DEFAULT NULL,
41 `faction_range` decimal(4,0) DEFAULT NULL,
42 `isUndead` int(11) DEFAULT '0',
43 `absorb_level` decimal(2,0) DEFAULT '0',
44 `absorb_type` enum('FULL_PARTY','LAST_HIT','PARTY_ONE_RANDOM') NOT NULL DEFAULT 'LAST_HIT',
45 `ss` int(4) DEFAULT '0',
46 `bss` int(4) DEFAULT '0',
47 `ss_rate` int(3) DEFAULT '0',
48 `AI` varchar(8) DEFAULT 'fighter',
49 `drop_herbs` enum('true','false') NOT NULL DEFAULT 'false',
50 `faction` int(11) DEFAULT NULL,
51 PRIMARY KEY (`id`),
52 KEY `I_npc_name` (`name`)
53) ENGINE=MyISAM DEFAULT CHARSET=utf8;
54
55INSERT INTO `npc` VALUES ('12077', '12077', 'Wolf', '0', '', '0', '5', '13.00', '11.50', '15', 'male', 'L2Pet', '40', '195', '164', '3.95', '1.21', '40', '43', '30', '21', '20', '25', '0', '0', '9', '19', '3', '17', '304', '0', '333', '3907', '0', '0', '55', '125', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false');
56INSERT INTO `npc` VALUES ('12311', '12311', 'Hatchling of the Wind', '0', '', '0', '5', '9.00', '10.00', '35', 'male', 'L2Pet', '40', '610', '433', '7.11', '1.84', '40', '43', '30', '21', '20', '25', '0', '0', '48', '42', '22', '39', '278', '0', '333', '0', '0', '0', '80', '140', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false');
57INSERT INTO `npc` VALUES ('12312', '12312', 'Hatchling of the Stars', '0', '', '0', '5', '9.00', '10.00', '35', 'male', 'L2Pet', '40', '610', '433', '7.11', '1.84', '40', '43', '30', '21', '20', '25', '0', '0', '48', '42', '22', '39', '278', '0', '333', '0', '0', '0', '80', '140', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false');
58INSERT INTO `npc` VALUES ('12313', '12313', 'Hatchling of Twilight', '0', '', '0', '5', '9.00', '10.00', '35', 'male', 'L2Pet', '40', '610', '433', '7.11', '1.84', '40', '43', '30', '21', '20', '25', '0', '0', '48', '42', '22', '39', '282', '0', '333', '0', '0', '0', '88', '154', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false');
59INSERT INTO `npc` VALUES ('12526', '12526', 'Wind Strider', '0', '', '0', '5', '23.00', '31.00', '55', 'male', 'L2Pet', '40', '2728', '1138', '10.27', '2.45', '40', '43', '30', '21', '20', '25', '0', '0', '703', '332', '360', '301', '304', '0', '333', '5178', '0', '0', '80', '170', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false');
60INSERT INTO `npc` VALUES ('12527', '12527', 'Star Strider', '0', '', '0', '5', '23.00', '31.00', '55', 'male', 'L2Pet', '40', '2728', '1138', '10.27', '2.45', '40', '43', '30', '21', '20', '25', '0', '0', '703', '332', '360', '301', '282', '0', '333', '0', '0', '0', '88', '187', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false');
61INSERT INTO `npc` VALUES ('12528', '12528', 'Twilight Strider', '0', '', '0', '5', '23.00', '31.00', '55', 'male', 'L2Pet', '40', '2728', '1138', '10.27', '2.45', '40', '43', '30', '21', '20', '25', '0', '0', '703', '332', '360', '301', '278', '0', '333', '0', '0', '0', '80', '170', 'NULL', '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false');