魔獸單機(jī)3.35 如何批量修改裝備屬性
這是只修扮鍵改裝備耐力屬性6倍
如果需要修改其他屬性就把stat_type這個(gè)值改一下舉缺衫
上面的7代表值修改耐力值·
這正腔是想要附加屬性的類別，分別為:
1
生命值
3
敏捷
4
力量
5
智力
6
精神
7
耐力
用navicat8批量修改裝備屬性
比如連接后打開控制臺輸入
update
item_template
set
armor=armor*2回車
是所有護(hù)甲翻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;
強(qiáng)推
