Ko-Tr Server Tanıtımı

Tüm ITEM_UPGRADE Tablosu ve Ek Açıklamalar

Tüm ITEM_UPGRADE Tablosu ve Ek Açıklamalar
« : 16 Nisan 2016, 02:36:14 »
ITEM_UPGRADE tablosu önemli tablolardandır ve genellikle bozuk olmaktadır. Yararlı olması dileğiyle... Lütfen hatalı yer varsa bildiriniz.




1) ITEM_UPGRADE tablosunda bir nIndex değeri verirken tam bir serbesti içerisinde değiliz.


Örnekle açıklayalım :


Bunlar seçtiğimiz nIndex değerleri : (nIndex nedir? Değerleri sayfada aratıp bakarsanız nIndex nedir, anlaşılır.)


*140574
*200335
*320662


nIndex değerinin başındaki renklendirilmiş sayıları serbestçe seçemiyoruz. Eğer bir silah(pusat) basmak söz konusuysa bu değer 1, bir giysi(kılık) basmak söz konusuysa bu değer 2, bir takı basmak söz konusuysa bu değer 3 olmak zorundadır !


*140574 > bir pusat basımı nIndex'i
*200335 > bir kılık basımı nIndex'i
*320662 > bir takı basımı nIndex'i


-Pekiyi. Sıradan bir silah basımı ile unike bir silah basımı için nIndex baş sayısı aynı mıdır? Evet. Hem unike silahlar hem de sıradan silahlar için nIndex baş sayısı 1'dir. Ancak 70 Quest itemleri için durum farklı, bunlar için nIndex baş sayısı 9'dur.
-Aynı durum takılar için de geçerli midir? Evet. Hem sıradan takılar hem de unike takılar için nIndex baş sayısı 3'tür. Aşağıdaki code'ları incelediğinizde bunu net biçimde görebilirsiniz.


-Pekiyi niçin bütün sıradan-unike pusatların nIndex baş sayısı 1 de 70 Quest pusatlarının 9? Çünkü ITEM_UPGRADE tablosundaki nIndex değerleri ITEM tablosundaki num değerlerine bağımlıdır. Bütün giysilerin ITEM tablosundaki num değerlerinin baş sayısı 2'dir; bu nedenle bütün kıyafetlerin ITEM_UPGRADE tablosundaki nIndex değerlerinin baş sayısı 2'dir. 70 Quest itemlerinin ise ITEM tablosundaki num değerlerinin baş sayısı 9'dur; diğer silahların ise 1'dir, ITEM_UPGRADE tablosunu da bu baş sayı değerlerine uygun oluşturmak zorundasınız, yoksa çalışmaz.



Kod: Linklerin görüntülenmesine izin verilmiyor. Üye Ol ya da Giriş Yap
----------------------PUSATLAR--------------------




-------3. basamak kağıt------


insert into [ITEM_UPGRADE] values ('100001','5001','Normal-Weapons(+1)','&Reduce(b)','-1','1','379019000','0','0','0','0','0','0','0','0','7','3000','30');
insert into [ITEM_UPGRADE] values ('100002','5001','Normal-Weapons(+2)','&Reduce(b)','-1','2','379019000','0','0','0','0','0','0','0','0','7','3000','30');
insert into [ITEM_UPGRADE] values ('100003','5001','Normal-Weapons(+3)','&Reduce(b)','-1','3','379019000','0','0','0','0','0','0','0','0','7','3000','30');
insert into [ITEM_UPGRADE] values ('100004','5001','Normal-Weapons(+4)','&Reduce(b)','-1','4','379019000','0','0','0','0','0','0','0','0','7','3000','30');
insert into [ITEM_UPGRADE] values ('100005','5001','Normal-Weapons(+5)','&Reduce(b)','-1','5','379019000','0','0','0','0','0','0','0','0','7','3000','30');
insert into [ITEM_UPGRADE] values ('100006','5001','Normal-Weapons(+6)','&Reduce(b)','-1','6','379019000','0','0','0','0','0','0','0','0','7','3000','30');
insert into [ITEM_UPGRADE] values ('100007','5001','Normal-Weapons(+7)','&Reduce(b)','-1','7','379019000','0','0','0','0','0','0','0','0','7','3000','30');
insert into [ITEM_UPGRADE] values ('100008','5001','Normal-Weapons(+8)','&Reduce(b)','-1','8','379019000','0','0','0','0','0','0','0','0','7','3000','30');
insert into [ITEM_UPGRADE] values ('100009','5001','Normal-Weapons(+9)','&Reduce(b)','-1','9','379019000','0','0','0','0','0','0','0','0','7','3000','30');
insert into [ITEM_UPGRADE] values ('100010','5001','Normal-Weapons(+10)','&Reduce(b)','-1','10','379019000','0','0','0','0','0','0','0','0','7','3000','30');


insert into [ITEM_UPGRADE] values ('100011','5001','Normal-Weapons(+1)','&Elemental(b)','-1','1','379020000','0','0','0','0','0','0','0','0','8','3000','40');
insert into [ITEM_UPGRADE] values ('100012','5001','Normal-Weapons(+2)','&Elemental(b)','-1','2','379020000','0','0','0','0','0','0','0','0','8','3000','40');
insert into [ITEM_UPGRADE] values ('100013','5001','Normal-Weapons(+3)','&Elemental(b)','-1','3','379020000','0','0','0','0','0','0','0','0','8','3000','40');
insert into [ITEM_UPGRADE] values ('100014','5001','Normal-Weapons(+4)','&Elemental(b)','-1','4','379020000','0','0','0','0','0','0','0','0','8','3000','40');
insert into [ITEM_UPGRADE] values ('100015','5001','Normal-Weapons(+5)','&Elemental(b)','-1','5','379020000','0','0','0','0','0','0','0','0','8','3000','40');
insert into [ITEM_UPGRADE] values ('100016','5001','Normal-Weapons(+6)','&Elemental(b)','-1','6','379020000','0','0','0','0','0','0','0','0','8','3000','40');
insert into [ITEM_UPGRADE] values ('100017','5001','Normal-Weapons(+7)','&Elemental(b)','-1','7','379020000','0','0','0','0','0','0','0','0','8','3000','40');
insert into [ITEM_UPGRADE] values ('100018','5001','Normal-Weapons(+8)','&Elemental(b)','-1','8','379020000','0','0','0','0','0','0','0','0','8','3000','40');
insert into [ITEM_UPGRADE] values ('100019','5001','Normal-Weapons(+9)','&Elemental(b)','-1','9','379020000','0','0','0','0','0','0','0','0','8','3000','40');
insert into [ITEM_UPGRADE] values ('100020','5001','Normal-Weapons(+10)','&Elemental(b)','-1','10','379020000','0','0','0','0','0','0','0','0','8','3000','40');






insert into [ITEM_UPGRADE] values ('100021','5001','Normal-Weapons(+1)','&Upgrade(b)','-1','1','379016000','0','0','0','0','0','0','0','0','0','9600','1');
insert into [ITEM_UPGRADE] values ('100022','5001','Normal-Weapons(+2)','&Upgrade(b)','-1','2','379016000','0','0','0','0','0','0','0','0','0','5100','1');
insert into [ITEM_UPGRADE] values ('100023','5001','Normal-Weapons(+3)','&Upgrade(b)','-1','3','379016000','0','0','0','0','0','0','0','0','2','2600','1');
insert into [ITEM_UPGRADE] values ('100024','5001','Normal-Weapons(+4)','&Upgrade(b)','-1','4','379016000','0','0','0','0','0','0','0','0','2','1100','1');


insert into [ITEM_UPGRADE] values ('100031','5001','Reduce-Weapons(+1)','&Upgrade(b)','-1','31','379016000','0','0','0','0','0','0','0','0','0','9700','1');
insert into [ITEM_UPGRADE] values ('100032','5001','Reduce-Weapons(+2)','&Upgrade(b)','-1','32','379016000','0','0','0','0','0','0','0','0','0','5200','1');
insert into [ITEM_UPGRADE] values ('100033','5001','Reduce-Weapons(+3)','&Upgrade(b)','-1','33','379016000','0','0','0','0','0','0','0','0','3','2700','1');
insert into [ITEM_UPGRADE] values ('100034','5001','Reduce-Weapons(+4)','&Upgrade(b)','-1','34','379016000','0','0','0','0','0','0','0','0','5','1200','1');


insert into [ITEM_UPGRADE] values ('100041','5001','Elemental-Weapons(+1)','&Upgrade(b)','-1','41','379016000','0','0','0','0','0','0','0','0','0','9500','1');
insert into [ITEM_UPGRADE] values ('100042','5001','Elemental-Weapons(+2)','&Upgrade(b)','-1','42','379016000','0','0','0','0','0','0','0','0','0','5000','1');
insert into [ITEM_UPGRADE] values ('100043','5001','Elemental-Weapons(+3)','&Upgrade(b)','-1','43','379016000','0','0','0','0','0','0','0','0','3','2500','1');
insert into [ITEM_UPGRADE] values ('100044','5001','Elemental-Weapons(+4)','&Upgrade(b)','-1','44','379016000','0','0','0','0','0','0','0','0','5','1000','1');






--------4. basamak kağıt--------


insert into [ITEM_UPGRADE] values ('100051','5001','Normal-Weapons(+1)','<REDUCE(A)','-1','1','379024000','0','0','0','0','0','0','0','0','3','9500','30');
insert into [ITEM_UPGRADE] values ('100052','5001','Normal-Weapons(+2)','<REDUCE(A)','-1','2','379024000','0','0','0','0','0','0','0','0','3','9500','30');
insert into [ITEM_UPGRADE] values ('100053','5001','Normal-Weapons(+3)','<REDUCE(A)','-1','3','379024000','0','0','0','0','0','0','0','0','3','9500','30');
insert into [ITEM_UPGRADE] values ('100054','5001','Normal-Weapons(+4)','<REDUCE(A)','-1','4','379024000','0','0','0','0','0','0','0','0','3','9500','30');
insert into [ITEM_UPGRADE] values ('100055','5001','Normal-Weapons(+5)','<REDUCE(A)','-1','5','379024000','0','0','0','0','0','0','0','0','3','9500','30');
insert into [ITEM_UPGRADE] values ('100056','5001','Normal-Weapons(+6)','<REDUCE(A)','-1','6','379024000','0','0','0','0','0','0','0','0','3','9500','30');
insert into [ITEM_UPGRADE] values ('100057','5001','Normal-Weapons(+7)','<REDUCE(A)','-1','7','379024000','0','0','0','0','0','0','0','0','3','9500','30');
insert into [ITEM_UPGRADE] values ('100058','5001','Normal-Weapons(+8)','<REDUCE(A)','-1','8','379024000','0','0','0','0','0','0','0','0','3','9500','30');
insert into [ITEM_UPGRADE] values ('100059','5001','Normal-Weapons(+9)','<REDUCE(A)','-1','9','379024000','0','0','0','0','0','0','0','0','3','9500','30');
insert into [ITEM_UPGRADE] values ('100060','5001','Normal-Weapons(+10)','<REDUCE(A)','-1','10','379024000','0','0','0','0','0','0','0','0','3','9500','30');


insert into [ITEM_UPGRADE] values ('100061','5001','Normal-Weapons(+1)','<ELEMENTAL(A)','-1','1','379025000','0','0','0','0','0','0','0','0','5','9500','40');
insert into [ITEM_UPGRADE] values ('100062','5001','Normal-Weapons(+2)','<ELEMENTAL(A)','-1','2','379025000','0','0','0','0','0','0','0','0','5','9500','40');
insert into [ITEM_UPGRADE] values ('100063','5001','Normal-Weapons(+3)','<ELEMENTAL(A)','-1','3','379025000','0','0','0','0','0','0','0','0','5','9500','40');
insert into [ITEM_UPGRADE] values ('100064','5001','Normal-Weapons(+4)','<ELEMENTAL(A)','-1','4','379025000','0','0','0','0','0','0','0','0','5','9500','40');
insert into [ITEM_UPGRADE] values ('100065','5001','Normal-Weapons(+5)','<ELEMENTAL(A)','-1','5','379025000','0','0','0','0','0','0','0','0','5','9500','40');
insert into [ITEM_UPGRADE] values ('100066','5001','Normal-Weapons(+6)','<ELEMENTAL(A)','-1','6','379025000','0','0','0','0','0','0','0','0','5','9500','40');
insert into [ITEM_UPGRADE] values ('100067','5001','Normal-Weapons(+7)','<ELEMENTAL(A)','-1','7','379025000','0','0','0','0','0','0','0','0','5','9500','40');
insert into [ITEM_UPGRADE] values ('100068','5001','Normal-Weapons(+8)','<ELEMENTAL(A)','-1','8','379025000','0','0','0','0','0','0','0','0','5','9500','40');
insert into [ITEM_UPGRADE] values ('100069','5001','Normal-Weapons(+9)','<ELEMENTAL(A)','-1','9','379025000','0','0','0','0','0','0','0','0','5','9500','40');
insert into [ITEM_UPGRADE] values ('100070','5001','Normal-Weapons(+10)','<ELEMENTAL(A)','-1','10','379025000','0','0','0','0','0','0','0','0','5','9500','40');




insert into [ITEM_UPGRADE] values ('100071','5001','Normal-Weapons(+1)','<UPGRADE(A)','-1','1','379021000','0','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100072','5001','Normal-Weapons(+2)','<UPGRADE(A)','-1','2','379021000','0','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100073','5001','Normal-Weapons(+3)','<UPGRADE(A)','-1','3','379021000','0','0','0','0','0','0','0','0','0','8100','1');
insert into [ITEM_UPGRADE] values ('100074','5001','Normal-Weapons(+4)','<UPGRADE(A)','-1','4','379021000','0','0','0','0','0','0','0','0','5','6100','1');
insert into [ITEM_UPGRADE] values ('100075','5001','Normal-Weapons(+5)','<UPGRADE(A)','-1','5','379021000','0','0','0','0','0','0','0','0','8','4100','1');
insert into [ITEM_UPGRADE] values ('100076','5001','Normal-Weapons(+6)','<UPGRADE(A)','-1','6','379021000','0','0','0','0','0','0','0','0','10','2100','1');
insert into [ITEM_UPGRADE] values ('100077','5001','Normal-Weapons(+7)','<UPGRADE(A)','-1','7','379021000','0','0','0','0','0','0','0','0','11','850','1');
insert into [ITEM_UPGRADE] values ('100078','5001','Normal-Weapons(+8)','<UPGRADE(A)','-1','8','379021000','0','0','0','0','0','0','0','0','12','60','1');
insert into [ITEM_UPGRADE] values ('100079','5001','Normal-Weapons(+9)','<UPGRADE(A)','-1','9','379021000','0','0','0','0','0','0','0','0','13','6','1');


insert into [ITEM_UPGRADE] values ('100081','5001','Reduce-Weapons(+1)','<UPGRADE(A)','-1','31','379021000','0','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100082','5001','Reduce-Weapons(+2)','<UPGRADE(A)','-1','32','379021000','0','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100083','5001','Reduce-Weapons(+3)','<UPGRADE(A)','-1','33','379021000','0','0','0','0','0','0','0','0','3','8200','1');
insert into [ITEM_UPGRADE] values ('100084','5001','Reduce-Weapons(+4)','<UPGRADE(A)','-1','34','379021000','0','0','0','0','0','0','0','0','5','6200','1');
insert into [ITEM_UPGRADE] values ('100085','5001','Reduce-Weapons(+5)','<UPGRADE(A)','-1','35','379021000','0','0','0','0','0','0','0','0','8','4200','1');
insert into [ITEM_UPGRADE] values ('100086','5001','Reduce-Weapons(+6)','<UPGRADE(A)','-1','36','379021000','0','0','0','0','0','0','0','0','10','2200','1');
insert into [ITEM_UPGRADE] values ('100087','5001','Reduce-Weapons(+7)','<UPGRADE(A)','-1','37','379021000','0','0','0','0','0','0','0','0','11','950','1');
insert into [ITEM_UPGRADE] values ('100088','5001','Reduce-Weapons(+8)','<UPGRADE(A)','-1','38','379021000','0','0','0','0','0','0','0','0','12','70','1');
insert into [ITEM_UPGRADE] values ('100089','5001','Reduce-Weapons(+9)','<UPGRADE(A)','-1','39','379021000','0','0','0','0','0','0','0','0','13','7','1');


insert into [ITEM_UPGRADE] values ('100091','5001','Elemental-Weapons(+1)','<UPGRADE(A)','-1','41','379021000','0','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100092','5001','Elemental-Weapons(+2)','<UPGRADE(A)','-1','42','379021000','0','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100093','5001','Elemental-Weapons(+3)','<UPGRADE(A)','-1','43','379021000','0','0','0','0','0','0','0','0','3','8000','1');
insert into [ITEM_UPGRADE] values ('100094','5001','Elemental-Weapons(+4)','<UPGRADE(A)','-1','44','379021000','0','0','0','0','0','0','0','0','5','6000','1');
insert into [ITEM_UPGRADE] values ('100095','5001','Elemental-Weapons(+5)','<UPGRADE(A)','-1','45','379021000','0','0','0','0','0','0','0','0','8','4000','1');
insert into [ITEM_UPGRADE] values ('100096','5001','Elemental-Weapons(+6)','<UPGRADE(A)','-1','46','379021000','0','0','0','0','0','0','0','0','10','2000','1');
insert into [ITEM_UPGRADE] values ('100097','5001','Elemental-Weapons(+7)','<UPGRADE(A)','-1','47','379021000','0','0','0','0','0','0','0','0','11','750','1');
insert into [ITEM_UPGRADE] values ('100098','5001','Elemental-Weapons(+8)','<UPGRADE(A)','-1','48','379021000','0','0','0','0','0','0','0','0','12','50','1');
insert into [ITEM_UPGRADE] values ('100099','5001','Elemental-Weapons(+9)','<UPGRADE(A)','-1','49','379021000','0','0','0','0','0','0','0','0','13','5','1');




insert into [ITEM_UPGRADE] values ('100101','5001','Normal-Weapons(+1)','<UPGRADE(A) + TRINA','-1','1','700002000','379021000','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100102','5001','Normal-Weapons(+2)','<UPGRADE(A) + TRINA','-1','2','700002000','379021000','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100103','5001','Normal-Weapons(+3)','<UPGRADE(A) + TRINA','-1','3','700002000','379021000','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100104','5001','Normal-Weapons(+4)','<UPGRADE(A) + TRINA','-1','4','700002000','379021000','0','0','0','0','0','0','0','5','10000','1');
insert into [ITEM_UPGRADE] values ('100105','5001','Normal-Weapons(+5)','<UPGRADE(A) + TRINA','-1','5','700002000','379021000','0','0','0','0','0','0','0','8','8100','1');
insert into [ITEM_UPGRADE] values ('100106','5001','Normal-Weapons(+6)','<UPGRADE(A) + TRINA','-1','6','700002000','379021000','0','0','0','0','0','0','0','10','4100','1');
insert into [ITEM_UPGRADE] values ('100107','5001','Normal-Weapons(+7)','<UPGRADE(A) + TRINA','-1','7','700002000','379021000','0','0','0','0','0','0','0','11','1600','1');
insert into [ITEM_UPGRADE] values ('100108','5001','Normal-Weapons(+8)','<UPGRADE(A) + TRINA','-1','8','700002000','379021000','0','0','0','0','0','0','0','12','110','1');
insert into [ITEM_UPGRADE] values ('100109','5001','Normal-Weapons(+9)','<UPGRADE(A) + TRINA','-1','9','700002000','379021000','0','0','0','0','0','0','0','13','11','1');


insert into [ITEM_UPGRADE] values ('100111','5001','Reduce-Weapons(+1)','<UPGRADE(A) + TRINA','-1','31','700002000','379021000','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100112','5001','Reduce-Weapons(+2)','<UPGRADE(A) + TRINA','-1','32','700002000','379021000','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100113','5001','Reduce-Weapons(+3)','<UPGRADE(A) + TRINA','-1','33','700002000','379021000','0','0','0','0','0','0','0','3','10000','1');
insert into [ITEM_UPGRADE] values ('100114','5001','Reduce-Weapons(+4)','<UPGRADE(A) + TRINA','-1','34','700002000','379021000','0','0','0','0','0','0','0','5','10000','1');
insert into [ITEM_UPGRADE] values ('100115','5001','Reduce-Weapons(+5)','<UPGRADE(A) + TRINA','-1','35','700002000','379021000','0','0','0','0','0','0','0','8','8200','1');
insert into [ITEM_UPGRADE] values ('100116','5001','Reduce-Weapons(+6)','<UPGRADE(A) + TRINA','-1','36','700002000','379021000','0','0','0','0','0','0','0','10','4200','1');
insert into [ITEM_UPGRADE] values ('100117','5001','Reduce-Weapons(+7)','<UPGRADE(A) + TRINA','-1','37','700002000','379021000','0','0','0','0','0','0','0','11','1700','1');
insert into [ITEM_UPGRADE] values ('100118','5001','Reduce-Weapons(+8)','<UPGRADE(A) + TRINA','-1','38','700002000','379021000','0','0','0','0','0','0','0','12','120','1');
insert into [ITEM_UPGRADE] values ('100119','5001','Reduce-Weapons(+9)','<UPGRADE(A) + TRINA','-1','39','700002000','379021000','0','0','0','0','0','0','0','13','12','1');


insert into [ITEM_UPGRADE] values ('100121','5001','Elemental-Weapons(+1)','<UPGRADE(A) + TRINA','-1','41','700002000','379021000','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100122','5001','Elemental-Weapons(+2)','<UPGRADE(A) + TRINA','-1','42','700002000','379021000','0','0','0','0','0','0','0','0','10000','1');
insert into [ITEM_UPGRADE] values ('100123','5001','Elemental-Weapons(+3)','<UPGRADE(A) + TRINA','-1','43','700002000','379021000','0','0','0','0','0','0','0','3','10000','1');
insert into [ITEM_UPGRADE] values ('100124','5001','Elemental-Weapons(+4)','<UPGRADE(A) + TRINA','-1','44','700002000','379021000','0','0','0','0','0','0','0','5','10000','1');
insert into [ITEM_UPGRADE] values ('100125','5001','Elemental-Weapons(+5)','<UPGRADE(A) + TRINA','-1','45','700002000','379021000','0','0','0','0','0','0','0','8','8000','1');
insert into [ITEM_UPGRADE] values ('100126','5001','Elemental-Weapons(+6)','<UPGRADE(A) + TRINA','-1','46','700002000','379021000','0','0','0','0','0','0','0','10','4000','1');
insert into [ITEM_UPGRADE] values ('100127','5001','Elemental-Weapons(+7)','<UPGRADE(A) + TRINA','-1','47','700002000','379021000','0','0','0','0','0','0','0','11','1500','1');
insert into [ITEM_UPGRADE] values ('100128','5001','Elemental-Weapons(+8)','<UPGRADE(A) + TRINA','-1','48','700002000','379021000','0','0','0','0','0','0','0','12','100','1');
insert into [ITEM_UPGRADE] values ('100129','5001','Elemental-Weapons(+9)','<UPGRADE(A) + TRINA','-1','49','700002000','379021000','0','0','0','0','0','0','0','13','10','1');


----------

Ynt: Tüm ITEM_UPGRADE Tablosu ve Ek Açıklamalar
« Yanıtla #1 : 16 Nisan 2016, 02:39:13 »
Bu forumda konu açmak çok zor. Konunun devamına başka forumlardan bakabilirsiniz.
« Son Düzenleme: 16 Nisan 2016, 02:45:09 Gönderen: Kapagan »