当前位置:文档之家› 数据库修改

数据库修改

数据库修改给新手,LR宝宝修改,这样才能抗怪,老人请无视。

打开N8,连接world,按F6,输入宝宝HP,MP,力量,敏捷等升级翻倍update pet_levelstats set hp = hp*40;update pet_levelstats set mana = mana+3;update pet_levelstats set mana = mana*2;update pet_levelstats set armor = armor*30;update pet_levelstats set str = str*50;update pet_levelstats set agi = agi*20;update pet_levelstats set sta = sta*20;update pet_levelstats set inte = inte*20;update pet_levelstats set spi = spi*20;人物的HP.MP升级翻倍update player_classlevelstats set basemana=basemana*10;update player_classlevelstats set basehp=basehp*10;所有BOSS吃控制技能,眩晕,恐惧等等UPDATE creature_template SET mechanic_immune_mask = 0 where rank=3;护甲值2倍UPDATE item_template SET armor = armor*2;最小和最大武器伤害值*30是30倍的意思单手UPDATE item_template SET dmg_min1 = dmg_min1*30;UPDATE item_template SET dmg_max1 = dmg_max1*30;双手UPDATE item_template SET dmg_min2 = dmg_min2*30;UPDATE item_template SET dmg_max2 = dmg_max2*30;武器攻击速度延迟/2是除2的意思UPDATEitem_template SET delay = delay/2;装备的抵抗抗性2倍UPDATE item_template SETholy_res = holy_res*2;UPDATE item_template SET fire_res =fire_res*2;UPDATE item_template SET nature_res = nature_res*2;UPDATEitem_template SET frost_res = frost_res*2;UPDATE item_template SETshadow_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*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_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 SETUPDATE item_template SETstat_value2 = stat_value2*2 WHERE stat_type2=5;UPDATE item_template SETstat_value3 = stat_value3*2 WHERE stat_type3=5; UPDATE item_template SETstat_value4 = stat_value4*2 WHERE stat_type4=5;UPDATE item_template SETstat_value5 = stat_value5*2 WHERE stat_type5=5;UPDATE item_template SETstat_value6 = stat_value6*2 WHERE stat_type6=5;UPDATE item_template SETstat_value7 = stat_value7*2 WHERE stat_type7=5;修改精神UPDATE item_templateSET stat_value1 = stat_value1*2 WHERE stat_type1=6;UPDATE item_template SETstat_value2 = stat_value2*2 WHERE stat_type2=6;UPDATE item_template SETstat_value3 = stat_value3*2 WHERE stat_type3=6;UPDATE item_template SETstat_value4 = stat_value4*2 WHERE stat_type4=6;UPDATE item_template SETstat_value5 = stat_value5*2 WHERE stat_type5=6;UPDATE item_template SETstat_value6 = stat_value6*2 WHERE stat_type6=6;UPDATE item_template SETstat_value7 = stat_value7*2 WHERE stat_type7=6;修改耐力UPDATE item_templateSET stat_value1 = stat_value1*4 WHERE stat_type1=7;UPDATE item_template SETstat_value2 = stat_value2*4 WHERE stat_type2=7;UPDATE item_template SETstat_value3 = stat_value3*4 WHERE stat_type3=7;UPDATE item_template SETstat_value4 = stat_value4*4 WHERE stat_type4=7;UPDATE item_template SETstat_value5 = stat_value5*4 WHERE stat_type5=7;UPDATE item_template SETUPDATE item_template SETstat_value7 = stat_value7*4 WHERE stat_type7=7;修改记录:WLK装备护甲*1.5,耐力*2CTM装备属性*2,耐力*4任务物品掉落100%update creature_loot_template set Chanceorquestchance=-100 where Chanceorquestchance<0;剥皮强化命令,使剥皮一次最多能剥15块:update skinning_loot_template set maxcount=15;钓起的鱼数量最高能到10.具体数值自己设置吧~update fishing_loot_template set maxcount=10;下面是采集的,同样,采药采矿,一次最多能采到15块,包括石头和宝石。

草药update gameobject_loot_template set maxcount=15 where item=765;update gameobject_loot_template set maxcount=15 where item=785;update gameobject_loot_template set maxcount=15 where item=2449;update gameobject_loot_template set maxcount=15 where item=2450;update gameobject_loot_template set maxcount=15 where item=2452;update gameobject_loot_template set maxcount=15 where item=2453;update gameobject_loot_template set maxcount=15 where item=3356;update gameobject_loot_template set maxcount=15 where item=3357;update gameobject_loot_template set maxcount=15 where item=3818;update gameobject_loot_template set maxcount=15 where item=3819;update gameobject_loot_template set maxcount=15 where item=3820;update gameobject_loot_template set maxcount=15 where item=3821;update gameobject_loot_template set maxcount=15 where item=8836;update gameobject_loot_template set maxcount=15 where item=8838;update gameobject_loot_template set maxcount=15 where item=8839;update gameobject_loot_template set maxcount=15 where item=13463;update gameobject_loot_template set maxcount=15 where item=13464;update gameobject_loot_template set maxcount=15 where item=13465;update gameobject_loot_template set maxcount=15 where item=13466;update gameobject_loot_template set maxcount=15 where item=13467;update gameobject_loot_template set maxcount=15 where item=13468; update gameobject_loot_template set maxcount=15 where item=8845; update gameobject_loot_template set maxcount=15 where item=8846; update gameobject_loot_template set maxcount=15 where item=8831; update gameobject_loot_template set maxcount=15 where item=6986; update gameobject_loot_template set maxcount=15 where item=4625; update gameobject_loot_template set maxcount=15 where item=3355; update gameobject_loot_template set maxcount=15 where item=2447; update gameobject_loot_template set maxcount=15 where item=8153; 矿物update gameobject_loot_template set maxcount=15 where item=2770; update gameobject_loot_template set maxcount=15 where item=2771; update gameobject_loot_template set maxcount=15 where item=2772; update gameobject_loot_template set maxcount=15 where item=2775; update gameobject_loot_template set maxcount=15 where item=2776; update gameobject_loot_template set maxcount=15 where item=3858; update gameobject_loot_template set maxcount=15 where item=7911; update gameobject_loot_template set maxcount=15 where item=10620; update gameobject_loot_template set maxcount=15 where item=11370; update gameobject_loot_template set maxcount=15 where item=5833; update gameobject_loot_template set maxcount=15 where item=6800; update gameobject_loot_template set maxcount=15 where item=6808; update gameobject_loot_template set maxcount=15 where item=12800; update gameobject_loot_template set maxcount=15 where item=12799; update gameobject_loot_template set maxcount=15 where item=1210; update gameobject_loot_template set maxcount=15 where item=818; update gameobject_loot_template set maxcount=15 where item=7910; update gameobject_loot_template set maxcount=15 where item=7909; update gameobject_loot_template set maxcount=15 where item=1529; update gameobject_loot_template set maxcount=15 where item=3864; update gameobject_loot_template set maxcount=15 where item=1705; update gameobject_loot_template set maxcount=15 where item=3407; update gameobject_loot_template set maxcount=15 where item=12361; update gameobject_loot_template set maxcount=15 where item=12364; 石头update gameobject_loot_template set maxcount=15 where item=2835; update gameobject_loot_template set maxcount=15 where item=2836; update gameobject_loot_template set maxcount=15 where item=2838; update gameobject_loot_template set maxcount=15 where item=7912; update gameobject_loot_template set maxcount=15 where item=12365;。

相关主题