明日x舟碰到BUG的解决方法

巨二兔

说一下最近遇到bug的解决方式吧，升级干员技能时基建崩溃的问题，使用navicat16连上数据库，找到arknights下的account表，找到你的账号（你第一个建的号id是10000022，第二个则是10000023，以此类推），你的账号所有数据均在user栏里



点中user栏，复制出来粘贴到文本或者N++或者visual studio code，然后搜roomid，



把这段复制粘贴回去即可恢复原状（这段含所有roomid内容），为了方便复制粘贴我把这段加到这楼里

"roomId": "DORMITORY", "charInstIds": [-1, -1, -1, -1, -1], "completeConstructTime": 1578715560}, "slot_5": {"level": 3, "state": 2, "roomId": "TRADING", "charInstIds": [118, 65, 73], "completeConstructTime": 1568855638}, "slot_6": {"level": 3, "state": 2, "roomId": "MANUFACTURE", "charInstIds": [-1, -1, -1], "completeConstructTime": 1564509571}, "slot_7": {"level": 3, "state": 2, "roomId": "POWER", "charInstIds": [152], "completeConstructTime": 1568706033}, "slot_9": {"level": 5, "state": 2, "roomId": "DORMITORY", "charInstIds": [-1, -1, -1, -1, -1], "completeConstructTime": 1575611522}, "slot_13": {"level": 3, "state": 2, "roomId": "TRAINING", "charInstIds": [43, 137], "completeConstructTime": 1563958035}, "slot_14": {"level": 3, "state": 2, "roomId": "TRADING", "charInstIds": [-1, -1, -1], "completeConstructTime": 1566267502}, "slot_15": {"level": 3, "state": 2, "roomId": "MANUFACTURE", "charInstIds": [35, 69, 54], "completeConstructTime": 1563645191}, "slot_16": {"level": 3, "state": 2, "roomId": "POWER", "charInstIds": [42], "completeConstructTime": 1563750598}, "slot_20": {"level": 5, "state": 2, "roomId": "DORMITORY", "charInstIds": [-1, -1, -1, -1, -1], "completeConstructTime": 1571018368}, "slot_23": {"level": 3, "state": 2, "roomId": "HIRE", "charInstIds": [98], "completeConstructTime": 1563632902}, "slot_24": {"level": 3, "state": 2, "roomId": "TRADING", "charInstIds": [-1, -1, -1], "completeConstructTime": 1563643838}, "slot_25": {"level": 3, "state": 2, "roomId": "MANUFACTURE", "charInstIds": [142, 107, 134], "completeConstructTime": 1563642506}, "slot_26": {"level": 3, "state": 2, "roomId": "POWER", "charInstIds": [20], "completeConstructTime": 1563632596}, "slot_28": {"level": 5, "state": 2, "roomId": "DORMITORY", "charInstIds": [-1, -1, -1, -1, -1], "completeConstructTime": 1577615160}, "slot_32": {"level": 3, "state": 2, "roomId": "WORKSHOP", "charInstIds": [167], "completeConstructTime": 1563579910}, "slot_34": {"level": 5, "state": 2, "roomId": "CONTROL", "charInstIds": [-1, -1, -1, -1, -1], "completeConstructTime": 1563781172}, "slot_36": {"level": 3, "state": 2, "roomId": "MEETING", "charInstIds": [-1, -1], "completeConstructTime": 1563632860}}, "diyPresetSolutions": {}}, "carousel": {"furnitureShop": {"goods": {}, "groups": {}}},

注意符号，如果复制多了或者少了符号N++或者visual studio code会提示你有错误，自己用txt的话自己排查自己复制粘贴的问题吧。
另外一个就是部分关卡的掉落和官服掉落掉率不一致，比如我最近在刷s2-5和s2-9，里面源岩和双酮的掉落明显达不到期望，修改位置在明日方舟一键端/LocalArknights/data/excel里的stage_table.json，打开文件里搜S2-5和S2-9，这里以S2-5为例，首先我们搜索S2-5，找到位置，然后往下翻，找到S2-5下面的displayDetailRewards，如下



通过物品表查询我们发现id 30011指的是源岩，occPercent为0表示固定掉落，为1表示大概率掉落，4为小概率掉落，2和3应该介于之间，dropType含义还没查到所以不建议瞎改，而我这里为了达到官方的掉落期望，改成了这样



固定掉三个，小概率掉一个，stage_table.json的修改不需要关服务器，即改即生效，所以说官方暗改概率什么的完全没任何问题，以后有人给你说官方开着服务器暗改不了概率什么的你就得小心了，这人7成是托3成是蠢。
基建能不进人绝对不要进人，基建能不进人绝对不要进人，基建能不进人绝对不要进人，人进了设施会出现各种莫名其妙的bug