Konu Yazar
huhuas
Member
- Kas
- 294
- 3
Bu veritabanını yaparken amaç orjinal homeko zevki alınması ,HOMEKO görevler ve skilleriyle vardır. Homeko 83/1 değildir.halen cz arkası bf yaratıkları olan veritabanlarını orjinal sananlar var.@
Bu veritabanı 3sene öncesi yaptığım bir proje idi , o yüzden bazı yeni çıkan şeyler varsa bdw vs gibi ekleyebilirsiniz.para işine gelirsek burada para değerlidir., paranın kolay olduğu sunucuları görüyorsunuzdur bi süre sonra b*ka sarıyor .
monster exp orjinal homekov2 .myko kadar zor değil ve homekov2 kadarda kolay değildir.
death zone veya darkland 2 adet vardır. 71karus 72human 2side npc monster olarak eşit ama kullanılmadı
Tüm görevler sorunsuz .
HomeKOdbv2+Myko=HomeKO (Orta seviye item database)Lvl oranları orjinali gibidir . item ve para biraz daha zordur .
birçok düzeltilen şey var.Kısa kesicem belli başlı yerlerdeki değişiklikleri yazıyorum sadece.
Moradon Lenoa npcden 10,000np karşılığı bahamut,gryphon,valkyrie helmet veya armor certificası alınır
delostaki item merchant npcden gerekli itemleri götürüp istediğiniz armor set alınır.
Tüm npcler sorunsuz çalışır evtler düzgün .
Moradon Shozin 74lvl ve üstü gerekli itemleri verip Krowaz itemi alabilir
Eslant "Mogo" npcden Juraid Mountain ve Krowaz Dominion'a 100m ile gidilir.
Krowazdan +1 itemler
Juraidden gem düşer.
Eslanta extra 1paramun 2brahman slotu eklendi.Toplamda 3er slot var.
Krowaz guard towerlar düzgün yerleştirildi
Bf guard towerlar düzgün yerleştirildi
Yeni skiller için powerful Gem gerekmez
Parfait(lotto npc) göbekli Santa yerine gerçek Sexy Santa
Colony Zone Bf monumenti kıran ırk bf ye girer.
bf monument 30dk da bir çıkar.
Skiller kontrol edildi.2ırk içinde tüm skiller eşit.
İtem Grupları classlara göre eşit düzenlendi
Bozuk Tablo ve prosedürler düzeltildi ve değiştirildi.
Eslant Pot Npcleri eklendi.
Colony Zone pot npcleri eklendi.
Pot ağırlıkları düşürüldü (720Favors 3,0)(1920Soul 1,0)
Monster Summon Staff 1li düzeltildi sorunsuz basılıyor 50lottoya alınabilir
Tüm silahları upgrade oluyor
Bf. Ultima odasına giriş için teleport gateler eklendi.Fragmentler ile partyce girilir
Stone of Apostle dropta görünmemesi düzeltildi.
Priest Kırmızı Siyah çitin görünmemesi düzeltildi.
Tbl ler düzeltildi npc mob item görünümleri.
lotto npc mavi kutu quest iptal
npc item değişimleri sorunsuz exe hatası yada görev itemlerini verip item alamama gibi bi durum yok
Chaotic generator medal,gem ve fragment kırdırma ekli.düzgün item değişim itemin seviyesine göre.
EMC LUFER ESLANT görevlerinden mavi kutular kaldırıldı.
cz tüm görevler 80lvl gerekir.power up +7çitin set verir
emc lufer gelin-damat görevlerinden
(scarlet moss,cuff binder hide,giga hammer fragment,fantastic cube 1er adet alırsınız.
bu itemler ile moradondan istediğiniz 1adet +1 krowaz(satanism) itemi alınır.74+ lvl)
Irklar arası eşitsizlik yok drop,görev,item,skill,zone vs
Droplar genel olarak yaratık seviyelerine göre.
örnek : stone golem çitin set +silahlar %25 giant golem %30gibi
yada eslant chipotera troll shaman doom soldier vs 7000 item grubu silahları(shard +1 raptor +1 vs vs)
booro balrog 8000item grubu silahlar (exceptional shard+1 , exceptional raptor vsvs)
boss dropları %100 değil en son %60
örnek: samma 1h 2h giantic axe(L) %40
bishop duke bach %60 roc rom rol
lesath shaula .%40 shields. %60 tail+bow
UPGRADELER : takılar +5e ve İtemler +10a %100dür kendinize göre değiştirin.
#####################
-----BOSSlar-----
######################
Kekurikekukaka = Kekuri Belt+0(%60) , Kekuri Ring+0(%60)
Lobo = Lobo Staff+0(%40) , Lobo Hammer+0(%30) , Lobo Pendant+0(%60)
Lupus = Lupus Staff+0(%40) , Lupus Hammer+0(%30) , Lupus Pendant+0(%60)
Lycaon = Lycaon Staff+0(%40) , Lycaon Hammer+0(%30) , Lycaon Pendant+0(%60)
Orc Bandit Leader = Holy Water of Temple(%60) , Knight's Medal(%30)
Barrkk = Tooth+0(%60)
Barkirra = Sword of Beast+0(%60) , Fang of Bakirra(%60)
Bone Collector = Skull Hammer+0(%60)
Dragon Tooth = Dragon Tooth Hammer+0(%60)
Hyde = Sword of the Dead+0(%60)
Antares = Scorpion Scythe+1(%60)
Shaula = Scorpion Shield+0(%40) , Chitin Bow+0(%60) , Tail of Shaula(%60)
Lesath = Chitin Shield+0(%40) , Scorpion Bow+0(%60) , Tail of Lesath(%60)
Duke = Ring of Courage+0(%60)
Bishop = Ring of Magic+0(%60)
Bach = Ring of Life+0(%60)
Dulian = Ring of Courage+0(%60)
Jersey = Ring of Magic+0(%60)
Query = Ring of Life+0(%60)
Javana = Giantic Axe(2h)+1(%40) , Giantic Axe(1h)+1(%40) - Glacier
Samma = Giantic Axe(2h)+1(%40) , Giantic Axe(1h)+1(%40) - Lightning
Felankor = Ring of the Felankor+0(%60)
Ultima = 1235(%60) , 1235(%60) , Knight's Medal(%20) , Royal Knight's Medal(%20) , King's Medal(%20)
İsiloon = 785(%60) , 1236(%60) , Royal Knight's Medal(%20) , King's Medal(%20) , Dragon Marble(%100)
##################################
Deruvish Founder = 2105(%60)
----------------------------
Agate Ring+0
Diamond Ring+0
Emerald Ring+0
Opal Ring+0
Ruby Ring+0
Crystal Ring+0
Elf Ring+0
Gold Ring+0
Platinum Ring+0
Silver Ring+0
##################################
Talos = 2405(%60)
-----------------------
İron Belt+0
Skeleton Belt+0
Belt of Life+0
Crystal Belt+0
Glass Belt+0
Mana Belt+0
Belt of Dexterity+0
Belt of Strength+0
Elf Belt+0
İce Belt+0
Belt of İntelligence+0
Bronze Belt+0
Fire Belt+0
Lightning Belt+0
#################################
Troll King = 1725(%60)
-----------------------
Platinum Earring+0
Elt-Metal Earring+0
Agate Earring+0
White-Silver Earring+0
Secret-Silver Earring+0
################################
Harpy Queen = 2205(%60)
-----------------------
Warrior Earring+0
Rogue Earring+0
Mage Earring+0
Cleric Earring+0
################################
Attila = 1400(%60)
-------------------
Warrior Pendant+1
Elemental Pendant+1
Priest Pendant+1
################################
Snake Queen = 2005(%60)
-----------------------
İron Necklace+0
White Dragon Necklace+0
Amulet of Strength+0
Red Dragon Amulet+0
Amulet of Dexterity+0
Green Dragon Amulet+0
Amulet of Magic Power+0
Crystal Necklace+0
Amulet of Healt+0
Elemental Necklace+0
Black Dragon Necklace+0
Amulet of Curse+0
Amulet of Goddes+0
Blue Dragon Necklace+0
################################
###################
----MORADON----
#######################
Worm = Speed scroll (%100)
Orc Watcher = 2grup (Mage,Priest paper set+5) %100
Blood worm = 2grup (Silver,Gold Coin) %100
Snatcher = 150AC , 1000HP , Attack Scroll
####################
----EMC-LUFER----
####################
DTS = 2000(%25)
Lamia = 2000(%25)
Lamiros = 2000(%30)
Lamentation = 2000(%40) - Totamic Club+1(%20)
Troll = Glave+1(%20)
Troll Warrior = Glave+1(%25)
Apostle = Salamander Staff+1(%20)
Harpy = Mirage Dagger+1(%20)
Raven Harpy = Mirage Dagger+1(%25)
Stone Golem = 2400(%25)
Giant Golem = 2400(%30)
Tyon = Blessed Upgrade Scroll (%30)
###################
----ESLANT----
#################
Crimson Wing = Shell Bot(%20)
Troll Berserker = Shell Bot(%25)
Troll Captain = Shell Helmet(%20)
Falcon = Shell Eldiven(%25)
Dark Stone = Shell Pad(%20)
DARK MARE = Shell Pauldron(%30) , 8000(%30)
DREAD MARE = Shell Pauldron(%50) , 8000(%50) , Gold bar(%10)
Troll Shaman = 7000(%20)
Apostle of Flames = 7000(%20)
Apostle of Piercing Cold = 7000(%20)
Chipotera = 7000(%20)
Evil Wizard = 7000(%25)
Doom Soldier = 7000(%25)
Dark Knight = 7000(%25)
Booro = 8000(%20) , 8000(%20)
Balrog = 8000(%30) , 8000(%30) , Knight's Medal(%10)
Titan = 2400(%40) , 2400(%40) , Brain of Centaur(%60)
#######################
----Krowaz Dominion----
########################
Red Dragon Hatchling = 1236(%10) , 786(%10)
Query = 1236(%15) , 786(%15)
Minotaur = 1236(%20) , 786(%20)
Bone Dragon = 1236(%20) , 786(%20)
Doom Guard = 1236(%30) , 786(%30)
Giga Hammer = 1236(%50) , 786(%50) , Giga Hammer Fragment (%100)
Cuff Binder = 1236(%50) , 786(%50) , Cuff Binder Hide (%100)
Knight of Betrayal = 1236(%50) , 786(%50) , Scarlet Moss (%100)
Krowaz = 1236(%70) , 1236(%70) , Krowaz Fantastic Cube (%100)
#########################
----Juraid Mountain----
#########################
Red Dragon Hatchling = 9999(%15)
Minotaur = 9999(%20)
Bone Dragon = 9999(%20)
Cockatrice = 9999(%20)
Leech King = 9999(%25)
Lillime = 9999(%25)
Deva Bird = 9999(%40) , 9999(%40)
#############################################
#############İTEM GRUPLARI #####################
############################################
7000= raptor shard elixir staff iron impact gibi silahlar vardır.exc değil
#####################
2000İtem Grubu
----------------
Destroyer+1
Philum+1
Wrist Cutter+1
Bone Cleaver+1
Bardish+1
Cleaver+1
İron Crossbow+1
Viper Staff+1
Priest Cracker+1
Large Hacker+1
Warrior fp set+1
Rogue fp ste+1
Mage fp set+1
Priest fp set+1
###########################
2400İtem Grubu
---------------------
Durandal+1
Harpoon+1
Tomahawk+1
Blade Axe+1
Glave+1
Mirage Dagger+1
İron Bow+1
Salamander Staff+1
Priest Bone Crasher+1
Totamic Club+1
Warrior chitin set+1
Rogue chitin set+1
Mage chitin set+1
Priest chitin set+1
################################
8000İtem Grubu
---------------------------
Exceptional Raptor+1
Exceptional İmpact+1
Exceptional Totamic Spear+1
Exceptional Deep Scar+1
Exceptional Graham+1
Exceptional Blade Axe+1
Exceptional Shard+1
Exceptional İron Bow+1
Exceptional Elixir Staff+1
Exceptional Priest İmpact+1
Exceptional İron İmpact+1
Exceptional Mirage+1
Raptor+1
İmpact+1
Totamic Spear+1
Deep Scar+1
Graham+1
Blade Axe+1
Shard+1
İron Bow+1
Elixir Staff+1
Priest İmpact+1
İron İmpact+1
İron Crossbow+1
Salamander Staff+1
Totamic Club+1
Glave+1
Mirage Dagger+1
##############################################
1236İtem Grubu
------------------------------------------
Exceptional Raptor+1
Exceptional Shard+1
Exceptional İron Bow+1
Exceptional Elixir Staff+1
Exceptional Priest İmpact+1
Exceptional İron İmpact+1
Hanguk Sword+1
Dark Vane+1
Enion Bow+1
Wreath of Erenion+1
Glacier Erenion+1
Lightning Erenion+1
Smite Hammer+1
Defender of the Lord+1
Hell Breaker+1
Fang of Bakirra
Tail of Lesath
Tail of Shaula
Blue Treasure Chest
Green Treasure Chest
Warrior,Rogue,Mage,Priest Shell helmet+1
Warrior,Rogue,Mage,Priest Shell Pauldron+1
Silver bar
Gold Coin
###############################################
786İtem Grubu
-------------------
Mirage+1
Totamic Spear+1
İmpact+1
Graham+1
Raptor+1
Shard+1
İron Bow+1
Elixir Staff+1
Priest İmpact+1
İron İmpact+1
Warrior Shell set+1
Rogue Shell set+1
Mage Shell set+1
Priest Shell set+1
##########################
9999İtem Grubu
--------------
Black Gem
Green Gem
Blue Gem
Yellow Gem
Red Gem
Silvery Gem
###########################
1235İtem Grubu
-----------------------
Avedon+6
Spear of Murky Waters+6
Lugias+6
Sherion+6
Cold-Hearted Dagger+6
Helenid Crossbow+6
Eagles Eye+6
Dread Shield+6
Syphioric+6
Oasis Staff+6
Chaotic Staff+6
Scorching Staff+6
Hell Blood+6
Elysium+6
Garp+
Stone Splitter+6
Holy Animor+6
Defender of the Lord+6
Hanguk Sword+6
Enion Bow+6
Dark Vane+6
Smite Hammer+6
Hell Breaker+6
Gold bar
Silver bar
Royal Knight's Medal
King's Medal
##############################
785İtem Grubu
İron Necklace+1
İron Belt+1
Glass Belt+1
Bronze Belt+1
Skeleton Belt+1
Warrior Pendant+2
Elemental Pendant+2
Priest Pendant+2
Warrior Earring+1
Rogue Earring+1
Mage Earring+1
Cleric Earring+1
Ring of Courage+1
Ring of Magic+1
Ring of Life+1
Platinu Earring+1
Elf-Metal Earring+1
Agete Earring+1
White-Silver Earring+1
Secret-Silver Earring+1
Silver bar
################################
##########################
########MEDALS############
#########################
Knight's Medal
İron Necklace+0
İron Belt+0
Tail of Lesath
Tail of Shaula
Fang of Bakirra
Warrior Earring+0
Rogue Earring+0
Mage Earring+0
Cleric Earring+0
Silver bar
Trina's Piece
Hp Scroll 1500
Scroll of Armor 300
Green Treasure Chest
##################################
Royal Knight's Medal
İron Necklace+1
İron Belt+1
Scorpion Shield+0
Chitin Shield+0
Gold bar
Ring of Courage+0
Ring of Magic+0
Ring of Life+0
Hp Scroll 1500
Scroll of Armor 300
Blue Treasure Chest
Redistribution İtem
###################################
King's Medal
İron Necklace+2
İron Belt+
Ring of Courage+2
Ring of Magic+2
Ring of Life+2
Platinum Earring+2
Elf-Metal Earring+2
Agate Earring+2
White-Silver Earring+2
Secret-Silver Earring+2
Scorpion Shield+0
Chitin Shield+0
Tail of Lesath
Tail of Shaula
Fang of Bakirra
#############################
[/QUOTE]
DOWNLOAD
[HIDE]Tıkla(Click Click Click)
[/HIDE]
BİRAZCIKTA KOD
Kod:
DB deki prosedürlerden buldum...denenmediler
Karakter adı değiştirme?
Kullanım : EXEC ACCOUNT_CHAR_NAME_CHANGE 'ESKICHARADI,'YENICHARADI'
Hesap ID değiştirme?
Kullanım : EXEC ACCOUNT_NAME_CHANGE 'EskiHesapAdi' , 'YeniHesapAdı'
Irk değiştirme?
Kullanım : EXEC ACCOUNT_NATION_TRANSFER 'HESAP_ID'
Şifre değiştirme?
Kullanım : EXEC ACCOUNT_PASSWORD_CHANGE ' Oyundaki Nick ' , ' Yeni Sifre '
Karakterin ID ve Pass bulma?
Kullanım : Exec BUL 'Oyundaki Nick'
Clan Lideri değiştirme?
Kullanım : EXEC CHANGE_KNIGHTS_LEADER 'ESKICLANLIDERI','YENICLANLIDERI'
İtemli Charın itemlerini itemsiz chara aktarma ve itemliden itemleri silmek?
KULLANIM : EXEC CHARACTER_ITEM_TRANSFER 'ITEMLI_CHAR' , 'ITEMSIZ_CHAR'
Clan adı değiştirme?
Kullanımı : EXEC CLAN_NAME_CHANGE 'YENİ' , 'ESKİ'
Karakteri silmek?
KULLANIM : EXEC DELETE CHARACTER 'HESAP ADI' , 'CHARACTER ADI'
Aylık Np sıfırlamak?
Kullanım : EXEC RESET_LOYALTY_MONTHLY
Kod:
Sorunsuz
?????RESET KODU?????
EXEC USER_KNIGHTS_RATING_UPDATE
EXEC UPDATE_PERSONAL_RANK
EXEC Rank_Knights
Kod:
Sorunsuz
Database Temizlemek?
truncate table ACCOUNT_CHAR
truncate table ACCOUNT_NATION_CHECK
truncate table ACCOUNT_NATION_TRANSFERS_QUEUE
truncate table BLOCKED_USERDATA
truncate table BLOCKED_WAREHOUSE
truncate table CURRENTUSER
truncate table FRIEND_LIST
truncate table Gokhan
truncate table HACKTOOL_USERLOG
truncate table HERO_USER
truncate table ITEMLER
truncate table K_NPC_ITEM
truncate table KING_BALLOT_BOX
truncate table KING_CANDIDACY_NOTICE_BOARD
truncate table KING_ELECTION_LIST
truncate table KNIGHTS
truncate table KNIGHTS_ALLIANCE
truncate table KNIGHTS_RATING
truncate table KNIGHTS_USER
truncate table NATIONAL_POINT_DONATE_LIST
truncate table NATIONAL_POINT_TRANSFER_LIST
truncate table PREMIUM_SERVICE
truncate table RENTAL_ITEM
truncate table RENTAL_ITEM_LIST
truncate table TB_USER
truncate table TERM_ITEM
truncate table USER_CLAN_RANK
truncate table USER_MANNERPOINT_RANK
truncate table USER_RENTAL_ITEM
truncate table USER_SAVED_MAGIC
truncate table USERDATA
truncate table USERDATA_SKILLSHORTCUT
truncate table WAREHOUSE
truncate table WEB_ITEMMALL
truncate table WEB_ITEMMALL_LOG
Ardreama giriş için npc sanırım kaldırmıştım isteyenler npcleri tekrardan ekleyip düzgün kontrol yapan bu evtleri kullanabilir
npc ile giriş yaptırtacaklar içindir. tabiki lvl alınca atmıyor ama lvl alan biri çıkınca asla geri giremez tamamen sorunsuzdur
1.evt (orc)
2.evt (human)
Bu veritabanı 3sene öncesi yaptığım bir proje idi , o yüzden bazı yeni çıkan şeyler varsa bdw vs gibi ekleyebilirsiniz.para işine gelirsek burada para değerlidir., paranın kolay olduğu sunucuları görüyorsunuzdur bi süre sonra b*ka sarıyor .
monster exp orjinal homekov2 .myko kadar zor değil ve homekov2 kadarda kolay değildir.
death zone veya darkland 2 adet vardır. 71karus 72human 2side npc monster olarak eşit ama kullanılmadı
Tüm görevler sorunsuz .
HomeKOdbv2+Myko=HomeKO (Orta seviye item database)Lvl oranları orjinali gibidir . item ve para biraz daha zordur .
birçok düzeltilen şey var.Kısa kesicem belli başlı yerlerdeki değişiklikleri yazıyorum sadece.
Moradon Lenoa npcden 10,000np karşılığı bahamut,gryphon,valkyrie helmet veya armor certificası alınır
delostaki item merchant npcden gerekli itemleri götürüp istediğiniz armor set alınır.
Tüm npcler sorunsuz çalışır evtler düzgün .
Moradon Shozin 74lvl ve üstü gerekli itemleri verip Krowaz itemi alabilir
Eslant "Mogo" npcden Juraid Mountain ve Krowaz Dominion'a 100m ile gidilir.
Krowazdan +1 itemler
Juraidden gem düşer.
Eslanta extra 1paramun 2brahman slotu eklendi.Toplamda 3er slot var.
Krowaz guard towerlar düzgün yerleştirildi
Bf guard towerlar düzgün yerleştirildi
Yeni skiller için powerful Gem gerekmez
Parfait(lotto npc) göbekli Santa yerine gerçek Sexy Santa
Colony Zone Bf monumenti kıran ırk bf ye girer.
bf monument 30dk da bir çıkar.
Skiller kontrol edildi.2ırk içinde tüm skiller eşit.
İtem Grupları classlara göre eşit düzenlendi
Bozuk Tablo ve prosedürler düzeltildi ve değiştirildi.
Eslant Pot Npcleri eklendi.
Colony Zone pot npcleri eklendi.
Pot ağırlıkları düşürüldü (720Favors 3,0)(1920Soul 1,0)
Monster Summon Staff 1li düzeltildi sorunsuz basılıyor 50lottoya alınabilir
Tüm silahları upgrade oluyor
Bf. Ultima odasına giriş için teleport gateler eklendi.Fragmentler ile partyce girilir
Stone of Apostle dropta görünmemesi düzeltildi.
Priest Kırmızı Siyah çitin görünmemesi düzeltildi.
Tbl ler düzeltildi npc mob item görünümleri.
lotto npc mavi kutu quest iptal
npc item değişimleri sorunsuz exe hatası yada görev itemlerini verip item alamama gibi bi durum yok
Chaotic generator medal,gem ve fragment kırdırma ekli.düzgün item değişim itemin seviyesine göre.
EMC LUFER ESLANT görevlerinden mavi kutular kaldırıldı.
cz tüm görevler 80lvl gerekir.power up +7çitin set verir
emc lufer gelin-damat görevlerinden
(scarlet moss,cuff binder hide,giga hammer fragment,fantastic cube 1er adet alırsınız.
bu itemler ile moradondan istediğiniz 1adet +1 krowaz(satanism) itemi alınır.74+ lvl)
Irklar arası eşitsizlik yok drop,görev,item,skill,zone vs
Droplar genel olarak yaratık seviyelerine göre.
örnek : stone golem çitin set +silahlar %25 giant golem %30gibi
yada eslant chipotera troll shaman doom soldier vs 7000 item grubu silahları(shard +1 raptor +1 vs vs)
booro balrog 8000item grubu silahlar (exceptional shard+1 , exceptional raptor vsvs)
boss dropları %100 değil en son %60
örnek: samma 1h 2h giantic axe(L) %40
bishop duke bach %60 roc rom rol
lesath shaula .%40 shields. %60 tail+bow
UPGRADELER : takılar +5e ve İtemler +10a %100dür kendinize göre değiştirin.
#####################
-----BOSSlar-----
######################
Kekurikekukaka = Kekuri Belt+0(%60) , Kekuri Ring+0(%60)
Lobo = Lobo Staff+0(%40) , Lobo Hammer+0(%30) , Lobo Pendant+0(%60)
Lupus = Lupus Staff+0(%40) , Lupus Hammer+0(%30) , Lupus Pendant+0(%60)
Lycaon = Lycaon Staff+0(%40) , Lycaon Hammer+0(%30) , Lycaon Pendant+0(%60)
Orc Bandit Leader = Holy Water of Temple(%60) , Knight's Medal(%30)
Barrkk = Tooth+0(%60)
Barkirra = Sword of Beast+0(%60) , Fang of Bakirra(%60)
Bone Collector = Skull Hammer+0(%60)
Dragon Tooth = Dragon Tooth Hammer+0(%60)
Hyde = Sword of the Dead+0(%60)
Antares = Scorpion Scythe+1(%60)
Shaula = Scorpion Shield+0(%40) , Chitin Bow+0(%60) , Tail of Shaula(%60)
Lesath = Chitin Shield+0(%40) , Scorpion Bow+0(%60) , Tail of Lesath(%60)
Duke = Ring of Courage+0(%60)
Bishop = Ring of Magic+0(%60)
Bach = Ring of Life+0(%60)
Dulian = Ring of Courage+0(%60)
Jersey = Ring of Magic+0(%60)
Query = Ring of Life+0(%60)
Javana = Giantic Axe(2h)+1(%40) , Giantic Axe(1h)+1(%40) - Glacier
Samma = Giantic Axe(2h)+1(%40) , Giantic Axe(1h)+1(%40) - Lightning
Felankor = Ring of the Felankor+0(%60)
Ultima = 1235(%60) , 1235(%60) , Knight's Medal(%20) , Royal Knight's Medal(%20) , King's Medal(%20)
İsiloon = 785(%60) , 1236(%60) , Royal Knight's Medal(%20) , King's Medal(%20) , Dragon Marble(%100)
##################################
Deruvish Founder = 2105(%60)
----------------------------
Agate Ring+0
Diamond Ring+0
Emerald Ring+0
Opal Ring+0
Ruby Ring+0
Crystal Ring+0
Elf Ring+0
Gold Ring+0
Platinum Ring+0
Silver Ring+0
##################################
Talos = 2405(%60)
-----------------------
İron Belt+0
Skeleton Belt+0
Belt of Life+0
Crystal Belt+0
Glass Belt+0
Mana Belt+0
Belt of Dexterity+0
Belt of Strength+0
Elf Belt+0
İce Belt+0
Belt of İntelligence+0
Bronze Belt+0
Fire Belt+0
Lightning Belt+0
#################################
Troll King = 1725(%60)
-----------------------
Platinum Earring+0
Elt-Metal Earring+0
Agate Earring+0
White-Silver Earring+0
Secret-Silver Earring+0
################################
Harpy Queen = 2205(%60)
-----------------------
Warrior Earring+0
Rogue Earring+0
Mage Earring+0
Cleric Earring+0
################################
Attila = 1400(%60)
-------------------
Warrior Pendant+1
Elemental Pendant+1
Priest Pendant+1
################################
Snake Queen = 2005(%60)
-----------------------
İron Necklace+0
White Dragon Necklace+0
Amulet of Strength+0
Red Dragon Amulet+0
Amulet of Dexterity+0
Green Dragon Amulet+0
Amulet of Magic Power+0
Crystal Necklace+0
Amulet of Healt+0
Elemental Necklace+0
Black Dragon Necklace+0
Amulet of Curse+0
Amulet of Goddes+0
Blue Dragon Necklace+0
################################
###################
----MORADON----
#######################
Worm = Speed scroll (%100)
Orc Watcher = 2grup (Mage,Priest paper set+5) %100
Blood worm = 2grup (Silver,Gold Coin) %100
Snatcher = 150AC , 1000HP , Attack Scroll
####################
----EMC-LUFER----
####################
DTS = 2000(%25)
Lamia = 2000(%25)
Lamiros = 2000(%30)
Lamentation = 2000(%40) - Totamic Club+1(%20)
Troll = Glave+1(%20)
Troll Warrior = Glave+1(%25)
Apostle = Salamander Staff+1(%20)
Harpy = Mirage Dagger+1(%20)
Raven Harpy = Mirage Dagger+1(%25)
Stone Golem = 2400(%25)
Giant Golem = 2400(%30)
Tyon = Blessed Upgrade Scroll (%30)
###################
----ESLANT----
#################
Crimson Wing = Shell Bot(%20)
Troll Berserker = Shell Bot(%25)
Troll Captain = Shell Helmet(%20)
Falcon = Shell Eldiven(%25)
Dark Stone = Shell Pad(%20)
DARK MARE = Shell Pauldron(%30) , 8000(%30)
DREAD MARE = Shell Pauldron(%50) , 8000(%50) , Gold bar(%10)
Troll Shaman = 7000(%20)
Apostle of Flames = 7000(%20)
Apostle of Piercing Cold = 7000(%20)
Chipotera = 7000(%20)
Evil Wizard = 7000(%25)
Doom Soldier = 7000(%25)
Dark Knight = 7000(%25)
Booro = 8000(%20) , 8000(%20)
Balrog = 8000(%30) , 8000(%30) , Knight's Medal(%10)
Titan = 2400(%40) , 2400(%40) , Brain of Centaur(%60)
#######################
----Krowaz Dominion----
########################
Red Dragon Hatchling = 1236(%10) , 786(%10)
Query = 1236(%15) , 786(%15)
Minotaur = 1236(%20) , 786(%20)
Bone Dragon = 1236(%20) , 786(%20)
Doom Guard = 1236(%30) , 786(%30)
Giga Hammer = 1236(%50) , 786(%50) , Giga Hammer Fragment (%100)
Cuff Binder = 1236(%50) , 786(%50) , Cuff Binder Hide (%100)
Knight of Betrayal = 1236(%50) , 786(%50) , Scarlet Moss (%100)
Krowaz = 1236(%70) , 1236(%70) , Krowaz Fantastic Cube (%100)
#########################
----Juraid Mountain----
#########################
Red Dragon Hatchling = 9999(%15)
Minotaur = 9999(%20)
Bone Dragon = 9999(%20)
Cockatrice = 9999(%20)
Leech King = 9999(%25)
Lillime = 9999(%25)
Deva Bird = 9999(%40) , 9999(%40)
#############################################
#############İTEM GRUPLARI #####################
############################################
7000= raptor shard elixir staff iron impact gibi silahlar vardır.exc değil
#####################
2000İtem Grubu
----------------
Destroyer+1
Philum+1
Wrist Cutter+1
Bone Cleaver+1
Bardish+1
Cleaver+1
İron Crossbow+1
Viper Staff+1
Priest Cracker+1
Large Hacker+1
Warrior fp set+1
Rogue fp ste+1
Mage fp set+1
Priest fp set+1
###########################
2400İtem Grubu
---------------------
Durandal+1
Harpoon+1
Tomahawk+1
Blade Axe+1
Glave+1
Mirage Dagger+1
İron Bow+1
Salamander Staff+1
Priest Bone Crasher+1
Totamic Club+1
Warrior chitin set+1
Rogue chitin set+1
Mage chitin set+1
Priest chitin set+1
################################
8000İtem Grubu
---------------------------
Exceptional Raptor+1
Exceptional İmpact+1
Exceptional Totamic Spear+1
Exceptional Deep Scar+1
Exceptional Graham+1
Exceptional Blade Axe+1
Exceptional Shard+1
Exceptional İron Bow+1
Exceptional Elixir Staff+1
Exceptional Priest İmpact+1
Exceptional İron İmpact+1
Exceptional Mirage+1
Raptor+1
İmpact+1
Totamic Spear+1
Deep Scar+1
Graham+1
Blade Axe+1
Shard+1
İron Bow+1
Elixir Staff+1
Priest İmpact+1
İron İmpact+1
İron Crossbow+1
Salamander Staff+1
Totamic Club+1
Glave+1
Mirage Dagger+1
##############################################
1236İtem Grubu
------------------------------------------
Exceptional Raptor+1
Exceptional Shard+1
Exceptional İron Bow+1
Exceptional Elixir Staff+1
Exceptional Priest İmpact+1
Exceptional İron İmpact+1
Hanguk Sword+1
Dark Vane+1
Enion Bow+1
Wreath of Erenion+1
Glacier Erenion+1
Lightning Erenion+1
Smite Hammer+1
Defender of the Lord+1
Hell Breaker+1
Fang of Bakirra
Tail of Lesath
Tail of Shaula
Blue Treasure Chest
Green Treasure Chest
Warrior,Rogue,Mage,Priest Shell helmet+1
Warrior,Rogue,Mage,Priest Shell Pauldron+1
Silver bar
Gold Coin
###############################################
786İtem Grubu
-------------------
Mirage+1
Totamic Spear+1
İmpact+1
Graham+1
Raptor+1
Shard+1
İron Bow+1
Elixir Staff+1
Priest İmpact+1
İron İmpact+1
Warrior Shell set+1
Rogue Shell set+1
Mage Shell set+1
Priest Shell set+1
##########################
9999İtem Grubu
--------------
Black Gem
Green Gem
Blue Gem
Yellow Gem
Red Gem
Silvery Gem
###########################
1235İtem Grubu
-----------------------
Avedon+6
Spear of Murky Waters+6
Lugias+6
Sherion+6
Cold-Hearted Dagger+6
Helenid Crossbow+6
Eagles Eye+6
Dread Shield+6
Syphioric+6
Oasis Staff+6
Chaotic Staff+6
Scorching Staff+6
Hell Blood+6
Elysium+6
Garp+
Stone Splitter+6
Holy Animor+6
Defender of the Lord+6
Hanguk Sword+6
Enion Bow+6
Dark Vane+6
Smite Hammer+6
Hell Breaker+6
Gold bar
Silver bar
Royal Knight's Medal
King's Medal
##############################
785İtem Grubu
İron Necklace+1
İron Belt+1
Glass Belt+1
Bronze Belt+1
Skeleton Belt+1
Warrior Pendant+2
Elemental Pendant+2
Priest Pendant+2
Warrior Earring+1
Rogue Earring+1
Mage Earring+1
Cleric Earring+1
Ring of Courage+1
Ring of Magic+1
Ring of Life+1
Platinu Earring+1
Elf-Metal Earring+1
Agete Earring+1
White-Silver Earring+1
Secret-Silver Earring+1
Silver bar
################################
##########################
########MEDALS############
#########################
Knight's Medal
İron Necklace+0
İron Belt+0
Tail of Lesath
Tail of Shaula
Fang of Bakirra
Warrior Earring+0
Rogue Earring+0
Mage Earring+0
Cleric Earring+0
Silver bar
Trina's Piece
Hp Scroll 1500
Scroll of Armor 300
Green Treasure Chest
##################################
Royal Knight's Medal
İron Necklace+1
İron Belt+1
Scorpion Shield+0
Chitin Shield+0
Gold bar
Ring of Courage+0
Ring of Magic+0
Ring of Life+0
Hp Scroll 1500
Scroll of Armor 300
Blue Treasure Chest
Redistribution İtem
###################################
King's Medal
İron Necklace+2
İron Belt+
Ring of Courage+2
Ring of Magic+2
Ring of Life+2
Platinum Earring+2
Elf-Metal Earring+2
Agate Earring+2
White-Silver Earring+2
Secret-Silver Earring+2
Scorpion Shield+0
Chitin Shield+0
Tail of Lesath
Tail of Shaula
Fang of Bakirra
#############################
[/QUOTE]
+++++ RESİMLER +++++
DOWNLOAD
[HIDE]Tıkla(Click Click Click)
[/HIDE]
BİRAZCIKTA KOD
Kod:
DB deki prosedürlerden buldum...denenmediler
Karakter adı değiştirme?
Kullanım : EXEC ACCOUNT_CHAR_NAME_CHANGE 'ESKICHARADI,'YENICHARADI'
Hesap ID değiştirme?
Kullanım : EXEC ACCOUNT_NAME_CHANGE 'EskiHesapAdi' , 'YeniHesapAdı'
Irk değiştirme?
Kullanım : EXEC ACCOUNT_NATION_TRANSFER 'HESAP_ID'
Şifre değiştirme?
Kullanım : EXEC ACCOUNT_PASSWORD_CHANGE ' Oyundaki Nick ' , ' Yeni Sifre '
Karakterin ID ve Pass bulma?
Kullanım : Exec BUL 'Oyundaki Nick'
Clan Lideri değiştirme?
Kullanım : EXEC CHANGE_KNIGHTS_LEADER 'ESKICLANLIDERI','YENICLANLIDERI'
İtemli Charın itemlerini itemsiz chara aktarma ve itemliden itemleri silmek?
KULLANIM : EXEC CHARACTER_ITEM_TRANSFER 'ITEMLI_CHAR' , 'ITEMSIZ_CHAR'
Clan adı değiştirme?
Kullanımı : EXEC CLAN_NAME_CHANGE 'YENİ' , 'ESKİ'
Karakteri silmek?
KULLANIM : EXEC DELETE CHARACTER 'HESAP ADI' , 'CHARACTER ADI'
Aylık Np sıfırlamak?
Kullanım : EXEC RESET_LOYALTY_MONTHLY
Kod:
Sorunsuz
?????RESET KODU?????
EXEC USER_KNIGHTS_RATING_UPDATE
EXEC UPDATE_PERSONAL_RANK
EXEC Rank_Knights
Kod:
Sorunsuz
Database Temizlemek?
truncate table ACCOUNT_CHAR
truncate table ACCOUNT_NATION_CHECK
truncate table ACCOUNT_NATION_TRANSFERS_QUEUE
truncate table BLOCKED_USERDATA
truncate table BLOCKED_WAREHOUSE
truncate table CURRENTUSER
truncate table FRIEND_LIST
truncate table Gokhan
truncate table HACKTOOL_USERLOG
truncate table HERO_USER
truncate table ITEMLER
truncate table K_NPC_ITEM
truncate table KING_BALLOT_BOX
truncate table KING_CANDIDACY_NOTICE_BOARD
truncate table KING_ELECTION_LIST
truncate table KNIGHTS
truncate table KNIGHTS_ALLIANCE
truncate table KNIGHTS_RATING
truncate table KNIGHTS_USER
truncate table NATIONAL_POINT_DONATE_LIST
truncate table NATIONAL_POINT_TRANSFER_LIST
truncate table PREMIUM_SERVICE
truncate table RENTAL_ITEM
truncate table RENTAL_ITEM_LIST
truncate table TB_USER
truncate table TERM_ITEM
truncate table USER_CLAN_RANK
truncate table USER_MANNERPOINT_RANK
truncate table USER_RENTAL_ITEM
truncate table USER_SAVED_MAGIC
truncate table USERDATA
truncate table USERDATA_SKILLSHORTCUT
truncate table WAREHOUSE
truncate table WEB_ITEMMALL
truncate table WEB_ITEMMALL_LOG
Ardreama giriş için npc sanırım kaldırmıştım isteyenler npcleri tekrardan ekleyip düzgün kontrol yapan bu evtleri kullanabilir
npc ile giriş yaptırtacaklar içindir. tabiki lvl alınca atmıyor ama lvl alan biri çıkınca asla geri giremez tamamen sorunsuzdur
1.evt (orc)
Kod:
#########################################
EVENT 40201; ARDREAM
E RUN_EVENT 78911
E RUN_EVENT 78912
E RUN_EVENT 78913
E RUN_EVENT 78914
E RUN_EVENT 78915
E RUN_EVENT 78916
E RUN_EVENT 78917
END
EVENT 78911
A CHECK_LV 1 29
E SAY -1 -1 80001 -1 -1 -1 -1 -1 -1 -1 -1 -1; Level yetmezse hata ver ( quest_talk_us.tbl )
E RETURN
END
EVENT 78912
A CHECK_LV 60 250
E SAY -1 -1 80001 -1 -1 -1 -1 -1 -1 -1 -1 -1; Level yetmezse hata ver ( quest_talk_us.tbl )
E RETURN
END
EVENT 78913
A CHECK_SKILL_TOTAL 1 41
E SAY -1 -1 80006 -1 -1 -1 -1 -1 -1 -1 -1 -1; Level yetmezse hata ver ( quest_talk_us.tbl )
E RETURN
END
EVENT 78914
A CHECK_SKILL_TOTAL 101 250
E SAY -1 -1 80006 -1 -1 -1 -1 -1 -1 -1 -1 -1; Level yetmezse hata ver ( quest_talk_us.tbl )
E RETURN
END
EVENT 78915
A CHECK_STAT_TOTAL 1 386
E SAY -1 -1 80007 -1 -1 -1 -1 -1 -1 -1 -1 -1; Level yetmezse hata ver ( quest_talk_us.tbl )
E RETURN
END
EVENT 78916
A CHECK_STAT_TOTAL 475 500
E SAY -1 -1 80007 -1 -1 -1 -1 -1 -1 -1 -1 -1; Level yetmezse hata ver ( quest_talk_us.tbl )
E RETURN
END
EVENT 78917
E SELECT_MSG 16084 77815 44434 22011 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1;³ª°¥·¡ ¸»·¡?
END
EVENT 22011
E ZONE_CHANGE 202 848 129
END2.evt (human)
Kod:
#########################################
EVENT 40201; ARDREAM
E RUN_EVENT 78911
E RUN_EVENT 78912
E RUN_EVENT 78913
E RUN_EVENT 78914
E RUN_EVENT 78915
E RUN_EVENT 78916
E RUN_EVENT 78917
END
EVENT 78911
A CHECK_LV 1 29
E SAY -1 -1 80001 -1 -1 -1 -1 -1 -1 -1 -1 -1; Level yetmezse hata ver ( quest_talk_us.tbl )
E RETURN
END
EVENT 78912
A CHECK_LV 60 250
E SAY -1 -1 80001 -1 -1 -1 -1 -1 -1 -1 -1 -1; Level yetmezse hata ver ( quest_talk_us.tbl )
E RETURN
END
EVENT 78913
A CHECK_SKILL_TOTAL 1 41
E SAY -1 -1 80006 -1 -1 -1 -1 -1 -1 -1 -1 -1; Level yetmezse hata ver ( quest_talk_us.tbl )
E RETURN
END
EVENT 78914
A CHECK_SKILL_TOTAL 101 250
E SAY -1 -1 80006 -1 -1 -1 -1 -1 -1 -1 -1 -1; Level yetmezse hata ver ( quest_talk_us.tbl )
E RETURN
END
EVENT 78915
A CHECK_STAT_TOTAL 1 386
E SAY -1 -1 80007 -1 -1 -1 -1 -1 -1 -1 -1 -1; Level yetmezse hata ver ( quest_talk_us.tbl )
E RETURN
END
EVENT 78916
A CHECK_STAT_TOTAL 475 500
E SAY -1 -1 80007 -1 -1 -1 -1 -1 -1 -1 -1 -1; Level yetmezse hata ver ( quest_talk_us.tbl )
E RETURN
END
EVENT 78917
E SELECT_MSG 16084 77815 44434 22011 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1;³ª°¥·¡ ¸»·¡?
END
EVENT 22011
E ZONE_CHANGE 202 183 898
END
Son düzenleme:
