Search found 5 matches

by sudeki238
Fri Jul 05, 2019 9:09 am
Forum: Tables
Topic: Star Traders: Frontiers v2.3.29 (Updated: 4/Aug/18)
Replies: 72
Views: 58376

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

-- Get All Jobs on Captain -- insert into gamejob (gameCharacterId,jobType,jobLevel,experience) select 1, (select distinct t.jobtype from job t where t.jobtype not in (select jobtype from gamejob where gamecharacterid = 1) and t.jobtype not in (22,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013)),...
by sudeki238
Fri Jul 05, 2019 8:39 am
Forum: Tables
Topic: Star Traders: Frontiers v2.3.29 (Updated: 4/Aug/18)
Replies: 72
Views: 58376

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

-- True Insert Trait -- insert into gamecharactertrait (gamecharacterid, traitid, characterknows, optionid) select 1, (select t._id from Trait t where t._id not in (select traitid from gamecharactertrait where gamecharacterid = 1) and t._id not in (4,7,11,13,22,28,29,30,31,33,36,42,45,49,50,51,56,59...
by sudeki238
Mon Jul 01, 2019 12:58 pm
Forum: Tables
Topic: Star Traders: Frontiers v2.3.29 (Updated: 4/Aug/18)
Replies: 72
Views: 58376

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

you could try this ... no idea if it still works ... Do a grouped search for the health and morale of your target, eg "4:98 4:97" Right click on the found address and choose "Browse this memory region" 17 bytes and 4 bits from the health value is the 4 byte value for the number of job levels 18 byte...
by sudeki238
Tue Dec 04, 2018 6:12 am
Forum: Tables
Topic: Star Traders: Frontiers v2.3.29 (Updated: 4/Aug/18)
Replies: 72
Views: 58376

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

hi there,
as far as i see it ...
the table still works.
at least you can play with the sql stuff and edit quite some stuff ...

any one found out how to edit max hull and components of your ship ?
by sudeki238
Mon Dec 03, 2018 11:47 am
Forum: Tables
Topic: Star Traders: Frontiers v2.3.29 (Updated: 4/Aug/18)
Replies: 72
Views: 58376

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

ty for the great work .... found some stuff after playing a bit around ... Job ID's 1 crew dog 2 mechanic 3 electronics tech 4 gunner 5 soldier 6 pistoleer 7 sniper 8 swordsman 10 assassin 11 combat medic 12 doctor 13 diplomat 15 zealot 16 hyperwarp navigator 18 exo scout 19 scavenger 23 commander 2...