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

[tfigment]

This table is a little non-standard and doesn't work as you might expect.

This table hooks into the database the game uses to store data. The files are well encrypted so difficult to use directly with a database editor. This allows viewing the editing the data.db database which has base game information and the currently loaded game_#.db database.

The main requirement is that you must enable the table before loading the captain on the start menu so that it can get the correct pointers.

Next it will only expose SQL queries. This is probably foreign concept to most users here so this table may not be very useful.

To use the table select the "Open Game Query Editor" check box. It will launch an editor that allows queries to be run and results viewed.

For Example if you type the following it will show a list of all tables in the database that you can query:

Code: Select all

select name, tbl_name from sqlite_master where type = 'table'

The select Execute button or (Ctrl+Enter) on keyboard.

You can set health for all characters with something like the following but we dont know actual max so the health bars might behave strange if it overruns.

Code: Select all

update Character set health=max(health,200), spirit=max(health,100)

The editor has a number of predefined queries that I quickly thought up and a save/load mechanism to save to disk. The combobox just is a convenience to access queries to save and restore and it will populate in the text area to be run.

The problem with this technique is that the game does not immediately load this data from the database.

Things like Contact Influence and Reputation are loaded frequently while Money never is. So you might need to exit to main menu and reload the current game to see effects.

Example SQL Commands

Code: Select all

-- Game Data --
select * from GameData;

Code: Select all

-- Game Character List --
select * from GameCharacter;

Code: Select all

-- Columns in Game Character Table --
PRAGMA table_info(GameCharacter);

Code: Select all

-- Character List --
select gc.displayName, c.* from GameCharacter gc, Character c where c._id = gc.gameCharacterId;

Code: Select all

-- Set Health to 200 --
update Character set health=max(health,200), spirit=max(health,200)

Code: Select all

-- Pay Crew --
update GameCharacter set payTurn = (select turn from GameData limit 1);

Code: Select all

-- Refuel Ship --
Update GameShip set fuel = 600 where mapZoneId = -1;

Code: Select all

-- Clear Last Talents Used --
update GameTalent set talentUsedTurn=0;

Code: Select all

-- Set Max Contact Influence --
update GameContact set influenceScore = influenceScoreMax where influenceScore < influenceScoreMax;

Code: Select all

-- Set Contact Reputation to 50 --
update GameContact set contactRep = 50 where contactRep < 50;

Code: Select all

-- Clear Ship Component Damage--
update ShipDeckCompartment set componentDamage = 0 where componentDamage != 0;

Code: Select all

-- Table List --
select name, tbl_name from sqlite_master where type = 'table';

Code: Select all

-- Character List --
select gc.displayName, c.* from GameCharacter gc, Character c where c._id = gc.gameCharacterId;

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

[WintermuteX]

This is soooo great!
Thank you very much!

But one question: the data query editor is not supposed to change values? At least I couldn't change the shipEngine table.

[WintermuteX]

Could you (or anyone with enough knowledge) update the AOBScan/Script to work with 2.3.28 (the release version after leaving early access)? Most likely this would work for quite some time afterwards. The last table version worked until very recent (the last update before release or the one before that broke the table).

[ANC46]

[QUOTE="tfigment, post: 28194, member: 2321"]This table is a little non-standard and doesn't work as you might expect.



This table hooks into the database the game uses to store data. The files are well encrypted so difficult to use directly with a database editor. This allows viewing the editing the data.db database which has base game information and the currently loaded game_#.db database.



The main requirement is that you much enable the table before loading the captain on the start menu so that it can get the correct pointers.



Next it will only expose SQL queries. This is probably foreign concept to most users here so this table may not be very useful.



To use the table select the "Open Game Query Editor" check box. It will launch an editor that allows queries to be run and results viewed.



For Example if you type the following it will show a list of all tables in the database that you can query:

[code]select name, tbl_name from sqlite_master where type = 'table'[/code]

The select Execute button or (Ctrl+Enter) on keyboard.



You can set health for all characters with something like the following but we dont know actual max so the health bars might behave strange if it overruns.

[code]update Character set health=max(health,200), spirit=max(health,100)[/code]



The editor has a number of predefined queries that I quickly thought up and a save/load mechanism to save to disk. The combobox just is a convenience to access queries to save and restore and it will populate in the text area to be run.



The problem with this technique is that the game does not immediately load this data from the database.



Things like Contact Influence and Reputation are loaded frequently while Money never is. So you might need to exit to main menu and reload the current game to see effects.

[spoiler=Example SQL Commands]

[code]-- Game Data --

select * from GameData;[/code]

[code]-- Game Character List --

select * from GameCharacter;[/code]

[code]-- Columns in Game Character Table --

PRAGMA table_info(GameCharacter);[/code]

[code]-- Character List --

select gc.displayName, c.* from GameCharacter gc, Character c where c._id = gc.gameCharacterId;[/code]

[code]-- Set Health to 200 --

update Character set health=max(health,200), spirit=max(health,200)[/code]

[code]-- Pay Crew --

update GameCharacter set payTurn = (select turn from GameData limit 1);[/code]

[code]-- Refuel Ship --

Update GameShip set fuel = 600 where mapZoneId = -1;[/code]

[code]-- Clear Last Talents Used --

update GameTalent set talentUsedTurn=0;[/code]

[code]-- Set Max Contact Influence --

update GameContact set influenceScore = influenceScoreMax where influenceScore < influenceScoreMax;[/code]

[code]-- Set Contact Reputation to 50 --

update GameContact set contactRep = 50 where contactRep < 50;[/code]

[code]-- Clear Ship Component Damage--

update ShipDeckCompartment set componentDamage = 0 where componentDamage != 0;[/code]

[code]-- Table List --

select name, tbl_name from sqlite_master where type = 'table';[/code]

[code]-- Character List --

select gc.displayName, c.* from GameCharacter gc, Character c where c._id = gc.gameCharacterId;[/code]

[/spoiler][/QUOTE]



+1

[kain33]

yes please, update it :)

[hentai-sama]

full release is on, pls update table

[gorsan]

this table also never worked for me even for right versions, i know mysql,

- anyway you have to find cheat adresses at character creation

- the trick is you can edit cheated stats after creating a new template then editing stats just before starting game

[WintermuteX]

[QUOTE="gorsan, post: 53898, member: 975"]this table also never worked for me even for right versions, i know mysql,

- anyway you have to find cheat adresses at character creation

- the trick is you can edit cheated stats after creating a new template then editing stats just before starting game[/QUOTE]



The table really worked like a charm, at least for myself and even for months. You could edit your crews attributes and skills aswell as reputations and influence with the SQL statements. Cheating the stats of your captain works quite well at character creation, but afterwards the best you can do is cheat the level of the crew and the talent points; skills and attributes aren't permanent.

[CaesarCzech]

Can you update this for release ?

[tfigment]

Updated for 2.3.29. They changed how and when the game db is loaded so new AOBSCAN is required for that location. I've only done cursory testing but seemed to work correctly.

[SAZUREE]

thanks.

but how to to use this table ?

[korell]

Can someone give a sample statement on how to edit crew attribute?

[WintermuteX]

[QUOTE="korell, post: 54099, member: 609"]Can someone give a sample statement on how to edit crew attribute?[/QUOTE]





For ALL skills of ALL crew:

[CODE]update GameCharacter set skLightFirearms = 200, skHeavyFirearms = 200, skMelee = 200, skEvasion = 200, skTactics = 200, skStealth = 200, skGunnery = 200, skPilot = 200, skShipOps = 200, skRepair = 200, skElectronics = 200, skNavigation = 200, skDoctor = 200, skCommand = 200, skNegotiate = 200, skIntimidate = 200, skExplorer = 200;[/CODE]



For ALL attributes of ALL crew:

[CODE]update GameCharacter set attQuickness = 200, attStrength = 200, attFortitude = 200, attWisdom = 200, attCharisma = 200, attResilience =200;[/CODE]



To set the attribute "Quickness" of "Captain Cheat" to 210:

[CODE]update GameCharacter set attQuickness = 210 where displayName = "Captain Cheat";[/CODE]

[korell]

Thanks for the reply much appreciated

[Pez]

For some reason, I can't get the money to change. With high enough attributes though, you get paid for buying certain things (they cost negative money).



Here's a couple of SQL commands:



-- Make all contacts known --

update GameContact set characterKnows = 1 where characterKnows = 0;



-- Set faction rep to 300 (feel free to adjust permit, edict, and rank as you like)--

update CharacterRank set rep = 300, permit = 5, edict = 1, rank = 5;



-- Set all character experience (50000 allows officers to have one lvl 15 skill, and 2 lvl 11's)--

update Character set experience = 50000;



There's got to be a way to unlock everything. I just haven't figured it out yet. Prolly won't really try. I've contemplated playing around with adding traits, but since I don't have a table connecting the trait ID # to the actual [url=https://startraders.gamepedia.com/Traits]trait name[/url], I'm not going to waste my time playing around with it to figure them out.