大家新年好！我是新，先秀一下新船，
接著向大家介绍全自动提船代码，由於原来的提船贴已找不到，为了方便大家把辛苦的劳动成果保存和交流，经过了无数不眠不休，焚膏继晷，风尘仆仆的日日夜夜，我终于弄出了这个代码，与大家分享⋯

先来个免责声明, 一切风险和责任由使用者承担, USE AT YOUR OWN RISK!
哈哈哈!
图片来自：全小號的百度相册

现在开始提船, 首先你要有一台windows的pc, 然后sqlite.org那里下载command-line shell,
接着把你的存档导出来, 跟着建一个新文件夹, 把存档, sqlite3.exe, 提船代码都放在这个新文件夹里, 一切就绪.
图片来自：全小號的百度相册

先介绍一个手动单船的提船代码, 把下面的代码复制notepad上, 把.output 文件名.plist 的[文件名]改为你要存的名字, 把WHERE zbsmanagedship.ztitle = "船名" 的[船名]改为你的船的名字,
然后sqlite3.exe, 把改好的代码复制, 贴sqlite3的运行窗口里, 窗口没自动关闭就按一下enter键,
你就会得到你的plist文件了, 注意你的船名不要重复!
.open battleship.sqlite
.output 文件名.plist
select
"
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE plist PUBLIC '-//Apple//DTD PLIST 1.0//EN' 'http://www.apple.com/DTDs/PropertyList-1.0.dtd'>
<plist version='1.0'>
<dict>
<key>title</key>
<string>护卫舰spy</string>
<key>unitDictionaries</key>
<array>
";
SELECT
"<dict><key>color</key><integer>"||zbsmanagedunit.zcolor||"</integer><key>prototypeName</key><string>"||zbsprototypeunit.zname||"</string><key>quaternion</key><integer>"||zbsmanagedunit.zquaternion||"</integer><key>translationX</key><real>"||zbsmanagedunit.ztranslationx||"</real><key>translationY</key><real>"||zbsmanagedunit.ztranslationy||"</real><key>translationZ</key><real>"||zbsmanagedunit.ztranslationz||"</real></dict>"
FROM zbsmanagedunit
inner join
zbsprototypeunit
on zbsprototypeunit.z_pk = zbsmanagedunit.zprototype
inner join
zbsmanagedship
on zbsmanagedship.z_pk = zbsmanagedunit.zship
WHERE zbsmanagedship.ztitle = "船名"
order by zbsprototypeunit.zname
;
select
"
</array>
</dict>
</plist>
";
.exit
图片来自：全小號的百度相册

接下来就是全自动提船了, 一次把存档里的船全都提出来, 如果你的船名里有特别字符, 可能会中断提船, 请检查一下你的船名.
把下面的代码复制到notepad里, 存为.bat文件, 例如PullMyShips.bat, 然后把存档, sqlite3.exe和这个bat文件放在一个文件夹里, 执行这个bat文件, 你就会得到一堆plist文件,以你的船名来命名的,
下面是代码:
echo .open battleship.sqlite > ships.sql
echo .output shipslist.txt >> ships.sql
echo select z_pk, replace(ztitle,^" ^", ^"^") from zbsmanagedship where ztype = ""; >> ships.sql
echo .exit >> ships.sql
sqlite3 < ships.sql
for /F "tokens=1,2 delims=|" %%j in (shipslist.txt) do (
echo .open battleship.sqlite > pullaship.sql
echo .output %%k.plist >> pullaship.sql
echo. >> pullaship.sql
echo select >> pullaship.sql
echo ^" >> pullaship.sql
echo ^<?xml version='1.0' encoding='UTF-8'?^> >> pullaship.sql
echo ^<!DOCTYPE plist PUBLIC '-^/^/Apple^/^/DTD PLIST 1.0^/^/EN' 'http:^/^/www.apple.com^/DTDs^/PropertyList-1.0.dtd'^> >> pullaship.sql
echo ^<plist version='1.0'^> >> pullaship.sql
echo ^<dict^> >> pullaship.sql
echo ^<key^>title^</key^> >> pullaship.sql
echo ^<string^>护卫舰spy^</string^> >> pullaship.sql
echo ^<key^>unitDictionaries^</key^> >> pullaship.sql
echo ^<array^> >> pullaship.sql
echo ^"; >> pullaship.sql
echo. >> pullaship.sql
echo SELECT >> pullaship.sql
echo ^"^<dict^>^<key^>color^</key^>^<integer^>^"^|^|zbsmanagedunit.zcolor^|^|^"^</integer^>^<key^>prototypeName^</key^>^<string^>^"^|^| >> pullaship.sqlecho zbsprototypeunit.zname^|^|^"^</string^>^<key^>quaternion^</key^>^<integer^>^"^|^| >> pullaship.sqlecho zbsmanagedunit.zquaternion^|^|^"^</integer^>^<key^>translationX^</key^>^<real^>^"^|^| >> pullaship.sqlecho zbsmanagedunit.ztranslationx^|^|^"^</real^>^<key^>translationY^</key^>^<real^>^"^|^| >> pullaship.sqlecho zbsmanagedunit.ztranslationy^|^|^"^</real^>^<key^>translationZ^</key^>^<real^>^"^|^|zbsmanagedunit.ztranslationz^|^|^"^</real^>^</dict^>^" >> pullaship.sql
echo FROM zbsmanagedunit >> pullaship.sql
echo inner join >> pullaship.sql
echo zbsprototypeunit >> pullaship.sql
echo on zbsprototypeunit.z_pk = zbsmanagedunit.zprototype >> pullaship.sql
echo WHERE zbsmanagedunit.zship = %%j >> pullaship.sql
echo order by zbsprototypeunit.zname >> pullaship.sql
echo ; >> pullaship.sql
echo. >> pullaship.sql
echo select >> pullaship.sql
echo ^" >> pullaship.sql
echo ^</array^> >> pullaship.sql
echo ^</dict^> >> pullaship.sql
echo ^</plist^> >> pullaship.sql
echo ^"; >> pullaship.sql
echo. >> pullaship.sql
echo .exit >> pullaship.sql
sqlite3 < pullaship.sql
)
记着, Use at your onw Risk!
图片来自：全小號的百度相册

谁在删楼, 代码楼被全删了...

@ 毁灭者_Decade, @毁灭者_Decade

一点改进， 在本提船代码最前面加上一行： chcp 65001
提出来的plist文件就是utf-8, 可直接用。