createshoptemplate.sql

天之炼狱OpenDE_SQL.tar.gz

INSERT INTO ShopTemplate VALUES (2210, 0, 30, 0,2,0, 0, 219); # 轨颇捞绢 馆瘤
INSERT INTO ShopTemplate VALUES (2220, 0, 31, 0,2,0, 0, 219); # 轨颇捞绢 迫骂
INSERT INTO ShopTemplate VALUES (2230, 0, 32, 0,2,0, 0, 219); # 轨颇捞绢 格吧捞
INSERT INTO ShopTemplate VALUES (2235, 0, 41, 7,7,0, 0, 219); # 喉风靛而

INSERT INTO ShopTemplate VALUES (2240, 1, 30, 0,2,1,3, 219); # 轨颇捞绢 馆瘤
INSERT INTO ShopTemplate VALUES (2250, 1, 31, 0,2,1,3, 219); # 轨颇捞绢 迫骂
INSERT INTO ShopTemplate VALUES (2260, 1, 32, 0,2,1,3, 219); # 轨颇捞绢 格吧捞

INSERT INTO ShopTemplate VALUES (2270, 2, 33, 0,0,0,0, 219); # 轨颇捞绢 内飘
INSERT INTO ShopTemplate VALUES (2271, 2, 30, 0,0,0,0, 219); # 轨颇捞绢 馆瘤
INSERT INTO ShopTemplate VALUES (2272, 2, 31, 0,0,0,0, 219); # 轨颇捞绢 迫骂
INSERT INTO ShopTemplate VALUES (2273, 2, 32, 0,0,0,0, 219); # 轨颇捞绢 格吧捞 
INSERT INTO ShopTemplate VALUES (2274, 2, 42, 0,0,0,0, 219); # 轨颇捞绢 蓖吧捞
INSERT INTO ShopTemplate VALUES (2275, 2, 44, 0,0,0,0, 219); # 轨颇捞绢 呈努
INSERT INTO ShopTemplate VALUES (2276, 2, 45, 0,0,0,0, 219); # 轨颇捞绢 厚靛


#######################################################
# 惯饭府 - BASIC
INSERT INTO ShopTemplate VALUES (2310, 0, 33, 0,5,0,0, 94); # 轨颇捞绢 内飘
# 惯饭府 - SPECIAL
INSERT INTO ShopTemplate VALUES (2320, 1, 33, 0,3,1,3, 94); # 轨颇捞绢 内飘

#######################################################
# 饭海墨 - BASIC
INSERT INTO ShopTemplate VALUES (2400, 0, 44, 0,2,0,0, 255); # 呈努
INSERT INTO ShopTemplate VALUES (2401, 0, 45, 0,2,0,0, 255); # 厚靛
INSERT INTO ShopTemplate VALUES (2402, 1, 44, 0,2,2,3, 255); # 呈努
INSERT INTO ShopTemplate VALUES (2403, 1, 45, 0,2,2,3, 255); # 厚靛

INSERT INTO ShopTemplate VALUES (2410,0,30,0,2,0,0,220);
INSERT INTO ShopTemplate VALUES (2420,0,31,0,2,0,0,220);
INSERT INTO ShopTemplate VALUES (2430,0,32,0,2,0,0,220);
INSERT INTO ShopTemplate VALUES (2435,0,36,0,3,0,0,220);
INSERT INTO ShopTemplate VALUES (2436,0,37,0,1,0,0,220);
INSERT INTO ShopTemplate VALUES (2440,1,30,0,2,1,3,220);
INSERT INTO ShopTemplate VALUES (2450,1,31,0,2,1,3,220);
INSERT INTO ShopTemplate VALUES (2460,1,32,0,2,1,3,220);


#######################################################
# 墨颇萍聪 - BASIC 
INSERT INTO ShopTemplate VALUES (2535, 0, 36, 0,3,0,0, 93); # 轨颇捞绢 趋没
INSERT INTO ShopTemplate VALUES (2536, 0, 37, 0,1,0,0, 93); # 函脚酒捞袍
INSERT INTO ShopTemplate VALUES (2537, 0, 39, 3,5,0,0, 93); # 荐沥
INSERT INTO ShopTemplate VALUES (2538, 0, 39, 0,2,0,0, 93); # 荐沥



######################################################
## 夸茄 - BASIC
INSERT INTO ShopTemplate VALUES (2610, 0, 1,0,9,0,0,101);
INSERT INTO ShopTemplate VALUES (2620, 0, 2,0,2,0,0,101);
INSERT INTO ShopTemplate VALUES (2630, 0, 4,0,0,0,0,101);
INSERT INTO ShopTemplate VALUES (2640, 0, 4,2,2,0,0,101);
INSERT INTO ShopTemplate VALUES (2650, 0, 4,4,4,0,0,101);
INSERT INTO ShopTemplate VALUES (2660, 0, 4,6,6,0,0,101);


######################################################
# 混扼膏歹 - BASIC
INSERT INTO ShopTemplate VALUES (2710, 0, 1, 0,9,0,0,98); # 器记
INSERT INTO ShopTemplate VALUES (2720, 0, 2, 0,2,0,0,98); # 拱捍
INSERT INTO ShopTemplate VALUES (2730, 0, 4, 0,0,0,0,98); # 藕芒
INSERT INTO ShopTemplate VALUES (2740, 0, 4, 2,2,0,0,98); # 藕芒
INSERT INTO ShopTemplate VALUES (2750, 0, 4, 4,4,0,0,98); # 藕芒
INSERT INTO ShopTemplate VALUES (2760, 0, 4, 6,6,0,0,98); # 藕芒


######################################################
# 教 - BASIC
INSERT INTO ShopTemplate VALUES (2810, 0, 1, 0,9,0,0,13); # 拱距
INSERT INTO ShopTemplate VALUES (2820, 0, 2, 0,6,0,0,13); # 拱捍
#INSERT INTO ShopTemplate VALUES (2830, 0, 4, 0,0,0,0,13); # 藕芒
#INSERT INTO ShopTemplate VALUES (2840, 0, 4, 2,2,0,0,13); # 藕芒
#INSERT INTO ShopTemplate VALUES (2850, 0, 4, 4,4,0,0,13); # 藕芒
#INSERT INTO ShopTemplate VALUES (2860, 0, 4, 6,6,0,0,13); # 藕芒



###############################################################
# 单聪胶 - BASIC
INSERT INTO ShopTemplate VALUES (2900, 0,  1, 0, 1, 0, 0, 297);
INSERT INTO ShopTemplate VALUES (2901, 0,  1, 5, 6, 0, 0, 297);
INSERT INTO ShopTemplate VALUES (2902, 0,  2, 0, 0, 0, 0, 297);
INSERT INTO ShopTemplate VALUES (2903, 0,  4, 0, 0, 0, 0, 297);
INSERT INTO ShopTemplate VALUES (2904, 0,  4, 2, 2, 0, 0, 297);
INSERT INTO ShopTemplate VALUES (2905, 0,  4, 4, 4, 0, 0, 297);
INSERT INTO ShopTemplate VALUES (2906, 0,  4, 6, 6, 0, 0, 297);

# 单聪胶 - SPECIAL
INSERT INTO ShopTemplate VALUES (2915, 1, 11, 0, 1, 1, 2, 297);
INSERT INTO ShopTemplate VALUES (2916, 1, 12, 0, 1, 1, 2, 297);
INSERT INTO ShopTemplate VALUES (2917, 1,  8, 0, 0, 1, 2, 297);
INSERT INTO ShopTemplate VALUES (2918, 1,  9, 0, 0, 1, 2, 297);
INSERT INTO ShopTemplate VALUES (2919, 1, 10, 0, 0, 1, 2, 297);
INSERT INTO ShopTemplate VALUES (2920, 1, 19, 0, 0, 1, 2, 297);
INSERT INTO ShopTemplate VALUES (2921, 1, 13, 0, 0, 1, 2, 297);
INSERT INTO ShopTemplate VALUES (2922, 1, 26, 0, 0, 1, 2, 297);
  
##############################################################
# 具付葛配 - BASIC
INSERT INTO ShopTemplate VALUES (3000, 0,  1,0,1,0,0,296);
INSERT INTO ShopTemplate VALUES (3001, 0,  1,5,6,0,0,296);
INSERT INTO ShopTemplate VALUES (3002, 0,  2,0,0,0,0,296);
INSERT INTO ShopTemplate VALUES (3003, 0,  4,0,0,0,0,296);
INSERT INTO ShopTemplate VALUES (3004, 0,  4,2,2,0,0,296);
INSERT INTO ShopTemplate VALUES (3005, 0,  4,4,4,0,0,296);
INSERT INTO ShopTemplate VALUES (3006, 0,  4,6,6,0,0,296);
INSERT INTO ShopTemplate VALUES (3007, 0, 11,0,1,0,0,296);
INSERT INTO ShopTemplate VALUES (3008, 0, 12,0,1,0,0,296);
INSERT INTO ShopTemplate VALUES (3009, 0,  8,0,0,0,0,296);
INSERT INTO ShopTemplate VALUES (3010, 0,  9,0,0,0,0,296);
INSERT INTO ShopTemplate VALUES (3011, 0, 10,0,0,0,0,296);
INSERT INTO ShopTemplate VALUES (3012, 0, 19,0,0,0,0,296);
INSERT INTO ShopTemplate VALUES (3013, 0, 13,0,0,0,0,296);
INSERT INTO ShopTemplate VALUES (3014, 0, 26,0,0,0,0,296);
 
INSERT INTO ShopTemplate VALUES (3015, 1, 11,0,1,1,3,296);
INSERT INTO ShopTemplate VALUES (3016, 1, 12,0,1,1,3,296);
INSERT INTO ShopTemplate VALUES (3017, 1,  8,0,0,1,3,296);
INSERT INTO ShopTemplate VALUES (3018, 1,  9,0,0,1,3,296);
INSERT INTO ShopTemplate VALUES (3019, 1, 10,0,0,1,3,296);
INSERT INTO ShopTemplate VALUES (3020, 1, 19,0,0,1,3,296);
INSERT INTO ShopTemplate VALUES (3021, 1, 13,0,0,1,3,296);
INSERT INTO ShopTemplate VALUES (3022, 1, 26,0,0,1,3,296);

#########################################################
# 辰矫 - BASIC
INSERT INTO ShopTemplate VALUES (3201, 0, 11,0,1,0,0,303);
INSERT INTO ShopTemplate VALUES (3202, 0, 12,0,1,0,0,303);
INSERT INTO ShopTemplate VALUES (3203, 0, 26,0,0,0,0,303);
INSERT INTO ShopTemplate VALUES (3204, 0, 19,0,0,0,0,303);
# 辰矫 - SPECIAL
INSERT INTO ShopTemplate VALUES (3205, 1, 11,0,1,1,2,303);
INSERT INTO ShopTemplate VALUES (3206, 1, 12,0,1,1,2,303);
INSERT INTO ShopTemplate VALUES (3207, 1, 26,0,0,1,2,303);
INSERT INTO ShopTemplate VALUES (3208, 1, 19,0,0,1,2,303);


#########################################################
# 抛府 - BASIC
INSERT INTO ShopTemplate VALUES (3301, 0, 13, 0,0,0,0,302);
INSERT INTO ShopTemplate VALUES (3302, 0, 18, 0,0,0,0,302);
INSERT INTO ShopTemplate VALUES (3303, 0, 16, 0,0,0,0,302);
# 抛府 - SPECIAL
INSERT INTO ShopTemplate VALUES (3304, 1, 13, 0,0,1,2,302);
INSERT INTO ShopTemplate VALUES (3305, 1, 18, 0,0,1,2,302);
INSERT INTO ShopTemplate VALUES (3306, 1, 16, 0,0,1,2,302);


INSERT INTO ShopTemplate VALUES (3101,0,8,0,0,0,0,311);
INSERT INTO ShopTemplate VALUES (3102,0,9,0,0,0,0,311);
INSERT INTO ShopTemplate VALUES (3103,0,10,0,0,0,0,311);
INSERT INTO ShopTemplate VALUES (3106,1,8,0,0,1,2,311);
INSERT INTO ShopTemplate VALUES (3107,1,9,0,0,1,2,311);
INSERT INTO ShopTemplate VALUES (3108,1,10,0,0,1,2,311);
INSERT INTO ShopTemplate VALUES (4000,1,8,2,6,0,0,17);
INSERT INTO ShopTemplate VALUES (4001,1,9,2,6,0,0,17);
INSERT INTO ShopTemplate VALUES (4002,1,10,2,6,0,0,17);
INSERT INTO ShopTemplate VALUES (4003,1,8,2,6,0,0,157);
INSERT INTO ShopTemplate VALUES (4004,1,9,2,6,0,0,157);
INSERT INTO ShopTemplate VALUES (4005,1,10,2,6,0,0,157);
INSERT INTO ShopTemplate VALUES (4006,1,30,2,6,0,0,92);
INSERT INTO ShopTemplate VALUES (4007,1,31,2,6,0,0,92);
INSERT INTO ShopTemplate VALUES (4008,1,32,2,6,0,0,92);


#######################################################
# 酒弊匙 - BASIC
INSERT INTO ShopTemplate VALUES (4110, 0, 33, 0,5,0,0, 362);  # 轨颇捞绢 内飘 
INSERT INTO ShopTemplate VALUES (4115, 1, 33, 0,3,1,4, 362);  # 轨颇捞绢 内飘 



#######################################################
# 橇府具 - BASIC
INSERT INTO ShopTemplate VALUES (4210, 0, 30, 0,2,0,0, 365); # 轨颇捞绢 馆瘤
INSERT INTO ShopTemplate VALUES (4220, 0, 31, 0,2,0,0, 365); # 轨颇捞绢 迫骂
INSERT INTO ShopTemplate VALUES (4230, 0, 32, 0,2,0,0, 365); # 轨颇捞绢 格吧捞
INSERT INTO ShopTemplate VALUES (4240, 0, 41, 7,2,0,0, 365); # 喉风靛酚
INSERT INTO ShopTemplate VALUES (4250, 1, 30, 0,2,1,4, 365); # 轨颇捞绢 馆瘤
INSERT INTO ShopTemplate VALUES (4260, 1, 31, 0,2,1,4, 365); # 轨颇捞绢 迫骂
INSERT INTO ShopTemplate VALUES (4270, 1, 32, 0,2,1,4, 365); # 轨颇捞绢 格吧捞
# 橇府具 - GAMBLE
INSERT INTO ShopTemplate VALUES (4280, 2, 33, 0,0,0,0, 365); # 轨颇捞绢 内飘
INSERT INTO ShopTemplate VALUES (4281, 2, 30, 0,0,0,0, 365); # 轨颇捞绢 馆瘤
INSERT INTO ShopTemplate VALUES (4282, 2, 31, 0,0,0,0, 365); # 轨颇捞绢 迫骂
INSERT INTO ShopTemplate VALUES (4283, 2, 32, 0,0,0,0, 365); # 轨颇捞绢 格吧捞 
INSERT INTO ShopTemplate VALUES (4284, 2, 42, 0,0,0,0, 365); # 轨颇捞绢 蓖吧捞
INSERT INTO ShopTemplate VALUES (4285, 2, 44, 0,0,0,0, 365); # 轨颇捞绢 呈努
INSERT INTO ShopTemplate VALUES (4286, 2, 45, 0,0,0,0, 365); # 轨颇捞绢 厚靛




#######################################################
# 饭捞红 - BASIC
INSERT INTO ShopTemplate VALUES (4310, 0, 33, 2,5,0, 0, 370);
# 饭捞红 - SPECAIL
INSERT INTO ShopTemplate VALUES (4320, 1, 33, 2,3,3,4, 370);


#######################################################
# 墨福膏 - BASIC
INSERT INTO ShopTemplate VALUES (4511, 0,  1, 0,9,0,0,430); # 器记
INSERT INTO ShopTemplate VALUES (4512, 0,  2, 0,2,0,0,430); # 拱捍
INSERT INTO ShopTemplate VALUES (4513, 0,  4, 1,1,0,0,430); # 藕芒
INSERT INTO ShopTemplate VALUES (4514, 0,  4, 3,3,0,0,430); # 藕芒
INSERT INTO ShopTemplate VALUES (4515, 0,  4, 5,5,0,0,430); # 藕芒
INSERT INTO ShopTemplate VALUES (4516, 0,  4, 7,7,0,0,430); # 藕芒
INSERT INTO ShopTemplate VALUES (4517, 0, 41, 7,7,0,0,430); # 喉风靛而
# 墨福膏 - 白喉
INSERT INTO ShopTemplate VALUES (4521, 2, 11, 0,0,0,0,430); # 内飘
INSERT INTO ShopTemplate VALUES (4522, 2, 12, 0,0,0,0,430); # 官瘤
INSERT INTO ShopTemplate VALUES (4523, 2, 13, 0,0,0,0,430); # 脚惯
INSERT INTO ShopTemplate VALUES (4524, 2, 18, 0,0,0,0,430); # 厘癌
INSERT INTO ShopTemplate VALUES (4525, 2, 19, 0,0,0,0,430); # 秋镐
INSERT INTO ShopTemplate VALUES (4526, 2,  8, 0,0,0,0,430); # 馆瘤
INSERT INTO ShopTemplate VALUES (4527, 2,  9, 0,0,0,0,430); # 迫骂
INSERT INTO ShopTemplate VALUES (4528, 2, 10, 0,0,0,0,430); # 格吧捞
INSERT INTO ShopTemplate VALUES (4529, 2, 26, 0,0,0,0,430); # 骇飘
INSERT INTO ShopTemplate VALUES (4530, 2, 14, 3,3,0,0,430); # 八
INSERT INTO ShopTemplate VALUES (4531, 2, 15, 0,0,0,0,430); # 档
INSERT INTO ShopTemplate VALUES (4532, 2, 16, 2,2,0,0,430); # 规菩
INSERT INTO ShopTemplate VALUES (4533, 2, 17, 0,0,0,0,430); # 皋捞胶
INSERT INTO ShopTemplate VALUES (4534, 2, 35, 0,0,0,0,430); # 皋捞胶
INSERT INTO ShopTemplate VALUES (4535, 2, 20, 0,0,0,0,430); # SG
INSERT INTO ShopTemplate VALUES (4536, 2, 21, 0,0,0,0,430); # SMG
INSERT INTO ShopTemplate VALUES (4537, 2, 22, 0,0,0,0,430); # AR
INSERT INTO ShopTemplate VALUES (4538, 2, 23, 0,0,0,0,430); # SR



#######################################################
# 肺后 - BASIC
INSERT INTO ShopTemplate VALUES (4600, 0,  8, 0,  2,0, 0, 428); # 馆瘤
INSERT INTO ShopTemplate VALUES (4601, 0,  9, 0,  2,0, 0, 428); # 迫骂
INSERT INTO ShopTemplate VALUES (4602, 0, 10, 0,  2,0, 0, 428); # 格吧捞
INSERT INTO ShopTemplate VALUES (4606, 0,  4,16, 23,0, 0, 428); # 藕芒
# 肺后 - SPECIAL
INSERT INTO ShopTemplate VALUES (4603, 1,  8, 0,2,1,4, 428); # 馆瘤
INSERT INTO ShopTemplate VALUES (4604, 1,  9, 0,2,1,4, 428); # 迫骂
INSERT INTO ShopTemplate VALUES (4605, 1, 10, 0,2,1,4, 428); # 格吧捞



########################################################
## 赣乔 - BASIC