这是只修扮键改装备耐力属性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;