Bloodforged item PVP power fix

UPDATE item_template
SET PvPpower = 1
, stat_value10 = 1
, spellid_4 = 101701
WHERE PvPpower > 1
AND requiredlevel BETWEEN 41 AND 70
AND name LIKE 'Bloodforged%'
AND stat_type10 = 35
AND (stat_value10 = 0 OR stat_value10 IS NULL);



UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 24, 42)
, stat_value10 = if(name LIKE 'Bloodforged%', 12, 18)
, spellid_4 = if(name LIKE 'Bloodforged%', 101724, 101742)
WHERE InventoryType IN (1, 5, 7, 20) #Head, Chest, Legs
AND subclass = 1 #Cloth
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 24, 42)
, stat_value10 = if(name LIKE 'Bloodforged%', 10, 16)
, spellid_4 = if(name LIKE 'Bloodforged%', 101724, 101742)
WHERE InventoryType IN (1, 5, 7, 20) #Head, Chest, Legs
AND subclass = 2 #Leather
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 24, 42)
, stat_value10 = if(name LIKE 'Bloodforged%', 8, 13)
, spellid_4 = if(name LIKE 'Bloodforged%', 101724, 101742)
WHERE InventoryType IN (1, 5, 7, 20) #Head, Chest, Legs
AND subclass = 3 #Mail
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 24, 42)
, stat_value10 = if(name LIKE 'Bloodforged%', 7, 12)
, spellid_4 = if(name LIKE 'Bloodforged%', 101724, 101742)
WHERE InventoryType IN (1, 5, 7, 20) #Head, Chest, Legs
AND subclass = 4 #Plate
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

-- Shoulders, Boots, Gloves, Waist
UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 18, 36)
, stat_value10 = if(name LIKE 'Bloodforged%', 10, 14)
, spellid_4 = if(name LIKE 'Bloodforged%', 101718, 101736)
WHERE InventoryType IN (3, 6, 8, 10) #Shoulders, Boots, Gloves, Waist
AND subclass = 1 #Cloth
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;


UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 18, 36)
, stat_value10 = if(name LIKE 'Bloodforged%', 8, 13)
, spellid_4 = if(name LIKE 'Bloodforged%', 101718, 101736)
WHERE InventoryType IN (3, 6, 8, 10) #Shoulders, Boots, Gloves, Waist
AND subclass = 2 #Leather
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 18, 36)
, stat_value10 = if(name LIKE 'Bloodforged%', 7, 11)
, spellid_4 = if(name LIKE 'Bloodforged%', 101718, 101736)
WHERE InventoryType IN (3, 6, 8, 10) #Shoulders, Boots, Gloves, Waist
AND subclass = 3 #Mail
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 18, 36)
, stat_value10 = if(name LIKE 'Bloodforged%', 6, 10)
, spellid_4 = if(name LIKE 'Bloodforged%', 101718, 101736)
WHERE InventoryType IN (3, 6, 8, 10) #Shoulders, Boots, Gloves, Waist
AND subclass = 4 #Plate
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

-- Bracers
UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 15, 30)
, stat_value10 = if(name LIKE 'Bloodforged%', 8, 11)
, spellid_4 = if(name LIKE 'Bloodforged%', 101715, 101730)
WHERE InventoryType IN (9) #Bracers
AND subclass = 1 #Cloth
AND stat_type10 = 35
and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100)
AND pvppower BETWEEN 1 and 100
AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 15, 30)
, stat_value10 = if(name LIKE 'Bloodforged%', 7, 10)
, spellid_4 = if(name LIKE 'Bloodforged%', 101715, 101730)
WHERE InventoryType IN (9) #Bracers
AND subclass = 2 #Leather
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 15, 30)
, stat_value10 = if(name LIKE 'Bloodforged%', 6, 8)
, spellid_4 = if(name LIKE 'Bloodforged%', 101715, 101730)
WHERE InventoryType IN (9) #Bracers
AND subclass = 3 #Mail
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 15, 30)
, stat_value10 = if(name LIKE 'Bloodforged%', 5, 7)
, spellid_4 = if(name LIKE 'Bloodforged%', 101715, 101730)
WHERE InventoryType IN (9) #Bracers
AND subclass = 4 #Plate
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

-- Neck, Cloak, Ring, Trinket
UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 12, 18)
, stat_value10 = if(name LIKE 'Bloodforged%', 4, 6)
, spellid_4 = if(name LIKE 'Bloodforged%', 101712, 101718)
WHERE InventoryType IN (2, 11, 12, 16)
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

-- Shield, Offhand, Ranged, Wand, 1h
UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 12, 24)
, stat_value10 = if(name LIKE 'Bloodforged%', 4, 8)
, spellid_4 = if(name LIKE 'Bloodforged%', 101712, 101724)
WHERE InventoryType IN (13, 14, 15, 21, 21, 22, 23, 25, 26, 28)
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

-- 2h
UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 16, 48)
, stat_value10 = if(name LIKE 'Bloodforged%', 8, 16)
, spellid_4 = if(name LIKE 'Bloodforged%', 101716, 101748)
WHERE InventoryType IN (17)
AND stat_type10 = 35 and if(name LIKE 'Bloodforged%', stat_value10 BETWEEN 0 AND 100 , stat_value10 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;


UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 12, 12)
#, stat_value9 = if(name LIKE 'Bloodforged%', 4, 6)
, spellid_4 = if(name LIKE 'Bloodforged%', 101712, 101712)
WHERE InventoryType IN (2, 11, 12, 16)
AND stat_type9 = 35 and if(name LIKE 'Bloodforged%', stat_value9 BETWEEN 0 AND 100 , stat_value9 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

-- Shield, Offhand, Ranged, Wand, 1h
UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 12, 12)
#, stat_value9 = if(name LIKE 'Bloodforged%', 4, 8)
, spellid_4 = if(name LIKE 'Bloodforged%', 101712, 101712)
WHERE InventoryType IN (13, 14, 15, 21, 21, 22, 23, 25, 26, 28)
AND stat_type9 = 35 and if(name LIKE 'Bloodforged%', stat_value9 BETWEEN 0 AND 100 , stat_value9 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;

-- 2h
UPDATE item_template
SET PvPpower = if(name LIKE 'Bloodforged%', 16, 16)
#, stat_value9 = if(name LIKE 'Bloodforged%', 8, 16)
, spellid_4 = if(name LIKE 'Bloodforged%', 101716, 101716)
WHERE InventoryType IN (17)
AND stat_type9 = 35 and if(name LIKE 'Bloodforged%', stat_value9 BETWEEN 0 AND 100 , stat_value9 BETWEEN 1 AND 100) AND pvppower BETWEEN 1 and 100 AND spellid_4 <> 0
AND requiredlevel BETWEEN 41 AND 70;