Mods in a playset

[sen4mi]

I decided I had reason to want to be able to extract the mod directories for a stellaris playset, and it occurred to me that someone else might want to be able to do this. So:

 

Prerequisite: the sqlite command line tools which you can download from https://sqlite.org/download.html

 

Once you have this, you can write a script which runs sqlite3.exe with a command line argument of "%USERPROFILE%/Documents/Paradox Interactive/Stellaris/launcher-v2.sqlite" and redirects standard input from a script file which looks something like this:

 

.bail on
.headers on
.mode csv
SELECT mods.source, mods.dirPath, mods.displayName
        FROM mods
                INNER JOIN playsets_mods
                        ON mods.id=playsets_mods.modId
                INNER JOIN playsets
                        ON playsets.id=playsets_mods.playsetId
        WHERE playsets.name='Elves'
        ORDER BY playsets_mods.position;
.exit
 

And then you can redirect standard output to a csv file (which you can load up in google docs or a spreadsheet program, for example).

 

Here, the playset I am getting mods for is named Elves, but you can change that to be whichever playset you want.

 

Also, you might want to remove the .headers on line, since that's just column labels.

 

Also, if you want only the directories, you might change the select line to say SELECT mods.dirPath and if you only have one column you might want to remove the line that says .mode csv 

 

But, anyways... hopefully I am using vocabulary which makes sense to people... If I goofed something or was confusing, let me know.

 

(Also, if you are the sort of person who installs cygwin on your windows box, I have a variation on this where I find all the files in active mods which contain a certain event type, and another one where I back up and modify all those files so that they would have visible windows so I could see which ones were being active -- if that's the sort of thing which interests somebody, let me know and I can post the details.)