我找到了修复进魔塔的方法,都是转来的拿来给大家共享下。
龙塔进入不了,排行榜进不了前3,执行以下SQL,完美解决
修改之前需下线,关掉服务端,改好后再开启服务端
其实就是用户表中,少了6个ID的用户,所以用户信息找不到。
INSERT INTO `mt`.`userinfo` (`id`, `autoBuyCoin`, `blockChat`, `blockLogin`, `buyPackCount`, `cityId`, `coin`, `coupon`, `exp`, `fame`, `gold`, `identify`, `level`, `loginCount`, `loginDays`, `loginTime`, `logoutTime`, `longpo`, `pearlBagSize`, `playerName`, `registerTime`, `renamed`, `rmb`, `fundGold`, `server`, `sex`, `taskStep`, `totalGold`, `totalLoginDays`, `totalOnlineTime`, `userName`, `vocation`, `ability`, `charmValue`, `totalOlineTimeAtToday`, `tuiJie`, `loginPf`, `blockChatReason`, `lxLoginMonth`, `arenaHonor`, `maxAbility`, `gatherSpirit`) VALUES ('100010000000001', '0', '0', '0', '0', '1', '100270', '20', '2270', '0', '0', '0', '9', '1', '1', '2016-03-12 17:54:03', '2016-03-12 18:19:43', '1000', '0', '飓鼎玩网单1', '2016-03-12 17:02:08', '0', '0', '0', '1', '2', '9', '0', '1', '1988397', 'judingwan1', '2', '719.000', '0', '0', '0', '37wan', '', '1', '0', '0.0', '0');
INSERT INTO `mt`.`userinfo` (`id`, `autoBuyCoin`, `blockChat`, `blockLogin`, `buyPackCount`, `cityId`, `coin`, `coupon`, `exp`, `fame`, `gold`, `identify`, `level`, `loginCount`, `loginDays`, `loginTime`, `logoutTime`, `longpo`, `pearlBagSize`, `playerName`, `registerTime`, `renamed`, `rmb`, `fundGold`, `server`, `sex`, `taskStep`, `totalGold`, `totalLoginDays`, `totalOnlineTime`, `userName`, `vocation`, `ability`, `charmValue`, `totalOlineTimeAtToday`, `tuiJie`, `loginPf`, `blockChatReason`, `lxLoginMonth`, `arenaHonor`, `maxAbility`, `gatherSpirit`) VALUES ('100010000000002', '0', '0', '0', '0', '1', '100270', '20', '2270', '0', '0', '0', '9', '1', '1', '2016-03-12 17:54:03', '2016-03-12 18:19:43', '1000', '0', '飓鼎玩网单2', '2016-03-12 17:02:08', '0', '0', '0', '1', '2', '9', '0', '1', '1988397', 'judingwan2', '2', '719.000', '0', '0', '0', '37wan', '', '1', '0', '0.0', '0');
INSERT INTO `mt`.`userinfo` (`id`, `autoBuyCoin`, `blockChat`, `blockLogin`, `buyPackCount`, `cityId`, `coin`, `coupon`, `exp`, `fame`, `gold`, `identify`, `level`, `loginCount`, `loginDays`, `loginTime`, `logoutTime`, `longpo`, `pearlBagSize`, `playerName`, `registerTime`, `renamed`, `rmb`, `fundGold`, `server`, `sex`, `taskStep`, `totalGold`, `totalLoginDays`, `totalOnlineTime`, `userName`, `vocation`, `ability`, `charmValue`, `totalOlineTimeAtToday`, `tuiJie`, `loginPf`, `blockChatReason`, `lxLoginMonth`, `arenaHonor`, `maxAbility`, `gatherSpirit`) VALUES ('100010000000003', '0', '0', '0', '0', '1', '100270', '20', '2270', '0', '0', '0', '9', '1', '1', '2016-03-12 17:54:03', '2016-03-12 18:19:43', '1000', '0', '飓鼎玩网单3', '2016-03-12 17:02:08', '0', '0', '0', '1', '2', '9', '0', '1', '1988397', 'judingwan3', '2', '719.000', '0', '0', '0', '37wan', '', '1', '0', '0.0', '0');
INSERT INTO `mt`.`userinfo` (`id`, `autoBuyCoin`, `blockChat`, `blockLogin`, `buyPackCount`, `cityId`, `coin`, `coupon`, `exp`, `fame`, `gold`, `identify`, `level`, `loginCount`, `loginDays`, `loginTime`, `logoutTime`, `longpo`, `pearlBagSize`, `playerName`, `registerTime`, `renamed`, `rmb`, `fundGold`, `server`, `sex`, `taskStep`, `totalGold`, `totalLoginDays`, `totalOnlineTime`, `userName`, `vocation`, `ability`, `charmValue`, `totalOlineTimeAtToday`, `tuiJie`, `loginPf`, `blockChatReason`, `lxLoginMonth`, `arenaHonor`, `maxAbility`, `gatherSpirit`) VALUES ('100010000000004', '0', '0', '0', '0', '1', '100270', '20', '2270', '0', '0', '0', '9', '1', '1', '2016-03-12 17:54:03', '2016-03-12 18:19:43', '1000', '0', '飓鼎玩网单4', '2016-03-12 17:02:08', '0', '0', '0', '1', '2', '9', '0', '1', '1988397', 'judingwan4', '2', '719.000', '0', '0', '0', '37wan', '', '1', '0', '0.0', '0');
INSERT INTO `mt`.`userinfo` (`id`, `autoBuyCoin`, `blockChat`, `blockLogin`, `buyPackCount`, `cityId`, `coin`, `coupon`, `exp`, `fame`, `gold`, `identify`, `level`, `loginCount`, `loginDays`, `loginTime`, `logoutTime`, `longpo`, `pearlBagSize`, `playerName`, `registerTime`, `renamed`, `rmb`, `fundGold`, `server`, `sex`, `taskStep`, `totalGold`, `totalLoginDays`, `totalOnlineTime`, `userName`, `vocation`, `ability`, `charmValue`, `totalOlineTimeAtToday`, `tuiJie`, `loginPf`, `blockChatReason`, `lxLoginMonth`, `arenaHonor`, `maxAbility`, `gatherSpirit`) VALUES ('100010000000005', '0', '0', '0', '0', '1', '100270', '20', '2270', '0', '0', '0', '9', '1', '1', '2016-03-12 17:54:03', '2016-03-12 18:19:43', '1000', '0', '飓鼎玩网单5', '2016-03-12 17:02:08', '0', '0', '0', '1', '2', '9', '0', '1', '1988397', 'judingwan5', '2', '719.000', '0', '0', '0', '37wan', '', '1', '0', '0.0', '0');
INSERT INTO `mt`.`userinfo` (`id`, `autoBuyCoin`, `blockChat`, `blockLogin`, `buyPackCount`, `cityId`, `coin`, `coupon`, `exp`, `fame`, `gold`, `identify`, `level`, `loginCount`, `loginDays`, `loginTime`, `logoutTime`, `longpo`, `pearlBagSize`, `playerName`, `registerTime`, `renamed`, `rmb`, `fundGold`, `server`, `sex`, `taskStep`, `totalGold`, `totalLoginDays`, `totalOnlineTime`, `userName`, `vocation`, `ability`, `charmValue`, `totalOlineTimeAtToday`, `tuiJie`, `loginPf`, `blockChatReason`, `lxLoginMonth`, `arenaHonor`, `maxAbility`, `gatherSpirit`) VALUES ('100010000000006', '0', '0', '0', '0', '1', '100270', '20', '2270', '0', '0', '0', '9', '1', '1', '2016-03-12 17:54:03', '2016-03-12 18:19:43', '1000', '0', '飓鼎玩网单6', '2016-03-12 17:02:08', '0', '0', '0', '1', '2', '9', '0', '1', '1988397', 'judingwan6', '2', '719.000', '0', '0', '0', '37wan', '', '1', '0', '0.0', '0');
链接数据库,然后右键MT数据库,选择:命令行界面:,复制代码到界面,回车,搞定 |