#Looking for a table

1 messages · Page 1 of 1 (latest)

tulip flax
#

Is there any way to get a table of the vanilla Talent ids without having to hack the db? I haven't been able to find them anywhere, and in creations of some professions, it would be nice if I could reuse some of the already existing talents as opposed to needing to make every talent custom.

#

It would also be handy to look at some already created NPC values to reference in making more.

lilac eagle
#

That's a spreadsheet with all of the tables in the STF database (non-save tables that is). It's a little out of date, but is still 98% complete.

tulip flax
#

Thanks a million! That will help me soo much

lilac eagle
#

It also has a tab you can use to actually write the code

tulip flax
#

And anyone else that wanted it too hehe

lilac eagle
#

The #stf_modding channel is the activish modder channel for things like this.

tulip flax
#

Ah ok. I am just learning still, bouncing between sheets and stuff. Yesterday I put together an excel dropdown list to make navigating the enumerators easier for myself

lilac eagle
#

Yeah. The Enums are painful.

#

When I'm modding I have a bunch of things open at once, my self-built mod building tool and sql editor, the spreadsheet I linked, a few wiki pages, notepad, and STF.

tulip flax
#

I do my sql edits in notepad++ sincd idk how to use the sql/database thingy I downloaded

lilac eagle
#

If your SQL is wrong, the STF engine isn't very helpful for debugging. It gives a generic "it broke at an UPDATE statement", but it doesn't tell you which line.

#

Having a SQL tool to run your code is helpful because it will tell you what's wrong with it. You can also double check the impact of your changes are what you expect.

#

If you are just doing 'simple' changes, then it isn't necessary. But once you start doing more complicated things, it is vital.

tulip flax
#

Yeah... currently working on making 2 professions and unique Talents+traits, but want to fill some in with vanilla traits as well.
Once I get more used to the sequences and stuff, I might attempt to make a map with custom storyline(s)

lilac eagle
#

Map modding is hard. Story's are harder.

tulip flax
#

Kinda want to make something that is halfway between the android game series Space RPG, and X4 Foundations (pc)

lilac eagle
#

You should join the #stf_modding channel

#

Andrew has some documentation posted there. And I've written guides there.

tulip flax
#

Thanks 🙂 I will check on it periodically then

lilac eagle
#

The other obvious thing is, go grab all the Merchant Marine mods and use their code as examples when you try to build your own. It has a lot of the basic types of changes in it, so you can use that a guide to write your own.

#

When I build a job, I compose it in that spreadsheet I linked as 50 or so lines, and then copy & paste that into the sql txt file. It also allows you to track changes and things much more easily.

#

Trying to debug talent 27's effectType changes in notepad is painful.

tulip flax
#

Hmm ok. I was using a few like the Jedi one for what I am doing rn. Also subscribed to some others just to copy and paste code for myself as a reference.

I made some conflicting mods I wanted to use compatible by integrating them into my 'minimod' mod and changing uniqueIDs

lilac eagle
#

That's the way to do it.

tulip flax
#

Oh, yesterday I noticed that an example wiki template did not list everything that was in mod templates, which let me realize that I don't need to add a bunch of stuff that I am just going to pump 0's into for some things

lilac eagle
#

yep

tulip flax
#

like attStrength

lilac eagle
#

Seriously, go try out the Builder tab in that spreadsheet

tulip flax
#

XD oki later today I will ❤️

lilac eagle
#

(Technically, the spreadsheet is missing some of the new fields that were added. I think the ship components have 2 new fields? Maybe 4?) I've just not cared enough to export and update things.

tulip flax
#

Hmm. Well I have not meddled with ships or their components myself yet. Hopefully their googledoc or enumerators page get edited to include them at some point

lilac eagle
#

When I built the sheet, I didn't add any automated update logic, so I'd have to do it all by hand again.

#

There are 46 tables in the database. Even if it only takes 5 minutes to process each one, once I remember how, it would be painful. Alternatively, there are cat videos on the internet to watch.