- Katılım
- 6 Mayıs 2022
- Mesajlar
- 45,967
Bildiğiniz gibi item tablosunda item plus numaraları +9 sonra düzgün adlandırılmamış örnek vericek olursak,
Liste bu şekilde gidiyor. Birkaç gündür item tablosunu temize çekiyorum hemen hemen %60'ı bitti sayılır. Bunun için pratik scriptler hazırlıyorum. Birkaçını paylaşmak istedim.
Armorlar için mantık şu şekilde. Warrior shell helmet'i ele alalım +0 saf halinin item numarasını tanımlanmış değere yazıyorsunuz ve size kullanılabilir helmetleri listeliyor. Aynı zamanda item plus numarlarını doğru şekilde çağırıyor. +11 ise +11 çağırır. Race itemler dahil değildir.
Listelediği item listesi,
Weapon için biraz daha farklı, aslında aynı fakat ardışık numalardaki sıralama sistemi farklı.
Listeleme şu şekilde,
Weapon için,
Knight Online Private Server Oyununda Kullanılabilir Itemleri Listelemek (Doğru Plus Adları ile Birlikte)
Knight Online, özellikle private server (özel sunucu) kullanıcıları arasında büyük bir tutkuyla oynanan, nostaljik bir MMORPG oyunudur. Bu sunucularda geliştirilen sistemlerle oyuncular, orijinal oyunun ötesinde özel içeriklerle karşılaşabilir. Ancak bu özel sunucuların çoğu zaman farklı item listeleri, plus sistemleri ve emulator yapıları olabilir. Bu nedenle doğru plus adlarını bilmek, hem karakter gelişimini optimize eder hem de oyun içi dengeleri korumak açısından önemlidir.
Knight Online özel sunucularında item listeleme işlemi, genellikle server files (sunucu dosyaları) üzerinden yapılır. Özellikle item.bin, mob.bin, npc.bin gibi dosyalar üzerinden item verileri okunabilir. Bu dosyalar genellikle KO Dev (Knight Online Development) süreçlerinde düzenlenebilir. Bu dosyalarda yer alan item isimleri, client tarafında doğru şekilde gösterilebilir ve oyuncular tarafından kullanılabilir.
Item listesi çıkarılırken dikkat edilmesi gereken önemli bir konu, plus değerleridir. Örneğin bir chitin shell zırhı +10, +15 veya +20 gibi farklı plus seviyelerinde olabilir. Bu plus adları genellikle sunucuya özel tanımlanır ve bazı özel sunucularda USKO, ROFD, iKO, tKO gibi sistemlerde farklı isimler alabilir. Bu nedenle sunucuya özel database (veritabanı) dosyaları incelenmelidir.
Plus sistemleri, genellikle item üzerinde belirtilen bonuslara göre değişir. Bu bonuslar, attack, defense, critical, hit gibi özellikler artırılabilir. Doğru plus adlarını öğrenmek için, server files içindeki item verilerini okuyan araçlar veya KO Client Edit yazılımları kullanılabilir. Bunlar sayesinde sunucuda hangi itemin hangi plus değerlerine sahip olduğu kolayca görülebilir.
Knight Online özel sunucularında yaygın olarak kullanılan bazı item ve plus isimleri şunlardır:
- Chitin Shell +10 – Düşük seviye zırh bonusu.
- Iron Necklace +15 – Savunma artışı sağlar.
- Warrior Weapon +20 – Savaşçı sınıfları için ideal.
- Mage Staff +18 – Büyücü karakterler için güçlü bonuslar içerir.
Bu tür itemlerin doğru şekilde listelenmesi için, geliştiricilerin emulator sistemlerine ve source code yapısına hakim olması gerekir. Ayrıca KO Bot veya Macro Bot sistemleri üzerinden otomatik item kontrolü yapan yazılımlar da kullanılabilir. Bu yazılımlar, item isimlerini ve plus sistemlerini daha hızlı analiz etmede yardımcı olur.
Knight Lobby gibi platformlar, özel sunucu geliştiricileri ve oyuncuları için önemli bir bilgi merkezi haline gelmiştir. Burada yayınlanan KO Files, Server Files, Database içerikleri, geliştiricilerin doğru item listelerini çıkarmasında destek sağlar. Cap 83, Cap 70 gibi seviye sınırlamalarına göre itemlerin sınıflandırılması da önemlidir.
Sonuç olarak, Knight Online özel sunucularında doğru item ve plus adlarını listelemek, hem oyun deneyimini artırır hem de sunucu dengelerini korumada kritik rol oynar. KO Dev sürecinde doğru dosya yönetimi ve client uyumu sağlanmalıdır.
Listing Usable Items in Knight Online Private Server (With Correct Plus Names Included)
Knight Online remains a nostalgic MMORPG loved especially by private server enthusiasts. Within these custom servers, players often encounter unique content beyond the original game. However, many of these servers feature different item lists, plus systems, and emulator structures. Therefore, knowing the correct plus names not only helps optimize character development but also maintains in-game balance.
In Knight Online private servers, item listing is typically done via server files. Key files such as item.bin, mob.bin, and npc.bin contain the relevant data. These can be edited during KO Dev (Knight Online Development) processes. The items listed in these files are displayed correctly on the client side and become usable by players.
An important factor to consider when listing items is their plus values. For example, a chitin shell armor might come in different plus levels like +10, +15, or +20. These plus names are usually customized per server and may differ across systems like USKO, ROFD, iKO, tKO, etc. Thus, examining the server-specific database files is essential.
Plus systems generally depend on bonuses provided by the item, enhancing stats such as attack, defense, critical, hit, etc. To identify correct plus names, tools that read item data from server files or KO Client Edit software can be used. These allow developers to easily see which plus values each item has within the server.
Some commonly used items and plus names in Knight Online private servers include:
- Chitin Shell +10 – Provides low-level armor bonuses.
- Iron Necklace +15 – Increases defense stats.
- Warrior Weapon +20 – Ideal for warrior class characters.
- Mage Staff +18 – Offers strong bonuses for magic users.
To properly list such items, developers must be familiar with emulator systems and source code structures. Additionally, tools based on KO Bot or Macro Bot systems can assist in automatically checking item names and plus values, making analysis faster and more efficient.
Platforms like Knight Lobby serve as valuable information hubs for both developers and players of private servers. Content such as KO Files, Server Files, and Database resources shared here help developers accurately compile item lists. Categorizing items according to level caps like Cap 83 or Cap 70 is also crucial.
In conclusion, correctly listing items and plus names in Knight Online private servers enhances gameplay experience and plays a critical role in maintaining server balance. Proper file management and client compatibility should be ensured during the KO Dev process.
- <li data-xf-list-type="ul">+0 -> +10
<li data-xf-list-type="ul">+1 -> +11
<li data-xf-list-type="ul">..
<li data-xf-list-type="ul">+0 ->30
Liste bu şekilde gidiyor. Birkaç gündür item tablosunu temize çekiyorum hemen hemen %60'ı bitti sayılır. Bunun için pratik scriptler hazırlıyorum. Birkaçını paylaşmak istedim.
Armorlar için mantık şu şekilde. Warrior shell helmet'i ele alalım +0 saf halinin item numarasını tanımlanmış değere yazıyorsunuz ve size kullanılabilir helmetleri listeliyor. Aynı zamanda item plus numarlarını doğru şekilde çağırıyor. +11 ise +11 çağırır. Race itemler dahil değildir.
Listelediği item listesi,
Kod:
DECLARE @ItemID int = 567005001 SELECT * FROM ITEM WHERE (Num BETWEEN @ItemID+10000000 AND @ItemID+10000008) OR (Num BETWEEN @ItemID+10000030 AND @ItemID+10000038) OR (Num BETWEEN @ItemID+10000060 AND @ItemID+10000068) OR (Num BETWEEN @ItemID+10000090 AND @ItemID+10000098) OR (Num BETWEEN @ItemID+10000120 AND @ItemID+10000128) OR (Num BETWEEN @ItemID+10000150 AND @ItemID+10000158) OR (Num BETWEEN @ItemID+10000180 AND @ItemID+10000188) OR (Num BETWEEN @ItemID+10000210 AND @ItemID+10000218) UNION SELECT Num,REPLACE(strName,'(+0)','(+10)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Upgrade item(+0 to +10) (Num BETWEEN @ItemID AND @ItemID+39) OR (Num BETWEEN @ItemID+500 AND @ItemID+549) UNION SELECT Num,REPLACE(strName,'(+0)','(+10)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+0 to +10) Num IN(@ItemID+10000009, @ItemID+10000039, @ItemID+10000069, @ItemID+10000099, @ItemID+10000129, @ItemID+10000159, @ItemID+10000189, @ItemID+10000219, @ItemID+10000249) UNION SELECT Num,REPLACE(strName,'(+1)','(+11)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+1 to +11) Num IN(@ItemID+10000010, @ItemID+10000040, @ItemID+10000070, @ItemID+10000100, @ItemID+10000130, @ItemID+10000160, @ItemID+10000190, @ItemID+10000220, @ItemID+10000250) UNION SELECT Num,REPLACE(strName,'(+2)','(+12)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+2 to +12) Num IN(@ItemID+10000011, @ItemID+10000041, @ItemID+10000071, @ItemID+10000101, @ItemID+10000131, @ItemID+10000161, @ItemID+10000191, @ItemID+10000221, @ItemID+10000251) UNION SELECT Num,REPLACE(strName,'(+3)','(+13)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+3 to +13) Num IN(@ItemID+10000012, @ItemID+10000042, @ItemID+10000072, @ItemID+10000102, @ItemID+10000132, @ItemID+10000162, @ItemID+10000192, @ItemID+10000222, @ItemID+10000252) UNION SELECT Num,REPLACE(strName,'(+4)','(+14)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+4 to +14) Num IN(@ItemID+10000013, @ItemID+10000043, @ItemID+10000073, @ItemID+10000103, @ItemID+10000133, @ItemID+10000163, @ItemID+10000193, @ItemID+10000223, @ItemID+10000253) UNION SELECT Num,REPLACE(strName,'(+5)','(+15)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+5 to +15) Num IN(@ItemID+10000014, @ItemID+10000044, @ItemID+10000074, @ItemID+10000104, @ItemID+10000134, @ItemID+10000164, @ItemID+10000194, @ItemID+10000224, @ItemID+10000254) UNION SELECT Num,REPLACE(strName,'(+6)','(+16)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+6 to +16) Num IN(@ItemID+10000015, @ItemID+10000045, @ItemID+10000075, @ItemID+10000105, @ItemID+10000135, @ItemID+10000165, @ItemID+10000195, @ItemID+10000225, @ItemID+10000255) UNION SELECT Num,REPLACE(strName,'(+7)','(+17)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+7 to +17) Num IN(@ItemID+10000016, @ItemID+10000046, @ItemID+10000076, @ItemID+10000106, @ItemID+10000136, @ItemID+10000166, @ItemID+10000196, @ItemID+10000226, @ItemID+10000256) UNION SELECT Num,REPLACE(strName,'(+8)','(+18)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+8 to +18) Num IN(@ItemID+10000017, @ItemID+10000047, @ItemID+10000077, @ItemID+10000107, @ItemID+10000137, @ItemID+10000167, @ItemID+10000197, @ItemID+10000227, @ItemID+10000257) UNION SELECT Num,REPLACE(strName,'(+9)','(+19)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+9 to +19) Num IN(@ItemID+10000018, @ItemID+10000048, @ItemID+10000078, @ItemID+10000108, @ItemID+10000138, @ItemID+10000168, @ItemID+10000198, @ItemID+10000228, @ItemID+10000258) UNION SELECT Num,REPLACE(strName,'(+0)','(+20)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+0 to +20) Num IN(@ItemID+10000019, @ItemID+10000049, @ItemID+10000079, @ItemID+10000109, @ItemID+10000139, @ItemID+10000169, @ItemID+10000199, @ItemID+10000229, @ItemID+10000259) UNION SELECT Num,REPLACE(strName,'(+1)','(+21)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+1 to +21) Num IN(@ItemID+10000020, @ItemID+10000050, @ItemID+10000080, @ItemID+10000110, @ItemID+10000140, @ItemID+10000170, @ItemID+10000200, @ItemID+10000230, @ItemID+10000260) UNION SELECT Num,REPLACE(strName,'(+2)','(+22)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+2 to +22) Num IN(@ItemID+10000021, @ItemID+10000051, @ItemID+10000081, @ItemID+10000111, @ItemID+10000141, @ItemID+10000171, @ItemID+10000201, @ItemID+10000231, @ItemID+10000261) UNION SELECT Num,REPLACE(strName,'(+3)','(+23)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+3 to +23) Num IN(@ItemID+10000022, @ItemID+10000052, @ItemID+10000082, @ItemID+10000112, @ItemID+10000142, @ItemID+10000172, @ItemID+10000202, @ItemID+10000232, @ItemID+10000262) UNION SELECT Num,REPLACE(strName,'(+4)','(+24)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+4 to +24) Num IN(@ItemID+10000023, @ItemID+10000053, @ItemID+10000083, @ItemID+10000113, @ItemID+10000143, @ItemID+10000173, @ItemID+10000203, @ItemID+10000233, @ItemID+10000263) UNION SELECT Num,REPLACE(strName,'(+5)','(+25)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+5 to +25) Num IN(@ItemID+10000024, @ItemID+10000054, @ItemID+10000084, @ItemID+10000114, @ItemID+10000144, @ItemID+10000174, @ItemID+10000204, @ItemID+10000234, @ItemID+10000264) UNION SELECT Num,REPLACE(strName,'(+6)','(+26)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+6 to +26) Num IN(@ItemID+10000025, @ItemID+10000055, @ItemID+10000085, @ItemID+10000115, @ItemID+10000145, @ItemID+10000175, @ItemID+10000205, @ItemID+10000235, @ItemID+10000265) UNION SELECT Num,REPLACE(strName,'(+7)','(+27)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+7 to +27) Num IN(@ItemID+10000026, @ItemID+10000056, @ItemID+10000086, @ItemID+10000116, @ItemID+10000146, @ItemID+10000176, @ItemID+10000206, @ItemID+10000236, @ItemID+10000266) UNION SELECT Num,REPLACE(strName,'(+8)','(+28)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+8 to +28) Num IN(@ItemID+10000027, @ItemID+10000057, @ItemID+10000087, @ItemID+10000117, @ItemID+10000147, @ItemID+10000177, @ItemID+10000207, @ItemID+10000237, @ItemID+10000267) UNION SELECT Num,REPLACE(strName,'(+9)','(+29)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+9 to +29) Num IN(@ItemID+10000028, @ItemID+10000058, @ItemID+10000088, @ItemID+10000118, @ItemID+10000148, @ItemID+10000178, @ItemID+10000208, @ItemID+10000238, @ItemID+10000268) UNION SELECT Num,REPLACE(strName,'(+0)','(+30)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+0 to +30) Num IN(@ItemID+10000029, @ItemID+10000059, @ItemID+10000089, @ItemID+10000119, @ItemID+10000149, @ItemID+10000179, @ItemID+10000209, @ItemID+10000239, @ItemID+10000269) ORDER BY Num ASC GOWeapon için biraz daha farklı, aslında aynı fakat ardışık numalardaki sıralama sistemi farklı.
Listeleme şu şekilde,
Kod:
Shard(Non-posion)(1-10) Shard(Posion)(1-10) Shard(Non-posion)(Reduce)(1-10) Shard(Posion)(1-30) Shard(Non-posion)(Reduce)(1-30)Weapon için,
Kod:
DECLARE @ItemID int = 150450001 SELECT * FROM ITEM WHERE (Num BETWEEN @ItemID+1000 AND @ItemID+1008) OR (Num BETWEEN @ItemID+1030 AND @ItemID+1038) OR (Num BETWEEN @ItemID+1060 AND @ItemID+1068) OR (Num BETWEEN @ItemID+1090 AND @ItemID+1098) OR (Num BETWEEN @ItemID+1120 AND @ItemID+1128) OR (Num BETWEEN @ItemID+1150 AND @ItemID+1158) OR (Num BETWEEN @ItemID+1180 AND @ItemID+1188) OR (Num BETWEEN @ItemID+1210 AND @ItemID+1218) UNION SELECT Num,REPLACE(strName,'(+0)','(+10)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Upgrade item(+0 to +10) (Num BETWEEN @ItemID AND @ItemID+9) OR (Num BETWEEN @ItemID+30 AND @ItemID+49) UNION SELECT Num,REPLACE(strName,'(+0)','(+10)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+0 to +10) Num IN(@ItemID+1009, @ItemID+1039) UNION SELECT Num,REPLACE(strName,'(+1)','(+11)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+1 to +11) Num IN(@ItemID+1010, @ItemID+1040) UNION SELECT Num,REPLACE(strName,'(+2)','(+12)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+2 to +12) Num IN(@ItemID+1011, @ItemID+1041) UNION SELECT Num,REPLACE(strName,'(+3)','(+13)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+3 to +13) Num IN(@ItemID+1012, @ItemID+1042) UNION SELECT Num,REPLACE(strName,'(+4)','(+14)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+4 to +14) Num IN(@ItemID+1013, @ItemID+1043) UNION SELECT Num,REPLACE(strName,'(+5)','(+15)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+5 to +15) Num IN(@ItemID+1014, @ItemID+1044) UNION SELECT Num,REPLACE(strName,'(+6)','(+16)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+6 to +16) Num IN(@ItemID+1015, @ItemID+1045) UNION SELECT Num,REPLACE(strName,'(+7)','(+17)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+7 to +17) Num IN(@ItemID+1016, @ItemID+1046) UNION SELECT Num,REPLACE(strName,'(+8)','(+18)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+8 to +18) Num IN(@ItemID+1017, @ItemID+1047) UNION SELECT Num,REPLACE(strName,'(+9)','(+19)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+9 to +19) Num IN(@ItemID+1018, @ItemID+1048) UNION SELECT Num,REPLACE(strName,'(+0)','(+20)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+0 to +20) Num IN(@ItemID+1019, @ItemID+1049) UNION SELECT Num,REPLACE(strName,'(+1)','(+21)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+1 to +21) Num IN(@ItemID+1020, @ItemID+1050) UNION SELECT Num,REPLACE(strName,'(+2)','(+22)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+2 to +22) Num IN(@ItemID+1021, @ItemID+1051) UNION SELECT Num,REPLACE(strName,'(+3)','(+23)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+3 to +23) Num IN(@ItemID+1022, @ItemID+1052) UNION SELECT Num,REPLACE(strName,'(+4)','(+24)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+4 to +24) Num IN(@ItemID+1023, @ItemID+1053) UNION SELECT Num,REPLACE(strName,'(+5)','(+25)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+5 to +25) Num IN(@ItemID+1024, @ItemID+1054) UNION SELECT Num,REPLACE(strName,'(+6)','(+26)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+6 to +26) Num IN(@ItemID+1025, @ItemID+1055) UNION SELECT Num,REPLACE(strName,'(+7)','(+27)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+7 to +27) Num IN(@ItemID+1026, @ItemID+1056) UNION SELECT Num,REPLACE(strName,'(+8)','(+28)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+8 to +28) Num IN(@ItemID+1027, @ItemID+1057) UNION SELECT Num,REPLACE(strName,'(+9)','(+29)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+9 to +29) Num IN(@ItemID+1028, @ItemID+1058) UNION SELECT Num,REPLACE(strName,'(+0)','(+30)'),Kind,Slot,Race,Class,Damage,[Delay],[Range],[Weight],Duration,BuyPrice,SellPrice,Ac,Countable,Effect1,Effect2,ReqLevel,ReqLevelMax,ReqRank,ReqTitle,ReqStr,ReqSta,ReqDex,ReqIntel,ReqCha,SellingGroup,ItemType,Hitrate,Evasionrate,DaggerAc,SwordAc,MaceAc,AxeAc,SpearAc,BowAc,FireDamage,IceDamage,LightningDamage,PoisonDamage,HPDrain,MPDamage,MPDrain,MirrorDamage,StrB,StaB,DexB,IntelB,ChaB,MaxHpB,MaxMpB,FireR,ColdR,LightningR,MagicR,PoisonR,CurseR FROM ITEM WHERE -- Rebirth upgrade item (+0 to +30) Num IN(@ItemID+1029, @ItemID+1059) ORDER BY Num ASC GOKnight Online Private Server Oyununda Kullanılabilir Itemleri Listelemek (Doğru Plus Adları ile Birlikte)
Knight Online, özellikle private server (özel sunucu) kullanıcıları arasında büyük bir tutkuyla oynanan, nostaljik bir MMORPG oyunudur. Bu sunucularda geliştirilen sistemlerle oyuncular, orijinal oyunun ötesinde özel içeriklerle karşılaşabilir. Ancak bu özel sunucuların çoğu zaman farklı item listeleri, plus sistemleri ve emulator yapıları olabilir. Bu nedenle doğru plus adlarını bilmek, hem karakter gelişimini optimize eder hem de oyun içi dengeleri korumak açısından önemlidir.
Knight Online özel sunucularında item listeleme işlemi, genellikle server files (sunucu dosyaları) üzerinden yapılır. Özellikle item.bin, mob.bin, npc.bin gibi dosyalar üzerinden item verileri okunabilir. Bu dosyalar genellikle KO Dev (Knight Online Development) süreçlerinde düzenlenebilir. Bu dosyalarda yer alan item isimleri, client tarafında doğru şekilde gösterilebilir ve oyuncular tarafından kullanılabilir.
Item listesi çıkarılırken dikkat edilmesi gereken önemli bir konu, plus değerleridir. Örneğin bir chitin shell zırhı +10, +15 veya +20 gibi farklı plus seviyelerinde olabilir. Bu plus adları genellikle sunucuya özel tanımlanır ve bazı özel sunucularda USKO, ROFD, iKO, tKO gibi sistemlerde farklı isimler alabilir. Bu nedenle sunucuya özel database (veritabanı) dosyaları incelenmelidir.
Plus sistemleri, genellikle item üzerinde belirtilen bonuslara göre değişir. Bu bonuslar, attack, defense, critical, hit gibi özellikler artırılabilir. Doğru plus adlarını öğrenmek için, server files içindeki item verilerini okuyan araçlar veya KO Client Edit yazılımları kullanılabilir. Bunlar sayesinde sunucuda hangi itemin hangi plus değerlerine sahip olduğu kolayca görülebilir.
Knight Online özel sunucularında yaygın olarak kullanılan bazı item ve plus isimleri şunlardır:
- Chitin Shell +10 – Düşük seviye zırh bonusu.
- Iron Necklace +15 – Savunma artışı sağlar.
- Warrior Weapon +20 – Savaşçı sınıfları için ideal.
- Mage Staff +18 – Büyücü karakterler için güçlü bonuslar içerir.
Bu tür itemlerin doğru şekilde listelenmesi için, geliştiricilerin emulator sistemlerine ve source code yapısına hakim olması gerekir. Ayrıca KO Bot veya Macro Bot sistemleri üzerinden otomatik item kontrolü yapan yazılımlar da kullanılabilir. Bu yazılımlar, item isimlerini ve plus sistemlerini daha hızlı analiz etmede yardımcı olur.
Knight Lobby gibi platformlar, özel sunucu geliştiricileri ve oyuncuları için önemli bir bilgi merkezi haline gelmiştir. Burada yayınlanan KO Files, Server Files, Database içerikleri, geliştiricilerin doğru item listelerini çıkarmasında destek sağlar. Cap 83, Cap 70 gibi seviye sınırlamalarına göre itemlerin sınıflandırılması da önemlidir.
Sonuç olarak, Knight Online özel sunucularında doğru item ve plus adlarını listelemek, hem oyun deneyimini artırır hem de sunucu dengelerini korumada kritik rol oynar. KO Dev sürecinde doğru dosya yönetimi ve client uyumu sağlanmalıdır.
Listing Usable Items in Knight Online Private Server (With Correct Plus Names Included)
Knight Online remains a nostalgic MMORPG loved especially by private server enthusiasts. Within these custom servers, players often encounter unique content beyond the original game. However, many of these servers feature different item lists, plus systems, and emulator structures. Therefore, knowing the correct plus names not only helps optimize character development but also maintains in-game balance.
In Knight Online private servers, item listing is typically done via server files. Key files such as item.bin, mob.bin, and npc.bin contain the relevant data. These can be edited during KO Dev (Knight Online Development) processes. The items listed in these files are displayed correctly on the client side and become usable by players.
An important factor to consider when listing items is their plus values. For example, a chitin shell armor might come in different plus levels like +10, +15, or +20. These plus names are usually customized per server and may differ across systems like USKO, ROFD, iKO, tKO, etc. Thus, examining the server-specific database files is essential.
Plus systems generally depend on bonuses provided by the item, enhancing stats such as attack, defense, critical, hit, etc. To identify correct plus names, tools that read item data from server files or KO Client Edit software can be used. These allow developers to easily see which plus values each item has within the server.
Some commonly used items and plus names in Knight Online private servers include:
- Chitin Shell +10 – Provides low-level armor bonuses.
- Iron Necklace +15 – Increases defense stats.
- Warrior Weapon +20 – Ideal for warrior class characters.
- Mage Staff +18 – Offers strong bonuses for magic users.
To properly list such items, developers must be familiar with emulator systems and source code structures. Additionally, tools based on KO Bot or Macro Bot systems can assist in automatically checking item names and plus values, making analysis faster and more efficient.
Platforms like Knight Lobby serve as valuable information hubs for both developers and players of private servers. Content such as KO Files, Server Files, and Database resources shared here help developers accurately compile item lists. Categorizing items according to level caps like Cap 83 or Cap 70 is also crucial.
In conclusion, correctly listing items and plus names in Knight Online private servers enhances gameplay experience and plays a critical role in maintaining server balance. Proper file management and client compatibility should be ensured during the KO Dev process.
