createshoptemplate.sql

天之炼狱OpenDE_SQL.tar.gz

INSERT INTO ShopTemplate VALUES (5021, 0, 30, 0,3,0, 0,  429); # 轨颇捞绢馆瘤
INSERT INTO ShopTemplate VALUES (5022, 0, 31, 0,3,0, 0,  429); # 轨颇捞绢迫骂
INSERT INTO ShopTemplate VALUES (5023, 0, 32, 0,3,0, 0,  429); # 轨颇捞绢 格吧捞
INSERT INTO ShopTemplate VALUES (5031, 0, 41, 7,7,0, 0,  429); # 喉风靛而
# 赣乔 - SPECIAL
INSERT INTO ShopTemplate VALUES (5028, 1, 30, 0,3,2,4,  429); # 轨颇捞绢馆瘤
INSERT INTO ShopTemplate VALUES (5029, 1, 31, 0,3,2,4,  429); # 轨颇捞绢迫骂
INSERT INTO ShopTemplate VALUES (5030, 1, 32, 0,3,2,4,  429); # 轨颇捞绢 格吧捞
# 赣乔 - GAMBLE
INSERT INTO ShopTemplate VALUES (5041, 2, 33, 0,0,0, 0,  429); # 轨颇捞绢 内飘
INSERT INTO ShopTemplate VALUES (5042, 2, 30, 0,0,0, 0,  429); # 轨颇捞绢 馆瘤
INSERT INTO ShopTemplate VALUES (5043, 2, 31, 0,0,0, 0,  429); # 轨颇捞绢 迫骂
INSERT INTO ShopTemplate VALUES (5044, 2, 32, 0,0,0, 0,  429); # 轨颇捞绢 格吧捞 
INSERT INTO ShopTemplate VALUES (5045, 2, 42, 0,0,0, 0,  429); # 轨颇捞绢 蓖吧捞
INSERT INTO ShopTemplate VALUES (5046, 2, 44, 0,0,0, 0,  429); # 轨颇捞绢 呈努
INSERT INTO ShopTemplate VALUES (5047, 2, 45, 0,0,0, 0,  429); # 轨颇捞绢 厚靛


#######################################################
# 墨烙 - BASIC
INSERT INTO ShopTemplate VALUES (5100, 0, 44, 3,5,0,0, 364);  # 呈努
INSERT INTO ShopTemplate VALUES (5101, 0, 45, 2,3,0,0, 364);  # 厚靛
# 墨烙 - SPECIAL
INSERT INTO ShopTemplate VALUES (5110, 1, 44, 3,5,1,4, 364);  # 呈努
INSERT INTO ShopTemplate VALUES (5111, 1, 45, 2,3,1,4, 364);  # 厚靛


#######################################################
# 酒捞父 - BASIC
INSERT INTO ShopTemplate VALUES (5200, 0, 36, 0,3,0,0, 363);  # 趋没
INSERT INTO ShopTemplate VALUES (5201, 0, 37, 0,1,0,0, 363);  # 函脚酒捞袍
INSERT INTO ShopTemplate VALUES (5202, 0, 39, 6,8,0,0, 363);  # 荐沥
INSERT INTO ShopTemplate VALUES (5203, 0, 39, 0,2,0,0, 363);  # 荐沥


#######################################################
# 弊府乔胶 - BASIC
INSERT INTO ShopTemplate VALUES (5300, 0, 36, 0, 3,0,0, 427);  # 趋没
INSERT INTO ShopTemplate VALUES (5301, 0, 37, 0, 1,0,0, 427);  # 函脚酒捞袍
INSERT INTO ShopTemplate VALUES (5302, 0, 39, 9,11,0,0, 427);  # 荐沥
INSERT INTO ShopTemplate VALUES (5303, 0, 39, 0, 2,0,0, 427);  # 荐沥


#######################################################
# 胶配具畴橇 - SPECIAL
#######################################################
INSERT INTO ShopTemplate VALUES (5400, 1, 8, 4, 7, 255, 255, 164);  #


#######################################################
# 酒淬狼 己瘤 包访 Slayer NPC
#######################################################
# 酒老赴(白喉) 苛鸥何胶己
INSERT INTO ShopTemplate VALUES (5510, 0,  1, 3, 4,0,0,519); # 器记
INSERT INTO ShopTemplate VALUES (5511, 0,  1, 8, 9,0,0,519); # 器记
INSERT INTO ShopTemplate VALUES (5512, 0,  1,12,13,0,0,519); # 器记
INSERT INTO ShopTemplate VALUES (5513, 0,  2, 0, 2,0,0,519); # 拱捍
INSERT INTO ShopTemplate VALUES (5514, 0,  4, 1, 1,0,0,519); # 藕芒
INSERT INTO ShopTemplate VALUES (5515, 0,  4, 3, 3,0,0,519); # 藕芒
INSERT INTO ShopTemplate VALUES (5516, 0,  4, 5, 5,0,0,519); # 藕芒
INSERT INTO ShopTemplate VALUES (5517, 0,  4, 7, 7,0,0,519); # 藕芒
INSERT INTO ShopTemplate VALUES (5518, 0,  4, 9, 9,0,0,519); # 藕芒
INSERT INTO ShopTemplate VALUES (5519, 0,  4,11,11,0,0,519); # 藕芒
INSERT INTO ShopTemplate VALUES (5520, 0,  4,13,13,0,0,519); # 藕芒
INSERT INTO ShopTemplate VALUES (5521, 0,  4,15,15,0,0,519); # 藕芒
# 浇饭捞绢 白喉
INSERT INTO ShopTemplate VALUES (5522, 2, 11, 0,0,0,0,519); # 内飘
INSERT INTO ShopTemplate VALUES (5523, 2, 12, 0,0,0,0,519); # 官瘤
INSERT INTO ShopTemplate VALUES (5524, 2, 13, 0,0,0,0,519); # 脚惯
INSERT INTO ShopTemplate VALUES (5525, 2, 18, 0,0,0,0,519); # 厘癌
INSERT INTO ShopTemplate VALUES (5526, 2, 19, 0,0,0,0,519); # 秋镐
INSERT INTO ShopTemplate VALUES (5527, 2,  8, 0,0,0,0,519); # 馆瘤
INSERT INTO ShopTemplate VALUES (5528, 2,  9, 0,0,0,0,519); # 迫骂
INSERT INTO ShopTemplate VALUES (5529, 2, 10, 0,0,0,0,519); # 格吧捞
INSERT INTO ShopTemplate VALUES (5530, 2, 26, 0,0,0,0,519); # 骇飘
INSERT INTO ShopTemplate VALUES (5531, 2, 14, 3,3,0,0,519); # 八
INSERT INTO ShopTemplate VALUES (5532, 2, 15, 0,0,0,0,519); # 档
INSERT INTO ShopTemplate VALUES (5533, 2, 16, 2,2,0,0,519); # 规菩
INSERT INTO ShopTemplate VALUES (5534, 2, 17, 0,0,0,0,519); # 皋捞胶
INSERT INTO ShopTemplate VALUES (5535, 2, 35, 0,0,0,0,519); # 皋捞胶
INSERT INTO ShopTemplate VALUES (5536, 2, 20, 0,0,0,0,519); # SG
INSERT INTO ShopTemplate VALUES (5537, 2, 21, 0,0,0,0,519); # SMG
INSERT INTO ShopTemplate VALUES (5538, 2, 22, 0,0,0,0,519); # AR
INSERT INTO ShopTemplate VALUES (5539, 2, 23, 0,0,0,0,519); # S519R

# 舅坊 苛鸥何胶己
INSERT INTO ShopTemplate VALUES (5611, 0, 15, 2,3,0,0,521); # 档
INSERT INTO ShopTemplate VALUES (5612, 0, 14, 2,3,0,0,521); # 八
INSERT INTO ShopTemplate VALUES (5613, 0, 23, 2,3,0,0,521); # SR
INSERT INTO ShopTemplate VALUES (5614, 0, 21, 2,3,0,0,521); # SMG
INSERT INTO ShopTemplate VALUES (5615, 0, 20, 2,3,0,0,521); # SG
INSERT INTO ShopTemplate VALUES (5616, 0, 22, 2,3,0,0,521); # AR
INSERT INTO ShopTemplate VALUES (5617, 0, 17, 2,3,0,0,521); # CROSS
INSERT INTO ShopTemplate VALUES (5618, 0, 35, 2,3,0,0,521); # MACE

INSERT INTO ShopTemplate VALUES (5619, 1, 15, 2,3,2,4,521); # 档
INSERT INTO ShopTemplate VALUES (5620, 1, 14, 2,3,2,4,521); # 八
INSERT INTO ShopTemplate VALUES (5621, 1, 23, 2,3,2,4,521); # SR
INSERT INTO ShopTemplate VALUES (5622, 1, 21, 2,3,2,4,521); # SMG
INSERT INTO ShopTemplate VALUES (5623, 1, 20, 2,3,2,4,521); # SG
INSERT INTO ShopTemplate VALUES (5624, 1, 22, 2,3,2,4,521); # AR
INSERT INTO ShopTemplate VALUES (5625, 1, 17, 2,3,2,4,521); # CROSS
INSERT INTO ShopTemplate VALUES (5626, 1, 35, 2,3,2,4,521); # MACE

# 林叼胶(白喉) 剂萍公胶己
INSERT INTO ShopTemplate VALUES (5710, 0,  1, 3, 4,0,0,522); # 器记
INSERT INTO ShopTemplate VALUES (5711, 0,  1, 8, 9,0,0,522); # 器记
INSERT INTO ShopTemplate VALUES (5712, 0,  1,12,13,0,0,522); # 器记
INSERT INTO ShopTemplate VALUES (5713, 0,  2, 0, 2,0,0,522); # 拱捍
INSERT INTO ShopTemplate VALUES (5714, 0,  4, 1, 1,0,0,522); # 藕芒
INSERT INTO ShopTemplate VALUES (5715, 0,  4, 3, 3,0,0,522); # 藕芒
INSERT INTO ShopTemplate VALUES (5716, 0,  4, 5, 5,0,0,522); # 藕芒
INSERT INTO ShopTemplate VALUES (5717, 0,  4, 7, 7,0,0,522); # 藕芒
INSERT INTO ShopTemplate VALUES (5718, 0,  4, 9, 9,0,0,522); # 藕芒
INSERT INTO ShopTemplate VALUES (5719, 0,  4,11,11,0,0,522); # 藕芒
INSERT INTO ShopTemplate VALUES (5720, 0,  4,13,13,0,0,522); # 藕芒
INSERT INTO ShopTemplate VALUES (5721, 0,  4,15,15,0,0,522); # 藕芒
# 浇饭捞绢 白喉
INSERT INTO ShopTemplate VALUES (5722, 2, 11, 0,0,0,0,522); # 内飘
INSERT INTO ShopTemplate VALUES (5723, 2, 12, 0,0,0,0,522); # 官瘤
INSERT INTO ShopTemplate VALUES (5724, 2, 13, 0,0,0,0,522); # 脚惯
INSERT INTO ShopTemplate VALUES (5725, 2, 18, 0,0,0,0,522); # 厘癌
INSERT INTO ShopTemplate VALUES (5726, 2, 19, 0,0,0,0,522); # 秋镐
INSERT INTO ShopTemplate VALUES (5727, 2,  8, 0,0,0,0,522); # 馆瘤
INSERT INTO ShopTemplate VALUES (5728, 2,  9, 0,0,0,0,522); # 迫骂
INSERT INTO ShopTemplate VALUES (5729, 2, 10, 0,0,0,0,522); # 格吧捞
INSERT INTO ShopTemplate VALUES (5730, 2, 26, 0,0,0,0,522); # 骇飘
INSERT INTO ShopTemplate VALUES (5731, 2, 14, 3,3,0,0,522); # 八
INSERT INTO ShopTemplate VALUES (5732, 2, 15, 0,0,0,0,522); # 档
INSERT INTO ShopTemplate VALUES (5733, 2, 16, 2,2,0,0,522); # 规菩
INSERT INTO ShopTemplate VALUES (5734, 2, 17, 0,0,0,0,522); # 皋捞胶
INSERT INTO ShopTemplate VALUES (5735, 2, 35, 0,0,0,0,522); # 皋捞胶
INSERT INTO ShopTemplate VALUES (5736, 2, 20, 0,0,0,0,522); # SG
INSERT INTO ShopTemplate VALUES (5737, 2, 21, 0,0,0,0,522); # SMG
INSERT INTO ShopTemplate VALUES (5738, 2, 22, 0,0,0,0,522); # AR
INSERT INTO ShopTemplate VALUES (5739, 2, 23, 0,0,0,0,522); # SR

# 橇府靛腐 剂萍公胶己
INSERT INTO ShopTemplate VALUES (5811, 0,  8, 1,3,0,0,523); # 馆瘤
INSERT INTO ShopTemplate VALUES (5812, 0,  9, 1,3,0,0,523); # 迫骂
INSERT INTO ShopTemplate VALUES (5813, 0, 10, 1,3,0,0,523); # 格吧捞

INSERT INTO ShopTemplate VALUES (5814, 1,  8, 1,3,2,4,523); # 馆瘤
INSERT INTO ShopTemplate VALUES (5815, 1,  9, 1,3,2,4,523); # 迫骂
INSERT INTO ShopTemplate VALUES (5816, 1, 10, 1,3,2,4,523); # 格吧捞


#######################################################
# 酒淬狼 己瘤 包访 Vampire NPC
#######################################################
# 海酒飘腐胶 抛福萍快胶己
INSERT INTO ShopTemplate VALUES (6531, 0, 36, 0, 3,0,0,518); # 轨颇捞绢 趋没
INSERT INTO ShopTemplate VALUES (6532, 0, 36, 6, 6,0,0,518); # 轨颇捞绢 趋没
INSERT INTO ShopTemplate VALUES (6533, 0, 37, 0, 1,0,0,518); # 函脚酒捞袍
#INSERT INTO ShopTemplate VALUES (6534, 0, 39,12,14,0,0,518); # 荐沥
#INSERT INTO ShopTemplate VALUES (6535, 0, 39, 0, 2,0,0,518); # 荐沥

# 付府(白喉) 抛福萍快胶己
INSERT INTO ShopTemplate VALUES (6671, 0, 30, 1,3,0, 0,  516); # 轨颇捞绢 馆瘤
INSERT INTO ShopTemplate VALUES (6672, 0, 31, 1,3,0, 0,  516); # 轨颇捞绢 迫骂
INSERT INTO ShopTemplate VALUES (6673, 0, 32, 1,3,0, 0,  516); # 轨颇捞绢 格吧捞 
INSERT INTO ShopTemplate VALUES (6674, 0, 45, 2,4,0, 0,  516); # 轨颇捞绢 厚靛

INSERT INTO ShopTemplate VALUES (6675, 1, 30, 1,3,2, 4,  516); # 轨颇捞绢 馆瘤
INSERT INTO ShopTemplate VALUES (6676, 1, 31, 1,3,2, 4,  516); # 轨颇捞绢 迫骂
INSERT INTO ShopTemplate VALUES (6677, 1, 32, 1,3,2, 4,  516); # 轨颇捞绢 格吧捞 
INSERT INTO ShopTemplate VALUES (6678, 1, 45, 2,4,2, 4,  516); # 轨颇捞绢 厚靛
# 轨颇捞绢 白喉
INSERT INTO ShopTemplate VALUES (6679, 2, 33, 0,0,0, 0,  516); # 轨颇捞绢 内飘
INSERT INTO ShopTemplate VALUES (6680, 2, 30, 0,0,0, 0,  516); # 轨颇捞绢 馆瘤
INSERT INTO ShopTemplate VALUES (6681, 2, 31, 0,0,0, 0,  516); # 轨颇捞绢 迫骂
INSERT INTO ShopTemplate VALUES (6682, 2, 32, 0,0,0, 0,  516); # 轨颇捞绢 格吧捞 
INSERT INTO ShopTemplate VALUES (6683, 2, 42, 0,0,0, 0,  516); # 轨颇捞绢 蓖吧捞
INSERT INTO ShopTemplate VALUES (6684, 2, 44, 0,0,0, 0,  516); # 轨颇捞绢 呈努
INSERT INTO ShopTemplate VALUES (6685, 2, 45, 0,0,0, 0,  516); # 轨颇捞绢 厚靛


# 酒固(白喉) 捻酒福捧胶己
INSERT INTO ShopTemplate VALUES (6771, 0, 33, 2,7,0,0, 520); # 轨颇捞绢 内飘
INSERT INTO ShopTemplate VALUES (6772, 1, 33, 2,5,2,4, 520); # 轨颇捞绢 内飘
# 轨颇捞绢 白喉
INSERT INTO ShopTemplate VALUES (6773, 2, 33, 0,0,0, 0,  520); # 轨颇捞绢 内飘
INSERT INTO ShopTemplate VALUES (6774, 2, 30, 0,0,0, 0,  520); # 轨颇捞绢 馆瘤
INSERT INTO ShopTemplate VALUES (6775, 2, 31, 0,0,0, 0,  520); # 轨颇捞绢 迫骂
INSERT INTO ShopTemplate VALUES (6776, 2, 32, 0,0,0, 0,  520); # 轨颇捞绢 格吧捞 
INSERT INTO ShopTemplate VALUES (6777, 2, 42, 0,0,0, 0,  520); # 轨颇捞绢 蓖吧捞
INSERT INTO ShopTemplate VALUES (6778, 2, 44, 0,0,0, 0,  520); # 轨颇捞绢 呈努
INSERT INTO ShopTemplate VALUES (6779, 2, 45, 0,0,0, 0,  520); # 轨颇捞绢 厚靛

# 隔废 捻酒福捧胶己
INSERT INTO ShopTemplate VALUES (6831, 0, 36, 0, 3,0,0,517); # 轨颇捞绢 趋没
INSERT INTO ShopTemplate VALUES (6832, 0, 36, 6, 6,0,0,517); # 轨颇捞绢 趋没
INSERT INTO ShopTemplate VALUES (6833, 0, 37, 0, 1,0,0,517); # 函脚酒捞袍
#INSERT INTO ShopTemplate VALUES (6834, 0, 39,15,17,0,0,517); # 荐沥
#INSERT INTO ShopTemplate VALUES (6835, 0, 39, 0, 2,0,0,517); # 荐沥

#######################################################
# 酒快胶磐胶 付阑 NPC Shop
#######################################################
# 府颇萍
INSERT INTO ShopTemplate VALUES (6901, 0, 66, 0, 4,0,0,654); # 扼官
INSERT INTO ShopTemplate VALUES (6902, 0, 67, 0, 4,0,0,654); # 仟颇
INSERT INTO ShopTemplate VALUES (6903, 0, 68, 0, 4,0,0,654); # 皋捞
INSERT INTO ShopTemplate VALUES (6904, 0, 69, 0, 2,0,0,654); # 家券籍

# 付匙胶捻
INSERT INTO ShopTemplate VALUES (7101, 0, 59, 0, 2,0,0,655); # 酒快胶磐令 铆农恩
INSERT INTO ShopTemplate VALUES (7102, 0, 65, 0, 2,0,0,655); # 酒快胶磐令 阂府胶撇复
INSERT INTO ShopTemplate VALUES (7103, 0, 65,10,12,0,0,655); # 酒快胶磐令 拱府胶撇复
INSERT INTO ShopTemplate VALUES (7104, 0, 65,20,22,0,0,655); # 酒快胶磐令 措瘤府胶撇复

INSERT INTO ShopTemplate VALUES (7105, 1, 59, 0, 2,1,4,655); # 酒快胶磐令 铆农恩
INSERT INTO ShopTemplate VALUES (7106, 1, 65, 0, 2,1,4,655); # 酒快胶磐令 阂府胶撇复
INSERT INTO ShopTemplate VALUES (7107, 1, 65,10,12,1,4,655); # 酒快胶磐令 拱府胶撇复
INSERT INTO ShopTemplate VALUES (7108, 1, 65,20,22,1,4,655); # 酒快胶磐令 措瘤府胶撇复

# 酒付鸥
INSERT INTO ShopTemplate VALUES (6911, 0, 63, 0, 2,0,0,657); # 酒快胶磐令 傅
INSERT INTO ShopTemplate VALUES (6912, 0, 62, 0, 2,0,0,657); # 酒快胶磐令 奇带飘
INSERT INTO ShopTemplate VALUES (6913, 0, 60, 0, 2,0,0,657); # 酒快胶磐令 辑努复

INSERT INTO ShopTemplate VALUES (6914, 1, 63, 0, 2,1,4,657); # 酒快胶磐令 傅
INSERT INTO ShopTemplate VALUES (6915, 1, 62, 0, 2,1,4,657); # 酒快胶磐令 奇带飘
INSERT INTO ShopTemplate VALUES (6916, 1, 60, 0, 2,1,4,657); # 酒快胶磐令 辑努复

INSERT INTO ShopTemplate VALUES (6917, 0, 41, 7, 7,0,0,657); # 喉风靛而

# 胺喉
INSERT INTO ShopTemplate VALUES (7109, 2, 61, 0, 0,0,0,657); # 酒快胶磐令 内飘
INSERT INTO ShopTemplate VALUES (7110, 2, 58, 0, 0,0,0,657); # 酒快胶磐令 何明
INSERT INTO ShopTemplate VALUES (7111, 2, 59, 0, 0,0,0,657); # 酒快胶磐令 铆农恩
INSERT INTO ShopTemplate VALUES (7112, 2, 65, 0, 0,0,0,657); # 酒快胶磐令 阂府胶撇复
INSERT INTO ShopTemplate VALUES (7113, 2, 60, 0, 0,0,0,657); # 酒快胶磐令 辑努复
INSERT INTO ShopTemplate VALUES (7114, 2, 57, 0, 0,0,0,657); # 酒快胶磐令 鞠胶龟靛
INSERT INTO ShopTemplate VALUES (7115, 2, 62, 0, 0,0,0,657); # 酒快胶磐令 奇带飘
INSERT INTO ShopTemplate VALUES (7116, 2, 63, 0, 0,0,0,657); # 酒快胶磐令 傅


# 龋扼
INSERT INTO ShopTemplate VALUES (7001, 0, 61, 0, 2,0,0,658); # 酒快胶磐令 内飘
INSERT INTO ShopTemplate VALUES (7002, 0, 58, 0, 2,0,0,658); # 酒快胶磐令 何明
INSERT INTO ShopTemplate VALUES (7003, 0, 57, 0, 2,0,0,658); # 酒快胶磐令 鞠胶龟靛

INSERT INTO ShopTemplate VALUES (7004, 1, 61, 0, 2,1,4,658); # 酒快胶磐令 内飘
INSERT INTO ShopTemplate VALUES (7005, 1, 58, 0, 2,1,4,658); # 酒快胶磐令 何明
INSERT INTO ShopTemplate VALUES (7006, 1, 57, 0, 2,1,4,658); # 酒快胶磐令 鞠胶龟靛