入驻
魔兽有爱论坛»论坛 › 模拟器 › 魔兽世界模拟器 › AyaseCore › 关于梦神端后期和挑战模式的一点建议
12
返回列表 发帖
楼主: saswind

[建议与设想] 关于梦神端后期和挑战模式的一点建议

[复制链接]
发表于 2019-10-16 00:33:52 | 显示全部楼层
默默看着 菜鸡只能如此
回复

使用道具 举报

ayase

3402

时沙

62

精华

158

主题

声望: 48791   虚弱: 0

管理员

🔶收集癖,你懂的🔶

万神殿uiwow（lulus制）信仰战假死猎人今天也只能打恢复的增强萨跑路骑士吟游牧师孝顺骑士潜行者登山猎手划水武僧搓水法爷卖糖术神圣光永恒炉石祖国万岁！！积少成多奥的灰烬时沙之瓶炉石天马比格沃斯先生无敌的缰绳黑色宝石猎豹脚男奔波尔菠萝雷施小咕无冕者希尔瓦娜斯·风行者伊利丹·怒风泰兰德·语风莉莉安·沃斯泰坦之握荣耀属于联盟!为了部落!银色北伐军瓦兰纳尔·远古王者之锤金鸡报晓Doge哼哼（lulus制作）金鼠(ytfirefox制作) 犇向牛年(尚美制作)福虎贺岁(尚美制作)金兔迎春(尚美制作)祥龙贺岁(尚美制作)灵蛇献瑞（尚美制作）烈焰星驰（尚美制作）
发表于 2019-10-19 22:38:35 | 显示全部楼层
挺久以前写的装备升级数据生成语句,可以直接拿去修改下
  1. /*一些属性倍率*/

  2. set @lv1 = 1.320;

  3. set @lv2 = 1.680;

  4. set @lv3 = 2.080;

  5. /*武器伤害倍率*/

  6. set @lv1_dmg = 1.320;

  7. set @lv2_dmg = 1.680;

  8. set @lv3_dmg = 2.080;

  9. 

  10. /*预先清理数据*/

  11. DROP TABLE IF EXISTS item_up;

  12. DELETE FROM item_template_custom WHERE entry>=100000 and entry <= 1000000;

  13. DELETE FROM item_template WHERE entry>=100000 and entry <= 1000000;

  14. 

  15. DELETE FROM disenchant_loot_template WHERE entry>=100000 and entry <= 1000000;

  16. 

  17. DROP TABLE IF EXISTS item_template_copy;

  18. DROP TABLE IF EXISTS item_1;

  19. DROP TABLE IF EXISTS item_2;

  20. DROP TABLE IF EXISTS item_3;

  21. DROP TABLE IF EXISTS up1;

  22. DROP TABLE IF EXISTS up2;

  23. DROP TABLE IF EXISTS up3;

  24. 

  25. CREATE TABLE `item_up` (

  26.   `oldItemEntry` int(20) NOT NULL DEFAULT '0',

  27.   `oldItemCount` int(20) DEFAULT '1',

  28.   `newItemEntry` int(20) DEFAULT '0',

  29.   `chance` tinyint(3) DEFAULT '100',

  30.   `clEntry1` int(20) DEFAULT '0',

  31.   `clCount1` int(20) DEFAULT '0',

  32.   `clEntry2` int(20) DEFAULT '0',

  33.   `clCount2` int(20) DEFAULT '0',

  34.   `clEntry3` int(20) DEFAULT '0',

  35.   `clCount3` int(20) DEFAULT '0',

  36.   `clEntry4` int(20) DEFAULT '0',

  37.   `clCount4` int(20) DEFAULT '0',

  38.   `clEntry5` int(20) DEFAULT '0',

  39.   `clCount5` int(20) DEFAULT '0',

  40.   PRIMARY KEY (`oldItemEntry`)

  41. ) ENGINE=MyISAM DEFAULT CHARSET=gbk;

  42. 

  43. CREATE TEMPORARY TABLE item_template_copy (select * from item_template);

  44. ALTER TABLE `item_template_copy` ADD PRIMARY KEY (`entry`);

  45. REPLACE into item_template_copy select * from item_template_custom;

  46. 

  47. /*选择物品等级和品质大于等于1的装备生成升级数据*/

  48. CREATE TEMPORARY TABLE item_1 (select * from item_template_copy where entry<100000 and (class = 4 or class = 2) and ItemLevel >= 1 and Quality >= 1);

  49. CREATE TEMPORARY TABLE item_2 (select * from item_1);

  50. CREATE TEMPORARY TABLE item_3 (select * from item_1);

  51. 

  52. CREATE TEMPORARY TABLE up1 select * from item_up;

  53. CREATE TEMPORARY TABLE up2 select * from item_up;

  54. CREATE TEMPORARY TABLE up3 select * from item_up;

  55. 

  56. /*移除多余数据,使物品数据缺失导致某些物品不能升级

  57. 目的 

  58. 普通->lv1 所有可升级

  59. lv1(青铜)->lv2(白银) 因为移除白银装等少于200的物品 所以导致部分装等小于200的青铜不能再次升级为白银

  60. lv2(白银)->lv3(黄金) 同理使得装等小于251的装备不能升级到黄金*/

  61. delete from item_2 where itemlevel < 200;/*移除装等少于200的白银装备*/

  62. delete from item_3 where itemlevel < 251;/*移除装等少于251的黄金装备*/

  63. 

  64. INSERT INTO up1 (oldItemEntry) (select entry from item_1);

  65. INSERT INTO up2 (oldItemEntry) (select entry from item_2);

  66. INSERT INTO up3 (oldItemEntry) (select entry from item_3);

  67. 

  68. update item_1 set name=concat(name,'◇英勇青铜');

  69. update item_1 set entry = entry + 100000;

  70. UPDATE item_1 SET stat_value1 = stat_value1*@lv1;

  71. UPDATE item_1 SET stat_value2 = stat_value2*@lv1;

  72. UPDATE item_1 SET stat_value3 = stat_value3*@lv1;

  73. UPDATE item_1 SET stat_value4 = stat_value4*@lv1;

  74. UPDATE item_1 SET stat_value5 = stat_value5*@lv1;

  75. UPDATE item_1 SET stat_value6 = stat_value6*@lv1;

  76. UPDATE item_1 SET stat_value7 = stat_value7*@lv1;

  77. UPDATE item_1 SET stat_value8 = stat_value8*@lv1;

  78. UPDATE item_1 SET stat_value9 = stat_value9*@lv1;

  79. UPDATE item_1 SET stat_value10 = stat_value10*@lv1;

  80. UPDATE item_1 SET armor = armor*@lv1;

  81. UPDATE item_1 SET holy_res = holy_res*@lv1;

  82. UPDATE item_1 SET fire_res = fire_res*@lv1;

  83. UPDATE item_1 SET nature_res = nature_res*@lv1;

  84. UPDATE item_1 SET frost_res = frost_res*@lv1;

  85. UPDATE item_1 SET shadow_res = shadow_res*@lv1;

  86. UPDATE item_1 SET arcane_res = arcane_res*@lv1;

  87. UPDATE item_1 SET dmg_min1 = dmg_min1*@lv1_dmg;

  88. UPDATE item_1 SET dmg_max1 = dmg_max1*@lv1_dmg;

  89. UPDATE item_1 SET SellPrice = SellPrice*1;

  90. update item_1 set maxcount = 3 where maxcount <= 1;

  91. update item_1 set DisenchantID = entry,RequiredDisenchantSkill = 0;

  92. 

  93. update item_2 set name=concat(name,'◇不屈白银');

  94. update item_2 set entry = entry + 200000;

  95. UPDATE item_2 SET stat_value1 = stat_value1*@lv2;

  96. UPDATE item_2 SET stat_value2 = stat_value2*@lv2;

  97. UPDATE item_2 SET stat_value3 = stat_value3*@lv2;

  98. UPDATE item_2 SET stat_value4 = stat_value4*@lv2;

  99. UPDATE item_2 SET stat_value5 = stat_value5*@lv2;

  100. UPDATE item_2 SET stat_value6 = stat_value6*@lv2;

  101. UPDATE item_2 SET stat_value7 = stat_value7*@lv2;

  102. UPDATE item_2 SET stat_value8 = stat_value8*@lv2;

  103. UPDATE item_2 SET stat_value9 = stat_value9*@lv2;

  104. UPDATE item_2 SET stat_value10 = stat_value10*@lv2;

  105. UPDATE item_2 SET armor = armor*@lv2;

  106. UPDATE item_2 SET holy_res = holy_res*@lv2;

  107. UPDATE item_2 SET fire_res = fire_res*@lv2;

  108. UPDATE item_2 SET nature_res = nature_res*@lv2;

  109. UPDATE item_2 SET frost_res = frost_res*@lv2;

  110. UPDATE item_2 SET shadow_res = shadow_res*@lv2;

  111. UPDATE item_2 SET arcane_res = arcane_res*@lv2;

  112. UPDATE item_2 SET dmg_min1 = dmg_min1*@lv2_dmg;

  113. UPDATE item_2 SET dmg_max1 = dmg_max1*@lv2_dmg;

  114. UPDATE item_2 SET SellPrice = SellPrice*1;

  115. update item_2 set maxcount = 3 where maxcount <= 1;

  116. update item_2 set DisenchantID = entry,RequiredDisenchantSkill = 0;

  117. 

  118. update item_3 set name=concat(name,'◇荣耀黄金');

  119. update item_3 set entry = entry + 300000;

  120. UPDATE item_3 SET stat_value1 = stat_value1*@lv3;

  121. UPDATE item_3 SET stat_value2 = stat_value2*@lv3;

  122. UPDATE item_3 SET stat_value3 = stat_value3*@lv3;

  123. UPDATE item_3 SET stat_value4 = stat_value4*@lv3;

  124. UPDATE item_3 SET stat_value5 = stat_value5*@lv3;

  125. UPDATE item_3 SET stat_value6 = stat_value6*@lv3;

  126. UPDATE item_3 SET stat_value7 = stat_value7*@lv3;

  127. UPDATE item_3 SET stat_value8 = stat_value8*@lv3;

  128. UPDATE item_3 SET stat_value9 = stat_value9*@lv3;

  129. UPDATE item_3 SET stat_value10 = stat_value10*@lv3;

  130. UPDATE item_3 SET armor = armor*@lv3;

  131. UPDATE item_3 SET holy_res = holy_res*@lv3;

  132. UPDATE item_3 SET fire_res = fire_res*@lv3;

  133. UPDATE item_3 SET nature_res = nature_res*@lv3;

  134. UPDATE item_3 SET frost_res = frost_res*@lv3;

  135. UPDATE item_3 SET shadow_res = shadow_res*@lv3;

  136. UPDATE item_3 SET arcane_res = arcane_res*@lv3;

  137. UPDATE item_3 SET dmg_min1 = dmg_min1*@lv3_dmg;

  138. UPDATE item_3 SET dmg_max1 = dmg_max1*@lv3_dmg;

  139. UPDATE item_3 SET SellPrice = SellPrice*1;

  140. update item_3 set maxcount = 3 where maxcount <= 1;

  141. update item_3 set DisenchantID = entry,RequiredDisenchantSkill = 0;

  142. 

  143. insert into item_template_copy select * from item_1;

  144. insert into item_template_copy select * from item_2;

  145. insert into item_template_copy select * from item_3;

  146. 

  147. insert into item_template_custom select * from item_1;

  148. insert into item_template_custom select * from item_2;

  149. insert into item_template_custom select * from item_3;

  150. 

  151. /*升级表配置,我都按照装等设置数量*/

  152. update up1 a,item_template_copy b set a.oldItemCount = 1,a.newItemEntry = a.oldItemEntry + 100000,

  153. a.chance = 100 - (b.itemlevel) * 0.09,

  154. 

  155. /*霜纹布 公式:装等*品质*0.05

  156. 例子:

  157. 装等10 绿装 10*2*0.05=1

  158. 装等200紫装 200*4*0.05=40 

  159. 装等277紫装 277*4*0.05=55.4 */

  160. clEntry1 = 0, clCount1 = (b.itemlevel)* b.Quality * 2500,

  161. clEntry2 = 33470, clCount2 = (b.itemlevel)* b.Quality * 0.05,

  162. clEntry3 = 33568, clCount3 = (b.itemlevel)* b.Quality * 0.03,

  163. clEntry4 = 36912, clCount4 = (b.itemlevel) * b.Quality* 0.033 

  164. where a.oldItemEntry = b.entry;

  165. 

  166. update up2 a,item_template_copy b set a.oldItemCount = 2,a.oldItemEntry = a.oldItemEntry + 100000,a.newItemEntry = a.oldItemEntry + 200000,

  167. a.chance = (90 - (b.itemlevel) * 0.12),

  168. clEntry1 = 0, clCount1 = (b.itemlevel)* b.Quality * 6250,

  169. clEntry2 = 41510, clCount2 = (b.itemlevel) * b.Quality* 0.02,

  170. clEntry3 = 38425, clCount3 = (b.itemlevel) * b.Quality* 0.01,

  171. clEntry4 = 36913, clCount4 = (b.itemlevel) * b.Quality* 0.029 

  172. where a.oldItemEntry = b.entry;

  173. 

  174. update up3 a,item_template_copy b set a.oldItemCount = 3,a.oldItemEntry = a.oldItemEntry + 200000,a.newItemEntry = a.oldItemEntry + 300000,

  175. a.chance = 80 - (b.itemlevel) * 0.15,

  176. clEntry1 = 0, clCount1 = (b.itemlevel)* b.Quality * 25000,

  177. clEntry2 = 41511, clCount2 = (b.itemlevel)* b.Quality * 0.038,

  178. clEntry3 = 44128, clCount3 = (b.itemlevel)* b.Quality * 0.0065,

  179. clEntry4 = 37663, clCount4 = (b.itemlevel) * b.Quality* 0.0065 

  180. where a.oldItemEntry = b.entry;

  181. 

  182. insert into item_up select * from up1;

  183. insert into item_up select * from up2;

  184. insert into item_up select * from up3;

  185. 

  186. INSERT INTO disenchant_loot_template select newItemEntry,oldItemEntry,100,1,0,oldItemCount,oldItemCount from item_up;

  187. INSERT INTO disenchant_loot_template select newItemEntry,clEntry1,100,1,1,1,clCount1 * 0.6 from item_up where clEntry1 <> 0 and clCount1 <> 0;

  188. INSERT INTO disenchant_loot_template select newItemEntry,clEntry2,100,1,2,1,clCount2 * 0.6 from item_up where clEntry2 <> 0 and clCount2 <> 0;

  189. INSERT INTO disenchant_loot_template select newItemEntry,clEntry3,100,1,3,1,clCount3 * 0.6 from item_up where clEntry3 <> 0 and clCount3 <> 0;

  190. INSERT INTO disenchant_loot_template select newItemEntry,clEntry4,100,1,4,1,clCount4 * 0.6 from item_up where clEntry4 <> 0 and clCount4 <> 0;

  191. INSERT INTO disenchant_loot_template select newItemEntry,clEntry5,100,1,5,1,clCount5 * 0.6 from item_up where clEntry5 <> 0 and clCount5 <> 0;

复制代码


[发帖际遇]: ayase积极反馈有爱魔兽BUG,获得4 声望. 幸运榜 / 衰神榜
因工作繁忙,只在晚上处理论坛事务.
回复

使用道具 举报

cz262

20

时沙

0

精华

1

主题

声望: 277   虚弱: 0

Lv.2(潜行者)

瓦格里的标记
发表于 2022-8-27 22:45:49 | 显示全部楼层
还是没搞明白挑战者模式怎么搞
回复

使用道具 举报

鱼非羊

37

时沙

0

精华

1

主题

声望: 48   虚弱: 0

Lv.1(追随者)
发表于 2022-11-26 19:36:36 | 显示全部楼层
楼主  请问你是如何部署到服务器的啊  我这边也是想三两好友一起玩 但不知道怎么改   我尝试着把worldserver.conf中的SOAP IP改为服务器IP后 客户端能登录成功 但选择服务器时 无法进入服务器  是修改的地方不完整么？
回复

使用道具 举报

12
返回列表 发帖
快速回复 返回顶部 返回列表

    © 2001-2019 Comsenz Inc. Powered by Discuz!X3.4 ( 粤ICP备19016828号 )

    GMT+8, 2026-2-17 22:53, Processed in 0.482475 second(s), 14 queries , File On.