Selamlar Güzel Bir Paylaşımdır
-------HeLL blade warior 80--------
UPDATE MAGIC_TYPE1
SET Hit =400
WHERE (iNum = 106580)
UPDATE MAGIC_TYPE1
SET Hit =400
WHERE (iNum = 206580)
UPDATE MAGIC_TYPE1
SET AddDamage =400
WHERE (iNum = 106580)
UPDATE MAGIC_TYPE1
SET AddDamage =400
WHERE (iNum = 206580)
------Holwing Sword Warrior 70----
UPDATE MAGIC_TYPE1
SET Hit =350 , AddDamage =350
WHERE (iNum = 106570)
UPDATE MAGIC_TYPE1
SET Hit =350 , AddDamage =350
WHERE (iNum = 206570)
------Sword Dancing warrior 60----
UPDATE MAGIC_TYPE1
SET Hit =300 , AddDamage =300
WHERE (iNum = 105560)
UPDATE MAGIC_TYPE1
SET Hit =300 , AddDamage =300
WHERE (iNum = 106560)
UPDATE MAGIC_TYPE1
SET AddDamage =300 , Hit =300
WHERE (iNum = 205560)
UPDATE MAGIC_TYPE1
SET AddDamage =300 , Hit =300
WHERE (iNum = 206560)
----------Spike Binding 72(seri Olmasını Onler)--------
UPDATE MAGIC
SET Recasttime = 255
WHERE (magicnum = 208675)
----------Spike Rogue 55--------
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 108655)
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 107655)
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 207655)
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 208655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 108655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 107655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 207655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 208655)
----------Thrust Rogue 35---------
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 108635)
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 107635)
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 207635)
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 208635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 108635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 107635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 207635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 208635)
----------Pierce Rogue 15---------
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 108615)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 107615)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 207615)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 208615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 108615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 107615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 207615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 208615)
----------Stab Rogue 5---------
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 108005)
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 107005)
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 207005)
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 208005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 108005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 107005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 207005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 208005)
----------CuT Rogue 40---------
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 108640)
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 107640)
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 207640)
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 208640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 108640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 107640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 207640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 208640)
-------------Rogue 70---------
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 108670)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 208670)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 108670)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 208670)
----------Critical Rogue 80---------
UPDATE MAGIC_TYPE4
SET Dex =600
WHERE (iNum = 208685)
UPDATE MAGIC_TYPE4
SET Dex =600
WHERE (iNum = 108685)
----------Critical Rogue 80(180 saniyede Basılabilr)---------
UPDATE MAGIC
SET recasttime =255
WHERE (magicnum = 208685)
UPDATE MAGIC
SET recasttime =255
WHERE (magicnum = 108685)
----------Archery Rogue 55 (5Li Ok) ATamayacak---------
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 207555)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 208555)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 107555)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 108555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 108555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 107555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 208555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 207555)
----------Archery Rogue 55 (3Lü Ok) ATamayacak---------
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 207515)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 208515)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 107515)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 108515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 207515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 208515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 107515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 108515)
----------Priest 72 Skill ---------
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 111551)
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 212551)
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 211551)
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 112551)
kısa yoldan şöyle Yapalım
Kod:
update MAGIC_TYPE1 set Hit = '400', AddDamage = '400'
where Name = 'Hell Blade'
update MAGIC_TYPE1 set Hit = '350', AddDamage = '350'
where Name = (select EnName from MAGIC where EnName = 'Howling Sword')
update MAGIC_TYPE1 set Hit = '300', AddDamage = '300'
where Name = (select EnName from MAGIC where EnName = 'Sword Dancing')
update MAGIC_TYPE1 set Hit = '900' where Name = 'Spike' and Description LIKE '%600%'
update MAGIC_TYPE1 set Hit = '600' where Name = 'Thrust'
update MAGIC_TYPE1 set Hit = '400' where Name = 'Pierce'
update MAGIC_TYPE1 set hit = '200' where Name = 'Stab'
update MAGIC_TYPE1 set Hit = '250' where name = 'Cut'
update MAGIC_TYPE1 set Hit = '700' where Name = (select EnName from MAGIC where EnName = 'Bloody Beast')
UPDATE MAGIC_TYPE4
SET Dex =200
WHERE iNum = '208685' or iNum = '108685'
update MAGIC_TYPE1 set Hit = '250', AddDamage = '250'
where Name = (select EnName from MAGIC where ENName = 'Helis')
Asas Damageleri Çok Abartılı idi Düzeltme Yaptım. Bunları Kullanırsanız Sorunsuz Eşitlik Sağlanır.
Alıntı:
Walkry ile 2600 Defans Neden Olsun Fixlenmicekmi O Artık Walkry ile 2600 defanslı server olursa o iş yapmaz
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.
-------HeLL blade warior 80--------
UPDATE MAGIC_TYPE1
SET Hit =400
WHERE (iNum = 106580)
UPDATE MAGIC_TYPE1
SET Hit =400
WHERE (iNum = 206580)
UPDATE MAGIC_TYPE1
SET AddDamage =400
WHERE (iNum = 106580)
UPDATE MAGIC_TYPE1
SET AddDamage =400
WHERE (iNum = 206580)
------Holwing Sword Warrior 70----
UPDATE MAGIC_TYPE1
SET Hit =350 , AddDamage =350
WHERE (iNum = 106570)
UPDATE MAGIC_TYPE1
SET Hit =350 , AddDamage =350
WHERE (iNum = 206570)
------Sword Dancing warrior 60----
UPDATE MAGIC_TYPE1
SET Hit =300 , AddDamage =300
WHERE (iNum = 105560)
UPDATE MAGIC_TYPE1
SET Hit =300 , AddDamage =300
WHERE (iNum = 106560)
UPDATE MAGIC_TYPE1
SET AddDamage =300 , Hit =300
WHERE (iNum = 205560)
UPDATE MAGIC_TYPE1
SET AddDamage =300 , Hit =300
WHERE (iNum = 206560)
----------Spike Binding 72(seri Olmasını Onler)--------
UPDATE MAGIC
SET Recasttime = 255
WHERE (magicnum = 208675)
----------Spike Rogue 55--------
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 108655)
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 107655)
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 207655)
UPDATE MAGIC_TYPE1
SET Hit =1100
WHERE (iNum = 208655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 108655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 107655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 207655)
UPDATE MAGIC_TYPE1
SET AddDamage =1100
WHERE (iNum = 208655)
----------Thrust Rogue 35---------
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 108635)
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 107635)
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 207635)
UPDATE MAGIC_TYPE1
SET Hit =800
WHERE (iNum = 208635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 108635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 107635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 207635)
UPDATE MAGIC_TYPE1
SET AddDamage =800
WHERE (iNum = 208635)
----------Pierce Rogue 15---------
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 108615)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 107615)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 207615)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 208615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 108615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 107615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 207615)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 208615)
----------Stab Rogue 5---------
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 108005)
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 107005)
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 207005)
UPDATE MAGIC_TYPE1
SET Hit =300
WHERE (iNum = 208005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 108005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 107005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 207005)
UPDATE MAGIC_TYPE1
SET AddDamage =300
WHERE (iNum = 208005)
----------CuT Rogue 40---------
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 108640)
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 107640)
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 207640)
UPDATE MAGIC_TYPE1
SET Hit =350
WHERE (iNum = 208640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 108640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 107640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 207640)
UPDATE MAGIC_TYPE1
SET AddDamage =350
WHERE (iNum = 208640)
-------------Rogue 70---------
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 108670)
UPDATE MAGIC_TYPE1
SET Hit =700
WHERE (iNum = 208670)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 108670)
UPDATE MAGIC_TYPE1
SET AddDamage =700
WHERE (iNum = 208670)
----------Critical Rogue 80---------
UPDATE MAGIC_TYPE4
SET Dex =600
WHERE (iNum = 208685)
UPDATE MAGIC_TYPE4
SET Dex =600
WHERE (iNum = 108685)
----------Critical Rogue 80(180 saniyede Basılabilr)---------
UPDATE MAGIC
SET recasttime =255
WHERE (magicnum = 208685)
UPDATE MAGIC
SET recasttime =255
WHERE (magicnum = 108685)
----------Archery Rogue 55 (5Li Ok) ATamayacak---------
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 207555)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 208555)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 107555)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 108555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 108555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 107555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 208555)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 207555)
----------Archery Rogue 55 (3Lü Ok) ATamayacak---------
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 207515)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 208515)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 107515)
UPDATE MAGIC_TYPE2
SET NeedArrow =255, Hitrate =0 , adddamage=0 , adddamageplus =0 , addrange=0
WHERE (iNum = 108515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 207515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 208515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 107515)
UPDATE MAGIC
SET Recasttime = 250
WHERE (magicnum = 108515)
----------Priest 72 Skill ---------
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 111551)
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 212551)
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 211551)
UPDATE MAGIC_TYPE1
SET Hit =500 , adddamage =500
WHERE (iNum = 112551)
kısa yoldan şöyle Yapalım
Kod:
update MAGIC_TYPE1 set Hit = '400', AddDamage = '400'
where Name = 'Hell Blade'
update MAGIC_TYPE1 set Hit = '350', AddDamage = '350'
where Name = (select EnName from MAGIC where EnName = 'Howling Sword')
update MAGIC_TYPE1 set Hit = '300', AddDamage = '300'
where Name = (select EnName from MAGIC where EnName = 'Sword Dancing')
update MAGIC_TYPE1 set Hit = '900' where Name = 'Spike' and Description LIKE '%600%'
update MAGIC_TYPE1 set Hit = '600' where Name = 'Thrust'
update MAGIC_TYPE1 set Hit = '400' where Name = 'Pierce'
update MAGIC_TYPE1 set hit = '200' where Name = 'Stab'
update MAGIC_TYPE1 set Hit = '250' where name = 'Cut'
update MAGIC_TYPE1 set Hit = '700' where Name = (select EnName from MAGIC where EnName = 'Bloody Beast')
UPDATE MAGIC_TYPE4
SET Dex =200
WHERE iNum = '208685' or iNum = '108685'
update MAGIC_TYPE1 set Hit = '250', AddDamage = '250'
where Name = (select EnName from MAGIC where ENName = 'Helis')
Asas Damageleri Çok Abartılı idi Düzeltme Yaptım. Bunları Kullanırsanız Sorunsuz Eşitlik Sağlanır.
Alıntı:
Walkry ile 2600 Defans Neden Olsun Fixlenmicekmi O Artık Walkry ile 2600 defanslı server olursa o iş yapmaz
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.