1299 Damage Ayarlama Skiller


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

Alıntı

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.

Hakkında alpa2011
www.extra.forum7.biz admini

Bir Cevap Yazın

Aşağıya bilgilerinizi girin veya oturum açmak için bir simgeye tıklayın:

WordPress.com Logosu

WordPress.com hesabınızı kullanarak yorum yapıyorsunuz. Log Out / Değiştir )

Twitter resmi

Twitter hesabınızı kullanarak yorum yapıyorsunuz. Log Out / Değiştir )

Facebook fotoğrafı

Facebook hesabınızı kullanarak yorum yapıyorsunuz. Log Out / Değiştir )

Google+ fotoğrafı

Google+ hesabınızı kullanarak yorum yapıyorsunuz. Log Out / Değiştir )

Connecting to %s

%d blogcu bunu beğendi: