魔兽世界命令修改装备属性

本帖最后由 maimsx 于 2015-8-12 11:13 编辑

使用前请安装Navicat 8.0.20 以上版本

在工具下选中你的数据库`

然后按F6输入下面你想要的命令，如果不行就进入到你要修改的文件里，再按F6，菜单里也可以找到命令输入这个功能。

把命令复制进去，记得带;号，然后回车就可以，不要把中文也复制进去。命令可以一个一个复制回车


命令分析：以护甲值变成原来的4倍为例 UPDATE item_template SET armor = armor*4;  命令里的 item_template是物品属性这个文件，armor是item_template这个文件里面的一项属性栏目，如果端里的名称不是这些，改成你现在端里对应的名称就可以。乘是*，除是/，UPDATE是升级的意思吧，SET是设置，这2个大写的单词是固定的，具体的意思应该懂了吧

复制回车，也可以几条命令一起复制，再回车

NPC修改

NPC的攻击延迟 除于2

UPDATE creature_proto SET attacktime = attacktime/2;

NPC的最小和最大HP血量值 3倍

UPDATE creature_proto SET maxhealth = maxhealth*3;

UPDATE creature_proto SET minhealth = minhealth*3;

NPC的最小和最大伤害值 3倍

UPDATE creature_proto SET mindamage = mindamage*3;

UPDATE creature_proto SET maxdamage = maxdamage*3;

NPC掉落金钱 10倍

UPDATE creature_proto SET money = money*10;

修改装备属性

用navicat数据库导入

进navicat

在mangos的item_template导入

导成功后看item_template里的StatsCount栏下是不是都是10

UPDATE item_template SET StatsCount = 10;

改成10后，一些自定义的装备就可以带属性了（例如背包）

装备批量精练属性修改

护甲值

4倍

UPDATE item_template SET armor = armor*4;

最小和最大武器伤害值

*10是10倍的意思

UPDATE item_template SET dmg_min1 = dmg_min1*20;

UPDATE item_template SET dmg_max1 = dmg_max1*20;

武器攻击速度延迟 /2是除2的意思（武器攻击间隔降低2倍，2秒一次变成1秒一次）

UPDATE item_template SET delay = delay/2;

盾牌格挡10倍

UPDATE item_template SET block = block*10;

装备的抵抗抗性 6倍

UPDATE item_template SET holy_res = holy_res*6;

UPDATE item_template SET fire_res = fire_res*6;

UPDATE item_template SET nature_res = nature_res*6;

UPDATE item_template SET frost_res = frost_res*6;

UPDATE item_template SET shadow_res = shadow_res*6;

UPDATE item_template SET arcane_res = arcane_res*6;

购买商品价钱 3倍（其实这个用除法比较好）

UPDATE item_template SET buyprice = buyprice*3;

卖出商品价钱 3倍

UPDATE item_template SET sellprice = sellprice*3;

修改敏捷20倍

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

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

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

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

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

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

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

修改力量20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=4;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=4;

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

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

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

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

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=4;

修改智力20倍

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

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

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

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

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

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

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=5;

修改精神20倍

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

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

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

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

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

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

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=6;

修改耐力20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=7;

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

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

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

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

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

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=7;

修改武器等级20倍

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

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

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

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

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

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

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

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

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

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=11;

修改防御等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=12;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=12;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=12;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=12;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=12;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=12;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=12;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=12;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=12;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=12;

修改躲避等级20倍

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

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

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

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

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

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

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

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

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

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=13;

修改招架等级20倍

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

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

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

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

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

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

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

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

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

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=14;

修改盾格档等级20倍

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

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

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

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

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

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

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

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

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

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=15;

修改命中等级20倍

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

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

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

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

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

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=16;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=16;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=16;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=16;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=16;

修改远程命中等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=17;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=17;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=17;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=17;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=17;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=17;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=17;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=17;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=17;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=17;

修改法术命中等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=18;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=18;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=18;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=18;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=18;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=18;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=18;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=18;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=18;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=18;

修改法术暴击等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=21;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=21;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=21;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=21;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=21;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=21;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=21;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=21;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=21;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=21;

修改近战躲避等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=22;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=22;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=22;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=22;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=22;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=22;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=22;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=22;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=22;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=22;

修改远程躲避等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=23;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=23;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=23;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=23;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=23;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=23;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=23;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=23;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=23;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=23;

修改法术躲避等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=24;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=24;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=24;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=24;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=24;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=24;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=24;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=24;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=24;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=24;

修改近战致命躲避等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=25;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=25;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=25;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=25;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=25;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=25;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=25;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=25;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=25;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=25;

修改远程致命躲避等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=26;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=26;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=26;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=26;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=26;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=26;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=26;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=26;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=26;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=26;

修改法术致命躲避等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=27;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=27;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=27;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=27;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=27;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=27;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=27;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=27;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=27;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=27;

修改近战加速等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=28;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=28;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=28;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=28;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=28;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=28;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=28;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=28;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=28;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=28;

修改远程加速等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=29;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=29;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=29;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=29;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=29;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=29;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=29;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=29;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=29;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=29;

修改法术加速等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=30;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=30;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=30;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=30;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=30;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=30;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=30;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=30;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=30;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=30;

修改命中等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=31;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=31;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=31;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=31;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=31;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=31;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=31;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=31;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=31;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=31;

修改暴击等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=32;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=32;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=32;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=32;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=32;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=32;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=32;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=32;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=32;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=32;

修改击中躲避等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=33;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=33;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=33;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=33;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=33;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=33;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=33;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=33;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=33;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=33;

修改暴击躲避等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=34;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=34;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=34;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=34;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=34;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=34;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=34;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=34;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=34;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=34;

修改韧性等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=35;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=35;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=35;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=35;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=35;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=35;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=35;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=35;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=35;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=35;

修改急速等级20倍

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

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

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

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

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

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

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

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

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

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=36;

修改精准等级20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=37;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=37;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=37;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=37;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=37;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=37;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=37;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=37;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=37;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=37;

修改攻击强度等级20倍

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

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

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

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

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

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

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

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

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

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=38;

修改每5秒回蓝20倍

UPDATE item_template SET stat_value1 = stat_value1*20 WHERE stat_type1=43;

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=43;

UPDATE item_template SET stat_value3 = stat_value3*20 WHERE stat_type3=43;

UPDATE item_template SET stat_value4 = stat_value4*20 WHERE stat_type4=43;

UPDATE item_template SET stat_value5 = stat_value5*20 WHERE stat_type5=43;

UPDATE item_template SET stat_value6 = stat_value6*20 WHERE stat_type6=43;

UPDATE item_template SET stat_value7 = stat_value7*20 WHERE stat_type7=43;

UPDATE item_template SET stat_value8 = stat_value8*20 WHERE stat_type8=43;

UPDATE item_template SET stat_value9 = stat_value9*20 WHERE stat_type9=43;

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=43;

修改护甲穿透等级20倍

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

UPDATE item_template SET stat_value2 = stat_value2*20 WHERE stat_type2=44;

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

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

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

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

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

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

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

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=44;

修改法术强度等级20倍

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

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

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

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

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

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

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

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

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

UPDATE item_template SET stat_value10 = stat_value10*20 WHERE stat_type10=45;