用lua实现2.43TBC双天赋功能

luhongjin0101

感谢分享,大佬厉害

你的小可爱喵

感谢分享，扩展一下做成三天赋吧

ilhuyi

感谢分享

guruihan

感谢分享

yylwb152

请教一下，这是不是还缺少1个双天赋卷轴的sql呢？

zhxlovevs

yylwb152 发表于 2024-8-23 17:01
请教一下，这是不是还缺少1个双天赋卷轴的sql呢？

由于各种端数据库不一样 随便做个带技能的物品就行了

cs297334757

感谢大佬分享！

laotang1973

[SQL] Query player_dual_spec start
[ERR] 1142 - REFERENCES command denied to user 'mangos'@'localhost' for table 'tbccharacters.player'
[ERR] /*
MySQL Data Transfer
Source Host: localhost
Source Database: tbccharacters
Target Host: localhost
Target Database: tbccharacters
Date: 2024/8/22 13:38:55
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for player_dual_spec
-- ----------------------------
CREATE TABLE `player_dual_spec` (
  `guid` bigint(20) unsigned NOT NULL,
  `dual_spec_enabled` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`guid`),
  CONSTRAINT `player_dual_spec_ibfk_1` FOREIGN KEY (`guid`) REFERENCES `player` (`guid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records
-- ----------------------------
;
[SQL] Finished with error

[SQL] Query player_talent_specs start
[ERR] 1142 - REFERENCES command denied to user 'mangos'@'localhost' for table 'tbccharacters.player'
[ERR] /*
MySQL Data Transfer
Source Host: localhost
Source Database: tbccharacters
Target Host: localhost
Target Database: tbccharacters
Date: 2024/8/22 13:38:59
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for player_talent_specs
-- ----------------------------
CREATE TABLE `player_talent_specs` (
  `guid` bigint(20) unsigned NOT NULL,
  `spec_id` tinyint(1) NOT NULL,
  `talent_tabs` text NOT NULL,
  PRIMARY KEY (`guid`,`spec_id`),
  CONSTRAINT `player_talent_specs_ibfk_1` FOREIGN KEY (`guid`) REFERENCES `player` (`guid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records
-- ----------------------------
;
[SQL] Finished with error
这2张表创建不了？

yxb135

感谢分享，正需要，下来看看

yxb135

laotang1973 发表于 2024-8-27 01:01
[SQL] Query player_dual_spec start
[ERR] 1142 - REFERENCES command denied to user 'mangos'@'localhos ...

你的数据库帐户权限不够，换成默认root帐户登陆可解决。