-- =====================================================
-- MIGRATION: Ajout des armes Tier 2 et Tier 3 + Rééquilibrage Tier 1
-- =====================================================
-- Structure des IDs:
--   X00-X09: Tier 1 (+0 à +9)
--   X10-X19: Tier 2 (+0 à +9)
--   X20-X29: Tier 3 (+0 à +9)
-- Catégories:
--   100: Sword, 200: Axe, 300: Hammer, 400: Bow
--   500: Daggers, 600: Spear, 700: Staff, 800: Orb, 900: Tome
-- =====================================================

-- Supprimer les anciennes armes de joueur (garder 0-3 pour monstres)
DELETE FROM weapons WHERE id >= 100;

-- =====================================================
-- TIER 1 - Niveau requis 1, Prix de base 100
-- Dégâts de base: 4-6 (varie selon type d'arme)
-- Prix: 100, 120, 145, 175, 210, 260, 320, 400, 500, 650
-- =====================================================

INSERT INTO weapons (id, name, category, tier, rarity, damage_type, strength_scaling, dexterity_scaling, intelligence_scaling, required_level, sell_price, min_damage, max_damage, crit_chance_min, crit_chance_max, crit_damage_min, crit_damage_max, pierce_chance_min, pierce_chance_max, life_steal_min, life_steal_max, mana_steal_min, mana_steal_max, attack_speed_min, attack_speed_max) VALUES
-- =====================================================
-- EPEES Tier 1 (100-109) - Équilibrée, polyvalente
-- =====================================================
(100, 'Épée rouillée', 'Sword', 1, 0, 'Physical', 2, 1, 1, 1, 100, 5, 7, 5, 10, 15, 25, 3, 8, 2, 5, 0, 0, 0.95, 1.05),
(101, 'Épée rouillée +1', 'Sword', 1, 0, 'Physical', 2, 1, 1, 1, 120, 6, 8, 5, 10, 15, 25, 3, 8, 2, 5, 0, 0, 0.95, 1.05),
(102, 'Épée rouillée +2', 'Sword', 1, 0, 'Physical', 2, 1, 1, 1, 145, 7, 9, 5, 10, 15, 25, 3, 8, 2, 5, 0, 0, 0.95, 1.05),
(103, 'Épée rouillée +3', 'Sword', 1, 0, 'Physical', 2, 1, 1, 1, 175, 8, 10, 5, 10, 15, 25, 3, 8, 2, 5, 0, 0, 0.95, 1.05),
(104, 'Épée rouillée +4', 'Sword', 1, 0, 'Physical', 2, 1, 1, 1, 210, 9, 11, 5, 10, 15, 25, 3, 8, 2, 5, 0, 0, 0.95, 1.05),
(105, 'Épée rouillée +5', 'Sword', 1, 0, 'Physical', 2, 1, 1, 1, 260, 10, 13, 5, 10, 15, 25, 3, 8, 2, 5, 0, 0, 0.95, 1.05),
(106, 'Épée rouillée +6', 'Sword', 1, 0, 'Physical', 2, 1, 1, 1, 320, 11, 14, 5, 10, 15, 25, 3, 8, 2, 5, 0, 0, 0.95, 1.05),
(107, 'Épée rouillée +7', 'Sword', 1, 0, 'Physical', 2, 1, 1, 1, 400, 13, 16, 5, 10, 15, 25, 3, 8, 2, 5, 0, 0, 0.95, 1.05),
(108, 'Épée rouillée +8', 'Sword', 1, 0, 'Physical', 2, 1, 1, 1, 500, 14, 18, 5, 10, 15, 25, 3, 8, 2, 5, 0, 0, 0.95, 1.05),
(109, 'Épée rouillée +9', 'Sword', 1, 0, 'Physical', 2, 1, 1, 1, 650, 16, 20, 5, 10, 15, 25, 3, 8, 2, 5, 0, 0, 0.95, 1.05),

-- =====================================================
-- HACHES Tier 1 (200-209) - Gros dégâts, lente, crit damage
-- =====================================================
(200, 'Hache de bûcheron', 'Axe', 1, 0, 'Physical', 4, 0, 0, 1, 100, 7, 9, 3, 6, 25, 45, 2, 5, 0, 0, 0, 0, 0.75, 0.85),
(201, 'Hache de bûcheron +1', 'Axe', 1, 0, 'Physical', 4, 0, 0, 1, 120, 8, 10, 3, 6, 25, 45, 2, 5, 0, 0, 0, 0, 0.75, 0.85),
(202, 'Hache de bûcheron +2', 'Axe', 1, 0, 'Physical', 4, 0, 0, 1, 145, 9, 12, 3, 6, 25, 45, 2, 5, 0, 0, 0, 0, 0.75, 0.85),
(203, 'Hache de bûcheron +3', 'Axe', 1, 0, 'Physical', 4, 0, 0, 1, 175, 10, 13, 3, 6, 25, 45, 2, 5, 0, 0, 0, 0, 0.75, 0.85),
(204, 'Hache de bûcheron +4', 'Axe', 1, 0, 'Physical', 4, 0, 0, 1, 210, 12, 15, 3, 6, 25, 45, 2, 5, 0, 0, 0, 0, 0.75, 0.85),
(205, 'Hache de bûcheron +5', 'Axe', 1, 0, 'Physical', 4, 0, 0, 1, 260, 13, 17, 3, 6, 25, 45, 2, 5, 0, 0, 0, 0, 0.75, 0.85),
(206, 'Hache de bûcheron +6', 'Axe', 1, 0, 'Physical', 4, 0, 0, 1, 320, 15, 19, 3, 6, 25, 45, 2, 5, 0, 0, 0, 0, 0.75, 0.85),
(207, 'Hache de bûcheron +7', 'Axe', 1, 0, 'Physical', 4, 0, 0, 1, 400, 17, 21, 3, 6, 25, 45, 2, 5, 0, 0, 0, 0, 0.75, 0.85),
(208, 'Hache de bûcheron +8', 'Axe', 1, 0, 'Physical', 4, 0, 0, 1, 500, 19, 24, 3, 6, 25, 45, 2, 5, 0, 0, 0, 0, 0.75, 0.85),
(209, 'Hache de bûcheron +9', 'Axe', 1, 0, 'Physical', 4, 0, 0, 1, 650, 21, 27, 3, 6, 25, 45, 2, 5, 0, 0, 0, 0, 0.75, 0.85),

-- =====================================================
-- MARTEAUX Tier 1 (300-309) - Très lent, très gros dégâts, mana steal
-- =====================================================
(300, 'Marteau de guerre', 'Hammer', 1, 0, 'Physical', 3, 0, 1, 1, 100, 8, 11, 2, 4, 20, 35, 0, 3, 0, 0, 3, 6, 0.65, 0.75),
(301, 'Marteau de guerre +1', 'Hammer', 1, 0, 'Physical', 3, 0, 1, 1, 120, 9, 13, 2, 4, 20, 35, 0, 3, 0, 0, 3, 6, 0.65, 0.75),
(302, 'Marteau de guerre +2', 'Hammer', 1, 0, 'Physical', 3, 0, 1, 1, 145, 11, 15, 2, 4, 20, 35, 0, 3, 0, 0, 3, 6, 0.65, 0.75),
(303, 'Marteau de guerre +3', 'Hammer', 1, 0, 'Physical', 3, 0, 1, 1, 175, 12, 17, 2, 4, 20, 35, 0, 3, 0, 0, 3, 6, 0.65, 0.75),
(304, 'Marteau de guerre +4', 'Hammer', 1, 0, 'Physical', 3, 0, 1, 1, 210, 14, 19, 2, 4, 20, 35, 0, 3, 0, 0, 3, 6, 0.65, 0.75),
(305, 'Marteau de guerre +5', 'Hammer', 1, 0, 'Physical', 3, 0, 1, 1, 260, 16, 21, 2, 4, 20, 35, 0, 3, 0, 0, 3, 6, 0.65, 0.75),
(306, 'Marteau de guerre +6', 'Hammer', 1, 0, 'Physical', 3, 0, 1, 1, 320, 18, 24, 2, 4, 20, 35, 0, 3, 0, 0, 3, 6, 0.65, 0.75),
(307, 'Marteau de guerre +7', 'Hammer', 1, 0, 'Physical', 3, 0, 1, 1, 400, 20, 27, 2, 4, 20, 35, 0, 3, 0, 0, 3, 6, 0.65, 0.75),
(308, 'Marteau de guerre +8', 'Hammer', 1, 0, 'Physical', 3, 0, 1, 1, 500, 23, 30, 2, 4, 20, 35, 0, 3, 0, 0, 3, 6, 0.65, 0.75),
(309, 'Marteau de guerre +9', 'Hammer', 1, 0, 'Physical', 3, 0, 1, 1, 650, 26, 34, 2, 4, 20, 35, 0, 3, 0, 0, 3, 6, 0.65, 0.75),

-- =====================================================
-- ARCS Tier 1 (400-409) - Rapide, dégâts moyens, pierce
-- =====================================================
(400, 'Arc de chasse', 'Bow', 1, 0, 'Physical', 0, 3, 1, 1, 100, 4, 6, 4, 8, 15, 25, 5, 12, 0, 0, 0, 0, 1.10, 1.25),
(401, 'Arc de chasse +1', 'Bow', 1, 0, 'Physical', 0, 3, 1, 1, 120, 5, 7, 4, 8, 15, 25, 5, 12, 0, 0, 0, 0, 1.10, 1.25),
(402, 'Arc de chasse +2', 'Bow', 1, 0, 'Physical', 0, 3, 1, 1, 145, 5, 8, 4, 8, 15, 25, 5, 12, 0, 0, 0, 0, 1.10, 1.25),
(403, 'Arc de chasse +3', 'Bow', 1, 0, 'Physical', 0, 3, 1, 1, 175, 6, 9, 4, 8, 15, 25, 5, 12, 0, 0, 0, 0, 1.10, 1.25),
(404, 'Arc de chasse +4', 'Bow', 1, 0, 'Physical', 0, 3, 1, 1, 210, 7, 10, 4, 8, 15, 25, 5, 12, 0, 0, 0, 0, 1.10, 1.25),
(405, 'Arc de chasse +5', 'Bow', 1, 0, 'Physical', 0, 3, 1, 1, 260, 8, 11, 4, 8, 15, 25, 5, 12, 0, 0, 0, 0, 1.10, 1.25),
(406, 'Arc de chasse +6', 'Bow', 1, 0, 'Physical', 0, 3, 1, 1, 320, 9, 12, 4, 8, 15, 25, 5, 12, 0, 0, 0, 0, 1.10, 1.25),
(407, 'Arc de chasse +7', 'Bow', 1, 0, 'Physical', 0, 3, 1, 1, 400, 10, 14, 4, 8, 15, 25, 5, 12, 0, 0, 0, 0, 1.10, 1.25),
(408, 'Arc de chasse +8', 'Bow', 1, 0, 'Physical', 0, 3, 1, 1, 500, 11, 15, 4, 8, 15, 25, 5, 12, 0, 0, 0, 0, 1.10, 1.25),
(409, 'Arc de chasse +9', 'Bow', 1, 0, 'Physical', 0, 3, 1, 1, 650, 13, 17, 4, 8, 15, 25, 5, 12, 0, 0, 0, 0, 1.10, 1.25),

-- =====================================================
-- DAGUES Tier 1 (500-509) - Très rapide, faibles dégâts, crit + life steal
-- =====================================================
(500, 'Dague sanglante', 'Daggers', 1, 0, 'Physical', 1, 3, 0, 1, 100, 3, 5, 8, 15, 20, 35, 5, 10, 3, 7, 0, 0, 1.35, 1.50),
(501, 'Dague sanglante +1', 'Daggers', 1, 0, 'Physical', 1, 3, 0, 1, 120, 4, 5, 8, 15, 20, 35, 5, 10, 3, 7, 0, 0, 1.35, 1.50),
(502, 'Dague sanglante +2', 'Daggers', 1, 0, 'Physical', 1, 3, 0, 1, 145, 4, 6, 8, 15, 20, 35, 5, 10, 3, 7, 0, 0, 1.35, 1.50),
(503, 'Dague sanglante +3', 'Daggers', 1, 0, 'Physical', 1, 3, 0, 1, 175, 5, 7, 8, 15, 20, 35, 5, 10, 3, 7, 0, 0, 1.35, 1.50),
(504, 'Dague sanglante +4', 'Daggers', 1, 0, 'Physical', 1, 3, 0, 1, 210, 5, 8, 8, 15, 20, 35, 5, 10, 3, 7, 0, 0, 1.35, 1.50),
(505, 'Dague sanglante +5', 'Daggers', 1, 0, 'Physical', 1, 3, 0, 1, 260, 6, 9, 8, 15, 20, 35, 5, 10, 3, 7, 0, 0, 1.35, 1.50),
(506, 'Dague sanglante +6', 'Daggers', 1, 0, 'Physical', 1, 3, 0, 1, 320, 7, 10, 8, 15, 20, 35, 5, 10, 3, 7, 0, 0, 1.35, 1.50),
(507, 'Dague sanglante +7', 'Daggers', 1, 0, 'Physical', 1, 3, 0, 1, 400, 8, 11, 8, 15, 20, 35, 5, 10, 3, 7, 0, 0, 1.35, 1.50),
(508, 'Dague sanglante +8', 'Daggers', 1, 0, 'Physical', 1, 3, 0, 1, 500, 9, 12, 8, 15, 20, 35, 5, 10, 3, 7, 0, 0, 1.35, 1.50),
(509, 'Dague sanglante +9', 'Daggers', 1, 0, 'Physical', 1, 3, 0, 1, 650, 10, 14, 8, 15, 20, 35, 5, 10, 3, 7, 0, 0, 1.35, 1.50),

-- =====================================================
-- LANCES Tier 1 (600-609) - Rapide, pierce élevé, mana steal
-- =====================================================
(600, 'Lance empoisonnée', 'Spear', 1, 0, 'Physical', 0, 4, 0, 1, 100, 4, 6, 5, 10, 12, 22, 8, 15, 0, 0, 2, 5, 1.15, 1.30),
(601, 'Lance empoisonnée +1', 'Spear', 1, 0, 'Physical', 0, 4, 0, 1, 120, 5, 7, 5, 10, 12, 22, 8, 15, 0, 0, 2, 5, 1.15, 1.30),
(602, 'Lance empoisonnée +2', 'Spear', 1, 0, 'Physical', 0, 4, 0, 1, 145, 5, 8, 5, 10, 12, 22, 8, 15, 0, 0, 2, 5, 1.15, 1.30),
(603, 'Lance empoisonnée +3', 'Spear', 1, 0, 'Physical', 0, 4, 0, 1, 175, 6, 9, 5, 10, 12, 22, 8, 15, 0, 0, 2, 5, 1.15, 1.30),
(604, 'Lance empoisonnée +4', 'Spear', 1, 0, 'Physical', 0, 4, 0, 1, 210, 7, 10, 5, 10, 12, 22, 8, 15, 0, 0, 2, 5, 1.15, 1.30),
(605, 'Lance empoisonnée +5', 'Spear', 1, 0, 'Physical', 0, 4, 0, 1, 260, 8, 11, 5, 10, 12, 22, 8, 15, 0, 0, 2, 5, 1.15, 1.30),
(606, 'Lance empoisonnée +6', 'Spear', 1, 0, 'Physical', 0, 4, 0, 1, 320, 9, 12, 5, 10, 12, 22, 8, 15, 0, 0, 2, 5, 1.15, 1.30),
(607, 'Lance empoisonnée +7', 'Spear', 1, 0, 'Physical', 0, 4, 0, 1, 400, 10, 13, 5, 10, 12, 22, 8, 15, 0, 0, 2, 5, 1.15, 1.30),
(608, 'Lance empoisonnée +8', 'Spear', 1, 0, 'Physical', 0, 4, 0, 1, 500, 11, 15, 5, 10, 12, 22, 8, 15, 0, 0, 2, 5, 1.15, 1.30),
(609, 'Lance empoisonnée +9', 'Spear', 1, 0, 'Physical', 0, 4, 0, 1, 650, 13, 17, 5, 10, 12, 22, 8, 15, 0, 0, 2, 5, 1.15, 1.30),

-- =====================================================
-- BATONS Tier 1 (700-709) - Magique, moyen, crit damage + mana steal
-- =====================================================
(700, 'Bâton d''arcaniste', 'Staff', 1, 0, 'Magical', 1, 0, 3, 1, 100, 4, 6, 3, 6, 20, 35, 0, 3, 0, 0, 4, 8, 0.95, 1.10),
(701, 'Bâton d''arcaniste +1', 'Staff', 1, 0, 'Magical', 1, 0, 3, 1, 120, 5, 7, 3, 6, 20, 35, 0, 3, 0, 0, 4, 8, 0.95, 1.10),
(702, 'Bâton d''arcaniste +2', 'Staff', 1, 0, 'Magical', 1, 0, 3, 1, 145, 5, 8, 3, 6, 20, 35, 0, 3, 0, 0, 4, 8, 0.95, 1.10),
(703, 'Bâton d''arcaniste +3', 'Staff', 1, 0, 'Magical', 1, 0, 3, 1, 175, 6, 9, 3, 6, 20, 35, 0, 3, 0, 0, 4, 8, 0.95, 1.10),
(704, 'Bâton d''arcaniste +4', 'Staff', 1, 0, 'Magical', 1, 0, 3, 1, 210, 7, 10, 3, 6, 20, 35, 0, 3, 0, 0, 4, 8, 0.95, 1.10),
(705, 'Bâton d''arcaniste +5', 'Staff', 1, 0, 'Magical', 1, 0, 3, 1, 260, 8, 11, 3, 6, 20, 35, 0, 3, 0, 0, 4, 8, 0.95, 1.10),
(706, 'Bâton d''arcaniste +6', 'Staff', 1, 0, 'Magical', 1, 0, 3, 1, 320, 9, 12, 3, 6, 20, 35, 0, 3, 0, 0, 4, 8, 0.95, 1.10),
(707, 'Bâton d''arcaniste +7', 'Staff', 1, 0, 'Magical', 1, 0, 3, 1, 400, 10, 14, 3, 6, 20, 35, 0, 3, 0, 0, 4, 8, 0.95, 1.10),
(708, 'Bâton d''arcaniste +8', 'Staff', 1, 0, 'Magical', 1, 0, 3, 1, 500, 11, 15, 3, 6, 20, 35, 0, 3, 0, 0, 4, 8, 0.95, 1.10),
(709, 'Bâton d''arcaniste +9', 'Staff', 1, 0, 'Magical', 1, 0, 3, 1, 650, 13, 17, 3, 6, 20, 35, 0, 3, 0, 0, 4, 8, 0.95, 1.10),

-- =====================================================
-- ORBES Tier 1 (800-809) - Magique, rapide, life steal
-- =====================================================
(800, 'Orbe d''argent', 'Orb', 1, 0, 'Magical', 0, 1, 3, 1, 100, 4, 6, 4, 8, 15, 28, 3, 8, 3, 6, 0, 0, 1.20, 1.35),
(801, 'Orbe d''argent +1', 'Orb', 1, 0, 'Magical', 0, 1, 3, 1, 120, 4, 7, 4, 8, 15, 28, 3, 8, 3, 6, 0, 0, 1.20, 1.35),
(802, 'Orbe d''argent +2', 'Orb', 1, 0, 'Magical', 0, 1, 3, 1, 145, 5, 8, 4, 8, 15, 28, 3, 8, 3, 6, 0, 0, 1.20, 1.35),
(803, 'Orbe d''argent +3', 'Orb', 1, 0, 'Magical', 0, 1, 3, 1, 175, 6, 9, 4, 8, 15, 28, 3, 8, 3, 6, 0, 0, 1.20, 1.35),
(804, 'Orbe d''argent +4', 'Orb', 1, 0, 'Magical', 0, 1, 3, 1, 210, 6, 10, 4, 8, 15, 28, 3, 8, 3, 6, 0, 0, 1.20, 1.35),
(805, 'Orbe d''argent +5', 'Orb', 1, 0, 'Magical', 0, 1, 3, 1, 260, 7, 11, 4, 8, 15, 28, 3, 8, 3, 6, 0, 0, 1.20, 1.35),
(806, 'Orbe d''argent +6', 'Orb', 1, 0, 'Magical', 0, 1, 3, 1, 320, 8, 12, 4, 8, 15, 28, 3, 8, 3, 6, 0, 0, 1.20, 1.35),
(807, 'Orbe d''argent +7', 'Orb', 1, 0, 'Magical', 0, 1, 3, 1, 400, 9, 13, 4, 8, 15, 28, 3, 8, 3, 6, 0, 0, 1.20, 1.35),
(808, 'Orbe d''argent +8', 'Orb', 1, 0, 'Magical', 0, 1, 3, 1, 500, 10, 14, 4, 8, 15, 28, 3, 8, 3, 6, 0, 0, 1.20, 1.35),
(809, 'Orbe d''argent +9', 'Orb', 1, 0, 'Magical', 0, 1, 3, 1, 650, 11, 16, 4, 8, 15, 28, 3, 8, 3, 6, 0, 0, 1.20, 1.35),

-- =====================================================
-- TOMES Tier 1 (900-909) - Magique, lent, très gros crit damage
-- =====================================================
(900, 'Tome des secrets', 'Tome', 1, 0, 'Magical', 0, 0, 4, 1, 100, 3, 5, 2, 5, 35, 60, 0, 2, 0, 0, 0, 0, 0.75, 0.85),
(901, 'Tome des secrets +1', 'Tome', 1, 0, 'Magical', 0, 0, 4, 1, 120, 4, 6, 2, 5, 35, 60, 0, 2, 0, 0, 0, 0, 0.75, 0.85),
(902, 'Tome des secrets +2', 'Tome', 1, 0, 'Magical', 0, 0, 4, 1, 145, 4, 7, 2, 5, 35, 60, 0, 2, 0, 0, 0, 0, 0.75, 0.85),
(903, 'Tome des secrets +3', 'Tome', 1, 0, 'Magical', 0, 0, 4, 1, 175, 5, 8, 2, 5, 35, 60, 0, 2, 0, 0, 0, 0, 0.75, 0.85),
(904, 'Tome des secrets +4', 'Tome', 1, 0, 'Magical', 0, 0, 4, 1, 210, 5, 9, 2, 5, 35, 60, 0, 2, 0, 0, 0, 0, 0.75, 0.85),
(905, 'Tome des secrets +5', 'Tome', 1, 0, 'Magical', 0, 0, 4, 1, 260, 6, 10, 2, 5, 35, 60, 0, 2, 0, 0, 0, 0, 0.75, 0.85),
(906, 'Tome des secrets +6', 'Tome', 1, 0, 'Magical', 0, 0, 4, 1, 320, 7, 11, 2, 5, 35, 60, 0, 2, 0, 0, 0, 0, 0.75, 0.85),
(907, 'Tome des secrets +7', 'Tome', 1, 0, 'Magical', 0, 0, 4, 1, 400, 8, 12, 2, 5, 35, 60, 0, 2, 0, 0, 0, 0, 0.75, 0.85),
(908, 'Tome des secrets +8', 'Tome', 1, 0, 'Magical', 0, 0, 4, 1, 500, 9, 14, 2, 5, 35, 60, 0, 2, 0, 0, 0, 0, 0.75, 0.85),
(909, 'Tome des secrets +9', 'Tome', 1, 0, 'Magical', 0, 0, 4, 1, 650, 10, 16, 2, 5, 35, 60, 0, 2, 0, 0, 0, 0, 0.75, 0.85),

-- =====================================================
-- TIER 2 - Niveau requis 3, Prix de base 250
-- Dégâts de base: ~1.6x Tier 1
-- Prix: 250, 300, 365, 440, 525, 650, 800, 1000, 1250, 1625
-- =====================================================

-- =====================================================
-- EPEES Tier 2 (110-119) - Épée d'acier
-- =====================================================
(110, 'Épée d''acier', 'Sword', 2, 0, 'Physical', 3, 1, 1, 3, 250, 9, 12, 6, 12, 18, 30, 4, 10, 3, 6, 0, 0, 0.95, 1.05),
(111, 'Épée d''acier +1', 'Sword', 2, 0, 'Physical', 3, 1, 1, 3, 300, 10, 14, 6, 12, 18, 30, 4, 10, 3, 6, 0, 0, 0.95, 1.05),
(112, 'Épée d''acier +2', 'Sword', 2, 0, 'Physical', 3, 1, 1, 3, 365, 12, 16, 6, 12, 18, 30, 4, 10, 3, 6, 0, 0, 0.95, 1.05),
(113, 'Épée d''acier +3', 'Sword', 2, 0, 'Physical', 3, 1, 1, 3, 440, 14, 18, 6, 12, 18, 30, 4, 10, 3, 6, 0, 0, 0.95, 1.05),
(114, 'Épée d''acier +4', 'Sword', 2, 0, 'Physical', 3, 1, 1, 3, 525, 16, 20, 6, 12, 18, 30, 4, 10, 3, 6, 0, 0, 0.95, 1.05),
(115, 'Épée d''acier +5', 'Sword', 2, 0, 'Physical', 3, 1, 1, 3, 650, 18, 23, 6, 12, 18, 30, 4, 10, 3, 6, 0, 0, 0.95, 1.05),
(116, 'Épée d''acier +6', 'Sword', 2, 0, 'Physical', 3, 1, 1, 3, 800, 20, 26, 6, 12, 18, 30, 4, 10, 3, 6, 0, 0, 0.95, 1.05),
(117, 'Épée d''acier +7', 'Sword', 2, 0, 'Physical', 3, 1, 1, 3, 1000, 23, 29, 6, 12, 18, 30, 4, 10, 3, 6, 0, 0, 0.95, 1.05),
(118, 'Épée d''acier +8', 'Sword', 2, 0, 'Physical', 3, 1, 1, 3, 1250, 26, 33, 6, 12, 18, 30, 4, 10, 3, 6, 0, 0, 0.95, 1.05),
(119, 'Épée d''acier +9', 'Sword', 2, 0, 'Physical', 3, 1, 1, 3, 1625, 29, 37, 6, 12, 18, 30, 4, 10, 3, 6, 0, 0, 0.95, 1.05),

-- =====================================================
-- HACHES Tier 2 (210-219) - Hache de fer noir
-- =====================================================
(210, 'Hache de fer noir', 'Axe', 2, 0, 'Physical', 4, 0, 0, 3, 250, 12, 16, 4, 8, 30, 55, 3, 7, 0, 0, 0, 0, 0.75, 0.85),
(211, 'Hache de fer noir +1', 'Axe', 2, 0, 'Physical', 4, 0, 0, 3, 300, 14, 18, 4, 8, 30, 55, 3, 7, 0, 0, 0, 0, 0.75, 0.85),
(212, 'Hache de fer noir +2', 'Axe', 2, 0, 'Physical', 4, 0, 0, 3, 365, 16, 21, 4, 8, 30, 55, 3, 7, 0, 0, 0, 0, 0.75, 0.85),
(213, 'Hache de fer noir +3', 'Axe', 2, 0, 'Physical', 4, 0, 0, 3, 440, 18, 24, 4, 8, 30, 55, 3, 7, 0, 0, 0, 0, 0.75, 0.85),
(214, 'Hache de fer noir +4', 'Axe', 2, 0, 'Physical', 4, 0, 0, 3, 525, 21, 27, 4, 8, 30, 55, 3, 7, 0, 0, 0, 0, 0.75, 0.85),
(215, 'Hache de fer noir +5', 'Axe', 2, 0, 'Physical', 4, 0, 0, 3, 650, 24, 31, 4, 8, 30, 55, 3, 7, 0, 0, 0, 0, 0.75, 0.85),
(216, 'Hache de fer noir +6', 'Axe', 2, 0, 'Physical', 4, 0, 0, 3, 800, 27, 35, 4, 8, 30, 55, 3, 7, 0, 0, 0, 0, 0.75, 0.85),
(217, 'Hache de fer noir +7', 'Axe', 2, 0, 'Physical', 4, 0, 0, 3, 1000, 31, 40, 4, 8, 30, 55, 3, 7, 0, 0, 0, 0, 0.75, 0.85),
(218, 'Hache de fer noir +8', 'Axe', 2, 0, 'Physical', 4, 0, 0, 3, 1250, 35, 45, 4, 8, 30, 55, 3, 7, 0, 0, 0, 0, 0.75, 0.85),
(219, 'Hache de fer noir +9', 'Axe', 2, 0, 'Physical', 4, 0, 0, 3, 1625, 39, 50, 4, 8, 30, 55, 3, 7, 0, 0, 0, 0, 0.75, 0.85),

-- =====================================================
-- MARTEAUX Tier 2 (310-319) - Masse d'armes
-- =====================================================
(310, 'Masse d''armes', 'Hammer', 2, 0, 'Physical', 3, 0, 1, 3, 250, 14, 19, 3, 5, 25, 42, 0, 4, 0, 0, 4, 8, 0.65, 0.75),
(311, 'Masse d''armes +1', 'Hammer', 2, 0, 'Physical', 3, 0, 1, 3, 300, 16, 22, 3, 5, 25, 42, 0, 4, 0, 0, 4, 8, 0.65, 0.75),
(312, 'Masse d''armes +2', 'Hammer', 2, 0, 'Physical', 3, 0, 1, 3, 365, 19, 25, 3, 5, 25, 42, 0, 4, 0, 0, 4, 8, 0.65, 0.75),
(313, 'Masse d''armes +3', 'Hammer', 2, 0, 'Physical', 3, 0, 1, 3, 440, 21, 28, 3, 5, 25, 42, 0, 4, 0, 0, 4, 8, 0.65, 0.75),
(314, 'Masse d''armes +4', 'Hammer', 2, 0, 'Physical', 3, 0, 1, 3, 525, 24, 32, 3, 5, 25, 42, 0, 4, 0, 0, 4, 8, 0.65, 0.75),
(315, 'Masse d''armes +5', 'Hammer', 2, 0, 'Physical', 3, 0, 1, 3, 650, 28, 37, 3, 5, 25, 42, 0, 4, 0, 0, 4, 8, 0.65, 0.75),
(316, 'Masse d''armes +6', 'Hammer', 2, 0, 'Physical', 3, 0, 1, 3, 800, 32, 42, 3, 5, 25, 42, 0, 4, 0, 0, 4, 8, 0.65, 0.75),
(317, 'Masse d''armes +7', 'Hammer', 2, 0, 'Physical', 3, 0, 1, 3, 1000, 36, 48, 3, 5, 25, 42, 0, 4, 0, 0, 4, 8, 0.65, 0.75),
(318, 'Masse d''armes +8', 'Hammer', 2, 0, 'Physical', 3, 0, 1, 3, 1250, 41, 54, 3, 5, 25, 42, 0, 4, 0, 0, 4, 8, 0.65, 0.75),
(319, 'Masse d''armes +9', 'Hammer', 2, 0, 'Physical', 3, 0, 1, 3, 1625, 47, 62, 3, 5, 25, 42, 0, 4, 0, 0, 4, 8, 0.65, 0.75),

-- =====================================================
-- ARCS Tier 2 (410-419) - Arc long
-- =====================================================
(410, 'Arc long', 'Bow', 2, 0, 'Physical', 0, 4, 1, 3, 250, 7, 10, 5, 10, 18, 30, 7, 15, 0, 0, 0, 0, 1.10, 1.25),
(411, 'Arc long +1', 'Bow', 2, 0, 'Physical', 0, 4, 1, 3, 300, 8, 12, 5, 10, 18, 30, 7, 15, 0, 0, 0, 0, 1.10, 1.25),
(412, 'Arc long +2', 'Bow', 2, 0, 'Physical', 0, 4, 1, 3, 365, 9, 13, 5, 10, 18, 30, 7, 15, 0, 0, 0, 0, 1.10, 1.25),
(413, 'Arc long +3', 'Bow', 2, 0, 'Physical', 0, 4, 1, 3, 440, 11, 15, 5, 10, 18, 30, 7, 15, 0, 0, 0, 0, 1.10, 1.25),
(414, 'Arc long +4', 'Bow', 2, 0, 'Physical', 0, 4, 1, 3, 525, 12, 17, 5, 10, 18, 30, 7, 15, 0, 0, 0, 0, 1.10, 1.25),
(415, 'Arc long +5', 'Bow', 2, 0, 'Physical', 0, 4, 1, 3, 650, 14, 19, 5, 10, 18, 30, 7, 15, 0, 0, 0, 0, 1.10, 1.25),
(416, 'Arc long +6', 'Bow', 2, 0, 'Physical', 0, 4, 1, 3, 800, 16, 22, 5, 10, 18, 30, 7, 15, 0, 0, 0, 0, 1.10, 1.25),
(417, 'Arc long +7', 'Bow', 2, 0, 'Physical', 0, 4, 1, 3, 1000, 18, 25, 5, 10, 18, 30, 7, 15, 0, 0, 0, 0, 1.10, 1.25),
(418, 'Arc long +8', 'Bow', 2, 0, 'Physical', 0, 4, 1, 3, 1250, 21, 28, 5, 10, 18, 30, 7, 15, 0, 0, 0, 0, 1.10, 1.25),
(419, 'Arc long +9', 'Bow', 2, 0, 'Physical', 0, 4, 1, 3, 1625, 24, 32, 5, 10, 18, 30, 7, 15, 0, 0, 0, 0, 1.10, 1.25),

-- =====================================================
-- DAGUES Tier 2 (510-519) - Lames jumelles
-- =====================================================
(510, 'Lames jumelles', 'Daggers', 2, 0, 'Physical', 1, 4, 0, 3, 250, 5, 8, 10, 18, 25, 42, 6, 12, 4, 8, 0, 0, 1.35, 1.50),
(511, 'Lames jumelles +1', 'Daggers', 2, 0, 'Physical', 1, 4, 0, 3, 300, 6, 9, 10, 18, 25, 42, 6, 12, 4, 8, 0, 0, 1.35, 1.50),
(512, 'Lames jumelles +2', 'Daggers', 2, 0, 'Physical', 1, 4, 0, 3, 365, 7, 10, 10, 18, 25, 42, 6, 12, 4, 8, 0, 0, 1.35, 1.50),
(513, 'Lames jumelles +3', 'Daggers', 2, 0, 'Physical', 1, 4, 0, 3, 440, 8, 12, 10, 18, 25, 42, 6, 12, 4, 8, 0, 0, 1.35, 1.50),
(514, 'Lames jumelles +4', 'Daggers', 2, 0, 'Physical', 1, 4, 0, 3, 525, 9, 13, 10, 18, 25, 42, 6, 12, 4, 8, 0, 0, 1.35, 1.50),
(515, 'Lames jumelles +5', 'Daggers', 2, 0, 'Physical', 1, 4, 0, 3, 650, 11, 15, 10, 18, 25, 42, 6, 12, 4, 8, 0, 0, 1.35, 1.50),
(516, 'Lames jumelles +6', 'Daggers', 2, 0, 'Physical', 1, 4, 0, 3, 800, 12, 17, 10, 18, 25, 42, 6, 12, 4, 8, 0, 0, 1.35, 1.50),
(517, 'Lames jumelles +7', 'Daggers', 2, 0, 'Physical', 1, 4, 0, 3, 1000, 14, 20, 10, 18, 25, 42, 6, 12, 4, 8, 0, 0, 1.35, 1.50),
(518, 'Lames jumelles +8', 'Daggers', 2, 0, 'Physical', 1, 4, 0, 3, 1250, 16, 23, 10, 18, 25, 42, 6, 12, 4, 8, 0, 0, 1.35, 1.50),
(519, 'Lames jumelles +9', 'Daggers', 2, 0, 'Physical', 1, 4, 0, 3, 1625, 18, 26, 10, 18, 25, 42, 6, 12, 4, 8, 0, 0, 1.35, 1.50),

-- =====================================================
-- LANCES Tier 2 (610-619) - Hallebarde
-- =====================================================
(610, 'Hallebarde', 'Spear', 2, 0, 'Physical', 0, 4, 0, 3, 250, 7, 10, 6, 12, 15, 28, 10, 18, 0, 0, 3, 6, 1.15, 1.30),
(611, 'Hallebarde +1', 'Spear', 2, 0, 'Physical', 0, 4, 0, 3, 300, 8, 12, 6, 12, 15, 28, 10, 18, 0, 0, 3, 6, 1.15, 1.30),
(612, 'Hallebarde +2', 'Spear', 2, 0, 'Physical', 0, 4, 0, 3, 365, 9, 13, 6, 12, 15, 28, 10, 18, 0, 0, 3, 6, 1.15, 1.30),
(613, 'Hallebarde +3', 'Spear', 2, 0, 'Physical', 0, 4, 0, 3, 440, 11, 15, 6, 12, 15, 28, 10, 18, 0, 0, 3, 6, 1.15, 1.30),
(614, 'Hallebarde +4', 'Spear', 2, 0, 'Physical', 0, 4, 0, 3, 525, 12, 17, 6, 12, 15, 28, 10, 18, 0, 0, 3, 6, 1.15, 1.30),
(615, 'Hallebarde +5', 'Spear', 2, 0, 'Physical', 0, 4, 0, 3, 650, 14, 19, 6, 12, 15, 28, 10, 18, 0, 0, 3, 6, 1.15, 1.30),
(616, 'Hallebarde +6', 'Spear', 2, 0, 'Physical', 0, 4, 0, 3, 800, 16, 22, 6, 12, 15, 28, 10, 18, 0, 0, 3, 6, 1.15, 1.30),
(617, 'Hallebarde +7', 'Spear', 2, 0, 'Physical', 0, 4, 0, 3, 1000, 18, 25, 6, 12, 15, 28, 10, 18, 0, 0, 3, 6, 1.15, 1.30),
(618, 'Hallebarde +8', 'Spear', 2, 0, 'Physical', 0, 4, 0, 3, 1250, 21, 28, 6, 12, 15, 28, 10, 18, 0, 0, 3, 6, 1.15, 1.30),
(619, 'Hallebarde +9', 'Spear', 2, 0, 'Physical', 0, 4, 0, 3, 1625, 24, 32, 6, 12, 15, 28, 10, 18, 0, 0, 3, 6, 1.15, 1.30),

-- =====================================================
-- BATONS Tier 2 (710-719) - Bâton de mage
-- =====================================================
(710, 'Bâton de mage', 'Staff', 2, 0, 'Magical', 1, 0, 4, 3, 250, 7, 10, 4, 8, 25, 42, 0, 4, 0, 0, 5, 10, 0.95, 1.10),
(711, 'Bâton de mage +1', 'Staff', 2, 0, 'Magical', 1, 0, 4, 3, 300, 8, 11, 4, 8, 25, 42, 0, 4, 0, 0, 5, 10, 0.95, 1.10),
(712, 'Bâton de mage +2', 'Staff', 2, 0, 'Magical', 1, 0, 4, 3, 365, 9, 13, 4, 8, 25, 42, 0, 4, 0, 0, 5, 10, 0.95, 1.10),
(713, 'Bâton de mage +3', 'Staff', 2, 0, 'Magical', 1, 0, 4, 3, 440, 11, 15, 4, 8, 25, 42, 0, 4, 0, 0, 5, 10, 0.95, 1.10),
(714, 'Bâton de mage +4', 'Staff', 2, 0, 'Magical', 1, 0, 4, 3, 525, 12, 17, 4, 8, 25, 42, 0, 4, 0, 0, 5, 10, 0.95, 1.10),
(715, 'Bâton de mage +5', 'Staff', 2, 0, 'Magical', 1, 0, 4, 3, 650, 14, 19, 4, 8, 25, 42, 0, 4, 0, 0, 5, 10, 0.95, 1.10),
(716, 'Bâton de mage +6', 'Staff', 2, 0, 'Magical', 1, 0, 4, 3, 800, 16, 22, 4, 8, 25, 42, 0, 4, 0, 0, 5, 10, 0.95, 1.10),
(717, 'Bâton de mage +7', 'Staff', 2, 0, 'Magical', 1, 0, 4, 3, 1000, 18, 25, 4, 8, 25, 42, 0, 4, 0, 0, 5, 10, 0.95, 1.10),
(718, 'Bâton de mage +8', 'Staff', 2, 0, 'Magical', 1, 0, 4, 3, 1250, 21, 28, 4, 8, 25, 42, 0, 4, 0, 0, 5, 10, 0.95, 1.10),
(719, 'Bâton de mage +9', 'Staff', 2, 0, 'Magical', 1, 0, 4, 3, 1625, 24, 32, 4, 8, 25, 42, 0, 4, 0, 0, 5, 10, 0.95, 1.10),

-- =====================================================
-- ORBES Tier 2 (810-819) - Orbe de feu
-- =====================================================
(810, 'Orbe de feu', 'Orb', 2, 0, 'Magical', 0, 1, 4, 3, 250, 6, 10, 5, 10, 18, 34, 4, 10, 4, 8, 0, 0, 1.20, 1.35),
(811, 'Orbe de feu +1', 'Orb', 2, 0, 'Magical', 0, 1, 4, 3, 300, 7, 11, 5, 10, 18, 34, 4, 10, 4, 8, 0, 0, 1.20, 1.35),
(812, 'Orbe de feu +2', 'Orb', 2, 0, 'Magical', 0, 1, 4, 3, 365, 8, 13, 5, 10, 18, 34, 4, 10, 4, 8, 0, 0, 1.20, 1.35),
(813, 'Orbe de feu +3', 'Orb', 2, 0, 'Magical', 0, 1, 4, 3, 440, 10, 15, 5, 10, 18, 34, 4, 10, 4, 8, 0, 0, 1.20, 1.35),
(814, 'Orbe de feu +4', 'Orb', 2, 0, 'Magical', 0, 1, 4, 3, 525, 11, 17, 5, 10, 18, 34, 4, 10, 4, 8, 0, 0, 1.20, 1.35),
(815, 'Orbe de feu +5', 'Orb', 2, 0, 'Magical', 0, 1, 4, 3, 650, 13, 19, 5, 10, 18, 34, 4, 10, 4, 8, 0, 0, 1.20, 1.35),
(816, 'Orbe de feu +6', 'Orb', 2, 0, 'Magical', 0, 1, 4, 3, 800, 15, 21, 5, 10, 18, 34, 4, 10, 4, 8, 0, 0, 1.20, 1.35),
(817, 'Orbe de feu +7', 'Orb', 2, 0, 'Magical', 0, 1, 4, 3, 1000, 17, 24, 5, 10, 18, 34, 4, 10, 4, 8, 0, 0, 1.20, 1.35),
(818, 'Orbe de feu +8', 'Orb', 2, 0, 'Magical', 0, 1, 4, 3, 1250, 19, 27, 5, 10, 18, 34, 4, 10, 4, 8, 0, 0, 1.20, 1.35),
(819, 'Orbe de feu +9', 'Orb', 2, 0, 'Magical', 0, 1, 4, 3, 1625, 22, 31, 5, 10, 18, 34, 4, 10, 4, 8, 0, 0, 1.20, 1.35),

-- =====================================================
-- TOMES Tier 2 (910-919) - Grimoire ancien
-- =====================================================
(910, 'Grimoire ancien', 'Tome', 2, 0, 'Magical', 0, 0, 4, 3, 250, 5, 9, 3, 6, 42, 72, 0, 3, 0, 0, 0, 0, 0.75, 0.85),
(911, 'Grimoire ancien +1', 'Tome', 2, 0, 'Magical', 0, 0, 4, 3, 300, 6, 10, 3, 6, 42, 72, 0, 3, 0, 0, 0, 0, 0.75, 0.85),
(912, 'Grimoire ancien +2', 'Tome', 2, 0, 'Magical', 0, 0, 4, 3, 365, 7, 12, 3, 6, 42, 72, 0, 3, 0, 0, 0, 0, 0.75, 0.85),
(913, 'Grimoire ancien +3', 'Tome', 2, 0, 'Magical', 0, 0, 4, 3, 440, 8, 14, 3, 6, 42, 72, 0, 3, 0, 0, 0, 0, 0.75, 0.85),
(914, 'Grimoire ancien +4', 'Tome', 2, 0, 'Magical', 0, 0, 4, 3, 525, 10, 16, 3, 6, 42, 72, 0, 3, 0, 0, 0, 0, 0.75, 0.85),
(915, 'Grimoire ancien +5', 'Tome', 2, 0, 'Magical', 0, 0, 4, 3, 650, 11, 18, 3, 6, 42, 72, 0, 3, 0, 0, 0, 0, 0.75, 0.85),
(916, 'Grimoire ancien +6', 'Tome', 2, 0, 'Magical', 0, 0, 4, 3, 800, 13, 20, 3, 6, 42, 72, 0, 3, 0, 0, 0, 0, 0.75, 0.85),
(917, 'Grimoire ancien +7', 'Tome', 2, 0, 'Magical', 0, 0, 4, 3, 1000, 15, 23, 3, 6, 42, 72, 0, 3, 0, 0, 0, 0, 0.75, 0.85),
(918, 'Grimoire ancien +8', 'Tome', 2, 0, 'Magical', 0, 0, 4, 3, 1250, 17, 26, 3, 6, 42, 72, 0, 3, 0, 0, 0, 0, 0.75, 0.85),
(919, 'Grimoire ancien +9', 'Tome', 2, 0, 'Magical', 0, 0, 4, 3, 1625, 19, 30, 3, 6, 42, 72, 0, 3, 0, 0, 0, 0, 0.75, 0.85),

-- =====================================================
-- TIER 3 - Niveau requis 5, Prix de base 500
-- Dégâts de base: ~1.6x Tier 2
-- Prix: 500, 600, 730, 880, 1050, 1300, 1600, 2000, 2500, 3250
-- =====================================================

-- =====================================================
-- EPEES Tier 3 (120-129) - Lame runique
-- =====================================================
(120, 'Lame runique', 'Sword', 3, 0, 'Physical', 3, 2, 1, 5, 500, 16, 21, 7, 14, 22, 36, 5, 12, 4, 8, 0, 0, 0.95, 1.05),
(121, 'Lame runique +1', 'Sword', 3, 0, 'Physical', 3, 2, 1, 5, 600, 18, 24, 7, 14, 22, 36, 5, 12, 4, 8, 0, 0, 0.95, 1.05),
(122, 'Lame runique +2', 'Sword', 3, 0, 'Physical', 3, 2, 1, 5, 730, 21, 28, 7, 14, 22, 36, 5, 12, 4, 8, 0, 0, 0.95, 1.05),
(123, 'Lame runique +3', 'Sword', 3, 0, 'Physical', 3, 2, 1, 5, 880, 24, 32, 7, 14, 22, 36, 5, 12, 4, 8, 0, 0, 0.95, 1.05),
(124, 'Lame runique +4', 'Sword', 3, 0, 'Physical', 3, 2, 1, 5, 1050, 28, 37, 7, 14, 22, 36, 5, 12, 4, 8, 0, 0, 0.95, 1.05),
(125, 'Lame runique +5', 'Sword', 3, 0, 'Physical', 3, 2, 1, 5, 1300, 32, 42, 7, 14, 22, 36, 5, 12, 4, 8, 0, 0, 0.95, 1.05),
(126, 'Lame runique +6', 'Sword', 3, 0, 'Physical', 3, 2, 1, 5, 1600, 36, 48, 7, 14, 22, 36, 5, 12, 4, 8, 0, 0, 0.95, 1.05),
(127, 'Lame runique +7', 'Sword', 3, 0, 'Physical', 3, 2, 1, 5, 2000, 41, 54, 7, 14, 22, 36, 5, 12, 4, 8, 0, 0, 0.95, 1.05),
(128, 'Lame runique +8', 'Sword', 3, 0, 'Physical', 3, 2, 1, 5, 2500, 47, 62, 7, 14, 22, 36, 5, 12, 4, 8, 0, 0, 0.95, 1.05),
(129, 'Lame runique +9', 'Sword', 3, 0, 'Physical', 3, 2, 1, 5, 3250, 53, 70, 7, 14, 22, 36, 5, 12, 4, 8, 0, 0, 0.95, 1.05),

-- =====================================================
-- HACHES Tier 3 (220-229) - Hache de bourreau
-- =====================================================
(220, 'Hache de bourreau', 'Axe', 3, 0, 'Physical', 5, 0, 0, 5, 500, 21, 28, 5, 10, 35, 65, 4, 9, 0, 0, 0, 0, 0.75, 0.85),
(221, 'Hache de bourreau +1', 'Axe', 3, 0, 'Physical', 5, 0, 0, 5, 600, 24, 32, 5, 10, 35, 65, 4, 9, 0, 0, 0, 0, 0.75, 0.85),
(222, 'Hache de bourreau +2', 'Axe', 3, 0, 'Physical', 5, 0, 0, 5, 730, 28, 37, 5, 10, 35, 65, 4, 9, 0, 0, 0, 0, 0.75, 0.85),
(223, 'Hache de bourreau +3', 'Axe', 3, 0, 'Physical', 5, 0, 0, 5, 880, 32, 42, 5, 10, 35, 65, 4, 9, 0, 0, 0, 0, 0.75, 0.85),
(224, 'Hache de bourreau +4', 'Axe', 3, 0, 'Physical', 5, 0, 0, 5, 1050, 37, 49, 5, 10, 35, 65, 4, 9, 0, 0, 0, 0, 0.75, 0.85),
(225, 'Hache de bourreau +5', 'Axe', 3, 0, 'Physical', 5, 0, 0, 5, 1300, 42, 56, 5, 10, 35, 65, 4, 9, 0, 0, 0, 0, 0.75, 0.85),
(226, 'Hache de bourreau +6', 'Axe', 3, 0, 'Physical', 5, 0, 0, 5, 1600, 48, 64, 5, 10, 35, 65, 4, 9, 0, 0, 0, 0, 0.75, 0.85),
(227, 'Hache de bourreau +7', 'Axe', 3, 0, 'Physical', 5, 0, 0, 5, 2000, 55, 73, 5, 10, 35, 65, 4, 9, 0, 0, 0, 0, 0.75, 0.85),
(228, 'Hache de bourreau +8', 'Axe', 3, 0, 'Physical', 5, 0, 0, 5, 2500, 63, 84, 5, 10, 35, 65, 4, 9, 0, 0, 0, 0, 0.75, 0.85),
(229, 'Hache de bourreau +9', 'Axe', 3, 0, 'Physical', 5, 0, 0, 5, 3250, 72, 96, 5, 10, 35, 65, 4, 9, 0, 0, 0, 0, 0.75, 0.85),

-- =====================================================
-- MARTEAUX Tier 3 (320-329) - Marteau de titan
-- =====================================================
(320, 'Marteau de titan', 'Hammer', 3, 0, 'Physical', 4, 0, 1, 5, 500, 24, 33, 4, 6, 30, 50, 0, 5, 0, 0, 5, 10, 0.65, 0.75),
(321, 'Marteau de titan +1', 'Hammer', 3, 0, 'Physical', 4, 0, 1, 5, 600, 28, 38, 4, 6, 30, 50, 0, 5, 0, 0, 5, 10, 0.65, 0.75),
(322, 'Marteau de titan +2', 'Hammer', 3, 0, 'Physical', 4, 0, 1, 5, 730, 32, 44, 4, 6, 30, 50, 0, 5, 0, 0, 5, 10, 0.65, 0.75),
(323, 'Marteau de titan +3', 'Hammer', 3, 0, 'Physical', 4, 0, 1, 5, 880, 37, 50, 4, 6, 30, 50, 0, 5, 0, 0, 5, 10, 0.65, 0.75),
(324, 'Marteau de titan +4', 'Hammer', 3, 0, 'Physical', 4, 0, 1, 5, 1050, 42, 57, 4, 6, 30, 50, 0, 5, 0, 0, 5, 10, 0.65, 0.75),
(325, 'Marteau de titan +5', 'Hammer', 3, 0, 'Physical', 4, 0, 1, 5, 1300, 49, 66, 4, 6, 30, 50, 0, 5, 0, 0, 5, 10, 0.65, 0.75),
(326, 'Marteau de titan +6', 'Hammer', 3, 0, 'Physical', 4, 0, 1, 5, 1600, 56, 76, 4, 6, 30, 50, 0, 5, 0, 0, 5, 10, 0.65, 0.75),
(327, 'Marteau de titan +7', 'Hammer', 3, 0, 'Physical', 4, 0, 1, 5, 2000, 64, 87, 4, 6, 30, 50, 0, 5, 0, 0, 5, 10, 0.65, 0.75),
(328, 'Marteau de titan +8', 'Hammer', 3, 0, 'Physical', 4, 0, 1, 5, 2500, 74, 100, 4, 6, 30, 50, 0, 5, 0, 0, 5, 10, 0.65, 0.75),
(329, 'Marteau de titan +9', 'Hammer', 3, 0, 'Physical', 4, 0, 1, 5, 3250, 85, 115, 4, 6, 30, 50, 0, 5, 0, 0, 5, 10, 0.65, 0.75),

-- =====================================================
-- ARCS Tier 3 (420-429) - Arc composite
-- =====================================================
(420, 'Arc composite', 'Bow', 3, 0, 'Physical', 0, 4, 1, 5, 500, 12, 17, 6, 12, 22, 36, 9, 18, 0, 0, 0, 0, 1.10, 1.25),
(421, 'Arc composite +1', 'Bow', 3, 0, 'Physical', 0, 4, 1, 5, 600, 14, 20, 6, 12, 22, 36, 9, 18, 0, 0, 0, 0, 1.10, 1.25),
(422, 'Arc composite +2', 'Bow', 3, 0, 'Physical', 0, 4, 1, 5, 730, 16, 23, 6, 12, 22, 36, 9, 18, 0, 0, 0, 0, 1.10, 1.25),
(423, 'Arc composite +3', 'Bow', 3, 0, 'Physical', 0, 4, 1, 5, 880, 19, 26, 6, 12, 22, 36, 9, 18, 0, 0, 0, 0, 1.10, 1.25),
(424, 'Arc composite +4', 'Bow', 3, 0, 'Physical', 0, 4, 1, 5, 1050, 22, 30, 6, 12, 22, 36, 9, 18, 0, 0, 0, 0, 1.10, 1.25),
(425, 'Arc composite +5', 'Bow', 3, 0, 'Physical', 0, 4, 1, 5, 1300, 25, 35, 6, 12, 22, 36, 9, 18, 0, 0, 0, 0, 1.10, 1.25),
(426, 'Arc composite +6', 'Bow', 3, 0, 'Physical', 0, 4, 1, 5, 1600, 29, 40, 6, 12, 22, 36, 9, 18, 0, 0, 0, 0, 1.10, 1.25),
(427, 'Arc composite +7', 'Bow', 3, 0, 'Physical', 0, 4, 1, 5, 2000, 33, 46, 6, 12, 22, 36, 9, 18, 0, 0, 0, 0, 1.10, 1.25),
(428, 'Arc composite +8', 'Bow', 3, 0, 'Physical', 0, 4, 1, 5, 2500, 38, 53, 6, 12, 22, 36, 9, 18, 0, 0, 0, 0, 1.10, 1.25),
(429, 'Arc composite +9', 'Bow', 3, 0, 'Physical', 0, 4, 1, 5, 3250, 44, 61, 6, 12, 22, 36, 9, 18, 0, 0, 0, 0, 1.10, 1.25),

-- =====================================================
-- DAGUES Tier 3 (520-529) - Crocs de vipère
-- =====================================================
(520, 'Crocs de vipère', 'Daggers', 3, 0, 'Physical', 1, 4, 0, 5, 500, 9, 14, 12, 22, 30, 50, 8, 15, 5, 10, 0, 0, 1.35, 1.50),
(521, 'Crocs de vipère +1', 'Daggers', 3, 0, 'Physical', 1, 4, 0, 5, 600, 10, 16, 12, 22, 30, 50, 8, 15, 5, 10, 0, 0, 1.35, 1.50),
(522, 'Crocs de vipère +2', 'Daggers', 3, 0, 'Physical', 1, 4, 0, 5, 730, 12, 18, 12, 22, 30, 50, 8, 15, 5, 10, 0, 0, 1.35, 1.50),
(523, 'Crocs de vipère +3', 'Daggers', 3, 0, 'Physical', 1, 4, 0, 5, 880, 14, 21, 12, 22, 30, 50, 8, 15, 5, 10, 0, 0, 1.35, 1.50),
(524, 'Crocs de vipère +4', 'Daggers', 3, 0, 'Physical', 1, 4, 0, 5, 1050, 16, 24, 12, 22, 30, 50, 8, 15, 5, 10, 0, 0, 1.35, 1.50),
(525, 'Crocs de vipère +5', 'Daggers', 3, 0, 'Physical', 1, 4, 0, 5, 1300, 19, 28, 12, 22, 30, 50, 8, 15, 5, 10, 0, 0, 1.35, 1.50),
(526, 'Crocs de vipère +6', 'Daggers', 3, 0, 'Physical', 1, 4, 0, 5, 1600, 22, 32, 12, 22, 30, 50, 8, 15, 5, 10, 0, 0, 1.35, 1.50),
(527, 'Crocs de vipère +7', 'Daggers', 3, 0, 'Physical', 1, 4, 0, 5, 2000, 25, 37, 12, 22, 30, 50, 8, 15, 5, 10, 0, 0, 1.35, 1.50),
(528, 'Crocs de vipère +8', 'Daggers', 3, 0, 'Physical', 1, 4, 0, 5, 2500, 29, 42, 12, 22, 30, 50, 8, 15, 5, 10, 0, 0, 1.35, 1.50),
(529, 'Crocs de vipère +9', 'Daggers', 3, 0, 'Physical', 1, 4, 0, 5, 3250, 33, 49, 12, 22, 30, 50, 8, 15, 5, 10, 0, 0, 1.35, 1.50),

-- =====================================================
-- LANCES Tier 3 (620-629) - Trident maudit
-- =====================================================
(620, 'Trident maudit', 'Spear', 3, 0, 'Physical', 0, 5, 0, 5, 500, 12, 17, 7, 14, 18, 34, 12, 22, 0, 0, 4, 8, 1.15, 1.30),
(621, 'Trident maudit +1', 'Spear', 3, 0, 'Physical', 0, 5, 0, 5, 600, 14, 20, 7, 14, 18, 34, 12, 22, 0, 0, 4, 8, 1.15, 1.30),
(622, 'Trident maudit +2', 'Spear', 3, 0, 'Physical', 0, 5, 0, 5, 730, 16, 23, 7, 14, 18, 34, 12, 22, 0, 0, 4, 8, 1.15, 1.30),
(623, 'Trident maudit +3', 'Spear', 3, 0, 'Physical', 0, 5, 0, 5, 880, 19, 26, 7, 14, 18, 34, 12, 22, 0, 0, 4, 8, 1.15, 1.30),
(624, 'Trident maudit +4', 'Spear', 3, 0, 'Physical', 0, 5, 0, 5, 1050, 22, 30, 7, 14, 18, 34, 12, 22, 0, 0, 4, 8, 1.15, 1.30),
(625, 'Trident maudit +5', 'Spear', 3, 0, 'Physical', 0, 5, 0, 5, 1300, 25, 35, 7, 14, 18, 34, 12, 22, 0, 0, 4, 8, 1.15, 1.30),
(626, 'Trident maudit +6', 'Spear', 3, 0, 'Physical', 0, 5, 0, 5, 1600, 29, 40, 7, 14, 18, 34, 12, 22, 0, 0, 4, 8, 1.15, 1.30),
(627, 'Trident maudit +7', 'Spear', 3, 0, 'Physical', 0, 5, 0, 5, 2000, 33, 46, 7, 14, 18, 34, 12, 22, 0, 0, 4, 8, 1.15, 1.30),
(628, 'Trident maudit +8', 'Spear', 3, 0, 'Physical', 0, 5, 0, 5, 2500, 38, 53, 7, 14, 18, 34, 12, 22, 0, 0, 4, 8, 1.15, 1.30),
(629, 'Trident maudit +9', 'Spear', 3, 0, 'Physical', 0, 5, 0, 5, 3250, 44, 61, 7, 14, 18, 34, 12, 22, 0, 0, 4, 8, 1.15, 1.30),

-- =====================================================
-- BATONS Tier 3 (720-729) - Bâton de l'archimage
-- =====================================================
(720, 'Bâton de l''archimage', 'Staff', 3, 0, 'Magical', 1, 0, 4, 5, 500, 12, 17, 5, 10, 30, 50, 0, 5, 0, 0, 6, 12, 0.95, 1.10),
(721, 'Bâton de l''archimage +1', 'Staff', 3, 0, 'Magical', 1, 0, 4, 5, 600, 14, 19, 5, 10, 30, 50, 0, 5, 0, 0, 6, 12, 0.95, 1.10),
(722, 'Bâton de l''archimage +2', 'Staff', 3, 0, 'Magical', 1, 0, 4, 5, 730, 16, 22, 5, 10, 30, 50, 0, 5, 0, 0, 6, 12, 0.95, 1.10),
(723, 'Bâton de l''archimage +3', 'Staff', 3, 0, 'Magical', 1, 0, 4, 5, 880, 18, 25, 5, 10, 30, 50, 0, 5, 0, 0, 6, 12, 0.95, 1.10),
(724, 'Bâton de l''archimage +4', 'Staff', 3, 0, 'Magical', 1, 0, 4, 5, 1050, 21, 29, 5, 10, 30, 50, 0, 5, 0, 0, 6, 12, 0.95, 1.10),
(725, 'Bâton de l''archimage +5', 'Staff', 3, 0, 'Magical', 1, 0, 4, 5, 1300, 24, 33, 5, 10, 30, 50, 0, 5, 0, 0, 6, 12, 0.95, 1.10),
(726, 'Bâton de l''archimage +6', 'Staff', 3, 0, 'Magical', 1, 0, 4, 5, 1600, 28, 38, 5, 10, 30, 50, 0, 5, 0, 0, 6, 12, 0.95, 1.10),
(727, 'Bâton de l''archimage +7', 'Staff', 3, 0, 'Magical', 1, 0, 4, 5, 2000, 32, 44, 5, 10, 30, 50, 0, 5, 0, 0, 6, 12, 0.95, 1.10),
(728, 'Bâton de l''archimage +8', 'Staff', 3, 0, 'Magical', 1, 0, 4, 5, 2500, 37, 50, 5, 10, 30, 50, 0, 5, 0, 0, 6, 12, 0.95, 1.10),
(729, 'Bâton de l''archimage +9', 'Staff', 3, 0, 'Magical', 1, 0, 4, 5, 3250, 42, 58, 5, 10, 30, 50, 0, 5, 0, 0, 6, 12, 0.95, 1.10),

-- =====================================================
-- ORBES Tier 3 (820-829) - Orbe des abysses
-- =====================================================
(820, 'Orbe des abysses', 'Orb', 3, 0, 'Magical', 0, 1, 4, 5, 500, 10, 16, 6, 12, 22, 40, 5, 12, 5, 10, 0, 0, 1.20, 1.35),
(821, 'Orbe des abysses +1', 'Orb', 3, 0, 'Magical', 0, 1, 4, 5, 600, 12, 18, 6, 12, 22, 40, 5, 12, 5, 10, 0, 0, 1.20, 1.35),
(822, 'Orbe des abysses +2', 'Orb', 3, 0, 'Magical', 0, 1, 4, 5, 730, 14, 21, 6, 12, 22, 40, 5, 12, 5, 10, 0, 0, 1.20, 1.35),
(823, 'Orbe des abysses +3', 'Orb', 3, 0, 'Magical', 0, 1, 4, 5, 880, 16, 24, 6, 12, 22, 40, 5, 12, 5, 10, 0, 0, 1.20, 1.35),
(824, 'Orbe des abysses +4', 'Orb', 3, 0, 'Magical', 0, 1, 4, 5, 1050, 19, 28, 6, 12, 22, 40, 5, 12, 5, 10, 0, 0, 1.20, 1.35),
(825, 'Orbe des abysses +5', 'Orb', 3, 0, 'Magical', 0, 1, 4, 5, 1300, 22, 32, 6, 12, 22, 40, 5, 12, 5, 10, 0, 0, 1.20, 1.35),
(826, 'Orbe des abysses +6', 'Orb', 3, 0, 'Magical', 0, 1, 4, 5, 1600, 25, 37, 6, 12, 22, 40, 5, 12, 5, 10, 0, 0, 1.20, 1.35),
(827, 'Orbe des abysses +7', 'Orb', 3, 0, 'Magical', 0, 1, 4, 5, 2000, 29, 42, 6, 12, 22, 40, 5, 12, 5, 10, 0, 0, 1.20, 1.35),
(828, 'Orbe des abysses +8', 'Orb', 3, 0, 'Magical', 0, 1, 4, 5, 2500, 33, 48, 6, 12, 22, 40, 5, 12, 5, 10, 0, 0, 1.20, 1.35),
(829, 'Orbe des abysses +9', 'Orb', 3, 0, 'Magical', 0, 1, 4, 5, 3250, 38, 55, 6, 12, 22, 40, 5, 12, 5, 10, 0, 0, 1.20, 1.35),

-- =====================================================
-- TOMES Tier 3 (920-929) - Codex interdit
-- =====================================================
(920, 'Codex interdit', 'Tome', 3, 0, 'Magical', 0, 0, 5, 5, 500, 9, 15, 4, 8, 50, 85, 0, 4, 0, 0, 0, 0, 0.75, 0.85),
(921, 'Codex interdit +1', 'Tome', 3, 0, 'Magical', 0, 0, 5, 5, 600, 10, 17, 4, 8, 50, 85, 0, 4, 0, 0, 0, 0, 0.75, 0.85),
(922, 'Codex interdit +2', 'Tome', 3, 0, 'Magical', 0, 0, 5, 5, 730, 12, 20, 4, 8, 50, 85, 0, 4, 0, 0, 0, 0, 0.75, 0.85),
(923, 'Codex interdit +3', 'Tome', 3, 0, 'Magical', 0, 0, 5, 5, 880, 14, 23, 4, 8, 50, 85, 0, 4, 0, 0, 0, 0, 0.75, 0.85),
(924, 'Codex interdit +4', 'Tome', 3, 0, 'Magical', 0, 0, 5, 5, 1050, 16, 26, 4, 8, 50, 85, 0, 4, 0, 0, 0, 0, 0.75, 0.85),
(925, 'Codex interdit +5', 'Tome', 3, 0, 'Magical', 0, 0, 5, 5, 1300, 19, 30, 4, 8, 50, 85, 0, 4, 0, 0, 0, 0, 0.75, 0.85),
(926, 'Codex interdit +6', 'Tome', 3, 0, 'Magical', 0, 0, 5, 5, 1600, 22, 35, 4, 8, 50, 85, 0, 4, 0, 0, 0, 0, 0.75, 0.85),
(927, 'Codex interdit +7', 'Tome', 3, 0, 'Magical', 0, 0, 5, 5, 2000, 25, 40, 4, 8, 50, 85, 0, 4, 0, 0, 0, 0, 0.75, 0.85),
(928, 'Codex interdit +8', 'Tome', 3, 0, 'Magical', 0, 0, 5, 5, 2500, 29, 46, 4, 8, 50, 85, 0, 4, 0, 0, 0, 0, 0.75, 0.85),
(929, 'Codex interdit +9', 'Tome', 3, 0, 'Magical', 0, 0, 5, 5, 3250, 33, 53, 4, 8, 50, 85, 0, 4, 0, 0, 0, 0, 0.75, 0.85)

ON DUPLICATE KEY UPDATE
    name = VALUES(name),
    tier = VALUES(tier),
    required_level = VALUES(required_level),
    sell_price = VALUES(sell_price),
    min_damage = VALUES(min_damage),
    max_damage = VALUES(max_damage),
    crit_chance_min = VALUES(crit_chance_min),
    crit_chance_max = VALUES(crit_chance_max),
    crit_damage_min = VALUES(crit_damage_min),
    crit_damage_max = VALUES(crit_damage_max),
    pierce_chance_min = VALUES(pierce_chance_min),
    pierce_chance_max = VALUES(pierce_chance_max),
    life_steal_min = VALUES(life_steal_min),
    life_steal_max = VALUES(life_steal_max),
    mana_steal_min = VALUES(mana_steal_min),
    mana_steal_max = VALUES(mana_steal_max),
    attack_speed_min = VALUES(attack_speed_min),
    attack_speed_max = VALUES(attack_speed_max);

-- Afficher le résumé
SELECT
    tier,
    category,
    COUNT(*) as total,
    MIN(min_damage) as min_dmg,
    MAX(max_damage) as max_dmg
FROM weapons
WHERE id >= 100
GROUP BY tier, category
ORDER BY tier, category;
