Code - 1
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'
code - 2
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 )
code - 3
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 )