Ko-yardim Reklam Alanı

img acıklama
img acıklama
img acıklama
img acıklama

[KO-YARDIM ÖZEL] Tüm ITEM Tablosunu ve Tüm ITEM_UPGRADE Tablosunu Düzenleme [Low-Middle-High Class Ayrımlı]

A

Acceleration

KY Üye
Katılım
10 Ocak 2023
Mesajlar
7
Tepkime puanı
1
Puanları
13
Öncelikle ITEM tablosunu düzenleyeceğiz.

1) ITEM tablosunun içeriğini temizliyoruz.

Kod: 
--------
--------
Delete from ITEM
--------
--------

2) Ekteki ITEM_1.txt ve ITEM_2.txt dosyalarını indirip Query Analyzer'a uygulayınız.


Konu aşağıdan devam etmektedir.
 

Ekli dosyalar

  • ITEM_1.txt
    8.6 MB · Görüntüleme: 31
  • ITEM_2.txt
    9.4 MB · Görüntüleme: 22
A

Acceleration

KY Üye
Katılım
10 Ocak 2023
Mesajlar
7
Tepkime puanı
1
Puanları
13
3) Aşağıdaki link'ten TBL dosyalarını indiriniz ve client'ın DATA klasörünün içine aktarınız. Bu TBL dosyaları yukarıdaki ITEM tablosuyla uyumludur. TBL dosyalarını DATA klasörünün içine aktarmazsanız birtakım item'ları göremezsiniz.

Gizli içeriği görüntüleme kayıtlı kullanıcılar için mevcuttur!


* İsteyenler ekteki TBL.txt dosyasını indirebilir ve bir TBL editor yardımıyla yukarıdaki TBL dosyalarını edit'leyebilir. Ama yukarıdaki link'ten TBL dosyalarını indirdiyseniz TBL edit'lemenize gerek yoktur.




4) Moradon'a silahların ve kıyafetlerin satıldığı NPC'leri ekleyebiliriz. Bu NPC'lerde Horn Crossbow, Sword Breaker, Plate Armor'lar gibi item'lar satılmaktadır.

Kod: 
-------- Kaikei Unkei Gosaku Mokichi ---------

delete from k_npc where ssid = '30001' 
delete from k_npc where ssid = '30002' 
delete from k_npc where ssid = '30003' 
delete from k_npc where ssid = '30004' 

insert into [K_NPC] values ('30001','Kaikei [Weapons] {L}','22200','100','0','0','1','7','21','1','0','1','201701','50','100','300','30000','0','0','5000','130','130','1000','1500','2','5','1000','0','0','0','250','250','250','250','250','250','250','90','7','14','25','15000','30001','0','0','1');
insert into [K_NPC] values ('30002','Unkei [Weapons] {M}','22200','100','0','0','1','7','21','1','0','1','201801','50','100','300','30000','0','0','5000','130','130','1000','1500','2','5','1000','0','0','0','250','250','250','250','250','250','250','90','7','14','25','15000','30002','0','0','1');

insert into [K_NPC] values ('30003','Gosaku [Armors] {L}','12200','100','0','0','2','1','21','1','0','1','202701','50','100','300','30000','0','0','5000','130','130','1000','1500','2','5','1000','0','0','0','250','250','250','250','250','250','250','90','7','14','25','15000','30003','0','0','1');
insert into [K_NPC] values ('30004','Mokichi [Armors] {M}','12200','100','0','0','2','1','21','1','0','1','202801','50','100','300','30000','0','0','5000','130','130','1000','1500','2','5','1000','0','0','0','250','250','250','250','250','250','250','90','7','14','25','15000','30004','0','0','1');




delete from k_npcpos where npcid = '30001' and zoneid = '21'
delete from k_npcpos where npcid = '30002' and zoneid = '21'
delete from k_npcpos where npcid = '30003' and zoneid = '21'
delete from k_npcpos where npcid = '30004' and zoneid = '21'


insert into [K_NPCPOS] values ('21','30002','100','0','0','0','0','398','363','398','363','0','0','0','0','1','30','-120','0','NULL');
insert into [K_NPCPOS] values ('21','30001','100','0','0','0','0','398','359','398','359','0','0','0','0','1','30','-120','0','NULL');

insert into [K_NPCPOS] values ('21','30003','100','0','0','0','0','398','371','398','371','0','0','0','0','1','30','-120','0','NULL');
insert into [K_NPCPOS] values ('21','30004','100','0','0','0','0','398','375','398','375','0','0','0','0','1','30','-120','0','NULL');

--------
--------




5) Birtakım grup droplar aşağıda verilmiştir.

Kod: 
--------
--------

Delete from MAKE_ITEM_GROUP where iItemGroupNum >= '1000' AND iItemGroupNum <= '1999'



insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1010','120110701','120150701','125210701','125250701','389010000','120110701','120150701','125210701','125250701','389010000','120110701','120150701','125210701','125250701','389010000','120110701','120150701','125210701','125250701','389010000','120110701','120150701','125210701','125250701','389010000','120110701','120150701','125210701','125250701','389010000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1011','120110721','120150721','125210721','125250721','389010000','120110721','120150721','125210721','125250721','389010000','120110721','120150721','125210721','125250721','389010000','120110721','120150721','125210721','125250721','389010000','120110721','120150721','125210721','125250721','389010000','120110721','120150721','125210721','125250721','389010000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1012','110110701','120310701','125310701','180110701','160100701','110150701','120350701','125350701','180150701','160150701','201001701','201002701','201003701','201004701','201005701','241001701','241002701','241003701','241004701','241005701','261001701','261002701','261003701','261004701','261005701','281001701','281002701','281003701','281004701','281005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1013','110110701','120310701','125310701','150210701','160100701','110150701','120350701','125350701','150250701','160150701','201001701','201002701','201003701','201004701','201005701','241001701','241002701','241003701','241004701','241005701','261001701','261002701','261003701','261004701','261005701','281001701','281002701','281003701','281004701','281005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1014','110110721','120310721','125310721','180110721','160100721','110150721','120350721','125350721','180150721','160150721','201001701','201002701','201003701','201004701','201005701','241001701','241002701','241003701','241004701','241005701','261001701','261002701','261003701','261004701','261005701','281001701','281002701','281003701','281004701','281005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1015','110110721','120310721','125310721','150210721','160100721','110150721','120350721','125350721','150250721','160150721','201001701','201002701','201003701','201004701','201005701','241001701','241002701','241003701','241004701','241005701','261001701','261002701','261003701','261004701','261005701','281001701','281002701','281003701','281004701','281005701');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1020','120110702','120150702','125210702','125250702','389010000','120110702','120150702','125210702','125250702','389010000','120110702','120150702','125210702','125250702','389010000','120110702','120150702','125210702','125250702','389010000','120110702','120150702','125210702','125250702','389010000','120110702','120150702','125210702','125250702','389010000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1021','120110722','120150722','125210722','125250722','389010000','120110722','120150722','125210722','125250722','389010000','120110722','120150722','125210722','125250722','389010000','120110722','120150722','125210722','125250722','389010000','120110722','120150722','125210722','125250722','389010000','120110722','120150722','125210722','125250722','389010000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1022','110110702','120310702','125310702','180110702','160100702','110150702','120350702','125350702','180150702','160150702','201001703','201002703','201003703','201004703','201005703','241001703','241002703','241003703','241004703','241005703','261001703','261002703','261003703','261004703','261005703','281001703','281002703','281003703','281004703','281005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1023','110110702','120310702','125310702','150210702','160100702','110150702','120350702','125350702','150250702','160150702','201001703','201002703','201003703','201004703','201005703','241001703','241002703','241003703','241004703','241005703','261001703','261002703','261003703','261004703','261005703','281001703','281002703','281003703','281004703','281005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1024','110110722','120310722','125310722','180110722','160100722','110150722','120350722','125350722','180150722','160150722','201001703','201002703','201003703','201004703','201005703','241001703','241002703','241003703','241004703','241005703','261001703','261002703','261003703','261004703','261005703','281001703','281002703','281003703','281004703','281005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1025','110110722','120310722','125310722','150210722','160100722','110150722','120350722','125350722','150250722','160150722','201001703','201002703','201003703','201004703','201005703','241001703','241002703','241003703','241004703','241005703','261001703','261002703','261003703','261004703','261005703','281001703','281002703','281003703','281004703','281005703');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1030','120110703','120150703','125210703','125250703','389010000','120110703','120150703','125210703','125250703','389010000','120110703','120150703','125210703','125250703','389010000','120110703','120150703','125210703','125250703','389010000','120110703','120150703','125210703','125250703','389010000','120110703','120150703','125210703','125250703','389010000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1031','120110723','120150723','125210723','125250723','389010000','120110723','120150723','125210723','125250723','389010000','120110723','120150723','125210723','125250723','389010000','120110723','120150723','125210723','125250723','389010000','120110723','120150723','125210723','125250723','389010000','120110723','120150723','125210723','125250723','389010000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1032','110110703','120310703','125310703','180110703','160100703','110150703','120350703','125350703','180150703','160150703','201001705','201002705','201003705','201004705','201005705','241001705','241002705','241003705','241004705','241005705','261001705','261002705','261003705','261004705','261005705','281001705','281002705','281003705','281004705','281005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1033','110110703','120310703','125310703','150210703','160100703','110150703','120350703','125350703','150250703','160150703','201001705','201002705','201003705','201004705','201005705','241001705','241002705','241003705','241004705','241005705','261001705','261002705','261003705','261004705','261005705','281001705','281002705','281003705','281004705','281005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1034','110110723','120310723','125310723','180110723','160100723','110150723','120350723','125350723','180150723','160150723','201001705','201002705','201003705','201004705','201005705','241001705','241002705','241003705','241004705','241005705','261001705','261002705','261003705','261004705','261005705','281001705','281002705','281003705','281004705','281005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1035','110110723','120310723','125310723','150210723','160100723','110150723','120350723','125350723','150250723','160150723','201001705','201002705','201003705','201004705','201005705','241001705','241002705','241003705','241004705','241005705','261001705','261002705','261003705','261004705','261005705','281001705','281002705','281003705','281004705','281005705');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1066','110110706','120110707','120310706','370004000','389038000','110150706','120150707','120350706','370005000','389039000','125210707','125310706','150210706','370006000','389040000','125250707','125350706','150250706','379002000','389026000','160100706','180110706','379006000','379003000','389023000','160150706','180150706','389033000','379004000','389050000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1067','110110707','120110727','120310707','370004000','389038000','110150707','120150727','120350707','370005000','389039000','125210727','125310707','150210707','370006000','389040000','125250727','125350707','150250707','379002000','389026000','160100707','180110707','379006000','379003000','389023000','160150707','180150707','389033000','379004000','389050000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1068','110110707','120110728','120310707','370004000','389038000','110150707','120150728','120350707','370005000','389039000','125210728','125310707','150210707','370006000','389040000','125250728','125350707','150250707','379002000','389026000','160100707','180110707','379006000','379003000','389023000','160150707','180150707','389033000','379004000','389050000');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1110','110410701','120510701','125610701','130210701','389010000','110450701','120550701','125650701','130250701','389011000','140210701','145310701','150410701','155310701','379001000','140250701','145350701','150450701','155350701','370004000','180310701','190210701','135310701','160210701','370005000','180350701','190250701','135350701','160250701','370006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1111','110410721','120510721','125610721','130210721','389010000','110450721','120550721','125650721','130250721','389011000','140210721','145310721','150410721','155310721','379001000','140250721','145350721','150450721','155350721','370004000','180310721','190210721','135310721','160210721','370005000','180350721','190250721','135350721','160250721','370006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1112','110610701','120710701','125810701','130410701','135510701','140410701','160410701','170110701','180510701','190410701','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1113','110610701','120710701','125810701','145510701','150610701','155510701','160410701','170110701','180510701','190410701','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1114','110650701','120750701','125850701','130450701','135550701','140450701','160450701','170150701','180550701','190450701','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1115','110650701','120750701','125850701','145550701','150650701','155550701','160450701','170150701','180550701','190450701','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1116','110610721','120710721','125810721','130410721','135510721','140410721','160410721','170110721','180510721','190410721','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1117','110610721','120710721','125810721','145510721','150610721','155510721','160410721','170110721','180510721','190410721','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1118','110650721','120750721','125850721','130450721','135550721','140450721','160450721','170150721','180550721','190450721','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1119','110650721','120750721','125850721','145550721','150650721','155550721','160450721','170150721','180550721','190450721','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1120','110410702','120510702','125610702','130210702','389010000','110450702','120550702','125650702','130250702','389011000','140210702','145310702','150410702','155310702','379001000','140250702','145350702','150450702','155350702','370004000','180310702','190210702','135310702','160210702','370005000','180350702','190250702','135350702','160250702','370006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1121','110410722','120510722','125610722','130210722','389010000','110450722','120550722','125650722','130250722','389011000','140210722','145310722','150410722','155310722','379001000','140250722','145350722','150450722','155350722','370004000','180310722','190210722','135310722','160210722','370005000','180350722','190250722','135350722','160250722','370006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1122','110610702','120710702','125810702','130410702','135510702','140410702','160410702','170110702','180510702','190410702','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1123','110610702','120710702','125810702','145510702','150610702','155510702','160410702','170110702','180510702','190410702','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1124','110650702','120750702','125850702','130450702','135550702','140450702','160450702','170150702','180550702','190450702','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1125','110650702','120750702','125850702','145550702','150650702','155550702','160450702','170150702','180550702','190450702','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1126','110610722','120710722','125810722','130410722','135510722','140410722','160410722','170110722','180510722','190410722','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1127','110610722','120710722','125810722','145510722','150610722','155510722','160410722','170110722','180510722','190410722','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1128','110650722','120750722','125850722','130450722','135550722','140450722','160450722','170150722','180550722','190450722','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1129','110650722','120750722','125850722','145550722','150650722','155550722','160450722','170150722','180550722','190450722','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1130','110410703','120510703','125610703','130210703','389010000','110450703','120550703','125650703','130250703','389011000','140210703','145310703','150410703','155310703','379001000','140250703','145350703','150450703','155350703','370004000','180310703','190210703','135310703','160210703','370005000','180350703','190250703','135350703','160250703','370006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1131','110410723','120510723','125610723','130210723','389010000','110450723','120550723','125650723','130250723','389011000','140210723','145310723','150410723','155310723','379001000','140250723','145350723','150450723','155350723','370004000','180310723','190210723','135310723','160210723','370005000','180350723','190250723','135350723','160250723','370006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1132','110610703','120710703','125810703','130410703','135510703','140410703','160410703','170110703','180510703','190410703','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1133','110610703','120710703','125810703','145510703','150610703','155510703','160410703','170110703','180510703','190410703','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1134','110650703','120750703','125850703','130450703','135550703','140450703','160450703','170150703','180550703','190450703','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1135','110650703','120750703','125850703','145550703','150650703','155550703','160450703','170150703','180550703','190450703','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1136','110610723','120710723','125810723','130410723','135510723','140410723','160410723','170110723','180510723','190410723','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1137','110610723','120710723','125810723','145510723','150610723','155510723','160410723','170110723','180510723','190410723','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1138','110650723','120750723','125850723','130450723','135550723','140450723','160450723','170150723','180550723','190450723','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1139','110650723','120750723','125850723','145550723','150650723','155550723','160450723','170150723','180550723','190450723','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');





insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1210','110710701','120810701','125910701','130610701','389010000','135710701','140610701','145710701','130650701','389011000','135750701','140650701','145750701','150710701','389012000','155710701','160610701','170210701','180610701','379001000','155750701','160650701','170250701','190610701','379002000','379006000','389065000','389023000','190650701','389033000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1211','110710721','120810721','125910721','130610721','389010000','135710721','140610721','145710721','130650721','389011000','135750721','140650721','145750721','150710721','389012000','155710721','160610721','170210721','180610721','379001000','155750721','160650721','170250721','190610721','379002000','379006000','389065000','389023000','190650721','389033000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1212','110810701','120910701','126010701','130710701','135810701','140710701','168110701','170310701','180710701','190710701','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1213','110810701','120910701','126010701','145810701','150810701','155810701','168110701','170310701','180710701','190710701','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1214','110810701','120910701','126010701','130710701','135810701','140710701','168150701','170350701','180710701','190710701','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1215','110810701','120910701','126010701','145810701','150810701','155810701','168150701','170350701','180710701','190710701','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1216','110810721','120910721','126010721','130710721','135810721','140710721','168110721','170310721','180710721','190710721','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1217','110810721','120910721','126010721','145810721','150810721','155810721','168110721','170310721','180710721','190710721','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1218','110810721','120910721','126010721','130710721','135810721','140710721','168150721','170350721','180710721','190710721','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1219','110810721','120910721','126010721','145810721','150810721','155810721','168150721','170350721','180710721','190710721','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1220','110710702','120810702','125910702','130610702','389010000','135710702','140610702','145710702','130650702','389011000','135750702','140650702','145750702','150710702','389012000','155710702','160610702','170210702','180610702','379001000','155750702','160650702','170250702','190610702','379002000','379006000','389065000','389023000','190650702','389033000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1221','110710722','120810722','125910722','130610722','389010000','135710722','140610722','145710722','130650722','389011000','135750722','140650722','145750722','150710722','389012000','155710722','160610722','170210722','180610722','379001000','155750722','160650722','170250722','190610722','379002000','379006000','389065000','389023000','190650722','389033000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1222','110810702','120910702','126010702','130710702','135810702','140710702','168110702','170310702','180710702','190710702','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1223','110810702','120910702','126010702','145810702','150810702','155810702','168110702','170310702','180710702','190710702','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1224','110810702','120910702','126010702','130710702','135810702','140710702','168150702','170350702','180710702','190710702','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1225','110810702','120910702','126010702','145810702','150810702','155810702','168150702','170350702','180710702','190710702','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1226','110810722','120910722','126010722','130710722','135810722','140710722','168110722','170310722','180710722','190710722','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1227','110810722','120910722','126010722','145810722','150810722','155810722','168110722','170310722','180710722','190710722','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1228','110810722','120910722','126010722','130710722','135810722','140710722','168150722','170350722','180710722','190710722','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1229','110810722','120910722','126010722','145810722','150810722','155810722','168150722','170350722','180710722','190710722','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1230','110710703','120810703','125910703','130610703','389010000','135710703','140610703','145710703','130650703','389011000','135750703','140650703','145750703','150710703','389012000','155710703','160610703','170210703','180610703','379001000','155750703','160650703','170250703','190610703','379002000','379006000','389065000','389023000','190650703','389033000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1231','110710723','120810723','125910723','130610723','389010000','135710723','140610723','145710723','130650723','389011000','135750723','140650723','145750723','150710723','389012000','155710723','160610723','170210723','180610723','379001000','155750723','160650723','170250723','190610723','379002000','379006000','389065000','389023000','190650723','389033000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1232','110810703','120910703','126010703','130710703','135810703','140710703','168110703','170310703','180710703','190710703','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1233','110810703','120910703','126010703','145810703','150810703','155810703','168110703','170310703','180710703','190710703','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1234','110810703','120910703','126010703','130710703','135810703','140710703','168150703','170350703','180710703','190710703','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1235','110810703','120910703','126010703','145810703','150810703','155810703','168150703','170350703','180710703','190710703','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1236','110810723','120910723','126010723','130710723','135810723','140710723','168110723','170310723','180710723','190710723','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1237','110810723','120910723','126010723','145810723','150810723','155810723','168110723','170310723','180710723','190710723','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1238','110810723','120910723','126010723','130710723','135810723','140710723','168150723','170350723','180710723','190710723','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1239','110810723','120910723','126010723','145810723','150810723','155810723','168150723','170350723','180710723','190710723','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1310','110810701','120910701','126010701','130710701','389026000','135810701','140710701','145810701','150810701','370004000','155810701','168110701','170310701','180710701','370005000','190710701','168150701','170350701','389076000','389038000','379110000','379109000','389033000','389074000','389039000','389065000','379006000','389023000','389075000','389040000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1311','110810721','120910721','126010721','130710721','389026000','135810721','140710721','145810721','150810721','370004000','155810721','168110721','170310721','180710721','370005000','190710721','168150721','170350721','389076000','389038000','379110000','379109000','389033000','389074000','389039000','389065000','379006000','389023000','389075000','389040000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1312','121010801','135910801','130810801','168210801','170410801','180810801','190810801','389074000','389075000','389076000','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1313','110910801','126110801','140810801','145910801','168210801','150910801','180810801','389074000','389075000','389076000','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1314','180810801','110910801','135910801','155910801','145910801','168210801','126110801','389074000','389075000','389076000','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1315','121010801','135910801','130810801','168250801','170450801','180810801','190810801','389074000','389075000','389076000','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1316','110910801','126110801','140810801','145910801','168250801','150910801','180810801','389074000','389075000','389076000','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1317','180810801','110910801','135910801','155910801','145910801','168250801','126110801','389074000','389075000','389076000','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1320','110810702','120910702','126010702','130710702','389026000','135810702','140710702','145810702','150810702','370004000','155810702','168110702','170310702','180710702','370005000','190710702','168150702','170350702','389076000','389038000','379110000','379109000','389033000','389074000','389039000','389065000','379006000','389023000','389075000','389040000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1321','110810722','120910722','126010722','130710722','389026000','135810722','140710722','145810722','150810722','370004000','155810722','168110722','170310722','180710722','370005000','190710722','168150722','170350722','389076000','389038000','379110000','379109000','389033000','389074000','389039000','389065000','379006000','389023000','389075000','389040000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1322','121010802','135910802','130810802','168210802','170410802','180810802','190810802','389074000','389075000','389076000','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1323','110910802','126110802','140810802','145910802','168210802','150910802','180810802','389074000','389075000','389076000','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1324','180810802','110910802','135910802','155910802','145910802','168210802','126110802','389074000','389075000','389076000','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1325','121010802','135910802','130810802','168250802','170450802','180810802','190810802','389074000','389075000','389076000','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1326','110910802','126110802','140810802','145910802','168250802','150910802','180810802','389074000','389075000','389076000','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1327','180810802','110910802','135910802','155910802','145910802','168250802','126110802','389074000','389075000','389076000','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1330','110810703','120910703','126010703','130710703','389026000','135810703','140710703','145810703','150810703','370004000','155810703','168110703','170310703','180710703','370005000','190710703','168150703','170350703','389076000','389038000','379110000','379109000','389033000','389074000','389039000','389065000','379006000','389023000','389075000','389040000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1331','110810723','120910723','126010723','130710723','389026000','135810723','140710723','145810723','150810723','370004000','155810723','168110723','170310723','180710723','370005000','190710723','168150723','170350723','389076000','389038000','379110000','379109000','389033000','389074000','389039000','389065000','379006000','389023000','389075000','389040000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1332','121010803','135910803','130810803','168210803','170410803','180810803','190810803','389074000','389075000','389076000','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1333','110910803','126110803','140810803','145910803','168210803','150910803','180810803','389074000','389075000','389076000','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1334','180810803','110910803','135910803','155910803','145910803','168210803','126110803','389074000','389075000','389076000','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1335','121010803','135910803','130810803','168250803','170450803','180810803','190810803','389074000','389075000','389076000','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1336','110910803','126110803','140810803','145910803','168250803','150910803','180810803','389074000','389075000','389076000','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1337','180810803','110910803','135910803','155910803','145910803','168250803','126110803','389074000','389075000','389076000','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1361','121010801','135910801','130810801','168210801','170410801','180810801','190810801','150910801','126110801','140810801','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1362','110910801','135910801','130810801','168210801','155910801','180810801','190810801','150910801','126110801','145910801','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1363','121010801','135910801','130810801','168250801','170450801','180810801','190810801','150910801','126110801','140810801','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1364','110910801','135910801','130810801','168250801','155910801','180810801','190810801','150910801','126110801','145910801','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1371','121010802','135910802','130810802','168210802','170410802','180810802','190810802','150910802','126110802','140810802','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1372','110910802','135910802','130810802','168210802','155910802','180810802','190810802','150910802','126110802','145910802','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1373','121010802','135910802','130810802','168250802','170450802','180810802','190810802','150910802','126110802','140810802','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1374','110910802','135910802','130810802','168250802','155910802','180810802','190810802','150910802','126110802','145910802','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1381','121010803','135910803','130810803','168210803','170410803','180810803','190810803','150910803','126110803','140810803','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1382','110910803','135910803','130810803','168210803','155910803','180810803','190810803','150910803','126110803','145910803','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1383','121010803','135910803','130810803','168250803','170450803','180810803','190810803','150910803','126110803','140810803','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1384','110910803','135910803','130810803','168250803','155910803','180810803','190810803','150910803','126110803','145910803','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1410','110910801','121010801','126110801','130810801','389038000','135910801','140810801','145910801','150910801','389039000','155910801','168210801','170410801','180810801','389040000','190810801','168250801','170450801','389074000','389050000','389065000','389023000','389083000','389075000','389014000','389033000','389026000','379109000','389076000','379006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1411','121110801','136010801','130910801','168210801','171510801','180910801','190910801','126210801','151010801','140910801','205001901','205002901','205003901','205004901','205005901','245001901','245002901','245003901','245004901','245005901','265001901','265002901','265003901','265004901','265005901','285001901','285002901','285003901','285004901','285005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1412','156010801','136010801','130910801','168210801','111010801','180910801','190910801','126210801','151010801','146010801','205001901','205002901','205003901','205004901','205005901','245001901','245002901','245003901','245004901','245005901','265001901','265002901','265003901','265004901','265005901','285001901','285002901','285003901','285004901','285005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1413','121110801','136010801','130910801','168250801','171550801','180910801','190910801','126210801','151010801','140910801','205001901','205002901','205003901','205004901','205005901','245001901','245002901','245003901','245004901','245005901','265001901','265002901','265003901','265004901','265005901','285001901','285002901','285003901','285004901','285005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1414','156010801','136010801','130910801','168250801','111010801','180910801','190910801','126210801','151010801','146010801','205001901','205002901','205003901','205004901','205005901','245001901','245002901','245003901','245004901','245005901','265001901','265002901','265003901','265004901','265005901','285001901','285002901','285003901','285004901','285005901');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1420','110910802','121010802','126110802','130810802','389038000','135910802','140810802','145910802','150910802','389039000','155910802','168210802','170410802','180810802','389040000','190810802','168250802','170450802','389074000','389050000','389065000','389023000','389083000','389075000','389014000','389033000','389026000','379109000','389076000','379006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1421','121110802','136010802','130910802','168210802','171510802','180910802','190910802','126210802','151010802','140910802','205001903','205002903','205003903','205004903','205005903','245001903','245002903','245003903','245004903','245005903','265001903','265002903','265003903','265004903','265005903','285001903','285002903','285003903','285004903','285005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1422','156010802','136010802','130910802','168210802','111010802','180910802','190910802','126210802','151010802','146010802','205001903','205002903','205003903','205004903','205005903','245001903','245002903','245003903','245004903','245005903','265001903','265002903','265003903','265004903','265005903','285001903','285002903','285003903','285004903','285005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1423','121110802','136010802','130910802','168250802','171550802','180910802','190910802','126210802','151010802','140910802','205001903','205002903','205003903','205004903','205005903','245001903','245002903','245003903','245004903','245005903','265001903','265002903','265003903','265004903','265005903','285001903','285002903','285003903','285004903','285005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1424','156010802','136010802','130910802','168250802','111010802','180910802','190910802','126210802','151010802','146010802','205001903','205002903','205003903','205004903','205005903','245001903','245002903','245003903','245004903','245005903','265001903','265002903','265003903','265004903','265005903','285001903','285002903','285003903','285004903','285005903');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1430','110910803','121010803','126110803','130810803','389038000','135910803','140810803','145910803','150910803','389039000','155910803','168210803','170410803','180810803','389040000','190810803','168250803','170450803','389074000','389050000','389065000','389023000','389083000','389075000','389014000','389033000','389026000','379109000','389076000','379006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1431','121110803','136010803','130910803','168210803','171510803','180910803','190910803','126210803','151010803','140910803','205001905','205002905','205003905','205004905','205005905','245001905','245002905','245003905','245004905','245005905','265001905','265002905','265003905','265004905','265005905','285001905','285002905','285003905','285004905','285005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1432','156010803','136010803','130910803','168210803','111010803','180910803','190910803','126210803','151010803','146010803','205001905','205002905','205003905','205004905','205005905','245001905','245002905','245003905','245004905','245005905','265001905','265002905','265003905','265004905','265005905','285001905','285002905','285003905','285004905','285005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1433','121110803','136010803','130910803','168250803','171550803','180910803','190910803','126210803','151010803','140910803','205001905','205002905','205003905','205004905','205005905','245001905','245002905','245003905','245004905','245005905','265001905','265002905','265003905','265004905','265005905','285001905','285002905','285003905','285004905','285005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1434','156010803','136010803','130910803','168250803','111010803','180910803','190910803','126210803','151010803','146010803','205001905','205002905','205003905','205004905','205005905','245001905','245002905','245003905','245004905','245005905','265001905','265002905','265003905','265004905','265005905','285001905','285002905','285003905','285004905','285005905');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1510','111010801','121110801','126210801','130910801','389050000','136010801','140910801','146010801','151010801','389026000','156010801','168210801','171510801','180910801','389033000','389038000','168250801','171550801','190910801','389075000','389039000','379109000','389014000','379006000','389074000','389040000','389083000','379004000','389065000','389076000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1511','121210901','126310901','131010901','136110901','141010901','151110901','156110901','168310901','181010901','191010901','205001901','205002901','205003901','205004901','205005901','245001901','245002901','245003901','245004901','245005901','265001901','265002901','265003901','265004901','265005901','285001901','285002901','285003901','285004901','285005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1512','111110901','126310901','131010901','136110901','146110901','151110901','156110901','168310901','181010901','191010901','205001901','205002901','205003901','205004901','205005901','245001901','245002901','245003901','245004901','245005901','265001901','265002901','265003901','265004901','265005901','285001901','285002901','285003901','285004901','285005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1513','121210901','126310901','131010901','136110901','141010901','151110901','156110901','168310901','181010901','191010901','206001901','206002901','206003901','206004901','206005901','246001901','246002901','246003901','246004901','246005901','266001901','266002901','266003901','266004901','266005901','286001901','286002901','286003901','286004901','286005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1514','111110901','126310901','131010901','136110901','146110901','151110901','156110901','168310901','181010901','191010901','206001901','206002901','206003901','206004901','206005901','246001901','246002901','246003901','246004901','246005901','266001901','266002901','266003901','266004901','266005901','286001901','286002901','286003901','286004901','286005901');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1520','111010802','121110802','126210802','130910802','389050000','136010802','140910802','146010802','151010802','389026000','156010802','168210802','171510802','180910802','389033000','389038000','168250802','171550802','190910802','389075000','389039000','379109000','389014000','379006000','389074000','389040000','389083000','379004000','389065000','389076000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1521','121210902','126310902','131010902','136110902','141010902','151110902','156110902','168310902','181010902','191010902','205001903','205002903','205003903','205004903','205005903','245001903','245002903','245003903','245004903','245005903','265001903','265002903','265003903','265004903','265005903','285001903','285002903','285003903','285004903','285005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1522','111110902','126310902','131010902','136110902','146110902','151110902','156110902','168310902','181010902','191010902','205001903','205002903','205003903','205004903','205005903','245001903','245002903','245003903','245004903','245005903','265001903','265002903','265003903','265004903','265005903','285001903','285002903','285003903','285004903','285005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1523','121210902','126310902','131010902','136110902','141010902','151110902','156110902','168310902','181010902','191010902','206001903','206002903','206003903','206004903','206005903','246001903','246002903','246003903','246004903','246005903','266001903','266002903','266003903','266004903','266005903','286001903','286002903','286003903','286004903','286005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1524','111110902','126310902','131010902','136110902','146110902','151110902','156110902','168310902','181010902','191010902','206001903','206002903','206003903','206004903','206005903','246001903','246002903','246003903','246004903','246005903','266001903','266002903','266003903','266004903','266005903','286001903','286002903','286003903','286004903','286005903');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1530','111010803','121110803','126210803','130910803','389050000','136010803','140910803','146010803','151010803','389026000','156010803','168210803','171510803','180910803','389033000','389038000','168250803','171550803','190910803','389075000','389039000','379109000','389014000','379006000','389074000','389040000','389083000','379004000','389065000','389076000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1531','121210903','126310903','131010903','136110903','141010903','151110903','156110903','168310903','181010903','191010903','205001905','205002905','205003905','205004905','205005905','245001905','245002905','245003905','245004905','245005905','265001905','265002905','265003905','265004905','265005905','285001905','285002905','285003905','285004905','285005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1532','111110903','126310903','131010903','136110903','146110903','151110903','156110903','168310903','181010903','191010903','205001905','205002905','205003905','205004905','205005905','245001905','245002905','245003905','245004905','245005905','265001905','265002905','265003905','265004905','265005905','285001905','285002905','285003905','285004905','285005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1533','121210903','126310903','131010903','136110903','141010903','151110903','156110903','168310903','181010903','191010903','206001905','206002905','206003905','206004905','206005905','246001905','246002905','246003905','246004905','246005905','266001905','266002905','266003905','266004905','266005905','286001905','286002905','286003905','286004905','286005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1534','111110903','126310903','131010903','136110903','146110903','151110903','156110903','168310903','181010903','191010903','206001905','206002905','206003905','206004905','206005905','246001905','246002905','246003905','246004905','246005905','266001905','266002905','266003905','266004905','266005905','286001905','286002905','286003905','286004905','286005905');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1610','131010901','111110901','379109000','370004000','389033000','136110901','141010901','379107000','389026000','389050000','156110901','168310901','389083000','389023000','379006000','121210901','126310901','389074000','389038000','389014000','146110901','151110901','389075000','389039000','379004000','181010901','191010901','389076000','389040000','389065000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1611','121310901','126410901','131110901','136210901','141110901','151210901','156210901','168410901','181110901','191110901','206001901','206002901','206003901','206004901','206005901','246001901','246002901','246003901','246004901','246005901','266001901','266002901','266003901','266004901','266005901','286001901','286002901','286003901','286004901','286005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1612','111210901','126410901','131110901','136210901','146210901','151210901','156210901','168410901','181110901','191110901','206001901','206002901','206003901','206004901','206005901','246001901','246002901','246003901','246004901','246005901','266001901','266002901','266003901','266004901','266005901','286001901','286002901','286003901','286004901','286005901');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1620','131010902','111110902','379109000','370004000','389033000','136110902','141010902','379107000','389026000','389050000','156110902','168310902','389083000','389023000','379006000','121210902','126310902','389074000','389038000','389014000','146110902','151110902','389075000','389039000','379004000','181010902','191010902','389076000','389040000','389065000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1621','121310902','126410902','131110902','136210902','141110902','151210902','156210902','168410902','181110902','191110902','206001903','206002903','206003903','206004903','206005903','246001903','246002903','246003903','246004903','246005903','266001903','266002903','266003903','266004903','266005903','286001903','286002903','286003903','286004903','286005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1622','111210902','126410902','131110902','136210902','146210902','151210902','156210902','168410902','181110902','191110902','206001903','206002903','206003903','206004903','206005903','246001903','246002903','246003903','246004903','246005903','266001903','266002903','266003903','266004903','266005903','286001903','286002903','286003903','286004903','286005903');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1630','131010903','111110903','379109000','370004000','389033000','136110903','141010903','379107000','389026000','389050000','156110903','168310903','389083000','389023000','379006000','121210903','126310903','389074000','389038000','389014000','146110903','151110903','389075000','389039000','379004000','181010903','191010903','389076000','389040000','389065000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1631','121310903','126410903','131110903','136210903','141110903','151210903','156210903','168410903','181110903','191110903','206001905','206002905','206003905','206004905','206005905','246001905','246002905','246003905','246004905','246005905','266001905','266002905','266003905','266004905','266005905','286001905','286002905','286003905','286004905','286005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1632','111210903','126410903','131110903','136210903','146210903','151210903','156210903','168410903','181110903','191110903','206001905','206002905','206003905','206004905','206005905','246001905','246002905','246003905','246004905','246005905','266001905','266002905','266003905','266004905','266005905','286001905','286002905','286003905','286004905','286005905');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1710','370004000','379110000','379006000','111210901','121310901','370006000','379109000','389033000','126410901','131110901','379004000','379107000','389050000','136210901','141110901','389023000','379221000','389038000','146210901','151210901','389026000','379205000','389039000','156210901','168410901','389083000','379016000','389040000','181110901','191110901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1711','121410901','126610901','131210901','136310901','141210901','151310901','156310901','168610901','181210901','191210901','206001901','206002901','206003901','206004901','206005901','246001901','246002901','246003901','246004901','246005901','266001901','266002901','266003901','266004901','266005901','286001901','286002901','286003901','286004901','286005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1712','111310901','126610901','131210901','136310901','146310901','151310901','156310901','168610901','181210901','191210901','206001901','206002901','206003901','206004901','206005901','246001901','246002901','246003901','246004901','246005901','266001901','266002901','266003901','266004901','266005901','286001901','286002901','286003901','286004901','286005901');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1720','370004000','379110000','379006000','111210902','121310902','370006000','379109000','389033000','126410902','131110902','379004000','379107000','389050000','136210902','141110902','389023000','379221000','389038000','146210902','151210902','389026000','379205000','389039000','156210902','168410902','389083000','379016000','389040000','181110902','191110902');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1721','121410902','126610902','131210902','136310902','141210902','151310902','156310902','168610902','181210902','191210902','206001903','206002903','206003903','206004903','206005903','246001903','246002903','246003903','246004903','246005903','266001903','266002903','266003903','266004903','266005903','286001903','286002903','286003903','286004903','286005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1722','111310902','126610902','131210902','136310902','146310902','151310902','156310902','168610902','181210902','191210902','206001903','206002903','206003903','206004903','206005903','246001903','246002903','246003903','246004903','246005903','266001903','266002903','266003903','266004903','266005903','286001903','286002903','286003903','286004903','286005903');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1730','370004000','379110000','379006000','111210903','121310903','370006000','379109000','389033000','126410903','131110903','379004000','379107000','389050000','136210903','141110903','389023000','379221000','389038000','146210903','151210903','389026000','379205000','389039000','156210903','168410903','389083000','379016000','389040000','181110903','191110903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1731','121410903','126610903','131210903','136310903','141210903','151310903','156310903','168610903','181210903','191210903','206001905','206002905','206003905','206004905','206005905','246001905','246002905','246003905','246004905','246005905','266001905','266002905','266003905','266004905','266005905','286001905','286002905','286003905','286004905','286005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1732','111310903','126610903','131210903','136310903','146310903','151310903','156310903','168610903','181210903','191210903','206001905','206002905','206003905','206004905','206005905','246001905','246002905','246003905','246004905','246005905','266001905','266002905','266003905','266004905','266005905','286001905','286002905','286003905','286004905','286005905');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1810','370004000','379110000','379006000','111310901','121410901','370006000','379109000','389033000','126610901','131210901','379004000','379107000','389050000','136310901','141210901','389023000','379221000','389038000','146310901','151310901','389026000','379205000','389039000','156310901','168610901','389083000','379016000','389040000','181210901','191210901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1820','370004000','379110000','379006000','111310902','121410902','370006000','379109000','389033000','126610902','131210902','379004000','379107000','389050000','136310902','141210902','389023000','379221000','389038000','146310902','151310902','389026000','379205000','389039000','156310902','168610902','389083000','379016000','389040000','181210902','191210902');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1830','370004000','379110000','379006000','111310903','121410903','370006000','379109000','389033000','126610903','131210903','379004000','379107000','389050000','136310903','141210903','389023000','379221000','389038000','146310903','151310903','389026000','379205000','389039000','156310903','168610903','389083000','379016000','389040000','181210903','191210903');





insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1901','261001781','261002781','261003781','261004781','261005781','281001781','281002781','281003781','281004781','281005781','205001981','205002981','205003981','205004981','205005981','245001981','245002981','245003981','245004981','245005981','265001981','265002981','265003981','265004981','265005981','285001981','285002981','285003981','285004981','285005981');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1902','261001782','261002782','261003782','261004782','261005782','281001782','281002782','281003782','281004782','281005782','205001982','205002982','205003982','205004982','205005982','245001982','245002982','245003982','245004982','245005982','265001982','265002982','265003982','265004982','265005982','285001982','285002982','285003982','285004982','285005982');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1903','261001783','261002783','261003783','261004783','261005783','281001783','281002783','281003783','281004783','281005783','205001983','205002983','205003983','205004983','205005983','245001983','245002983','245003983','245004983','245005983','265001983','265002983','265003983','265004983','265005983','285001983','285002983','285003983','285004983','285005983');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1911','111210901','121310901','379059000','191210901','181210901','126410901','131110901','379060000','156310901','168610901','136210901','141110901','379061000','151310901','146310901','151210901','146210901','379062000','136310901','141210901','156210901','168410901','379107000','131210901','126610901','191110901','181110901','379109000','111310901','121410901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1912','111210902','121310902','379059000','191210902','181210902','126410902','131110902','379060000','156310902','168610902','136210902','141110902','379061000','151310902','146310902','151210902','146210902','379062000','136310902','141210902','156210902','168410902','379107000','131210902','126610902','191110902','181110902','379109000','111310902','121410902');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1913','111210903','121310903','379059000','191210903','181210903','126410903','131110903','379060000','156310903','168610903','136210903','141110903','379061000','151310903','146310903','151210903','146210903','379062000','136310903','141210903','156210903','168410903','379107000','131210903','126610903','191110903','181110903','379109000','111310903','121410903');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1925','320110005','320110015','320110025','320110035','320110075','310110005','310110015','310110025','310110035','310110075','330110005','330110015','330110025','330110035','330110075','340110005','340110015','340110025','340110035','340110075','310150005','310150015','310150025','310150035','310150075','330150005','330150015','330150025','330150035','330150075');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1926','320110006','320110016','320110026','320110036','320110076','310110006','310110016','310110026','310110036','310110076','330110006','330110016','330110026','330110036','330110076','340110006','340110016','340110026','340110036','340110076','310150006','310150016','310150026','310150036','310150076','330150006','330150016','330150026','330150036','330150076');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1935','320150005','320150015','320150025','320150035','320150075','310150005','310150015','310150025','310150035','310150075','330150005','330150015','330150025','330150035','330150075','340150005','340150015','340150025','340150035','340150075','310110005','310110015','310110025','310110035','310110075','330110005','330110015','330110025','330110035','330110075');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1936','320150006','320150016','320150026','320150036','320150076','310150006','310150016','310150026','310150036','310150076','330150006','330150016','330150026','330150036','330150076','340150006','340150016','340150026','340150036','340150076','310110006','310110016','310110026','310110036','310110076','330110006','330110016','330110026','330110036','330110076');

---------
---------

Konu aşağıdan devam etmektedir.
 

Ekli dosyalar

  • TBL.txt
    382.1 KB · Görüntüleme: 5
A

Acceleration

KY Üye
Katılım
10 Ocak 2023
Mesajlar
7
Tepkime puanı
1
Puanları
13
6) ITEM_EXCHANGE tablosunda birtakım değişimler yapılması gerekmektedir.

Kod: 
--------



--------- Blue Treasure Chest (Mavi Kutu) -------

Update ITEM_EXCHANGE set nExchangeItemNum1 = '111110901', nExchangeItemNum2 = '205001901', nExchangeItemNum3 = '206001901', nExchangeItemNum4 = '111210901'  where nIndex = '78'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '121210901', nExchangeItemNum2 = '205002901', nExchangeItemNum3 = '206002901', nExchangeItemNum4 = '121310901'  where nIndex = '79'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '126310901', nExchangeItemNum2 = '205003901', nExchangeItemNum3 = '206003901', nExchangeItemNum4 = '126410901'  where nIndex = '80'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '131010901', nExchangeItemNum2 = '205004901', nExchangeItemNum3 = '206004901', nExchangeItemNum4 = '131110901'  where nIndex = '81'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '136110901', nExchangeItemNum2 = '205005901', nExchangeItemNum3 = '206005901', nExchangeItemNum4 = '136210901'  where nIndex = '82'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '141010901', nExchangeItemNum2 = '245001901', nExchangeItemNum3 = '246001901', nExchangeItemNum4 = '141110901'  where nIndex = '83'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '146110901', nExchangeItemNum2 = '245002901', nExchangeItemNum3 = '246002901', nExchangeItemNum4 = '146210901'  where nIndex = '84'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '151110901', nExchangeItemNum2 = '245003901', nExchangeItemNum3 = '246003901', nExchangeItemNum4 = '151210901'  where nIndex = '85'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '156110901', nExchangeItemNum2 = '245004901', nExchangeItemNum3 = '246004901', nExchangeItemNum4 = '156210901'  where nIndex = '86'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '168310901', nExchangeItemNum2 = '245005901', nExchangeItemNum3 = '246005901', nExchangeItemNum4 = '168410901'  where nIndex = '87'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '181010901', nExchangeItemNum2 = '265001901', nExchangeItemNum3 = '266001901', nExchangeItemNum4 = '181110901'  where nIndex = '88'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '191010901', nExchangeItemNum2 = '265002901', nExchangeItemNum3 = '266002901', nExchangeItemNum4 = '191110901'  where nIndex = '89'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '181010901', nExchangeItemNum2 = '265003901', nExchangeItemNum3 = '266003901', nExchangeItemNum4 = '181110901'  where nIndex = '90'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '191010901', nExchangeItemNum2 = '265004901', nExchangeItemNum3 = '266004901', nExchangeItemNum4 = '191110901'  where nIndex = '91'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '131010901', nExchangeItemNum2 = '265005901', nExchangeItemNum3 = '266005901', nExchangeItemNum4 = '131110901'  where nIndex = '92'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '151010801', nExchangeItemNum2 = '285001901', nExchangeItemNum3 = '286001901', nExchangeItemNum4 = '151110901'  where nIndex = '93'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '156010801', nExchangeItemNum2 = '285002901', nExchangeItemNum3 = '286002901', nExchangeItemNum4 = '156110901'  where nIndex = '94'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '111010801', nExchangeItemNum2 = '285003901', nExchangeItemNum3 = '286003901', nExchangeItemNum4 = '111110901'  where nIndex = '95'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '126310901', nExchangeItemNum2 = '285004901', nExchangeItemNum3 = '286004901', nExchangeItemNum4 = '126410901'  where nIndex = '96'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '141010901', nExchangeItemNum2 = '285005901', nExchangeItemNum3 = '286005901', nExchangeItemNum4 = '141110901'  where nIndex = '97'



--------- Green Treasure Chest (Yeşil Kutu) ---------

Update ITEM_EXCHANGE set nExchangeItemNum1 = '111110901', nExchangeItemNum2 = '205001901', nExchangeItemNum3 = '206001901', nExchangeItemNum4 = '111210901'  where nIndex = '104'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '121210901', nExchangeItemNum2 = '205002901', nExchangeItemNum3 = '206002901', nExchangeItemNum4 = '121310901'  where nIndex = '105'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '126310901', nExchangeItemNum2 = '205003901', nExchangeItemNum3 = '206003901', nExchangeItemNum4 = '126410901'  where nIndex = '106'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '131010901', nExchangeItemNum2 = '205004901', nExchangeItemNum3 = '206004901', nExchangeItemNum4 = '131110901'  where nIndex = '107'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '136110901', nExchangeItemNum2 = '205005901', nExchangeItemNum3 = '206005901', nExchangeItemNum4 = '136210901'  where nIndex = '108'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '141010901', nExchangeItemNum2 = '245001901', nExchangeItemNum3 = '246001901', nExchangeItemNum4 = '141110901'  where nIndex = '109'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '146110901', nExchangeItemNum2 = '245002901', nExchangeItemNum3 = '246002901', nExchangeItemNum4 = '146210901'  where nIndex = '110'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '151110901', nExchangeItemNum2 = '245003901', nExchangeItemNum3 = '246003901', nExchangeItemNum4 = '151210901'  where nIndex = '111'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '156110901', nExchangeItemNum2 = '245004901', nExchangeItemNum3 = '246004901', nExchangeItemNum4 = '156210901'  where nIndex = '112'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '168310901', nExchangeItemNum2 = '245005901', nExchangeItemNum3 = '246005901', nExchangeItemNum4 = '168410901'  where nIndex = '113'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '181010901', nExchangeItemNum2 = '265001901', nExchangeItemNum3 = '266001901', nExchangeItemNum4 = '181110901'  where nIndex = '114'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '191010901', nExchangeItemNum2 = '265002901', nExchangeItemNum3 = '266002901', nExchangeItemNum4 = '191110901'  where nIndex = '115'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '181010901', nExchangeItemNum2 = '265003901', nExchangeItemNum3 = '266003901', nExchangeItemNum4 = '181110901'  where nIndex = '116'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '191010901', nExchangeItemNum2 = '265004901', nExchangeItemNum3 = '266004901', nExchangeItemNum4 = '191110901'  where nIndex = '117'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '131010901', nExchangeItemNum2 = '265005901', nExchangeItemNum3 = '266005901', nExchangeItemNum4 = '131110901'  where nIndex = '118'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '151010801', nExchangeItemNum2 = '285001901', nExchangeItemNum3 = '286001901', nExchangeItemNum4 = '151110901'  where nIndex = '119'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '156010801', nExchangeItemNum2 = '285002901', nExchangeItemNum3 = '286002901', nExchangeItemNum4 = '156110901'  where nIndex = '120'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '111010801', nExchangeItemNum2 = '285003901', nExchangeItemNum3 = '286003901', nExchangeItemNum4 = '111110901'  where nIndex = '121'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '126310901', nExchangeItemNum2 = '285004901', nExchangeItemNum3 = '286004901', nExchangeItemNum4 = '126410901'  where nIndex = '122'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '141010901', nExchangeItemNum2 = '285005901', nExchangeItemNum3 = '286005901', nExchangeItemNum4 = '141110901'  where nIndex = '123'




---------- Abyss Gem ---------

Update ITEM_EXCHANGE set nExchangeItemNum1 = '156210901', nExchangeItemNum2 = '156110901', nExchangeItemNum3 = '205001901', nExchangeItemNum4 = '204001801'  where nIndex = '35271'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '136210901', nExchangeItemNum2 = '136110901', nExchangeItemNum3 = '205002901', nExchangeItemNum4 = '204002801'  where nIndex = '35272'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '121310901', nExchangeItemNum2 = '121210901', nExchangeItemNum3 = '205003901', nExchangeItemNum4 = '204003801'  where nIndex = '35273'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '151210901', nExchangeItemNum2 = '151110901', nExchangeItemNum3 = '205004901', nExchangeItemNum4 = '204004801'  where nIndex = '35274'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '168410901', nExchangeItemNum2 = '168310901', nExchangeItemNum3 = '205005901', nExchangeItemNum4 = '204005801'  where nIndex = '35275'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '181110901', nExchangeItemNum2 = '181010901', nExchangeItemNum3 = '245001901', nExchangeItemNum4 = '244001801'  where nIndex = '35276'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '111210901', nExchangeItemNum2 = '111110901', nExchangeItemNum3 = '245002901', nExchangeItemNum4 = '244002801'  where nIndex = '35277'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '191110901', nExchangeItemNum2 = '191010901', nExchangeItemNum3 = '245003901', nExchangeItemNum4 = '244003801'  where nIndex = '35278'
Update ITEM_EXCHANGE set nExchangeItemNum3 = '245004901', nExchangeItemNum4 = '244004801'  where nIndex = '35279'
Update ITEM_EXCHANGE set nExchangeItemNum3 = '245005901', nExchangeItemNum4 = '244005801'  where nIndex = '35280'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '156210901', nExchangeItemNum2 = '156110901', nExchangeItemNum3 = '265001901', nExchangeItemNum4 = '264001801'  where nIndex = '35281'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '136210901', nExchangeItemNum2 = '136110901', nExchangeItemNum3 = '265002901', nExchangeItemNum4 = '264002801'  where nIndex = '35282'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '121310901', nExchangeItemNum2 = '121210901', nExchangeItemNum3 = '265003901', nExchangeItemNum4 = '264003801'  where nIndex = '35283'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '151210901', nExchangeItemNum2 = '151110901', nExchangeItemNum3 = '265004901', nExchangeItemNum4 = '264004801'  where nIndex = '35284'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '168410901', nExchangeItemNum2 = '168310901', nExchangeItemNum3 = '265005901', nExchangeItemNum4 = '264005801'  where nIndex = '35285'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '181110901', nExchangeItemNum2 = '181010901', nExchangeItemNum3 = '285001901', nExchangeItemNum4 = '284001801'  where nIndex = '35286'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '111210901', nExchangeItemNum2 = '111110901', nExchangeItemNum3 = '285002901', nExchangeItemNum4 = '284002801'  where nIndex = '35287'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '191110901', nExchangeItemNum2 = '191010901', nExchangeItemNum3 = '285003901', nExchangeItemNum4 = '284003801'  where nIndex = '35288'
Update ITEM_EXCHANGE set nExchangeItemNum3 = '285004901', nExchangeItemNum4 = '284004801'  where nIndex = '35289'
Update ITEM_EXCHANGE set nExchangeItemNum3 = '285005901', nExchangeItemNum4 = '284005801'  where nIndex = '35290'



----------- Low quality jewel --------

Update ITEM_EXCHANGE set nOriginItemNum1 = '201001701', nExchangeItemNum1 = '201001734', nExchangeItemNum2 = '201001744', nExchangeItemNum3 = '201001754', nExchangeItemNum4 = '201001764', nExchangeItemNum5 = '201001774' where nIndex = '7801'
Update ITEM_EXCHANGE set nOriginItemNum1 = '201002701', nExchangeItemNum1 = '201002734', nExchangeItemNum2 = '201002744', nExchangeItemNum3 = '201002754', nExchangeItemNum4 = '201002764', nExchangeItemNum5 = '201002774' where nIndex = '7802'
Update ITEM_EXCHANGE set nOriginItemNum1 = '201003701', nExchangeItemNum1 = '201003734', nExchangeItemNum2 = '201003744', nExchangeItemNum3 = '201003754', nExchangeItemNum4 = '201003764', nExchangeItemNum5 = '201003774' where nIndex = '7803'
Update ITEM_EXCHANGE set nOriginItemNum1 = '201004701', nExchangeItemNum1 = '201004734', nExchangeItemNum2 = '201004744', nExchangeItemNum3 = '201004754', nExchangeItemNum4 = '201004764', nExchangeItemNum5 = '201004774' where nIndex = '7804'
Update ITEM_EXCHANGE set nOriginItemNum1 = '201005701', nExchangeItemNum1 = '201005734', nExchangeItemNum2 = '201005744', nExchangeItemNum3 = '201005754', nExchangeItemNum4 = '201005764', nExchangeItemNum5 = '201005774' where nIndex = '7805'

Update ITEM_EXCHANGE set nOriginItemNum1 = '241001701', nExchangeItemNum1 = '241001734', nExchangeItemNum2 = '241001744', nExchangeItemNum3 = '241001754', nExchangeItemNum4 = '241001764', nExchangeItemNum5 = '241001774' where nIndex = '7806'
Update ITEM_EXCHANGE set nOriginItemNum1 = '241002701', nExchangeItemNum1 = '241002734', nExchangeItemNum2 = '241002744', nExchangeItemNum3 = '241002754', nExchangeItemNum4 = '241002764', nExchangeItemNum5 = '241002774' where nIndex = '7807'
Update ITEM_EXCHANGE set nOriginItemNum1 = '241003701', nExchangeItemNum1 = '241003734', nExchangeItemNum2 = '241003744', nExchangeItemNum3 = '241003754', nExchangeItemNum4 = '241003764', nExchangeItemNum5 = '241003774' where nIndex = '7808'
Update ITEM_EXCHANGE set nOriginItemNum1 = '241004701', nExchangeItemNum1 = '241004734', nExchangeItemNum2 = '241004744', nExchangeItemNum3 = '241004754', nExchangeItemNum4 = '241004764', nExchangeItemNum5 = '241004774' where nIndex = '7809'
Update ITEM_EXCHANGE set nOriginItemNum1 = '241005701', nExchangeItemNum1 = '241005734', nExchangeItemNum2 = '241005744', nExchangeItemNum3 = '241005754', nExchangeItemNum4 = '241005764', nExchangeItemNum5 = '241005774' where nIndex = '7810'

Update ITEM_EXCHANGE set nOriginItemNum1 = '261001701', nExchangeItemNum1 = '261001734', nExchangeItemNum2 = '261001744', nExchangeItemNum3 = '261001754', nExchangeItemNum4 = '261001764', nExchangeItemNum5 = '261001774' where nIndex = '7811'
Update ITEM_EXCHANGE set nOriginItemNum1 = '261002701', nExchangeItemNum1 = '261002734', nExchangeItemNum2 = '261002744', nExchangeItemNum3 = '261002754', nExchangeItemNum4 = '261002764', nExchangeItemNum5 = '261002774' where nIndex = '7812'
Update ITEM_EXCHANGE set nOriginItemNum1 = '261003701', nExchangeItemNum1 = '261003734', nExchangeItemNum2 = '261003744', nExchangeItemNum3 = '261003754', nExchangeItemNum4 = '261003764', nExchangeItemNum5 = '261003774' where nIndex = '7813'
Update ITEM_EXCHANGE set nOriginItemNum1 = '261004701', nExchangeItemNum1 = '261004734', nExchangeItemNum2 = '261004744', nExchangeItemNum3 = '261004754', nExchangeItemNum4 = '261004764', nExchangeItemNum5 = '261004774' where nIndex = '7814'
Update ITEM_EXCHANGE set nOriginItemNum1 = '261005701', nExchangeItemNum1 = '261005734', nExchangeItemNum2 = '261005744', nExchangeItemNum3 = '261005754', nExchangeItemNum4 = '261005764', nExchangeItemNum5 = '261005774' where nIndex = '7815'

Update ITEM_EXCHANGE set nOriginItemNum1 = '281001701', nExchangeItemNum1 = '281001734', nExchangeItemNum2 = '281001744', nExchangeItemNum3 = '281001754', nExchangeItemNum4 = '281001764', nExchangeItemNum5 = '281001774' where nIndex = '7816'
Update ITEM_EXCHANGE set nOriginItemNum1 = '281002701', nExchangeItemNum1 = '281002734', nExchangeItemNum2 = '281002744', nExchangeItemNum3 = '281002754', nExchangeItemNum4 = '281002764', nExchangeItemNum5 = '281002774' where nIndex = '7817'
Update ITEM_EXCHANGE set nOriginItemNum1 = '281003701', nExchangeItemNum1 = '281003734', nExchangeItemNum2 = '281003744', nExchangeItemNum3 = '281003754', nExchangeItemNum4 = '281003764', nExchangeItemNum5 = '281003774' where nIndex = '7818'
Update ITEM_EXCHANGE set nOriginItemNum1 = '281004701', nExchangeItemNum1 = '281004734', nExchangeItemNum2 = '281004744', nExchangeItemNum3 = '281004754', nExchangeItemNum4 = '281004764', nExchangeItemNum5 = '281004774' where nIndex = '7819'
Update ITEM_EXCHANGE set nOriginItemNum1 = '281005701', nExchangeItemNum1 = '281005734', nExchangeItemNum2 = '281005744', nExchangeItemNum3 = '281005754', nExchangeItemNum4 = '281005764', nExchangeItemNum5 = '281005774' where nIndex = '7820'



---------




7) ITEM_UPGRADE tablosunun içeriğini temizliyoruz.

Kod: 
--------
--------

Delete from ITEM_UPGRADE

--------
--------


8) Sıradan silahların basım satırlarını ITEM_UPGRADE tablosuna ekliyoruz.

Gizli içeriği görüntüleme kayıtlı kullanıcılar için mevcuttur!



Konu aşağıdan devam etmektedir.
 
A

Acceleration

KY Üye
Katılım
10 Ocak 2023
Mesajlar
7
Tepkime puanı
1
Puanları
13
9) Unique silahların basım satırlarını ITEM_UPGRADE tablosuna ekliyoruz.

Gizli içeriği görüntüleme kayıtlı kullanıcılar için mevcuttur!


Konu aşağıdan devam etmektedir.
 
A

Acceleration

KY Üye
Katılım
10 Ocak 2023
Mesajlar
7
Tepkime puanı
1
Puanları
13
10) Kıyafetlerin basım satırlarını ITEM_UPGRADE tablosuna ekliyoruz.

Gizli içeriği görüntüleme kayıtlı kullanıcılar için mevcuttur!


Konu aşağıdan devam etmektedir.
 
A

Acceleration

KY Üye
Katılım
10 Ocak 2023
Mesajlar
7
Tepkime puanı
1
Puanları
13
11) Sıradan takıların ve unique takıların basım satırlarını ITEM_UPGRADE tablosuna ekliyoruz.

Gizli içeriği görüntüleme kayıtlı kullanıcılar için mevcuttur!


Konu aşağıdan devam etmektedir.
 
A

Acceleration

KY Üye
Katılım
10 Ocak 2023
Mesajlar
7
Tepkime puanı
1
Puanları
13
12) Upgrade oranlarını kolayca düzenleyebilmek için birtakım code'lar aşağıda verilmiştir.

- Kökenden low class silahların (Örn: Sword breaker, Alchemy Staff) upgrade oranlarını düzenleme :


Kod: 
-------

------ Low silahların low class upgrade scroll ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '379221000' and nReqItem2 = '0'


------ Low silahların middle class upgrade scroll ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%7' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '200' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%8' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '20' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%9' and nReqItem1 = '379205000' and nReqItem2 = '0'


------ Low silahların BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '40' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'


------ Low silahların BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

-------






- Kökenden middle class silahların (Örn: Cleaver, Bardish) upgrade oranlarını düzenleme :


Kod: 
-------

------ Middle silahların middle class upgrade scroll ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%1' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%2' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%3' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%4' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%5' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%6' and nReqItem1 = '379205000' and nReqItem2 = '0'


------ Middle silahların BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '200' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '20' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'


------ Middle silahların BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '40' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

--------







- Kökenden high class silahların (Örn: Shard, Raptor) upgrade oranlarını düzenleme :


Kod: 
-------

------ High silahların BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '500' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '100' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'



------ High silahların BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '200' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '20' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

--------














- Kökenden low class kıyafetlerin (Örn: Fabric Coat, Silk Pants) upgrade oranlarını düzenleme :


Kod: 
-------

------ Low kıyafetlerin low class upgrade scroll ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '379221000' and nReqItem2 = '0'


------ Low kıyafetlerin middle class upgrade scroll ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%7' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%8' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '40' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%9' and nReqItem1 = '379205000' and nReqItem2 = '0'


------ Low kıyafetlerin BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'


------ Low kıyafetlerin BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '1600' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

--------






- Kökenden middle class kıyafetlerin (Örn: Rogue Full Plate Armor Pauldron) upgrade oranlarını düzenleme :


Kod: 
-------

------ Middle kıyafetlerin middle class upgrade scroll ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%1' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%2' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%3' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%4' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%5' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%6' and nReqItem1 = '379205000' and nReqItem2 = '0'


------ Middle kıyafetlerin BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '40' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'


------ Middle kıyafetlerin BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

--------







- Kökenden high class kıyafetlerin (Örn: Priest Chitin Shell Pads) upgrade oranlarını düzenleme :


Kod: 
-------

------ High kıyafetlerin BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '200' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '20' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'


------ High kıyafetlerin BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '40' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

--------













- Kökenden unique silahların (Örn: Dark Vane, Hell Breaker) upgrade oranlarını düzenleme :



Kod: 
-------


------ Unique silahların BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'






------ Unique silahların BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'


--------













- Unique takıların (Örn: Elf-Metal Earring, Warrior Earring) +0'dan +1'e olan upgrade oranlarını düzenleme :

Kod: 
-------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '31%' and nReqItem1 = '379159000' and nReqItem2 = '0'

-------





- Unique takıların (Örn: Elf-Metal Earring, Warrior Earring) diğer upgrade oranlarını düzenleme :

Kod: 
-------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '1%' and nOriginItem LIKE '%1' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '1%' and nOriginItem LIKE '%2' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2500' WHERE nIndex LIKE '32%' and nOriginItem LIKE '1%' and nOriginItem LIKE '%3' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '1%' and nOriginItem LIKE '%4' and nReqItem1 = '379159000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%1' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%2' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2500' WHERE nIndex LIKE '32%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%3' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%4' and nReqItem1 = '379159000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%1' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%2' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2500' WHERE nIndex LIKE '32%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%3' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%4' and nReqItem1 = '379159000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%1' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%2' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2500' WHERE nIndex LIKE '32%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%3' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%4' and nReqItem1 = '379159000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%1' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%2' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2500' WHERE nIndex LIKE '32%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%3' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%4' and nReqItem1 = '379159000' and nReqItem2 = '0'

--------


Konu tamamlandı.
 
kurtulus

kurtulus

KY Üye
Katılım
30 Ocak 2022
Mesajlar
21
Tepkime puanı
5
Puanları
33
güzel konu ama backup almadan direk kopyala yapıştır yapacak arkadaşların db farklılıklarını gözetmesi ve o kadar item vardı, düzenlemiştim, gitti hepsi vs dememesi için dikkat etmesi gerektiğini hatırlatmakta fayda var (y)
 
D

delitay

KY Kıdemli Üye
KY YardımSever
Katılım
24 Ağu 2023
Mesajlar
241
Çözümler
4
Tepkime puanı
14
Puanları
0
sagolasın ustam
 
Cevap yazmak için giriş yap yada kayıt ol.
img acıklama
Benzer konular Forum Tarih
MANES PROSEDÜR Tüm Dropları Sıfırlama Kodu :) Prosedür - Kaynak Kod ve Query Kod Paylaşımları 5 211
Y KAYNAK KOD CE ITEM SLOT DEGİŞEREK ITEM BUGLAMA FIXED Prosedür - Kaynak Kod ve Query Kod Paylaşımları 37 2K
Admin KAYNAK KOD SQL QUERY - DB'de Çift item ID Kontrolü Prosedür - Kaynak Kod ve Query Kod Paylaşımları 2 307
CMDK PROSEDÜR Bot karaktere İtem Verme Prosedürü Prosedür - Kaynak Kod ve Query Kod Paylaşımları 59 1K
Admin PROSEDÜR Başlangıç Level | Para | Stat | Skill | Point Ayarlama | Tüm Versiyonlar Prosedür - Kaynak Kod ve Query Kod Paylaşımları 10 3K
Admin PROSEDÜR Zoneye Göre Exp Oranlarını Arttırma | Tüm Zoneler İçin Prosedür - Kaynak Kod ve Query Kod Paylaşımları 45 4K
Admin PROSEDÜR Herkese 21 GB verme | Tüm Kayıtlı Kullanıcılara Verir Prosedür - Kaynak Kod ve Query Kod Paylaşımları 12 2K
Admin PROSEDÜR Destek Item Ekleme Kodu - Tüm DB Versiyonlarında Uyumludur Prosedür - Kaynak Kod ve Query Kod Paylaşımları 22 2K
Admin PROSEDÜR v20xx Oto Res Kodu | Tüm 20xx Versiyonlarda Uyumlu Prosedür - Kaynak Kod ve Query Kod Paylaşımları 2 2K
Admin KAYNAK KOD Sağ Köşeye Başlık Kutusu ekleme | Tüm Versiyonlarda Kullanılabilir Prosedür - Kaynak Kod ve Query Kod Paylaşımları 51 4K

Benzer konular

Ko Yardım
"Ko-Yardım" Forum sitemizde;
T.C.K 20.ci Madde ve 5651 Sayılı Kanun'un 4.cü maddesinin (2).ci fıkrasına göre TÜM ÜYELERİMİZ Yaptıkları paylaşımlardan kendileri sorumludur!
İletişim;
E-mail:mail@ko-yardim.com
Discord adresi: koyardim
Forum software by XenForo® © 2010-2024 XenForo Ltd.
Tepki lideri konular
Reklam