-- =====================================================
-- MIGRATION: Ajout des branches de talents manquantes
-- =====================================================
-- Ce script ajoute les branches Fire, Sacred, Fallen, Paladin
-- qui manquent dans la base de données

SET NAMES utf8mb4;

-- =====================================================
-- BRANCHE FEU (24 talents) - Arcaniste
-- =====================================================
INSERT INTO talents (id, branch_id, name, description, spell_id, modify_spell_id, cooldown_reduction, mana_cost_reduction, str_scaling_change, dex_scaling_change, int_scaling_change, remove_status_effects, affected_spell_ids, strength_bonus, dexterity_bonus, intelligence_bonus, magical_damage_bonus, physical_damage_bonus, magic_resistance_bonus, crit_chance_bonus, healing_bonus, max_health_bonus, max_mana_bonus, mana_regen_bonus, health_regen_bonus, physical_defense_bonus, magical_defense_bonus, damage_reduction_bonus, evasion_bonus, attack_speed_bonus, armor_bonus, all_stats_bonus, tree_position, damage_reflection_bonus, crit_damage_bonus, crit_resistance_bonus) VALUES
('fire_0', 'fire', 'Serpent de feu', 'Debloque le sort Serpent de feu', 4, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('fire_1', 'fire', 'Mur de braises', '+10% de renvoi de degats', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 10, 0, 0),
('fire_2', 'fire', 'Cyclone igne', '30% de chance d''appliquer 1 stack de brulure supplementaire', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0),
('fire_3', 'fire', 'Spirale ardente', 'Chaque tick de brulure regenere 1 mana', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0),
('fire_4', 'fire', 'Faille magmatique', 'Reduit les degats de brulure subis de 40%', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0),
('fire_5', 'fire', 'Boule de feu', 'Debloque le sort Boule de feu', 1, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0),
('fire_6', 'fire', 'Orbe incandescente', '+8% de chance de critique avec les sorts de feu', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0),
('fire_7', 'fire', 'Nova solaire', 'Les brulures infligent +1 degat par stack actif', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0),
('fire_8', 'fire', 'Machoire infernale', '+15% de degats aux ennemis sous 40% PV', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0),
('fire_9', 'fire', 'Singularite ardente', '-2 cout mana pour tous les sorts de feu', NULL, NULL, 0, 2, 0, 0, 0, 0, '[1,4,11,18]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 0, 0, 0),
('fire_10', 'fire', 'Avatar incandescent', 'Vos attaques d''arme infligent 1 stack de brulure', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0),
('fire_11', 'fire', 'Pluie de meteores', 'Debloque le sort Pluie de meteores', 11, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 0, 0, 0),
('fire_12', 'fire', 'Ruee embrasee', '+15% de vitesse pendant 2 tours apres un sort de feu', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12, 0, 0, 0),
('fire_13', 'fire', 'Papillons de cendres', 'Les brulures durent 1 tour de plus', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13, 0, 0, 0),
('fire_14', 'fire', 'Fouet flamboyant', 'Les coups critiques infligent 2 stacks de brulure', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14, 0, 0, 0),
('fire_15', 'fire', 'Sceau pyromantique', 'Ennemis brules: -15% evasion, -10% res. magique', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15, 0, 0, 0),
('fire_16', 'fire', 'Rugissement du Brasier', '+12% de degats magiques contre cibles brulees', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0),
('fire_17', 'fire', 'Foulee de braise', 'Sous 35% PV, sorts de feu +25% degats', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, 0, 0, 0),
('fire_18', 'fire', 'Noyau solaire', 'Debloque le sort Noyau solaire', 18, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 0, 0, 0),
('fire_19', 'fire', 'Glyphe du Brasier', '-2 cooldown sur Pluie de meteores', NULL, 11, 2, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19, 0, 0, 0),
('fire_20', 'fire', 'Griffe flamboyante', '20% de chance d''ignorer la resistance magique', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 0, 0, 0),
('fire_21', 'fire', 'Maitrise des flammes', '+15% de degats a tous les sorts de feu', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 0, 0, 0),
('fire_22', 'fire', 'Coeur de magma', '-2 cooldown sur Noyau solaire', NULL, 18, 2, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0),
('fire_23', 'fire', 'Appel du Phenix', '1x par combat: renaissez a 40% PV + 5 stacks brulure a l''ennemi', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, 0, 0, 0)
ON DUPLICATE KEY UPDATE name = VALUES(name), spell_id = VALUES(spell_id);

-- =====================================================
-- BRANCHE SACREE (24 talents) - Templier
-- =====================================================
INSERT INTO talents (id, branch_id, name, description, spell_id, modify_spell_id, cooldown_reduction, mana_cost_reduction, str_scaling_change, dex_scaling_change, int_scaling_change, remove_status_effects, affected_spell_ids, strength_bonus, dexterity_bonus, intelligence_bonus, magical_damage_bonus, physical_damage_bonus, magic_resistance_bonus, crit_chance_bonus, healing_bonus, max_health_bonus, max_mana_bonus, mana_regen_bonus, health_regen_bonus, physical_defense_bonus, magical_defense_bonus, damage_reduction_bonus, evasion_bonus, attack_speed_bonus, armor_bonus, all_stats_bonus, tree_position, damage_reflection_bonus, crit_damage_bonus, crit_resistance_bonus) VALUES
('sacred_0', 'sacred', 'Lumiere sacree', 'Debloque le sort Lumiere sacree', 30, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('sacred_1', 'sacred', 'Grace divine', '+10% d''efficacite des soins', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0),
('sacred_2', 'sacred', 'Lumiere persistante', 'Lumiere sacree applique 1 tour de regeneration', NULL, 30, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0),
('sacred_3', 'sacred', 'Resilience sacree', '+5 points de vie maximum', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0),
('sacred_4', 'sacred', 'Aura purificatrice', 'Les soins retirent 1 stack de debuff negatif', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0),
('sacred_5', 'sacred', 'Benediction du soleil', '+2 mana regenere par tour', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0),
('sacred_6', 'sacred', 'Faveur celeste', '10% de chance d''obtenir un soin gratuit', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0),
('sacred_7', 'sacred', 'Corps sacre', '+3 defense physique', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0),
('sacred_8', 'sacred', 'Benediction divine', 'Debloque le sort Benediction divine', 31, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0),
('sacred_9', 'sacred', 'Lumiere interieure', '-1 cooldown sur Lumiere sacree', NULL, 30, 1, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 0, 0, 0),
('sacred_10', 'sacred', 'Protection divine', '+5% de reduction des degats recus', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 10, 0, 0, 0),
('sacred_11', 'sacred', 'Esprit serein', '+5 mana maximum', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 11, 0, 0, 0),
('sacred_12', 'sacred', 'Toucher guerisseur', 'Benediction divine soigne +10 HP', NULL, 31, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12, 0, 0, 0),
('sacred_13', 'sacred', 'Sanctuaire', 'Sous 25% HP, soins +25% efficaces', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13, 0, 0, 0),
('sacred_14', 'sacred', 'Foi inebranlable', '+2 a toutes les statistiques', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 14, 0, 0, 0),
('sacred_15', 'sacred', 'Regeneration amelioree', 'La regeneration soigne +2 HP par tour', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 15, 0, 0, 0),
('sacred_16', 'sacred', 'Lumiere aveuglante', '15% de chance d''aveugler l''ennemi', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0),
('sacred_17', 'sacred', 'Communion divine', '-2 cout mana pour tous les sorts sacres', NULL, NULL, 0, 2, 0, 0, 0, 0, '[30,31]', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, 0, 0, 0),
('sacred_18', 'sacred', 'Ame renforcee', '+10 points de vie maximum', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 0, 0, 0),
('sacred_19', 'sacred', 'Benediction eternelle', 'Benediction divine dure +1 tour', NULL, 31, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19, 0, 0, 0),
('sacred_20', 'sacred', 'Miracle', '1x par combat: a 0 HP, remontez a 25% HP', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 0, 0, 0),
('sacred_21', 'sacred', 'Avatar de lumiere', '+20% efficacite soins, immunite tenebres', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 0, 0, 0),
('sacred_22', 'sacred', 'Saint protecteur', 'Tous vos buffs durent +1 tour', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0),
('sacred_23', 'sacred', 'Apotheose sacree', '+5 INT, soins critiques +50%', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, 0, 0, 0)
ON DUPLICATE KEY UPDATE name = VALUES(name), spell_id = VALUES(spell_id);

-- =====================================================
-- BRANCHE DECHU (24 talents) - Templier
-- =====================================================
INSERT INTO talents (id, branch_id, name, description, spell_id, modify_spell_id, cooldown_reduction, mana_cost_reduction, str_scaling_change, dex_scaling_change, int_scaling_change, remove_status_effects, affected_spell_ids, strength_bonus, dexterity_bonus, intelligence_bonus, magical_damage_bonus, physical_damage_bonus, magic_resistance_bonus, crit_chance_bonus, healing_bonus, max_health_bonus, max_mana_bonus, mana_regen_bonus, health_regen_bonus, physical_defense_bonus, magical_defense_bonus, damage_reduction_bonus, evasion_bonus, attack_speed_bonus, armor_bonus, all_stats_bonus, tree_position, damage_reflection_bonus, crit_damage_bonus, crit_resistance_bonus) VALUES
('fallen_0', 'fallen', 'Malediction des tenebres', 'Debloque le sort Malediction des tenebres', 32, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('fallen_1', 'fallen', 'Ombre grandissante', '+10% de degats des sorts de tenebres', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0),
('fallen_2', 'fallen', 'Corruption', 'Malediction applique +1 stack de faiblesse', NULL, 32, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0),
('fallen_3', 'fallen', 'Pacte sombre', '+3 mana maximum', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0),
('fallen_4', 'fallen', 'Malediction contagieuse', 'Les debuffs appliques durent +1 tour', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0),
('fallen_5', 'fallen', 'Voile d''ombre', '+5% d''esquive', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 5, 0, 0, 0),
('fallen_6', 'fallen', 'Presence menacante', 'Ennemis affaiblis: -10% de precision', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0),
('fallen_7', 'fallen', 'Ame tourmentee', '+2 DEX', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0),
('fallen_8', 'fallen', 'Drain d''ame', 'Debloque le sort Drain d''ame', 33, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0),
('fallen_9', 'fallen', 'Faiblesse amplifiee', 'Ennemis sous faiblesse: +15% degats', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 0, 0, 0),
('fallen_10', 'fallen', 'Tenebres interieures', '-1 cooldown sur Malediction des tenebres', NULL, 32, 1, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0),
('fallen_11', 'fallen', 'Resistance corrompue', '+3 resistance magique', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 11, 0, 0, 0),
('fallen_12', 'fallen', 'Drain ameliore', 'Drain d''ame vole +20% de vie', NULL, 33, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12, 0, 0, 0),
('fallen_13', 'fallen', 'Marque des damnes', 'Ennemis maudits ne regenerent pas de vie', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13, 0, 0, 0),
('fallen_14', 'fallen', 'Desespoir', '+5% degats par debuff actif (max +25%)', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14, 0, 0, 0),
('fallen_15', 'fallen', 'Essence noire', '+3 INT', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15, 0, 0, 0),
('fallen_16', 'fallen', 'Cauchemar eveille', '15% de chance d''appliquer Terreur', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0),
('fallen_17', 'fallen', 'Vampirisme', 'Tous vos degats vous soignent de 5%', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, 0, 0, 0),
('fallen_18', 'fallen', 'Malediction persistante', 'Les faiblesses ne peuvent pas etre purgees', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 0, 0, 0),
('fallen_19', 'fallen', 'Ame vorace', 'Drain d''ame coute -3 mana', NULL, 33, 0, 3, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19, 0, 0, 0),
('fallen_20', 'fallen', 'Pacte mortel', 'Sacrifiez 10% HP max pour +30% degats ce tour', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 0, 0, 0),
('fallen_21', 'fallen', 'Seigneur des tenebres', '+25% degats tenebres, immunite faiblesse', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 25, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 0, 0, 0),
('fallen_22', 'fallen', 'Drain massif', 'Drain d''ame touche tous les ennemis', NULL, 33, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0),
('fallen_23', 'fallen', 'Ange dechu', '+5 DEX, +5 INT, debuffs doubles', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 5, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, 0, 0, 0)
ON DUPLICATE KEY UPDATE name = VALUES(name), spell_id = VALUES(spell_id);

-- =====================================================
-- BRANCHE PALADIN (24 talents) - Templier
-- =====================================================
INSERT INTO talents (id, branch_id, name, description, spell_id, modify_spell_id, cooldown_reduction, mana_cost_reduction, str_scaling_change, dex_scaling_change, int_scaling_change, remove_status_effects, affected_spell_ids, strength_bonus, dexterity_bonus, intelligence_bonus, magical_damage_bonus, physical_damage_bonus, magic_resistance_bonus, crit_chance_bonus, healing_bonus, max_health_bonus, max_mana_bonus, mana_regen_bonus, health_regen_bonus, physical_defense_bonus, magical_defense_bonus, damage_reduction_bonus, evasion_bonus, attack_speed_bonus, armor_bonus, all_stats_bonus, tree_position, damage_reflection_bonus, crit_damage_bonus, crit_resistance_bonus) VALUES
('paladin_0', 'paladin', 'Frappe vertueuse', 'Debloque le sort Frappe vertueuse', 34, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
('paladin_1', 'paladin', 'Entrainement martial', '+10% de degats physiques', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0),
('paladin_2', 'paladin', 'Frappe benie', 'Frappe vertueuse: 20% chance mini-soin 5 HP', NULL, 34, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0),
('paladin_3', 'paladin', 'Constitution', '+5 points de vie maximum', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0),
('paladin_4', 'paladin', 'Posture defensive', '+5 defense physique', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0),
('paladin_5', 'paladin', 'Zele', '+5% de vitesse d''attaque', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 5, 0, 0, 0),
('paladin_6', 'paladin', 'Determination', 'Ne peut pas etre etourdi plus d''1 tour', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0, 0, 0),
('paladin_7', 'paladin', 'Force brute', '+2 STR', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0),
('paladin_8', 'paladin', 'Bouclier de foi', 'Debloque le sort Bouclier de foi', 35, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0),
('paladin_9', 'paladin', 'Represailles', 'Renvoie 10% des degats recus', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9, 10, 0, 0),
('paladin_10', 'paladin', 'Frappe rapide', '-1 cooldown sur Frappe vertueuse', NULL, 34, 1, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0),
('paladin_11', 'paladin', 'Armure renforcee', '+3 def physique, +3 res magique', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 3, 0, 0, 0, 0, 0, 11, 0, 0, 0),
('paladin_12', 'paladin', 'Bouclier etendu', 'Bouclier de foi dure +1 tour', NULL, 35, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12, 0, 0, 0),
('paladin_13', 'paladin', 'Charge heroique', 'Premier coup: +50% degats', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13, 0, 0, 0),
('paladin_14', 'paladin', 'Equilibre parfait', '+2 STR, +2 DEX, +2 INT', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 2, 2, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14, 0, 0, 0),
('paladin_15', 'paladin', 'Aura de courage', 'Immunite a la Terreur', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15, 0, 0, 0),
('paladin_16', 'paladin', 'Coup devastateur', '+15% de chance de critique', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, 0),
('paladin_17', 'paladin', 'Recuperation', 'Regenere 3 HP par tour', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 17, 0, 0, 0),
('paladin_18', 'paladin', 'Fureur controlee', 'Sous 50% HP, +20% degats', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18, 0, 0, 0),
('paladin_19', 'paladin', 'Bouclier sacre', 'Bouclier de foi coute -3 mana', NULL, 35, 0, 3, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 19, 0, 0, 0),
('paladin_20', 'paladin', 'Dernier rempart', 'A 1 HP, invincibilite 1 tour (1x/combat)', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20, 0, 0, 0),
('paladin_21', 'paladin', 'Champion divin', '+15% degats phys, +15% reduction degats', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15, 0, 0, 0, 0, 21, 0, 0, 0),
('paladin_22', 'paladin', 'Vengeance divine', 'Quand vous bloquez, contre-attaque 100% degats', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 22, 0, 0, 0),
('paladin_23', 'paladin', 'Guerrier celeste', '+5 STR, +10% reduction degats, +10% critique', NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, 5, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, 0, 0, 23, 0, 0, 0)
ON DUPLICATE KEY UPDATE name = VALUES(name), spell_id = VALUES(spell_id);
