Aidez au developpement du craft !

Unread post by **Cossa** » 06 Jul 2005, 10:14

Et pour les prix (ce sont juste des regroupements ainsi que quelques corrections de syntaxe mes 2 posts là)

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";

Unread post by **Cossa** » 06 Jul 2005, 10:20

Code: Select all

UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 77, Silver = 61, Copper = 60 WHERE Name = "Flawless Finesse War Sigil";
UPDATE itemtemplate SET Gold = 77, Silver = 61, Copper = 60 WHERE Name = "Flawless Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 77, Silver = 61, Copper = 60 WHERE Name = "Flawless Brilliant Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Watery War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Fiery War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Dusty War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Heated War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Earthen War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Airy War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Vapor War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Icy War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Earthen Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Icy Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Fiery Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Airy Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Heated Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Dusty Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Vapor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Watery Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Ashen Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Vacuous Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 89, Silver = 22, Copper = 00 WHERE Name = "Perfect Finesse War Sigil";
UPDATE itemtemplate SET Gold = 89, Silver = 22, Copper = 00 WHERE Name = "Perfect Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 89, Silver = 22, Copper = 00 WHERE Name = "Perfect Brilliant Sigil"; 
UPDATE itemtemplate SET Gold = 0, Silver = 0, Copper = 9 WHERE Name = "bronze bracket";
UPDATE itemtemplate SET Gold = 0, Silver = 0, Copper = 18 WHERE Name = "bronze hinge";
UPDATE itemtemplate SET Gold = 0, Silver = 0, Copper = 9 WHERE Name = "bronze wrought jewelry box";
UPDATE itemtemplate SET Gold = 0, Silver = 0, Copper = 18 WHERE Name = "bronze small lantern";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 75 WHERE Name = "bronze gem-studded jewelry box";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 40 WHERE Name = "iron bracket";
UPDATE itemtemplate SET Gold = 0, Silver = 2, Copper = 80 WHERE Name = "iron hinge";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 40 WHERE Name = "iron wrought jewelry box";
UPDATE itemtemplate SET Gold = 0, Silver = 2, Copper = 80 WHERE Name = "iron small lantern";
UPDATE itemtemplate SET Gold = 0, Silver = 28, Copper = 00 WHERE Name = "iron gem-studded jewelry box";
UPDATE itemtemplate SET Gold = 0, Silver = 5, Copper = 60 WHERE Name = "steel bracket";
UPDATE itemtemplate SET Gold = 0, Silver = 11, Copper = 20 WHERE Name = "steel hinge";
UPDATE itemtemplate SET Gold = 0, Silver = 5, Copper = 60 WHERE Name = "steel wrought jewelry box";
UPDATE itemtemplate SET Gold = 0, Silver = 11, Copper = 20 WHERE Name = "steel small lantern";
UPDATE itemtemplate SET Gold = 1, Silver = 12, Copper = 00 WHERE Name = "steel gem-studded jewelry box";
UPDATE itemtemplate SET Gold = 0, Silver = 16, Copper = 80 WHERE Name = "alloy bracket";
UPDATE itemtemplate SET Gold = 0, Silver = 33, Copper = 60 WHERE Name = "alloy hinge";
UPDATE itemtemplate SET Gold = 0, Silver = 16, Copper = 80 WHERE Name = "alloy wrought jewelry box";
UPDATE itemtemplate SET Gold = 0, Silver = 33, Copper = 60 WHERE Name = "alloy small lantern";
UPDATE itemtemplate SET Gold = 3, Silver = 31, Copper = 20 WHERE Name = "alloy gem-studded jewelry box";
UPDATE itemtemplate SET Gold = 0, Silver = 50, Copper = 40 WHERE Name = "fine alloy bracket";
UPDATE itemtemplate SET Gold = 1, Silver = 0, Copper = 80 WHERE Name = "fine alloy hinge";
UPDATE itemtemplate SET Gold = 0, Silver = 50, Copper = 40 WHERE Name = "fine alloy wrought jewelry box";
UPDATE itemtemplate SET Gold = 1, Silver = 0, Copper = 80 WHERE Name = "fine alloy small lantern";
UPDATE itemtemplate SET Gold = 10, Silver = 8, Copper = 00 WHERE Name = "fine alloy gem-studded jewelry box";
UPDATE itemtemplate SET Gold = 1, Silver = 0, Copper = 80 WHERE Name = "mithril bracket";
UPDATE itemtemplate SET Gold = 2, Silver = 1, Copper = 60 WHERE Name = "mithril hinge";
UPDATE itemtemplate SET Gold = 1, Silver = 0, Copper = 80 WHERE Name = "mithril wrought jewelry box";
UPDATE itemtemplate SET Gold = 2, Silver = 1, Copper = 60 WHERE Name = "mithril small lantern";
UPDATE itemtemplate SET Gold = 20, Silver = 16, Copper = 0 WHERE Name = "mithril gem-studded jewelry box";
UPDATE itemtemplate SET Gold = 1, Silver = 51, Copper = 20 WHERE Name = "adamantium bracket";
UPDATE itemtemplate SET Gold = 3, Silver = 2, Copper = 40 WHERE Name = "adamantium hinge";
UPDATE itemtemplate SET Gold = 1, Silver = 51, Copper = 20 WHERE Name = "adamantium wrought jewelry box";
UPDATE itemtemplate SET Gold = 3, Silver = 2, Copper = 40 WHERE Name = "adamantium small lantern";
UPDATE itemtemplate SET Gold = 30, Silver = 20, Copper = 20 WHERE Name = "adamantium gem-studded jewelry box";
UPDATE itemtemplate SET Gold = 2, Silver = 26, Copper = 80 WHERE Name = "asterite bracket";
UPDATE itemtemplate SET Gold = 4, Silver = 53, Copper = 60 WHERE Name = "asterite hinge";
UPDATE itemtemplate SET Gold = 2, Silver = 26, Copper = 80 WHERE Name = "asterite wrought jewelry box";
UPDATE itemtemplate SET Gold = 4, Silver = 53, Copper = 60 WHERE Name = "asterite small lantern";
UPDATE itemtemplate SET Gold = 45, Silver = 36, Copper = 00 WHERE Name = "asterite gem-studded jewelry box";
UPDATE itemtemplate SET Gold = 3, Silver = 40, Copper = 20 WHERE Name = "netherium bracket";
UPDATE itemtemplate SET Gold = 6, Silver = 80, Copper = 40 WHERE Name = "netherium hinge";
UPDATE itemtemplate SET Gold = 3, Silver = 40, Copper = 20 WHERE Name = "netherium wrought jewelry box";
UPDATE itemtemplate SET Gold = 6, Silver = 80, Copper = 40 WHERE Name = "netherium small lantern";
UPDATE itemtemplate SET Gold = 68, Silver = 04, Copper = 0 WHERE Name = "netherium gem-studded jewelry box";
UPDATE itemtemplate SET Gold = 5, Silver = 10, Copper = 30 WHERE Name = "arcanium bracket";
UPDATE itemtemplate SET Gold = 10, Silver = 20, Copper = 60 WHERE Name = "arcanium hinge";
UPDATE itemtemplate SET Gold = 5, Silver = 10, Copper = 30 WHERE Name = "arcanium wrought jewelry box";
UPDATE itemtemplate SET Gold = 10, Silver = 20, Copper = 60 WHERE Name = "arcanium small lantern";
UPDATE itemtemplate SET Gold = 102, Silver = 06, Copper = 00 WHERE Name = "arcanium gem-studded jewelry box";
UPDATE itemtemplate SET Copper = 89 WHERE Name = "bronze hand axe";
UPDATE itemtemplate SET Silver = 15, Copper = 80 WHERE Name = "iron hand axe";
UPDATE itemtemplate SET Silver = 63, Copper = 20 WHERE Name = "steel hand axe";
UPDATE itemtemplate SET Gold = 1, Silver = 89, Copper = 60 WHERE Name = "alloy hand axe";
UPDATE itemtemplate SET Gold = 5, Silver = 68, Copper = 80 WHERE Name = "fine alloy hand axe";
UPDATE itemtemplate SET Gold = 11, Silver = 37, Copper = 60 WHERE Name = "mithril hand axe";
UPDATE itemtemplate SET Gold = 17, Silver = 6, Copper = 40 WHERE Name = "adamantium hand axe";
UPDATE itemtemplate SET Gold = 25, Silver = 59, Copper = 60 WHERE Name = "asterite hand axe";
UPDATE itemtemplate SET Gold = 38, Silver = 39, Copper = 40 WHERE Name = "netherium hand axe";
UPDATE itemtemplate SET Gold = 57, Silver = 59, Copper = 10 WHERE Name = "arcanium hand axe";
UPDATE itemtemplate SET Silver = 1, Copper = 37 WHERE Name = "bronze bearded axe";
UPDATE itemtemplate SET Silver = 24, Copper = 20 WHERE Name = "iron bearded axe";
UPDATE itemtemplate SET Silver = 96, Copper = 80 WHERE Name = "steel bearded axe";
UPDATE itemtemplate SET Gold = 2, Silver = 90, Copper = 40 WHERE Name = "alloy bearded axe";
UPDATE itemtemplate SET Gold = 8, Silver = 71, Copper = 20 WHERE Name = "fine alloy bearded axe";
UPDATE itemtemplate SET Gold = 17, Silver = 42, Copper = 40 WHERE Name = "mithril bearded axe";
UPDATE itemtemplate SET Gold = 26, Silver = 13, Copper = 60 WHERE Name = "adamantium bearded axe";
UPDATE itemtemplate SET Gold = 39, Silver = 20, Copper = 40 WHERE Name = "asterite bearded axe";
UPDATE itemtemplate SET Gold = 58, Silver = 80, Copper = 60 WHERE Name = "netherium bearded axe";
UPDATE itemtemplate SET Gold = 88, Silver = 20, Copper = 90 WHERE Name = "arcanium bearded axe";
UPDATE itemtemplate SET Silver = 1, Copper = 80 WHERE Name = "bronze war axe";
UPDATE itemtemplate SET Silver = 31, Copper = 80 WHERE Name = "iron war axe";
UPDATE itemtemplate SET Gold = 1, Silver = 27, Copper = 20 WHERE Name = "steel war axe";
UPDATE itemtemplate SET Gold = 3, Silver = 81, Copper = 60 WHERE Name = "alloy war axe";
UPDATE itemtemplate SET Gold = 11, Silver = 44, Copper = 80 WHERE Name = "fine alloy war axe";
UPDATE itemtemplate SET Gold = 22, Silver = 89, Copper = 60 WHERE Name = "mithril war axe";
UPDATE itemtemplate SET Gold = 34, Silver = 34, Copper = 40 WHERE Name = "adamantium war axe";
UPDATE itemtemplate SET Gold = 51, Silver = 51, Copper = 60 WHERE Name = "asterite war axe";
UPDATE itemtemplate SET Gold = 77, Silver = 27, Copper = 40 WHERE Name = "netherium war axe";
UPDATE itemtemplate SET Gold = 115, Silver = 91, Copper = 10 WHERE Name = "arcanium war axe";
UPDATE itemtemplate SET Silver = 2, Copper = 26 WHERE Name = "bronze spiked axe";
UPDATE itemtemplate SET Silver = 40 WHERE Name = "iron spiked axe";
UPDATE itemtemplate SET Gold = 1, Silver = 60 WHERE Name = "steel spiked axe";
UPDATE itemtemplate SET Gold = 4, Silver = 80 WHERE Name = "alloy spiked axe";
UPDATE itemtemplate SET Gold = 14, Silver = 40 WHERE Name = "fine alloy spiked axe";
UPDATE itemtemplate SET Gold = 28, Silver = 80 WHERE Name = "mithril spiked axe";
UPDATE itemtemplate SET Gold = 43, Silver = 20 WHERE Name = "adamantium spiked axe";
UPDATE itemtemplate SET Gold = 64, Silver = 80 WHERE Name = "asterite spiked axe";
UPDATE itemtemplate SET Gold = 97, Silver = 20 WHERE Name = "netherium spiked axe";
UPDATE itemtemplate SET Gold = 145, Silver = 80 WHERE Name = "arcanium spiked axe";
UPDATE itemtemplate SET Silver = 2, Copper = 74 WHERE Name = "bronze double bladed axe";
UPDATE itemtemplate SET Silver = 48, Copper = 40 WHERE Name = "iron double bladed axe";
UPDATE itemtemplate SET Gold = 1, Silver = 93, Copper = 60 WHERE Name = "steel double bladed axe";
UPDATE itemtemplate SET Gold = 5, Silver = 80, Copper = 80 WHERE Name = "alloy double bladed axe";
UPDATE itemtemplate SET Gold = 17, Silver = 42, Copper = 40 WHERE Name = "fine alloy double bladed axe";
UPDATE itemtemplate SET Gold = 34, Silver = 84, Copper = 80 WHERE Name = "mithril double bladed axe";
UPDATE itemtemplate SET Gold = 52, Silver = 27, Copper = 20 WHERE Name = "adamantium double bladed axe";
UPDATE itemtemplate SET Gold = 78, Silver = 40, Copper = 80 WHERE Name = "asterite double bladed axe";
UPDATE itemtemplate SET Gold = 117, Silver = 61, Copper = 20 WHERE Name = "netherium double bladed axe";
UPDATE itemtemplate SET Gold = 176, Silver = 41, Copper = 80 WHERE Name = "arcanium double bladed axe";
UPDATE itemtemplate SET Gold = 20, Silver = 73, Copper = 60 WHERE Name = "fine alloy cleaver";
UPDATE itemtemplate SET Gold = 41, Silver = 47, Copper = 20 WHERE Name = "mithril cleaver";
UPDATE itemtemplate SET Gold = 62, Silver = 20, Copper = 80 WHERE Name = "adamantium cleaver";
UPDATE itemtemplate SET Gold = 93, Silver = 31, Copper = 20 WHERE Name = "asterite cleaver";
UPDATE itemtemplate SET Gold = 139, Silver = 96, Copper = 80 WHERE Name = "netherium cleaver";
UPDATE itemtemplate SET Gold = 209, Silver = 95, Copper = 20 WHERE Name = "arcanium cleaver";
UPDATE itemtemplate SET Silver = 2, Copper = 74 WHERE Name = "bronze large axe";
UPDATE itemtemplate SET Silver = 48, Copper = 40 WHERE Name = "iron large axe";
UPDATE itemtemplate SET Gold = 1, Silver = 93, Copper = 60 WHERE Name = "steel large axe";
UPDATE itemtemplate SET Gold = 5, Silver = 80, Copper = 80 WHERE Name = "alloy large axe";
UPDATE itemtemplate SET Gold = 17, Silver = 42, Copper = 40 WHERE Name = "fine alloy large axe";
UPDATE itemtemplate SET Gold = 34, Silver = 84, Copper = 80 WHERE Name = "mithril large axe";
UPDATE itemtemplate SET Gold = 52, Silver = 27, Copper = 20 WHERE Name = "adamantium large axe";
UPDATE itemtemplate SET Gold = 78, Silver = 40, Copper = 80 WHERE Name = "asterite large axe";
UPDATE itemtemplate SET Gold = 117, Silver = 61, Copper = 20 WHERE Name = "netherium large axe";
UPDATE itemtemplate SET Gold = 176, Silver = 41, Copper = 80 WHERE Name = "arcanium large axe";
UPDATE itemtemplate SET Silver = 3, Copper = 14 WHERE Name = "bronze great axe";
UPDATE itemtemplate SET Silver = 55, Copper = 40 WHERE Name = "iron great axe";
UPDATE itemtemplate SET Gold = 2, Silver = 21, Copper = 60 WHERE Name = "steel great axe";
UPDATE itemtemplate SET Gold = 6, Silver = 64, Copper = 80 WHERE Name = "alloy great axe";
UPDATE itemtemplate SET Gold = 19, Silver = 94, Copper = 40 WHERE Name = "fine alloy great axe";
UPDATE itemtemplate SET Gold = 39, Silver = 88, Copper = 80 WHERE Name = "mithril great axe";
UPDATE itemtemplate SET Gold = 59, Silver = 83, Copper = 20 WHERE Name = "adamantium great axe";
UPDATE itemtemplate SET Gold = 89, Silver = 74, Copper = 80 WHERE Name = "asterite great axe";
UPDATE itemtemplate SET Gold = 134, Silver = 62, Copper = 20 WHERE Name = "netherium great axe";
UPDATE itemtemplate SET Gold = 201, Silver = 93, Copper = 30 WHERE Name = "arcanium great axe";
UPDATE itemtemplate SET Gold = 24, Silver = 76, Copper = 80 WHERE Name = "fine alloy war cleaver";
UPDATE itemtemplate SET Gold = 49, Silver = 53, Copper = 60 WHERE Name = "mithril war cleaver";
UPDATE itemtemplate SET Gold = 74, Silver = 30, Copper = 40 WHERE Name = "adamantium war cleaver";
UPDATE itemtemplate SET Gold = 111, Silver = 45, Copper = 60 WHERE Name = "asterite war cleaver";
UPDATE itemtemplate SET Gold = 167, Silver = 18, Copper = 40 WHERE Name = "netherium war cleaver";
UPDATE itemtemplate SET Gold = 250, Silver = 77, Copper = 60 WHERE Name = "arcanium war cleaver";
UPDATE itemtemplate SET Gold = 20, Silver = 73, Copper = 60 WHERE Name = "fine alloy weighted bearded axe";
UPDATE itemtemplate SET Gold = 41, Silver = 47, Copper = 20 WHERE Name = "mithril weighted bearded axe";
UPDATE itemtemplate SET Gold = 62, Silver = 20, Copper = 80 WHERE Name = "adamantium weighted bearded axe";
UPDATE itemtemplate SET Gold = 93, Silver = 31, Copper = 20 WHERE Name = "asterite weighted bearded axe";
UPDATE itemtemplate SET Gold = 139, Silver = 96, Copper = 80 WHERE Name = "netherium weighted bearded axe";
UPDATE itemtemplate SET Gold = 209, Silver = 95, Copper = 20 WHERE Name = "arcanium weighted bearded axe";
UPDATE itemtemplate SET Gold = 20, Silver = 73, Copper = 60 WHERE Name = "fine alloy exceptional hatchet";
UPDATE itemtemplate SET Gold = 41, Silver = 47, Copper = 20 WHERE Name = "mithril exceptional hatchet";
UPDATE itemtemplate SET Gold = 62, Silver = 20, Copper = 80 WHERE Name = "adamantium exceptional hatchet";
UPDATE itemtemplate SET Gold = 93, Silver = 31, Copper = 20 WHERE Name = "asterite exceptional hatchet";
UPDATE itemtemplate SET Gold = 139, Silver = 96, Copper = 80 WHERE Name = "netherium exceptional hatchet";
UPDATE itemtemplate SET Gold = 209, Silver = 95, Copper = 20 WHERE Name = "arcanium exceptional hatchet";
UPDATE itemtemplate SET Gold = 20, Silver = 73, Copper = 60 WHERE Name = "fine alloy weighted double bladed axe";
UPDATE itemtemplate SET Gold = 41, Silver = 47, Copper = 20 WHERE Name = "mithril weighted double bladed axe";
UPDATE itemtemplate SET Gold = 62, Silver = 20, Copper = 80 WHERE Name = "adamantium weighted double bladed axe";
UPDATE itemtemplate SET Gold = 93, Silver = 31, Copper = 20 WHERE Name = "asterite weighted double bladed axe";
UPDATE itemtemplate SET Gold = 139, Silver = 96, Copper = 80 WHERE Name = "netherium weighted double bladed axe";
UPDATE itemtemplate SET Gold = 209, Silver = 95, Copper = 20 WHERE Name = "arcanium weighted double bladed axe";
UPDATE itemtemplate SET Gold = 20, Silver = 73, Copper = 60 WHERE Name = "fine alloy exceptional double bladed axe";
UPDATE itemtemplate SET Gold = 41, Silver = 47, Copper = 20 WHERE Name = "mithril exceptional double bladed axe";
UPDATE itemtemplate SET Gold = 62, Silver = 20, Copper = 80 WHERE Name = "adamantium exceptional double bladed axe";
UPDATE itemtemplate SET Gold = 93, Silver = 31, Copper = 20 WHERE Name = "asterite exceptional double bladed axe";
UPDATE itemtemplate SET Gold = 139, Silver = 96, Copper = 80 WHERE Name = "netherium exceptional double bladed axe";
UPDATE itemtemplate SET Gold = 209, Silver = 95, Copper = 20 WHERE Name = "arcanium exceptional double bladed axe";
UPDATE itemtemplate SET Gold = 20, Silver = 73, Copper = 60 WHERE Name = "fine alloy fortified double bladed axe";
UPDATE itemtemplate SET Gold = 41, Silver = 47, Copper = 20 WHERE Name = "mithril fortified double bladed axe";
UPDATE itemtemplate SET Gold = 62, Silver = 20, Copper = 80 WHERE Name = "adamantium fortified double bladed axe";
UPDATE itemtemplate SET Gold = 93, Silver = 31, Copper = 20 WHERE Name = "asterite fortified double bladed axe";
UPDATE itemtemplate SET Gold = 139, Silver = 96, Copper = 80 WHERE Name = "netherium fortified double bladed axe";
UPDATE itemtemplate SET Gold = 209, Silver = 95, Copper = 20 WHERE Name = "arcanium fortified double bladed axe";
UPDATE itemtemplate SET Gold = 24, Silver = 76, Copper = 80 WHERE Name = "fine alloy exceptional battle axe";
UPDATE itemtemplate SET Gold = 49, Silver = 53, Copper = 60 WHERE Name = "mithril exceptional battle axe";
UPDATE itemtemplate SET Gold = 74, Silver = 30, Copper = 40 WHERE Name = "adamantium exceptional battle axe";
UPDATE itemtemplate SET Gold = 111, Silver = 45, Copper = 60 WHERE Name = "asterite exceptional battle axe";
UPDATE itemtemplate SET Gold = 167, Silver = 18, Copper = 40 WHERE Name = "netherium exceptional battle axe";
UPDATE itemtemplate SET Gold = 250, Silver = 77, Copper = 60 WHERE Name = "arcanium exceptional battle axe";
UPDATE itemtemplate SET Gold = 24, Silver = 76, Copper = 80 WHERE Name = "fine alloy fortified battle axe";
UPDATE itemtemplate SET Gold = 49, Silver = 53, Copper = 60 WHERE Name = "mithril fortified battle axe";
UPDATE itemtemplate SET Gold = 74, Silver = 30, Copper = 40 WHERE Name = "adamantium fortified battle axe";
UPDATE itemtemplate SET Gold = 111, Silver = 45, Copper = 60 WHERE Name = "asterite fortified battle axe";
UPDATE itemtemplate SET Gold = 167, Silver = 18, Copper = 40 WHERE Name = "netherium fortified battle axe";
UPDATE itemtemplate SET Gold = 250, Silver = 77, Copper = 60 WHERE Name = "arcanium fortified battle axe";

Unread post by **Malkavien** » 06 Jul 2005, 10:30

merci de votre aide, comme je vous l'ait dit plus tot : nous gardons toutes vos modifications pour en faire une grosse mise a jour.

Unread post by **Ghordjul** » 06 Jul 2005, 12:49

J'avoue que pendant 2 secondes, avant de lire ton texte de début de post, j'ai cru que tu te foutais de ma tronche Cossa

Ceci dit, regarde bien ton post de traduction, les apostrophes passent mal et sont remplacées par \'
Exemple :

UPDATE itemtemplate SET Name='Collier d\'Energie' WHERE Name='Necklace of Energy';

Rien de grave, un bon vieux "Remplacer tout" et c'est règlé, mais j'ai préféré signaler

EDIT : Okidoki, j'ai rien dit

Unread post by **Cossa** » 06 Jul 2005, 13:26

Nonon Ghordjul ne cherche pas d'erreurs la ou tout est normal

Si je met un \ avant le ' c'est pour montrer que cela correspond a une appostrophe DANS le nom et non pas la fin du nom

Car j'ai entouré le nom par des ' au lieu de " :p

Unread post by **Asenar Lunin** » 06 Jul 2005, 15:20

Et a propos de remplacer "barre de fer en bronze" par "barre de bronze", idem pour les carrés de tissus de. par carré de. et les planches en bois de. par planche de.

Et si OUI (ce serait bien), est ce que vous ferez l'update a partir de la bd existante (c'est à dire avec les noms fr) ou sur la bd originelle (en vo quoi).

Unread post by **Cossa** » 06 Jul 2005, 15:41

J'attend une confirmation pour la modification et si c'est accepté comme systeme, je donne un fichir sql contenant toutes les requetes modifiées

Unread post by **KULGAR** » 06 Jul 2005, 18:29

Prix Haches Midgard (prix de revente identique à goa)

UPDATE itemtemplate SET Copper = 75 WHERE Name = "bronze hand axe";
UPDATE itemtemplate SET Silver = 12 WHERE Name = "iron hand axe";
UPDATE itemtemplate SET Silver = 48 WHERE Name = "steel hand axe";
UPDATE itemtemplate SET Gold = 1, Silver = 44 WHERE Name = "alloy hand axe";
UPDATE itemtemplate SET Gold = 4, Silver = 32 WHERE Name = "fine alloy hand axe";
UPDATE itemtemplate SET Gold = 8, Silver = 64 WHERE Name = "mithril hand axe";
UPDATE itemtemplate SET Gold = 12, Silver = 96 WHERE Name = "adamantium hand axe";
UPDATE itemtemplate SET Gold = 19, Silver = 44 WHERE Name = "asterite hand axe";
UPDATE itemtemplate SET Gold = 29, Silver = 16 WHERE Name = "netherium hand axe";
UPDATE itemtemplate SET Gold = 43, Silver = 74 WHERE Name = "arcanium hand axe";

UPDATE itemtemplate SET Silver = 1, Copper = 13 WHERE Name = "bronze bearded axe";
UPDATE itemtemplate SET Silver = 18 WHERE Name = "iron bearded axe";
UPDATE itemtemplate SET Silver = 72 WHERE Name = "steel bearded axe";
UPDATE itemtemplate SET Gold = 2, Silver = 16 WHERE Name = "alloy bearded axe";
UPDATE itemtemplate SET Gold = 6, Silver = 48 WHERE Name = "fine alloy bearded axe";
UPDATE itemtemplate SET Gold = 12, Silver = 96 WHERE Name = "mithril bearded axe";
UPDATE itemtemplate SET Gold = 19, Silver = 44 WHERE Name = "adamantium bearded axe";
UPDATE itemtemplate SET Gold = 29, Silver = 16 WHERE Name = "asterite bearded axe";
UPDATE itemtemplate SET Gold = 43, Silver = 74 WHERE Name = "netherium bearded axe";
UPDATE itemtemplate SET Gold = 65, Silver = 61 WHERE Name = "arcanium bearded axe";

UPDATE itemtemplate SET Silver = 1, Copper = 50 WHERE Name = "bronze war axe";
UPDATE itemtemplate SET Silver = 24 WHERE Name = "iron war axe";
UPDATE itemtemplate SET Silver = 96 WHERE Name = "steel war axe";
UPDATE itemtemplate SET Gold = 2, Silver = 88 WHERE Name = "alloy war axe";
UPDATE itemtemplate SET Gold = 8, Silver = 64 WHERE Name = "fine alloy war axe";
UPDATE itemtemplate SET Gold = 17, Silver = 28 WHERE Name = "mithril war axe";
UPDATE itemtemplate SET Gold = 25, Silver = 92 WHERE Name = "adamantium war axe";
UPDATE itemtemplate SET Gold = 38, Silver = 88 WHERE Name = "asterite war axe";
UPDATE itemtemplate SET Gold = 58, Silver = 32 WHERE Name = "netherium war axe";
UPDATE itemtemplate SET Gold = 87, Silver = 48 WHERE Name = "arcanium war axe";

UPDATE itemtemplate SET Silver = 1, Copper = 88 WHERE Name = "bronze spiked axe";
UPDATE itemtemplate SET Silver = 30 WHERE Name = "iron spiked axe";
UPDATE itemtemplate SET Gold = 1, Silver = 20 WHERE Name = "steel spiked axe";
UPDATE itemtemplate SET Gold = 3, Silver = 60 WHERE Name = "alloy spiked axe";
UPDATE itemtemplate SET Gold = 10, Silver = 80 WHERE Name = "fine alloy spiked axe";
UPDATE itemtemplate SET Gold = 21, Silver = 60 WHERE Name = "mithril spiked axe";
UPDATE itemtemplate SET Gold = 32, Silver = 40 WHERE Name = "adamantium spiked axe";
UPDATE itemtemplate SET Gold = 48, Silver = 60 WHERE Name = "asterite spiked axe";
UPDATE itemtemplate SET Gold = 72, Silver = 90 WHERE Name = "netherium spiked axe";
UPDATE itemtemplate SET Gold = 109, Silver = 35 WHERE Name = "arcanium spiked axe";

UPDATE itemtemplate SET Silver = 2, Copper = 25 WHERE Name = "bronze double bladed axe";
UPDATE itemtemplate SET Silver = 36 WHERE Name = "iron double bladed axe";
UPDATE itemtemplate SET Gold = 1, Silver = 44 WHERE Name = "steel double bladed axe";
UPDATE itemtemplate SET Gold = 4, Silver = 32 WHERE Name = "alloy double bladed axe";
UPDATE itemtemplate SET Gold = 12, Silver = 96 WHERE Name = "fine alloy double bladed axe";
UPDATE itemtemplate SET Gold = 25, Silver = 92 WHERE Name = "mithril double bladed axe";
UPDATE itemtemplate SET Gold = 38, Silver = 88 WHERE Name = "adamantium double bladed axe";
UPDATE itemtemplate SET Gold = 58, Silver = 32 WHERE Name = "asterite double bladed axe";
UPDATE itemtemplate SET Gold = 87, Silver = 48 WHERE Name = "netherium double bladed axe";
UPDATE itemtemplate SET Gold = 131, Silver = 22 WHERE Name = "arcanium double bladed axe";

UPDATE itemtemplate SET Gold = 15, Silver = 55, Copper = 20 WHERE Name = "fine alloy cleaver";
UPDATE itemtemplate SET Gold = 31, Silver = 10, Copper = 40 WHERE Name = "mithril cleaver";
UPDATE itemtemplate SET Gold = 46, Silver = 65, Copper = 60 WHERE Name = "adamantium cleaver";
UPDATE itemtemplate SET Gold = 69, Silver = 98, Copper = 40 WHERE Name = "asterite cleaver";
UPDATE itemtemplate SET Gold = 104, Silver = 97, Copper = 60 WHERE Name = "netherium cleaver";
UPDATE itemtemplate SET Gold = 157, Silver = 46, Copper = 40 WHERE Name = "arcanium cleaver";

UPDATE itemtemplate SET Silver = 2, Copper = 25 WHERE Name = "bronze large axe";
UPDATE itemtemplate SET Silver = 36 WHERE Name = "iron large axe";
UPDATE itemtemplate SET Gold = 1, Silver = 44 WHERE Name = "steel large axe";
UPDATE itemtemplate SET Gold = 4, Silver = 32 WHERE Name = "alloy large axe";
UPDATE itemtemplate SET Gold = 12, Silver = 96 WHERE Name = "fine alloy large axe";
UPDATE itemtemplate SET Gold = 25, Silver = 92 WHERE Name = "mithril large axe";
UPDATE itemtemplate SET Gold = 38, Silver = 88 WHERE Name = "adamantium large axe";
UPDATE itemtemplate SET Gold = 58, Silver = 32 WHERE Name = "asterite large axe";
UPDATE itemtemplate SET Gold = 87, Silver = 48 WHERE Name = "netherium large axe";
UPDATE itemtemplate SET Gold = 131, Silver = 22 WHERE Name = "arcanium large axe";

UPDATE itemtemplate SET Silver = 2, Copper = 63 WHERE Name = "bronze great axe";
UPDATE itemtemplate SET Silver = 42 WHERE Name = "iron great axe";
UPDATE itemtemplate SET Gold = 1, Silver = 68 WHERE Name = "steel great axe";
UPDATE itemtemplate SET Gold = 5, Silver = 4, WHERE Name = "alloy great axe";
UPDATE itemtemplate SET Gold = 15, Silver = 12 WHERE Name = "fine alloy great axe";
UPDATE itemtemplate SET Gold = 30, Silver = 24 WHERE Name = "mithril great axe";
UPDATE itemtemplate SET Gold = 45, Silver = 36 WHERE Name = "adamantium great axe";
UPDATE itemtemplate SET Gold = 68, Silver = 4 WHERE Name = "asterite great axe";
UPDATE itemtemplate SET Gold = 102, Silver = 6 WHERE Name = "netherium great axe";
UPDATE itemtemplate SET Gold = 153, Silver = 9 WHERE Name = "arcanium great axe";

UPDATE itemtemplate SET Gold = 15, Silver = 55, Copper = 20 WHERE Name = "fine alloy weighted bearded axe";
UPDATE itemtemplate SET Gold = 31, Silver = 10, Copper = 40 WHERE Name = "mithril weighted bearded axe";
UPDATE itemtemplate SET Gold = 46, Silver = 65, Copper = 60 WHERE Name = "adamantium weighted bearded axe";
UPDATE itemtemplate SET Gold = 69, Silver = 98, Copper = 40 WHERE Name = "asterite weighted bearded axe";
UPDATE itemtemplate SET Gold = 104, Silver = 97, Copper = 60 WHERE Name = "netherium weighted bearded axe";
UPDATE itemtemplate SET Gold = 157, Silver = 46, Copper = 40 WHERE Name = "arcanium weighted bearded axe";

UPDATE itemtemplate SET Gold = 15, Silver = 55, Copper = 20 WHERE Name = "fine alloy exceptional hatchet";
UPDATE itemtemplate SET Gold = 31, Silver = 10, Copper = 40 WHERE Name = "mithril exceptional hatchet";
UPDATE itemtemplate SET Gold = 46, Silver = 65, Copper = 60 WHERE Name = "adamantium exceptional hatchet";
UPDATE itemtemplate SET Gold = 69, Silver = 98, Copper = 40 WHERE Name = "asterite exceptional hatchet";
UPDATE itemtemplate SET Gold = 104, Silver = 97, Copper = 60 WHERE Name = "netherium exceptional hatchet";
UPDATE itemtemplate SET Gold = 157, Silver = 46, Copper = 40 WHERE Name = "arcanium exceptional hatchet";

UPDATE itemtemplate SET Gold = 15, Silver = 55, Copper = 20 WHERE Name = "fine alloy weighted double bladed axe";
UPDATE itemtemplate SET Gold = 31, Silver = 10, Copper = 40 WHERE Name = "mithril weighted double bladed axe";
UPDATE itemtemplate SET Gold = 46, Silver = 65, Copper = 60 WHERE Name = "adamantium weighted double bladed axe";
UPDATE itemtemplate SET Gold = 69, Silver = 98, Copper = 40 WHERE Name = "asterite weighted double bladed axe";
UPDATE itemtemplate SET Gold = 104, Silver = 97, Copper = 60 WHERE Name = "netherium weighted double bladed axe";
UPDATE itemtemplate SET Gold = 157, Silver = 46, Copper = 40 WHERE Name = "arcanium weighted double bladed axe";

UPDATE itemtemplate SET Gold = 15, Silver = 55, Copper = 20 WHERE Name = "fine alloy exceptional double bladed axe";
UPDATE itemtemplate SET Gold = 31, Silver = 10, Copper = 40 WHERE Name = "mithril exceptional double bladed axe";
UPDATE itemtemplate SET Gold = 46, Silver = 65, Copper = 60 WHERE Name = "adamantium exceptional double bladed axe";
UPDATE itemtemplate SET Gold = 69, Silver = 98, Copper = 40 WHERE Name = "asterite exceptional double bladed axe";
UPDATE itemtemplate SET Gold = 104, Silver = 97, Copper = 60 WHERE Name = "netherium exceptional double bladed axe";
UPDATE itemtemplate SET Gold = 157, Silver = 46, Copper = 40 WHERE Name = "arcanium exceptional double bladed axe";

UPDATE itemtemplate SET Gold = 15, Silver = 55, Copper = 20 WHERE Name = "fine alloy fortified double bladed axe";
UPDATE itemtemplate SET Gold = 31, Silver = 10, Copper = 40 WHERE Name = "mithril fortified double bladed axe";
UPDATE itemtemplate SET Gold = 46, Silver = 65, Copper = 60 WHERE Name = "adamantium fortified double bladed axe";
UPDATE itemtemplate SET Gold = 69, Silver = 98, Copper = 40 WHERE Name = "asterite fortified double bladed axe";
UPDATE itemtemplate SET Gold = 104, Silver = 97, Copper = 60 WHERE Name = "netherium fortified double bladed axe";
UPDATE itemtemplate SET Gold = 157, Silver = 46, Copper = 40 WHERE Name = "arcanium fortified double bladed axe";

UPDATE itemtemplate SET Gold = 18, Silver = 43, Copper = 20 WHERE Name = "fine alloy exceptional battle axe";
UPDATE itemtemplate SET Gold = 36, Silver = 86, Copper = 40 WHERE Name = "mithril exceptional battle axe";
UPDATE itemtemplate SET Gold = 55, Silver = 29, Copper = 60 WHERE Name = "adamantium exceptional battle axe";
UPDATE itemtemplate SET Gold = 82, Silver = 94, Copper = 40 WHERE Name = "asterite exceptional battle axe";
UPDATE itemtemplate SET Gold = 124, Silver = 41, Copper = 60 WHERE Name = "netherium exceptional battle axe";
UPDATE itemtemplate SET Gold = 186, Silver = 62, Copper = 40 WHERE Name = "arcanium exceptional battle axe";

UPDATE itemtemplate SET Gold = 18, Silver = 43, Copper = 20 WHERE Name = "fine alloy fortified battle axe";
UPDATE itemtemplate SET Gold = 36, Silver = 86, Copper = 40 WHERE Name = "mithril fortified battle axe";
UPDATE itemtemplate SET Gold = 55, Silver = 29, Copper = 60 WHERE Name = "adamantium fortified battle axe";
UPDATE itemtemplate SET Gold = 82, Silver = 94, Copper = 40 WHERE Name = "asterite fortified battle axe";
UPDATE itemtemplate SET Gold = 124, Silver = 41, Copper = 60 WHERE Name = "netherium fortified battle axe";
UPDATE itemtemplate SET Gold = 124, Silver = 41, Copper = 60 WHERE Name = "arcanium fortified battle axe";

Observation:
Absence des armes Legendaire.

Prix Mateaux Midgard (prix de revente identique à goa)

UPDATE itemtemplate SET Copper = 75 WHERE Name = "bronze small hammer";
UPDATE itemtemplate SET Silver = 12 WHERE Name = "iron small hammer";
UPDATE itemtemplate SET Silver = 48 WHERE Name = "steel small hammer";
UPDATE itemtemplate SET Gold = 1, Silver = 44 WHERE Name = "alloy small hammer";
UPDATE itemtemplate SET Gold = 4, Silver = 32 WHERE Name = "fine alloy small hammer";
UPDATE itemtemplate SET Gold = 8, Silver = 64 WHERE Name = "mithril small hammer";
UPDATE itemtemplate SET Gold = 12, Silver = 96 WHERE Name = "adamantium small hammer";
UPDATE itemtemplate SET Gold = 19, Silver = 44 WHERE Name = "asterite small hammer";
UPDATE itemtemplate SET Gold = 29, Silver = 16 WHERE Name = "netherium small hammer";
UPDATE itemtemplate SET Gold = 43, Silver = 74 WHERE Name = "arcanium small hammer";

UPDATE itemtemplate SET Silver = 1, Copper = 19 WHERE Name = "bronze hammer";
UPDATE itemtemplate SET Silver = 19 WHERE Name = "iron hammer";
UPDATE itemtemplate SET Silver = 76 WHERE Name = "steel hammer";
UPDATE itemtemplate SET Gold = 2, Silver = 28 WHERE Name = "alloy hammer";
UPDATE itemtemplate SET Gold = 6, Silver = 84 WHERE Name = "fine alloy hammer";
UPDATE itemtemplate SET Gold = 13, Silver = 68 WHERE Name = "mithril hammer";
UPDATE itemtemplate SET Gold = 20, Silver = 52 WHERE Name = "adamantium hammer";
UPDATE itemtemplate SET Gold = 30, Silver = 78 WHERE Name = "asterite hammer";
UPDATE itemtemplate SET Gold = 46, Silver = 17 WHERE Name = "netherium hammer";
UPDATE itemtemplate SET Gold = 69, Silver = 25, Copper = 50 WHERE Name = "arcanium hammer";

UPDATE itemtemplate SET Silver = 1, Copper = 50 WHERE Name = "bronze war hammer";
UPDATE itemtemplate SET Silver = 24 WHERE Name = "iron war hammer";
UPDATE itemtemplate SET Silver = 96 WHERE Name = "steel war hammer";
UPDATE itemtemplate SET Gold = 2, Silver = 88 WHERE Name = "alloy war hammer";
UPDATE itemtemplate SET Gold = 8, Silver = 64 WHERE Name = "fine alloy war hammer";
UPDATE itemtemplate SET Gold = 17, Silver = 28 WHERE Name = "mithril war hammer";
UPDATE itemtemplate SET Gold = 25, Silver = 92 WHERE Name = "adamantium war hammer";
UPDATE itemtemplate SET Gold = 38, Silver = 88 WHERE Name = "asterite war hammer";
UPDATE itemtemplate SET Gold = 58, Silver = 32 WHERE Name = "netherium war hammer";
UPDATE itemtemplate SET Gold = 87, Silver = 48 WHERE Name = "arcanium war hammer";

UPDATE itemtemplate SET Silver = 2 WHERE Name = "bronze pick hammer";
UPDATE itemtemplate SET Silver = 32 WHERE Name = "iron pick hammer";
UPDATE itemtemplate SET Gold = 1, Silver = 28 WHERE Name = "steel pick hammer";
UPDATE itemtemplate SET Gold = 3, Silver = 84 WHERE Name = "alloy pick hammer";
UPDATE itemtemplate SET Gold = 11, Silver = 52 WHERE Name = "fine alloy pick hammer";
UPDATE itemtemplate SET Gold = 23, Silver = 4 WHERE Name = "mithril pick hammer";
UPDATE itemtemplate SET Gold = 34, Silver = 56 WHERE Name = "adamantium pick hammer";
UPDATE itemtemplate SET Gold = 51, Silver = 84 WHERE Name = "asterite pick hammer";
UPDATE itemtemplate SET Gold = 77, Silver = 76 WHERE Name = "netherium pick hammer";
UPDATE itemtemplate SET Gold = 116, Silver = 64 WHERE Name = "arcanium pick hammer";

UPDATE itemtemplate SET Silver = 2, Copper = 50 WHERE Name = "bronze battle hammer";
UPDATE itemtemplate SET Silver = 40 WHERE Name = "iron battle hammer";
UPDATE itemtemplate SET Gold = 1, Silver = 60 WHERE Name = "steel battle hammer";
UPDATE itemtemplate SET Gold = 4, Silver = 80 WHERE Name = "alloy battle hammer";
UPDATE itemtemplate SET Gold = 14, Silver = 40 WHERE Name = "fine alloy battle hammer";
UPDATE itemtemplate SET Gold = 28, Silver = 80 WHERE Name = "mithril battle hammer";
UPDATE itemtemplate SET Gold = 43, Silver = 20 WHERE Name = "adamantium battle hammer";
UPDATE itemtemplate SET Gold = 64, Silver = 80 WHERE Name = "asterite battle hammer";
UPDATE itemtemplate SET Gold = 97, Silver = 20 WHERE Name = "netherium battle hammer";
UPDATE itemtemplate SET Gold = 145, Silver = 80 WHERE Name = "arcanium battle hammer";

UPDATE itemtemplate SET Gold = 15, Silver = 84 WHERE Name = "fine alloy spiked hammer";
UPDATE itemtemplate SET Gold = 31, Silver = 68 WHERE Name = "mithril spiked hammer";
UPDATE itemtemplate SET Gold = 47, Silver = 52 WHERE Name = "adamantium spiked hammer";
UPDATE itemtemplate SET Gold = 71, Silver = 28 WHERE Name = "asterite spiked hammer";
UPDATE itemtemplate SET Gold = 106, Silver = 92 WHERE Name = "netherium spiked hammer";
UPDATE itemtemplate SET Gold = 160, Silver = 38 WHERE Name = "arcanium spiked hammer";

UPDATE itemtemplate SET Silver = 2, Copper = 13 WHERE Name = "bronze two handed war hammer";
UPDATE itemtemplate SET Silver = 34 WHERE Name = "iron two handed war hammer";
UPDATE itemtemplate SET Gold = 1, Silver = 36 WHERE Name = "steel two handed war hammer";
UPDATE itemtemplate SET Gold = 4, Silver = 8 WHERE Name = "alloy two handed war hammer";
UPDATE itemtemplate SET Gold = 12, Silver = 24 WHERE Name = "fine alloy two handed war hammer";
UPDATE itemtemplate SET Gold = 24, Silver = 48 WHERE Name = "mithril two handed war hammer";
UPDATE itemtemplate SET Gold = 36, Silver = 72 WHERE Name = "adamantium two handed war hammer";
UPDATE itemtemplate SET Gold = 55, Silver = 8 WHERE Name = "asterite two handed war hammer";
UPDATE itemtemplate SET Gold = 82, Silver = 62 WHERE Name = "netherium two handed war hammer";
UPDATE itemtemplate SET Gold = 123, Silver = 93 WHERE Name = "arcanium two handed war hammer";

UPDATE itemtemplate SET Silver = 2, Copper = 50 WHERE Name = "bronze great hammer";
UPDATE itemtemplate SET Silver = 40 WHERE Name = "iron great hammer";
UPDATE itemtemplate SET Gold = 1, Silver = 60 WHERE Name = "steel great hammer";
UPDATE itemtemplate SET Gold = 4, Silver = 80 WHERE Name = "alloy great hammer";
UPDATE itemtemplate SET Gold = 14, Silver = 40 WHERE Name = "fine alloy great hammer";
UPDATE itemtemplate SET Gold = 28, Silver = 80 WHERE Name = "mithril great hammer";
UPDATE itemtemplate SET Gold = 43, Silver = 20 WHERE Name = "adamantium great hammer";
UPDATE itemtemplate SET Gold = 64, Silver = 80 WHERE Name = "asterite great hammer";
UPDATE itemtemplate SET Gold = 97, Silver = 20 WHERE Name = "netherium great hammer";
UPDATE itemtemplate SET Gold = 145, Silver = 80 WHERE Name = "arcanium great hammer";

UPDATE itemtemplate SET Gold = 17, Silver = 28 WHERE Name = "fine alloy great spiked hammer";
UPDATE itemtemplate SET Gold = 34, Silver = 56 WHERE Name = "mithril great spiked hammer";
UPDATE itemtemplate SET Gold = 51, Silver = 84 WHERE Name = "adamantium great spiked hammer";
UPDATE itemtemplate SET Gold = 77, Silver = 76 WHERE Name = "asterite great spiked hammer";
UPDATE itemtemplate SET Gold = 116, Silver = 64 WHERE Name = "netherium great spiked hammer";
UPDATE itemtemplate SET Gold = 174, Silver = 96 WHERE Name = "arcanium great spiked hammer";

UPDATE itemtemplate SET Gold = 15, Silver = 55, Copper = 20 WHERE Name = "fine alloy exceptional pick hammer";
UPDATE itemtemplate SET Gold = 31, Silver = 10, Copper = 40 WHERE Name = "mithril exceptional pick hammer";
UPDATE itemtemplate SET Gold = 46, Silver = 65, Copper = 60 WHERE Name = "adamantium exceptional pick hammer";
UPDATE itemtemplate SET Gold = 69, Silver = 98, Copper = 40 WHERE Name = "asterite exceptional pick hammer";
UPDATE itemtemplate SET Gold = 104, Silver = 97, Copper = 60 WHERE Name = "netherium exceptional pick hammer";
UPDATE itemtemplate SET Gold = 157, Silver = 46, Copper = 40 WHERE Name = "arcanium exceptional pick hammer";

UPDATE itemtemplate SET Gold = 15, Silver = 84 WHERE Name = "fine alloy fortified pick hammer";
UPDATE itemtemplate SET Gold = 31, Silver = 68 WHERE Name = "mithril fortified pick hammer";
UPDATE itemtemplate SET Gold = 47, Silver = 52 WHERE Name = "adamantium fortified pick hammer";
UPDATE itemtemplate SET Gold = 71, Silver = 28 WHERE Name = "asterite fortified pick hammer";
UPDATE itemtemplate SET Gold = 106, Silver = 92 WHERE Name = "netherium fortified pick hammer";
UPDATE itemtemplate SET Gold = 160, Silver = 38 WHERE Name = "arcanium fortified pick hammer";

UPDATE itemtemplate SET Gold = 17, Silver = 28 WHERE Name = "fine alloy exceptional great hammer";
UPDATE itemtemplate SET Gold = 34, Silver = 56 WHERE Name = "mithril exceptional great hammer";
UPDATE itemtemplate SET Gold = 51, Silver = 84 WHERE Name = "adamantium exceptional great hammer";
UPDATE itemtemplate SET Gold = 77, Silver = 76 WHERE Name = "asterite exceptional great hammer";
UPDATE itemtemplate SET Gold = 116, Silver = 64 WHERE Name = "netherium exceptional great hammer";
UPDATE itemtemplate SET Gold = 174, Silver = 96 WHERE Name = "arcanium exceptional great hammer";

UPDATE itemtemplate SET Gold = 17, Silver = 28 WHERE Name = "fine alloy fortified great hammer";
UPDATE itemtemplate SET Gold = 34, Silver = 56 WHERE Name = "mithril fortified great hammer";
UPDATE itemtemplate SET Gold = 51, Silver = 84 WHERE Name = "adamantium fortified great hammer";
UPDATE itemtemplate SET Gold = 77, Silver = 76 WHERE Name = "asterite fortified great hammer";
UPDATE itemtemplate SET Gold = 116, Silver = 64 WHERE Name = "netherium fortified great hammer";
UPDATE itemtemplate SET Gold = 174, Silver = 96 WHERE Name = "arcanium fortified great hammer";

Observation:
Absence des armes Legendaire.

Prix Lances Midgard (prix de revente identique à goa)

UPDATE itemtemplate SET Silver = 1 WHERE Name = "bronze spear";
UPDATE itemtemplate SET Silver = 16 WHERE Name = "iron spear";
UPDATE itemtemplate SET Silver = 64 WHERE Name = "steel spear";
UPDATE itemtemplate SET Gold = 1, Silver = 92 WHERE Name = "alloy spear";
UPDATE itemtemplate SET Gold = 5, Silver = 76 WHERE Name = "fine alloy spear";
UPDATE itemtemplate SET Gold = 11, Silver = 52 WHERE Name = "mithril spear";
UPDATE itemtemplate SET Gold = 17, Silver = 28 WHERE Name = "adamantium spear";
UPDATE itemtemplate SET Gold = 25, Silver = 92 WHERE Name = "asterite spear";
UPDATE itemtemplate SET Gold = 38, Silver = 88 WHERE Name = "netherium spear";
UPDATE itemtemplate SET Gold = 58, Silver = 32 WHERE Name = "arcanium spear";

UPDATE itemtemplate SET Silver = 1, Copper = 25 WHERE Name = "bronze long spear";
UPDATE itemtemplate SET Silver = 20 WHERE Name = "iron long spear";
UPDATE itemtemplate SET Silver = 80 WHERE Name = "steel long spear";
UPDATE itemtemplate SET Gold = 2, Silver = 40 WHERE Name = "alloy long spear";
UPDATE itemtemplate SET Gold = 7, Silver = 20 WHERE Name = "fine alloy long spear";
UPDATE itemtemplate SET Gold = 14, Silver = 40 WHERE Name = "mithril long spear";
UPDATE itemtemplate SET Gold = 21, Silver = 60 WHERE Name = "adamantium long spear";
UPDATE itemtemplate SET Gold = 32, Silver = 40 WHERE Name = "asterite long spear";
UPDATE itemtemplate SET Gold = 48, Silver = 60 WHERE Name = "netherium long spear";
UPDATE itemtemplate SET Gold = 72, Silver = 90 WHERE Name = "arcanium long spear";

UPDATE itemtemplate SET Silver = 1, Copper = 50 WHERE Name = "bronze trident";
UPDATE itemtemplate SET Silver = 24 WHERE Name = "iron trident";
UPDATE itemtemplate SET Silver = 96 WHERE Name = "steel trident";
UPDATE itemtemplate SET Gold = 2, Silver = 88 WHERE Name = "alloy trident";
UPDATE itemtemplate SET Gold = 8, Silver = 64 WHERE Name = "fine alloy trident";
UPDATE itemtemplate SET Gold = 17, Silver = 28 WHERE Name = "mithril trident";
UPDATE itemtemplate SET Gold = 25, Silver = 92 WHERE Name = "adamantium trident";
UPDATE itemtemplate SET Gold = 38, Silver = 88 WHERE Name = "asterite trident";
UPDATE itemtemplate SET Gold = 58, Silver = 32 WHERE Name = "netherium trident";
UPDATE itemtemplate SET Gold = 87, Silver = 48 WHERE Name = "arcanium trident";

UPDATE itemtemplate SET Silver = 2 WHERE Name = "bronze lugged spear";
UPDATE itemtemplate SET Silver = 32 WHERE Name = "iron lugged spear";
UPDATE itemtemplate SET Gold = 1, Silver = 28 WHERE Name = "steel lugged spear";
UPDATE itemtemplate SET Gold = 3, Silver = 84 WHERE Name = "alloy lugged spear";
UPDATE itemtemplate SET Gold = 11, Silver = 52 WHERE Name = "fine alloy lugged spear";
UPDATE itemtemplate SET Gold = 23, Silver = 4 WHERE Name = "mithril lugged spear";
UPDATE itemtemplate SET Gold = 34, Silver = 56 WHERE Name = "adamantium lugged spear";
UPDATE itemtemplate SET Gold = 51, Silver = 84 WHERE Name = "asterite lugged spear";
UPDATE itemtemplate SET Gold = 77, Silver = 76 WHERE Name = "netherium lugged spear";
UPDATE itemtemplate SET Gold = 116, Silver = 64 WHERE Name = "arcanium lugged spear";

UPDATE itemtemplate SET Silver = 2, Copper = 63 WHERE Name = "bronze great spear";
UPDATE itemtemplate SET Silver = 42 WHERE Name = "iron great spear";
UPDATE itemtemplate SET Gold = 1, Silver = 64 WHERE Name = "steel great spear";
UPDATE itemtemplate SET Gold = 5, Silver = 4 WHERE Name = "alloy great spear";
UPDATE itemtemplate SET Gold = 15, Silver = 12 WHERE Name = "fine alloy great spear";
UPDATE itemtemplate SET Gold = 30, Silver = 24 WHERE Name = "mithril great spear";
UPDATE itemtemplate SET Gold = 45, Silver = 36 WHERE Name = "adamantium great spear";
UPDATE itemtemplate SET Gold = 68, Silver = 4 WHERE Name = "asterite great spear";
UPDATE itemtemplate SET Gold = 102, Silver = 6 WHERE Name = "netherium great spear";
UPDATE itemtemplate SET Gold = 153, Silver = 9 WHERE Name = "arcanium great spear";

UPDATE itemtemplate SET Gold = 18, Silver = 14, Copper = 40 WHERE Name = "fine alloy battle spear";
UPDATE itemtemplate SET Gold = 36, Silver = 28, Copper = 80 WHERE Name = "mithril battle spear";
UPDATE itemtemplate SET Gold = 54, Silver = 43, Copper = 20 WHERE Name = "adamantium battle spear";
UPDATE itemtemplate SET Gold = 81, Silver = 64, Copper = 80 WHERE Name = "asterite battle spear";
UPDATE itemtemplate SET Gold = 122, Silver = 47, Copper = 20 WHERE Name = "netherium battle spear";
UPDATE itemtemplate SET Gold = 183, Silver = 70, Copper = 80 WHERE Name = "arcanium battle spear";

UPDATE itemtemplate SET Gold = 18, Silver = 14, Copper = 40 WHERE Name = "fine alloy weighted hooked spear";
UPDATE itemtemplate SET Gold = 36, Silver = 28, Copper = 80 WHERE Name = "mithril weighted hooked spear";
UPDATE itemtemplate SET Gold = 54, Silver = 43, Copper = 20 WHERE Name = "adamantium weighted hooked spear";
UPDATE itemtemplate SET Gold = 81, Silver = 64, Copper = 80 WHERE Name = "asterite weighted hooked spear";
UPDATE itemtemplate SET Gold = 122, Silver = 47, Copper = 20 WHERE Name = "netherium weighted hooked spear";
UPDATE itemtemplate SET Gold = 183, Silver = 70, Copper = 80 WHERE Name = "arcanium weighted hooked spear";

UPDATE itemtemplate SET Gold = 18, Silver = 14, Copper = 40 WHERE Name = "fine alloy exceptional hooked spear";
UPDATE itemtemplate SET Gold = 36, Silver = 28, Copper = 80 WHERE Name = "mithril exceptional hooked spear";
UPDATE itemtemplate SET Gold = 54, Silver = 43, Copper = 20 WHERE Name = "adamantium exceptional hooked spear";
UPDATE itemtemplate SET Gold = 81, Silver = 64, Copper = 80 WHERE Name = "asterite exceptional hooked spear";
UPDATE itemtemplate SET Gold = 122, Silver = 47, Copper = 20 WHERE Name = "netherium exceptional hooked spear";
UPDATE itemtemplate SET Gold = 183, Silver = 70, Copper = 80 WHERE Name = "arcanium exceptional hooked spear";

UPDATE itemtemplate SET Gold = 18, Silver = 14, Copper = 40 WHERE Name = "fine alloy fortified hooked spear";
UPDATE itemtemplate SET Gold = 36, Silver = 28, Copper = 80 WHERE Name = "mithril fortified hooked spear";
UPDATE itemtemplate SET Gold = 54, Silver = 43, Copper = 20 WHERE Name = "adamantium fortified hooked spear";
UPDATE itemtemplate SET Gold = 81, Silver = 64, Copper = 80 WHERE Name = "asterite fortified hooked spear";
UPDATE itemtemplate SET Gold = 122, Silver = 47, Copper = 20 WHERE Name = "netherium fortified hooked spear";
UPDATE itemtemplate SET Gold = 183, Silver = 70, Copper = 80 WHERE Name = "arcanium fortified hooked spear";

UPDATE itemtemplate SET Gold = 18, Silver = 14, Copper = 40 WHERE Name = "fine alloy exceptional battle spear";
UPDATE itemtemplate SET Gold = 36, Silver = 28, Copper = 80 WHERE Name = "mithril exceptional battle spear";
UPDATE itemtemplate SET Gold = 54, Silver = 43, Copper = 20 WHERE Name = "adamantium exceptional battle spear";
UPDATE itemtemplate SET Gold = 81, Silver = 64, Copper = 80 WHERE Name = "asterite exceptional battle spear";
UPDATE itemtemplate SET Gold = 122, Silver = 47, Copper = 20 WHERE Name = "netherium exceptional battle spear";
UPDATE itemtemplate SET Gold = 183, Silver = 70, Copper = 80 WHERE Name = "arcanium exceptional battle spear";

UPDATE itemtemplate SET Gold = 18, Silver = 14, Copper = 40 WHERE Name = "fine alloy fortified battle spear";
UPDATE itemtemplate SET Gold = 36, Silver = 28, Copper = 80 WHERE Name = "mithril fortified battle spear";
UPDATE itemtemplate SET Gold = 54, Silver = 43, Copper = 20 WHERE Name = "adamantium fortified battle spear";
UPDATE itemtemplate SET Gold = 81, Silver = 64, Copper = 80 WHERE Name = "asterite fortified battle spear";
UPDATE itemtemplate SET Gold = 122, Silver = 47, Copper = 20 WHERE Name = "netherium fortified battle spear";
UPDATE itemtemplate SET Gold = 183, Silver = 70, Copper = 80 WHERE Name = "arcanium fortified battle spear";

Observation:
Absence des armes Legendaire.

Prix Boucliés Midgard (prix de revente identique à goa)

UPDATE itemtemplate SET Copper = 31 WHERE Name = "bronze kite shield";
UPDATE itemtemplate SET Silver = 5 WHERE Name = "iron kite shield";
UPDATE itemtemplate SET Silver = 20 WHERE Name = "steel kite shield";
UPDATE itemtemplate SET Silver = 60 WHERE Name = "alloy kite shield";
UPDATE itemtemplate SET Gold = 1, Silver = 80 WHERE Name = "fine alloy kite shield";
UPDATE itemtemplate SET Gold = 3, Silver = 60 WHERE Name = "mithril kite shield";
UPDATE itemtemplate SET Gold = 5, Silver = 40 WHERE Name = "adamantium kite shield";
UPDATE itemtemplate SET Gold = 8, Silver = 10 WHERE Name = "asterite kite shield";
UPDATE itemtemplate SET Gold = 12, Silver = 15 WHERE Name = "netherium kite shield";
UPDATE itemtemplate SET Gold = 18, Silver = 22, Copper = 50 WHERE Name = "arcanium kite shield";

UPDATE itemtemplate SET Copper = 38 WHERE Name = "bronze tower shield";
UPDATE itemtemplate SET Silver = 6 WHERE Name = "iron tower shield";
UPDATE itemtemplate SET Silver = 24 WHERE Name = "steel tower shield";
UPDATE itemtemplate SET Silver = 72 WHERE Name = "alloy tower shield";
UPDATE itemtemplate SET Gold = 2, Silver = 16 WHERE Name = "fine alloy tower shield";
UPDATE itemtemplate SET Gold = 4, Silver = 32 WHERE Name = "mithril tower shield";
UPDATE itemtemplate SET Gold = 6, Silver = 16 WHERE Name = "adamantium tower shield";
UPDATE itemtemplate SET Gold = 9, Silver = 72 WHERE Name = "asterite tower shield";
UPDATE itemtemplate SET Gold = 14, Silver = 58 WHERE Name = "netherium tower shield";
UPDATE itemtemplate SET Gold = 21, Silver = 87 WHERE Name = "arcanium tower shield";

UPDATE itemtemplate SET Copper = 25 WHERE Name = "bronze round shield";
UPDATE itemtemplate SET Silver = 4 WHERE Name = "iron round shield";
UPDATE itemtemplate SET Silver = 16 WHERE Name = "steel round shield";
UPDATE itemtemplate SET Silver = 48 WHERE Name = "alloy round shield";
UPDATE itemtemplate SET Gold = 1, Silver = 44 WHERE Name = "fine alloy round shield";
UPDATE itemtemplate SET Gold = 2, Silver = 88 WHERE Name = "mithril round shield";
UPDATE itemtemplate SET Gold = 4, Silver = 32 WHERE Name = "adamantium round shield";
UPDATE itemtemplate SET Gold = 6, Silver = 48 WHERE Name = "asterite round shield";
UPDATE itemtemplate SET Gold = 9, Silver = 72 WHERE Name = "netherium round shield";
UPDATE itemtemplate SET Gold = 14, Silver = 58 WHERE Name = "arcanium round shield";

UPDATE itemtemplate SET Copper = 44 WHERE Name = "bronze heater shield";
UPDATE itemtemplate SET Silver = 7 WHERE Name = "iron heater shield";
UPDATE itemtemplate SET Silver = 28 WHERE Name = "steel heater shield";
UPDATE itemtemplate SET Silver = 84 WHERE Name = "alloy heater shield";
UPDATE itemtemplate SET Gold = 2, Silver = 52 WHERE Name = "fine alloy heater shield";
UPDATE itemtemplate SET Gold = 5, Silver = 4 WHERE Name = "mithril heater shield";
UPDATE itemtemplate SET Gold = 7, Silver = 56 WHERE Name = "adamantium heater shield";
UPDATE itemtemplate SET Gold = 11, Silver = 34 WHERE Name = "asterite heater shield";
UPDATE itemtemplate SET Gold = 17, Silver = 1 WHERE Name = "netherium heater shield";
UPDATE itemtemplate SET Gold = 25, Silver = 51 Copper = 50 WHERE Name = "arcanium heater shield";

Observation:

Il manque le: -reinforced round shield
-reinforced kite shield
-reinforced tower shield
-Exceptional bucker
-Exceptional heater shield
-Exceptional block shield
-large round shield

(ils y en a mais pas avec fine alloy, mithril, adamantium, asterite, netherium, arcanium)

Voilà, le reste des armes Midgardienne est en cour, en esperant avoir fais aucune faute.

Unread post by **Cossa** » 06 Jul 2005, 18:50

Décidez vous au niveau du prix. On met quoi ? Perte et gain = 0 ou prix a la goa ? ou alors un gain mais de cb de % ?

Unread post by **KULGAR** » 06 Jul 2005, 19:29

duff wrote:pour ce qui est du prix je crois pas que a y soit et je pense que le mieux c est de le prendre autre part.

Ca c'est quand j'avais mis prix de vente = coup d'achat.

Dellgyad wrote: J'avais cru comprendre que le craft avait été remis pour une économie inter joueur (dans le sens, l'un forge des armes qu'il vend a des autres joueurs, pour pouvoir s'acheter du nouveau matériel, et revendre aux joueur, etcetc.) , et non pas inter pnj .

Le meilleur moyen d'obtenir ça est de metre le prix le prix GOA, qui veut dire, obligation de vendre ses objets à un PJ si on ne veut pas perdre.

Unread post by **Malkavien** » 06 Jul 2005, 19:57

prix de revente a la GOA me parait approprié.

Unread post by **Cossa** » 06 Jul 2005, 20:32

chef ok chef, sa fait une perte de cb de % ? (enfin si c'est fixe)

Unread post by **psyclik** » 07 Jul 2005, 05:58

Une question pour etre certain de ne pas faire d'erreurs: peut on considerer que tous les objets d'une meme categorie (toutes les Great sword par exemple) ont la meme skin ?

Il me semble que c'est le cas, mais n'ayant pas utilser tous les items du jeu, je prefere demander plutot que de me planter

.

Unread post by **duff** » 07 Jul 2005, 08:45

Bon c est super de voire que la communauté se bouge et fait avancer les choses bien plus vite que sur dol data dump ou j ai tenter de trover des gens pour aider mais rien...
bref
la bonne nouvelle c est que l update des prix et des noms crafté est excelents.
par contre, ne le faite pas pour les outils et une partie des matieres premieres. en effet, le code du craft une partie des matieres premieres hard coded dans le code ce qui fait qu il me faut absolument les meme nom.
pour resumer c est avec le nom que je retrouve les outils de craft genre alchemy kit
mortar and pestle

bref pour le craft classic ne toucher pas au nom des outils et pour les gemmes ne touchez pas au nom

Unread post by **Cossa** » 07 Jul 2005, 09:57

Au pire, ce que tu peux fournir Duff c'est une bdd (sous forme xml ou sql peut importe) ne contenant que les noms à modifier.

Donc en gros on enleve quoi ?
Les outils, les gemmes et quoi d'autres ?