Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Archery Skills Fix Level 1~70

Experienced Elementalist
Joined
Jan 3, 2008
Messages
299
Reaction score
1
1. Put this into your Query Analyzer and hit execute, just to remove any hint of editting you tried to do but failed to do.

Code:
delete from magic where type1='2'
truncate table magic_type2
delete from magic_type3 where inum='108566'
delete from magic_type3 where inum='208566'
delete from magic_type4 where inum='108562'
delete from magic_type4 where inum='208562'

2. Then, erase that, and put this into your Query Analyzer and hit execute.

Code:
insert into magic values ( 102003, 'Archery', 'Archery', 'Shoot an arrow', 0, 0, 0, 1, 551, 7, 3, 1020, 0, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 107003, 'Archery', 'Archery', 'Shoot an arrow', 0, 0, 0, 1, 551, 7, 3, 1070, 0, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 107500, 'Through Shot', 'Through Shot', 'Inflict 150% damage', 0, 0, 0, 1, 551, 7, 0, 1075, 15, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 107505, 'Fire Arrow', 'Fire Arrow', 'Shoot flame arrows', 0, 0, 0, 1, 101, 7, 5, 1075, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 107510, 'Poison Arrow', 'Poison Arrow', 'Shoot poison arrows', 0, 0, 0, 1, 801, 7, 10, 1075, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 107515, 'Multiple Shot', 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 0, 0, 1, 801, 7, 15, 1075, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 107520, 'Guided Arrow', 'Guided Arrow', '100% accurate arrow', 0, 0, 0, 1, 550, 7, 20, 1075, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 107525, 'Perfect Shot', 'Perfect Shot', 'Inflict 200% damage', 0, 0, 0, 1, 551, 7, 25, 1075, 70, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 107530, 'Fire Shot', 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 0, 0, 1, 101, 7, 30, 1075, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 107535, 'Poison Shot', 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 0, 0, 1, 801, 7, 35, 1075, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 107540, 'Arc Shot', 'Arc Shot', 'Inflict 250% damage', 0, 0, 0, 1, 551, 7, 40, 1075, 100, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 107545, 'Explosive Shot', 'Explosive Shot', 'The Strongest Fire Arrow', 0, 0, 0, 1, 148, 7, 45, 1075, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 107550, 'Viper', 'Viper', 'The Strongest Poison Arrow', 0, 0, 0, 1, 157, 7, 50, 1075, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 107555, 'Arrow Shower', 'Arrow Shower', 'Shoot 5 arrows simulataneously', 0, 0, 0, 1, 801, 7, 55, 1075, 150, 0, 7, 391010000, 15, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 107557, 'Shadow Shot', 'Shadow Shot', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 57, 1075, 200, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 107560, 'Shadow Hunter', 'Shadow Hunter', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 60, 1075, 250, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 108003, 'Archery', 'Archery', 'Shoot an arrow', 0, 0, 0, 1, 551, 7, 3, 1080, 0, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 108500, 'Through Shot', 'Through Shot', 'Inflict 150% damage', 0, 0, 0, 1, 551, 7, 0, 1085, 15, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 108505, 'Fire Arrow', 'Fire Arrow', 'Shoot flame arrows', 0, 0, 0, 1, 101, 7, 5, 1085, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 108510, 'Poison Arrow', 'Poison Arrow', 'Shoot poison arrows', 0, 0, 0, 1, 801, 7, 10, 1085, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 108515, 'Multiple Shot', 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 0, 0, 1, 801, 7, 15, 1085, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 108520, 'Guided Arrow', 'Guided Arrow', '100% accurate arrow', 0, 0, 0, 1, 550, 7, 20, 1085, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 108525, 'Perfect Shot', 'Perfect Shot', 'Inflict 200% damage', 0, 0, 0, 1, 551, 7, 25, 1085, 70, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 108530, 'Fire Shot', 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 0, 0, 1, 101, 7, 30, 1085, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 108535, 'Poison Shot', 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 0, 0, 1, 801, 7, 35, 1085, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 108540, 'Arc Shot', 'Arc Shot', 'Inflict 250% damage', 0, 0, 0, 1, 551, 7, 40, 1085, 100, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 108545, 'Explosive Shot', 'Explosive Shot', 'The Strongest Fire Arrow', 0, 0, 0, 1, 148, 7, 45, 1085, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 108550, 'Viper', 'Viper', 'The Strongest Poison Arrow', 0, 0, 0, 1, 157, 7, 50, 1085, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 108555, 'Arrow Shower', 'Arrow Shower', 'Shoot 5 arrows simulataneously', 0, 0, 0, 1, 801, 7, 55, 1085, 150, 0, 7, 391010000, 15, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 108557, 'Shadow Shot', 'Shadow Shot', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 57, 1085, 200, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 108560, 'Shadow Hunter', 'Shadow Hunter', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 60, 1085, 250, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 108562, 'Ice Shot', 'Ice Shot', 'Inflicts 300% damage and has a chance to slow down the enemy', 0, 0, 0, 1, 145, 7, 62, 1085, 300, 0, 7, 391010000, 13, 60, 100, 2, 4, 0, 0, 0 )
insert into magic values ( 108566, 'Lightning Shot', 'Lightning Shot', 'Inflicts 300% damage and stuns for 3 seconds', 0, 0, 0, 1, 154, 7, 66, 1085, 300, 0, 7, 391010000, 13, 60, 100, 2, 0, 3, 0, 0 )
insert into magic values ( 108570, 'Dark Pursuer', 'Dark Pursuer', '100% accurate arrow with 350% damage', 0, 0, 0, 1, 550, 7, 70, 1085, 300, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 202003, 'Archery', 'Archery', 'Shoot an arrow', 0, 0, 0, 1, 551, 7, 3, 2020, 0, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 207003, 'Archery', 'Archery', 'Shoot an arrow', 0, 0, 0, 1, 551, 7, 3, 2070, 0, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 207500, 'Through Shot', 'Through Shot', 'Inflict 150% damage', 0, 0, 0, 1, 551, 7, 0, 2075, 15, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 207505, 'Fire Arrow', 'Fire Arrow', 'Shoot flame arrows', 0, 0, 0, 1, 101, 7, 5, 2075, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 207510, 'Poison Arrow', 'Poison Arrow', 'Shoot poison arrows', 0, 0, 0, 1, 801, 7, 10, 2075, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 207515, 'Multiple Shot', 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 0, 0, 1, 801, 7, 15, 2075, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 207520, 'Guided Arrow', 'Guided Arrow', '100% accurate arrow', 0, 0, 0, 1, 550, 7, 20, 2075, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 207525, 'Perfect Shot', 'Perfect Shot', 'Inflict 200% damage', 0, 0, 0, 1, 551, 7, 25, 2075, 70, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 207530, 'Fire Shot', 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 0, 0, 1, 101, 7, 30, 2075, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 207535, 'Poison Shot', 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 0, 0, 1, 801, 7, 35, 2075, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 207540, 'Arc Shot', 'Arc Shot', 'Inflict 250% damage', 0, 0, 0, 1, 551, 7, 40, 2075, 100, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 207545, 'Explosive Shot', 'Explosive Shot', 'The Strongest Fire Arrow', 0, 0, 0, 1, 148, 7, 45, 2075, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 207550, 'Viper', 'Viper', 'The Strongest Poison Arrow', 0, 0, 0, 1, 157, 7, 50, 2075, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 207555, 'Arrow Shower', 'Arrow Shower', 'Shoot 5 arrows simulataneously', 0, 0, 0, 1, 801, 7, 55, 2075, 150, 0, 7, 391010000, 15, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 207557, 'Shadow Shot', 'Shadow Shot', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 57, 2075, 200, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 207560, 'Shadow Hunter', 'Shadow Hunter', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 60, 2075, 250, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 208003, 'Archery', 'Archery', 'Shoot an arrow', 0, 0, 0, 1, 551, 7, 3, 2080, 0, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 208500, 'Through Shot', 'Through Shot', 'Inflict 150% damage', 0, 0, 0, 1, 551, 7, 0, 2085, 15, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 208505, 'Fire Arrow', 'Fire Arrow', 'Shoot flame arrows', 0, 0, 0, 1, 101, 7, 5, 2085, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 208510, 'Poison Arrow', 'Poison Arrow', 'Shoot poison arrows', 0, 0, 0, 1, 801, 7, 10, 2085, 10, 0, 7, 391010000, 13, 32, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 208515, 'Multiple Shot', 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 0, 0, 1, 801, 7, 15, 2085, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 208520, 'Guided Arrow', 'Guided Arrow', '100% accurate arrow', 0, 0, 0, 1, 550, 7, 20, 2085, 40, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 208525, 'Perfect Shot', 'Perfect Shot', 'Inflict 200% damage', 0, 0, 0, 1, 551, 7, 25, 2085, 70, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 208530, 'Fire Shot', 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 0, 0, 1, 101, 7, 30, 2085, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 208535, 'Poison Shot', 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 0, 0, 1, 801, 7, 35, 2085, 30, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 208540, 'Arc Shot', 'Arc Shot', 'Inflict 250% damage', 0, 0, 0, 1, 551, 7, 40, 2085, 100, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 208545, 'Explosive Shot', 'Explosive Shot', 'The Strongest Fire Arrow', 0, 0, 0, 1, 148, 7, 45, 2085, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 208550, 'Viper', 'Viper', 'The Strongest Poison Arrow', 0, 0, 0, 1, 157, 7, 50, 2085, 50, 0, 7, 391010000, 13, 42, 100, 2, 3, 0, 0, 0 )
insert into magic values ( 208555, 'Arrow Shower', 'Arrow Shower', 'Shoot 5 arrows simulataneously', 0, 0, 0, 1, 801, 7, 55, 2085, 150, 0, 7, 391010000, 15, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 208557, 'Shadow Shot', 'Shadow Shot', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 57, 2085, 200, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 208560, 'Shadow Hunter', 'Shadow Hunter', '100% accurate arrow with 250% damage', 0, 0, 0, 1, 550, 7, 60, 2085, 250, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 208562, 'Ice Shot', 'Ice Shot', 'Inflicts 300% damage and has a chance to slow down the enemy', 0, 0, 0, 1, 145, 7, 62, 2085, 300, 0, 7, 391010000, 13, 60, 100, 2, 4, 0, 0, 0 )
insert into magic values ( 208566, 'Lightning Shot', 'Lightning Shot', 'Inflicts 300% damage and stuns for 3 seconds', 0, 0, 0, 1, 154, 7, 66, 2085, 300, 0, 7, 391010000, 13, 60, 100, 2, 0, 3, 0, 0 )
insert into magic values ( 208570, 'Dark Pursuer', 'Dark Pursuer', '100% accurate arrow with 350% damage', 0, 0, 0, 1, 550, 7, 70, 2085, 300, 0, 7, 391010000, 13, 0, 100, 2, 0, 0, 0, 0 )
insert into magic_type2 values ( 102003, 'Archery', 'Shoot an arrow', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 107003, 'Archery', 'Shoot an arrow', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 107503, 'Through Shot', 'Inflict 150% damage', 0, 100, 150, 100, 1, 1 )
insert into magic_type2 values ( 107505, 'Fire Arrow', 'Shoot flame arrows', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 107510, 'Poison Arrow', 'Shoot poison arrows', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 107515, 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 100, 99, 100, 3, 3 )
insert into magic_type2 values ( 107520, 'Guided Arrow', '100% accurate arrow', 2, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 107525, 'Perfect Shot', 'Inflict 200% damage', 0, 100, 200, 100, 1, 1 )
insert into magic_type2 values ( 107530, 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 107535, 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 107540, 'Arc Shot', 'Inflict 250% damage', 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 ( 107555, 'Arrow Shower', 'Shoot 5 arrows simultaneously', 0, 100, 99, 100, 5, 5 )
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 300% damage', 2, 100, 300, 100, 1, 1 )
insert into magic_type2 values ( 108003, 'Archery', 'Shoot an arrow', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 108503, 'Through Shot', 'Inflict 150% damage', 0, 100, 150, 100, 1, 1 )
insert into magic_type2 values ( 108505, 'Fire Arrow', 'Shoot flame arrows', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 108510, 'Poison Arrow', 'Shoot poison arrows', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 108515, 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 100, 99, 100, 3, 3 )
insert into magic_type2 values ( 108520, 'Guided Arrow', '100% accurate arrow', 2, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 108525, 'Perfect Shot', 'Inflict 200% damage', 0, 100, 200, 100, 1, 1 )
insert into magic_type2 values ( 108530, 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 108535, 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 108540, 'Arc Shot', 'Inflict 250% damage', 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 ( 108555, 'Arrow Shower', 'Shoot 5 arrows simultaneously', 0, 100, 99, 100, 5, 5 )
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 300% damage', 2, 100, 300, 100, 1, 1 )
insert into magic_type2 values ( 108562, 'Ice Shot', 'Inflict 300% damage and has a chance to slow down enemy', 2, 100, 300, 100, 1, 1 )
insert into magic_type2 values ( 108566, 'Lightning Shot', 'Inflict 300% damage and stuns for 3 seconds', 2, 100, 300, 100, 1, 1 )
insert into magic_type2 values ( 108570, 'Dark Pursuer', '100% accurate arrow with 350% damage', 2, 100, 350, 100, 1, 1 )
insert into magic_type2 values ( 202003, 'Archery', 'Shoot an arrow', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 207003, 'Archery', 'Shoot an arrow', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 207503, 'Through Shot', 'Inflict 150% damage', 0, 100, 150, 100, 1, 1 )
insert into magic_type2 values ( 207505, 'Fire Arrow', 'Shoot flame arrows', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 207510, 'Poison Arrow', 'Shoot poison arrows', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 207515, 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 100, 99, 100, 3, 3 )
insert into magic_type2 values ( 207520, 'Guided Arrow', '100% accurate arrow', 2, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 207525, 'Perfect Shot', 'Inflict 200% damage', 0, 100, 200, 100, 1, 1 )
insert into magic_type2 values ( 207530, 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 207535, 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 207540, 'Arc Shot', 'Inflict 250% damage', 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 ( 207555, 'Arrow Shower', 'Shoot 5 arrows simultaneously', 0, 100, 99, 100, 5, 5 )
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 300% damage', 2, 100, 300, 100, 1, 1 )
insert into magic_type2 values ( 208003, 'Archery', 'Shoot an arrow', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 208503, 'Through Shot', 'Inflict 150% damage', 0, 100, 150, 100, 1, 1 )
insert into magic_type2 values ( 208505, 'Fire Arrow', 'Shoot flame arrows', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 208510, 'Poison Arrow', 'Shoot poison arrows', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 208515, 'Multiple Shot', 'Shoot 3 arrows simultaneously', 0, 100, 99, 100, 3, 3 )
insert into magic_type2 values ( 208520, 'Guided Arrow', '100% accurate arrow', 2, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 208525, 'Perfect Shot', 'Inflict 200% damage', 0, 100, 200, 100, 1, 1 )
insert into magic_type2 values ( 208530, 'Fire Shot', 'Arrow attack that inflicts additional flame damage', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 208535, 'Poison Shot', 'Arrow attack that inflicts additional poison damage', 0, 100, 100, 100, 1, 1 )
insert into magic_type2 values ( 208540, 'Arc Shot', 'Inflict 250% damage', 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 ( 208555, 'Arrow Shower', 'Shoot 5 arrows simultaneously', 0, 100, 99, 100, 5, 5 )
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 300% damage', 2, 100, 300, 100, 1, 1 )
insert into magic_type2 values ( 208562, 'Ice Shot', 'Inflict 300% damage and has a chance to slow down enemy', 2, 100, 300, 100, 1, 1 )
insert into magic_type2 values ( 208566, 'Lightning Shot', 'Inflict 300% damage and stuns for 3 seconds', 2, 100, 300, 100, 1, 1 )
insert into magic_type2 values ( 208570, 'Dark Pursuer', '100% accurate arrow with 350% damage', 2, 100, 350, 100, 1, 1 )
insert into magic_type3 values ( 108566, 'Lightning Shot', 'Inflicts 300% damage and stuns for 3 seconds', 0, 0, 1, -150, 0, 0, 0, 3 )
insert into magic_type3 values ( 208566, 'Lightning Shot', 'Inflicts 300% damage and stuns for 3 seconds', 0, 0, 1, -150, 0, 0, 0, 3 )
insert into magic_type4 values ( 108562, 'Ice Shot', 'Inflicts 300% damage and has a chance to slow down the enemy', 40, 0, 10, 100, 65, 0, 100, 100, 100, 0, 100, 0, 100, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100 )
insert into magic_type4 values ( 208562, 'Ice Shot', 'Inflicts 300% damage and has a chance to slow down the enemy', 40, 0, 10, 100, 65, 0, 100, 100, 100, 0, 100, 0, 100, 100, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100 )

NOTE: I changed the enname or krname or whatever to its English form. That way, I can copy paste it easier. Sometimes when you copy paste rows with like turkish symbols, it only copies up to the turkish symbols. So, if you wanna translate it into Korean again, be my guest.

2a. If you want Counter-Strike:

Code:
insert into magic values ( 107552, 'Counter Strike', 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 0, 0, 0, 1, 551, 7, 52, 1075, 150, 0, 7, 391010000, 13, 240, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 108552, 'Counter Strike', 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 0, 0, 0, 1, 551, 7, 52, 1085, 150, 0, 7, 391010000, 13, 240, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 207552, 'Counter Strike', 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 0, 0, 0, 1, 551, 7, 52, 2075, 150, 0, 7, 391010000, 13, 240, 100, 2, 0, 0, 0, 0 )
insert into magic values ( 208552, 'Counter Strike', 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 0, 0, 0, 1, 551, 7, 52, 2085, 150, 0, 7, 391010000, 13, 240, 100, 2, 0, 0, 0, 0 )
insert into magic_type2 values ( 107552, 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 2, 80, 400, 100, 1, 1 )
insert into magic_type2 values ( 108552, 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 2, 80, 400, 100, 1, 1 )
insert into magic_type2 values ( 207552, 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 2, 80, 400, 100, 1, 1 )
insert into magic_type2 values ( 208552, 'Counter Strike', 'Arrow attack that inflicts a great amount of damage', 2, 80, 400, 100, 1, 1 )

3. Download the attachment and put it in your data folder.

I cannot make this any easier. If you can't do this by yourself, then I don't think anyone can help you lol. Just delete your MSSQL, and jump off a bridge ;D

Well,

Creditz to Jonny for giving me 3/4 of the code, and me for translating it and completing the code with whatever was missing and the RofD skills.

P.S. Tested all of them except Counter-Strike I think.
 

Attachments

You must be registered for see attachments list
Newbie Spellweaver
Joined
Jul 7, 2008
Messages
7
Reaction score
0
Re: [Share] Archery Skills Fix Level 1~70

i am imported all data to my DB

and fix TBL

and if i use skills

skill visual working and used mana point but not show any damage ..

Lighting Shot - Ice Shot - Counter Strike ...

Not Working no Damage. ..
 
Junior Spellweaver
Joined
Jun 7, 2006
Messages
144
Reaction score
1
Re: [Share] Archery Skills Fix Level 1~70

Can I do this when my server is running?.
 
Newbie Spellweaver
Joined
Jun 10, 2006
Messages
78
Reaction score
1
Re: [Share] Archery Skills Fix Level 1~70

Yes but it dont take effect b4 you restart server
 
Junior Spellweaver
Joined
Jun 7, 2006
Messages
144
Reaction score
1
Re: [Share] Archery Skills Fix Level 1~70

I c, thx ray
 
Back
Top