首先，https://survivingmaps.com/ 這個(gè)網(wǎng)站的數(shù)據(jù)因?yàn)榘姹靖露?，所以需要新的?shù)據(jù)以及自己實(shí)現(xiàn)這個(gè)網(wǎng)站的功能

地圖坐標(biāo)與突破科技對(duì)應(yīng)表來自https://forum.paradoxplaza.com/forum/threads/surviving-mars-maps-find-your-perfect-landinglocation.1107750/page-2#post-25465232

我做了個(gè)備份

MapData Tito GP Mar 15 2021.7z?有Green Planet這個(gè)DLC的數(shù)據(jù)

鏈接: https://pan.baidu.com/s/1PevLmKNZ3X-cm2x85Myqlw 提取碼: q9h7

MapData Tito Not GP Mar 15 2021.7z?沒有Green Planet這個(gè)DLC的數(shù)據(jù)

鏈接: https://pan.baidu.com/s/16CxajdLSiQpx7rzgupw4vw 提取碼: ja5f

其作者為ChoGGi (https://github.com/ChoGGi/SurvivingMars_CheatMods)，他的github里有一些mod和工具，例如View Colony Map就是地圖和突破科技的預(yù)覽Mod，其中ChoGGi's Library\Code\CommonFunctions.lua的RetMapBreakthroughs部分為突破科技的生成，如果將來這個(gè)數(shù)據(jù)作者不再更新，就需研究這部分來自己生成新的數(shù)據(jù)了。

SurvivingMars_CheatMods-16.6.zip

鏈接: https://pan.baidu.com/s/1fCm9acJiiFP_Ic89uya7tw 提取碼: txja

更多關(guān)于View Colony Map和RetMapBreakthroughs部分有部分未開啟的部分，可以再多生成3個(gè)突破科技用以模擬歐米伽望遠(yuǎn)鏡的效果，可以通過修改mod實(shí)現(xiàn)

但是之前的數(shù)據(jù)表格里并沒有這部分，無法進(jìn)行篩選，只能作為篩選后的補(bǔ)充，而且通過這個(gè)mod可以知道這個(gè)數(shù)據(jù)表格的前4個(gè)突破科技是行星異象，第5個(gè)開始是地圖掃描獲得，并且是按順序獲得的，也就是如果地圖上能掃描9個(gè)突破科技，那么會(huì)是第5至13個(gè)

其中，還包含了一個(gè)Map Images Pack，其中顯示了對(duì)應(yīng)的地圖名字與地形

有了這些Mod和信息，還不能篩選想要的地圖，所以需要一些別的工具和一點(diǎn)點(diǎn)SQL知識(shí)

我們需要的工具是DB Browser for SQLite，可以從 https://sqlitebrowser.org/dl/ 下載。這個(gè)是一個(gè)可以創(chuàng)建、編輯基于文件的關(guān)系數(shù)據(jù)庫(kù)的工具，無需安裝，解壓即用。

首先打開DB Browser for SQLite，新建數(shù)據(jù)庫(kù)。

關(guān)閉這個(gè)窗口

導(dǎo)入MapData Tito Breakthroughs GP.csv

首先，這個(gè)例子

SELECT *

FROM "MapData Tito Breakthroughs GP"

WHERE MapName = "BlankBig_01"

AND ( Breakthrough1 = "The Positronic Brain" OR Breakthrough2 = "The Positronic Brain" OR Breakthrough3 = "The Positronic Brain" OR Breakthrough4 = "The Positronic Brain" OR Breakthrough5 = "The Positronic Brain" OR Breakthrough6 = "The Positronic Brain" OR Breakthrough7 = "The Positronic Brain" OR Breakthrough8 = "The Positronic Brain" OR Breakthrough9 = "The Positronic Brain" OR Breakthrough10 = "The Positronic Brain" OR Breakthrough11 = "The Positronic Brain" OR Breakthrough12 = "The Positronic Brain" OR Breakthrough13 = "The Positronic Brain" OR Breakthrough14 = "The Positronic Brain" OR Breakthrough15 = "The Positronic Brain" OR Breakthrough16 = "The Positronic Brain" OR Breakthrough17 = "The Positronic Brain" )

AND ( Breakthrough1 = "Service Bots" OR Breakthrough2 = "Service Bots" OR Breakthrough3 = "Service Bots" OR Breakthrough4 = "Service Bots" OR Breakthrough5 = "Service Bots" OR Breakthrough6 = "Service Bots" OR Breakthrough7 = "Service Bots" OR Breakthrough8 = "Service Bots" OR Breakthrough9 = "Service Bots" OR Breakthrough10 = "Service Bots" OR Breakthrough11 = "Service Bots" OR Breakthrough12 = "Service Bots" OR Breakthrough13 = "Service Bots" OR Breakthrough14 = "Service Bots" OR Breakthrough15 = "Service Bots" OR Breakthrough16 = "Service Bots" OR Breakthrough17 = "Service Bots" )

AND ( Breakthrough1 = "Superconducting Computing" OR Breakthrough2 = "Superconducting Computing" OR Breakthrough3 = "Superconducting Computing" OR Breakthrough4 = "Superconducting Computing" OR Breakthrough5 = "Superconducting Computing" OR Breakthrough6 = "Superconducting Computing" OR Breakthrough7 = "Superconducting Computing" OR Breakthrough8 = "Superconducting Computing" OR Breakthrough9 = "Superconducting Computing" OR Breakthrough10 = "Superconducting Computing" OR Breakthrough11 = "Superconducting Computing" OR Breakthrough12 = "Superconducting Computing" OR Breakthrough13 = "Superconducting Computing" OR Breakthrough14 = "Superconducting Computing" OR Breakthrough15 = "Superconducting Computing" OR Breakthrough16 = "Superconducting Computing" OR Breakthrough17 = "Superconducting Computing" )

AND ( Breakthrough1 = "Nano Refinement" OR Breakthrough2 = "Nano Refinement" OR Breakthrough3 = "Nano Refinement" OR Breakthrough4 = "Nano Refinement" OR Breakthrough5 = "Nano Refinement" OR Breakthrough6 = "Nano Refinement" OR Breakthrough7 = "Nano Refinement" OR Breakthrough8 = "Nano Refinement" OR Breakthrough9 = "Nano Refinement" OR Breakthrough10 = "Nano Refinement" OR Breakthrough11 = "Nano Refinement" OR Breakthrough12 = "Nano Refinement" OR Breakthrough13 = "Nano Refinement" OR Breakthrough14 = "Nano Refinement" OR Breakthrough15 = "Nano Refinement" OR Breakthrough16 = "Nano Refinement" OR Breakthrough17 = "Nano Refinement" )

AND ( Breakthrough1 = "Eternal Fusion" OR Breakthrough2 = "Eternal Fusion" OR Breakthrough3 = "Eternal Fusion" OR Breakthrough4 = "Eternal Fusion" OR Breakthrough5 = "Eternal Fusion" OR Breakthrough6 = "Eternal Fusion" OR Breakthrough7 = "Eternal Fusion" OR Breakthrough8 = "Eternal Fusion" OR Breakthrough9 = "Eternal Fusion" OR Breakthrough10 = "Eternal Fusion" OR Breakthrough11 = "Eternal Fusion" OR Breakthrough12 = "Eternal Fusion" OR Breakthrough13 = "Eternal Fusion" OR Breakthrough14 = "Eternal Fusion" OR Breakthrough15 = "Eternal Fusion" OR Breakthrough16 = "Eternal Fusion" OR Breakthrough17 = "Eternal Fusion" )

希望地圖是BlankBig_01，并且有“正子腦 The Positronic Brain”、“服務(wù)型機(jī)器人 Service Bots”、“超導(dǎo)計(jì)算 Superconducting Computing”、“納米提純 Nano Refinement”、“無限核融合 Eternal Fusion”

我們就得到了3個(gè)篩選結(jié)果

篩選地圖是MapName = "BlankBig_01"，如果不需要篩選地圖，那么就刪除這些以及之后緊連的AND，如果需要篩選多種地圖，那么就用括號(hào)括起來并在括號(hào)內(nèi)用OR相連?( MapName = "BlankBig_01" OR?MapName = "BlankBig_02" )

( Breakthrough1 = "" OR Breakthrough2 = "" OR Breakthrough3 = "" OR Breakthrough4 = "" OR Breakthrough5 = "" OR Breakthrough6 = "" OR Breakthrough7 = "" OR Breakthrough8 = "" OR Breakthrough9 = "" OR Breakthrough10 = "" OR Breakthrough11 = "" OR Breakthrough12 = "" OR Breakthrough13 = "" OR Breakthrough14 = "" OR Breakthrough15 = "" OR Breakthrough16 = "" OR Breakthrough17 = "" )

這部分就是從表內(nèi)篩選特定突破科技，因?yàn)槟稠?xiàng)突破科技可能出現(xiàn)于17列中的任何一列

我們已經(jīng)知道行星異象位于1-4列，如果我們不想某個(gè)科技太晚出現(xiàn)，那么我們可以刪除3、4列，我們還知道第5列開始就是地圖掃描的部分，依次出現(xiàn)，如果我們希望某些科技盡早出現(xiàn)，那么就保留前第5列開始的6～9列，即5至10列～5至13列。

(?Breakthrough1 = "" OR?Breakthrough2 = ""?OR Breakthrough5 = "" OR Breakthrough6 = "" OR Breakthrough7 = "" OR Breakthrough8 = "" OR Breakthrough9 = "" OR Breakthrough10 = "" OR Breakthrough11 = "" OR Breakthrough12 = "" OR Breakthrough13 = "" )

如果希望早早（第一個(gè)行星異象、前5個(gè)地圖掃描）就有“挖掘站人工智能 Extractor AI”和“納米提純?Nano Refinement”以跳過建設(shè)開礦穹頂?shù)倪^程并且不再依賴奇跡，然后希望在中期（前兩個(gè)行星異象、前10個(gè)地圖掃描）擁有“正子腦?The Positronic Brain”，也如挖礦一樣一勞永逸地建立工廠穹頂，然后還希望之后（前三個(gè)行星異象、前10個(gè)地圖掃描）擁有“無限核融合 Eternal Fusion”以支撐更大規(guī)模的擴(kuò)張，就可以寫下如下的SQL

SELECT *

FROM "MapData Tito Breakthroughs GP"

WHERE MapName = "BlankBig_01"

AND ( Breakthrough1 = "Extractor AI" OR Breakthrough5 = "Extractor AI" OR Breakthrough6 = "Extractor AI" OR Breakthrough7 = "Extractor AI" OR Breakthrough8 = "Extractor AI" OR Breakthrough9 = "Extractor AI" )

AND ( Breakthrough1 = "Nano Refinement" OR Breakthrough5 = "Nano Refinement" OR Breakthrough6 = "Nano Refinement" OR Breakthrough7 = "Nano Refinement" OR Breakthrough8 = "Nano Refinement" OR Breakthrough9 = "Nano Refinement" )

AND ( Breakthrough1 = "The Positronic Brain" OR Breakthrough2 = "The Positronic Brain" OR Breakthrough5 = "The Positronic Brain" OR Breakthrough6 = "The Positronic Brain" OR Breakthrough7 = "The Positronic Brain" OR Breakthrough8 = "The Positronic Brain" OR Breakthrough9 = "The Positronic Brain" OR Breakthrough10 = "The Positronic Brain" OR Breakthrough11 = "The Positronic Brain" OR Breakthrough12 = "The Positronic Brain" OR Breakthrough13 = "The Positronic Brain" OR Breakthrough14 = "The Positronic Brain" )

AND ( Breakthrough1 = "Eternal Fusion" OR Breakthrough2 = "Eternal Fusion" OR Breakthrough3 = "Eternal Fusion" OR Breakthrough5 = "Eternal Fusion" OR Breakthrough6 = "Eternal Fusion" OR Breakthrough7 = "Eternal Fusion" OR Breakthrough8 = "Eternal Fusion" OR Breakthrough9 = "Eternal Fusion" OR Breakthrough10 = "Eternal Fusion" OR Breakthrough11 = "Eternal Fusion" OR Breakthrough12 = "Eternal Fusion" OR Breakthrough13 = "Eternal Fusion" OR Breakthrough14 = "Eternal Fusion" )

我們可以得到結(jié)果

然后我們檢查這倆結(jié)果的其他突破科技

最后選擇自己最喜歡的地圖！