护甲值
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*3
WHERE stat_type1=3;
UPDATE iitem_template SET stat_value2 = stat_value2*3
WHERE stat_type2=3;
UPDATE item_template SET stat_value3 = stat_value3*3
WHERE stat_type3=3;
UPDATE item_template SET stat_value4 = stat_value4*3
WHERE stat_type4=3;
UPDATE item_template SET stat_value5 = stat_value5*3
WHERE stat_type5=3;
UPDATE item_template SET stat_value6 = stat_value6*3
WHERE stat_type6=3;
UPDATE item_template SET stat_value7 = stat_value7*3
WHERE stat_type7=3;
修改力量
UPDATE item_template SET stat_value1 =
stat_value1*3 WHERE stat_type1=4;
UPDATE item_template SET stat_value2 =
stat_value2*3 WHERE stat_type2=4;
UPDATE item_template SET stat_value3 =
stat_value3*3 WHERE stat_type3=4;
UPDATE item_template SET stat_value4 =
stat_value4*3 WHERE stat_type4=4;
UPDATE item_template SET stat_value5 =
stat_value5*3 WHERE stat_type5=4;
UPDATE item_template SET stat_value6 =
stat_value6*3 WHERE stat_type6=4;
UPDATE item_template SET stat_value7 =
stat_value7*3 WHERE stat_type7=4;
修改智力
UPDATE item_template SET
stat_value1 = stat_value1*5 WHERE stat_type1=5;
UPDATE item_template SET
stat_value2 = stat_value2*5 WHERE stat_type2=5;
UPDATE item_template SET
stat_value3 = stat_value3*5 WHERE stat_type3=5;
UPDATE item_template SET
stat_value4 = stat_value4*5 WHERE stat_type4=5;
UPDATE item_template SET
stat_value5 = stat_value5*5 WHERE stat_type5=5;
UPDATE item_template SET
stat_value6 = stat_value6*5 WHERE stat_type6=5;
UPDATE item_template SET
stat_value7 = stat_value7*5 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;
以下是爆率修改 目前的很多端改配置文件时改不了爆率的 用这个命令就OK 用法同上
首先update creature_loot_template set groupid=0;
接着update creature_loot_template set Chanceorquestchance=1 where Chanceorquestchance=0;
然后修改所有蓝色紫色橙色物品的爆率
update creature_loot_template set ChanceOrQuestChance=30 where ChanceOrQuestChance<30 and ((select Quality from item_template where entry=item)=3 or (select Quality from item_template where entry=item)=4 or (select Quality from item_template where entry=item)=5);
修改BB属性: 这个修改的是所有BB的属性 包括法师的水元素 萨满的狼
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;
------------------------------------------------------------------------------