网页资讯视频图片知道文库贴吧地图采购
进入贴吧全吧搜索
你姐的夫吧 关注：1,414贴子：10,341
  • 20回复贴，共1页

人人为我，我为人人，来点常用的SQL语句，供后来者们参考。

只看楼主收藏回复

此贴为抛砖引玉，希望大家多多支持！
1.关于SQL语句的使用方法
打开数据库，world里按F6，或右键表，选择命令列界面，粘贴，回车，显示有Query OK等等就可以了。
2.汉化本地数据库
/*汉化生物列表
update creature_template,locales_creature set creature_template.name = locales_creature.name_loc4 where creature_template.entry = locales_creature.entry;
/*汉化物品列表（注意，此处汉化后姐夫端部分物品无名字显示）
update item_template,locales_item set item_template.name = locales_item.name_loc4 where item_template.entry = locales_item.entry;
3.提升任务物品掉率（-100即为100%掉落，可以改成自己想要的数值）
UPDATE creature_loot_template set ChanceOrQuestChance = -100 where ChanceOrQuestChance<0;
4.属性倍率
/*宠物N倍血,N倍魔,属性N倍,如要调整人物等级属性将pet_levelstats改为player_levelstats即可
update pet_levelstats set hp = hp*N;
update pet_levelstats set mana = mana*N;
update pet_levelstats set armor = armor*N;
update pet_levelstats set str = str*N;
update pet_levelstats set agi = agi*N;
update pet_levelstats set sta = sta*N;
update pet_levelstats set inte = inte*N;
5.BOSS物品掉落数量
/*去除BOSS只掉落两三件装备的限制
Update creature_loot_template set group_id=0;
Update creature_loot_template set ChanceOrQuestChance = replace(ChanceOrQuestChance,'0','20') where ChanceOrQuestChance = 0;
6.去除装备限制属性
/*去除职业限制
Update item_template set Allowable_Class = -1;
/*去除种族限制：
Update item_template set Allowable_Race = -1;
/*去除需求专业限制：
Update item_template set Required_Skill = 0;
Update item_template set Required_Skill_Rank = 0;
/*去除需求技能限制：
Update item_template set required_spell = 0;
/*去除荣誉限制：
Update item_template set required_honor_rank = 0;
/*去除声望限制：
Update item_template set Required_Reputation_Faction = 0;
Update item_template set Required_Reputation_Rank = 0;
/*去除唯一限制：
Update item_template set max_count = 0;
/*去除叠加限制
Update item_template set stackable = 255 where stackable>1;
/*去除绑定限制：
Update item_template set bonding = 0;
IP属地:湖南1楼2025-02-27 10:23回复
    谢谢分享
    IP属地:四川2楼2025-02-27 14:54
    回复
      2026-02-13 16:02:24
      广告
      不感兴趣
      开通SVIP免广告
      请问 猎人可以穿重甲 这个怎么改？
      IP属地:广西3楼2025-02-28 14:15
      回复
        试试这个
        /*去除职业对武器、护甲类型的限制：
        Update playercreateinfo_spell set racemask = 0 where spell = 75;
        Update playercreateinfo_spell set classmask = 0 where spell = 75;
        Update playercreateinfo_spell set racemask = 0 where spell = 107;
        Update playercreateinfo_spell set classmask = 0 where spell = 107;
        Update playercreateinfo_spell set racemask = 0 where spell = 197;
        Update playercreateinfo_spell set classmask = 0 where spell = 197;
        Update playercreateinfo_spell set racemask = 0 where spell = 198;
        Update playercreateinfo_spell set classmask = 0 where spell = 198;
        Update playercreateinfo_spell set racemask = 0 where spell = 199;
        Update playercreateinfo_spell set classmask = 0 where spell = 199;
        Update playercreateinfo_spell set racemask = 0 where spell = 200;
        Update playercreateinfo_spell set classmask = 0 where spell = 200;
        Update playercreateinfo_spell set racemask = 0 where spell = 201;
        Update playercreateinfo_spell set classmask = 0 where spell = 201;
        Update playercreateinfo_spell set racemask = 0 where spell = 202;
        Update playercreateinfo_spell set classmask = 0 where spell = 202;
        Update playercreateinfo_spell set racemask = 0 where spell = 227;
        Update playercreateinfo_spell set classmask = 0 where spell = 227;
        Update playercreateinfo_spell set racemask = 0 where spell = 264;
        Update playercreateinfo_spell set classmask = 0 where spell = 264;
        Update playercreateinfo_spell set racemask = 0 where spell = 266;
        Update playercreateinfo_spell set classmask = 0 where spell = 266;
        Update playercreateinfo_spell set racemask = 0 where spell = 674;
        Update playercreateinfo_spell set classmask = 0 where spell = 674;
        Update playercreateinfo_spell set racemask = 0 where spell = 750;
        Update playercreateinfo_spell set classmask = 0 where spell = 750;
        Update playercreateinfo_spell set racemask = 0 where spell = 1180;
        Update playercreateinfo_spell set classmask = 0 where spell = 1180;
        Update playercreateinfo_spell set racemask = 0 where spell = 2567;
        Update playercreateinfo_spell set classmask = 0 where spell = 2567;
        Update playercreateinfo_spell set racemask = 0 where spell = 2764;
        Update playercreateinfo_spell set classmask = 0 where spell = 2764;
        Update playercreateinfo_spell set racemask = 0 where spell = 3127;
        Update playercreateinfo_spell set classmask = 0 where spell = 3127;
        Update playercreateinfo_spell set racemask = 0 where spell = 5009;
        Update playercreateinfo_spell set classmask = 0 where spell = 5009;
        Update playercreateinfo_spell set racemask = 0 where spell = 5011;
        Update playercreateinfo_spell set classmask = 0 where spell = 5011;
        Update playercreateinfo_spell set racemask = 0 where spell = 5019;
        Update playercreateinfo_spell set classmask = 0 where spell = 5019;
        Update playercreateinfo_spell set racemask = 0 where spell = 8737;
        Update playercreateinfo_spell set classmask = 0 where spell = 8737;
        Update playercreateinfo_spell set racemask = 0 where spell = 9077;
        Update playercreateinfo_spell set classmask = 0 where spell = 9077;
        Update playercreateinfo_spell set racemask = 0 where spell = 9116;
        Update playercreateinfo_spell set classmask = 0 where spell = 9116;
        Update playercreateinfo_spell set racemask = 0 where spell = 27762;
        Update playercreateinfo_spell set classmask = 0 where spell = 27762;
        Update playercreateinfo_spell set racemask = 0 where spell = 27763;
        Update playercreateinfo_spell set classmask = 0 where spell = 27763;
        Update playercreateinfo_spell set racemask = 0 where spell = 27764;
        Update playercreateinfo_spell set classmask = 0 where spell = 27764;
        @godpuppet
        IP属地:湖南4楼2025-03-01 00:27
        收起回复
          打开数据库，world里按F6，或右键表，选择命令列界面，粘贴，回车，显示有Query OK等等就可以了。 是哪个world
          IP属地:广西5楼2025-03-04 23:37
          回复
            我在其他网站 找了个物品255个1组的命令条 输入了成功了 但是不知道怎么处理好的
            IP属地:广西6楼2025-03-05 01:27
            收起回复
              谢谢
              IP属地:广西7楼2025-03-05 19:25
              回复
                可以在帮写一条命令吗？ 人物可以使用所有武器 。猎人想用锤子
                IP属地:广西8楼2025-03-07 18:10
                回复
                  2026-02-13 15:56:24
                  广告
                  不感兴趣
                  开通SVIP免广告
                  发个自己用的和我一样只玩部落的可以用一下
                  /*亡灵剑专精*/
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('5', '1', '20597', '0', '5875', 'Sword Specialization');
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('5', '4', '20597', '0', '5875', 'Sword Specialization');
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('5', '5', '20597', '0', '5875', 'Sword Specialization');
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('5', '8', '20597', '0', '5875', 'Sword Specialization');
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('5', '9', '20597', '0', '5875', 'Sword Specialization');
                  /*牛头锤专精*/
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('6', '1', '20864', '0', '5875', 'Sword Specialization');
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('6', '3', '20864', '0', '5875', 'Sword Specialization');
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('6', '7', '20864', '0', '5875', 'Sword Specialization');
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('6', '11', '20864', '0', '5875', 'Sword Specialization');
                  /*牛头枪专精*/
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('6', '1', '20595', '0', '5875', 'Sword Specialization');
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('6', '3', '20595', '0', '5875', 'Sword Specialization');
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('6', '7', '20595', '0', '5875', 'Sword Specialization');
                  INSERT INTO `mangos`.`playercreateinfo_spell` (`race`, `class`, `spell`, `build_min`, `build_max`, `note`) VALUES ('6', '11', '20595', '0', '5875', 'Sword Specialization');
                  IP属地:辽宁9楼2025-03-09 17:05
                  收起回复
                    心血来潮再发几个
                    UPDATE `item_template` SET `stackable`='9999' WHERE (`entry`='6265') ; /*灵魂碎片堆叠数改为9999【9999可改255或20，不影响】*/
                    6秒炉石【无CD就把6000改为0】
                    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');
                    IP属地:辽宁10楼2025-03-09 17:11
                    回复
                      感谢分享！
                      IP属地:浙江11楼2025-10-17 22:18
                      回复

                        扫二维码下载贴吧客户端

                        下载贴吧APP
                        看高清直播、视频！
                        • 20回复贴，共1页
                        发表回复
                        发贴请遵守贴吧协议及“七条底线”贴吧投诉
                        内  容:
                          查看全部
                        发 表
                        保存至快速回贴

                        发布成功
                        去贴吧APP订阅抽奖结果通知
                        扫码进入贴吧APP
                        ···········
                        开奖后第一时间站内信通知
                        ···········
                        中奖结果全员公示