createnpc.sql

天之炼狱OpenDE_SQL.tar.gz

-- MySQL dump 8.22
--
-- Host: 61.78.53.167    Database: DARKEDEN
---------------------------------------------------------
-- Server version	3.23.54-log

--
-- Table structure for table 'NPC'
--

DROP TABLE IF EXISTS NPC;

CREATE TABLE NPC (
  Name varchar(50) NOT NULL default '',
  NPCID int(10) unsigned NOT NULL default '0',
  SpriteType int(10) unsigned NOT NULL default '0',
  Race int(10) unsigned NOT NULL default '0',
  MainColor int(10) unsigned NOT NULL default '0',
  SubColor int(10) unsigned NOT NULL default '0',
  ZoneID int(10) unsigned NOT NULL default '0',
  ClanType int(10) unsigned NOT NULL default '0',
  ShowInMinimap tinyint(3) unsigned NOT NULL default '0',
  Description text NOT NULL,
  PRIMARY KEY  (NPCID)
) TYPE=MyISAM;

--
-- Dumping data for table 'NPC'
--


INSERT INTO NPC VALUES ('克里斯',21,20,0,1,1,2021,0,1,'保管箱的出销及管理。');
INSERT INTO NPC VALUES ('司马尔罗维奇',108,44,0,1,1,2021,0,1,'修理，镀银。');
INSERT INTO NPC VALUES ('约翰娜',101,35,0,1,1,2021,0,1,'治疗，枪械和弹夹。');
INSERT INTO NPC VALUES ('哥鲁伯',95,28,0,1,1,2022,0,1,'卖项链、手镯、戒指。');
INSERT INTO NPC VALUES ('西哈拉',100,34,0,1,1,2022,0,1,'靴子和手套。');
INSERT INTO NPC VALUES ('山德拉',97,31,0,1,1,2022,0,1,'上下衣、腰带、头盔。');
INSERT INTO NPC VALUES ('赫斯布罗',110,46,0,1,1,2023,0,1,'销售盾牌，镀银。');
INSERT INTO NPC VALUES ('尤娃',14,13,0,1,1,2023,0,1,'刀术指导，刀买卖。');
INSERT INTO NPC VALUES ('汉',24,23,0,1,1,2023,0,1,'剑术指导，剑买卖。');
INSERT INTO NPC VALUES ('可南',157,55,0,1,1,2023,0,1,'圣向恢复。');
INSERT INTO NPC VALUES ('杰克',109,45,0,1,1,14,0,1,'摩托车以及子弹销售，摩托车管理。');
INSERT INTO NPC VALUES ('迈特',250,0,0,1,1,2024,0,1,'直升机司机。');
INSERT INTO NPC VALUES ('戴维',27,26,0,1,1,2001,0,1,'修理');
INSERT INTO NPC VALUES ('凯文',20,19,0,1,1,2001,0,1,'保管箱销售以及管理');
INSERT INTO NPC VALUES ('沙拉曼德',98,32,0,1,1,2001,0,1,'治疗，枪械和弹夹。');
INSERT INTO NPC VALUES ('索尼亚',99,33,0,1,1,2002,0,1,'上下衣，腰带，头盔。');
INSERT INTO NPC VALUES ('克劳尔',102,36,0,1,1,2002,0,1,'卖靴子和手套。');
INSERT INTO NPC VALUES ('克来夫',23,22,0,1,1,2002,0,1,'销售首饰。');
INSERT INTO NPC VALUES ('德雷克',11,10,0,1,1,2003,0,1,'AR, SG 魄概');
INSERT INTO NPC VALUES ('苏坦',12,11,0,1,1,2003,0,1,'卖SMG');
INSERT INTO NPC VALUES ('简森',15,14,0,1,1,2003,0,1,'枪技术教育，SR销售。');
INSERT INTO NPC VALUES ('斯密斯',103,39,0,1,1,2003,0,1,'圣力恢复。');
INSERT INTO NPC VALUES ('斯克',251,0,0,1,1,2004,0,1,'直升机司机。');
INSERT INTO NPC VALUES ('克里斯丁',22,21,0,1,1,2011,0,1,'保管箱销售以及管理');
INSERT INTO NPC VALUES ('哥丽芬',96,29,0,1,1,2011,0,1,'修理');
INSERT INTO NPC VALUES ('辛森',13,12,0,1,1,2011,0,1,'治疗，枪械和弹夹。');
INSERT INTO NPC VALUES ('叶布基尼',159,54,0,1,1,2012,0,1,'销售首饰。');
INSERT INTO NPC VALUES ('尼古拉',160,49,0,1,1,2012,0,1,'上下衣，腰带，头盔。');
INSERT INTO NPC VALUES ('理查德森',161,51,0,1,1,2012,0,1,'靴子，手套管理。');
INSERT INTO NPC VALUES ('卡因',18,17,0,1,1,2012,0,1,'图书馆管理');
INSERT INTO NPC VALUES ('汉尼伐',25,24,0,1,1,2013,0,1,'魔法系列技术教育，卖权杖。');
INSERT INTO NPC VALUES ('沙莫尔',162,52,0,1,1,2013,0,1,'首饰管理');
INSERT INTO NPC VALUES ('拉可马诺夫',163,50,0,1,1,2013,0,1,'治疗技术教育，销售十字架。');
INSERT INTO NPC VALUES ('思托亚诺夫',164,53,0,1,1,2013,0,1,'圣向恢复。');
INSERT INTO NPC VALUES ('佛利可乐加斯',92,37,1,1,1,1003,0,1,'吸血鬼技术教育。');
INSERT INTO NPC VALUES ('卡帕提尼',93,38,1,1,1,1003,0,1,'首饰以及变身物品销售，保管箱的销售和管理。');
INSERT INTO NPC VALUES ('巴勒里',94,30,1,1,1,1003,0,1,'出售外套');
INSERT INTO NPC VALUES ('赛思',219,65,1,1,1,1003,0,1,'出售首饰及变身用物品');
INSERT INTO NPC VALUES ('卡昆',220,66,1,1,1,1003,0,1,'修理首饰及出售变身用物品');
INSERT INTO NPC VALUES ('凯泽',17,16,0,1,1,2101,0,1,'担任情报工作');
INSERT INTO NPC VALUES ('扎克',16,15,0,1,1,2101,0,1,'武器管理员');
INSERT INTO NPC VALUES ('塔娜',26,25,0,1,1,2101,0,1,'管理电脑');
INSERT INTO NPC VALUES ('得尼斯',297,0,0,1,1,2101,0,1,'治疗，枪械和弹夹。');
INSERT INTO NPC VALUES ('山本',296,0,0,1,1,2102,0,1,'治疗，枪械和弹夹。');
INSERT INTO NPC VALUES ('特里',302,0,0,1,1,2101,0,1,'出售鞋，手套及盾牌');
INSERT INTO NPC VALUES ('南西',303,1,0,1,1,2101,0,1,'出售上衣，下衣，腰带，帽子');
INSERT INTO NPC VALUES ('马克',298,0,0,1,1,2101,0,0,'野战司令部警卫');
INSERT INTO NPC VALUES ('约翰',299,0,0,1,1,2101,0,0,'野战司令部警卫');
INSERT INTO NPC VALUES ('丽沙',300,1,0,1,1,2101,0,0,'野战司令部警卫');
INSERT INTO NPC VALUES ('巴比安',304,0,0,1,1,2101,0,0,'野战司令部警卫');
INSERT INTO NPC VALUES ('杰夫',305,0,0,1,1,2101,0,0,'野战司令部警卫');
INSERT INTO NPC VALUES ('特利斯坦',315,0,0,1,1,2102,0,0,'野战司令部警卫');
INSERT INTO NPC VALUES ('艾连',316,1,0,1,1,2102,0,0,'野战司令部警卫');
INSERT INTO NPC VALUES ('培德力',317,1,0,1,1,2102,0,0,'野战司令部警卫');
INSERT INTO NPC VALUES ('莱贝卡',255,40,1,1,1,1003,0,1,'巴托里护卫');
INSERT INTO NPC VALUES ('阿格纳',362,80,1,1,1,1007,1,1,'出售外套');
INSERT INTO NPC VALUES ('艾曼',363,81,1,1,1,1007,1,1,'保管及修理');
INSERT INTO NPC VALUES ('凯因',364,82,1,1,1,1007,1,1,'Vampire 技术教育');
INSERT INTO NPC VALUES ('普丽亚',365,83,1,1,1,1007,1,1,'出售首饰');
INSERT INTO NPC VALUES ('拉里巴',368,37,1,1,1,23,0,1,'祭祀');
INSERT INTO NPC VALUES ('莱尔本',370,49,1,1,1,34,0,1,'出售Vampire外套');
INSERT INTO NPC VALUES ('格丽皮斯',427,97,1,1,1,61,0,1,'修理及保管');
INSERT INTO NPC VALUES ('洛宾',428,98,0,1,1,64,0,1,'修理及保管');
INSERT INTO NPC VALUES ('墨菲',429,99,1,1,1,61,0,1,'出售物品');
INSERT INTO NPC VALUES ('卡尔曼',430,100,0,1,1,64,0,1,'治疗及出售物品');

########################################################################
# 酒淬狼 己瘤
########################################################################
# 苛鸥何胶
INSERT INTO NPC VALUES ('爱斯林',		519,116,0,1,1,1201,0,1,'');
INSERT INTO NPC VALUES ('爱伦',			521,118,0,1,1,1201,0,1,'');
INSERT INTO NPC VALUES ('西蒙',		525,122,0,1,1,1201,0,1,'');

# 抛福萍快胶
INSERT INTO NPC VALUES ('马丽',			516,113,1,1,1,1202,0,1,'');
INSERT INTO NPC VALUES ('比屈斯',	518,115,1,1,1,1202,0,1,'');
INSERT INTO NPC VALUES ('汉特',			254, 40,1,1,1,1202,0,1,'');

# 剂萍公胶
INSERT INTO NPC VALUES ('朱缔斯',		522,119,0,1,1,1203,0,1,'');
INSERT INTO NPC VALUES ('哈罗德',		523,120,0,1,1,1203,0,1,'');
INSERT INTO NPC VALUES ('布兰达',		524,121,0,1,1,1203,0,1,'');

# 捻酒福捧胶
INSERT INTO NPC VALUES ('爱米',			520,117,1,1,1,1204,0,1,'');
INSERT INTO NPC VALUES ('摩罗克',			517,114,1,1,1,1204,0,1,'');
INSERT INTO NPC VALUES ('巴隆',			253, 40,1,1,1,1204,0,1,'');

# 酒淬狼 己瘤 巩瘤扁
INSERT INTO NPC VALUES ('帕拉罗斯',	551,125,0,1,1,73,  0,1, '');
INSERT INTO NPC VALUES ('帕亚',		555,127,0,1,1,71,  0,1, '');
INSERT INTO NPC VALUES ('爱里克',		553,126,0,1,1,73,  0,1, '');
INSERT INTO NPC VALUES ('伊莫特',	557,128,0,1,1,71,  0,1, '');

########################################################################
# 酒快胶磐令 NPC
########################################################################

INSERT INTO NPC VALUES ('拉维亚',	653,143,2,1,1,1311,  66,1, '');
INSERT INTO NPC VALUES ('利特',	654,144,2,1,1,1311,  66,1, '');
INSERT INTO NPC VALUES ('马内斯',	655,145,2,1,1,1311,  66,1, '');
INSERT INTO NPC VALUES ('索拉',	656,146,2,1,1,1311,  66,1, '');
INSERT INTO NPC VALUES ('阿马塔',	657,147,2,1,1,1311,  66,1, '');
INSERT INTO NPC VALUES ('郝拉',		658,148,2,1,1,1311,  66,1, '');