Posted: 06 Jul 2005, 10:14
Et pour les prix (ce sont juste des regroupements ainsi que quelques corrections de syntaxe mes 2 posts là)
Code: Select all
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Watery War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Dusty War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Heated War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Icy War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Icy Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Heated Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Dusty Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Watery Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Ashen Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vacuous Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 4, Copper = 80 WHERE Name = "Raw Finesse War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 4, Copper = 80 WHERE Name = "Raw Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 4, Copper = 80 WHERE Name = "Raw Brilliant Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Watery War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Fiery War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Dusty War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Heated War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Earthen War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Airy War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Vapor War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Icy War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Earthen Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Icy Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Fiery Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Airy Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Heated Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Dusty Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Vapor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Watery Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Ashen Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Vacuous Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 29, Copper = 40 WHERE Name = "Uncut Finesse War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 29, Copper = 40 WHERE Name = "Uncut Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 29, Copper = 40 WHERE Name = "Uncut Brilliant Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Watery War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Fiery War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Dusty War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Heated War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Earthen War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Airy War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Vapor War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Icy War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Earthen Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Icy Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Fiery Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Airy Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Heated Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Dusty Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Vapor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Watery Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Ashen Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Vacuous Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 20, Copper = 60 WHERE Name = "Rough Finesse War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 20, Copper = 60 WHERE Name = "Rough Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 20, Copper = 60 WHERE Name = "Rough Brilliant Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Watery War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Fiery War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Dusty War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Heated War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Earthen War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Airy War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Vapor War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Icy War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Earthen Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Icy Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Fiery Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Airy Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Heated Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Dusty Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Vapor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Watery Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Ashen Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Vacuous Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 22, Copper = 40 WHERE Name = "Flawed Finesse War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 22, Copper = 40 WHERE Name = "Flawed Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 22, Copper = 40 WHERE Name = "Flawed Brilliant Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Watery War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Fiery War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Dusty War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Heated War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Earthen War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Airy War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Vapor War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Icy War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Earthen Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Icy Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Fiery Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Airy Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Heated Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Dusty Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Vapor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Watery Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Ashen Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Vacuous Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 12, Silver = 10, Copper = 20 WHERE Name = "Imperfect Finesse War Sigil";
UPDATE itemtemplate SET Gold = 12, Silver = 10, Copper = 20 WHERE Name = "Imperfect Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 12, Silver = 10, Copper = 20 WHERE Name = "Imperfect Brilliant Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Watery War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Fiery War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Dusty War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Heated War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Earthen War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Airy War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Vapor War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Icy War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Earthen Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Icy Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Fiery Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Airy Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Heated Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Dusty Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Vapor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Watery Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Ashen Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Vacuous Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 26, Silver = 78, Copper = 40 WHERE Name = "Polished Finesse War Sigil";
UPDATE itemtemplate SET Gold = 26, Silver = 78, Copper = 40 WHERE Name = "Polished Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 26, Silver = 78, Copper = 40 WHERE Name = "Polished Brilliant Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Watery War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Fiery War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Dusty War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Heated War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Earthen War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Airy War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Vapor War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Icy War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Earthen Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Icy Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Fiery Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Airy Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Heated Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Dusty Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Vapor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Watery Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Ashen Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Vacuous Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 40, Silver = 00, Copper = 80 WHERE Name = "Faceted Finesse War Sigil";
UPDATE itemtemplate SET Gold = 40, Silver = 00, Copper = 80 WHERE Name = "Faceted Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 40, Silver = 00, Copper = 80 WHERE Name = "Faceted Brilliant Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Watery War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Fiery War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Dusty War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Heated War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Earthen War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Airy War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Vapor War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Icy War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Earthen Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Icy Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Fiery Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Airy Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Heated Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Dusty Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Vapor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Watery Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Ashen Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Vacuous Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 59, Silver = 80, Copper = 20 WHERE Name = "Precious Finesse War Sigil";
UPDATE itemtemplate SET Gold = 59, Silver = 80, Copper = 20 WHERE Name = "Precious Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 59, Silver = 80, Copper = 20 WHERE Name = "Precious Brilliant Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Watery War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Fiery War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Dusty War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Heated War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Earthen War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Airy War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Vapor War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Icy War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Earthen Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Icy Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Fiery Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Airy Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Heated Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Dusty Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Vapor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Watery Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Ashen Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Vacuous Sigil";