Sitemizden Yararlanmak İçin

Sitemize Üye Olmalısınız

or Kayıt ol
Server Tanitimi , Ko Tanitimi , Silkroad Pvp Serverler , Metin2 Pvp Serverler

Selfname İtemler Sorunsuz Upgrade Qa Kodu Trina Ve Trinasız

[XFB] Konu Bilgileri

Konu Hakkında Merhaba, tarihinde Knight Online Pvp Prosedür & Kod Paylaşımları kategorisinde Stark tarafından oluşturulan Selfname İtemler Sorunsuz Upgrade Qa Kodu Trina Ve Trinasız başlıklı konuyu okuyorsunuz. Bu konu şimdiye dek 1,074 kez görüntülenmiş, 0 yorum ve 0 tepki puanı almıştır...
Kategori Adı Knight Online Pvp Prosedür & Kod Paylaşımları
Konu Başlığı Selfname İtemler Sorunsuz Upgrade Qa Kodu Trina Ve Trinasız
Konbuyu başlatan Stark
Başlangıç tarihi
Cevaplar
Görüntüleme
İlk mesaj tepki puanı
Son Mesaj Yazan Stark

Stark

K.Destek Yöneticisi
Katılım
27 May 2013
Mesajlar
2,663
Tepkime puanı
10
Puanları
0
Selamlar







### SHIELD OF in Çoklu İD si Fix ###



1.



Queryde Çalıştırın:









Kod:

DELETE FROM ITEM WHERE strName LIKE '%Shield of %'

2.



Queryde Çalıştırın:













Kod:

insert into [ITEM] Values (910126544,Shield of ,60,2,0,0,0,100,20,200,9000,84974,0,195,0,0,0,1,99 ,0,0,94,0,0,0,0,0,4,0,0,0,20,20,20,20,0,0,0,0,

0,0,0,0,0,3,1,1,1,1,0,0,0,2,2,2,0,0,0)

insert into [ITEM] Values (910126301,Shield of (+1),60,2,0,0,0,100,20,200,9000,84974,0,195,0,0,0, 1,99,0,0,94,0,0,0,0,0,4,0,0,0,20,20,20,20,0,0,0,0,

0,0,0,0,0,3,1,1,1,1,0,0,0,2,2,2,0,0,0)

insert into [ITEM] Values (910126302,Shield of (+2),60,2,0,0,0,100,20,200,10000,84974,0,197,0,0,0 ,1,99,0,0,96,0,0,0,0,0,4,0,0,0,23,23,23,23,0,0,0,0

,0,0,0,0,0,3,2,2,2,2,0,0,0,4,4,4,0,0,0)

insert into [ITEM] Values (910126303,Shield of (+3),60,2,0,0,0,100,20,200,11000,84974,0,202,0,0,0 ,1,99,0,0,98,0,0,0,0,0,4,0,0,0,26,26,26,26,0,0,0,0

,0,0,0,0,0,3,3,3,3,3,0,0,0,6,6,6,0,0,0)

insert into [ITEM] Values (910126304,Shield of (+4),60,2,0,0,0,100,20,200,12000,84974,0,207,0,0,0 ,1,99,0,0,100,0,0,0,0,0,4,0,0,0,29,29,29,29,0,0,0,

0,0,0,0,0,0,3,4,4,4,4,0,0,0,8,8,8,0,0,0)

insert into [ITEM] Values (910126305,Shield of (+5),60,2,0,0,0,100,20,200,13000,84974,0,212,0,0,0 ,1,99,0,0,102,0,0,0,0,0,4,0,0,0,32,32,32,32,0,0,0,

0,0,0,0,0,0,3,5,5,5,5,0,0,0,10,10,10,0,0,0)

insert into [ITEM] Values (910126306,Shield of (+6),60,2,0,0,0,100,20,200,14000,84974,0,217,0,0,0 ,1,99,0,0,104,0,0,0,0,0,4,0,0,0,35,35,35,35,0,0,0,

0,0,0,0,0,0,3,6,6,6,6,0,0,0,12,12,12,0,0,0)

insert into [ITEM] Values (910126307,Shield of (+7),60,2,0,0,0,100,20,200,15000,84974,0,224,0,0,0 ,1,99,0,0,106,0,0,0,0,0,4,0,0,0,38,38,38,38,0,0,0,

0,0,0,0,0,0,4,7,7,7,7,0,0,0,14,14,14,0,0,0)

insert into [ITEM] Values (910126308,Shield of (+8),60,2,0,0,0,100,20,200,16000,84974,0,234,0,0,0 ,1,99,0,0,108,0,0,0,0,0,4,0,0,0,41,41,41,41,0,0,0,

0,0,0,0,0,0,4,8,8,8,8,0,0,0,16,16,16,0,0,0)

insert into [ITEM] Values (910126309,Shield of (+9),60,2,0,0,0,100,20,200,17000,84974,0,250,0,0,0 ,1,99,0,0,110,0,0,0,0,0,4,0,0,0,44,44,44,44,0,0,0,

0,0,0,0,0,0,4,9,9,9,9,0,0,0,18,18,18,0,0,0)

insert into [ITEM] Values (910126310,Shield of (+10),60,2,0,0,0,100,20,200,18000,84974,0,285,0,0, 0,1,99,0,0,112,0,0,0,0,0,4,0,0,0,47,47,47,47,0,0,0 ,

0,0,0,0,0,0,4,10,10,10,10,0,0,0,20,20,20,0,0,0)

3.



Clientinize Geçin Ve Shield of in ID sini 910120000 Yapın. İtem_org_us.tbl















---------------------------------------------------------------------------------------------------------------------------



---------------------------------------------------------------------------------------------------------------------------



---------------------------------------------------------------------------------------------------------------------------



---------------------------------------------------------------------------------------------------------------------------















### NO TRINA ###







:













Kod:

insert into [ITEM_UPGRADE] Values (910101,5001,'Dagger of ','+0',-1,0,379025000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910102,5001,'Dagger of ','+1',-1,301,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910103,5001,'Dagger of ','+2',-1,302,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910104,5001,'Dagger of ','+3',-1,303,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910105,5001,'Dagger of ','+4',-1,304,379021000,0,0,0,0,0,0,0,200000,8,9000,1)

insert into [ITEM_UPGRADE] Values (910106,5001,'Dagger of ','+5',-1,305,379021000,0,0,0,0,0,0,0,200000,8,8500,1)

insert into [ITEM_UPGRADE] Values (910107,5001,'Dagger of ','+6',-1,306,379021000,0,0,0,0,0,0,0,200000,8,6000,1)

insert into [ITEM_UPGRADE] Values (910108,5001,'Dagger of ','+7',-1,307,379021000,0,0,0,0,0,0,0,200000,8,3000,1)

insert into [ITEM_UPGRADE] Values (910109,5001,'Dagger of ','+8',-1,308,379021000,0,0,0,0,0,0,0,200000,8,1000,1)

insert into [ITEM_UPGRADE] Values (910110,5001,'Dagger of ','+9',-1,309,379021000,0,0,0,0,0,0,0,200000,8,500,1)

insert into [ITEM_UPGRADE] Values (910111,5001,'Dagger of ','+10',-1,310,379021000,0,0,0,0,0,0,0,200000,8,10,1)

:













Kod:

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+0',-1,0,379025000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+1',-1,301,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+2',-1,302,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+3',-1,303,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+4',-1,304,379021000,0,0,0,0,0,0,0,200000,8,9000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+5',-1,305,379021000,0,0,0,0,0,0,0,200000,8,8500,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+6',-1,306,379021000,0,0,0,0,0,0,0,200000,8,6000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+7',-1,307,379021000,0,0,0,0,0,0,0,200000,8,3000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+8',-1,308,379021000,0,0,0,0,0,0,0,200000,8,1000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+9',-1,309,379021000,0,0,0,0,0,0,0,200000,8,500,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+10',-1,310,379021000,0,0,0,0,0,0,0,200000,8,10,1)

:













Kod:

insert into [ITEM_UPGRADE] Values (910120,5001,'Shield of ','+0',-1,0,379025000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910120,5001,'Shield of ','+1',-1,301,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910120,5001,'Shield of ','+2',-1,302,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910120,5001,'Shield of ','+3',-1,303,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910120,5001,'Shield of ','+4',-1,304,379021000,0,0,0,0,0,0,0,200000,8,9000,1)

insert into [ITEM_UPGRADE] Values (910120,5001,'Shield of ','+5',-1,305,379021000,0,0,0,0,0,0,0,200000,8,8500,1)

insert into [ITEM_UPGRADE] Values (910120,5001,'Shield of ','+6',-1,306,379021000,0,0,0,0,0,0,0,200000,8,6000,1)

insert into [ITEM_UPGRADE] Values (910120,5001,'Shield of ','+7',-1,307,379021000,0,0,0,0,0,0,0,200000,8,3000,1)

insert into [ITEM_UPGRADE] Values (910120,5001,'Shield of ','+8',-1,308,379021000,0,0,0,0,0,0,0,200000,8,1000,1)

insert into [ITEM_UPGRADE] Values (910120,5001,'Shield of ','+9',-1,309,379021000,0,0,0,0,0,0,0,200000,8,500,1)

insert into [ITEM_UPGRADE] Values (910120,5001,'Shield of ','+10',-1,310,379021000,0,0,0,0,0,0,0,200000,8,10,1)

:













Kod:

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+0',-1,0,379025000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+1',-1,301,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+2',-1,302,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+3',-1,303,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+4',-1,304,379021000,0,0,0,0,0,0,0,200000,8,9000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+5',-1,305,379021000,0,0,0,0,0,0,0,200000,8,8500,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+6',-1,306,379021000,0,0,0,0,0,0,0,200000,8,6000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+7',-1,307,379021000,0,0,0,0,0,0,0,200000,8,3000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+8',-1,308,379021000,0,0,0,0,0,0,0,200000,8,1000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+9',-1,309,379021000,0,0,0,0,0,0,0,200000,8,500,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+10',-1,310,379021000,0,0,0,0,0,0,0,200000,8,10,1)

:













Kod:

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+0',-1,0,379025000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+1',-1,301,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+2',-1,302,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+3',-1,303,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+4',-1,304,379021000,0,0,0,0,0,0,0,200000,8,9000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+5',-1,305,379021000,0,0,0,0,0,0,0,200000,8,8500,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+6',-1,306,379021000,0,0,0,0,0,0,0,200000,8,6000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+7',-1,307,379021000,0,0,0,0,0,0,0,200000,8,3000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+8',-1,308,379021000,0,0,0,0,0,0,0,200000,8,1000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+9',-1,309,379021000,0,0,0,0,0,0,0,200000,8,500,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+10',-1,310,379021000,0,0,0,0,0,0,0,200000,8,10,1)

:













Kod:

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+0',-1,0,379025000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+1',-1,301,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+2',-1,302,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+3',-1,303,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+4',-1,304,379021000,0,0,0,0,0,0,0,200000,8,9000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+5',-1,305,379021000,0,0,0,0,0,0,0,200000,8,8500,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+6',-1,306,379021000,0,0,0,0,0,0,0,200000,8,6000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+7',-1,307,379021000,0,0,0,0,0,0,0,200000,8,3000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+8',-1,308,379021000,0,0,0,0,0,0,0,200000,8,1000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+9',-1,309,379021000,0,0,0,0,0,0,0,200000,8,500,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+10',-1,310,379021000,0,0,0,0,0,0,0,200000,8,10,1)















Kod:

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+0',-1,0,379025000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+1',-1,301,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+2',-1,302,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+3',-1,303,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+4',-1,304,379021000,0,0,0,0,0,0,0,200000,8,9000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+5',-1,305,379021000,0,0,0,0,0,0,0,200000,8,8500,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+6',-1,306,379021000,0,0,0,0,0,0,0,200000,8,6000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+7',-1,307,379021000,0,0,0,0,0,0,0,200000,8,3000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+8',-1,308,379021000,0,0,0,0,0,0,0,200000,8,1000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+9',-1,309,379021000,0,0,0,0,0,0,0,200000,8,500,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+10',-1,310,379021000,0,0,0,0,0,0,0,200000,8,10,1)















Kod:

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+0',-1,0,379025000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+1',-1,301,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+2',-1,302,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+3',-1,303,379021000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+4',-1,304,379021000,0,0,0,0,0,0,0,200000,8,9000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+5',-1,305,379021000,0,0,0,0,0,0,0,200000,8,8500,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+6',-1,306,379021000,0,0,0,0,0,0,0,200000,8,6000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+7',-1,307,379021000,0,0,0,0,0,0,0,200000,8,3000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+8',-1,308,379021000,0,0,0,0,0,0,0,200000,8,1000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+9',-1,309,379021000,0,0,0,0,0,0,0,200000,8,500,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+10',-1,310,379021000,0,0,0,0,0,0,0,200000,8,10,1)

### TRINA ###















:













Kod:

insert into [ITEM_UPGRADE] Values (910101,5001,'Dagger of ','+0',-1,0,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910102,5001,'Dagger of ','+1',-1,301,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910103,5001,'Dagger of ','+2',-1,302,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910104,5001,'Dagger of ','+3',-1,303,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910105,5001,'Dagger of ','+4',-1,304,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910106,5001,'Dagger of ','+5',-1,305,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910107,5001,'Dagger of ','+6',-1,306,700002000,0,0,0,0,0,0,0,200000,8,7500,1)

insert into [ITEM_UPGRADE] Values (910108,5001,'Dagger of ','+7',-1,307,700002000,0,0,0,0,0,0,0,200000,8,4500,1)

insert into [ITEM_UPGRADE] Values (910109,5001,'Dagger of ','+8',-1,308,700002000,0,0,0,0,0,0,0,200000,8,2500,1)

insert into [ITEM_UPGRADE] Values (910110,5001,'Dagger of ','+9',-1,309,700002000,0,0,0,0,0,0,0,200000,8,2000,1)

insert into [ITEM_UPGRADE] Values (910111,5001,'Dagger of ','+10',-1,310,700002000,0,0,0,0,0,0,0,200000,8,1510,1)

:













Kod:

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+0',-1,0,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+1',-1,301,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+2',-1,302,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+3',-1,303,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+4',-1,304,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+5',-1,305,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+6',-1,306,700002000,0,0,0,0,0,0,0,200000,8,7500,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+7',-1,307,700002000,0,0,0,0,0,0,0,200000,8,4500,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+8',-1,308,700002000,0,0,0,0,0,0,0,200000,8,2500,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+9',-1,309,700002000,0,0,0,0,0,0,0,200000,8,2000,1)

insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+10',-1,310,700002000,0,0,0,0,0,0,0,200000,8,1510,1)

:













Kod:

insert into [ITEM_UPGRADE] Values (920120,5001,'Shield of ','+0',-1,0,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (920120,5001,'Shield of ','+1',-1,301,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (920120,5001,'Shield of ','+2',-1,302,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (920120,5001,'Shield of ','+3',-1,303,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (920120,5001,'Shield of ','+4',-1,304,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (920120,5001,'Shield of ','+5',-1,305,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (920120,5001,'Shield of ','+6',-1,306,700002000,0,0,0,0,0,0,0,200000,8,7500,1)

insert into [ITEM_UPGRADE] Values (920120,5001,'Shield of ','+7',-1,307,700002000,0,0,0,0,0,0,0,200000,8,4500,1)

insert into [ITEM_UPGRADE] Values (920120,5001,'Shield of ','+8',-1,308,700002000,0,0,0,0,0,0,0,200000,8,2500,1)

insert into [ITEM_UPGRADE] Values (920120,5001,'Shield of ','+9',-1,309,700002000,0,0,0,0,0,0,0,200000,8,2000,1)

insert into [ITEM_UPGRADE] Values (920120,5001,'Shield of ','+10',-1,310,700002000,0,0,0,0,0,0,0,200000,8,1510,1)

:













Kod:

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+0',-1,0,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+1',-1,301,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+2',-1,302,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+3',-1,303,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+4',-1,304,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+5',-1,305,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+6',-1,306,700002000,0,0,0,0,0,0,0,200000,8,7500,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+7',-1,307,700002000,0,0,0,0,0,0,0,200000,8,4500,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+8',-1,308,700002000,0,0,0,0,0,0,0,200000,8,2500,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+9',-1,309,700002000,0,0,0,0,0,0,0,200000,8,2000,1)

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+10',-1,310,700002000,0,0,0,0,0,0,0,200000,8,1510,1)

:













Kod:

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+0',-1,0,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+1',-1,301,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+2',-1,302,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+3',-1,303,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+4',-1,304,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+5',-1,305,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+6',-1,306,700002000,0,0,0,0,0,0,0,200000,8,7500,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+7',-1,307,700002000,0,0,0,0,0,0,0,200000,8,4500,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+8',-1,308,700002000,0,0,0,0,0,0,0,200000,8,2500,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+9',-1,309,700002000,0,0,0,0,0,0,0,200000,8,2000,1)

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+10',-1,310,700002000,0,0,0,0,0,0,0,200000,8,1510,1)

:













Kod:

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+0',-1,0,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+1',-1,301,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+2',-1,302,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+3',-1,303,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+4',-1,304,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+5',-1,305,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+6',-1,306,700002000,0,0,0,0,0,0,0,200000,8,7500,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+7',-1,307,700002000,0,0,0,0,0,0,0,200000,8,4500,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+8',-1,308,700002000,0,0,0,0,0,0,0,200000,8,2500,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+9',-1,309,700002000,0,0,0,0,0,0,0,200000,8,2000,1)

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+10',-1,310,700002000,0,0,0,0,0,0,0,200000,8,1510,1)











Kod:

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+0',-1,0,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+1',-1,301,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+2',-1,302,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+3',-1,303,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+4',-1,304,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+5',-1,305,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+6',-1,306,700002000,0,0,0,0,0,0,0,200000,8,7500,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+7',-1,307,700002000,0,0,0,0,0,0,0,200000,8,4500,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+8',-1,308,700002000,0,0,0,0,0,0,0,200000,8,2500,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+9',-1,309,700002000,0,0,0,0,0,0,0,200000,8,2000,1)

insert into [ITEM_UPGRADE] Values (910122,5001,'Bow of ','+10',-1,310,700002000,0,0,0,0,0,0,0,200000,8,1510,1)











Kod:

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+0',-1,0,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+1',-1,301,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+2',-1,302,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+3',-1,303,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+4',-1,304,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+5',-1,305,700002000,0,0,0,0,0,0,0,200000,8,10000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+6',-1,306,700002000,0,0,0,0,0,0,0,200000,8,7500,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+7',-1,307,700002000,0,0,0,0,0,0,0,200000,8,4500,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+8',-1,308,700002000,0,0,0,0,0,0,0,200000,8,2500,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+9',-1,309,700002000,0,0,0,0,0,0,0,200000,8,2000,1)

insert into [ITEM_UPGRADE] Values (910121,5001,'Spear of ','+10',-1,310,700002000,0,0,0,0,0,0,0,200000,8,1510,1)









Kullanımı ...








1 Başlat > Tüm Programlar > Microsoft SQL Server > Query Analyzer ‘ a giriyoruz.



2 SQL Server’ a bağlanıyoruz ve açılan ekranda ” master ” yerine ” DBmizi ” seçiyoruz.



3 Seçtikten sonra aşağıdaki kodu kopyalayıp , yapıştırıyoruz ve F5 yaparak kodumuzu uyguluyoruz.
 
Üst