这是只修扮键改装备耐力属性6倍
如果需要修改其他属性就把stat_type这个值改一下举缺衫
上面的7代表值修改耐力值·
这正腔是想要附加属性的类别，分别为:
1
生命值
3
敏捷
4
力量
5
智力
6
精神
7
耐力
用navicat8批量修改装备属性
比如连接后打开控制台输入
update
item_template
set
armor=armor*2回车
是所有护甲翻2倍
UPDATE
item_template
SET
stat_value10
=
stat_value10*2
where
stat_type10=1;
UPDATE
item_template
SET
stat_value1
=
stat_value1*2
where
stat_type1=2;
UPDATE
item_template
SET
stat_value2
=
stat_value2*2
where
stat_type2=2;
UPDATE
item_template
SET
stat_value3
=
stat_value3*2
where
stat_type3=2;
UPDATE
item_template
SET
stat_value4
=
stat_value4*2
where
stat_type4=2;
UPDATE
item_template
SET
stat_value5
=
stat_value5*2
where
stat_type5=2;
UPDATE
item_template
SET
stat_value6
=
stat_value6*2
where
stat_type6=2;
UPDATE
item_template
SET
stat_value7
=
stat_value7*2
where
stat_type7=2;
UPDATE
item_template
SET
stat_value8
=
stat_value8*2
where
stat_type8=2;
UPDATE
item_template
SET
stat_value9
=
stat_value9*2
where
stat_type9=2;
UPDATE
item_template
SET
stat_value10
=
stat_value10*2
where
stat_type10=2;
UPDATE
item_template
SET
stat_value1
=
stat_value1*2
where
stat_type1=3;
UPDATE
item_template
SET
stat_value2
=
stat_value2*2
where
stat_type2=3;
UPDATE
item_template
SET
stat_value3
=
stat_value3*2
where
stat_type3=3;
UPDATE
item_template
SET
stat_value4
=
stat_value4*2
where
stat_type4=3;
UPDATE
item_template
SET
stat_value5
=
stat_value5*2
where
stat_type5=3;
UPDATE
item_template
SET
stat_value6
=
stat_value6*2
where
stat_type6=3;
UPDATE
item_template
SET
stat_value7
=
stat_value7*2
where
stat_type7=3;
UPDATE
item_template
SET
stat_value8
=
stat_value8*2
where
stat_type8=3;
UPDATE
item_template
SET
stat_value9
=
stat_value9*2
where
stat_type9=3;
UPDATE
item_template
SET
stat_value10
=
stat_value10*2
where
stat_type10=3;
UPDATE
item_template
SET
stat_value1
=
stat_value1*2
where
stat_type1=4;
UPDATE
item_template
SET
stat_value2
=
stat_value2*2
where
stat_type2=4;
UPDATE
item_template
SET
stat_value3
=
stat_value3*2
where
stat_type3=4;
UPDATE
item_template
SET
stat_value4
=
stat_value4*2
where
stat_type4=4;
UPDATE
item_template
SET
stat_value5
=
stat_value5*2
where
stat_type5=4;
UPDATE
item_template
SET
stat_value6
=
stat_value6*2
where
stat_type6=4;
UPDATE
item_template
SET
stat_value7
=
stat_value7*2
where
stat_type7=4;
UPDATE
item_template
SET
stat_value8
=
stat_value8*2
where
stat_type8=4;
UPDATE
item_template
SET
stat_value9
=
stat_value9*2
where
stat_type9=4;
UPDATE
item_template
SET
stat_value10
=
stat_value10*2
where
stat_type10=4;
UPDATE
item_template
SET
stat_value1
=
stat_value1*2
where
stat_type1=5;
UPDATE
item_template
SET
stat_value2
=
stat_value2*2
where
stat_type2=5;
UPDATE
item_template
SET
stat_value3
=
stat_value3*2
where
stat_type3=5;
UPDATE
item_template
SET
stat_value4
=
stat_value4*2
where
stat_type4=5;
UPDATE
item_template
SET
stat_value5
=
stat_value5*2
where
stat_type5=5;
UPDATE
item_template
SET
stat_value6
=
stat_value6*2
where
stat_type6=5;
UPDATE
item_template
SET
stat_value7
=
stat_value7*2
where
stat_type7=5;
UPDATE
item_template
SET
stat_value8
=
stat_value8*2
where
stat_type8=5;
UPDATE
item_template
SET
stat_value9
=
stat_value9*2
where
stat_type9=5;
UPDATE
item_template
SET
stat_value10
=
stat_value10*2
where
stat_type10=5;
UPDATE
item_template
SET
stat_value1
=
stat_value1*2
where
stat_type1=6;
UPDATE
item_template
SET
stat_value2
=
stat_value2*2
where
stat_type2=6;
UPDATE
item_template
SET
stat_value3
=
stat_value3*2
where
stat_type3=6;
UPDATE
item_template
SET
stat_value4
=
stat_value4*2
where
stat_type4=6;
UPDATE
item_template
SET
stat_value5
=
stat_value5*2
where
stat_type5=6;
UPDATE
item_template
SET
stat_value6
=
stat_value6*2
where
stat_type6=6;
UPDATE
item_template
SET
stat_value7
=
stat_value7*2
where
stat_type7=6;
UPDATE
item_template
SET
stat_value8
=
stat_value8*2
where
stat_type8=6;
UPDATE
item_template
SET
stat_value9
=
stat_value9*2
where
stat_type9=6;
UPDATE
item_template
SET
stat_value10
=
stat_value10*2
where
stat_type10=6;
UPDATE
item_template
SET
stat_value1
=
stat_value1*2
where
stat_type1=7;
UPDATE
item_template
SET
stat_value2
=
stat_value2*2
where
stat_type2=7;
UPDATE
item_template
SET
stat_value3
=
stat_value3*2
where
stat_type3=7;
UPDATE
item_template
SET
stat_value4
=
stat_value4*2
where
stat_type4=7;
UPDATE
item_template
SET
stat_value5
=
stat_value5*2
where
stat_type5=7;
UPDATE
item_template
SET
stat_value6
=
stat_value6*2
where
stat_type6=7;
UPDATE
item_template
SET
stat_value7
=
stat_value7*2
where
stat_type7=7;
UPDATE
item_template
SET
stat_value8
=
stat_value8*2
where
stat_type8=7;
UPDATE
item_template
SET
stat_value9
=
stat_value9*2
where
stat_type9=7;
UPDATE
item_template
SET
stat_value10
=
stat_value10*2
where
stat_type10=7;