PVPKO 2008 - 1299 Private Server Tanıtım,Database,Client ve Procedure Paylaşım Blogu
KnightOnline PVP Server Tanıtımı
Metin2 PVP Server Tanıtım

31 Aralık 2008 Çarşamba

Usko Görev Takıları ve Bazı İtemleri DB'e Ekle

Kullanımı ;
Q.A kodlarını db'ye girmeniz yeterli olacaktır. Genelde bütün datalarda eklidir.

İtem Kodları;
Kod:
910153111 Mage Earring
910154112 Mercenary Earring
910155113 Assassin Earring
910156114 Priest Earring

910157137 Mercenary Pendant
910158138 Messenger Pendant
910159139 Cleric Pendant

910160118 Body Belt

910161271 Messenger Ring
910162272 Mercenary Ring
910163273 Assassin Ring
910164274 Priest Ring
Kod:
insert into [ITEM] Values (910153000,'Mage Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,0,3,10,40,5,5,5,5,5,5)
insert into [ITEM] Values (910154000,'Mercenary Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,3,0,0,0,40,0,3,3,3,3,3,3)
insert into [ITEM] Values (910155000,'Assassin Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,4,0,0,30,10,7,7,7,7,7,7)
insert into [ITEM] Values (910156000,'Priest Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,3,0,25,20,3,3,3,3,3,3)
insert into [ITEM] Values (910164000,'Priest Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,4,0,45,40,3,3,3,3,3,3)
insert into [ITEM] Values (910163000,'Assassin Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,5,0,0,50,30,4,4,4,4,4,4)
insert into [ITEM] Values (910161000,'Messenger Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,4,35,50,3,3,3,3,3,3)
insert into [ITEM] Values (910162000,'Mercenary Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,4,0,0,0,70,0,2,2,2,2,2,2)
insert into [ITEM] Values (910157000,'Mercenary Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,4,3,4,0,0,80,20,0,0,0,0,0,0)
insert into [ITEM] Values (910158000,'Messenger Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,0,4,0,3,3,60,40,3,3,3,3,3,3)
insert into [ITEM] Values (910159000,'Cleric Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,3,4,0,3,0,50,50,2,2,2,2,2,2)
insert into [ITEM] Values (910160000,'Body Belt',94,14,0,0,0,100,0,0,1,640,0,0,0,0,0,1,99,0,0,0,0,0,0,0,0,4,10,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,0,0,0,50,0,0,0,0,0,0,0)

insert into [ITEM] Values (910153111,'Mage Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,0,3,10,40,5,5,5,5,5,5)
insert into [ITEM] Values (910154112,'Mercenary Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,3,0,0,0,40,0,3,3,3,3,3,3)
insert into [ITEM] Values (910155113,'Assassin Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,4,0,0,30,10,7,7,7,7,7,7)
insert into [ITEM] Values (910156114,'Priest Earring',91,10,0,6,0,100,0,0,1,640,0,0,0,0,0,60,99,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,3,0,25,20,3,3,3,3,3,3)
insert into [ITEM] Values (910164274,'Priest Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,4,0,45,40,3,3,3,3,3,3)
insert into [ITEM] Values (910163273,'Assassin Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,5,0,0,50,30,4,4,4,4,4,4)
insert into [ITEM] Values (910161271,'Messenger Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,0,0,4,35,50,3,3,3,3,3,3)
insert into [ITEM] Values (910162272,'Mercenary Ring',93,12,0,0,0,100,0,0,1,640,0,5,0,0,0,1,99,0,0,0,0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,4,0,0,0,70,0,2,2,2,2,2,2)
insert into [ITEM] Values (910157137,'Mercenary Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,4,3,4,0,0,80,20,0,0,0,0,0,0)
insert into [ITEM] Values (910158138,'Messenger Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,0,4,0,3,3,60,40,3,3,3,3,3,3)
insert into [ITEM] Values (910159139,'Cleric Pendant',92,11,0,0,0,100,0,0,1,640,0,7,0,0,0,1,99,0,0,0,0,0,0,0,0,4,50,0,5,0,5,0,5,0,0,0,0,0,0,0,0,0,0,3,4,0,3,0,50,50,2,2,2,2,2,2)
insert into [ITEM] Values (910160118,'Body Belt',94,14,0,0,0,100,0,0,1,640,0,0,0,0,0,1,99,0,0,0,0,0,0,0,0,4,10,15,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,0,0,0,50,0,0,0,0,0,0,0)

Insert into [ITEM] values (379015000,'Bezoar of Glyptodont',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379007000,'Tooth of Smilodon',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379008000,'Claw of Stegodon',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379009000,'Heart of Haunga',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379010000,'Gavolt scales',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379254000,'Wolf Hide',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (910165000,'Wolfman',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389251000,'Arcas',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389252000,'Virgo',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389253000,'Libra',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389254000,'Canes Venatici',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389255000,'Leo',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389256000,'hydra',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379253000,'Skeleton',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379045000,'Cursed Bone',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379251000,'Kekoon gallbladder',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379252000,'Black silk spool',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (910118000,'Kekoon Armor',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379013000,'Mythril vessel',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389522000,'Golden Star Ornament',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389523000,'Red Bow Ornament',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (389524000,'Tinsel Ornament',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379270000,'Smirdon Meat',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379271000,'Smirdon Hide',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379272000,'Silver Feather',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379273000,'Animal Blood',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379275000,'Coarse Ground Bone',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
Insert into [ITEM] values (379276000,'Oath of Darkness',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)

Buradan Kodları Not Defteri İçinde İndirebilirsiniz.



Kodlar styLemert'den aLıntıdır.

DB'nize Mega Atross Ekleyin.

Mega Atross;
  • 990k hp si var.
  • Kesildiği taktirde 5k np veriyor.
  • Atack yapmıyor.
  • Boyutuda gayet küçük
Mega Atross'u DB'e eklemek için aşağıdaki kodu K_MONSTER tablesine ekleyiniz.


Kod:
8765 Mega Atross 1410 5 0 0 0 1 3 14 0 0 0 50 375000 5000 990000 10000 0 1224 261 649 2700 3000 2 9 5000 300104 300105 0 500 500 500 500 500 500 500 200 30 10 45 279618 1402 2 5 0  
Mega Atross'u çıkarmak için +monsummon 8765






29 Aralık 2008 Pazartesi

Hazır Odbc ve İniler + Kullanımı ve Resimli Anlatım

Öncelikle Aşağıdaki Linkten Hazır Odbc ve inileri indirin.

Hazır Odbc ve İNİler.. ( Pot Silinmesi Sorunu Giderildi)
Rar PaSS: privateserverlar.blogspot.com


NOT: Bu Odbc ve iniler DB ismi kn_online oLarak Hazırlanmıştır..


İndirdiğiniz dosyaları rar'dan çıkartınız.. Çıkardıktan Sonra " Oto Odbc " Dosyası içindeki regedit dosyasına 2 kere tıklayın ve karşınıza gelen ekranda tamam deyiniz.

Tamam dedikten sonra Başlat > Denetim MAsası > Yönetimsel Araçlar > Veri Kaynakları (ODBC) 'a giriyoruz..

Girdikten sonra yukarıdaki sekmelerden " SİSTEM DNS " yi seçiyoruz. Seçtikten sonra alttaki alanda;
  • data
  • Kdata
  • KN_Data
  • kn_online
  • Knight
  • Knight_Account
  • Knight_Data
  • LocalServer
  • Sknight
oLacaktır.. Bunlar var ise doğru yapmışız demektir.. Geriye sadece yapılandır diyerek kendi serverımıza göre uyarlayacağız.. Ben bir tanesini örnek olarak yapacağım diğerlerini siz uyarlarsınız...






28 Aralık 2008 Pazar

Usko'daki Yeni İtemleri DB'nize Ekleme + Resimli Anlatım

Öncelikle Buradan gerekli olan " Data " ve "Query Analyzer Kodlarını" aLıyoruz.

Serverımız Kapalı iken;

Başlat > Tüm Programlar > Microsoft SQL Server > Query Analyzer'ı çalıştırıyoruz..


Query Analyzer'dan DB'mizi Seçiyoruz..


Başta Almış olduğumuz Query Analyzer Kodlarını Buraya Kopyalıyoruz ve F5 'e basıyoruz..


Mesaj bölümünde çıkan yazılar bize işin bittiğini haber veriyor..

Bitirdikten Sonra Herhangi bir inventory editör iLe itemleri karakterinize verebilirsiniz.


Diğer İtemleri Aşağıdaki Resimlerden Görebilirsiniz.


Usko'daki Tüm Yeni İtemler

27 Aralık 2008 Cumartesi

+10 İtem Kodları Bonuslarıyla Birlikte

Kod:

156210010    +10 Raptor Normal
156210050    +10 Raptor Posion

111210010    +10 Shard Normal
111210050    +10 Shard Posion

146210010    +10 Iron Impact Normal
146210050    +10 Iron Impact Lighting


206001020    +10 Warrior Shell Pauldron         STR
206002020    +10 Warrior Shell Pad               STR
206003020    +10 Warrior Shell Helment          STR
206004020    +10 Warrior Shell Gaunlet          STR
206005020    +10 Warrior Shell Bot                  STR


206001510    +10 Warrior Shell Pauldron         HP
206002510    +10 Warrior Shell Pad                   HP
206003510    +10 Warrior Shell Helment          HP
206004510    +10 Warrior Shell Gaunlet          HP
206005510    +10 Warrior Shell Bot                   HP


206001520    +10 Warrior Shell Pauldron         DEX
206002520    +10 Warrior Shell Pad               DEX
206003520    +10 Warrior Shell Helment          DEX
206004520    +10 Warrior Shell Gaunlet          DEX
206005520    +10 Warrior Shell Bot                  DEX


206001530    +10 Warrior Shell Pauldron         INT
206002530    +10 Warrior Shell Pad               INT
206003530    +10 Warrior Shell Helment          INT
206004530    +10 Warrior Shell Gaunlet          INT
206005530    +10 Warrior Shell Bot                  INT


206001540    +10 Warrior Shell Pauldron         MAGIC
206002540    +10 Warrior Shell Pad               MAGIC
206003540    +10 Warrior Shell Helment          MAGIC
206004540    +10 Warrior Shell Gaunlet          MAGIC
206005540    +10 Warrior Shell Bot                  MAGIC



246001020    +10 Rogue Shell Pauldron           STR
246002020    +10 Rogue Shell Pad                    STR
246003020    +10 Rogue Shell Helment            STR
246004020    +10 Rogue Shell Gaunlet            STR
246005020    +10 Rogue Shell Bot                  STR


246001510    +10 Rogue Shell Pauldron          HP
246002510    +10 Rogue Shell Pad                   HP
246003510    +10 Rogue Shell Helment           HP
246004510    +10 Rogue Shell Gaunlet           HP
246005510    +10 Rogue Shell Bot                    HP



246001520    +10 Rogue Shell Pauldron           DEX
246002520    +10 Rogue Shell Pad                   DEX
246003520    +10 Rogue Shell Helment           DEX
246004520    +10 Rogue Shell Gaunlet            DEX
246005520    +10 Rogue Shell Bot                   DEX



246001530    +10 Rogue Shell Pauldron          INT
246002530    +10 Rogue Shell Pad                   INT
246003530    +10 Rogue Shell Helment           INT
246004530    +10 Rogue Shell Gaunlet           INT
246005530    +10 Rogue Shell Bot                   INT



246001540    +10 Rogue Shell Pauldron          MAGIC
246002540    +10 Rogue Shell Pad                   MAGIC
246003540    +10 Rogue Shell Helment           MAGIC
246004540    +10 Rogue Shell Gaunlet           MAGIC
246005540    +10 Rogue Shell Bot                   MAGIC



266001020    +10 Magican Shell Pauldron         STR
266002020    +10 Magican Shell Pad         STR
266003020    +10 Magican Shell Helment         STR
266004020    +10 Magican Shell Gaunlet         STR
266005020    +10 Magican Shell Bot         STR


266001510    +10 Magican Shell Pauldron         HP
266002510    +10 Magican Shell Pad         HP
266003510    +10 Magican Shell Helment         HP
266004510    +10 Magican Shell Gaunlet          HP
266005510    +10 Magican Shell Bot         HP


266001520    +10 Magican Shell Pauldron         DEX
266002520    +10 Magican Shell Pad         DEX
266003520    +10 Magican Shell Helment         DEX
266004520    +10 Magican Shell Gaunlet         DEX
266005520    +10 Magican Shell Bot         DEX


266001530    +10 Magican Shell Pauldron         INT
266002530    +10 Magican Shell Pad         INT
266003530    +10 Magican Shell Helment         INT
266004530    +10 Magican Shell Gaunlet          INT
266005530    +10 Magican Shell Bot         INT


266001540    +10 Magican Shell Pauldron         MAGIC
266002540    +10 Magican Shell Pad         MAGIC
266003540    +10 Magican Shell Helment         MAGIC
266004540    +10 Magican Shell Gaunlet         MAGIC
266005540    +10 Magican Shell Bot         MAGIC


286001020    +10 Priest Shell Pauldron         STR
286002020    +10 Priest Shell Pad         STR
286003020    +10 Priest Shell Helment         STR
286004020    +10 Priest Shell Gaunlet         STR
286005020    +10 Priest Shell Bot         STR


286001510    +10 Priest Shell Pauldron         HP
286002510    +10 Priest Shell Pad         HP
286003510    +10 Priest Shell Helment         HP
286004510    +10 Priest Shell Gaunlet         HP
286005510    +10 Priest Shell Bot         HP


286001520    +10 Priest Shell Pauldron         DEX
286002520    +10 Priest Shell Pad         DEX
286003520    +10 Priest Shell Helment         DEX
286004520    +10 Priest Shell Gaunlet         DEX
286005520    +10 Priest Shell Bot         DEX


286001530    +10 Priest Shell Pauldron         INT
286002530    +10 Priest Shell Pad         INT
286003530    +10 Priest Shell Helment         INT
286004530    +10 Priest Shell Gaunlet         INT
286005530    +10 Priest Shell Bot         INT


286001540    +10 Priest Shell Pauldron         MAGIC
286002540    +10 Priest Shell Pad         MAGIC
286003540    +10 Priest Shell Helment         MAGIC
286004540    +10 Priest Shell Gaunlet         MAGIC
286005540    +10 Priest Shell Bot         MAGIC



24 Aralık 2008 Çarşamba

Mage Blink Skill'ini Wind Advent Gibi Yapmak

1299 Private Serverlarda, bildiğiniz gibi Wild Advent 40 Metre uzağındaki düşmanın yanına ışınlanabiliyor. Blink'i madem USKO'daki gibi çalıştıramıyoruz,Kernkraft'a Blink'i Wild Advent'e benzetmiş.


Kod:
insert into MAGIC values (210774 , 'ºí¸µÅ©' , 'Blink' , 'Able to teleport in front of an opponent 20 meters away.' , 0 , 0 , 0 , 0 , 10123 , 7 , 80 , 2107 , 100 , 0 , 9 , 0 , 0 , 255 , 80 , 8 , 0 , 50 , 0 , 0)

insert into MAGIC values (110774 , 'ºí¸µÅ©' , 'Blink' , 'Able to teleport in front of an opponent 20 meters away.' , 0 , 0 , 0 , 0 , 10123 , 7 , 80 , 1107 , 100 , 0 , 9 , 0 , 0 , 255 , 80 , 8 , 0 , 50 , 0 , 0)

insert into MAGIC_TYPE8 values (110774 , 'Blink' , 'Able to teleport in front of an opponent 20 meters away.' , 1 , 40 , 25 , 0)

insert into MAGIC_TYPE8 values (210774 , 'Blink' , 'Able to teleport in front of an opponent 20 meters away.' , 1 , 40 , 25 , 0)
Kodları Query'de çalıştırdıktan sonra patch'i de attıktan sonra sorunsuzca çalışacaktır..


Buradan Patchi İndirebilirsiniz.


Bu Kodlar Kernkraft Tarafından Yazılmıştır.


20 Aralık 2008 Cumartesi

Otomatik Irk Verme

Bu Kodu , ACCOUNT_LOGIN'de ;
Oto üyeliğin içine yazacaksınız.
Yani Şuraya ;



Kod:
if @nRet = 0
begin
begin 'in hemen altında , instert into ile başlayan kod vardır.
Onun hemen altına ekliyorsunuz ;



Kodu Not Defteri İçinde İndirmek İçin


Kod:
-- Code By Ganks - Ko-Cuce.Com
declare @k int , @h int
select @k = count(strAccountID) from KO_S1.dbo.ACCOUNT_CHAR where bNation = 1
select @h = count(strAccountID) from KO_S1.dbo.ACCOUNT_CHAR where bNation = 2

if @k < @h --eğer karuslar daha az ise; begin insert into KO_S1.dbo.ACCOUNT_CHAR (strAccountID, bNation, bCharNum) values (@AccountID, @k, 0) end  if @h < @k --eğer humanlar daha az ise; begin insert into KO_S1.dbo.ACCOUNT_CHAR (strAccountID, bNation, bCharNum) values (@AccountID, @h, 0) end   if @h = @k begin insert into KO_S1.dbo.ACCOUNT_CHAR (strAccountID, bNation, bCharNum) values (@AccountID, @h, 0) end  INSERT INTO WAREHOUSE ( strAccountID ) VALUES (@AccountID))
Kaydediyorsunuz. Artık Yeni üyelik açıldıgında Irk'ı Otomatik atayacaktır.! Bu Kod Ganks Tarafından Yazılmıştır..

10k Group (Party) Heal Hatası Alanlara Çözüm + QA Kodu

İlk Baş Çalışmayan Skillerimizi Siliyoruz..


Kod:
delete from MAGIC where enName LIKE '%Complete%'
delete from MAGIC_TYPE3 where Name LIKE '%Complete%'
Magic Tablosunun En Alt Kısmına Bunu Ekliyoruz

Kod:
112554    Complete healing                  ???? ??                     ??? HP? ?? ???? ???                                                                        0    0    0    0    603    2    54    1125    960    0    9    0    15    54    80    3    0    25    1    0
112560    Group complete healing            ?? ???? ??                ?? ???? HP? ??? ???? ???                                                               0    0    0    0    603    6    60    1125    1920    0    9    0    15    64    80    3    0    25    1    0
212554    Complete healing                  ???? ??                     ??? HP? ?? ???? ???                                                                        0    0    0    0    603    2    54    2125    960    0    9    0    15    54    80    3    0    25    1    0
212560    Group complete healing            ?? ???? ??                ?? ???? HP? ??? ???? ???                                                               0    0    0    0    603    6    60    2125    1920    0    9    0    15    64    80    3    0    25    1    0
211554    Complete healing                  ???? ??                     ??? HP? ?? ???? ???                                                                        0    0    0    0    603    2    54    2115    960    0    9    0    15    54    80    3    0    25    1    0
211560    Group complete healing            ?? ???? ??                ?? ???? HP? ??? ???? ???                                                               0    0    0    0    603    6    60    2115    1920    0    9    0    15    64    80    3    0    25    1    0
111554    Complete healing                  ???? ??                     ??? HP? ?? ???? ???                                                                        0    0    0    0    603    2    54    1115    960    0    9    0    15    54    80    3    0    25    1    0
111560    Group complete healing            ?? ???? ??                ?? ???? HP? ??? ???? ???                                                               0    0    0    0    603    6    60    1115    1920    0    9    0    15    64    80    3    0    25    1    0
Bunuda Magic_Type3

Kod:
111554    Complete healing                  ??? HP? ?? ???? ???    0    0    1    6500    0    0    0    0
111560    Group complete healing            ?? ???? HP? ??? ???? ???    30    0    1    6500    0    0    0    0
112554    Complete healing                  ??? HP? ?? ???? ???    0    0    1    6500    0    0    0    0
112560    Group complete healing            ?? ???? HP? ??? ???? ???    30    0    1    6500    0    0    0    0
211554    Complete healing                  ??? HP? ?? ???? ???    0    0    1    6500    0    0    0    0
211560    Group complete healing            ?? ???? HP? ??? ???? ???    30    0    1    6500    0    0    0    0
212554    Complete healing                  ??? HP? ?? ???? ???    0    0    1    6500    0    0    0    0
212560    Group complete healing            ?? ???? HP? ??? ???? ???    30    0    1    6500    0    0    0    0
Sorunsuz Çalışır, Artık Yine Çalışmıyorsa Datanızı değiştirin.

Query Kod Eklendi:

Kod:
insert into MAGIC values (112554 , 'Complete healing              ' , '???? ??                 ' , '??? HP? ?? ???? ???                                                                    ' , 0 , 0 , 0 , 0 , 603 , 2 , 54 , 1125 , 960 , 0 , 9 , 0 , 15 , 54 , 80 , 3 , 0 , 25 , 1 , 0)
insert into MAGIC values (112560 , 'Group complete healing        ' , '?? ???? ??            ' , '?? ???? HP? ??? ???? ???                                                           ' , 0 , 0 , 0 , 0 , 603 , 6 , 60 , 1125 , 1920 , 0 , 9 , 0 , 15 , 64 , 80 , 3 , 0 , 25 , 1 , 0)
insert into MAGIC values (212554 , 'Complete healing              ' , '???? ??                 ' , '??? HP? ?? ???? ???                                                                    ' , 0 , 0 , 0 , 0 , 603 , 2 , 54 , 2125 , 960 , 0 , 9 , 0 , 15 , 54 , 80 , 3 , 0 , 25 , 1 , 0)
insert into MAGIC values (212560 , 'Group complete healing        ' , '?? ???? ??            ' , '?? ???? HP? ??? ???? ???                                                           ' , 0 , 0 , 0 , 0 , 603 , 6 , 60 , 2125 , 1920 , 0 , 9 , 0 , 15 , 64 , 80 , 3 , 0 , 25 , 1 , 0)
insert into MAGIC values (211554 , 'Complete healing              ' , '???? ??                 ' , '??? HP? ?? ???? ???                                                                    ' , 0 , 0 , 0 , 0 , 603 , 2 , 54 , 2115 , 960 , 0 , 9 , 0 , 15 , 54 , 80 , 3 , 0 , 25 , 1 , 0)
insert into MAGIC values (211560 , 'Group complete healing        ' , '?? ???? ??            ' , '?? ???? HP? ??? ???? ???                                                           ' , 0 , 0 , 0 , 0 , 603 , 6 , 60 , 2115 , 1920 , 0 , 9 , 0 , 15 , 64 , 80 , 3 , 0 , 25 , 1 , 0)
insert into MAGIC values (111554 , 'Complete healing              ' , '???? ??                 ' , '??? HP? ?? ???? ???                                                                    ' , 0 , 0 , 0 , 0 , 603 , 2 , 54 , 1115 , 960 , 0 , 9 , 0 , 15 , 54 , 80 , 3 , 0 , 25 , 1 , 0)
insert into MAGIC values (111560 , 'Group complete healing        ' , '?? ???? ??            ' , '?? ???? HP? ??? ???? ???                                                           ' , 0 , 0 , 0 , 0 , 603 , 6 , 60 , 1115 , 1920 , 0 , 9 , 0 , 15 , 64 , 80 , 3 , 0 , 25 , 1 , 0)
insert into MAGIC_Type3 values (111554 , 'Complete healing              ' , '??? HP? ?? ???? ???' , 0 , 0 , 1 , 6500 , 0 , 0 , 0 , 0)
insert into MAGIC_Type3 values (111560 , 'Group complete healing        ' , '?? ???? HP? ??? ???? ???' , 30 , 0 , 1 , 6500 , 0 , 0 , 0 , 0)
insert into MAGIC_Type3 values (112554 , 'Complete healing              ' , '??? HP? ?? ???? ???' , 0 , 0 , 1 , 6500 , 0 , 0 , 0 , 0)
insert into MAGIC_Type3 values (112560 , 'Group complete healing        ' , '?? ???? HP? ??? ???? ???' , 30 , 0 , 1 , 6500 , 0 , 0 , 0 , 0)
insert into MAGIC_Type3 values (211554 , 'Complete healing              ' , '??? HP? ?? ???? ???' , 0 , 0 , 1 , 6500 , 0 , 0 , 0 , 0)
insert into MAGIC_Type3 values (211560 , 'Group complete healing        ' , '?? ???? HP? ??? ???? ???' , 30 , 0 , 1 , 6500 , 0 , 0 , 0 , 0)
insert into MAGIC_Type3 values (212554 , 'Complete healing              ' , '??? HP? ?? ???? ???' , 0 , 0 , 1 , 6500 , 0 , 0 , 0 , 0)
insert into MAGIC_Type3 values (212560 , 'Group complete healing        ' , '?? ???? HP? ??? ???? ???' , 30 , 0 , 1 , 6500 , 0 , 0 , 0 , 0)
Bu Kodlar 0uikShare Tarafından Yazılmıştır.


Bütün Kodlar [ Not Defteri İçinde ]



19 Aralık 2008 Cuma

Sembol 99 / Sarı Rütbe

İndirdiğiniz Dosyanın içindeki " symbol " dosyasını Clientinizin içindeki " symbol_us " a atınız.. Resimli Anlatım için Tıkla..




Sembol 98 / Kırmızı Taç

İndirdiğiniz Dosyanın içindeki " symbol " dosyasını Clientinizin içindeki " symbol_us " a atınız.. Resimli Anlatım için Tıkla..




Sembol 97 / Taç Sembolü

İndirdiğiniz Dosyanın içindeki " symbol " dosyasını Clientinizin içindeki " symbol_us " a atınız.. Resimli Anlatım için Tıkla..


Sembol 96 / Kırmızı R Harfi

İndirdiğiniz Dosyanın içindeki " symbol " dosyasını Clientinizin içindeki " symbol_us " a atınız.. Resimli Anlatım için Tıkla..




Pelerin Sembollerini Nasıl Kullanırım?



1-
Öncelikle Kullanmak İstediğimiz Bir Sembolü Seçiyoruz.. (Dosyamızın adı " symbol " , Dosyamızın Türü de " .BMP ")



2- " symbol " Dosyamızı Knight Online Client'i İçindeki " symbol_us " klasörü içine kopyalıyoruz..




3- Karşımıza gelen Ekrana " Evet " diyoruz.




4- ve Oyuna Girip Pelerinciye Gidip Sembolümüzü Kullanıyoruz..




14 Aralık 2008 Pazar

DB'nize Felankor Lair (Odası) Ekleyin

Öncelikle Şunu İndirip Zones Klasörü içine Atınız..

Rapidshare & MediaFire


Aşağıdakileri de AiServer ve Ebenezerdeki Map içine Atınız.


66.Evt & 66.Evt(Alternatif)



Dragon.Smd & Dragon.SMd(Alternatif)


QUERY ANALYZER'a şu kodları uygulayın.


Kod:

insert into ZONE_INFO values('1','66','Dragon.smd','163000','163000','0','2','0','FELANKOR FLOOR') 

Kod:

insert into START_POSITION values('66','109','21','109','21','1','1','0','0','0','0') 
Sonra ZonesZones.tbl 'i bir Editör yardımıyla açın.

ve
Klasöründeki = 'den sonrakileri teker teker girin.



PHP- Kodu:

1.sütun = 660

2.sütun
= Zones11111111.gtd

3.sütun
= 11111111

4.sütun
= Zones11111111.tct

5.sütun
= Zones11111111.tlt

6.sütun
= Zones11111111.opd

7.sütun
= Zones11111111.opd

8.sütun
= Zones11111111.opdext

9.sütun
= Zones11111111.dxt

10.sütun
= MiscSkyBattleZone.N3Sky

11.sütun
= 0

12.sütun
= 2

13.sütun
= Zones11111111.glo

14.sütun
= Zones11111111.gev

15.sütun
= 0

16.sütun
= Zones11111111.ens

17.sütun
= 1

18.sütun
= Later

19.sütun
= 20003

20.sütun
= 20000

21.sütun
= 20002

22.sütun
= 20000

23.sütun
= Zones11111111.opdsub

24.sütun
= 0

25.sütun
= Zones11111111.evtsub
Şunları K_npc' e ekleyin.



Kod:

    19997    Çikis    2050    100    120710000    170210000    2    7    137    1    3    3    0    90    100    0    120000    0    0    20000    497    497    4000    1500    0    0    1000    0    0    0    250    250    250    250    250    250    250    90    7    14    35    32000    21510    0    0    1 

Kod:

    19990    Çikis    2050    100    120710000    170210000    1    7    137    1    3    3    0    90    100    0    120000    0    0    20000    497    497    4000    1500    0    0    1000    0    0    0    250    250    250    250    250    250    250    90    7    14    35    32000    21510    0    0    1 
Bunları K_npcpos' a ekleyin.


Kod:

    66    7035    1    0    0    0    0    58    70    58    70    58    70    58    70    1    32000    0    0 

Kod:

    66    19997    107    0    0    0    0    104    18    104    18    104    18    104    18    1    30    0    0    01040018010400180104001801040018 

Kod:

    66    19990    107    0    0    0    0    113    17    113    17    113    17    113    17    1    30    0    0    01130017011300170113001701130017 
Eğer gidip görmek isterseniz +zonechange 66 yazın ve Town çekin.

Etraf Bembeyaz ise USKO Object,Misc,Dtex Klasörlerini kullanın sorun hallolur..

Toplamda Eklediklerimiz;

  • Çıkış NPC'si
  • Felankor
  • Bu NPC'lerin ReSpawm'ları
  • Town Çekme
  • Zones.Tbl ve Felankor Odası Satırı
  • Felankor Odası Zone Dosyaları
FelanKor Lair (Odası), Shellx Tarafından Yapılmıştır..


Aşağıdakileride uygularsanız, Hell Abyss'den Dragon Marble düşürüp Teleport Gate'lerden felankora çıkabilirsiniz.

Evt Dosyası;


Rapidshare & Mediafire


Item Kodu ;


Kod:
Insert Into [ITEM] Values (389200000,'Dragon Marble',97,17,0,0,0,0,0,0,1,600000,0,0,1,0,0,1,99,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
TBL EDİT

Quest_Talk_Us.tbl'ye;


Kod:
91000    You have the Dragon's Marble. There's a gateway to Dragon in this cave.
Quest_Menu_Us.tbl'ye;


Kod:
92000    Enter the Dragon Cave
92001    Do not enter the Dragon Cave
Item_org_us.tbl ( Zaten vardır ama kontrol edin. )


Kod:
389200000    22    Dragon's Marble    Dragon    0    0    38920000    38920000    0    0    95    0    15    0    0    0    0    0    30    1    1000000    0    0    0    0    0    0    100    0    0    0    0    0    0    0    0
Hell Abyss'ten Dragon Marble Çıkarıp Felankor'a gitmek,styLemert'e aittir.
YASAL UYARI !! Sitemiz, hukuka, yasalara, telif haklarına ve kişilik haklarına saygılı olmayı amaç edinmiştir. Sitemiz, 5651 sayılı yasada tanımlanan yer sağlayıcı olarak hizmet vermektedir. İlgili yasaya göre, site yönetiminin hukuka aykırı içerikleri kontrol etme yükümlülüğü yoktur. Bu nedenle, sitemiz uyar ve kaldır prensibini benimsemiştir. Telif hakkına konu olan eserlerin yasal olmayan bir biçimde paylaşıldığını ve yasal haklarının çiğnendiğini düşünen hak sahipleri veya meslek birlikleri, s.gezer92[at]gmail.com mail adresinden bize ulaşabilirler. Şikayet yerinde görüldüğü takdirde ihlal olduğu düşünülen içerikler sitemizden kaldırılacaktır.
Arkasında Google Var! | Bu site Google Adsense ile gelir sağlamaktadır.