-- Touch of the Divine
REPLACE 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 ('741', 'Touch of the Divine', '5', '5', '4294967295', '4294967295', '741', '741', '6', '0', '0', '0', '0', '0', '4', '0', '65', '0', '7', '4294967295', '3', '0', '1', '741', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('741', '1', '232', '2', '4544');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('742', '1', '232', '4', '4545');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('743', '1', '232', '6', '4546');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('744', '1', '232', '8', '4547');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('745', '1', '232', '10', '4548');

-- Unfailing Divinity
REPLACE 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 ('577', 'Unfailing Divinity', '2', '3', '4294967295', '4294967295', '5660', '5661', '5', '4294967295', '0', '0', '0', '0', '4', '0', '61', '2', '4', '4294967295', '3', '0', '1', '577', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('577', '1', '277', '20', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('578', '1', '277', '40', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('579', '1', '277', '60', '0');

-- Internal Metronome(5)/Channeling Focus(3) * These AA no longer exist on live.
REPLACE 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 ('710', 'Internal Metronome', '5', '5', '4294967295', '4294967295', '710', '710', '6', '0', '96', '3', '0', '0', '256', '0', '65', '0', '7', '4294967295', '2', '0', '1', '710', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('95', '1', '235', '5', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('96', '1', '235', '10', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('97', '1', '235', '15', '0');

REPLACE 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 ('95', 'Channeling Focus', '2', '3', '4294967295', '4294967295', '13546', '13547', '2', '4294967295', '4294967295', '0', '0', '0', '64892', '0', '55', '2', '3', '4294967295', '2', '0', '1', '95', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('710', '1', '235', '5', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('711', '1', '235', '10', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('712', '1', '235', '15', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('713', '1', '235', '20', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('714', '1', '235', '25', '0');

-- Enchanted root/Viscid Root/Petrified root
REPLACE 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 ('144', 'Enhanced Root', '5', '1', '4294967295', '4294967295', '13600', '13601', '3', '4294967295', '4294967295', '0', '0', '0', '64', '0', '59', '0', '3', '4294967295', '3', '0', '1', '144', '1', '0');
REPLACE 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  ('567', 'Viscid Roots', '5', '1', '4294967295', '4294967295', '5664', '5665', '5', '4294967295', '144', '1', '0', '0', '64', '0', '63', '0', '4', '4294967295', '3', '0', '1', '567', '1', '0');
REPLACE 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  ('5061', 'Petrified Roots ', '5', '1', '4294967295', '4294967295', '567', '567', '7', '4294967295', '567', '1', '0', '0', '64', '0', '71', '0', '14', '4294967295', '3', '0', '1', '567', '4', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('144', '1', '244', '50', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('567', '1', '244', '62', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('5061', '1', '244', '73', '0');

-- Pet Affinity
REPLACE 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 ('734', 'Pet Affinity', '12', '1', '4294967295', '4294967295', '9285', '9286', '6', '4294967295', '0', '0', '0', '0', '60448', '0', '65', '0', '7', '4294967295', '2', '0', '1', '734', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('734', '1', '237', '1', '0');

-- Jamfest
REPLACE 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 ('225', 'Jam Fest', '3', '3', '4294967295', '4294967295', '13750', '13751', '3', '4294967295', '4294967295', '0', '0', '0', '256', '0', '59', '3', '3', '4294967295', '3', '0', '1', '225', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('225', '1', '272', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('225', '1', '272', '2', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('225', '1', '272', '3', '0');

-- Extended Notes/Sionachie's Crescendo
REPLACE 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 ('270', 'Extended Notes', '3', '3', '4294967295', '4294967295', '13805', '13806', '3', '4294967295', '4294967295', '0', '0', '0', '256', '0', '59', '3', '3', '4294967295', '3', '0', '1', '270', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('270', '1', '270', '10', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('271', '1', '270', '15', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('272', '1', '270', '25', '0');

REPLACE 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 ('568', 'Sionachie\'s Crescendo', '2', '3', '4294967295', '4294967295', '5666', '5667', '5', '4294967295', '270', '3', '0', '0', '256', '0', '63', '0', '4', '4294967295', '3', '0', '1', '568', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('568', '1', '270', '30', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('569', '1', '270', '35', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('570', '1', '270', '40', '0');

-- Spell Casting Expertise/Mastery of the Past(Caster/Healer)/MoP II/MoP III/MoP IV
REPLACE 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 ('101', 'Spell Casting Expertise', '2', '3', '4294967295', '4294967295', '13550', '13551', '2', '4294967295', '4294967295', '0', '0', '0', '31008', '0', '55', '2', '3', '4294967295', '2', '0', '1', '101', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('101', '1', '265', '20', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('102', '1', '265', '35', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('103', '1', '265', '52', '0');

REPLACE 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 ('446', 'Mastery of the Past', '3', '3', '4294967295', '4294967295', '446', '446', '5', '4294967295', '101', '3', '0', '0', '31008', '0', '62', '0', '4', '4294967295', '2', '0', '1', '446', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('446', '1', '265', '54', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('447', '1', '265', '56', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('448', '1', '265', '58', '0');

REPLACE 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 ('735', 'Mastery of the Past', '3', '3', '4294967295', '4294967295', '9163', '9164', '6', '4294967295', '0', '0', '0', '0', '32784', '0', '62', '0', '7', '4294967295', '2', '0', '1', '735', '1', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('735', '1', '265', '54', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('736', '1', '265', '56', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('737', '1', '265', '58', '0');

REPLACE 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 ('7056', 'Mastery of the Past II', '5', '3', '4294967295', '4294967295', '735', '735', '5', '4294967295', '0', '0', '0', '0', '33884', '0', '67', '0', '8', '4294967295', '2', '0', '1', '735', '1', '0');
REPLACE 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 ('7059', 'Mastery of the Past III', '6', '3', '4294967295', '4294967295', '735', '735', '5', '4294967295', '7056', '3', '0', '0', '33884', '0', '71', '0', '14', '4294967295', '2', '0', '1', '735', '4', '0');
REPLACE 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 ('7066', 'Mastery of the Past IV', '8', '3', '4294967295', '4294967295', '735', '735', '5', '4294967295', '7059', '3', '0', '0', '33884', '0', '76', '0', '15', '4294967295', '2', '0', '1', '735', '5', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('7056', '1', '265', '62', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('7057', '1', '265', '64', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('7058', '1', '265', '66', '0');

REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('7059', '1', '265', '67', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('7060', '1', '265', '68', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('7061', '1', '265', '69', '0');

REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('7066', '1', '265', '70', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('7066', '1', '265', '71', '0');
REPLACE INTO `aa_effects` (`aaid`, `slot`, `effectid`, `base1`, `base2`)  VALUES ('7066', '1', '265', '72', '0');

-- Misc fix from prior revision.
UPDATE `altadv_vars` SET `berserker` = 0 WHERE `skill_id` = 1624;
UPDATE `altadv_vars` SET `clientver` = 99 WHERE `skill_id` = 1143;
UPDATE `altadv_vars` SET `clientver` = 5 WHERE `aa_expansion` = 15;
REPLACE 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 ('1166', 'Frenzied Defense', '3', '3', '4294967295', '4294967295', '1143', '1143', '3', '4294967295', '0', '0', '0', '0', '0', '1', '65', '0', '15', '4294967295', '3', '0', '1', '1143', '4', '0');

