list_npcs.sql.svn-base

ROSE的源代码。了解的自己研究,编译通过

-- -----------------------------
-- Table structure for list_npcs
-- -----------------------------
DROP TABLE IF EXISTS `list_npcs`;
CREATE TABLE `list_npcs` (
	`id` int(11) NOT NULL auto_increment,
	`name` varchar(255) NOT NULL,
	`type` int(11) NOT NULL,
	`map` int(11) NOT NULL,
	`dir` float NOT NULL,
	`x` float NOT NULL,
	`y` float NOT NULL,
	  PRIMARY KEY  (`id`)
	) ENGINE=MyISAM AUTO_INCREMENT=152 DEFAULT CHARSET=latin1;

-- --------------------------
-- Records list_npcs / rl2171
-- --------------------------
-- (1) Planet Junon 

-- Map # 1 [Canyon City of Zant]

INSERT INTO `list_npcs` VALUES ('1', '[Village Chief] Cornell', '1001', '1', '180', '5216', '5112');
INSERT INTO `list_npcs` VALUES ('2', '[Akram Kingdom Minister] Warren', '1002', '1', '180', '5208', '5112');
INSERT INTO `list_npcs` VALUES ('3', '[Co-Founder of the Junon Order] Francis', '1003', '1', '135', '5080', '5065');
INSERT INTO `list_npcs` VALUES ('4', '[Ferrell Guild Staff] Crow', '1004', '1', '0', '5094', '5259');
INSERT INTO `list_npcs` VALUES ('5', '[Righteous Crusader] Leonard', '1005', '1', '45', '5261', '5166');
INSERT INTO `list_npcs` VALUES ('6', '[Arumic Merchant] Tryteh', '1006', '1', '270', '5312', '5152');
INSERT INTO `list_npcs` VALUES ('7', '[Gypsy Jewel Seller] Mina', '1007', '1', '225', '5292', '5127');
INSERT INTO `list_npcs` VALUES ('8', '[Weapon Seller] Raffle', '1008', '1', '315', '5303', '5231');
INSERT INTO `list_npcs` VALUES ('9', '[Armor Seller] Carrion', '1009', '1', '270', '5314', '5198');
INSERT INTO `list_npcs` VALUES ('10', '[Designer] Keenu', '1010', '1', '0', '5273', '5257');
INSERT INTO `list_npcs` VALUES ('11', '[Eccentric Inventor] Spero', '1011', '1', '45', '5213', '5255');
INSERT INTO `list_npcs` VALUES ('12', '[Ferrell Guild Staff] Ulysses', '1012', '1', '90', '5071', '5207');
INSERT INTO `list_npcs` VALUES ('13', '[Tavern Owner] Sharlin', '1013', '1', '315', '5131', '5218');
INSERT INTO `list_npcs` VALUES ('14', '[Guide] Lena', '1014', '1', '135', '5240', '5124');
INSERT INTO `list_npcs` VALUES ('15', '[Resident] Luth', '1015', '1', '270', '5130', '5153');
INSERT INTO `list_npcs` VALUES ('16', '[Livestock Farmer] Lampa', '1016', '1', '190', '5110', '5363');
INSERT INTO `list_npcs` VALUES ('17', '[Event Info] Judy', '1201', '1', '135', '5262', '5212');
INSERT INTO `list_npcs` VALUES ('18', '[Teleporter] Selladin', '1017', '1', '180', '5244', '5222');
INSERT INTO `list_npcs` VALUES ('19', '[Cornell\'s Grandson] Cheney', '1018', '1', '45', '5441', '5493');
INSERT INTO `list_npcs` VALUES ('20', '[Lena\'s Sister] Shirley', '1019', '1', '225', '5512', '5291');
INSERT INTO `list_npcs` VALUES ('21', '[Keenu\'s Daughter] Arisa', '1020', '1', '225', '5431', '5088');

-- Map # 2 [City of Junon Polis]

INSERT INTO `list_npcs` VALUES ('22', '[Historian] Jones', '1104', '2', '160', '5578', '4890');
INSERT INTO `list_npcs` VALUES ('23', '[Ferrell Guild Staff] Itz', '1100', '2', '270', '5603', '5034');
INSERT INTO `list_npcs` VALUES ('24', '[Ferrell Guild Staff] Hayen', '1099', '2', '270', '5603', '5046');
INSERT INTO `list_npcs` VALUES ('25', '[Tavern Owner] Harin', '1097', '2', '90', '5681', '5131');
INSERT INTO `list_npcs` VALUES ('26', '[Gypsy Jewel Seller] Bellia', '1092', '2', '270', '5726', '5202');
INSERT INTO `list_npcs` VALUES ('27', '[Ferrell Guild Merchant] Mildun', '1096', '2', '180', '5672', '5193');
INSERT INTO `list_npcs` VALUES ('28', '[Weapon Merchant] Crune', '1093', '2', '300', '5729', '5225');
INSERT INTO `list_npcs` VALUES ('29', '[Armor Merchant] Saki', '1094', '2', '270', '5722', '5290');
INSERT INTO `list_npcs` VALUES ('30', '[Manager of Ferrell] Arothel', '1089', '2', '270', '5713', '5360');
INSERT INTO `list_npcs` VALUES ('31', '[Ferrell Guild Staff] Charrs', '1110', '2', '270', '5713', '5368');
INSERT INTO `list_npcs` VALUES ('32', '[Guide] Eva', '1082', '2', '135', '5506', '5346');
INSERT INTO `list_npcs` VALUES ('33', '[Soldier] Winters', '1117', '2', '0', '5523', '5396');
INSERT INTO `list_npcs` VALUES ('34', '[Soldier] Odelo', '1116', '2', '0', '5507', '5396');
INSERT INTO `list_npcs` VALUES ('35', '[Righteous Crusader] Gawain', '1090', '2', '90', '5335', '5354');
INSERT INTO `list_npcs` VALUES ('36', '[Clan Owner] Burtland', '1115', '2', '100', '5288', '5264');
INSERT INTO `list_npcs` VALUES ('147', '[1st Arena Staff] Regina', '1751', '2', '100', '5288', '5243');
INSERT INTO `list_npcs` VALUES ('148', '[Vicious Captain] Ruven', '1125', '2', '270', '5597', '4918');
INSERT INTO `list_npcs` VALUES ('155', '[Clan Merchant] Aliche Patt', '1752', '2', '100', '5288', '5260');
INSERT INTO `list_npcs` VALUES ('37', '[Righteous Crusader] Huffe', '1111', '2', '90', '5335', '5346');
INSERT INTO `list_npcs` VALUES ('38', '[Elder of Junon Order] Gorthein', '1109', '2', '180', '5325', '5095');
INSERT INTO `list_npcs` VALUES ('39', '[Founder of Junon Order] Raw', '1088', '2', '180', '5319', '5095');
INSERT INTO `list_npcs` VALUES ('40', '[Guide] Alphonso', '1118', '2', '180', '5520', '5064');
INSERT INTO `list_npcs` VALUES ('41', '[Livestock Farmer] Sicru', '1107', '2', '190', '5818', '5487');
INSERT INTO `list_npcs` VALUES ('42', '[Ferrell Guild Staff] Kiroth', '1098', '2', '270', '5603', '5055');
INSERT INTO `list_npcs` VALUES ('43', '[Designer] Lisa', '1095', '2', '270', '5729', '5136');
INSERT INTO `list_npcs` VALUES ('44', '[Arumic Researcher] Carasia', '1112', '2', '190', '5730', '5093');
INSERT INTO `list_npcs` VALUES ('45', '[Event Info] Felice Fete', '1202', '2', '220', '5562', '5164');
INSERT INTO `list_npcs` VALUES ('46', '[Mayor] Darren', '1081', '2', '180', '5514', '5237');
INSERT INTO `list_npcs` VALUES ('47', '[Arumic Merchant] Chester', '1091', '2', '220', '5724', '5087');
INSERT INTO `list_npcs` VALUES ('48', '[Teleporter] Idiosel', '1119', '2', '270', '5347', '5177');

-- Map # 3 - [Dolphin Island]

INSERT INTO `list_npcs` VALUES ('49', '[Ferrell Guild Staff] Rooen', '1513', '3', '45', '5105', '5015');

-- Map # 5 [Junon Cartel]

INSERT INTO `list_npcs` VALUES ('50', '[Akram Minister] Mel', '1087', '5', '270', '5250', '5279');
INSERT INTO `list_npcs` VALUES ('51', '[Akram Minister] Rodath', '1086', '5', '90', '5149', '5279');

-- Map # 6 [Crusader Training]

INSERT INTO `list_npcs` VALUES ('52', '[Akram Minister] Gamp', '1084', '6', '270', '5250', '5279');

-- Map # 9 [No Name - PVP Area]

INSERT INTO `list_npcs` VALUES ('137', '[Referee] Leum', '1113', '9', '0', '5200', '5385');
INSERT INTO `list_npcs` VALUES ('138', '[Referee] Pirre', '1114', '9', '180', '5199', '4775');

-- Map # 11 [Junon Clan Field - (30-49)]

INSERT INTO `list_npcs` VALUES ('53', '[Akram Minister] Nell', '1085', '11', '45', '4982', '5481');
INSERT INTO `list_npcs` VALUES ('54', '[Akram Minister] Nell', '1085', '11', '135', '4953', '4996');
INSERT INTO `list_npcs` VALUES ('55', '[Akram Minister] Nell', '1085', '11', '270', '5522', '5020');
INSERT INTO `list_npcs` VALUES ('56', '[Akram Minister] Nell', '1085', '11', '320', '5454', '5480');

-- Map # 12 [Junon Clan Field - (50-69)]

INSERT INTO `list_npcs` VALUES ('139', '[Akram Minister] Nell', '1085', '12', '45', '4982', '5481');
INSERT INTO `list_npcs` VALUES ('140', '[Akram Minister] Nell', '1085', '12', '135', '4953', '4996');
INSERT INTO `list_npcs` VALUES ('141', '[Akram Minister] Nell', '1085', '12', '270', '5522', '5020');
INSERT INTO `list_npcs` VALUES ('142', '[Akram Minister] Nell', '1085', '12', '320', '5454', '5480');

-- Map # 13 [Junon Clan Field - (70-89)]

INSERT INTO `list_npcs` VALUES ('143', '[Akram Minister] Nell', '1085', '13', '45', '4982', '5481');
INSERT INTO `list_npcs` VALUES ('144', '[Akram Minister] Nell', '1085', '13', '135', '4953', '4996');
INSERT INTO `list_npcs` VALUES ('145', '[Akram Minister] Nell', '1085', '13', '270', '5522', '5020');
INSERT INTO `list_npcs` VALUES ('146', '[Akram Minister] Nell', '1085', '13', '320', '5454', '5480');

-- Map # 15 [Clan House]

INSERT INTO `list_npcs` VALUES ('152', '[Clan House Manager] Kushard', '1161', '15', '0', '5200', '5219');
INSERT INTO `list_npcs` VALUES ('153', '[Clan House Soldier] Jason', '1162', '15', '180', '5204', '5128');
INSERT INTO `list_npcs` VALUES ('154', '[Clan Clerk] Regina', '1120', '15', '180', '5196', '5128');


-- Map # 20 [Birth Island - Only works if you add it into the List_Zone.stb]

-- INSERT INTO `list_npcs` VALUES ('200', '[Visitor Guide] Arua\'s Fairy', '1030', '20', '135', '5124', '4733');
-- INSERT INTO `list_npcs` VALUES ('201', '[Visitor Guide] Arua\'s Fairy', '1030', '20', '225', '5649', '4743');
-- INSERT INTO `list_npcs` VALUES ('202', '[Visitor Guide] Arua\'s Fairy', '1030', '20', '0', '5709', '5178');
-- INSERT INTO `list_npcs` VALUES ('203', '[Visitor Guide] Arua\'s Fairy', '1030', '20', '45', '5339', '5394');
-- INSERT INTO `list_npcs` VALUES ('204', '[Visitor Guide] Arua\'s Fairy', '1030', '20', '45', '5035', '5149');


-- Map # 21 [Valley of Luxem Tower]

INSERT INTO `list_npcs` VALUES ('57', '[Arumic Resercher] Lutis', '1051', '21', '135', '5118', '5374');
INSERT INTO `list_npcs` VALUES ('58', '[Cleric] Karitte', '1053', '21', '135', '5115', '5384');
INSERT INTO `list_npcs` VALUES ('59', '[Mountain Guide] Shannon', '1052', '21', '45', '5358', '5278');