• Welcome to the new COTI server. We've moved the Citizens to a new server. Please let us know in the COTI Website issue forum if you find any problems.
  • We, the systems administration staff, apologize for this unexpected outage of the boards. We have resolved the root cause of the problem and there should be no further disruptions.

Homeworld generator

Horatius

SOC-12
Is there a searchable database for homeworlds? Or even a random homeworld generator somewhere?

something where you input the characteristics of the rolled homeworld and it will give you a list of possible candidates?
 
travellermap.com has the files, but at present, doesn't have the interface set up for that.

However, it's pretty easy to load those into an excell file, and filter for trade codes.
 
But not easily for ranges. And it doesn't seem to allow search by trade codes.

You could use Universe. It allows SQL queries to be run right from the main program, you just need to be able to phrase your homeworld requirements as a SELECT statement. You can do ranges in SELECT statements and the main system table (actually a VIEW) contains a flag field for each trade code.
 
or if you've got plain SEC files, you could even get around to writing an regular expression to get the data (in whatever scripting language you like). Regex is really powerful if equally arcane.

But - that would be fairly complicated compare to SQL (which for most non-programmers, both are probably close to impossible). But do-able.

There are several grep programs for Windows out there (grep being get regular expression if I remember) that you could possibly use as well and may do a bit of hand-holding on getting the regex correctly. But again: it would be more complicated than most people want to deal with (but now I'm piqued - perhaps I'll try that out)

I think Hemdian's solution would be the easiest, assuming you have or get Universe. And as he is working on version two I think, perhaps he could even add a quick SQL generator (select zero or more sizes, select zero or more atmo, etc, and generate a SQL statement from that. Most programs dealing with DBs have some sort of report generator to help you pick what you need).
 
I just noted this thread.

Years back I wrote a _very_basic_ "home world locator" for characters in teh Spinward Marches. I forget what disk I left it on and the system I used it on is long dead.

But it was written in PASCAL(stop laughing!!!)
It would
1) randomly choose two numbers between 1 and 4 inclusive to determine a subsector
2) Enter a subroutine and randomly choose a number between 1 and 8 inclusive to determine the column in the subsector
3) fall into a case statement based on the number from step 2 which would enter a subroutine that would generate a random number from 1 to the number of world's in the selected column in the selected subsector.
If there were no worlds in that subsector, it would re-run.

For example(and in a bit more detail),
The first selection would choose 1 to 4 and if it determined 4(the last column in the subsector),
A case would drop it into a second 1 to 4 generation who's case would choose between the subroutines Aramis, Rhylanor, Mora and TrinsVeil.
Once the 1-4 determined which subsector(say 3 - Mora) the Mora subroutine would first run a 1 - 8 random number and drop it into a case statement.
Here is where the real work was done because I tailored each of the eight possible outcomes to a random number based on that subsector's columns.
So if the 1 - 8 generator selected:
1: I could then get from worlds 1 to 3
2: I could then get from worlds 1 to 3
3: I could then get from worlds 1 to 2
4: I could then get from worlds 1 to 4
5: I could then get from worlds 1 to 3
6: I could then get from worlds 1 to 7
7: I could then get from worlds 1 to 2
8: I could then get from worlds 1 to 2

So if it chose 5 from the "pick 8" and then chose 2, it would then spit out the "address" of the system as 4352. All I would need do then is check the map for the subsector third down in the fourth column and then look for the second system down in the fifth column to see my homeworld is Rorise.

The logic is very simple but the difficulty is in tailoring the random generators led to by each of the case statements one you've selected the subsector. In the end, I was actually re-writing the program to spit out both the system name and the full UWP(with the PGR, trade classifications, etc...)

Marc
 
Back
Top