艾泽拉斯遗产单机畅游~~~惠民便利修改方案节选~~（N8运行）

stat_value1*10 WHERE stat_type1=35; UPDATE item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=35; UPDATE item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=35; UPDATE item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=35; UPDATE item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=35; UPDATE item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=35; UPDATE item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=35; UPDATE item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=35; UPDATE item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=35;

UPDATE item_template SET stat_value10 = stat_value10*10 WHERE stat_type10=35; 修改急速等级

UPDATE item_template SET

stat_value1 = stat_value1*10 WHERE stat_type1=36; UPDATE item_template SET

stat_value2 = stat_value2*10 WHERE stat_type2=36; UPDATE item_template SET

stat_value3 = stat_value3*10 WHERE stat_type3=36; UPDATE item_template SET

stat_value4 = stat_value4*10 WHERE stat_type4=36; UPDATE item_template SET

stat_value5 = stat_value5*10 WHERE stat_type5=36; UPDATE item_template SET

stat_value6 = stat_value6*10 WHERE stat_type6=36; UPDATE item_template SET

stat_value7 = stat_value7*10 WHERE stat_type7=36; UPDATE item_template SET

stat_value8 = stat_value8*10 WHERE stat_type8=36; UPDATE item_template SET

stat_value9 = stat_value9*10 WHERE stat_type9=36; UPDATE item_template SET

stat_value10 = stat_value10*10 WHERE stat_type10=36; 修改攻击强度等级

UPDATE

item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=38; UPDATE

item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=38; UPDATE

item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=38; UPDATE

item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=38; UPDATE

item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=38; UPDATE

item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=38; UPDATE

item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=38; UPDATE

item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=38; UPDATE

item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=38; UPDATE

item_template SET stat_value10 = stat_value10*10 WHERE stat_type10=38; 修改每5秒回蓝

UPDATE item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=43; UPDATE item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=43; UPDATE item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=43; UPDATE item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=43; UPDATE item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=43; UPDATE item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=43; UPDATE item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=43; UPDATE item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=43; UPDATE item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=43;

UPDATE item_template SET stat_value10 = stat_value10*10 WHERE stat_type10=43; 修改护甲穿透等级

UPDATE item_template SET

stat_value1 = stat_value1*10 WHERE stat_type1=44; UPDATE item_template SET

stat_value2 = stat_value2*10 WHERE stat_type2=44;

UPDATE item_template SET

stat_value3 = stat_value3*10 WHERE stat_type3=44; UPDATE item_template SET

stat_value4 = stat_value4*10 WHERE stat_type4=44; UPDATE item_template SET

stat_value5 = stat_value5*10 WHERE stat_type5=44; UPDATE item_template SET

stat_value6 = stat_value6*10 WHERE stat_type6=44; UPDATE item_template SET

stat_value7 = stat_value7*10 WHERE stat_type7=44; UPDATE item_template SET

stat_value8 = stat_value8*10 WHERE stat_type8=44; UPDATE item_template SET

stat_value9 = stat_value9*10 WHERE stat_type9=44; UPDATE item_template SET

stat_value10 = stat_value10*10 WHERE stat_type10=44; 修改法术强度等级

UPDATE

item_template SET stat_value1 = stat_value1*3 WHERE stat_type1=45; UPDATE

item_template SET stat_value2 = stat_value2*3 WHERE stat_type2=45; UPDATE

item_template SET stat_value3 = stat_value3*3 WHERE stat_type3=45; UPDATE

item_template SET stat_value4 = stat_value4*3 WHERE stat_type4=45; UPDATE

item_template SET stat_value5 = stat_value5*3 WHERE stat_type5=45; UPDATE

item_template SET stat_value6 = stat_value6*3 WHERE stat_type6=45; UPDATE

item_template SET stat_value7 = stat_value7*3 WHERE stat_type7=45; UPDATE

item_template SET stat_value8 = stat_value8*3 WHERE stat_type8=45; UPDATE

item_template SET stat_value9 = stat_value9*3 WHERE stat_type9=45; UPDATE

item_template SET stat_value10 = stat_value10*3 WHERE stat_type10=45;

教程 4 批量修改武器/装备属性

UPDATE `item_template` SET stat_value1 =stat_value1*3; UPDATE `item_template` SET stat_value2 =stat_value2*3; UPDATE `item_template` SET stat_value3 =stat_value3*3; UPDATE `item_template` SET stat_value4 =stat_value4*3; UPDATE `item_template` SET stat_value5 =stat_value5*3; UPDATE `item_template` SET stat_value6 =stat_value6*3; UPDATE `item_template` SET stat_value7 =stat_value7*3; UPDATE `item_template` SET stat_value8 =stat_value8*3; UPDATE `item_template` SET stat_value9 =stat_value9*3; UPDATE `item_template` SET stat_value10 =stat_value10*3; UPDATE `item_template` SET dmg_min1 = dmg_min1*3; UPDATE `item_template` SET dmg_min2 = dmg_min2*3; UPDATE `item_template` SET dmg_min3 = dmg_min3*3; UPDATE `item_template` SET dmg_min4 = dmg_min4*3; UPDATE `item_template` SET dmg_min5 = dmg_min5*3; UPDATE `item_template` SET dmg_max1 = dmg_max1*3; UPDATE `item_template` SET dmg_max2 = dmg_max2*3; UPDATE `item_template` SET dmg_max3 = dmg_max3*3; UPDATE `item_template` SET dmg_max4 = dmg_max4*3; UPDATE `item_template` SET dmg_max5 = dmg_max5*3; UPDATE `item_template` SET armor = armor*3;

UPDATE `item_template` SET holy_res = holy_res*3; UPDATE `item_template` SET fire_res = fire_res*3;

UPDATE `item_template` SET nature_res = nature_res*3; UPDATE `item_template` SET frost_res = frost_res*3;

UPDATE `item_template` SET shadow_res = shadow_res*3; UPDATE `item_template` SET arcane_res =arcane_res*3;

装备所有属性都乘以3倍包括[教程3]提到的武器伤害(后面的倍数可自行修改),包括绿字属性(如:急速等级