70 Level İtemlerinin Trina ve Trinasız Upgrade Edilmesi

Merhaba,

1299 Private Serverlarda,
çoğunlukla 70 LeveL Quest itemleri upgrade edilmiyor ve direk +10
olarak veriliyordu. Arşivime almış olduğum Kodlar arasında 70 LeveL
Quest itemlerinin Upgrade edilmeside mevcuttu. 1 - 2 foruma baktım
paylaşılmamış bende paylaşayım dedim.. Yapımcısı: DeathsEffigy'dir..

Bu Kodlar ile Trina ve Trinasız Upgrade Edilecek İtemler;

Shield of Selfname

Dagger of Selfname

Sword of Selfname

Mace of Selfname

Pole of Selfname

Staff of Selfname

Bow of Selfname

Spear of Selfname

Kullanım:

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

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

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

70 LeveL Quest İtemlerini Siliyoruz;

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

Shield of Selfname'in Upgrade'inde Çift İsim Yazmasını Fixlemek için;

Kod:: --70 LeveL Quest İtemlerin Upgrade Edilmesi
--http://pvpserverler.forumclan.com'da HolyDewy Tarafından Yayımlanmıştır..
--Yapımcısı: DeathsEffigy

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,
[center] 0,0,0,0,0,0,4,10,10,10,10,0,0,0,20,20,20,0,0,0)[/center]

TRİNA'SIZ UPGRADE İÇİN

Trina'sız Dagger of Selfname

Kod:: --70 LeveL Quest İtemlerin Upgrade Edilmesi
--http://pvpserverler.forumclan.com'da HolyDewy Tarafından Yayımlanmıştır..
--Yapımcısı: DeathsEffigy

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)

Trina'sız Sword Of Selfname
--70 LeveL Quest İtemlerin Upgrade Edilmesi
--http://pvpserverler.forumclan.com'da HolyDewy Tarafından Yayımlanmıştır..
--Yapımcısı: DeathsEffigy

Kod:: insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+0',-1,350,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+1',-1,351,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+2',-1,352,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+3',-1,353,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+4',-1,354,379021000,0,0,0,0,0,0,0,200000,8,9000,1)
insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+5',-1,355,379021000,0,0,0,0,0,0,0,200000,8,8500,1)
insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+6',-1,356,379021000,0,0,0,0,0,0,0,200000,8,6000,1)
insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+7',-1,357,379021000,0,0,0,0,0,0,0,200000,8,3000,1)
insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+8',-1,358,379021000,0,0,0,0,0,0,0,200000,8,1000,1)
insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+9',-1,359,379021000,0,0,0,0,0,0,0,200000,8,500,1)
insert into [ITEM_UPGRADE] Values (910126,5001,'Sword of ','+10',-1,360,379021000,0,0,0,0,0,0,0,200000,8,10,1)Trina'sız Shield Of Selfname

Kod:: --70 LeveL Quest İtemlerin Upgrade Edilmesi
--http://pvpserverler.forumclan.com'da HolyDewy Tarafından Yayımlanmıştır..
--Yapımcısı: DeathsEffigy

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)

Trina'sız Mace Of Selfname

Kod:: --70 LeveL Quest İtemlerin Upgrade Edilmesi
--http://pvpserverler.forumclan.com'da HolyDewy Tarafından Yayımlanmıştır..
--Yapımcısı: DeathsEffigy

insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+0',-1,324,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+1',-1,371,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+2',-1,372,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+3',-1,373,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+4',-1,374,379021000,0,0,0,0,0,0,0,200000,8,9000,1)
insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+5',-1,375,379021000,0,0,0,0,0,0,0,200000,8,8500,1)
insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+6',-1,376,379021000,0,0,0,0,0,0,0,200000,8,6000,1)
insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+7',-1,377,379021000,0,0,0,0,0,0,0,200000,8,3000,1)
insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+8',-1,378,379021000,0,0,0,0,0,0,0,200000,8,1000,1)
insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+9',-1,379,379021000,0,0,0,0,0,0,0,200000,8,500,1)
insert into [ITEM_UPGRADE] Values (910125,5001,'Mace of ','+10',-1,380,379021000,0,0,0,0,0,0,0,200000,8,10,1)

Trina'sız Pole of Selfname

Kod:: --70 LeveL Quest İtemlerin Upgrade Edilmesi
--http://pvpserverler.forumclan.com'da HolyDewy Tarafından Yayımlanmıştır..
--Yapımcısı: DeathsEffigy

insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+0',-1,351,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+1',-1,581,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+2',-1,582,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+3',-1,583,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+4',-1,584,379021000,0,0,0,0,0,0,0,200000,8,9000,1)
insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+5',-1,585,379021000,0,0,0,0,0,0,0,200000,8,8500,1)
insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+6',-1,586,379021000,0,0,0,0,0,0,0,200000,8,6000,1)
insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+7',-1,587,379021000,0,0,0,0,0,0,0,200000,8,3000,1)
insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+8',-1,588,379021000,0,0,0,0,0,0,0,200000,8,1000,1)
insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+9',-1,589,379021000,0,0,0,0,0,0,0,200000,8,500,1)
insert into [ITEM_UPGRADE] Values (910124,5001,'Pole of ','+10',-1,590,379021000,0,0,0,0,0,0,0,200000,8,10,1)

Trina'sız Staff of Selfname

Kod:: --70 LeveL Quest İtemlerin Upgrade Edilmesi
--http://pvpserverler.forumclan.com'da HolyDewy Tarafından Yayımlanmıştır..
--Yapımcısı: DeathsEffigy

insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+0',-1,355,379025000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+1',-1,571,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+2',-1,572,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+3',-1,573,379021000,0,0,0,0,0,0,0,200000,8,10000,1)
insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+4',-1,574,379021000,0,0,0,0,0,0,0,200000,8,9000,1)
insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+5',-1,575,379021000,0,0,0,0,0,0,0,200000,8,8500,1)
insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+6',-1,576,379021000,0,0,0,0,0,0,0,200000,8,6000,1)
insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+7',-1,577,379021000,0,0,0,0,0,0,0,200000,8,3000,1)
insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+8',-1,578,379021000,0,0,0,0,0,0,0,200000,8,1000,1)
insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+9',-1,579,379021000,0,0,0,0,0,0,0,200000,8,500,1)
insert into [ITEM_UPGRADE] Values (910123,5001,'Staff of ','+10',-1,580,379021000,0,0,0,0,0,0,0,200000,8,10,1)

» LEVEL 50 GÖREVİ###(ELMORAD/KARUS)
» [PAYLAŞIM]### Orjinal MyKO Database ### Level Sınır 70 ###