Bloody Pvp Pow / Resi update

-- Head, Chest, Legs
UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 8, 14)
, stat_value10 = if(name LIKE "Bloodforged%", 12, 18)
, spellid_4 = if(name LIKE "Bloodforged%", 101708, 101714)
WHERE InventoryType IN (1, 5, 7, 20) #Head, Chest, Legs
AND subclass = 1 #Cloth
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;

UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 8, 14)
, stat_value10 = if(name LIKE "Bloodforged%", 10, 16)
, spellid_4 = if(name LIKE "Bloodforged%", 101708, 101714)
WHERE InventoryType IN (1, 5, 7, 20) #Head, Chest, Legs
AND subclass = 2 #Leather
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;

UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 8, 14)
, stat_value10 = if(name LIKE "Bloodforged%", 8, 13)
, spellid_4 = if(name LIKE "Bloodforged%", 101708, 101714)
WHERE InventoryType IN (1, 5, 7, 20) #Head, Chest, Legs
AND subclass = 3 #Mail
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;

UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 8, 14)
, stat_value10 = if(name LIKE "Bloodforged%", 7, 12)
, spellid_4 = if(name LIKE "Bloodforged%", 101708, 101714)
WHERE InventoryType IN (1, 5, 7, 20) #Head, Chest, Legs
AND subclass = 4 #Plate
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;

-- Shoulders, Boots, Gloves, Waist
UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 6, 12)
, stat_value10 = if(name LIKE "Bloodforged%", 10, 14)
, spellid_4 = if(name LIKE "Bloodforged%", 101706, 101712)
WHERE InventoryType IN (3, 6, 8, 10) #Shoulders, Boots, Gloves, Waist
AND subclass = 1 #Cloth
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;


UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 6, 12)
, stat_value10 = if(name LIKE "Bloodforged%", 8, 13)
, spellid_4 = if(name LIKE "Bloodforged%", 101706, 101712)
WHERE InventoryType IN (3, 6, 8, 10) #Shoulders, Boots, Gloves, Waist
AND subclass = 2 #Leather
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;

UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 6, 12)
, stat_value10 = if(name LIKE "Bloodforged%", 7, 11)
, spellid_4 = if(name LIKE "Bloodforged%", 101706, 101712)
WHERE InventoryType IN (3, 6, 8, 10) #Shoulders, Boots, Gloves, Waist
AND subclass = 3 #Mail
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;

UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 6, 12)
, stat_value10 = if(name LIKE "Bloodforged%", 6, 10)
, spellid_4 = if(name LIKE "Bloodforged%", 101706, 101712)
WHERE InventoryType IN (3, 6, 8, 10) #Shoulders, Boots, Gloves, Waist
AND subclass = 4 #Plate
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;

-- Bracers
UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 5, 10)
, stat_value10 = if(name LIKE "Bloodforged%", 8, 11)
, spellid_4 = if(name LIKE "Bloodforged%", 101705, 101710)
WHERE InventoryType IN (9) #Bracers
AND subclass = 1 #Cloth
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;

UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 5, 10)
, stat_value10 = if(name LIKE "Bloodforged%", 7, 10)
, spellid_4 = if(name LIKE "Bloodforged%", 101705, 101710)
WHERE InventoryType IN (9) #Bracers
AND subclass = 2 #Leather
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;

UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 5, 10)
, stat_value10 = if(name LIKE "Bloodforged%", 6, 8)
, spellid_4 = if(name LIKE "Bloodforged%", 101705, 101710)
WHERE InventoryType IN (9) #Bracers
AND subclass = 3 #Mail
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;

UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 5, 10)
, stat_value10 = if(name LIKE "Bloodforged%", 5, 7)
, spellid_4 = if(name LIKE "Bloodforged%", 101705, 101710)
WHERE InventoryType IN (9) #Bracers
AND subclass = 4 #Plate
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;

-- Neck, Cloak, Ring, Trinket, Shield, Offhand, Ranged, Wand, 1h
UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 4, 6)
, stat_value10 = if(name LIKE "Bloodforged%", 4, 6)
, spellid_4 = if(name LIKE "Bloodforged%", 101704, 101706)
WHERE InventoryType IN (2, 11, 12, 13, 14, 15, 16, 21, 21, 22, 23, 25, 26, 28)
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;

-- 2h
UPDATE item_template
SET PvPpower = if(name LIKE "Bloodforged%", 8, 12)
, stat_value10 = if(name LIKE "Bloodforged%", 8, 12)
, spellid_4 = if(name LIKE "Bloodforged%", 101708, 101712)
WHERE InventoryType IN (17)
AND stat_type10 <> 0 AND pvppower <> 0 AND spellid_4 <> 0
AND requiredlevel BETWEEN 61 AND 70 AND NAME LIKE "Bloodforged%" AND stat_value10 > 0 AND pvppower > 0;