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.