1705 İtemlerini +70 Yapmak Veya İstediğiniz LvL







Zor Serverlere Yardımcı Olacığını Düşündüm..









Kod:

Update Item Set ReqLevel = '70' WHERE strname like '%Gabs Blessing%'



Update Item Set ReqLevel = '70' WHERE strname like '%Nonflammable Shield% '



Update Item Set ReqLevel = '70' WHERE strname like '%Death Wing Bow%'



Update Item Set ReqLevel = '70' WHERE strname like '%Kentaraus Face%'



Update Item Set ReqLevel = '70' WHERE strname like '%Cut Snake Tail%'



Update Item Set ReqLevel = '70' WHERE strname like '%Wirinom%'



Update Item Set ReqLevel = '70' WHERE strname like '%Nebiros%'



Update Item Set ReqLevel = '70' WHERE strname like '%Nameless White Cherry Blossom%'



Update Item Set ReqLevel = '70' WHERE strname like '%Double Possession%'



Update Item Set ReqLevel = '70' WHERE strname like '%Monks Staff of Destruction%'



Update Item Set ReqLevel = '70' WHERE strname like '%Secular Fan%'



Update Item Set ReqLevel = '70' WHERE strname like '%Leonar%'



Update Item Set ReqLevel = '70' WHERE strname like '%Baal%'



Update Item Set ReqLevel = '70' WHERE strname like '%Raum%'



Update Item Set ReqLevel = '70' WHERE strname like '%Windforce%'



Update Item Set ReqLevel = '70' WHERE strname like '%Faun%'



Update Item Set ReqLevel = '70' WHERE strname like '%Molok%'



Update Item Set ReqLevel = '70' WHERE strname like '%Fulitol%'



Alıntı:









orada koreako itemleri de var zor serverda koreako itemlerinin ne işi var











Kod:

Update Item Set ReqLevel ='70' Where strName Like '%%'

Update Item Set ReqLevel ='70' Where strName Like '%Gabs%'

Update Item Set ReqLevel ='70' Where strName Like '%Wirinom%'

Update Item Set ReqLevel ='70' Where strName Like '%Nebiros%'

Update Item Set ReqLevel ='70' Where strName Like '%Leonard%'

Update Item Set ReqLevel ='70' Where strName Like '%Baal%'

Update Item Set ReqLevel ='70' Where strName Like '%Raum%'

Update Item Set ReqLevel ='70' Where strName Like '%Windforce%'

Update Item Set ReqLevel ='70' Where strName Like '%Faun%'

Update Item Set ReqLevel ='70' Where strName Like '%Molok%'

Update Item Set ReqLevel ='70' Where strName Like '%Fulitol%'



Kod:

Update Item Set ReqLevel ='60' Where strName Like '%Chitin Shell%'

Update Item Set ReqLevel ='60' Where strName Like '%Complete%'













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.