- Katılım
- 12 Mart 2012
- Mesajlar
- 1,081
- Konu Yazar
- #1
MERHABA ARKADASLAR SORUNSUZ OKCU SKİLLERİNİ DATABASEYE EKLEDİM KOPK TBL GÖMDÜM AMA YİNEDE CALISMIYOR YARDIMLARINIZI BEKLİYORUM RESİMDE GÖRDÜGÜNÜZ GİBİ
KULLANDIGIM SQL KODLARI
truncate table magic_type2
go
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('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('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('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('108580','Blinding Strafe ','Shoots an arrow that inflicts 400% damage and blinds the enemy. Does not apply to monsters. ','2','80','650','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','650','100','1','1')
INSERT INTO MAGIC_TYPE2 VALUES('108585','Power Shot ','Shoots an arrow that inflicts a great amount of damage. ','2','80','1300','100','1','1')
INSERT INTO MAGIC_TYPE2 VALUES('208585','Power Shot ','Shoots an arrow that inflicts a great amount of damage. ','2','80','1300','100','1','1')
KULLANDIGIM SQL KODLARI

truncate table magic_type2
go
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('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('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('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('108580','Blinding Strafe ','Shoots an arrow that inflicts 400% damage and blinds the enemy. Does not apply to monsters. ','2','80','650','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','650','100','1','1')
INSERT INTO MAGIC_TYPE2 VALUES('108585','Power Shot ','Shoots an arrow that inflicts a great amount of damage. ','2','80','1300','100','1','1')
INSERT INTO MAGIC_TYPE2 VALUES('208585','Power Shot ','Shoots an arrow that inflicts a great amount of damage. ','2','80','1300','100','1','1')
Ekli dosyalar
Moderatör tarafında düzenlendi: