风暴七把武器去地图时间限制-新手实用SQL语句

这些是SQL语句，大家先用navicat打开数据库，然后选择MANGOS（虽然是M端的，T端应该可以套用）数据库，按F6会出现一个对话筐，需要哪部分就复制哪部分，粘贴进对再回车就可以了。（注使用语句后需要重新启动服务端才能生效，如物品属性没有显示请删除客户端下的WTF,Cache两个文件夹）
去除装备上的唯一属性
UPDATE item_template SET Maxcount = 0;

沙塔尔徽章的属性修改
update item_template set stat_type1 = 3 where entry = 31781;
update item_template set stat_value1 = 500 where entry = 31781;
update item_template set stat_type2 = 4 where entry = 31781;
update item_template set stat_value2 = 500 where entry = 31781;
update item_template set stat_type3 = 5 where entry = 31781;
update item_template set stat_value3 = 500 where entry = 31781;
update item_template set stat_type4 = 6 where entry = 31781;
update item_template set stat_value4 = 500 where entry = 31781;
update item_template set stat_type5 = 7 where entry = 31781;
update item_template set stat_value5 = 500 where entry = 31781;
update item_template set holy_res = 200 where entry = 31781;
update item_template set fire_res = 200 where entry = 31781;
update item_template set nature_res = 200 where entry = 31781;
update item_template set frost_res = 200 where entry = 31781;
update item_template set shadow_res = 200 where entry = 31781;
update item_template set arcane_res = 200 where entry = 31781;

update item_template set spellid_1 = 7219 where entry = 31781;
update item_template set spelltrigger_1 = 1 where entry = 31781;
update item_template set spellid_2 = 34774 where entry = 31781;
update item_template set spelltrigger_2 = 2 where entry = 31781;
update item_template set spellid_3 = 31750 where entry = 31781;
update item_template set spelltrigger_3 = 1 where entry = 31781;
update item_template set spellid_4 = 31750 where entry = 31781;
update item_template set spelltrigger_4 = 1 where entry = 31781;
update item_template set spellid_5 = 31750 where entry = 31781;
update item_template set spelltrigger_5 = 1 where entry = 31781;

蛋蛋双刀去除职业限制并强化伤害
update item_template set allowableclass = -1 where entry = 32837;
update item_template set allowableclass = -1 where entry = 32838;
update item_template set dmg_min1 = dmg_min1*2 where entry = 32837;
update item_template set dmg_max1 = dmg_max1*2 where entry = 32837;
update item_template set dmg_min1 = dmg_min1*2 where entry = 32838;
update item_template set dmg_max1 = dmg_max1*2 where entry = 32838;
update item_template set delay = delay*0.5 where entry = 32837;
update item_template set delay = delay*0.5 where entry = 32838;

风剑的属性强化（这样风剑就还是最强大的单手武器了哈哈）
update item_template set allowableclass = -1 where entry = 19019;
update item_template set dmg_min1 = dmg_min1*3 where entry = 19019;
update item_template set dmg_max1 = dmg_max1*3 where entry = 19019;
update item_template set delay = delay*0.3 where entry = 19019;
update item_template set holy_res = 200 where entry = 19019;
update item_template set fire_res = 200 where entry = 19019;
update item_template set nature_res = 200 where entry = 19019;
update item_template set frost_res = 200 where entry = 19019;
update item_template set shadow_res = 200 where entry = 19019;
update item_template set arcane_res = 200 where entry = 19019;

风暴要塞七把橙色武器去除地图和时间限制
update item_template set map = 0 where entry = 30311;
update item_template set map = 0 where entry = 30312;
update item_template set map = 0 where entry = 30313;
update item_template set map = 0 where entry = 30314;
update item_template set map = 0 where entry = 30316;
update item_template set map = 0 where entry = 30317;
update item_template set map = 0 where entry = 30318;
update item_template set map = 0 where entry = 30319;
update item_template set map = 0 where entry = 30320;
update item_template set duration = 0 where entry = 30311;
update item_template set duration = 0 where entry = 30312;
update item_template set duration = 0 where entry = 30313;
update item_template set duration = 0 where entry = 30314;
update item_template set duration = 0 where entry = 30316;
update item_template set duration = 0 where entry = 30317;
update item_template set duration = 0 where entry = 30318;
update item_template set duration = 0 where entry = 30320;

宠物属性强化
update pet_levelstats set hp = hp*2;
update pet_levelstats set mana = mana+1;
update pet_levelstats set mana = mana*0.5;
update pet_levelstats set armor = armor*3;
update pet_levelstats set str = str*10;
update pet_levelstats set agi = agi*10;
update pet_levelstats set sta = sta*10;
update pet_levelstats set inte = inte*10;
update pet_levelstats set spi = spi*10;

灵魂碎片可以叠加
update item_template set stackable = 100 where entry = 6265;

荣誉和战场装免费(使用之后连T5，T6之类的兑换也会免费，请慎重）
UPDATE npc_vendor SET extendedcost = 0;

以下是常用的GM命令。只要用GM号进。先点自己然后输入回车就可以了 。
.learn XXXX（XXXX为技能编号，可以学习很多其他职业的技能或者天赋）
基础类
双武器 674
盾牌 9116
皮甲 9077  
锁甲 8737  
板甲 750

技能类
清洁术 4987
解除诅咒 2782
驱散魔法 988
假死 5384

商业版发布站程序下载：发布站程序下载：

Tags：

作者：佚名