魔兽世界5.4.8 服务端+客户端+插件+登录器(虚拟机+手工)

qxpf666

2、建立GM账号
手动添加，打开Navicat Premium打开数据库 auth->rbac_account_permissions 添加你的账号数据，格式如下
"accountId"        "permissionId"        "granted"        "realmId"
1                           196                              1                  -1

佰厌星

请问可以用别的客户端吗，比如逍遥

qxpf666

是5.4.8版本号为18414的都可以，用我上传的单机登录器登录就可以

狼桃

谢谢大神分享

qxpf666

目前是官方设置，后续添加一些自定义的功能

player888

谢谢楼主分享

hhj134

学习了，很有用！

qxpf666

90%还原官方

zt3632563

不知道能不能玩，之前下了很多都完不成。

qq78914100

支持支持支持

247134154

不知道怎么注册账号。。。。

qxpf666

247134154 发表于 2025-3-26 19:57
不知道怎么注册账号。。。。

1、创建账号（需要在worldserver.exe里面输入），不要加下面的'<>'
account create <accountname> <password>

kt9606

感谢分享

shgedu

大神，我在建立数据库后，auth、characters、world，前两个没问题，导入SQL成功，最后一个，导入出错了，是字符集编码的问题吗？

Query:
CREATE TABLE `game_event`  (
  `eventEntry` tinyint UNSIGNED NOT NULL COMMENT 'Entry of the game event',
  `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before',
  `end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler',
  `occurence` bigint UNSIGNED NOT NULL DEFAULT 5184000 COMMENT 'Delay in minutes between occurences of the event',
  `length` bigint UNSIGNED NOT NULL DEFAULT 2592000 COMMENT 'Length in minutes of the event',
  `holiday` mediumint UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Client side holiday id',
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Description of the event displayed in console',
  `world_event` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 if normal event, 1 if world event',
  `announce` tinyint UNSIGNED NULL DEFAULT 2 COMMENT '0 dont announce, 1 announce, 2 value from config',
  PRIMARY KEY (`eventEntry`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic

Error occured at:2025-03-27 10:06:11
Line no.:787718
Error Code: 1067 - Invalid default value for 'start_time'



Query:
CREATE TABLE `game_event`  (
  `eventEntry` tinyint UNSIGNED NOT NULL COMMENT 'Entry of the game event',
  `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before',
  `end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler',
  `occurence` bigint UNSIGNED NOT NULL DEFAULT 5184000 COMMENT 'Delay in minutes between occurences of the event',
  `length` bigint UNSIGNED NOT NULL DEFAULT 2592000 COMMENT 'Length in minutes of the event',
  `holiday` mediumint UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Client side holiday id',
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Description of the event displayed in console',
  `world_event` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 if normal event, 1 if world event',
  `announce` tinyint UNSIGNED NULL DEFAULT 2 COMMENT '0 dont announce, 1 announce, 2 value from config',
  PRIMARY KEY (`eventEntry`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic

Error occured at:2025-03-27 10:16:19
Line no.:787718
Error Code: 1067 - Invalid default value for 'start_time'

qxpf666

shgedu 发表于 2025-3-27 09:35
大神，我在建立数据库后，auth、characters、world，前两个没问题，导入SQL成功，最后一个，导入出错了，是 ...

是的，建议用mysql8.4.4版本

shgedu

qxpf666 发表于 2025-3-27 10:09
是的，建议用mysql8.4.4版本

用的是8.4.4啊
Query:
CREATE TABLE `game_event`  (
  `eventEntry` tinyint UNSIGNED NOT NULL COMMENT 'Entry of the game event',
  `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before',
  `end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler',
  `occurence` bigint UNSIGNED NOT NULL DEFAULT 5184000 COMMENT 'Delay in minutes between occurences of the event',
  `length` bigint UNSIGNED NOT NULL DEFAULT 2592000 COMMENT 'Length in minutes of the event',
  `holiday` mediumint UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Client side holiday id',
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Description of the event displayed in console',
  `world_event` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 if normal event, 1 if world event',
  `announce` tinyint UNSIGNED NULL DEFAULT 2 COMMENT '0 dont announce, 1 announce, 2 value from config',
  PRIMARY KEY (`eventEntry`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic

Error occured at:2025-03-27 10:06:11
Line no.:787718
Error Code: 1067 - Invalid default value for 'start_time'



Query:
CREATE TABLE `game_event`  (
  `eventEntry` tinyint UNSIGNED NOT NULL COMMENT 'Entry of the game event',
  `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before',
  `end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler',
  `occurence` bigint UNSIGNED NOT NULL DEFAULT 5184000 COMMENT 'Delay in minutes between occurences of the event',
  `length` bigint UNSIGNED NOT NULL DEFAULT 2592000 COMMENT 'Length in minutes of the event',
  `holiday` mediumint UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Client side holiday id',
  `description` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Description of the event displayed in console',
  `world_event` tinyint UNSIGNED NOT NULL DEFAULT 0 COMMENT '0 if normal event, 1 if world event',
  `announce` tinyint UNSIGNED NULL DEFAULT 2 COMMENT '0 dont announce, 1 announce, 2 value from config',
  PRIMARY KEY (`eventEntry`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic

Error occured at:2025-03-27 10:16:19
Line no.:787718
Error Code: 1067 - Invalid default value for 'start_time'

qxpf666

重新用我百度云盘的文件sqlyog导入下，数据库重新下载试试，原来的那个是navi备份的

qxpf666

shgedu 发表于 2025-3-27 09:35
大神，我在建立数据库后，auth、characters、world，前两个没问题，导入SQL成功，最后一个，导入出错了，是 ...

重新用我百度云盘的文件sqlyog导入下，数据库重新下载试试，原来的那个是navi备份的

凝望骑士

首先谢谢大佬分享，请问任务副本是修复到什么程度的版本，

qxpf666

不行的话就用虚拟机版本试试看，已经上传到百度云盘了