2、建立GM账号
手动添加，打开Navicat Premium打开数据库 auth->rbac_account_permissions 添加你的账号数据，格式如下
"accountId" "permissionId" "granted" "realmId"
1 196 1 -1
请问可以用别的客户端吗，比如逍遥
是5.4.8版本号为18414的都可以，用我上传的单机登录器登录就可以
谢谢大神分享
目前是官方设置，后续添加一些自定义的功能
谢谢楼主分享
学习了，很有用！
90%还原官方
不知道能不能玩，之前下了很多都完不成。
支持支持支持
不知道怎么注册账号。。。。
247134154 发表于 2025-3-26 19:57
不知道怎么注册账号。。。。
1、创建账号（需要在worldserver.exe里面输入），不要加下面的'<>'
account create <accountname> <password>
感谢分享
本帖最后由 shgedu 于 2025-3-27 10:20 编辑
大神，我在建立数据库后，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'
shgedu 发表于 2025-3-27 09:35
大神，我在建立数据库后，auth、characters、world，前两个没问题，导入SQL成功，最后一个，导入出错了，是 ...
是的，建议用mysql8.4.4版本
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'
重新用我百度云盘的文件sqlyog导入下，数据库重新下载试试，原来的那个是navi备份的
shgedu 发表于 2025-3-27 09:35
大神，我在建立数据库后，auth、characters、world，前两个没问题，导入SQL成功，最后一个，导入出错了，是 ...
重新用我百度云盘的文件sqlyog导入下，数据库重新下载试试，原来的那个是navi备份的
首先谢谢大佬分享，请问任务副本是修复到什么程度的版本，:
不行的话就用虚拟机版本试试看，已经上传到百度云盘了