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

stat_value2*3 WHERE stat_type2=4;

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

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

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

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

UPDATE item_template SET stat_value7 = stat_value7*3 WHERE stat_type7=4; 修改智力

UPDATE item_template SET

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

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

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

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

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

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

stat_value7 = stat_value7*3 WHERE stat_type7=5; 修改精神

UPDATE item_template

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

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

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

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

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

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

stat_value7 = stat_value7*3 WHERE stat_type7=6; 修改耐力

UPDATE item_template

SET stat_value1 = stat_value1*3 WHERE stat_type1=7;

UPDATE item_template SET

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

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

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

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

stat_value6 = stat_value3*3 WHERE stat_type6=7; UPDATE item_template SET

stat_value7 = stat_value7*3 WHERE stat_type7=7; 修改武器等级

UPDATE

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

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

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

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

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

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

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

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

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

item_template SET stat_value10 = stat_value10*3 WHERE stat_type10=11; 修改防御等级

UPDATE item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=12; UPDATE item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=12; UPDATE item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=12; UPDATE item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=12; UPDATE item_template SET stat_value5 =

stat_value5*10 WHERE stat_type5=12; UPDATE item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=12; UPDATE item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=12; UPDATE item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=12; UPDATE item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=12;

UPDATE item_template SET stat_value10 = stat_value10*10 WHERE stat_type10=12; 修改躲避等级

UPDATE item_template SET

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

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

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

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

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

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

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

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

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

stat_value10 = stat_value10*10 WHERE stat_type10=13; 修改招架等级

UPDATE

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

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

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

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

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

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

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

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

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

item_template SET stat_value10 = stat_value10*10 WHERE stat_type10=14; 修改盾格档等级

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

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

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

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

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

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

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

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

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

UPDATE item_template SET stat_value10 = stat_value10*3 WHERE stat_type10=15; 修改命中等级

UPDATE item_template SET

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

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

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

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

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

stat_value6 = stat_value6*3 WHERE stat_type6=16;