Merhaba Arkadaşlar,







Bugün öğleden beri bu kodlar ile uğraşmaktayım. sonunda sorunsuz ve tüm skilleri çalıştırabildim.







NOT : Bütün skilleri denedim hepsi sorunsuz çalışmaktadır. 30K bug yoktur. Fakat damage'leri deneyip söylerseniz sevinirim. Archer pek fazla oynamadığım için hangi skilin daha fazla damage vermesi gerektiğini bilmiyorum. Oyunda ki açıklamalardan yola çıkarak damage'leri verdim.







İlk önce MAGIC_TYPE2 tablosunu temizleyelim.







QA'da









Kod:

TRUNCATE TABLE MAGIC_TYPE2

yazıp F5 yapalım.







Daha sonra aşağıda ki kodları QA'ya yapıştırıp çalıştırın.









Kod:

INSERT INTO MAGIC_TYPE2 VALUES(107003,'Archery','Shoot an arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107500,'Through Shot','Inflict 150% damage to an enemy.',0,100,150,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107505,'Fire Arrow','Shoot Fire Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107510,'Poison Arrow','Shoot Poison Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107515,'Multiple Shot','Shoot 3 arrows at once',0,100,99,100,3,1)

INSERT INTO MAGIC_TYPE2 VALUES(107520,'Guided Arrow','Arrow with 100% shot rate',2,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107525,'Perfect Shot','Inflict 200% damage to an enemy',0,100,200,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107530,'Fire Shot','An increased damage on fire based arrow attack',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107535,'Poison Shot','An increased damage on poison based arrow attack',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107540,'Arc Shot','Inflict 250% damage to an enemy',0,100,250,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107545,'Explosive Shot','Strongest Fire Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107550,'Viper','Strongest Poison Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107552,'Counter Strike','Arrow attack that inflicts a great amount of damage.',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107555,'Arrow Shower','Shoot 5 arrows at once',0,100,99,100,5,1)

INSERT INTO MAGIC_TYPE2 VALUES(107557,'Shadow Shot','100% accurate arrow with 200% damage',2,100,200,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(107560,'Shadow Hunter','100% accurate arrow with 250% damage',2,100,250,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108003,'Archery','Shoot an arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108500,'Through Shot','Inflict 150% damage to an enemy.',0,100,150,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108505,'Fire Arrow','Shoot Fire Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108510,'Poison Arrow','Shoot Poison Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108515,'Multiple Shot','Shoot 3 arrows at once',0,100,99,100,3,1)

INSERT INTO MAGIC_TYPE2 VALUES(108520,'Guided Arrow','Arrow with 100% shot rate',2,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108525,'Perfect Shot','Inflict 200% damage to an enemy',0,100,200,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108530,'Fire Shot','An increased damage on fire based arrow attack',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108535,'Poison Shot','An increased damage on poison based arrow attack',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108540,'Arc Shot','Inflict 250% damage to an enemy',0,100,250,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108545,'Explosive Shot','Strongest Fire Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108550,'Viper','Strongest Poison Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108552,'Counter Strike','Arrow attack that inflicts a great amount of damage.',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108555,'Arrow Shower','Shoot 5 arrows at once',0,100,99,100,5,1)

INSERT INTO MAGIC_TYPE2 VALUES(108557,'Shadow Shot','100% accurate arrow with 200% damage',2,100,200,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108560,'Shadow Hunter','100% accurate arrow with 250% damage',2,100,250,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108562,'Ice Shot','Inflicts 300% damage and has a chance to slow down the enemy.',0,100,300,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108566,'Lightning Shot','Inflicts 300% damage and stuns for 3 seconds',0,100,300,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108570,'Dark Pursuer','100% accurate arrow with 250% damage',2,100,250,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108575,'Blow Arrow','While moving, stab an enemy with an arrow to inflict 200% damage',0,100,200,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108580,'Blinding Strafe','Shoots an arrow that inflicts 400% damage and blinds the enemy. Does not apply to monsters.',2,80,400,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(108585,'Power Shot','Shoots an arrow that inflicts a great amount of damage.',2,80,500,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207003,'Archery','Shoot an arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207500,'Through Shot','Inflict 150% damage to an enemy.',0,100,150,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207505,'Fire Arrow','Shoot Fire Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207510,'Poison Arrow','Shoot Poison Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207515,'Multiple Shot','Shoot 3 arrows at once',0,100,99,100,3,1)

INSERT INTO MAGIC_TYPE2 VALUES(207520,'Guided Arrow','Arrow with 100% shot rate',2,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207525,'Perfect Shot','Inflict 200% damage to an enemy',0,100,200,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207530,'Fire Shot','An increased damage on fire based arrow attack',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207535,'Poison Shot','An increased damage on poison based arrow attack',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207540,'Arc Shot','Inflict 250% damage to an enemy',0,100,250,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207545,'Explosive Shot','Strongest Fire Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207550,'Viper','Strongest Poison Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207552,'Counter Strike','Arrow attack that inflicts a great amount of damage.',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207555,'Arrow Shower','Shoot 5 arrows at once',0,100,99,100,5,1)

INSERT INTO MAGIC_TYPE2 VALUES(207557,'Shadow Shot','100% accurate arrow with 200% damage',2,100,200,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(207560,'Shadow Hunter','100% accurate arrow with 250% damage',2,100,250,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208003,'Archery','Shoot an arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208500,'Through Shot','Inflict 150% damage to an enemy.',0,100,150,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208505,'Fire Arrow','Shoot Fire Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208510,'Poison Arrow','Shoot Poison Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208515,'Multiple Shot','Shoot 3 arrows at once',0,100,99,100,3,1)

INSERT INTO MAGIC_TYPE2 VALUES(208520,'Guided Arrow','Arrow with 100% shot rate',2,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208525,'Perfect Shot','Inflict 200% damage to an enemy',0,100,200,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208530,'Fire Shot','An increased damage on fire based arrow attack',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208535,'Poison Shot','An increased damage on poison based arrow attack',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208540,'Arc Shot','Inflict 250% damage to an enemy',0,100,250,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208545,'Explosive Shot','Strongest Fire Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208550,'Viper','Strongest Poison Arrow',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208552,'Counter Strike','Arrow attack that inflicts a great amount of damage.',0,100,100,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208555,'Arrow Shower','Shoot 5 arrows at once',0,100,99,100,5,1)

INSERT INTO MAGIC_TYPE2 VALUES(208557,'Shadow Shot','100% accurate arrow with 200% damage',2,100,200,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208560,'Shadow Hunter','100% accurate arrow with 250% damage',2,100,250,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208562,'Ice Shot','Inflicts 300% damage and has a chance to slow down the enemy.',0,100,300,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208566,'Lightning Shot','Inflicts 300% damage and stuns for 3 seconds',0,100,300,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208570,'Dark Pursuer','100% accurate arrow with 250% damage',2,100,250,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208575,'Blow Arrow','While moving, stab an enemy with an arrow to inflict 200% damage',0,100,200,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208580,'Blinding Strafe','Shoots an arrow that inflicts 400% damage and blinds the enemy. Does not apply to monsters.',2,80,400,100,1,1)

INSERT INTO MAGIC_TYPE2 VALUES(208585,'Power Shot','Shoots an arrow that inflicts a great amount of damage.',2,80,500,100,1,1)

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.







İşlem Tamamdır Ve Alıntıdır