艾泽拉斯遗产单机畅游~~~惠民便利修改方案节选~~(N8运行).doc

1、鉴于大家都在讨论如何能更加便利的体验游戏以下修改代码是本人参考了众多大大的修正秘诀节选出来的有了它们,生活更便利/*帐户注册 */insert into account(username,sha_pass_hash,joindate,email,last_ip) values(UPPER(账号),SHA1(CONCAT(UPPER(账号 ),:,UPPER(密码),2013-1-1,UPPER(随意邮箱地址),127.0.0.1);UPDATE item_template SET stackable = 9999 where stackable 1 ; /*所有堆叠数大于 1 的改为 9999

2、*/UPDATE item_template SET stackable=9999 WHERE (entry=6265) ; /*灵魂碎片堆叠数改为 9999*/UPDATE skinning_loot_template SET maxcount = 20 ; /*剥皮最大产量为 20 单位*/UPDATE fishing_loot_template SET maxcount = 20 ; /* 钓鱼*/UPDATE prospecting_loot_template SET maxcount = 20 ; /*采矿附产品（孔雀石、虎眼石、等）最大产量为 20 单位*/UPDATE creat

3、ure_loot_template SET maxcount=20 WHERE item=2589 ; /*亚麻布最大产量为 20*/UPDATE creature_loot_template SET maxcount=20 WHERE item=2592 ; /*毛料*/UPDATE creature_loot_template SET maxcount=20 WHERE item=4306 ; /*丝绸*/UPDATE creature_loot_template SET maxcount=20 WHERE item=4338 ; /* 魔纹布*/UPDATE creature_loot_

4、template SET maxcount=20 WHERE item=14047 ; /*符文布*/UPDATE creature_loot_template SET maxcount=20 WHERE item=14256 ; /* 恶魔布*/UPDATE creature_loot_template SET maxcount=20 WHERE item=21877 ; /* 灵纹布*/UPDATE gameobject SET spawntimesecs = 5 ; /* 草、矿、宝箱等刷新时间为 5秒*/UPDATE item_template SET spellcategorycoo

5、ldown_1 = 5000 where spellcategorycooldown_1 = 120000 and class = 0 ; /* 将药水的冷却时间设为 5 秒*/*炼化重铸物品需求 3 改 2*/update itemcomposeconfig set item_count=2,appenditemid=90594;update itemcomposeconfig set appenditemcoun=12 where appenditemcoun is null;/*任务最小接受等级降低 3 级*/update quest_template set minlevel=minl

6、evel-3 where minlevel5;/*任务物品 100%掉落*/update creature_loot_template set ChanceOrQuestChance = -100 where ChanceOrQuestChance99 and appenditemcoun999; /*碎片需求大于 1000 的减少 10 倍需求*/*以下如果不感兴趣就不用了*/*藏宝湾卖鹦鹉的商人处添加出售物品*/INSERT INTO npc_vendor VALUES (2663, 0, 90070, 0, 0, 0); /*艾泽拉斯金币-游戏金币购买,拼命打钱把*/INSERT INT

7、O npc_vendor VALUES (2663, 0, 90073, 0, 0, 0); /*权力印记*/INSERT INTO npc_vendor VALUES (2663, 0, 90074, 0, 0, 0); /*时光印记*/INSERT INTO npc_vendor VALUES (2663, 0, 90075, 0, 0, 0); /*生命印记*/INSERT INTO npc_vendor VALUES (2663, 0, 90112, 0, 0, 0); /*晶化生命碎片*/INSERT INTO npc_vendor VALUES (2663, 0, 90834, 0

8、, 0, 0); /*神秘的罗盘*/*宠物 20 倍血,20 倍魔,属性 10 倍*/update pet_levelstatsset hp = hp * 20 , mana = mana * 20 , armor = armor * 20 , str = str * 10 , agi = agi * 10 , sta = sta * 10 , inte = inte * 10 , spi = spi * 10 /*人物 10 倍属性*/update player_levelstatsset str = str * 5 , agi = agi * 5 , sta = sta * 5 , int

9、e = inte * 5 , spi = spi * 5 教程 3 武器攻击伤害成倍修改3 倍UPDATE item_template SET dmg_min1=dmg_min1*3;UPDATE item_template SET dmg_max1=dmg_max1*3; 遗产 账号是 root 密码是 ascent咋用呢？用8 按复制导入？装备批量精准属性修改护甲值 3 倍UPDATE item_template SET armor = armor*3;最小和最大武器伤害值 *30 是 30 倍的意思UPDATE item_template SET dmg_min1 = dmg_min1*

10、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_r

11、es = 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 st

12、at_type1=3;UPDATE iitem_template SET stat_value2 = stat_value2*3WHERE stat_type2=3;UPDATE item_template SET stat_value3 = stat_value3*3 WHERE stat_type3=3;UPDATE item_template SET stat_value4 = stat_value4*3WHERE stat_type4=3;UPDATE item_template SET stat_value5 = stat_value5*3WHERE stat_type5=3;UPD

13、ATE item_template SET stat_value6 = stat_value6*3 WHERE stat_type6=3;UPDATE item_template SET stat_value7 = stat_value7*3WHERE 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_

14、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

15、 stat_value7 = stat_value7*3 WHERE stat_type7=4;修改智力UPDATE item_template SET stat_value1 = stat_value1*3 WHERE stat_type1=5;UPDATE item_template SET stat_value2 = stat_value2*3 WHERE stat_type2=5;UPDATE item_template SET stat_value3 = stat_value3*3 WHERE stat_type3=5;UPDATE item_template SET stat_va

16、lue4 = stat_value4*3 WHERE stat_type4=5;UPDATE item_template SET stat_value5 = stat_value5*3 WHERE stat_type5=5;UPDATE item_template SET stat_value6 = stat_value6*3 WHERE stat_type6=5;UPDATE item_template SET stat_value7 = stat_value7*3 WHERE stat_type7=5;修改精神UPDATE item_template SET stat_value1 = s

17、tat_value1*3 WHERE stat_type1=6;UPDATE item_template SET stat_value2 = stat_value2*3 WHERE stat_type2=6;UPDATE item_template SET stat_value3 = stat_value3*3 WHERE stat_type3=6;UPDATE item_template SET stat_value4 = stat_value4*3 WHERE stat_type4=6;UPDATE item_template SET stat_value5 = stat_value5*3

18、 WHERE stat_type5=6;UPDATE item_template SET stat_value6 = stat_value6*3 WHERE stat_type6=6;UPDATE item_template SET stat_value7 = stat_value7*3 WHERE stat_type7=6;修改耐力UPDATE item_template SET stat_value1 = stat_value1*3 WHERE stat_type1=7;UPDATE item_template SET stat_value2 = stat_value2*3 WHERE s

19、tat_type2=7;UPDATE item_template SET stat_value3 = stat_value3*3 WHERE stat_type3=7;UPDATE item_template SET stat_value4 = stat_value4*3 WHERE stat_type4=7;UPDATE item_template SET stat_value5 = stat_value5*3 WHERE stat_type5=7;UPDATE item_template SET stat_value6 = stat_value3*3 WHERE stat_type6=7;

20、UPDATE item_template SET stat_value7 = stat_value7*3 WHERE stat_type7=7;修改武器等级UPDATE item_template SET stat_value1 = stat_value1*3 WHERE stat_type1=11;UPDATE item_template SET stat_value2 = stat_value2*3 WHERE stat_type2=11;UPDATE item_template SET stat_value3 = stat_value3*3 WHERE stat_type3=11;UPD

21、ATE item_template SET stat_value4 = stat_value4*3 WHERE stat_type4=11;UPDATE item_template SET stat_value5 = stat_value5*3 WHERE stat_type5=11;UPDATE item_template SET stat_value6 = stat_value6*3 WHERE stat_type6=11;UPDATE item_template SET stat_value7 = stat_value7*3 WHERE stat_type7=11;UPDATE item

22、_template SET stat_value8 = stat_value8*3 WHERE stat_type8=11;UPDATE item_template SET stat_value9 = stat_value9*3 WHERE stat_type9=11;UPDATE item_template SET stat_value10 = stat_value10*3 WHERE stat_type10=11;修改防御等级UPDATE item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=12;UPDATE it

23、em_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_t

24、emplate 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_templ

25、ate 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_

26、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_temp

27、late 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

28、_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_tem

29、plate 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_templat

30、e SET stat_value10 = stat_value10*10 WHERE stat_type10=14;修改盾格档等级UPDATE item_template SET stat_value1 = stat_value1*3 WHERE stat_type1=15;UPDATE item_template SET stat_value2 = stat_value2*3 WHERE stat_type2=15;UPDATE item_template SET stat_value3 = stat_value3*3 WHERE stat_type3=15;UPDATE item_temp

31、late SET stat_value4 = stat_value4*3 WHERE stat_type4=15;UPDATE item_template SET stat_value5 = stat_value5*3 WHERE stat_type5=15;UPDATE item_template SET stat_value6 = stat_value6*3 WHERE stat_type6=15;UPDATE item_template SET stat_value7 = stat_value7*3 WHERE stat_type7=15;UPDATE item_template SET

32、 stat_value8 = stat_value8*3 WHERE stat_type8=15;UPDATE item_template SET stat_value9 = stat_value9*3 WHERE stat_type9=15;UPDATE item_template SET stat_value10 = stat_value10*3 WHERE stat_type10=15;修改命中等级UPDATE item_template SET stat_value1 = stat_value1*3 WHERE stat_type1=16;UPDATE item_template SE

33、T stat_value2 = stat_value2*3 WHERE stat_type2=16;UPDATE item_template SET stat_value3 = stat_value3*3 WHERE stat_type3=16;UPDATE item_template SET stat_value4 = stat_value4*3 WHERE stat_type4=16;UPDATE item_template SET stat_value5 = stat_value5*3 WHERE stat_type5=16;UPDATE item_template SET stat_v

34、alue6 = stat_value6*3 WHERE stat_type6=16;UPDATE item_template SET stat_value7 = stat_value7*3 WHERE stat_type7=16;UPDATE item_template SET stat_value8 = stat_value8*3 WHERE stat_type8=16;UPDATE item_template SET stat_value9 = stat_value9*3 WHERE stat_type9=16;UPDATE item_template SET stat_value10 =

35、 stat_value10*3 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_val

36、ue4 = 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

37、= 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_

38、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_valu

39、e6 = 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

40、= stat_value10*10 WHERE stat_type10=18;修改法术暴击等级UPDATE item_template SET stat_value1 = stat_value1*3 WHERE stat_type1=21;UPDATE item_template SET stat_value2 = stat_value2*3 WHERE stat_type2=21;UPDATE item_template SET stat_value3 = stat_value3*3 WHERE stat_type3=21;UPDATE item_template SET stat_valu

41、e4 = stat_value4*3 WHERE stat_type4=21;UPDATE item_template SET stat_value5 = stat_value5*3 WHERE stat_type5=21;UPDATE item_template SET stat_value6 = stat_value6*3 WHERE stat_type6=21;UPDATE item_template SET stat_value7 = stat_value7*3 WHERE stat_type7=21;UPDATE item_template SET stat_value8 = sta

42、t_value8*3 WHERE stat_type8=21;UPDATE item_template SET stat_value9 = stat_value9*3 WHERE stat_type9=21;UPDATE item_template SET stat_value10 = stat_value10*3 WHERE stat_type10=21;修改近战躲避等级UPDATE item_template SET stat_value1 = stat_value1*10 WHERE stat_type1=22;UPDATE item_template SET stat_value2 =

43、 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