2020.07.04 增加 GM岛上的装备提供商

这些商人会根据玩家角色的不一样，导致卖的装备不一样。

1.比如战士角色只能看到战士的套装，其他职业的套装是看不到的

2.折腾了好久，以为是NPC的职业属性不一致导致的。但是在CREATURE_TEMPLATE 表格中的unit_class只有4个值1,2,4,8，修改后，还是战士看不到DK的大师卖的DK套装。（本来是玩家买了，给BOT装备，看来只有专门做一些包裹包括了套装，然后给BOT玩了）

 

SET SQL_SAFE_UPDATES = 0;
/*
BOT_CLASS_WARRIOR = 1
BOT_CLASS_PALADIN = 2
BOT_CLASS_HUNTER = 3
BOT_CLASS_ROGUE = 4
BOT_CLASS_PRIEST = 5
BOT_CLASS_DEATH_KNIGHT = 6
BOT_CLASS_SHAMAN = 7
BOT_CLASS_MAGE = 8
BOT_CLASS_WARLOCK = 9
BOT_CLASS_DRUID = 11
BOT_CLASS_BLADEMASTER = 12
BOT_CLASS_SPHYNX = 13
BOT_CLASS_ARCHMAGE = 14
BOT_CLASS_DREADLORD = 15
BOT_CLASS_SPELLBREAKER = 16
BOT_CLASS_DARK_RANGER = 17
*/
/*创建了14个生物原型，编号从90001~90014*/
/*创建了14个生物原型，编号从90001~90014，增加每个原型的物品销售*/
/*创建了14个NPC生物，编号从300001~300014*/

 

delete from creature_template where entry between 90000 and 99000;

insert into creature_template values
('90001', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-战士', '装备', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '1', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90002', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-圣骑士', '装备', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '2', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90003', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-猎人', '装备', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '2', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90004', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-潜行者', '装备', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '4', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90005', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-牧师', '装备', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '8', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90006', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-死亡骑士', '装备', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '1', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90007', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-萨满', '装备', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '2', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90008', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-法师', '装备', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '8', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90009', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-术士', '装备', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '8', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90010', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-德鲁伊', '装备', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '2', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90011', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-武器', '商品', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '1', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90012', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-好玩', '商品', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '1', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90013', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-高级物品', '商品', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '1', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340'),
('90014', '0', '0', '0', '0', '0', '24191', '0', '0', '0', '大师-其他', '商品', '', '0', '83', '83', '2', '35', '128', '1', '1.14286', '1', '3', '0', '2000', '2000', '1', '1', '1', '768', '2048', '0', '0', '7', '12', '0', '0', '0', '0', '0', '0', '0', 'SmartAI', '0', '1', '2000', '2000', '1', '35', '1', '0', '0', '1', '0', '0', '0', '', '12340');

delete from world.creature where id between 90000 and 99000;
insert into world.creature values
('300001', '90001', '1', '0', '0', '1', '1', '0', '0', '16321.9', '16242.4', '24.2435', '2.05779', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300002', '90002', '1', '0', '0', '1', '1', '0', '0', '16325.2', '16244.9', '23.6759', '2.17952', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300003', '90003', '1', '0', '0', '1', '1', '0', '0', '16319', '16240', '24.6338', '2.05386', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300004', '90004', '1', '0', '0', '1', '1', '0', '0', '16316.3', '16238.1', '25.0327', '2.05386', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300005', '90005', '1', '0', '0', '1', '1', '0', '0', '16313.4', '16235.5', '25.7287', '2.11669', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300006', '90006', '1', '0', '0', '1', '1', '0', '0', '16315.9', '16258.6', '22.8068', '5.35455', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300007', '90007', '1', '0', '0', '1', '1', '0', '0', '16312.4', '16256.5', '23.0814', '5.35063', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300008', '90008', '1', '0', '0', '1', '1', '0', '0', '16309.8', '16255', '23.2908', '5.37026', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300009', '90009', '1', '0', '0', '1', '1', '0', '0', '16306.9', '16253.8', '23.4845', '5.23674', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300010', '90010', '1', '0', '0', '1', '1', '0', '0', '16304.7', '16252.1', '23.8428', '5.272', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300011', '90011', '1', '0', '0', '1', '1', '0', '0', '16305.2', '16245.9', '24.8667', '0.716687', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300012', '90012', '1', '0', '0', '1', '1', '0', '0', '16308.1', '16239.7', '25.5537', '0.66328', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300013', '90013', '1', '0', '0', '1', '1', '0', '0', '16325.4', '16250.9', '23.696', '3.72633', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0'),
('300014', '90014', '1', '0', '0', '1', '1', '0', '0', '16321.4', '16256.1', '23.2708', '3.72633', '300', '0', '0', '27890000', '8516000', '0', '0', '0', '0', '', '0');

 

DELETE FROM world.npc_vendor where entry between 90000 and 99000;
insert world.npc_vendor value/*武器*/
('90011', '0', '49623', '0', '0', '0', '0'),/*影之哀伤*/
('90011', '0', '18348', '0', '0', '0', '0'),/*奎尔塞拉*/
('90011', '0', '19019', '0', '0', '0', '0'),/*逐风者*/
('90011', '0', '32837', '0', '0', '0', '0'),/*蛋主*/
('90011', '0', '32838', '0', '0', '0', '0'),/*蛋副*/
('90011', '0', '13262', '0', '0', '0', '0'),/*灰烬使者*/
('90011', '0', '49888', '0', '0', '0', '0'),/*影锋*/
('90011', '0', '51869', '0', '0', '0', '0'),/*整容刀*/
('90011', '0', '50730', '0', '0', '0', '0'),/*格罗萨格，白银之手骑士团圣剑*/
('90011', '0', '50737', '0', '0', '0', '0'),/*[浩劫的召唤，洛丹伦王权之斧*/
('90011', '0', '50654', '0', '0', '0', '0'),/*天灾降临战斧*/
('90011', '0', '50633', '0', '0', '0', '0'),/*辛达苟萨的残酷之爪*/
('90011', '0', '18582', '0', '0', '0', '0'),/*埃辛诺斯双刃*/
('90011', '0', '47515', '0', '0', '0', '0'),/*人屠*/
('90011', '0', '50412', '0', '0', '0', '0'),/*血毒长剑*/
('90011', '0', '51858', '0', '0', '0', '0'),/*断魂*/
('90011', '0', '50638', '0', '0', '0', '0'),/*佐德的机括长弓*/
('90011', '0', '34334', '0', '0', '0', '0'),/*索利达尔，群星之怒*/
('90011', '0', '50444', '0', '0', '0', '0'),/*洛万的银弹步枪*/
('90011', '0', '47521', '0', '0', '0', '0'),/*BRK-1000型火枪*/
('90011', '0', '51385', '0', '0', '0', '0'),/*打桩枪*/
('90011', '0', '50474', '0', '0', '0', '0'),/*弹片之星*/
('90011', '0', '50729', '0', '0', '0', '0');/* [冰川之墙]*/

insert world.npc_vendor value/*战士*/
('90001', '0', '51220', '0', '0', '0', '0'),/* [神圣伊米亚之王战甲]*/
('90001', '0', '51221', '0', '0', '0', '0'),
('90001', '0', '51222', '0', '0', '0', '0'),
('90001', '0', '51223', '0', '0', '0', '0'),
('90001', '0', '51224', '0', '0', '0', '0'),
('90001', '0', '51225', '0', '0', '0', '0'),/* [神圣伊米亚之王战甲]*/
('90001', '0', '51226', '0', '0', '0', '0'),
('90001', '0', '51227', '0', '0', '0', '0'),
('90001', '0', '51228', '0', '0', '0', '0'),
('90001', '0', '51229', '0', '0', '0', '0'),
('90001', '0', '54578', '0', '0', '0', '0'),/*天启降临之靴*/
('90001', '0', '54579', '0', '0', '0', '0'),/*拯救降临之靴*/
('90001', '0', '50659', '0', '0', '0', '0'),/*白熊之爪护腕*/
('90001', '0', '50611', '0', '0', '0', '0'),/* [黑暗清算护腕]*/
('90001', '0', '50620', '0', '0', '0', '0'),/*冷魂锁链*/
('90001', '0', '50691', '0', '0', '0', '0'),/* [断骨腰带]*/
('90001', '0', '54581', '0', '0', '0', '0'),/*半影坠饰*/
('90001', '0', '50627', '0', '0', '0', '0'),/* [孔雀石锁链]*/
('90001', '0', '50677', '0', '0', '0', '0'),/*裹尸布*/
('90001', '0', '50718', '0', '0', '0', '0'),/* [皇家血色披风]*/
('90001', '0', '52572', '0', '0', '0', '0'),/*永恒力量之灰烬指环*/
('90001', '0', '50693', '0', '0', '0', '0'),/*凋零之力*/
('90001', '0', '50622', '0', '0', '0', '0'),/*永冻指环*/
('90001', '0', '50642', '0', '0', '0', '0'),/* [蛮力指环]*/
('90001', '0', '54590', '0', '0', '0', '0'),/*锐锋暮光龙鳞*/
('90001', '0', '50706', '0', '0', '0', '0'),/*瓶中的小憎恶*/
('90001', '0', '54591', '0', '0', '0', '0'),/*石化暮光龙鳞]*/
('90001', '0', '50349', '0', '0', '0', '0'),/* [镇魂币]]*/
('90001', '0', '46104', '0', '0', '0', '0'),/*尤格杀手的衬衣*/
('90001', '0', '52252', '0', '0', '0', '0');/*战袍*/


insert world.npc_vendor value/*骑士OK*/
('90002', '0', '51275', '0', '0', '0', '0'),/* [ [神圣伊米亚之王战甲]]*/
('90002', '0', '51276', '0', '0', '0', '0'),/**/
('90002', '0', '51277', '0', '0', '0', '0'),/**/
('90002', '0', '51278', '0', '0', '0', '0'),/**/
('90002', '0', '51279', '0', '0', '0', '0'),/**/
('90002', '0', '54578', '0', '0', '0', '0'),/*天启降临之靴*/
('90002', '0', '50659', '0', '0', '0', '0'),/*白熊之爪护腕*/
('90002', '0', '50620', '0', '0', '0', '0'),/*冷魂锁链*/
('90002', '0', '54581', '0', '0', '0', '0'),/*半影坠饰*/
('90002', '0', '50677', '0', '0', '0', '0'),/*裹尸布*/
('90002', '0', '54590', '0', '0', '0', '0'),/*锐锋暮光龙鳞*/
('90002', '0', '50706', '0', '0', '0', '0'),/*瓶中的小憎恶*/
('90002', '0', '52572', '0', '0', '0', '0'),/*永恒力量之灰烬指环*/
('90002', '0', '50693', '0', '0', '0', '0');/*凋零之力*/

insert world.npc_vendor value/*猎人OK*/
('90003', '0', '51285', '0', '0', '0', '0'),/* [神圣安卡哈猎血护手]*/
('90003', '0', '51286', '0', '0', '0', '0'),/**/
('90003', '0', '51287', '0', '0', '0', '0'),/**/
('90003', '0', '51288', '0', '0', '0', '0'),/**/
('90003', '0', '51289', '0', '0', '0', '0'),/**/
('90003', '0', '54577', '0', '0', '0', '0'),/*天灾科学家长靴*/
('90003', '0', '50655', '0', '0', '0', '0'),/*天灾猎手臂铠*/
('90003', '0', '50688', '0', '0', '0', '0'),/*尼鲁巴尔猎手束带*/
('90003', '0', '50633', '0', '0', '0', '0'),/* [ [辛达苟萨的残酷之爪]]*/
('90003', '0', '50653', '0', '0', '0', '0'),/*秘室杀手斗篷*/
('90003', '0', '54576', '0', '0', '0', '0'),/*暮光徽记*/
('90003', '0', '50604', '0', '0', '0', '0'),/*白骨巨人指环*/
('90003', '0', '54590', '0', '0', '0', '0'),/*锐锋暮光龙鳞*/
('90003', '0', '50706', '0', '0', '0', '0'),/*瓶中的小憎恶*/
('90003', '0', '44448', '0', '0', '0', '0'),/*蛛魔强固箭袋*/
('90003', '0', '44447', '0', '0', '0', '0');/*龙鳞弹药包*/

insert world.npc_vendor value/*潜行者NOK*/
('90004', '0', '51250', '0', '0', '0', '0'),/* [ [神圣影刃头盔]]*/
('90004', '0', '51252', '0', '0', '0', '0'),/**/
('90004', '0', '51253', '0', '0', '0', '0'),/**/
('90004', '0', '51254', '0', '0', '0', '0'),/**/
('90004', '0', '51251', '0', '0', '0', '0'),/**/
('90004', '0', '50607', '0', '0', '0', '0'),/*[结霜皮靴]*/
('90004', '0', '54580', '0', '0', '0', '0'),/*荫影臂甲*/
('90004', '0', '50707', '0', '0', '0', '0'),/*阿斯崔里安的缝合腰带*/
('90004', '0', '50633', '0', '0', '0', '0'),/* [ [辛达苟萨的残酷之爪]]*/
('90004', '0', '50653', '0', '0', '0', '0'),/*秘室杀手斗篷*/
('90004', '0', '54576', '0', '0', '0', '0'),/*暮光徽记*/
('90004', '0', '50604', '0', '0', '0', '0'),/*白骨巨人指环*/
('90004', '0', '54590', '0', '0', '0', '0'),/*锐锋暮光龙鳞*/
('90004', '0', '50706', '0', '0', '0', '0');/*瓶中的小憎恶*/


insert world.npc_vendor value/*牧师OK*/
('90005', '0', '51260', '0', '0', '0', '0'),/* [ [ [神圣血色侍僧手套]]]*/
('90005', '0', '51261', '0', '0', '0', '0'),/**/
('90005', '0', '51262', '0', '0', '0', '0'),/**/
('90005', '0', '51263', '0', '0', '0', '0'),/**/
('90005', '0', '51264', '0', '0', '0', '0'),/**/
('90005', '0', '51850', '0', '0', '0', '0'),/* [陈尸长靴]*/
('90005', '0', '50686', '0', '0', '0', '0'),/*死亡医师的袖腕*/
('90005', '0', '50702', '0', '0', '0', '0'),/*顽疾束带*/
('90005', '0', '50609', '0', '0', '0', '0'),/* [ [冰冠斥候护符]]*/
('90005', '0', '50668', '0', '0', '0', '0'),/*叛变勇士的大氅*/
('90005', '0', '50720', '0', '0', '0', '0'),/*愈合血环*/
('90005', '0', '54585', '0', '0', '0', '0'),/*定相恢复之戒*/
('90005', '0', '50731', '0', '0', '0', '0'),/*安东尼达斯的圣杖*/
('90005', '0', '50631', '0', '0', '0', '0'),/*梦魇终结者*/
('90005', '0', '46017', '0', '0', '0', '0'),/*瓦兰奈尔，远古王者之锤*/
('90005', '0', '50719', '0', '0', '0', '0'),/* [影丝纺锤]*/
('90005', '0', '54589', '0', '0', '0', '0'),/*明亮暮光龙鳞*/
('90005', '0', '50726', '0', '0', '0', '0');/*纯血珠饰*/

insert world.npc_vendor value/*DK*/
('90006', '0', '40207', '0', '0', '0', '0'),/* [ [.add 40207// [警觉魔印]]]*/
('90006', '0', '50672', '0', '0', '0', '0'),/* [ [.additem 50672// [血毒长剑]]]]*/
('90006', '0', '51310', '0', '0', '0', '0'),/* [ [神圣天灾领主战盔]]*/
('90006', '0', '51311', '0', '0', '0', '0'),
('90006', '0', '51312', '0', '0', '0', '0'),
('90006', '0', '51313', '0', '0', '0', '0'),
('90006', '0', '51314', '0', '0', '0', '0'),
('90006', '0', '54578', '0', '0', '0', '0'),/*天启降临之靴*/
('90006', '0', '50659', '0', '0', '0', '0'),/*白熊之爪护腕*/
('90006', '0', '50620', '0', '0', '0', '0'),/*冷魂锁链*/
('90006', '0', '54581', '0', '0', '0', '0'),/*半影坠饰*/
('90006', '0', '50677', '0', '0', '0', '0'),/*裹尸布*/
('90006', '0', '54590', '0', '0', '0', '0'),/*锐锋暮光龙鳞*/
('90006', '0', '50706', '0', '0', '0', '0'),/*瓶中的小憎恶*/
('90006', '0', '52572', '0', '0', '0', '0'),/*永恒力量之灰烬指环*/
('90006', '0', '50693', '0', '0', '0', '0');/*凋零之力*/

insert world.npc_vendor value/*法师OK*/
('90008', '0', '51280', '0', '0', '0', '0'),/* [ [神圣血法战衣]]*/
('90008', '0', '51281', '0', '0', '0', '0'),/**/
('90008', '0', '51282', '0', '0', '0', '0'),/**/
('90008', '0', '51283', '0', '0', '0', '0'),/**/
('90008', '0', '51284', '0', '0', '0', '0'),/**/
('90008', '0', '50699', '0', '0', '0', '0'),/*天灾科学家长*/
('90008', '0', '54582', '0', '0', '0', '0'),/*火夜护腕*/
('90008', '0', '50613', '0', '0', '0', '0'),/*破碎冷魂腰带*/
('90008', '0', '50700', '0', '0', '0', '0'),/* [ [圣日的恩泽]]*/
('90008', '0', '54583', '0', '0', '0', '0'),/* [暮色蒸腾披风]*/
('90008', '0', '50714', '0', '0', '0', '0'),/*瓦拉纳的备用徽记之戒*/
('90008', '0', '50614', '0', '0', '0', '0'),/* [无尽迷宫指环]*/
('90008', '0', '50732', '0', '0', '0', '0'),/*血涌，克尔苏加德的苦痛之剑*/
('90008', '0', '50684', '0', '0', '0', '0'),/*贯体之刺*/
('90008', '0', '50719', '0', '0', '0', '0'),/* [影丝纺锤]*/
('90008', '0', '54588', '0', '0', '0', '0'),/* [焦黑暮光龙鳞]*/
('90008', '0', '50348', '0', '0', '0', '0');/* [被摘除的外物]*/

insert world.npc_vendor value/*SS OK*/
('90009', '0', '51230', '0', '0', '0', '0'),/* [ [ [神圣黑巫护腿]]]*/
('90009', '0', '51231', '0', '0', '0', '0'),/**/
('90009', '0', '51232', '0', '0', '0', '0'),/**/
('90009', '0', '51233', '0', '0', '0', '0'),/**/
('90009', '0', '51234', '0', '0', '0', '0'),/**/
('90009', '0', '50699', '0', '0', '0', '0'),/*天灾科学家长*/
('90009', '0', '54582', '0', '0', '0', '0'),/*火夜护腕*/
('90009', '0', '50613', '0', '0', '0', '0'),/*破碎冷魂腰带*/
('90009', '0', '50700', '0', '0', '0', '0'),/* [ [圣日的恩泽]]*/
('90009', '0', '54583', '0', '0', '0', '0'),/* [暮色蒸腾披风]*/
('90009', '0', '50714', '0', '0', '0', '0'),/*瓦拉纳的备用徽记之戒*/
('90009', '0', '50614', '0', '0', '0', '0'),/* [无尽迷宫指环]*/
('90009', '0', '50732', '0', '0', '0', '0'),/*血涌，克尔苏加德的苦痛之剑*/
('90009', '0', '50684', '0', '0', '0', '0'),/*贯体之刺*/
('90009', '0', '50719', '0', '0', '0', '0'),/* [影丝纺锤]*/
('90009', '0', '54588', '0', '0', '0', '0'),/* [焦黑暮光龙鳞]*/
('90009', '0', '50348', '0', '0', '0', '0');/* [被摘除的外物]*/

insert world.npc_vendor value/*德鲁伊 OK*/
('90010', '0', '54945', '0', '0', '0', '0'),/* [诺达希尔的污染嫩枝]*/
('90010', '0', '51295', '0', '0', '0', '0'),/* [ [ [神圣树纹]]]*/
('90010', '0', '51296', '0', '0', '0', '0'),/**/
('90010', '0', '51297', '0', '0', '0', '0'),/**/
('90010', '0', '51298', '0', '0', '0', '0'),/**/
('90010', '0', '51299', '0', '0', '0', '0'),/**/
('90010', '0', '50607', '0', '0', '0', '0'),/*[结霜皮靴]*/
('90010', '0', '54580', '0', '0', '0', '0'),/*荫影臂甲*/
('90010', '0', '50707', '0', '0', '0', '0'),/*阿斯崔里安的缝合腰带*/
('90010', '0', '50633', '0', '0', '0', '0'),/* [ [辛达苟萨的残酷之爪]]*/
('90010', '0', '50653', '0', '0', '0', '0'),/*秘室杀手斗篷*/
('90010', '0', '54576', '0', '0', '0', '0'),/*暮光徽记*/
('90010', '0', '50604', '0', '0', '0', '0'),/*白骨巨人指环*/
('90010', '0', '54590', '0', '0', '0', '0'),/*锐锋暮光龙鳞*/
('90010', '0', '50706', '0', '0', '0', '0');/*瓶中的小憎恶*/


insert world.npc_vendor value/*SM OK*/
('90007', '0', '51245', '0', '0', '0', '0'),/* [神圣霜巫]*/
('90007', '0', '51246', '0', '0', '0', '0'),/**/
('90007', '0', '51247', '0', '0', '0', '0'),/**/
('90007', '0', '51248', '0', '0', '0', '0'),/**/
('90007', '0', '51249', '0', '0', '0', '0'),/**/
('90007', '0', '50652', '0', '0', '0', '0'),/* [冥光胫甲]*/
('90007', '0', '50687', '0', '0', '0', '0'),/*.additem 50687// [血裂护腕]*/
('90007', '0', '54587', '0', '0', '0', '0'),/*.additem 54587//. [形影分离护带]*/
('90007', '0', '50700', '0', '0', '0', '0'),/* [ [圣日的恩泽]]*/
('90007', '0', '54583', '0', '0', '0', '0'),/* [暮色蒸腾披风]*/
('90007', '0', '50714', '0', '0', '0', '0'),/*瓦拉纳的备用徽记之戒*/
('90007', '0', '50614', '0', '0', '0', '0'),/* [无尽迷宫指环]*/
('90007', '0', '50719', '0', '0', '0', '0'),/* [影丝纺锤]*/
('90007', '0', '54588', '0', '0', '0', '0'),/* [焦黑暮光龙鳞]*/
('90007', '0', '50348', '0', '0', '0', '0');/* [被摘除的外物]*/


insert world.npc_vendor value /*好玩*/
('90012', '0', '33225', '0', '0', '0', '0'),/*幽灵虎*/
('90012', '0', '13335', '0', '0', '0', '0'),/*军马*/
('90012', '0', '13086', '0', '0', '0', '0'),/*冬泉豹*/
('90012', '0', '32458', '0', '0', '0', '0');/*凤凰*/

insert world.npc_vendor value /*其他*/
('90014', '0', '45862', '0', '0', '0', '0'),/*朴素风暴宝钻*/
('90014', '0', '42149', '0', '0', '0', '0'),/*圆润龙眼石*/
('90014', '0', '44452', '0', '0', '0', '0'),/*符文泰坦神铁棒*/
('90014', '0', '34055', '0', '0', '0', '0'),/*强效宇宙精华*/
('90014', '0', '34057', '0', '0', '0', '0'),/*深渊水晶*/
('90014', '0', '34054', '0', '0', '0', '0'),/*无限之尘*/
('90014', '0', '36918', '0', '0', '0', '0'),/*血玉石*/
('90014', '0', '34052', '0', '0', '0', '0'),/*梦境碎片*/
('90014', '0', '41163', '0', '0', '0', '0'),/*泰坦神铁锭*/
('90014', '0', '41266', '0', '0', '0', '0'),/*天焰钻石*/
('90014', '0', '41380', '0', '0', '0', '0'),/*多彩*/
('90014', '0', '41381', '0', '0', '0', '0'),/*多彩*/
('90014', '0', '41382', '0', '0', '0', '0'),/*多彩*/
('90014', '0', '41385', '0', '0', '0', '0'),/*多彩*/
('90014', '0', '41389', '0', '0', '0', '0'),/*多彩*/
('90014', '0', '41395', '0', '0', '0', '0'),/*多彩*/
('90014', '0', '41396', '0', '0', '0', '0'),/*多彩*/
('90014', '0', '41397', '0', '0', '0', '0'),/*多彩*/
('90014', '0', '41398', '0', '0', '0', '0'),/*多彩*/
('90014', '0', '41401', '0', '0', '0', '0'),/*多彩*/
('90014', '0', '40111', '0', '0', '0', '0'),/*红色*/
('90014', '0', '40112', '0', '0', '0', '0'),/*红色*/
('90014', '0', '40113', '0', '0', '0', '0'),/*红色*/
('90014', '0', '40114', '0', '0', '0', '0'),/*红色*/
('90014', '0', '40116', '0', '0', '0', '0'),/*红色*/
('90014', '0', '40118', '0', '0', '0', '0'),/*红色*/
('90014', '0', '40123', '0', '0', '0', '0'),/*红色*/
('90014', '0', '40119', '0', '0', '0', '0'),/*蓝色*/
('90014', '0', '40120', '0', '0', '0', '0'),/*蓝色*/
('90014', '0', '40121', '0', '0', '0', '0'),/*蓝色*/
('90014', '0', '40122', '0', '0', '0', '0'),/*蓝色*/
('90014', '0', '40125', '0', '0', '0', '0'),/*蓝色*/
('90014', '0', '40115', '0', '0', '0', '0'),/*黄色*/
('90014', '0', '40117', '0', '0', '0', '0'),/*黄色*/
('90014', '0', '40124', '0', '0', '0', '0'),/*黄色*/
('90014', '0', '40126', '0', '0', '0', '0'),/*黄色*/
('90014', '0', '40127', '0', '0', '0', '0'),/*黄色*/
('90014', '0', '41285', '0', '0', '0', '0');/*朴素风暴宝钻*/