• 网站首页
  • 传奇技术
  • 传世技术
  • 奇迹技术
  • 魔兽技术
  • 魔域技术
  • 江湖技术
  • 其他技术
  • 传三技术
  • 完美技术
  • 诛仙技术
  • 游戏程序

    • 软件文章

    您当前的位置：首页 > 魔兽技术

    魔兽世界批量修改装备属性的方法

    本文出处：网游动力作者：本站发布时间：2009-12-29阅读次数：

    使用前请安装Navicat 8.0.20 在工具下选中你的数据库`
    然后按F6输入下面你想要的命令
    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;


    装备批量精准属性修改

    护甲值
    3倍
    UPDATE item_template SET armor = armor*3;
    最小和最大武器伤害值
    *30是30倍的意思
    UPDATE item_template SET dmg_min1 = dmg_min1*30;
    UPDATE
    item_template SET dmg_max1 = dmg_max1*30;
    武器攻击速度延迟 /2是除2的意思
    UPDATE
    item_template SET delay = delay/2;
    装备的抵抗抗性 2倍
    UPDATE item_template SET
    holy_res = holy_res*2;
    UPDATE item_template SET fire_res =
    fire_res*2;
    UPDATE item_template SET nature_res = nature_res*2;
    UPDATE
    item_template SET frost_res = frost_res*2;
    UPDATE item_template SET
    shadow_res = shadow_res*2;
    UPDATE item_template SET arcane_res =
    arcane_res*2;
    购买商品价钱 3倍
    UPDATE item_template SET buyprice =
    buyprice*3;
    卖出商品价钱 3倍
    UPDATE item_template SET sellprice =
    sellprice*3;
    修改敏捷
    UPDATE item_template SET stat_value1 = stat_value1*10
    WHERE stat_type1=3;
    UPDATE iitem_template SET stat_value2 = stat_value2*10
    WHERE stat_type2=3;
    UPDATE item_template SET stat_value3 = stat_value3*10
    WHERE stat_type3=3;
    UPDATE item_template SET stat_value4 = stat_value4*10
    WHERE stat_type4=3;
    UPDATE item_template SET stat_value5 = stat_value5*10
    WHERE stat_type5=3;
    UPDATE item_template SET stat_value6 = stat_value6*10
    WHERE stat_type6=3;
    UPDATE item_template SET stat_value7 = stat_value7*10
    WHERE stat_type7=3;
    修改力量
    UPDATE item_template SET stat_value1 =
    stat_value1*10 WHERE stat_type1=4;
    UPDATE item_template SET stat_value2 =
    stat_value2*10 WHERE stat_type2=4;
    UPDATE item_template SET stat_value3 =
    stat_value3*10 WHERE stat_type3=4;
    UPDATE item_template SET stat_value4 =
    stat_value4*10 WHERE stat_type4=4;
    UPDATE item_template SET stat_value5 =
    stat_value5*10 WHERE stat_type5=4;
    UPDATE item_template SET stat_value6 =
    stat_value6*10 WHERE stat_type6=4;
    UPDATE item_template SET stat_value7 =
    stat_value7*10 WHERE stat_type7=4;
    修改智力
    UPDATE item_template SET
    stat_value1 = stat_value1*10 WHERE stat_type1=5;
    UPDATE item_template SET
    stat_value2 = stat_value2*10 WHERE stat_type2=5;
    UPDATE item_template SET
    stat_value3 = stat_value3*10 WHERE stat_type3=5;
    UPDATE item_template SET
    stat_value4 = stat_value4*10 WHERE stat_type4=5;
    UPDATE item_template SET
    stat_value5 = stat_value5*10 WHERE stat_type5=5;
    UPDATE item_template SET
    stat_value6 = stat_value6*10 WHERE stat_type6=5;
    UPDATE item_template SET
    stat_value7 = stat_value7*10 WHERE stat_type7=5;
    修改精神
    UPDATE item_template
    SET stat_value1 = stat_value1*10 WHERE stat_type1=6;
    UPDATE item_template SET
    stat_value2 = stat_value2*10 WHERE stat_type2=6;
    UPDATE item_template SET
    stat_value3 = stat_value3*10 WHERE stat_type3=6;
    UPDATE item_template SET
    stat_value4 = stat_value4*10 WHERE stat_type4=6;
    UPDATE item_template SET
    stat_value5 = stat_value5*10 WHERE stat_type5=6;
    UPDATE item_template SET
    stat_value6 = stat_value6*10 WHERE stat_type6=6;
    UPDATE item_template SET
    stat_value7 = stat_value7*10 WHERE stat_type7=6;
    修改耐力
    UPDATE item_template
    SET stat_value1 = stat_value1*10 WHERE stat_type1=7;
    UPDATE item_template SET
    stat_value2 = stat_value2*10 WHERE stat_type2=7;
    UPDATE item_template SET
    stat_value3 = stat_value3*10 WHERE stat_type3=7;
    UPDATE item_template SET
    stat_value4 = stat_value4*10 WHERE stat_type4=7;
    UPDATE item_template SET
    stat_value5 = stat_value5*10 WHERE stat_type5=7;
    UPDATE item_template SET
    stat_value6 = stat_value3*10 WHERE stat_type6=7;
    UPDATE item_template SET
    stat_value7 = stat_value7*10 WHERE stat_type7=7;
    修改武器等级
    UPDATE
    item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=11;
    UPDATE
    item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=11;
    UPDATE
    item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=11;
    UPDATE
    item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=11;
    UPDATE
    item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=11;
    UPDATE
    item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=11;
    UPDATE
    item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=11;
    UPDATE
    item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=11;
    UPDATE
    item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=11;
    UPDATE
    item_template SET stat_value10 = stat_value10*10 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*10 WHERE stat_type1=15;
    UPDATE item_template SET stat_value2 =
    stat_value2*10 WHERE stat_type2=15;
    UPDATE item_template SET stat_value3 =
    stat_value3*10 WHERE stat_type3=15;
    UPDATE item_template SET stat_value4 =
    stat_value4*10 WHERE stat_type4=15;
    UPDATE item_template SET stat_value5 =
    stat_value5*10 WHERE stat_type5=15;
    UPDATE item_template SET stat_value6 =
    stat_value6*10 WHERE stat_type6=15;
    UPDATE item_template SET stat_value7 =
    stat_value7*10 WHERE stat_type7=15;
    UPDATE item_template SET stat_value8 =
    stat_value8*10 WHERE stat_type8=15;
    UPDATE item_template SET stat_value9 =
    stat_value9*10 WHERE stat_type9=15;
    UPDATE item_template SET stat_value10 =
    stat_value10*10 WHERE stat_type10=15;
    修改命中等级
    UPDATE item_template SET
    stat_value1 = stat_value1*10 WHERE stat_type1=16;
    UPDATE item_template SET
    stat_value2 = stat_value2*10 WHERE stat_type2=16;
    UPDATE item_template SET
    stat_value3 = stat_value3*10 WHERE stat_type3=16;
    UPDATE item_template SET
    stat_value4 = stat_value4*10 WHERE stat_type4=16;
    UPDATE item_template SET
    stat_value5 = stat_value5*10 WHERE stat_type5=16;
    UPDATE item_template SET
    stat_value6 = stat_value6*10 WHERE stat_type6=16;
    UPDATE item_template SET
    stat_value7 = stat_value7*10 WHERE stat_type7=16;
    UPDATE item_template SET
    stat_value8 = stat_value8*10 WHERE stat_type8=16;
    UPDATE item_template SET
    stat_value9 = stat_value9*10 WHERE stat_type9=16;
    UPDATE item_template SET
    stat_value10 = stat_value10*10 WHERE stat_type10=16;
    修改远程命中等级
    UPDATE
    item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=17;
    UPDATE
    item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=17;
    UPDATE
    item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=17;
    UPDATE
    item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=17;
    UPDATE
    item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=17;
    UPDATE
    item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=17;
    UPDATE
    item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=17;
    UPDATE
    item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=17;
    UPDATE
    item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=17;
    UPDATE
    item_template SET stat_value10 = stat_value10*10 WHERE
    stat_type10=17;
    修改法术命中等级
    UPDATE item_template SET stat_value1 =
    stat_value1*10 WHERE stat_type1=18;
    UPDATE item_template SET stat_value2 =
    stat_value2*10 WHERE stat_type2=18;
    UPDATE item_template SET stat_value3 =
    stat_value3*10 WHERE stat_type3=18;
    UPDATE item_template SET stat_value4 =
    stat_value4*10 WHERE stat_type4=18;
    UPDATE item_template SET stat_value5 =
    stat_value5*10 WHERE stat_type5=18;
    UPDATE item_template SET stat_value6 =
    stat_value6*10 WHERE stat_type6=18;
    UPDATE item_template SET stat_value7 =
    stat_value7*10 WHERE stat_type7=18;
    UPDATE item_template SET stat_value8 =
    stat_value8*10 WHERE stat_type8=18;
    UPDATE item_template SET stat_value9 =
    stat_value9*10 WHERE stat_type9=18;
    UPDATE item_template SET stat_value10 =
    stat_value10*10 WHERE stat_type10=18;
    修改法术暴击等级
    UPDATE item_template SET
    stat_value1 = stat_value1*10 WHERE stat_type1=21;
    UPDATE item_template SET
    stat_value2 = stat_value2*10 WHERE stat_type2=21;
    UPDATE item_template SET
    stat_value3 = stat_value3*10 WHERE stat_type3=21;
    UPDATE item_template SET
    stat_value4 = stat_value4*10 WHERE stat_type4=21;
    UPDATE item_template SET
    stat_value5 = stat_value5*10 WHERE stat_type5=21;
    UPDATE item_template SET
    stat_value6 = stat_value6*10 WHERE stat_type6=21;
    UPDATE item_template SET
    stat_value7 = stat_value7*10 WHERE stat_type7=21;
    UPDATE item_template SET
    stat_value8 = stat_value8*10 WHERE stat_type8=21;
    UPDATE item_template SET
    stat_value9 = stat_value9*10 WHERE stat_type9=21;
    UPDATE item_template SET
    stat_value10 = stat_value10*10 WHERE stat_type10=21;
    修改近战躲避等级
    UPDATE
    item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=22;
    UPDATE
    item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=22;
    UPDATE
    item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=22;
    UPDATE
    item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=22;
    UPDATE
    item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=22;
    UPDATE
    item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=22;
    UPDATE
    item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=22;
    UPDATE
    item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=22;
    UPDATE
    item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=22;
    UPDATE
    item_template SET stat_value10 = stat_value10*10 WHERE
    stat_type10=22;
    修改远程躲避等级
    UPDATE item_template SET stat_value1 =
    stat_value1*10 WHERE stat_type1=23;
    UPDATE item_template SET stat_value2 =
    stat_value2*10 WHERE stat_type2=23;
    UPDATE item_template SET stat_value3 =
    stat_value3*10 WHERE stat_type3=23;
    UPDATE item_template SET stat_value4 =
    stat_value4*10 WHERE stat_type4=23;
    UPDATE item_template SET stat_value5 =
    stat_value5*10 WHERE stat_type5=23;
    UPDATE item_template SET stat_value6 =
    stat_value6*10 WHERE stat_type6=23;
    UPDATE item_template SET stat_value7 =
    stat_value7*10 WHERE stat_type7=23;
    UPDATE item_template SET stat_value8 =
    stat_value8*10 WHERE stat_type8=23;
    UPDATE item_template SET stat_value9 =
    stat_value9*10 WHERE stat_type9=23;
    UPDATE item_template SET stat_value10 =
    stat_value10*10 WHERE stat_type10=23;
    修改法术躲避等级
    UPDATE item_template SET
    stat_value1 = stat_value1*10 WHERE stat_type1=24;
    UPDATE item_template SET
    stat_value2 = stat_value2*10 WHERE stat_type2=24;
    UPDATE item_template SET
    stat_value3 = stat_value3*10 WHERE stat_type3=24;
    UPDATE item_template SET
    stat_value4 = stat_value4*10 WHERE stat_type4=24;
    UPDATE item_template SET
    stat_value5 = stat_value5*10 WHERE stat_type5=24;
    UPDATE item_template SET
    stat_value6 = stat_value6*10 WHERE stat_type6=24;
    UPDATE item_template SET
    stat_value7 = stat_value7*10 WHERE stat_type7=24;
    UPDATE item_template SET
    stat_value8 = stat_value8*10 WHERE stat_type8=24;
    UPDATE item_template SET
    stat_value9 = stat_value9*10 WHERE stat_type9=24;
    UPDATE item_template SET
    stat_value10 = stat_value10*10 WHERE stat_type10=24;
    修改近战致命躲避等级
    UPDATE
    item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=25;
    UPDATE
    item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=25;
    UPDATE
    item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=25;
    UPDATE
    item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=25;
    UPDATE
    item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=25;
    UPDATE
    item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=25;
    UPDATE
    item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=25;
    UPDATE
    item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=25;
    UPDATE
    item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=25;
    UPDATE
    item_template SET stat_value10 = stat_value10*10 WHERE
    stat_type10=25;
    修改远程致命躲避等级5uwl.net
    UPDATE item_template SET stat_value1 =
    stat_value1*10 WHERE stat_type1=26;
    UPDATE item_template SET stat_value2 =
    stat_value2*10 WHERE stat_type2=26;
    UPDATE item_template SET stat_value3 =
    stat_value3*10 WHERE stat_type3=26;
    UPDATE item_template SET stat_value4 =
    stat_value4*10 WHERE stat_type4=26;
    UPDATE item_template SET stat_value5 =
    stat_value5*10 WHERE stat_type5=26;
    UPDATE item_template SET stat_value6 =
    stat_value6*10 WHERE stat_type6=26;
    UPDATE item_template SET stat_value7 =
    stat_value7*10 WHERE stat_type7=26;
    UPDATE item_template SET stat_value8 =
    stat_value8*10 WHERE stat_type8=26;
    UPDATE item_template SET stat_value9 =
    stat_value9*10 WHERE stat_type9=26;
    UPDATE item_template SET stat_value10 =
    stat_value10*10 WHERE stat_type10=26;
    修改法术致命躲避等级
    UPDATE item_template SET
    stat_value1 = stat_value1*10 WHERE stat_type1=27;
    UPDATE item_template SET
    stat_value2 = stat_value2*10 WHERE stat_type2=27;
    UPDATE item_template SET
    stat_value3 = stat_value3*10 WHERE stat_type3=27;
    UPDATE item_template SET
    stat_value4 = stat_value4*10 WHERE stat_type4=27;
    UPDATE item_template SET
    stat_value5 = stat_value5*10 WHERE stat_type5=27;
    UPDATE item_template SET
    stat_value6 = stat_value6*10 WHERE stat_type6=27;
    UPDATE item_template SET
    stat_value7 = stat_value7*10 WHERE stat_type7=27;
    UPDATE item_template SET
    stat_value8 = stat_value8*10 WHERE stat_type8=27;
    UPDATE item_template SET
    stat_value9 = stat_value9*10 WHERE stat_type9=27;
    UPDATE item_template SET
    stat_value10 = stat_value10*10 WHERE stat_type10=27;
    修改近战加速等级
    UPDATE
    item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=28;
    UPDATE
    item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=28;
    UPDATE
    item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=28;
    UPDATE
    item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=28;
    UPDATE
    item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=28;
    UPDATE
    item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=28;
    UPDATE
    item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=28;
    UPDATE
    item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=28;
    UPDATE
    item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=28;
    UPDATE
    item_template SET stat_value10 = stat_value10*10 WHERE
    stat_type10=28;
    修改远程加速等级
    UPDATE item_template SET stat_value1 =
    stat_value1*10 WHERE stat_type1=29;
    UPDATE item_template SET stat_value2 =
    stat_value2*10 WHERE stat_type2=29;
    UPDATE item_template SET stat_value3 =
    stat_value3*10 WHERE stat_type3=29;
    UPDATE item_template SET stat_value4 =
    stat_value4*10 WHERE stat_type4=29;
    UPDATE item_template SET stat_value5 =
    stat_value5*10 WHERE stat_type5=29;
    UPDATE item_template SET stat_value6 =
    stat_value6*10 WHERE stat_type6=29;
    UPDATE item_template SET stat_value7 =
    stat_value7*10 WHERE stat_type7=29;
    UPDATE item_template SET stat_value8 =
    stat_value8*10 WHERE stat_type8=29;
    UPDATE item_template SET stat_value9 =
    stat_value9*10 WHERE stat_type9=29;
    UPDATE item_template SET stat_value10 =
    stat_value10*10 WHERE stat_type10=29;
    修改法术加速等级
    UPDATE item_template SET
    stat_value1 = stat_value1*10 WHERE stat_type1=30;
    UPDATE item_template SET
    stat_value2 = stat_value2*10 WHERE stat_type2=30;
    UPDATE item_template SET
    stat_value3 = stat_value3*10 WHERE stat_type3=30;
    UPDATE item_template SET
    stat_value4 = stat_value4*10 WHERE stat_type4=30;
    UPDATE item_template SET
    stat_value5 = stat_value5*10 WHERE stat_type5=30;
    UPDATE item_template SET
    stat_value6 = stat_value6*10 WHERE stat_type6=30;
    UPDATE item_template SET
    stat_value7 = stat_value7*10 WHERE stat_type7=30;
    UPDATE item_template SET
    stat_value8 = stat_value8*10 WHERE stat_type8=30;
    UPDATE item_template SET
    stat_value9 = stat_value9*10 WHERE stat_type9=30;
    UPDATE item_template SET
    stat_value10 = stat_value10*10 WHERE stat_type10=30;
    修改命中等级
    UPDATE
    item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=31;
    UPDATE
    item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=31;
    UPDATE
    item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=31;
    UPDATE
    item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=31;
    UPDATE
    item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=31;
    UPDATE
    item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=31;
    UPDATE
    item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=31;
    UPDATE
    item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=31;
    UPDATE
    item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=31;
    UPDATE
    item_template SET stat_value10 = stat_value10*10 WHERE
    stat_type10=31;
    修改暴击等级
    UPDATE item_template SET stat_value1 =
    stat_value1*10 WHERE stat_type1=32;
    UPDATE item_template SET stat_value2 =
    stat_value2*10 WHERE stat_type2=32;
    UPDATE item_template SET stat_value3 =
    stat_value3*10 WHERE stat_type3=32;
    UPDATE item_template SET stat_value4 =
    stat_value4*10 WHERE stat_type4=32;
    UPDATE item_template SET stat_value5 =
    stat_value5*10 WHERE stat_type5=32;
    UPDATE item_template SET stat_value6 =
    stat_value6*10 WHERE stat_type6=32;
    UPDATE item_template SET stat_value7 =
    stat_value7*10 WHERE stat_type7=32;
    UPDATE item_template SET stat_value8 =
    stat_value8*10 WHERE stat_type8=32;
    UPDATE item_template SET stat_value9 =
    stat_value9*10 WHERE stat_type9=32;
    UPDATE item_template SET stat_value10 =
    stat_value10*10 WHERE stat_type10=32;
    修改击中躲避等级
    UPDATE item_template SET
    stat_value1 = stat_value1*10 WHERE stat_type1=33;
    UPDATE item_template SET
    stat_value2 = stat_value2*10 WHERE stat_type2=33;
    UPDATE item_template SET
    stat_value3 = stat_value3*10 WHERE stat_type3=33;
    UPDATE item_template SET
    stat_value4 = stat_value4*10 WHERE stat_type4=33;
    UPDATE item_template SET
    stat_value5 = stat_value5*10 WHERE stat_type5=33;
    UPDATE item_template SET
    stat_value6 = stat_value6*10 WHERE stat_type6=33;
    UPDATE item_template SET
    stat_value7 = stat_value7*10 WHERE stat_type7=33;
    UPDATE item_template SET
    stat_value8 = stat_value8*10 WHERE stat_type8=33;
    UPDATE item_template SET
    stat_value9 = stat_value9*10 WHERE stat_type9=33;
    UPDATE item_template SET
    stat_value10 = stat_value10*10 WHERE stat_type10=33;
    修改暴击躲避等级
    UPDATE
    item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=34;
    UPDATE
    item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=34;
    UPDATE
    item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=34;
    UPDATE
    item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=34;
    UPDATE
    item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=34;
    UPDATE
    item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=34;
    UPDATE
    item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=34;
    UPDATE
    item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=34;
    UPDATE
    item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=34;
    UPDATE
    item_template SET stat_value10 = stat_value10*10 WHERE
    stat_type10=34;
    修改韧性等级
    UPDATE item_template SET stat_value1 =
    stat_value1*10 WHERE stat_type1=35;
    UPDATE item_template SET stat_value2 =
    stat_value2*10 WHERE stat_type2=35;
    UPDATE item_template SET stat_value3 =
    stat_value3*10 WHERE stat_type3=35;
    UPDATE item_template SET stat_value4 =
    stat_value4*10 WHERE stat_type4=35;
    UPDATE item_template SET stat_value5 =
    stat_value5*10 WHERE stat_type5=35;
    UPDATE item_template SET stat_value6 =
    stat_value6*10 WHERE stat_type6=35;
    UPDATE item_template SET stat_value7 =
    stat_value7*10 WHERE stat_type7=35;
    UPDATE item_template SET stat_value8 =
    stat_value8*10 WHERE stat_type8=35;
    UPDATE item_template SET stat_value9 =
    stat_value9*10 WHERE stat_type9=35;
    UPDATE item_template SET stat_value10 =
    stat_value10*10 WHERE stat_type10=35;
    修改急速等级
    UPDATE item_template SET
    stat_value1 = stat_value1*10 WHERE stat_type1=36;
    UPDATE item_template SET
    stat_value2 = stat_value2*10 WHERE stat_type2=36;
    UPDATE item_template SET
    stat_value3 = stat_value3*10 WHERE stat_type3=36;
    UPDATE item_template SET
    stat_value4 = stat_value4*10 WHERE stat_type4=36;
    UPDATE item_template SET
    stat_value5 = stat_value5*10 WHERE stat_type5=36;
    UPDATE item_template SET
    stat_value6 = stat_value6*10 WHERE stat_type6=36;
    UPDATE item_template SET
    stat_value7 = stat_value7*10 WHERE stat_type7=36;
    UPDATE item_template SET
    stat_value8 = stat_value8*10 WHERE stat_type8=36;
    UPDATE item_template SET
    stat_value9 = stat_value9*10 WHERE stat_type9=36;
    UPDATE item_template SET
    stat_value10 = stat_value10*10 WHERE stat_type10=36;
    修改攻击强度等级
    UPDATE
    item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=38;
    UPDATE
    item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=38;
    UPDATE
    item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=38;
    UPDATE
    item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=38;
    UPDATE
    item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=38;
    UPDATE
    item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=38;
    UPDATE
    item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=38;
    UPDATE
    item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=38;
    UPDATE
    item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=38;
    UPDATE
    item_template SET stat_value10 = stat_value10*10 WHERE
    stat_type10=38;
    修改每5秒回蓝
    UPDATE item_template SET stat_value1 =
    stat_value1*10 WHERE stat_type1=43;
    UPDATE item_template SET stat_value2 =
    stat_value2*10 WHERE stat_type2=43;
    UPDATE item_template SET stat_value3 =
    stat_value3*10 WHERE stat_type3=43;
    UPDATE item_template SET stat_value4 =
    stat_value4*10 WHERE stat_type4=43;
    UPDATE item_template SET stat_value5 =
    stat_value5*10 WHERE stat_type5=43;
    UPDATE item_template SET stat_value6 =
    stat_value6*10 WHERE stat_type6=43;
    UPDATE item_template SET stat_value7 =
    stat_value7*10 WHERE stat_type7=43;
    UPDATE item_template SET stat_value8 =
    stat_value8*10 WHERE stat_type8=43;
    UPDATE item_template SET stat_value9 =
    stat_value9*10 WHERE stat_type9=43;
    UPDATE item_template SET stat_value10 =
    stat_value10*10 WHERE stat_type10=43;
    修改护甲穿透等级
    UPDATE item_template SET
    stat_value1 = stat_value1*10 WHERE stat_type1=44;
    UPDATE item_template SET
    stat_value2 = stat_value2*10 WHERE stat_type2=44;
    UPDATE item_template SET
    stat_value3 = stat_value3*10 WHERE stat_type3=44;
    UPDATE item_template SET
    stat_value4 = stat_value4*10 WHERE stat_type4=44;
    UPDATE item_template SET
    stat_value5 = stat_value5*10 WHERE stat_type5=44;
    UPDATE item_template SET
    stat_value6 = stat_value6*10 WHERE stat_type6=44;
    UPDATE item_template SET
    stat_value7 = stat_value7*10 WHERE stat_type7=44;
    UPDATE item_template SET
    stat_value8 = stat_value8*10 WHERE stat_type8=44;
    UPDATE item_template SET
    stat_value9 = stat_value9*10 WHERE stat_type9=44;
    UPDATE item_template SET
    stat_value10 = stat_value10*10 WHERE stat_type10=44;
    修改法术强度等级
    UPDATE
    item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=45;
    UPDATE
    item_template SET stat_value2 = stat_value2*10 WHERE stat_type2=45;
    UPDATE
    item_template SET stat_value3 = stat_value3*10 WHERE stat_type3=45;
    UPDATE
    item_template SET stat_value4 = stat_value4*10 WHERE stat_type4=45;
    UPDATE
    item_template SET stat_value5 = stat_value5*10 WHERE stat_type5=45;
    UPDATE
    item_template SET stat_value6 = stat_value6*10 WHERE stat_type6=45;
    UPDATE
    item_template SET stat_value7 = stat_value7*10 WHERE stat_type7=45;
    UPDATE
    item_template SET stat_value8 = stat_value8*10 WHERE stat_type8=45;
    UPDATE
    item_template SET stat_value9 = stat_value9*10 WHERE stat_type9=45;
    UPDATE
    item_template SET stat_value10 = stat_value10*10 WHERE stat_type10=45;

    热门文章
    热门标签
    传奇引擎版本网络开区最新服务脚本服务端1.76英雄科技商业职业地图HERO元素1.80合击中变极品方法连击1.85完美轻变数据教程一条龙传世登陆全新完整免费仿盛大登陆器技能传说经典系统特色攻略更新配置网站玩家激情升级GOM火爆玩法
    Copyright © 2008-2016 网游动力. All Rights Reserved.
    Powered by：SF5.Net
    辽ICP备17007188号
    关于本站 | 网站帮助 | 广告合作 | 发布软件 | 下载声明 | 网站地图