Author Topic: Spacemaster help  (Read 2819 times)

0 Members and 1 Guest are viewing this topic.

Offline the obelisk (OP)

  • Sub-Lieutenant
  • ******
  • t
  • Posts: 109
  • Thanked: 11 times
Spacemaster help
« on: April 06, 2022, 02:40:24 PM »
Is it possible to use spacemaster mode to set jump points between specific systems, instead of just creating jump points to random systems, and if so, how do I do that?
 

Offline nuclearslurpee

  • Admiral of the Fleet
  • ***********
  • Posts: 3009
  • Thanked: 2265 times
  • Radioactive frozen beverage.
Re: Spacemaster help
« Reply #1 on: April 06, 2022, 03:28:46 PM »
No. To do this you would need to edit the database (table FCT_JumpPoint, I think) prior to exploring the JPs you wish to connect. You can use SM mode to create the needed JPs in each system if necessary.
 

Offline Garfunkel

  • Registered
  • Admiral of the Fleet
  • ***********
  • Posts: 2801
  • Thanked: 1058 times
Re: Spacemaster help
« Reply #2 on: April 06, 2022, 10:34:55 PM »
In case it's not about existing systems, you can use SM to modify the new system that JP leads to in any way you want as you can change the star and the planets, as well as add/remove them.

But if it's about existing systems that you wish to connect, then your only option is to go spelunking in the DB.
 

Offline skoormit

  • Rear Admiral
  • **********
  • Posts: 820
  • Thanked: 329 times
Re: Spacemaster help
« Reply #3 on: April 07, 2022, 10:04:04 AM »
But if it's about existing systems that you wish to connect, then your only option is to go spelunking in the DB.

Here's one way to thusly spelunk.

If you are familiar with DB editing:
The attached query returns the IDs of the known unexplored JPs in two systems.
For each JP in your desired pair, change FCT_JumpPoint.WPLink to the ID of the other JP.




If you aren't familiar with DB editing:

The following assumes your race has already found at least one unexplored JP in each of the two systems you wish to connect.
(You can create JPs in the System View Window with SM mode enabled. Then click the "Full Grav Survey" button to locate the JP.)

0) Save your game. Optionally, make a backup of Aurora.db.
1) Open Aurora.db with your SQLite utility of choice (I use DB Browser for SQLite; I will include details for executing the following steps using this).
2) Open the attached query ("Execute SQL" tab -> "Open SQL file" button).
3) Replace all four placeholder texts with appropriate values.
4) Execute the query (hit F5).
5) You should see one row of results for each possible pairing between unexplored jump points that your race has found in System 1 and System 2.
    If you see no results, then one or more of the values you entered was not found in the database, or one or both systems do not contain unexplored jump points that your race has found.
    Double check your spelling and your capitalization, make sure you don't have an extraneous space character, etc.

   
    The first four columns are the values you entered in step 3.
    The next column is the ID number of an unexplored jump point that your race has found in System 1.
    The next two columns are the distance and bearing of the jump point. (This should help you identify the desired jump point when there are multiple to choose from.)
    The final three columns are the ID number, distance, and bearing of an unexplored jump point that your race has found in System 2.

   
6) Access the FCT_JumpPoint table in edit mode (on the "Browse Data" tab, select FCT_JumpPoint from the dropdown).
7) Filter the table by WarpPointID to show the JP you want to use in System 1 (in the Filter box directly underneath the WarpPointID column header, enter the ID number of the JP you want to use).
8) You should now see only one row. Change the value in the WPLink column from 0 to the WarpPointID of the JP you want to connect to in System 2 (click the 0, type the new value, hit enter).
9) Now repeat steps 7 and 8 for the reverse order of WarpPointIDs (filter by the WarpPointID for the JP in System 2, and change the 0 in the WPLink column to the WarpPointID for the JP in System 1).
10) Commit your change to the database (click the "Write Changes" button in the top toolbar).

Your JPs are now connected.
Note that your race will not know they are connected until they explore one of the JPs (or you can use SM mode to explore either end).


As always, corrections or suggestions for the above or the attached are welcomed.
 
The following users thanked this post: Protomolecule, Vastrat