修改有风险，改前请存档，事后本帖不负责
修改有风险，改前请存档，事后本帖不负责
修改有风险，改前请存档，事后本帖不负责
*************************************↓↓以下为正文↓↓*************************************
1.打开数据库管理工具 Navicat，或HeidiSQL
2.找到 world 数据库，这里是mangos
3.找到列表item_template并点击“查询-新建”，输入以下语句（可复制粘贴）
SELECT entry, name FROM item_template WHERE name LIKE '%Hearthstone%';
4.从item_template列表找到“炉石”的ID“entry”为（6948）
5.在item_template列表点击“筛选-添加”，条件为entry等于6948[直接点击等于后面的问号即可输入]
6.点击下一行的“应用 (Ctrl+R)”或者直接按快捷键，找到炉石的物品信息
7.“spellid_1”即为炉石的法术ID（8690）
*****************以上为第一阶段************************
1. 打开world数据库（mangos），找到spell_template列表
2.点击“查询-新建”，输入以下语句（可复制粘贴）
SELECT entry, name FROM spell_template WHERE name LIKE '%Hearthstone%';
3.此处的“entry”与前面获得的法术ID一致（8690），可略过直接进行下一行
4.spell_template列表点击“筛选-添加”，条件为entry等于8690[直接点击等于后面的问号即可输入]
5.点击下一行的“应用 (Ctrl+R)”或者直接按快捷键，找到炉石的法术信息
6.修改“categoryRecoveryTime”项目，默认3600000，很明显单位职为毫秒，5min=300000
7.保存修改
*************************完毕*******************
修改有风险，改前请存档，事后本帖不负责
修改有风险，改前请存档，事后本帖不负责
修改有风险，改前请存档，事后本帖不负责

技术帝

顶🔝

做成宏他不香吗？

高手！

魔改的技能ID怎么查询呢？

UPDATE `mangos`.`spell_template` SET `entry`='8690', `build`='4222', `school`='0', `category`='89', `castUI`='0', `dispel`='0', `mechanic`='0', `attributes`='134283264', `attributesEx`='0', `attributesEx2`='0', `attributesEx3`='0', `attributesEx4`='0', `stances`='0', `stancesNot`='0', `targets`='0', `targetCreatureType`='0', `requiresSpellFocus`='0', `casterAuraState`='0', `targetAuraState`='0', `castingTimeIndex`='7', `recoveryTime`='0', `categoryRecoveryTime`='6000', `interruptFlags`='31', `auraInterruptFlags`='0', `channelInterruptFlags`='0', `procFlags`='0', `procChance`='101', `procCharges`='0', `maxLevel`='0', `baseLevel`='0', `spellLevel`='0', `durationIndex`='0', `powerType`='0', `manaCost`='0', `manCostPerLevel`='0', `manaPerSecond`='0', `manaPerSecondPerLevel`='0', `rangeIndex`='1', `speed`='0', `modelNextSpell`='0', `stackAmount`='0', `totem1`='0', `totem2`='0', `reagent1`='0', `reagent2`='0', `reagent3`='0', `reagent4`='0', `reagent5`='0', `reagent6`='0', `reagent7`='0', `reagent8`='0', `reagentCount1`='0', `reagentCount2`='0', `reagentCount3`='0', `reagentCount4`='0', `reagentCount5`='0', `reagentCount6`='0', `reagentCount7`='0', `reagentCount8`='0', `equippedItemClass`='-1', `equippedItemSubClassMask`='-1', `equippedItemInventoryTypeMask`='0', `effect1`='5', `effect2`='0', `effect3`='0', `effectDieSides1`='1', `effectDieSides2`='0', `effectDieSides3`='0', `effectBaseDice1`='1', `effectBaseDice2`='0', `effectBaseDice3`='0', `effectDicePerLevel1`='0', `effectDicePerLevel2`='0', `effectDicePerLevel3`='0', `effectRealPointsPerLevel1`='0', `effectRealPointsPerLevel2`='0', `effectRealPointsPerLevel3`='0', `effectBasePoints1`='-1', `effectBasePoints2`='0', `effectBasePoints3`='0', `effectBonusCoefficient1`='0', `effectBonusCoefficient2`='-1', `effectBonusCoefficient3`='-1', `effectMechanic1`='0', `effectMechanic2`='0', `effectMechanic3`='0', `effectImplicitTargetA1`='1', `effectImplicitTargetA2`='0', `effectImplicitTargetA3`='0', `effectImplicitTargetB1`='9', `effectImplicitTargetB2`='0', `effectImplicitTargetB3`='0', `effectRadiusIndex1`='0', `effectRadiusIndex2`='0', `effectRadiusIndex3`='0', `effectApplyAuraName1`='0', `effectApplyAuraName2`='0', `effectApplyAuraName3`='0', `effectAmplitude1`='0', `effectAmplitude2`='0', `effectAmplitude3`='0', `effectMultipleValue1`='0', `effectMultipleValue2`='0', `effectMultipleValue3`='0', `effectChainTarget1`='0', `effectChainTarget2`='0', `effectChainTarget3`='0', `effectItemType1`='0', `effectItemType2`='0', `effectItemType3`='0', `effectMiscValue1`='0', `effectMiscValue2`='0', `effectMiscValue3`='0', `effectTriggerSpell1`='0', `effectTriggerSpell2`='0', `effectTriggerSpell3`='0', `effectPointsPerComboPoint1`='0', `effectPointsPerComboPoint2`='0', `effectPointsPerComboPoint3`='0', `spellVisual1`='220', `spellVisual2`='0', `spellIconId`='776', `activeIconId`='0', `spellPriority`='0', `name`='Hearthstone', `nameFlags`='983070', `nameSubtext`='', `nameSubtextFlags`='983052', `description`='Returns you to $z. Speak to an Innkeeper in a different place to change your home location.', `descriptionFlags`='983070', `auraDescription`='', `auraDescriptionFlags`='983052', `manaCostPercentage`='0', `startRecoveryCategory`='133', `startRecoveryTime`='1500', `minTargetLevel`='0', `maxTargetLevel`='0', `spellFamilyName`='0', `spellFamilyFlags`='0', `maxAffectedTargets`='0', `dmgClass`='0', `preventionType`='0', `stanceBarOrder`='-1', `dmgMultiplier1`='1', `dmgMultiplier2`='1', `dmgMultiplier3`='1', `minFactionId`='0', `minReputation`='0', `requiredAuraVision`='0', `customFlags`='0', `script_name`='' WHERE (`entry`='8690') AND (`build`='4222');
UPDATE `mangos`.`spell_template` SET `entry`='8690', `build`='5086', `school`='0', `category`='89', `castUI`='0', `dispel`='0', `mechanic`='0', `attributes`='134283264', `attributesEx`='0', `attributesEx2`='0', `attributesEx3`='0', `attributesEx4`='0', `stances`='0', `stancesNot`='0', `targets`='0', `targetCreatureType`='0', `requiresSpellFocus`='0', `casterAuraState`='0', `targetAuraState`='0', `castingTimeIndex`='7', `recoveryTime`='0', `categoryRecoveryTime`='6000', `interruptFlags`='31', `auraInterruptFlags`='0', `channelInterruptFlags`='0', `procFlags`='0', `procChance`='101', `procCharges`='0', `maxLevel`='0', `baseLevel`='0', `spellLevel`='0', `durationIndex`='0', `powerType`='0', `manaCost`='0', `manCostPerLevel`='0', `manaPerSecond`='0', `manaPerSecondPerLevel`='0', `rangeIndex`='1', `speed`='0', `modelNextSpell`='0', `stackAmount`='0', `totem1`='0', `totem2`='0', `reagent1`='0', `reagent2`='0', `reagent3`='0', `reagent4`='0', `reagent5`='0', `reagent6`='0', `reagent7`='0', `reagent8`='0', `reagentCount1`='0', `reagentCount2`='0', `reagentCount3`='0', `reagentCount4`='0', `reagentCount5`='0', `reagentCount6`='0', `reagentCount7`='0', `reagentCount8`='0', `equippedItemClass`='-1', `equippedItemSubClassMask`='-1', `equippedItemInventoryTypeMask`='0', `effect1`='5', `effect2`='77', `effect3`='0', `effectDieSides1`='1', `effectDieSides2`='0', `effectDieSides3`='0', `effectBaseDice1`='1', `effectBaseDice2`='0', `effectBaseDice3`='0', `effectDicePerLevel1`='0', `effectDicePerLevel2`='0', `effectDicePerLevel3`='0', `effectRealPointsPerLevel1`='0', `effectRealPointsPerLevel2`='0', `effectRealPointsPerLevel3`='0', `effectBasePoints1`='-1', `effectBasePoints2`='0', `effectBasePoints3`='0', `effectBonusCoefficient1`='0', `effectBonusCoefficient2`='1', `effectBonusCoefficient3`='-1', `effectMechanic1`='0', `effectMechanic2`='0', `effectMechanic3`='0', `effectImplicitTargetA1`='1', `effectImplicitTargetA2`='1', `effectImplicitTargetA3`='0', `effectImplicitTargetB1`='9', `effectImplicitTargetB2`='0', `effectImplicitTargetB3`='0', `effectRadiusIndex1`='0', `effectRadiusIndex2`='0', `effectRadiusIndex3`='0', `effectApplyAuraName1`='0', `effectApplyAuraName2`='0', `effectApplyAuraName3`='0', `effectAmplitude1`='0', `effectAmplitude2`='0', `effectAmplitude3`='0', `effectMultipleValue1`='0', `effectMultipleValue2`='0', `effectMultipleValue3`='0', `effectChainTarget1`='0', `effectChainTarget2`='0', `effectChainTarget3`='0', `effectItemType1`='0', `effectItemType2`='0', `effectItemType3`='0', `effectMiscValue1`='0', `effectMiscValue2`='0', `effectMiscValue3`='0', `effectTriggerSpell1`='0', `effectTriggerSpell2`='0', `effectTriggerSpell3`='0', `effectPointsPerComboPoint1`='0', `effectPointsPerComboPoint2`='0', `effectPointsPerComboPoint3`='0', `spellVisual1`='220', `spellVisual2`='0', `spellIconId`='776', `activeIconId`='0', `spellPriority`='0', `name`='Hearthstone', `nameFlags`='2031678', `nameSubtext`='', `nameSubtextFlags`='2031676', `description`='Returns you to $z. Speak to an Innkeeper in a different place to change your home location.', `descriptionFlags`='2031678', `auraDescription`='', `auraDescriptionFlags`='2031676', `manaCostPercentage`='0', `startRecoveryCategory`='133', `startRecoveryTime`='1500', `minTargetLevel`='0', `maxTargetLevel`='0', `spellFamilyName`='0', `spellFamilyFlags`='0', `maxAffectedTargets`='0', `dmgClass`='0', `preventionType`='0', `stanceBarOrder`='-1', `dmgMultiplier1`='1', `dmgMultiplier2`='1', `dmgMultiplier3`='1', `minFactionId`='0', `minReputation`='0', `requiredAuraVision`='0', `customFlags`='0', `script_name`='' WHERE (`entry`='8690') AND (`build`='5086');

再发个小便利，有需要的可以用一下
UPDATE `item_template` SET stackable = 9999 where stackable > 1 ; /*所有堆叠数大于1的改为9999*/UPDATE `item_template` SET `stackable`='9999' WHERE (`entry`='6265') ; /*灵魂碎片堆叠数改为9999*/update creature_loot_template set ChanceOrQuestChance = -100 where ChanceOrQuestChance<0; /*任务物品100%掉落*/

大佬们，请教怎么修改猎人宝宝攻击属性，姐夫只改了各种族初始地的几个，我想把黑海岸那个幽灵豹改个带属性攻击的，谢谢

一般mangos还需要改spell.dbc里的值。不知道姐夫端需要改不。

牛啊

请问下 飞机的价格在哪里调整啊？ 前期没钱 低级副本都没法传送去打。。