- Katılım
- 6 Mayıs 2022
- Mesajlar
- 45,967
Merhabalar,
BaseTR sunucusunun Adminliğini ben yapıyorum. Daha önce pek bir paylaşımda bulunmadım açıkcası. Acemiyim. Ancak bir yerden başlamak lazım.
Bir çok kişi arıyor, doğru düzgün olanını bulamıyor. Bulsa bile yapamıyor. Bazıları bunun 'Virüslü' editörünü yapmış milleti kekliyor. Umarım işinize yarar. Ben KO-FOX ailesi için paylaşıyorum. Emeğe saygı derdim ama zaten başka bir forumda, başka bir isimle çıkar yarına.. Siz yararlanın yeter.
- ALINTI DEĞİLDİR -
[HIDE-REPLY]
[/HIDE-REPLY]
Açıklaması;
- 'nExchangeItemNum' yazan kısımlar vereceği itemin kodu. Örneğin; 'Iron Neck' vs. ekleyebilirsiniz. Sadece kodunu yazmanız yeterli.
- 'nExchangeItemCount' yazan kısımlar ise çıkma oranı. 5lik bir slotun toplamı 10.000 olmak zorundadır.
Örneğin;
Count1 = 1000, Count2 = 2000, Count3 = 5000, Count4 = 1000, Count5 = 1000 = TOTAL 10.000
veya;
Count1 = 100, Count2 = 200, Count3 = 500, Count4 = 200, Count5 = 9000 = TOTAL 10.000
Düşük oranlı kısımlara güzel itemler, yüksek oranlı kısımlara BUS, POT gibi ezik itemler koyabilirsiniz. Kafanıza göre ayarlayın.
Tebrikler, Chaotic Generatörden çıkan eşyaları başarıyla düzenlediniz!
NOT: 21.EVT'yi editleyerek ve ITEM_EXCHANGE tablosunu editleyerek daha çok ihtimal yaratılabilir. Tamamen yaratıcılığınıza kalmış. Ben KÖK kodunu paylaşıyım. Kolay gelsin.
V1299 - Fragment & Gem Droplarını Ayarlamak - SQL Kodu | Programsız
Knight Online özel sunucularında geliştirme yaparken, drop sistemlerinin ayarlanması önemli bir konudur. Özellikle Fragment ve Gem gibi nadir ödüllerin düşüş oranlarını kontrol etmek, hem oyuncu deneyimini artırır hem de sunucu dengelerini optimize eder. Bu yazıda, V1299 sürümüne uygun olarak Fragment ve Gem droplarını SQL kodu ile nasıl değiştireceğinizi adım adım anlatacağız. Programlama bilgisi gerektirmeden sadece veritabanı düzenlemesiyle bu işlemi gerçekleştirebilirsiniz.
Knight Online Drop Sistemi Nedir?
Knight Online özel sunucularında, her bir NPC (Mob) belirli eşyaları belirli oranlarda düşürür. Bu sistem, itemdb, mob, drop gibi tablolara dayanır. Drop oranları genellikle MobDropTableInfo adlı tablo üzerinden düzenlenir. Burada Fragment ve Gem gibi özel eşyaların düşüş oranları da tanımlanabilir.
V1299 İçin Fragment ve Gem Drop Ayarlaması
V1299 sürümünde Fragment ve Gem eşyalarının düşmesi için ilgili item ID'lerini doğru şekilde MobDropTableInfo tablosuna eklemek gerekir. Öncelikle, hangi eşyanın hangi ID ile tanımlandığını kontrol etmeniz gerekir. Bu bilgi genellikle Item.txt dosyasında yer alır.
Örnek Item ID Listesi:
- Fragment: 10001
- Gem: 10002
SQL Kodu Örneği:
Aşağıdaki SQL komutu ile tüm NPC'lerin Fragment veya Gem düşürme oranını %1 olarak ayarlayabilirsiniz:
Not: m_iMobID = 0 tüm NPC'leri kapsar. Belirli bir NPC'ye özel drop tanımlamak isterseniz, o NPC'nin ID'sini kullanmalısınız.
Drop Oranlarını Kontrol Etme
Yukarıdaki kodlarla drop tanımladıktan sonra, sunucunuzu yeniden başlatmanız gerekmez. Ancak bazı sunucular drop tablolarını restart sırasında yüklediği için değişikliğin aktif olması için sunucuyu yeniden başlatmanız gerekebilir. Drop oranlarını test etmek için test sunucusunda düşük seviyeli NPC'leri öldürerek sonuçları gözlemleyebilirsiniz.
Knight Lobby Üyelerine Özel İpuçları
Sunucunuzda Fragment ve Gem drop oranlarını ayarlarken, rate değerini çok yüksek tutarsanız, bu eşyaların değeri azalabilir. Bu nedenle, dengeli ve gerçekçi oranlar belirlemek önemlidir. Ayrıca, oyuncuların bu eşyalara olan ilgisini artırmak için özel etkinlikler veya çift drop haftasonları gibi zamanlar planlayabilirsiniz.
Knight Online özel sunucularında geliştirme yaparken, drop sistemlerini doğru yönetmek, hem oyuncu memnuniyetini artırır hem de sunucunuzun rekabet gücünü korumanızı sağlar. Bu rehber sayesinde Fragment ve Gem droplarını kolayca ayarlayabilir, oyuncular için daha keyifli bir deneyim yaratabilirsiniz.
Kaynaklar:
Knight Lobby, Knight Lobby adresinden KO özel sunucu dosyaları, emulator ve geliştirme kaynaklarına ulaşabilirsiniz.
V1299 - Setting Fragment & Gem Drops with SQL Code | No Programming Required
When developing Knight Online private servers, configuring drop systems is a critical task. Especially adjusting the drop rates of rare items like Fragment and Gem helps enhance player experience and balance server mechanics. In this article, we'll guide you step-by-step on how to change Fragment and Gem drop rates using SQL code for the V1299 version. You can perform this process solely through database modifications without needing programming knowledge.
What Is the Knight Online Drop System?
In Knight Online private servers, each NPC (Mob) drops specific items at certain rates. This system relies on tables such as itemdb, mob, and drop. Drop rates are typically managed via the MobDropTableInfo table, where drops for special items like Fragments and Gems can also be defined.
Configuring Fragment and Gem Drops for V1299
To enable Fragments and Gems to drop in the V1299 version, you must add the corresponding item IDs correctly into the MobDropTableInfo table. First, verify which IDs correspond to these items; this information is usually found in the Item.txt file.
Sample Item ID List:
- Fragment: 10001
- Gem: 10002
Example SQL Code:
With the following SQL command, you can set the drop rate for Fragments or Gems from all NPCs to 1%:
Note: m_iMobID = 0 covers all NPCs. If you want to define drops for specific NPCs only, use their individual IDs instead.
Checking Drop Rates
After applying the above codes, you may not need to restart your server. However, some servers load drop tables upon restart, so a server reboot might be required for the changes to take effect. You can test drop rates by killing low-level NPCs in a test environment to observe results.
Tips for Knight Lobby Members
While setting Fragment and Gem drop rates, avoid setting the rate too high, as this will decrease the value of these items. Therefore, setting balanced and realistic rates is crucial. Additionally, you can increase player interest in these items by scheduling special events or double drop weekends.
Properly managing drop systems while developing Knight Online private servers enhances player satisfaction and maintains the competitive edge of your server. With this guide, you can easily configure Fragment and Gem drops to create a more enjoyable experience for players.
Resources:
Knight Lobby offers access to KO private server files, emulators, and development resources at Knight Lobby.
BaseTR sunucusunun Adminliğini ben yapıyorum. Daha önce pek bir paylaşımda bulunmadım açıkcası. Acemiyim. Ancak bir yerden başlamak lazım.
Bir çok kişi arıyor, doğru düzgün olanını bulamıyor. Bulsa bile yapamıyor. Bazıları bunun 'Virüslü' editörünü yapmış milleti kekliyor. Umarım işinize yarar. Ben KO-FOX ailesi için paylaşıyorum. Emeğe saygı derdim ama zaten başka bir forumda, başka bir isimle çıkar yarına.. Siz yararlanın yeter.
- ALINTI DEĞİLDİR -
[HIDE-REPLY]
Kod:
## Framgnet of Arrogance ## update ITEM_EXCHANGE set nExchangeItemNum1 = '700002000' where nIndex = '36081' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36081' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '36081' update ITEM_EXCHANGE set nExchangeItemCount2 = '8000' where nIndex = '36081' update ITEM_EXCHANGE set nExchangeItemNum3 = '207003705' where nIndex = '36081' update ITEM_EXCHANGE set nExchangeItemCount3 = '500' where nIndex = '36081' update ITEM_EXCHANGE set nExchangeItemNum4 = '207004705' where nIndex = '36081' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '36081' update ITEM_EXCHANGE set nExchangeItemNum5 = '247004715' where nIndex = '36081' update ITEM_EXCHANGE set nExchangeItemCount5 = '500' where nIndex = '36081' update ITEM_EXCHANGE set nExchangeItemNum1 = '247005715' where nIndex = '36082' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36082' update ITEM_EXCHANGE set nExchangeItemNum2 = '247002715' where nIndex = '36082' update ITEM_EXCHANGE set nExchangeItemCount2 = '500' where nIndex = '36082' update ITEM_EXCHANGE set nExchangeItemNum3 = '207005705' where nIndex = '36082' update ITEM_EXCHANGE set nExchangeItemCount3 = '500' where nIndex = '36082' update ITEM_EXCHANGE set nExchangeItemNum4 = '207001705' where nIndex = '36082' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '36082' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '36082' update ITEM_EXCHANGE set nExchangeItemCount5 = '8000' where nIndex = '36082' update ITEM_EXCHANGE set nExchangeItemNum1 = '247002715' where nIndex = '36083' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36083' update ITEM_EXCHANGE set nExchangeItemNum2 = '247001715' where nIndex = '36083' update ITEM_EXCHANGE set nExchangeItemCount2 = '500' where nIndex = '36083' update ITEM_EXCHANGE set nExchangeItemNum3 = '207002705' where nIndex = '36083' update ITEM_EXCHANGE set nExchangeItemCount3 = '900' where nIndex = '36083' update ITEM_EXCHANGE set nExchangeItemNum4 = '320310126' where nIndex = '36083' update ITEM_EXCHANGE set nExchangeItemCount4 = '100' where nIndex = '36083' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '36083' update ITEM_EXCHANGE set nExchangeItemCount5 = '8000' where nIndex = '36083' ################################################################################## ## Framgnet of Glutton ## update ITEM_EXCHANGE set nExchangeItemNum1 = '700002000' where nIndex = '36181' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36181' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '36181' update ITEM_EXCHANGE set nExchangeItemCount2 = '8000' where nIndex = '36181' update ITEM_EXCHANGE set nExchangeItemNum3 = '267002725' where nIndex = '36181' update ITEM_EXCHANGE set nExchangeItemCount3 = '500' where nIndex = '36181' update ITEM_EXCHANGE set nExchangeItemNum4 = '267004725' where nIndex = '36181' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '36181' update ITEM_EXCHANGE set nExchangeItemNum5 = '287004735' where nIndex = '36181' update ITEM_EXCHANGE set nExchangeItemCount5 = '500' where nIndex = '36181' update ITEM_EXCHANGE set nExchangeItemNum1 = '287005735' where nIndex = '36182' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36182' update ITEM_EXCHANGE set nExchangeItemNum2 = '287001735' where nIndex = '36182' update ITEM_EXCHANGE set nExchangeItemCount2 = '500' where nIndex = '36182' update ITEM_EXCHANGE set nExchangeItemNum3 = '267005725' where nIndex = '36182' update ITEM_EXCHANGE set nExchangeItemCount3 = '500' where nIndex = '36182' update ITEM_EXCHANGE set nExchangeItemNum4 = '267001725' where nIndex = '36182' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '36182' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '36182' update ITEM_EXCHANGE set nExchangeItemCount5 = '8000' where nIndex = '36182' update ITEM_EXCHANGE set nExchangeItemNum1 = '287002735' where nIndex = '36183' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36183' update ITEM_EXCHANGE set nExchangeItemNum2 = '287003735' where nIndex = '36183' update ITEM_EXCHANGE set nExchangeItemCount2 = '500' where nIndex = '36183' update ITEM_EXCHANGE set nExchangeItemNum3 = '267003725' where nIndex = '36183' update ITEM_EXCHANGE set nExchangeItemCount3 = '900' where nIndex = '36183' update ITEM_EXCHANGE set nExchangeItemNum4 = '340610107' where nIndex = '36183' update ITEM_EXCHANGE set nExchangeItemCount4 = '100' where nIndex = '36183' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '36183' update ITEM_EXCHANGE set nExchangeItemCount5 = '8000' where nIndex = '36183' ################################################################################## ## Framgnet of Rage ## update ITEM_EXCHANGE set nExchangeItemNum1 = '700002000' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemCount2 = '8000' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemNum3 = '340410109' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemCount3 = '500' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemNum4 = '128440835' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemNum5 = '139430775' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemCount5 = '500' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemNum1 = '197420345' where nIndex = '36282' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36282' update ITEM_EXCHANGE set nExchangeItemNum2 = '320110302' where nIndex = '36282' update ITEM_EXCHANGE set nExchangeItemCount2 = '500' where nIndex = '36282' update ITEM_EXCHANGE set nExchangeItemNum3 = '320110322' where nIndex = '36282' update ITEM_EXCHANGE set nExchangeItemCount3 = '500' where nIndex = '36282' update ITEM_EXCHANGE set nExchangeItemNum4 = '320110312' where nIndex = '36282' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '36282' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '36282' update ITEM_EXCHANGE set nExchangeItemCount5 = '8000' where nIndex = '36282' update ITEM_EXCHANGE set nExchangeItemNum1 = '182430815' where nIndex = '36283' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36283' update ITEM_EXCHANGE set nExchangeItemNum2 = '184430875' where nIndex = '36283' update ITEM_EXCHANGE set nExchangeItemCount2 = '500' where nIndex = '36283' update ITEM_EXCHANGE set nExchangeItemNum3 = '183230845' where nIndex = '36283' update ITEM_EXCHANGE set nExchangeItemCount3 = '500' where nIndex = '36283' update ITEM_EXCHANGE set nExchangeItemNum4 = '340410115' where nIndex = '36283' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '36283' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '36283' update ITEM_EXCHANGE set nExchangeItemCount5 = '8000' where nIndex = '36283' ################################################################################## ## Framgnet of Sloth ## update ITEM_EXCHANGE set nExchangeItemNum1 = '700002000' where nIndex = '36381' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36381' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '36381' update ITEM_EXCHANGE set nExchangeItemCount2 = '7500' where nIndex = '36381' update ITEM_EXCHANGE set nExchangeItemNum3 = '810081000' where nIndex = '36381' update ITEM_EXCHANGE set nExchangeItemCount3 = '1000' where nIndex = '36381' update ITEM_EXCHANGE set nExchangeItemNum4 = '330111441' where nIndex = '36381' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '36381' update ITEM_EXCHANGE set nExchangeItemNum5 = '330151451' where nIndex = '36381' update ITEM_EXCHANGE set nExchangeItemCount5 = '500' where nIndex = '36381' update ITEM_EXCHANGE set nExchangeItemNum1 = '247004715' where nIndex = '36382' update ITEM_EXCHANGE set nExchangeItemCount1 = '750' where nIndex = '36382' update ITEM_EXCHANGE set nExchangeItemNum2 = '247005715' where nIndex = '36382' update ITEM_EXCHANGE set nExchangeItemCount2 = '750' where nIndex = '36382' update ITEM_EXCHANGE set nExchangeItemNum3 = '247002715' where nIndex = '36382' update ITEM_EXCHANGE set nExchangeItemCount3 = '750' where nIndex = '36382' update ITEM_EXCHANGE set nExchangeItemNum4 = '320110312' where nIndex = '36382' update ITEM_EXCHANGE set nExchangeItemCount4 = '750' where nIndex = '36382' update ITEM_EXCHANGE set nExchangeItemNum5 = '247003715' where nIndex = '36382' update ITEM_EXCHANGE set nExchangeItemCount5 = '7000' where nIndex = '36382' update ITEM_EXCHANGE set nExchangeItemNum1 = '207003705' where nIndex = '36383' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36383' update ITEM_EXCHANGE set nExchangeItemNum2 = '207004705' where nIndex = '36383' update ITEM_EXCHANGE set nExchangeItemCount2 = '500' where nIndex = '36383' update ITEM_EXCHANGE set nExchangeItemNum3 = '207005705' where nIndex = '36383' update ITEM_EXCHANGE set nExchangeItemCount3 = '500' where nIndex = '36383' update ITEM_EXCHANGE set nExchangeItemNum4 = '247001715' where nIndex = '36383' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '36383' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '36383' update ITEM_EXCHANGE set nExchangeItemCount5 = '8000' where nIndex = '36383' ################################################################################## ## Framgnet of Lechery ## update ITEM_EXCHANGE set nExchangeItemNum1 = '700002000' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemCount2 = '7500' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemNum3 = '800008000' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemCount3 = '1000' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemNum4 = '207001705' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemNum5 = '207002705' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemCount5 = '500' where nIndex = '36481' update ITEM_EXCHANGE set nExchangeItemNum1 = '310511131' where nIndex = '36482' update ITEM_EXCHANGE set nExchangeItemCount1 = '750' where nIndex = '36482' update ITEM_EXCHANGE set nExchangeItemNum2 = '310512141' where nIndex = '36482' update ITEM_EXCHANGE set nExchangeItemCount2 = '750' where nIndex = '36482' update ITEM_EXCHANGE set nExchangeItemNum3 = '287004735' where nIndex = '36482' update ITEM_EXCHANGE set nExchangeItemCount3 = '750' where nIndex = '36482' update ITEM_EXCHANGE set nExchangeItemNum4 = '287005735' where nIndex = '36482' update ITEM_EXCHANGE set nExchangeItemCount4 = '750' where nIndex = '36482' update ITEM_EXCHANGE set nExchangeItemNum5 = '247003715' where nIndex = '36482' update ITEM_EXCHANGE set nExchangeItemCount5 = '7000' where nIndex = '36482' update ITEM_EXCHANGE set nExchangeItemNum1 = '287001735' where nIndex = '36483' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36483' update ITEM_EXCHANGE set nExchangeItemNum2 = '287002735' where nIndex = '36483' update ITEM_EXCHANGE set nExchangeItemCount2 = '500' where nIndex = '36483' update ITEM_EXCHANGE set nExchangeItemNum3 = '287003735' where nIndex = '36483' update ITEM_EXCHANGE set nExchangeItemCount3 = '500' where nIndex = '36483' update ITEM_EXCHANGE set nExchangeItemNum4 = '810080000' where nIndex = '36483' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '36483' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '36483' update ITEM_EXCHANGE set nExchangeItemCount5 = '8000' where nIndex = '36483' ################################################################################## ## Fragment of Jealousy ## update ITEM_EXCHANGE set nExchangeItemNum1 = '700002000' where nIndex = '36581' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36581' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '36581' update ITEM_EXCHANGE set nExchangeItemCount2 = '7000' where nIndex = '36581' update ITEM_EXCHANGE set nExchangeItemNum3 = '310512141' where nIndex = '36581' update ITEM_EXCHANGE set nExchangeItemCount3 = '1000' where nIndex = '36581' update ITEM_EXCHANGE set nExchangeItemNum4 = '310410241' where nIndex = '36581' update ITEM_EXCHANGE set nExchangeItemCount4 = '100' where nIndex = '36581' update ITEM_EXCHANGE set nExchangeItemNum5 = '310610251' where nIndex = '36581' update ITEM_EXCHANGE set nExchangeItemCount5 = '500' where nIndex = '36581' update ITEM_EXCHANGE set nExchangeItemNum1 = '310511131' where nIndex = '36582' update ITEM_EXCHANGE set nExchangeItemCount1 = '1000' where nIndex = '36582' update ITEM_EXCHANGE set nExchangeItemNum2 = '330111441' where nIndex = '36582' update ITEM_EXCHANGE set nExchangeItemCount2 = '1000' where nIndex = '36582' update ITEM_EXCHANGE set nExchangeItemNum3 = '330151451' where nIndex = '36582' update ITEM_EXCHANGE set nExchangeItemCount3 = '1000' where nIndex = '36582' update ITEM_EXCHANGE set nExchangeItemNum4 = '320110322' where nIndex = '36582' update ITEM_EXCHANGE set nExchangeItemCount4 = '1000' where nIndex = '36582' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '36582' update ITEM_EXCHANGE set nExchangeItemCount5 = '6000' where nIndex = '36582' update ITEM_EXCHANGE set nExchangeItemNum1 = '340410109' where nIndex = '36583' update ITEM_EXCHANGE set nExchangeItemCount1 = '1000' where nIndex = '36583' update ITEM_EXCHANGE set nExchangeItemNum2 = '340410161' where nIndex = '36583' update ITEM_EXCHANGE set nExchangeItemCount2 = '1000' where nIndex = '36583' update ITEM_EXCHANGE set nExchangeItemNum3 = '320110301' where nIndex = '36583' update ITEM_EXCHANGE set nExchangeItemCount3 = '1000' where nIndex = '36583' update ITEM_EXCHANGE set nExchangeItemNum4 = '320110312' where nIndex = '36583' update ITEM_EXCHANGE set nExchangeItemCount4 = '1000' where nIndex = '36583' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '36583' update ITEM_EXCHANGE set nExchangeItemCount5 = '6000' where nIndex = '36583' ################################################################################## ## Fragment of Avarice ## update ITEM_EXCHANGE set nExchangeItemNum1 = '700002000' where nIndex = '36681' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36681' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '36681' update ITEM_EXCHANGE set nExchangeItemCount2 = '4000' where nIndex = '36681' update ITEM_EXCHANGE set nExchangeItemNum3 = '810081000' where nIndex = '36681' update ITEM_EXCHANGE set nExchangeItemCount3 = '1500' where nIndex = '36681' update ITEM_EXCHANGE set nExchangeItemNum4 = '810080000' where nIndex = '36681' update ITEM_EXCHANGE set nExchangeItemCount4 = '2000' where nIndex = '36681' update ITEM_EXCHANGE set nExchangeItemNum5 = '800008000' where nIndex = '36681' update ITEM_EXCHANGE set nExchangeItemCount5 = '2000' where nIndex = '36681' update ITEM_EXCHANGE set nExchangeItemNum1 = '502573000' where nIndex = '36682' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '36682' update ITEM_EXCHANGE set nExchangeItemNum2 = '320310126' where nIndex = '36682' update ITEM_EXCHANGE set nExchangeItemCount2 = '500' where nIndex = '36682' update ITEM_EXCHANGE set nExchangeItemNum3 = '340610107' where nIndex = '36682' update ITEM_EXCHANGE set nExchangeItemCount3 = '500' where nIndex = '36682' update ITEM_EXCHANGE set nExchangeItemNum4 = '128440835' where nIndex = '36682' update ITEM_EXCHANGE set nExchangeItemCount4 = '4500' where nIndex = '36682' update ITEM_EXCHANGE set nExchangeItemNum5 = '139430775' where nIndex = '36682' update ITEM_EXCHANGE set nExchangeItemCount5 = '4000' where nIndex = '36682' update ITEM_EXCHANGE set nExchangeItemNum1 = '184430875' where nIndex = '36683' update ITEM_EXCHANGE set nExchangeItemCount1 = '1000' where nIndex = '36683' update ITEM_EXCHANGE set nExchangeItemNum2 = '127430755' where nIndex = '36683' update ITEM_EXCHANGE set nExchangeItemCount2 = '1000' where nIndex = '36683' update ITEM_EXCHANGE set nExchangeItemNum3 = '340410109' where nIndex = '36683' update ITEM_EXCHANGE set nExchangeItemCount3 = '2000' where nIndex = '36683' update ITEM_EXCHANGE set nExchangeItemNum4 = '340410161' where nIndex = '36683' update ITEM_EXCHANGE set nExchangeItemCount4 = '2000' where nIndex = '36683' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '36683' update ITEM_EXCHANGE set nExchangeItemCount5 = '4000' where nIndex = '36683' update ITEM_EXCHANGE set nExchangeItemNum1 = '182430815' where nIndex = '36685' update ITEM_EXCHANGE set nExchangeItemCount1 = '2000' where nIndex = '36685' update ITEM_EXCHANGE set nExchangeItemNum2 = '183230845' where nIndex = '36685' update ITEM_EXCHANGE set nExchangeItemCount2 = '1500' where nIndex = '36685' update ITEM_EXCHANGE set nExchangeItemNum3 = '197420345' where nIndex = '36685' update ITEM_EXCHANGE set nExchangeItemCount3 = '1500' where nIndex = '36685' update ITEM_EXCHANGE set nExchangeItemNum4 = '330151451' where nIndex = '36685' update ITEM_EXCHANGE set nExchangeItemCount4 = '1000' where nIndex = '36685' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '36685' update ITEM_EXCHANGE set nExchangeItemCount5 = '4000' where nIndex = '36685' update ITEM_EXCHANGE set nExchangeItemNum1 = '330111441' where nIndex = '36686' update ITEM_EXCHANGE set nExchangeItemCount1 = '2000' where nIndex = '36686' update ITEM_EXCHANGE set nExchangeItemNum2 = '310512141' where nIndex = '36686' update ITEM_EXCHANGE set nExchangeItemCount2 = '2000' where nIndex = '36686' update ITEM_EXCHANGE set nExchangeItemNum3 = '310610251' where nIndex = '36686' update ITEM_EXCHANGE set nExchangeItemCount3 = '2000' where nIndex = '36686' update ITEM_EXCHANGE set nExchangeItemNum4 = '310410241' where nIndex = '36686' update ITEM_EXCHANGE set nExchangeItemCount4 = '2000' where nIndex = '36686' update ITEM_EXCHANGE set nExchangeItemNum5 = '310410282' where nIndex = '36686' update ITEM_EXCHANGE set nExchangeItemCount5 = '2000' where nIndex = '36686' ################################################################################## ## Black GEM ## update ITEM_EXCHANGE set nExchangeItemNum1 = '247004715' where nIndex = '46581' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '46581' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '46581' update ITEM_EXCHANGE set nExchangeItemCount2 = '7500' where nIndex = '46581' update ITEM_EXCHANGE set nExchangeItemNum3 = '247005715' where nIndex = '46581' update ITEM_EXCHANGE set nExchangeItemCount3 = '1000' where nIndex = '46581' update ITEM_EXCHANGE set nExchangeItemNum4 = '247002715' where nIndex = '46581' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '46581' update ITEM_EXCHANGE set nExchangeItemNum5 = '247003715' where nIndex = '46581' update ITEM_EXCHANGE set nExchangeItemCount5 = '500' where nIndex = '46581' update ITEM_EXCHANGE set nExchangeItemNum1 = '247001715' where nIndex = '46582' update ITEM_EXCHANGE set nExchangeItemCount1 = '750' where nIndex = '46582' update ITEM_EXCHANGE set nExchangeItemNum2 = '207003705' where nIndex = '46582' update ITEM_EXCHANGE set nExchangeItemCount2 = '750' where nIndex = '46582' update ITEM_EXCHANGE set nExchangeItemNum3 = '207004705' where nIndex = '46582' update ITEM_EXCHANGE set nExchangeItemCount3 = '750' where nIndex = '46582' update ITEM_EXCHANGE set nExchangeItemNum4 = '207005705' where nIndex = '46582' update ITEM_EXCHANGE set nExchangeItemCount4 = '750' where nIndex = '46582' update ITEM_EXCHANGE set nExchangeItemNum5 = '247003715' where nIndex = '46582' update ITEM_EXCHANGE set nExchangeItemCount5 = '7000' where nIndex = '46582' ################################################################################# ## Green Gem ## update ITEM_EXCHANGE set nExchangeItemNum1 = '207001705' where nIndex = '46481' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '46481' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '46481' update ITEM_EXCHANGE set nExchangeItemCount2 = '7500' where nIndex = '46481' update ITEM_EXCHANGE set nExchangeItemNum3 = '207002705' where nIndex = '46481' update ITEM_EXCHANGE set nExchangeItemCount3 = '1000' where nIndex = '46481' update ITEM_EXCHANGE set nExchangeItemNum4 = '287004735' where nIndex = '46481' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '46481' update ITEM_EXCHANGE set nExchangeItemNum5 = '287005735' where nIndex = '46481' update ITEM_EXCHANGE set nExchangeItemCount5 = '500' where nIndex = '46481' update ITEM_EXCHANGE set nExchangeItemNum1 = '287001735' where nIndex = '46482' update ITEM_EXCHANGE set nExchangeItemCount1 = '750' where nIndex = '46482' update ITEM_EXCHANGE set nExchangeItemNum2 = '287002735' where nIndex = '46482' update ITEM_EXCHANGE set nExchangeItemCount2 = '750' where nIndex = '46482' update ITEM_EXCHANGE set nExchangeItemNum3 = '287003735' where nIndex = '46482' update ITEM_EXCHANGE set nExchangeItemCount3 = '750' where nIndex = '46482' update ITEM_EXCHANGE set nExchangeItemNum4 = '320310126' where nIndex = '46482' update ITEM_EXCHANGE set nExchangeItemCount4 = '750' where nIndex = '46482' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '46482' update ITEM_EXCHANGE set nExchangeItemCount5 = '7000' where nIndex = '46482' ################################################################################### ## Blue Gem ## update ITEM_EXCHANGE set nExchangeItemNum1 = '267002725' where nIndex = '46381' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '46381' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '46381' update ITEM_EXCHANGE set nExchangeItemCount2 = '7500' where nIndex = '46381' update ITEM_EXCHANGE set nExchangeItemNum3 = '267004725' where nIndex = '46381' update ITEM_EXCHANGE set nExchangeItemCount3 = '1000' where nIndex = '46381' update ITEM_EXCHANGE set nExchangeItemNum4 = '267005725' where nIndex = '46381' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '46381' update ITEM_EXCHANGE set nExchangeItemNum5 = '267001725' where nIndex = '46381' update ITEM_EXCHANGE set nExchangeItemCount5 = '500' where nIndex = '46381' update ITEM_EXCHANGE set nExchangeItemNum1 = '267003725' where nIndex = '46382' update ITEM_EXCHANGE set nExchangeItemCount1 = '750' where nIndex = '46382' update ITEM_EXCHANGE set nExchangeItemNum2 = '800008000' where nIndex = '46382' update ITEM_EXCHANGE set nExchangeItemCount2 = '750' where nIndex = '46382' update ITEM_EXCHANGE set nExchangeItemNum3 = '810081000' where nIndex = '46382' update ITEM_EXCHANGE set nExchangeItemCount3 = '750' where nIndex = '46382' update ITEM_EXCHANGE set nExchangeItemNum4 = '810080000' where nIndex = '46382' update ITEM_EXCHANGE set nExchangeItemCount4 = '750' where nIndex = '46382' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '46382' update ITEM_EXCHANGE set nExchangeItemCount5 = '7000' where nIndex = '46382' ################################################################################## ## Yellow Gem ## update ITEM_EXCHANGE set nExchangeItemNum1 = '128440835' where nIndex = '46281' update ITEM_EXCHANGE set nExchangeItemCount1 = '500' where nIndex = '46281' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '46281' update ITEM_EXCHANGE set nExchangeItemCount2 = '7500' where nIndex = '46281' update ITEM_EXCHANGE set nExchangeItemNum3 = '139430775' where nIndex = '46281' update ITEM_EXCHANGE set nExchangeItemCount3 = '1000' where nIndex = '46281' update ITEM_EXCHANGE set nExchangeItemNum4 = '127430755' where nIndex = '46281' update ITEM_EXCHANGE set nExchangeItemCount4 = '500' where nIndex = '46281' update ITEM_EXCHANGE set nExchangeItemNum5 = '197420345' where nIndex = '46281' update ITEM_EXCHANGE set nExchangeItemCount5 = '500' where nIndex = '46281' update ITEM_EXCHANGE set nExchangeItemNum1 = '184430875' where nIndex = '46282' update ITEM_EXCHANGE set nExchangeItemCount1 = '750' where nIndex = '46282' update ITEM_EXCHANGE set nExchangeItemNum2 = '183230845' where nIndex = '46282' update ITEM_EXCHANGE set nExchangeItemCount2 = '750' where nIndex = '46282' update ITEM_EXCHANGE set nExchangeItemNum3 = '182430815' where nIndex = '46282' update ITEM_EXCHANGE set nExchangeItemCount3 = '750' where nIndex = '46282' update ITEM_EXCHANGE set nExchangeItemNum4 = '700002000' where nIndex = '46282' update ITEM_EXCHANGE set nExchangeItemCount4 = '750' where nIndex = '46282' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '46282' update ITEM_EXCHANGE set nExchangeItemCount5 = '7000' where nIndex = '46282' ################################################################################## ## Red Gem ## update ITEM_EXCHANGE set nExchangeItemNum1 = '340410109' where nIndex = '46181' update ITEM_EXCHANGE set nExchangeItemCount1 = '1000' where nIndex = '46181' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '46181' update ITEM_EXCHANGE set nExchangeItemCount2 = '6000' where nIndex = '46181' update ITEM_EXCHANGE set nExchangeItemNum3 = '340410115' where nIndex = '46181' update ITEM_EXCHANGE set nExchangeItemCount3 = '1000' where nIndex = '46181' update ITEM_EXCHANGE set nExchangeItemNum4 = '340410161' where nIndex = '46181' update ITEM_EXCHANGE set nExchangeItemCount4 = '1000' where nIndex = '46181' update ITEM_EXCHANGE set nExchangeItemNum5 = '320110302' where nIndex = '46181' update ITEM_EXCHANGE set nExchangeItemCount5 = '1000' where nIndex = '46181' update ITEM_EXCHANGE set nExchangeItemNum1 = '320110322' where nIndex = '46182' update ITEM_EXCHANGE set nExchangeItemCount1 = '1000' where nIndex = '46182' update ITEM_EXCHANGE set nExchangeItemNum2 = '320110312' where nIndex = '46182' update ITEM_EXCHANGE set nExchangeItemCount2 = '1000' where nIndex = '46182' update ITEM_EXCHANGE set nExchangeItemNum3 = '330151451' where nIndex = '46182' update ITEM_EXCHANGE set nExchangeItemCount3 = '1500' where nIndex = '46182' update ITEM_EXCHANGE set nExchangeItemNum4 = '330111441' where nIndex = '46182' update ITEM_EXCHANGE set nExchangeItemCount4 = '1500' where nIndex = '46182' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '46182' update ITEM_EXCHANGE set nExchangeItemCount5 = '5000' where nIndex = '46182' ################################################################################## ## Silvery Gem ## update ITEM_EXCHANGE set nExchangeItemNum1 = '502573000' where nIndex = '46081' update ITEM_EXCHANGE set nExchangeItemCount1 = '1000' where nIndex = '46081' update ITEM_EXCHANGE set nExchangeItemNum2 = '379021000' where nIndex = '46081' update ITEM_EXCHANGE set nExchangeItemCount2 = '6000' where nIndex = '46081' update ITEM_EXCHANGE set nExchangeItemNum3 = '320310126' where nIndex = '46081' update ITEM_EXCHANGE set nExchangeItemCount3 = '1000' where nIndex = '46081' update ITEM_EXCHANGE set nExchangeItemNum4 = '340610107' where nIndex = '46081' update ITEM_EXCHANGE set nExchangeItemCount4 = '1000' where nIndex = '46081' update ITEM_EXCHANGE set nExchangeItemNum5 = '310512141' where nIndex = '46081' update ITEM_EXCHANGE set nExchangeItemCount5 = '1000' where nIndex = '46081' update ITEM_EXCHANGE set nExchangeItemNum1 = '310511131' where nIndex = '46082' update ITEM_EXCHANGE set nExchangeItemCount1 = '1000' where nIndex = '46082' update ITEM_EXCHANGE set nExchangeItemNum2 = '310610251' where nIndex = '46082' update ITEM_EXCHANGE set nExchangeItemCount2 = '1000' where nIndex = '46082' update ITEM_EXCHANGE set nExchangeItemNum3 = '310410241' where nIndex = '46082' update ITEM_EXCHANGE set nExchangeItemCount3 = '1500' where nIndex = '46082' update ITEM_EXCHANGE set nExchangeItemNum4 = '310410282' where nIndex = '46082' update ITEM_EXCHANGE set nExchangeItemCount4 = '1500' where nIndex = '46082' update ITEM_EXCHANGE set nExchangeItemNum5 = '379021000' where nIndex = '46082' update ITEM_EXCHANGE set nExchangeItemCount5 = '5000' where nIndex = '46082' ##################################################################################Açıklaması;
- 'nExchangeItemNum' yazan kısımlar vereceği itemin kodu. Örneğin; 'Iron Neck' vs. ekleyebilirsiniz. Sadece kodunu yazmanız yeterli.
- 'nExchangeItemCount' yazan kısımlar ise çıkma oranı. 5lik bir slotun toplamı 10.000 olmak zorundadır.
Örneğin;
Count1 = 1000, Count2 = 2000, Count3 = 5000, Count4 = 1000, Count5 = 1000 = TOTAL 10.000
veya;
Count1 = 100, Count2 = 200, Count3 = 500, Count4 = 200, Count5 = 9000 = TOTAL 10.000
Düşük oranlı kısımlara güzel itemler, yüksek oranlı kısımlara BUS, POT gibi ezik itemler koyabilirsiniz. Kafanıza göre ayarlayın.
Tebrikler, Chaotic Generatörden çıkan eşyaları başarıyla düzenlediniz!
NOT: 21.EVT'yi editleyerek ve ITEM_EXCHANGE tablosunu editleyerek daha çok ihtimal yaratılabilir. Tamamen yaratıcılığınıza kalmış. Ben KÖK kodunu paylaşıyım. Kolay gelsin.
V1299 - Fragment & Gem Droplarını Ayarlamak - SQL Kodu | Programsız
Knight Online özel sunucularında geliştirme yaparken, drop sistemlerinin ayarlanması önemli bir konudur. Özellikle Fragment ve Gem gibi nadir ödüllerin düşüş oranlarını kontrol etmek, hem oyuncu deneyimini artırır hem de sunucu dengelerini optimize eder. Bu yazıda, V1299 sürümüne uygun olarak Fragment ve Gem droplarını SQL kodu ile nasıl değiştireceğinizi adım adım anlatacağız. Programlama bilgisi gerektirmeden sadece veritabanı düzenlemesiyle bu işlemi gerçekleştirebilirsiniz.
Knight Online Drop Sistemi Nedir?
Knight Online özel sunucularında, her bir NPC (Mob) belirli eşyaları belirli oranlarda düşürür. Bu sistem, itemdb, mob, drop gibi tablolara dayanır. Drop oranları genellikle MobDropTableInfo adlı tablo üzerinden düzenlenir. Burada Fragment ve Gem gibi özel eşyaların düşüş oranları da tanımlanabilir.
V1299 İçin Fragment ve Gem Drop Ayarlaması
V1299 sürümünde Fragment ve Gem eşyalarının düşmesi için ilgili item ID'lerini doğru şekilde MobDropTableInfo tablosuna eklemek gerekir. Öncelikle, hangi eşyanın hangi ID ile tanımlandığını kontrol etmeniz gerekir. Bu bilgi genellikle Item.txt dosyasında yer alır.
Örnek Item ID Listesi:
- Fragment: 10001
- Gem: 10002
SQL Kodu Örneği:
Aşağıdaki SQL komutu ile tüm NPC'lerin Fragment veya Gem düşürme oranını %1 olarak ayarlayabilirsiniz:
Kod:
[COLOR=green]INSERT INTO MobDropTableInfo ([/COLOR][COLOR=red]m_iMobID[/COLOR][COLOR=green], [/COLOR][COLOR=red]m_iItemID[/COLOR][COLOR=green], [/COLOR][COLOR=red]m_fRate[/COLOR][COLOR=green]) VALUES ([/COLOR][COLOR=red]'0'[/COLOR][COLOR=green], [/COLOR][COLOR=red]'10001'[/COLOR][COLOR=green], [/COLOR][COLOR=red]'0.01'[/COLOR][COLOR=green]);[/COLOR][BR][/BR][COLOR=green]INSERT INTO MobDropTableInfo ([/COLOR][COLOR=red]m_iMobID[/COLOR][COLOR=green], [/COLOR][COLOR=red]m_iItemID[/COLOR][COLOR=green], [/COLOR][COLOR=red]m_fRate[/COLOR][COLOR=green]) VALUES ([/COLOR][COLOR=red]'0'[/COLOR][COLOR=green], [/COLOR][COLOR=red]'10002'[/COLOR][COLOR=green], [/COLOR][COLOR=red]'0.01'[/COLOR][COLOR=green]);[/COLOR]Not: m_iMobID = 0 tüm NPC'leri kapsar. Belirli bir NPC'ye özel drop tanımlamak isterseniz, o NPC'nin ID'sini kullanmalısınız.
Drop Oranlarını Kontrol Etme
Yukarıdaki kodlarla drop tanımladıktan sonra, sunucunuzu yeniden başlatmanız gerekmez. Ancak bazı sunucular drop tablolarını restart sırasında yüklediği için değişikliğin aktif olması için sunucuyu yeniden başlatmanız gerekebilir. Drop oranlarını test etmek için test sunucusunda düşük seviyeli NPC'leri öldürerek sonuçları gözlemleyebilirsiniz.
Knight Lobby Üyelerine Özel İpuçları
Sunucunuzda Fragment ve Gem drop oranlarını ayarlarken, rate değerini çok yüksek tutarsanız, bu eşyaların değeri azalabilir. Bu nedenle, dengeli ve gerçekçi oranlar belirlemek önemlidir. Ayrıca, oyuncuların bu eşyalara olan ilgisini artırmak için özel etkinlikler veya çift drop haftasonları gibi zamanlar planlayabilirsiniz.
Knight Online özel sunucularında geliştirme yaparken, drop sistemlerini doğru yönetmek, hem oyuncu memnuniyetini artırır hem de sunucunuzun rekabet gücünü korumanızı sağlar. Bu rehber sayesinde Fragment ve Gem droplarını kolayca ayarlayabilir, oyuncular için daha keyifli bir deneyim yaratabilirsiniz.
Kaynaklar:
Knight Lobby, Knight Lobby adresinden KO özel sunucu dosyaları, emulator ve geliştirme kaynaklarına ulaşabilirsiniz.
V1299 - Setting Fragment & Gem Drops with SQL Code | No Programming Required
When developing Knight Online private servers, configuring drop systems is a critical task. Especially adjusting the drop rates of rare items like Fragment and Gem helps enhance player experience and balance server mechanics. In this article, we'll guide you step-by-step on how to change Fragment and Gem drop rates using SQL code for the V1299 version. You can perform this process solely through database modifications without needing programming knowledge.
What Is the Knight Online Drop System?
In Knight Online private servers, each NPC (Mob) drops specific items at certain rates. This system relies on tables such as itemdb, mob, and drop. Drop rates are typically managed via the MobDropTableInfo table, where drops for special items like Fragments and Gems can also be defined.
Configuring Fragment and Gem Drops for V1299
To enable Fragments and Gems to drop in the V1299 version, you must add the corresponding item IDs correctly into the MobDropTableInfo table. First, verify which IDs correspond to these items; this information is usually found in the Item.txt file.
Sample Item ID List:
- Fragment: 10001
- Gem: 10002
Example SQL Code:
With the following SQL command, you can set the drop rate for Fragments or Gems from all NPCs to 1%:
Kod:
[COLOR=green]INSERT INTO MobDropTableInfo ([/COLOR][COLOR=red]m_iMobID[/COLOR][COLOR=green], [/COLOR][COLOR=red]m_iItemID[/COLOR][COLOR=green], [/COLOR][COLOR=red]m_fRate[/COLOR][COLOR=green]) VALUES ([/COLOR][COLOR=red]'0'[/COLOR][COLOR=green], [/COLOR][COLOR=red]'10001'[/COLOR][COLOR=green], [/COLOR][COLOR=red]'0.01'[/COLOR][COLOR=green]);[/COLOR][BR][/BR][COLOR=green]INSERT INTO MobDropTableInfo ([/COLOR][COLOR=red]m_iMobID[/COLOR][COLOR=green], [/COLOR][COLOR=red]m_iItemID[/COLOR][COLOR=green], [/COLOR][COLOR=red]m_fRate[/COLOR][COLOR=green]) VALUES ([/COLOR][COLOR=red]'0'[/COLOR][COLOR=green], [/COLOR][COLOR=red]'10002'[/COLOR][COLOR=green], [/COLOR][COLOR=red]'0.01'[/COLOR][COLOR=green]);[/COLOR]Note: m_iMobID = 0 covers all NPCs. If you want to define drops for specific NPCs only, use their individual IDs instead.
Checking Drop Rates
After applying the above codes, you may not need to restart your server. However, some servers load drop tables upon restart, so a server reboot might be required for the changes to take effect. You can test drop rates by killing low-level NPCs in a test environment to observe results.
Tips for Knight Lobby Members
While setting Fragment and Gem drop rates, avoid setting the rate too high, as this will decrease the value of these items. Therefore, setting balanced and realistic rates is crucial. Additionally, you can increase player interest in these items by scheduling special events or double drop weekends.
Properly managing drop systems while developing Knight Online private servers enhances player satisfaction and maintains the competitive edge of your server. With this guide, you can easily configure Fragment and Gem drops to create a more enjoyable experience for players.
Resources:
Knight Lobby offers access to KO private server files, emulators, and development resources at Knight Lobby.
