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.
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.