Star Traders: Frontiers v2.3.29 (Updated: 4/Aug/18)

[grimmjow2000]

Anyone got an updated table for this game?

How to use this cheat table?

1. Install Cheat Engine
2. Double-click the .CT file in order to open it.
3. Click the PC icon in Cheat Engine in order to select the game process.
4. Keep the list.
5. Activate the trainer options by checking boxes or setting values from 0 to 1

[BipBop]

I would like to know if there is a way to edit ships, in particular the number and type of components
that can be mounted in a hull.

Have you found a solution to this? I would be interested in a speed improvement.

[Webraven]

Update GameContact set influenceScore = 1 where _id = 2;
In all my games that one spams me with bounty hunters. my personal payback revenge

[BipBop]

!!!NOTICE!!!

As of update #117 the way time is kept has changed.

Prior to this update, you could have found time by looking for the 4 byte value equivalent to your number of turns.

Now, for some reason, the value for turns is offset by 35. meaning if you hover your cursor over the time displayed at the top of the screen and it displays 100 "turns", the actual value is going to be 100 + 35 = 135.

Fun things you can do:
Stop time
Reverse time

Side effects,
Cooling down abilities will not cool down until the turn cooldown should have been over.

Note: Still useful for things like upgrading ships, Where you don't necessarily need skills to trigger.

Man man man man! You made my day! This is the absolute cheat needed! I hate how I used to miss story missions, now I can both do stories and the game! Thank you!

[theseko]

FYI: See [Link] for savegame decryptor and encryptor. Now you can decrypt saved game, tweak it (using sqlite client or binary editor), encrypt again and load the game.

[doobiedoo]

I'm not familiar with SQL (and this is specifically SQLite, yes?) and was hoping someone could help me as I try to add in Talents via the provided Query Editor.

The command:

Code: Select all

insert into gametalent values (1,28,1,-1000,0,0,0);

...isn't working. I *think* this might have something to do with the GameTalent table being locked, but I honestly have no idea. I've tried also:

Code: Select all

unlock table gametalent;
insert into gametalent values (1,28,1,-1000,0,0,0);

...but that also doesn't do anything, and maybe SQLite doesn't even have that command.

Any ideas how to just directly INSERT INTO the gametalent table?

[doobiedoo]

Figured it out. The gametalent table locks, for most of the time. To get it to run, I ended up going to the Talent screen, Retraining, selecting a Talent, and then applying this basic script via the SQL Query via Cheat Engine:

insert into gametalent (gamecharacterid,talenttype,talentlevel,talentusedturn,ext1,ext2,ext3) values (4,28,1,-1000,0,0,0);

...which is overly verbose but whatever, anyway after applying that Query (it's actually a list of these generated by a spreadsheet I have), you ESC out of the Talent screen and Crew screen. For whatever reason, using the BACK button or any other method (clicking on something else, for example) will disregard these changes!

[dragoduval]

Necropost, but a lot of the sql command give me the "Result set not found. No results to display." in the log, and does nothing. Anybdy now why ?

Edit : Nevermind, some actually showed that message and worked after saving and reloading.

[CaesarCzech]

could i ask for update ?

[Aerandria]

FYI: See [Link] for savegame decryptor and encryptor. Now you can decrypt saved game, tweak it (using sqlite client or binary editor), encrypt again and load the game.

I was looking at getting this working, and a software engineer friend volunteered to assist. My impression as a non-programmer is that the dependency here (CryptoPlus) was written for python 2.x and won't even work with any version of Python from the past several years, so I watched in mounting horror and amusement as my buddy took it on himself to make a standalone version.

[Link]

Also, I've seen a lot of folks in this thread using sql that require executing many times and I just wanted to point out that you can simply use a batch command instead. Whether that's more or less effort for a given task might depend, I guess. Here's a batch command for giving a bunch of traits to 4 specific characters, for example:

Code: Select all

insert into gamecharactertrait(gamecharacterid,traitid,characterknows,optionid) values(1,1,1,0),(1,2,1,0),(1,3,1,0),(1,5,1,0),(1,6,1,0),(1,8,1,0),(1,13,1,0),(1,14,1,0),(1,15,1,0),(1,16,1,0),(1,19,1,0),(1,20,1,0),(1,21,1,0),(1,24,1,0),(1,25,1,0),(1,26,1,0),(1,27,1,0),(1,32,1,0),(1,34,1,0),(1,35,1,0),(1,37,1,0),(1,38,1,0),(1,39,1,0),(1,40,1,0),(1,41,1,0),(1,43,1,0),(1,44,1,0),(1,46,1,0),(1,48,1,0),(1,52,1,0),(1,53,1,0),(1,54,1,0),(1,55,1,0),(1,57,1,0),(1,58,1,0),(1,60,1,0),(1,61,1,0),(1,63,1,0),(1,66,1,0),(1,68,1,0),(1,69,1,0),(1,70,1,0),(1,71,1,0),(1,72,1,0),(1,73,1,0),(1,74,1,0),(1,76,1,0),(1,83,1,0),(1,88,1,0),(1,101,1,0),(1,102,1,0),(1,104,1,0),(1,106,1,0),(1,109,1,0),(1,149,1,0),(1,151,1,0),(1,165,1,0),(1,166,1,0),(1,167,1,0),(1,168,1,0),(1,169,1,0),(1,170,1,0),(1,171,1,0),(1,172,1,0),(1,173,1,0),(1,174,1,0),(1,175,1,0),(1,176,1,0),(1,177,1,0),(1,179,1,0),(1,183,1,0),(1,184,1,0),(1,185,1,0),(1,186,1,0),(1,187,1,0),(1,188,1,0),(1,189,1,0),(1,190,1,0),(1,191,1,0),(1,192,1,0),(1,193,1,0),(1,197,1,0),(1,198,1,0),(1,199,1,0),(1,203,1,0),(1,204,1,0),(1,200,1,0),(1,209,1,0),(1,211,1,0),(1,212,1,0),(1,213,1,0),(1,215,1,0),(1,218,1,0),(1,219,1,0),(3,1,1,0),(3,2,1,0),(3,3,1,0),(3,5,1,0),(3,6,1,0),(3,8,1,0),(3,13,1,0),(3,14,1,0),(3,15,1,0),(3,16,1,0),(3,19,1,0),(3,20,1,0),(3,21,1,0),(3,24,1,0),(3,25,1,0),(3,26,1,0),(3,27,1,0),(3,32,1,0),(3,34,1,0),(3,35,1,0),(3,37,1,0),(3,38,1,0),(3,39,1,0),(3,40,1,0),(3,41,1,0),(3,43,1,0),(3,44,1,0),(3,46,1,0),(3,48,1,0),(3,52,1,0),(3,53,1,0),(3,54,1,0),(3,55,1,0),(3,57,1,0),(3,58,1,0),(3,60,1,0),(3,61,1,0),(3,63,1,0),(3,66,1,0),(3,68,1,0),(3,69,1,0),(3,70,1,0),(3,71,1,0),(3,72,1,0),(3,73,1,0),(3,74,1,0),(3,76,1,0),(3,83,1,0),(3,88,1,0),(3,101,1,0),(3,102,1,0),(3,104,1,0),(3,106,1,0),(3,109,1,0),(3,149,1,0),(3,151,1,0),(3,165,1,0),(3,166,1,0),(3,167,1,0),(3,168,1,0),(3,169,1,0),(3,170,1,0),(3,171,1,0),(3,172,1,0),(3,173,1,0),(3,174,1,0),(3,175,1,0),(3,176,1,0),(3,177,1,0),(3,179,1,0),(3,183,1,0),(3,184,1,0),(3,185,1,0),(3,186,1,0),(3,187,1,0),(3,188,1,0),(3,189,1,0),(3,190,1,0),(3,191,1,0),(3,192,1,0),(3,193,1,0),(3,197,1,0),(3,198,1,0),(3,199,1,0),(3,203,1,0),(3,204,1,0),(3,200,1,0),(3,209,1,0),(3,211,1,0),(3,212,1,0),(3,213,1,0),(3,215,1,0),(3,218,1,0),(3,219,1,0),(4,1,1,0),(4,2,1,0),(4,3,1,0),(4,5,1,0),(4,6,1,0),(4,8,1,0),(4,13,1,0),(4,14,1,0),(4,15,1,0),(4,16,1,0),(4,19,1,0),(4,20,1,0),(4,21,1,0),(4,24,1,0),(4,25,1,0),(4,26,1,0),(4,27,1,0),(4,32,1,0),(4,34,1,0),(4,35,1,0),(4,37,1,0),(4,38,1,0),(4,39,1,0),(4,40,1,0),(4,41,1,0),(4,43,1,0),(4,44,1,0),(4,46,1,0),(4,48,1,0),(4,52,1,0),(4,53,1,0),(4,54,1,0),(4,55,1,0),(4,57,1,0),(4,58,1,0),(4,60,1,0),(4,61,1,0),(4,63,1,0),(4,66,1,0),(4,68,1,0),(4,69,1,0),(4,70,1,0),(4,71,1,0),(4,72,1,0),(4,73,1,0),(4,74,1,0),(4,76,1,0),(4,83,1,0),(4,88,1,0),(4,101,1,0),(4,102,1,0),(4,104,1,0),(4,106,1,0),(4,109,1,0),(4,149,1,0),(4,151,1,0),(4,165,1,0),(4,166,1,0),(4,167,1,0),(4,168,1,0),(4,169,1,0),(4,170,1,0),(4,171,1,0),(4,172,1,0),(4,173,1,0),(4,174,1,0),(4,175,1,0),(4,176,1,0),(4,177,1,0),(4,179,1,0),(4,183,1,0),(4,184,1,0),(4,185,1,0),(4,186,1,0),(4,187,1,0),(4,188,1,0),(4,189,1,0),(4,190,1,0),(4,191,1,0),(4,192,1,0),(4,193,1,0),(4,197,1,0),(4,198,1,0),(4,199,1,0),(4,203,1,0),(4,204,1,0),(4,200,1,0),(4,209,1,0),(4,211,1,0),(4,212,1,0),(4,213,1,0),(4,215,1,0),(4,218,1,0),(4,219,1,0),(12,1,1,0),(12,2,1,0),(12,3,1,0),(12,5,1,0),(12,6,1,0),(12,8,1,0),(12,13,1,0),(12,14,1,0),(12,15,1,0),(12,16,1,0),(12,19,1,0),(12,20,1,0),(12,21,1,0),(12,24,1,0),(12,25,1,0),(12,26,1,0),(12,27,1,0),(12,32,1,0),(12,34,1,0),(12,35,1,0),(12,37,1,0),(12,38,1,0),(12,39,1,0),(12,40,1,0),(12,41,1,0),(12,43,1,0),(12,44,1,0),(12,46,1,0),(12,48,1,0),(12,52,1,0),(12,53,1,0),(12,54,1,0),(12,55,1,0),(12,57,1,0),(12,58,1,0),(12,60,1,0),(12,61,1,0),(12,63,1,0),(12,66,1,0),(12,68,1,0),(12,69,1,0),(12,70,1,0),(12,71,1,0),(12,72,1,0),(12,73,1,0),(12,74,1,0),(12,76,1,0),(12,83,1,0),(12,88,1,0),(12,101,1,0),(12,102,1,0),(12,104,1,0),(12,106,1,0),(12,109,1,0),(12,149,1,0),(12,151,1,0),(12,165,1,0),(12,166,1,0),(12,167,1,0),(12,168,1,0),(12,169,1,0),(12,170,1,0),(12,171,1,0),(12,172,1,0),(12,173,1,0),(12,174,1,0),(12,175,1,0),(12,176,1,0),(12,177,1,0),(12,179,1,0),(12,183,1,0),(12,184,1,0),(12,185,1,0),(12,186,1,0),(12,187,1,0),(12,188,1,0),(12,189,1,0),(12,190,1,0),(12,191,1,0),(12,192,1,0),(12,193,1,0),(12,197,1,0),(12,198,1,0),(12,199,1,0),(12,203,1,0),(12,204,1,0),(12,200,1,0),(12,209,1,0),(12,211,1,0),(12,212,1,0),(12,213,1,0),(12,215,1,0),(12,218,1,0),(12,219,1,0);

You can also straight up mod things, although you will have to execute your changes every time you load the game edit, turns out changes like this are permanent??? what the fuck lol, I'm so used to thinking of anything done with cheat engine as being entirely in memory that I was shocked to realize this is altering the game's encrypted database:

Code: Select all

update ShipComponent set holdsCargo=50, holdsGuest=2, mass=-300 where _id=305

Just some things I haven't seen people talking about much.

[Okies]

Is there a way to cut down upgrade time?

[Contralto]

Is there a way to cut down upgrade time?

Yeah, Use Chiller's hack mentioned before:

!!!NOTICE!!!

As of update #117 the way time is kept has changed.

Prior to this update, you could have found time by looking for the 4 byte value equivalent to your number of turns.

Now, for some reason, the value for turns is offset by 35. meaning if you hover your cursor over the time displayed at the top of the screen and it displays 100 "turns", the actual value is going to be 100 + 35 = 135.

Fun things you can do:
Stop time
Reverse time

Side effects,
Cooling down abilities will not cool down until the turn cooldown should have been over.

Note: Still useful for things like upgrading ships, Where you don't necessarily need skills to trigger.

[Chicken0895]

FYI: See [Link] for savegame decryptor and encryptor. Now you can decrypt saved game, tweak it (using sqlite client or binary editor), encrypt again and load the game.

I was looking at getting this working, and a software engineer friend volunteered to assist. My impression as a non-programmer is that the dependency here (CryptoPlus) was written for python 2.x and won't even work with any version of Python from the past several years, so I watched in mounting horror and amusement as my buddy took it on himself to make a standalone version.

[Link]

Also, I've seen a lot of folks in this thread using sql that require executing many times and I just wanted to point out that you can simply use a batch command instead. Whether that's more or less effort for a given task might depend, I guess. Here's a batch command for giving a bunch of traits to 4 specific characters, for example:

Code: Select all

insert into gamecharactertrait(gamecharacterid,traitid,characterknows,optionid) values(1,1,1,0),(1,2,1,0),(1,3,1,0),(1,5,1,0),(1,6,1,0),(1,8,1,0),(1,13,1,0),(1,14,1,0),(1,15,1,0),(1,16,1,0),(1,19,1,0),(1,20,1,0),(1,21,1,0),(1,24,1,0),(1,25,1,0),(1,26,1,0),(1,27,1,0),(1,32,1,0),(1,34,1,0),(1,35,1,0),(1,37,1,0),(1,38,1,0),(1,39,1,0),(1,40,1,0),(1,41,1,0),(1,43,1,0),(1,44,1,0),(1,46,1,0),(1,48,1,0),(1,52,1,0),(1,53,1,0),(1,54,1,0),(1,55,1,0),(1,57,1,0),(1,58,1,0),(1,60,1,0),(1,61,1,0),(1,63,1,0),(1,66,1,0),(1,68,1,0),(1,69,1,0),(1,70,1,0),(1,71,1,0),(1,72,1,0),(1,73,1,0),(1,74,1,0),(1,76,1,0),(1,83,1,0),(1,88,1,0),(1,101,1,0),(1,102,1,0),(1,104,1,0),(1,106,1,0),(1,109,1,0),(1,149,1,0),(1,151,1,0),(1,165,1,0),(1,166,1,0),(1,167,1,0),(1,168,1,0),(1,169,1,0),(1,170,1,0),(1,171,1,0),(1,172,1,0),(1,173,1,0),(1,174,1,0),(1,175,1,0),(1,176,1,0),(1,177,1,0),(1,179,1,0),(1,183,1,0),(1,184,1,0),(1,185,1,0),(1,186,1,0),(1,187,1,0),(1,188,1,0),(1,189,1,0),(1,190,1,0),(1,191,1,0),(1,192,1,0),(1,193,1,0),(1,197,1,0),(1,198,1,0),(1,199,1,0),(1,203,1,0),(1,204,1,0),(1,200,1,0),(1,209,1,0),(1,211,1,0),(1,212,1,0),(1,213,1,0),(1,215,1,0),(1,218,1,0),(1,219,1,0),(3,1,1,0),(3,2,1,0),(3,3,1,0),(3,5,1,0),(3,6,1,0),(3,8,1,0),(3,13,1,0),(3,14,1,0),(3,15,1,0),(3,16,1,0),(3,19,1,0),(3,20,1,0),(3,21,1,0),(3,24,1,0),(3,25,1,0),(3,26,1,0),(3,27,1,0),(3,32,1,0),(3,34,1,0),(3,35,1,0),(3,37,1,0),(3,38,1,0),(3,39,1,0),(3,40,1,0),(3,41,1,0),(3,43,1,0),(3,44,1,0),(3,46,1,0),(3,48,1,0),(3,52,1,0),(3,53,1,0),(3,54,1,0),(3,55,1,0),(3,57,1,0),(3,58,1,0),(3,60,1,0),(3,61,1,0),(3,63,1,0),(3,66,1,0),(3,68,1,0),(3,69,1,0),(3,70,1,0),(3,71,1,0),(3,72,1,0),(3,73,1,0),(3,74,1,0),(3,76,1,0),(3,83,1,0),(3,88,1,0),(3,101,1,0),(3,102,1,0),(3,104,1,0),(3,106,1,0),(3,109,1,0),(3,149,1,0),(3,151,1,0),(3,165,1,0),(3,166,1,0),(3,167,1,0),(3,168,1,0),(3,169,1,0),(3,170,1,0),(3,171,1,0),(3,172,1,0),(3,173,1,0),(3,174,1,0),(3,175,1,0),(3,176,1,0),(3,177,1,0),(3,179,1,0),(3,183,1,0),(3,184,1,0),(3,185,1,0),(3,186,1,0),(3,187,1,0),(3,188,1,0),(3,189,1,0),(3,190,1,0),(3,191,1,0),(3,192,1,0),(3,193,1,0),(3,197,1,0),(3,198,1,0),(3,199,1,0),(3,203,1,0),(3,204,1,0),(3,200,1,0),(3,209,1,0),(3,211,1,0),(3,212,1,0),(3,213,1,0),(3,215,1,0),(3,218,1,0),(3,219,1,0),(4,1,1,0),(4,2,1,0),(4,3,1,0),(4,5,1,0),(4,6,1,0),(4,8,1,0),(4,13,1,0),(4,14,1,0),(4,15,1,0),(4,16,1,0),(4,19,1,0),(4,20,1,0),(4,21,1,0),(4,24,1,0),(4,25,1,0),(4,26,1,0),(4,27,1,0),(4,32,1,0),(4,34,1,0),(4,35,1,0),(4,37,1,0),(4,38,1,0),(4,39,1,0),(4,40,1,0),(4,41,1,0),(4,43,1,0),(4,44,1,0),(4,46,1,0),(4,48,1,0),(4,52,1,0),(4,53,1,0),(4,54,1,0),(4,55,1,0),(4,57,1,0),(4,58,1,0),(4,60,1,0),(4,61,1,0),(4,63,1,0),(4,66,1,0),(4,68,1,0),(4,69,1,0),(4,70,1,0),(4,71,1,0),(4,72,1,0),(4,73,1,0),(4,74,1,0),(4,76,1,0),(4,83,1,0),(4,88,1,0),(4,101,1,0),(4,102,1,0),(4,104,1,0),(4,106,1,0),(4,109,1,0),(4,149,1,0),(4,151,1,0),(4,165,1,0),(4,166,1,0),(4,167,1,0),(4,168,1,0),(4,169,1,0),(4,170,1,0),(4,171,1,0),(4,172,1,0),(4,173,1,0),(4,174,1,0),(4,175,1,0),(4,176,1,0),(4,177,1,0),(4,179,1,0),(4,183,1,0),(4,184,1,0),(4,185,1,0),(4,186,1,0),(4,187,1,0),(4,188,1,0),(4,189,1,0),(4,190,1,0),(4,191,1,0),(4,192,1,0),(4,193,1,0),(4,197,1,0),(4,198,1,0),(4,199,1,0),(4,203,1,0),(4,204,1,0),(4,200,1,0),(4,209,1,0),(4,211,1,0),(4,212,1,0),(4,213,1,0),(4,215,1,0),(4,218,1,0),(4,219,1,0),(12,1,1,0),(12,2,1,0),(12,3,1,0),(12,5,1,0),(12,6,1,0),(12,8,1,0),(12,13,1,0),(12,14,1,0),(12,15,1,0),(12,16,1,0),(12,19,1,0),(12,20,1,0),(12,21,1,0),(12,24,1,0),(12,25,1,0),(12,26,1,0),(12,27,1,0),(12,32,1,0),(12,34,1,0),(12,35,1,0),(12,37,1,0),(12,38,1,0),(12,39,1,0),(12,40,1,0),(12,41,1,0),(12,43,1,0),(12,44,1,0),(12,46,1,0),(12,48,1,0),(12,52,1,0),(12,53,1,0),(12,54,1,0),(12,55,1,0),(12,57,1,0),(12,58,1,0),(12,60,1,0),(12,61,1,0),(12,63,1,0),(12,66,1,0),(12,68,1,0),(12,69,1,0),(12,70,1,0),(12,71,1,0),(12,72,1,0),(12,73,1,0),(12,74,1,0),(12,76,1,0),(12,83,1,0),(12,88,1,0),(12,101,1,0),(12,102,1,0),(12,104,1,0),(12,106,1,0),(12,109,1,0),(12,149,1,0),(12,151,1,0),(12,165,1,0),(12,166,1,0),(12,167,1,0),(12,168,1,0),(12,169,1,0),(12,170,1,0),(12,171,1,0),(12,172,1,0),(12,173,1,0),(12,174,1,0),(12,175,1,0),(12,176,1,0),(12,177,1,0),(12,179,1,0),(12,183,1,0),(12,184,1,0),(12,185,1,0),(12,186,1,0),(12,187,1,0),(12,188,1,0),(12,189,1,0),(12,190,1,0),(12,191,1,0),(12,192,1,0),(12,193,1,0),(12,197,1,0),(12,198,1,0),(12,199,1,0),(12,203,1,0),(12,204,1,0),(12,200,1,0),(12,209,1,0),(12,211,1,0),(12,212,1,0),(12,213,1,0),(12,215,1,0),(12,218,1,0),(12,219,1,0);

You can also straight up mod things, although you will have to execute your changes every time you load the game edit, turns out changes like this are permanent??? what the fuck lol, I'm so used to thinking of anything done with cheat engine as being entirely in memory that I was shocked to realize this is altering the game's encrypted database:

Code: Select all

update ShipComponent set holdsCargo=50, holdsGuest=2, mass=-300 where _id=305

Just some things I haven't seen people talking about much.

Is there any way to make this work with the mod version? I'm guessing they use a different key for it because my save is not getting decrypted properly.

Edit: Turns out the saves for the mod version aren't encrypted at all lol. You can just open it straight in your SQL DB browser of choice.

[hedloc]

update to version 3.3.99 please