pa/eqemu-server
2
0
Fork 0
mirror of https://github.com/EQEmu/Server.git synced 2025-12-12 01:11:29 +00:00
Code Issues Actions Packages Projects Releases Wiki Activity
eqemu-server/utils/sql/svn/2176_required_aa_updates.sql
KimLS da7347f76f svn -> git Migration
2013-02-16 16:14:39 -08:00

283 lines
29 KiB
SQL
Raw Permalink Blame History

-- Concentration
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1587, 1, 344, 50, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1588, 1, 344, 55, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1589, 1, 344, 60, 0);
-- Stalwart Endurance
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 652, 1, 293, 25, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 653, 1, 293, 50, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 654, 1, 293, 75, 0);
-- Dauntless Perseverance
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1586, 1, 293, 25, 0);
-- First Aid
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 74, 1, 269, 10, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 75, 1, 269, 20, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 76, 1, 269, 30, 0);
-- Bandage Wound
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 263, 1, 282, 10, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 264, 1, 282, 25, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 265, 1, 282, 50, 0);
-- Mithaniel's Binding
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 537, 1, 282, 60, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 538, 1, 282, 70, 0);
-- Field Dressing
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1611, 1, 282, 4, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1612, 1, 282, 8, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1613, 1, 282, 12, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1614, 1, 282, 16, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1615, 1, 282, 20, 0);
-- Combat Medic
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 5136, 1, 282, 4, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 5137, 1, 282, 8, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 5138, 1, 282, 12, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 5139, 1, 282, 16, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 5140, 1, 282, 20, 0);
-- Concentration
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1587, 1, 10, 0, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1588, 1, 33, 0, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1589, 1, 50, 0, 0);
-- Relentless Assault
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1621, 1, 177, 14, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1622, 1, 177, 19, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1623, 1, 177, 24, 0);
-- Punishing Blade
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 599, 1, 266, 2, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 600, 1, 266, 4, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 601, 1, 266, 8, 0);
-- Wicked Blade
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1536, 1, 266, 11, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1537, 1, 266, 14, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1538, 1, 266, 17, 0);
-- Speed of the Knight
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 602, 1, 266, 2, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 603, 1, 266, 4, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 604, 1, 266, 8, 0);
-- Innate See Invis
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1388, 2, 13, 1, 0);
-- Selo's Enduring Cadence
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1627, 1, 271, 5, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1628, 1, 271, 10, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1629, 1, 271, 15, 0);
-- Vicious Smash
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 855, 1, 220, 5, 10);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 856, 1, 220, 15, 10);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 857, 1, 220, 30, 10);
-- Kick Mastery -- Updates added for redundancy since some of these may already exist.
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 820, 1, 220, 10, 26);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 820, 2, 220, 10, 30);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 820, 3, 220, 10, 38);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 821, 1, 220, 20, 26);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 821, 2, 220, 20, 30);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 821, 3, 220, 20, 38);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 822, 1, 220, 30, 26);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 822, 2, 220, 30, 30);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 822, 3, 220, 30, 38);
UPDATE `aa_effects` SET `effectid`=220, `base1`=10, `base2`=26 WHERE `aaid`=820 && `slot`=1;
UPDATE `aa_effects` SET `effectid`=220, `base1`=10, `base2`=30 WHERE `aaid`=820 && `slot`=2;
UPDATE `aa_effects` SET `effectid`=220, `base1`=10, `base2`=38 WHERE `aaid`=820 && `slot`=3;
UPDATE `aa_effects` SET `effectid`=220, `base1`=20, `base2`=26 WHERE `aaid`=821 && `slot`=1;
UPDATE `aa_effects` SET `effectid`=220, `base1`=20, `base2`=30 WHERE `aaid`=821 && `slot`=2;
UPDATE `aa_effects` SET `effectid`=220, `base1`=20, `base2`=38 WHERE `aaid`=821 && `slot`=3;
UPDATE `aa_effects` SET `effectid`=220, `base1`=30, `base2`=26 WHERE `aaid`=822 && `slot`=1;
UPDATE `aa_effects` SET `effectid`=220, `base1`=30, `base2`=30 WHERE `aaid`=822 && `slot`=2;
UPDATE `aa_effects` SET `effectid`=220, `base1`=30, `base2`=38 WHERE `aaid`=822 && `slot`=3;
-- Strengthened Strike -- Updates added for redundancy since some of these may already exist.
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 915, 1, 220, 5, 10);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 915, 2, 220, 5, 30);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 916, 1, 220, 15, 10);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 916, 2, 220, 15, 30);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 917, 1, 220, 30, 10);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 917, 2, 220, 30, 30);
UPDATE `aa_effects` SET `effectid`=220, `base1`=5, `base2`=10 WHERE `aaid`=915 && `slot`=1;
UPDATE `aa_effects` SET `effectid`=220, `base1`=5, `base2`=30 WHERE `aaid`=915 && `slot`=2;
-- Shield Block
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1287, 1, 320, 1, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1288, 2, 320, 3, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1289, 3, 320, 5, 0);
-- Blur of Axes
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1134, 1, 220, 32, 74);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1135, 1, 220, 64, 74);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1136, 1, 220, 96, 74);
-- Vicious Frenzy
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1158, 1, 220, 128, 74);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1159, 1, 220, 192, 74);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1160, 1, 220, 224, 74);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1161, 1, 220, 256, 74);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1162, 1, 220, 288, 74);
-- Triple Backstab
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 846, 1, 258, 5, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 847, 1, 258, 10, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 848, 1, 258, 15, 0);
-- Flurry of Knives
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1301, 1, 258, 20, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1302, 1, 258, 25, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1303, 1, 258, 30, 0);
-- Chaotic Stab
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 287, 1, 253, 1, 0);
-- Endless Quiver
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 205, 1, 251, 100, 0);
-- Archery Mastery
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 199, 1, 301, 30, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 200, 1, 301, 60, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 201, 1, 301, 100, 0);
-- Throwing Mastery
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1131, 1, 185, 10, 51);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1132, 1, 185, 20, 51);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1133, 1, 185, 30, 51);
-- Sinister Strikes
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 806, 1, 249, 1, 0);
-- Heightened Awareness
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 823, 1, 222, 20, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 824, 1, 222, 25, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 825, 1, 222, 30, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 826, 1, 222, 35, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 827, 1, 222, 40, 0);
-- Tactical Mastery
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 631, 1, 292, 15, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 632, 1, 292, 30, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 633, 1, 292, 45, 0);
-- Ferocity
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 564, 1, 177, 3, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 565, 1, 177, 6, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 566, 1, 177, 9, 0);
-- Knight's Advantage
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 561, 1, 177, 3, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 562, 1, 177, 6, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 563, 1, 177, 9, 0);
-- Knight's Expertise
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1624, 1, 177, 14, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1625, 1, 177, 19, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1626, 1, 177, 24, 0);
-- Bestial Frenzy
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 551, 1, 225, 3, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 552, 1, 225, 6, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 553, 1, 225, 9, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 554, 1, 225, 12, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 555, 1, 225, 15, 0);
-- Harmonious Attack
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 556, 1, 225, 3, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 557, 1, 225, 6, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 558, 1, 225, 9, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 559, 1, 225, 12, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 560, 1, 225, 15, 0);
-- Weapon Affinity
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 686, 1, 200, 10, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 687, 1, 200, 20, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 688, 1, 200, 30, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 689, 1, 200, 40, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 690, 1, 200, 50, 0);
-- Dragon Punch
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 273, 1, 288, 100, 21);
-- Technique of Master Wu
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 611, 1, 283, 20, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 612, 1, 283, 40, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 613, 1, 283, 60, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 614, 1, 283, 80, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 615, 1, 283, 100, 0);
-- Seized Opportunity
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 878, 1, 252, 10, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 879, 1, 252, 20, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 880, 1, 252, 30, 0);
-- Forced Opening
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1539, 1, 252, 35, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1540, 1, 252, 40, 0);
INSERT INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`) VALUES ( 1541, 1, 252, 45, 0);
-- Fleet of Foot
UPDATE `aa_effects` SET `effectid`=290, `base1`=5 WHERE `aaid`=628;
UPDATE `aa_effects` SET `effectid`=290, `base1`=15 WHERE `aaid`=629;
-- Swift Journey
UPDATE `aa_effects` SET `effectid`=271, `base1`=7 WHERE `aaid`=672;
UPDATE `aa_effects` SET `effectid`=271, `base1`=14 WHERE `aaid`=673;
-- Innate Run Speed
UPDATE `aa_effects` SET `effectid`=271, `base1`=8 WHERE `aaid`=62;
UPDATE `aa_effects` SET `effectid`=271, `base1`=14 WHERE `aaid`=63;
UPDATE `aa_effects` SET `effectid`=271, `base1`=21 WHERE `aaid`=64;
-- Strikethrough
UPDATE `aa_effects` SET `effectid`=292, `base1`=5 WHERE `aaid`=807;
UPDATE `aa_effects` SET `effectid`=292, `base1`=10 WHERE `aaid`=808;
UPDATE `aa_effects` SET `effectid`=292, `base1`=15 WHERE `aaid`=809;
-- altadv_vars
UPDATE `altadv_vars` SET `prereq_skill` = 263 WHERE `skill_id` = 537;
UPDATE `altadv_vars` SET `type` = 2 WHERE `skill_id` = 564;
UPDATE `altadv_vars` SET `prereq_skill` = 222, `prereq_minpoints` = 3 WHERE `skill_id` = 652;
UPDATE `altadv_vars` SET `hotkey_sid` = 4294967295, `hotkey_sid2` = 4294967295, `title_sid` = 683, `desc_sid` = 683, `spellid` = 4294967295 WHERE `skill_id` = 683;
UPDATE `altadv_vars` SET `hotkey_sid` = 4294967295, `hotkey_sid2` = 4294967295, `title_sid` = 807, `desc_sid` = 807, `spellid` = 4294967295 WHERE `skill_id` = 807;
UPDATE `altadv_vars` SET `hotkey_sid` = 4294967295, `hotkey_sid2` = 4294967295, `title_sid` = 820, `desc_sid` = 820, `spellid` = 4294967295, `sof_type` = 3 WHERE `skill_id` = 820;
UPDATE `altadv_vars` SET `hotkey_sid` = 4294967295, `hotkey_sid2` = 4294967295, `title_sid` = 823, `desc_sid` = 823, `spellid` = 4294967295, `sof_type` = 3 WHERE `skill_id` = 823;
UPDATE `altadv_vars` SET `hotkey_sid` = 4294967295, `hotkey_sid2` = 4294967295, `title_sid` = 915, `desc_sid` = 915, `spellid` = 4294967295, `type` = 6 WHERE `skill_id` = 915;
UPDATE `altadv_vars` SET `hotkey_sid` = 4294967295, `hotkey_sid2` = 4294967295, `title_sid` = 846, `desc_sid` = 846, `spellid` = 4294967295, `sof_type` = 3 WHERE `skill_id` = 846;
UPDATE `altadv_vars` SET `hotkey_sid` = 4294967295, `hotkey_sid2` = 4294967295, `title_sid` = 855, `desc_sid` = 855, `spellid` = 4294967295, `sof_type` = 3, `classes` = 40 WHERE `skill_id` = 855;
UPDATE `altadv_vars` SET `hotkey_sid` = 4294967295, `hotkey_sid2` = 4294967295, `title_sid` = 878, `desc_sid` = 878, `spellid` = 4294967295, `prereq_skill` = 0, `prereq_minpoints` = 0, `sof_type` = 3 WHERE `skill_id` = 878;
UPDATE `altadv_vars` SET `hotkey_sid` = 4294967295, `hotkey_sid2` = 4294967295, `title_sid` = 1134, `desc_sid` = 1134, `spellid` = 4294967295, `sof_type` = 3, `aa_expansion` = 4, `sof_next_skill` = 1134 WHERE `skill_id` = 1134;
UPDATE `altadv_vars` SET `hotkey_sid` = 4294967295, `hotkey_sid2` = 4294967295, `title_sid` = 1150, `desc_sid` = 1150, `spellid` = 4294967295 WHERE `skill_id` = 1150;
UPDATE `altadv_vars` SET `hotkey_sid` = 4294967295, `hotkey_sid2` = 4294967295, `title_sid` = 1131, `desc_sid` = 1131, `spellid` = 4294967295, `sof_type` = 3, `aa_expansion` = 3 WHERE `skill_id` = 1131;
UPDATE `altadv_vars` SET `hotkey_sid` = 4294967295, `hotkey_sid2` = 4294967295, `title_sid` = 1158, `desc_sid` = 1158, `spellid` = 4294967295, `prereq_skill` = 1134, `prereq_minpoints` = 3, `sof_type` = 3, `sof_next_skill` = 1134 WHERE `skill_id` = 1158;
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1597', 'Call of Challenge', '9', '1', '1597', '1597', '1597', '1597', '7', '8271', '0', '0', '6', '10', '2', '0', '70', '0', '10', '4294967295', '3', '0', '70', '1597', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('912', 'Warlord\'s Tenacity', '3', '3', '912', '912', '912', '912', '6', '4925', '0', '0', '4', '60', '2', '0', '65', '3', '7', '4294967295', '3', '0', '65', '912', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1583', 'Hastened Defiance', '5', '1', '4294967295', '4294967295', '1583', '1583', '7', '4294967295', '912', '3', '0', '0', '2', '0', '70', '0', '10', '4294967295', '3', '0', '70', '1583', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1586', 'Dauntless Perseverance', '12', '1', '4294967295', '4294967295', '1586', '1586', '7', '4294967295', '222', '3', '0', '0', '2', '0', '70', '0', '10', '4294967295', '3', '0', '70', '1586', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1611', 'Field Dressing', '3', '5', '4294967295', '4294967295', '1611', '1611', '7', '4294967295', '537', '2', '0', '0', '2', '1', '66', '0', '10', '4294967295', '3', '0', '66', '1417', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('5136', 'Combat Medic', '3', '5', '4294967295', '4294967295', '4688', '4688', '3', '4294967295', '1611', '5', '0', '0', '2', '1', '71', '0', '12', '4294967295', '3', '0', '71', '4688', '4', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1587', 'Concentration', '3', '3', '4294967295', '4294967295', '1587', '1587', '7', '4294967295', '0', '0', '0', '0', '642', '1', '66', '0', '10', '4294967295', '2', '0', '1', '1587', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1621', 'Relentless Assault', '7', '3', '4294967295', '4294967295', '1621', '1621', '7', '4294967295', '564', '3', '0', '0', '658', '1', '70', '0', '10', '4294967295', '2', '0', '70', '564', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1330', 'Resolute Defiance', '3', '3', '912', '912', '1330', '1330', '7', '4925', '912', '3', '4', '60', '2', '0', '70', '3', '8', '4294967295', '3', '0', '70', '912', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1536', 'Wicked Blade', '3', '3', '4294967295', '4294967295', '1536', '1536', '7', '4294967295', '599', '3', '0', '0', '146', '1', '70', '0', '10', '4294967295', '3', '0', '70', '599', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1388', 'Innate See Invis', '9', '1', '4294967295', '4294967295', '1388', '1388', '7', '0', '0', '0', '0', '0', '65534', '1', '70', '0', '10', '4294967295', '1', '0', '70', '1388', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1627', 'Selo\'s Enduring Cadence', '3', '3', '4294967295', '4294967295', '1627', '1627', '7', '4294967295', '672', '2', '0', '0', '256', '0', '66', '0', '10', '4294967295', '3', '0', '66', '1627', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1301', 'Flurry of Knives', '3', '3', '4294967295', '4294967295', '1301', '1301', '7', '4294967295', '846', '3', '0', '0', '512', '0', '66', '3', '8', '4294967295', '3', '0', '1', '846', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1539', 'Forced Opening', '3', '3', '4294967295', '4294967295', '1539', '1539', '7', '4294967295', '878', '3', '0', '0', '512', '0', '70', '0', '10', '4294967295', '3', '0', '1', '878', '1', '0');
INSERT INTO `altadv_vars` (`skill_id`, `name`, `cost`, `max_level`, `hotkey_sid`, `hotkey_sid2`, `title_sid`, `desc_sid`, `type`, `spellid`, `prereq_skill`, `prereq_minpoints`, `spell_type`, `spell_refresh`, `classes`, `berserker`, `class_type`, `cost_inc`, `aa_expansion`, `special_category`, `sof_type`, `sof_cost_inc`, `sof_max_level`, `sof_next_skill`, `clientver`, `account_time_required`) VALUES ('1624', 'Knight\'s Expertise', '7', '3', '4294967295', '4294967295', '1624', '1624', '7', '4294967295', '561', '3', '0', '0', '40', '1', '70', '0', '10', '4294967295', '3', '0', '70', '561', '1', '0');
-- aa_actions
INSERT INTO `aa_actions` (`aaid`, `rank`, `reuse_time`, `spell_id`, `target`, `nonspell_action`, `nonspell_mana`, `nonspell_duration`, `redux_aa`, `redux_rate`, `redux_aa2`, `redux_rate2`) VALUES ('1597', '0', '10', '8271', '2', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `aa_actions` (`aaid`, `rank`, `reuse_time`, `spell_id`, `target`, `nonspell_action`, `nonspell_mana`, `nonspell_duration`, `redux_aa`, `redux_rate`, `redux_aa2`, `redux_rate2`) VALUES ('912', '0', '60', '4925', '1', '0', '0', '0', '1583', '10', '0', '0');
INSERT INTO `aa_actions` (`aaid`, `rank`, `reuse_time`, `spell_id`, `target`, `nonspell_action`, `nonspell_mana`, `nonspell_duration`, `redux_aa`, `redux_rate`, `redux_aa2`, `redux_rate2`) VALUES ('912', '1', '60', '4926', '1', '0', '0', '0', '1583', '10', '0', '0');
INSERT INTO `aa_actions` (`aaid`, `rank`, `reuse_time`, `spell_id`, `target`, `nonspell_action`, `nonspell_mana`, `nonspell_duration`, `redux_aa`, `redux_rate`, `redux_aa2`, `redux_rate2`) VALUES ('912', '2', '60', '4927', '1', '0', '0', '0', '1583', '10', '0', '0');
INSERT INTO `aa_actions` (`aaid`, `rank`, `reuse_time`, `spell_id`, `target`, `nonspell_action`, `nonspell_mana`, `nonspell_duration`, `redux_aa`, `redux_rate`, `redux_aa2`, `redux_rate2`) VALUES ('1330', '1', '60', '5936', '1', '0', '0', '0', '1583', '10', '0', '0');
INSERT INTO `aa_actions` (`aaid`, `rank`, `reuse_time`, `spell_id`, `target`, `nonspell_action`, `nonspell_mana`, `nonspell_duration`, `redux_aa`, `redux_rate`, `redux_aa2`, `redux_rate2`) VALUES ('1330', '2', '60', '5937', '1', '0', '0', '0', '1583', '10', '0', '0');
INSERT INTO `aa_actions` (`aaid`, `rank`, `reuse_time`, `spell_id`, `target`, `nonspell_action`, `nonspell_mana`, `nonspell_duration`, `redux_aa`, `redux_rate`, `redux_aa2`, `redux_rate2`) VALUES ('1330', '3', '60', '5938', '1', '0', '0', '0', '1583', '10', '0', '0');
Reference in New Issue View Git Blame Copy Permalink