СБорка прайд
--
-- Table structure for table `npc`
--
DROP TABLE IF EXISTS `npc`;
CREATE TABLE `npc`(
`id` decimal(11,0) NOT NULL default '0',
`idTemplate` int(11) NOT NULL default '0',
`name` varchar(200) default NULL,
`serverSideName` int(1) default '0',
`title` varchar(45) default '',
`serverSideTitle` int(1) default '0',
`class` varchar(200) default NULL,
`collision_radius` decimal(5,2) default NULL,
`collision_height` decimal(5,2) default NULL,
`level` decimal(2,0) default NULL,
`sex` varchar(6) default NULL,
`type` varchar(20) default NULL,
`attackrange` int(11) default NULL,
`hp` decimal(8,0) default NULL,
`mp` decimal(6,0) default NULL,
`hpreg` decimal(8,2) default NULL,
`mpreg` decimal(5,2) default NULL,
`str` decimal(7,0) default NULL,
`con` decimal(7,0) default NULL,
`dex` decimal(7,0) default NULL,
`int` decimal(7,0) default NULL,
`wit` decimal(7,0) default NULL,
`men` decimal(7,0) default NULL,
`exp` decimal(9,0) default NULL,
`sp` decimal(8,0) default NULL,
`patk` decimal(5,0) default NULL,
`pdef` decimal(5,0) default NULL,
`matk` decimal(5,0) default NULL,
`mdef` decimal(5,0) default NULL,
`atkspd` decimal(3,0) default NULL,
`aggro` decimal(6,0) default NULL,
`matkspd` decimal(4,0) default NULL,
`rhand` decimal(5,0) default NULL,
`lhand` decimal(5,0) default NULL,
`armor` decimal(1,0) default NULL,
`walkspd` decimal(3,0) default NULL,
`runspd` decimal(3,0) default NULL,
`faction_id` varchar(40) default NULL,
`faction_range` decimal(4,0) default NULL,
`isUndead` int(11) default 0,
`absorb_level` decimal(2,0) default 0,
`absorb_type` enum('FULL_PARTY','LAST_HIT','PARTY_ONE_RANDOM') DEFAULT 'LAST_HIT' NOT NULL,
`ss` int(4) default 0,
`bss` int(4) default 0,
`ss_rate` int(3) default 0,
`AI` varchar( default "fighter",
`drop_herbs` enum('true','false') DEFAULT 'false' NOT NULL,
PRIMARY KEY (`id`)
);
--
-- Dumping data for table `npc`
--
INSERT INTO `npc` VALUES
(50000, 50000, "Tauti", 0, "", 0, "LineageMonster.death_lord", 10, 63, 15, "male", "L2Monster", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
-- Russian Java Server Alliance Project
ЕРОР
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
[Err] --
-- Table structure for table `npc`
--
DROP TABLE IF EXISTS `npc`;
CREATE TABLE `npc`(
`id` decimal(11,0) NOT NULL default '0',
`idTemplate` int(11) NOT NULL default '0',
`name` varchar(200) default NULL,
`serverSideName` int(1) default '0',
`title` varchar(45) default '',
`serverSideTitle` int(1) default '0',
`class` varchar(200) default NULL,
`collision_radius` decimal(5,2) default NULL,
`collision_height` decimal(5,2) default NULL,
`level` decimal(2,0) default NULL,
`sex` varchar(6) default NULL,
`type` varchar(20) default NULL,
`attackrange` int(11) default NULL,
`hp` decimal(8,0) default NULL,
`mp` decimal(6,0) default NULL,
`hpreg` decimal(8,2) default NULL,
`mpreg` decimal(5,2) default NULL,
`str` decimal(7,0) default NULL,
`con` decimal(7,0) default NULL,
`dex` decimal(7,0) default NULL,
`int` decimal(7,0) default NULL,
`wit` decimal(7,0) default NULL,
`men` decimal(7,0) default NULL,
`exp` decimal(9,0) default NULL,
`sp` decimal(8,0) default NULL,
`patk` decimal(5,0) default NULL,
`pdef` decimal(5,0) default NULL,
`matk` decimal(5,0) default NULL,
`mdef` decimal(5,0) default NULL,
`atkspd` decimal(3,0) default NULL,
`aggro` decimal(6,0) default NULL,
`matkspd` decimal(4,0) default NULL,
`rhand` decimal(5,0) default NULL,
`lhand` decimal(5,0) default NULL,
`armor` decimal(1,0) default NULL,
`walkspd` decimal(3,0) default NULL,
`runspd` decimal(3,0) default NULL,
`faction_id` varchar(40) default NULL,
`faction_range` decimal(4,0) default NULL,
`isUndead` int(11) default 0,
`absorb_level` decimal(2,0) default 0,
`absorb_type` enum('FULL_PARTY','LAST_HIT','PARTY_ONE_RANDOM') DEFAULT 'LAST_HIT' NOT NULL,
`ss` int(4) default 0,
`bss` int(4) default 0,
`ss_rate` int(3) default 0,
`AI` varchar( default "fighter",
`drop_herbs` enum('true','false') DEFAULT 'false' NOT NULL,
PRIMARY KEY (`id`)
);
--
-- Dumping data for table `npc`
--
INSERT INTO `npc` VALUES
(50000, 50000, "Tauti", 0, "", 0, "LineageMonster.death_lord", 10, 63, 15, "male", "L2Monster", 40, 1200000, 164, 3.95, 1.21, 40, 43, 30, 21, 20, 25, 0, 0, 9, 19, 3, 17, 304, 0, 333, 3907, 0, 0, 24, 125, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
-- Russian Java Server Alliance Project
[Msg] Finished - Unsuccessfully
--------------------------------------------------
