`creature_loot_template`.`item` = `item_template`.`item` AND `item_template`.`Quality` 0 and `creature_loot_template`.`groupid` 0 AND `creature_loot_template`.`item` = `item_template`.`item` AND `item_template`.`Quality` > 1 ================================================== =================================== 70級以下精英一下怪綠色以上裝備暴率調低100倍 ================================================== =================================== update `creature_loot_template` Inner Join `creature_template` Inner Join `item_template` set `ChanceOrQuestChance` = `ChanceOrQuestChance` / 100 WHERE `creature_loot_template`.`entry` = `creature_template`.`entry` AND `creature_loot_template`.`ChanceOrQuestChance` > 0 and `creature_loot_template`.`groupid` 1 ================================================== ==================================== 所有任務物品暴率上調25 %暴率最高不超過55 % ================================================== ==================================== update `creature_loot_template` Inner Join `item_template` set `ChanceOrQuestChance` = `ChanceOrQuestChance`+ 25 WHERE `creature_loot_template`.`ChanceOrQuestChance` > 0 and `creature_loot_template`.`ChanceOrQuestChance` < 30 and `creature_loot_template`.`groupid` < 1 and `creature_loot_template`.`item` = `item_template`.`item` AND `item_template`.`class` = 12 風暴要塞七把橙色武器去除地圖和時間限制 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 item_template set stackable = 100 where entry = 6265; 去除裝備上的唯一屬性 UPDATE item_template SET Maxcount = 0; 去除榜定 UPDATE item_template SET bonding = 0; 去除職業限制 update item_template set allowableclass = -1 以上建議使用時備份@@祝大家開心 (责任编辑:admin) |