got that working again
here's what i posted on SSC
it's in a condition that it should work on any system MS Access is installed on
i said should, it works again on my new machine after some start problems.
it was setup under ME, but runs now on XP to, so i guess that it will work on any computer access is installed.
if not, then tell me please,
it will look like this:
the good thing about the html form is you can't edit the data by accident.
the bad thing it's a bit complicated to find the right route and you have to check both, actual and target system to get a jump route, because it didn't looks recursively for it.
most data you see about a system is common.
only 2 are to explain maybe,
max radius, means the ~maximum extension of a system in AU and gives you a idea how far from the main star your entry point will be, but not the exact distance to it.
the planetary info field will tell you roughly what you will find there, if i have explored the (unexplored) system allready or if it's known allready.
the system i used is,
S = a star
SS (no space between) = a binary star
P = a planet orbiting a star or binary star
A = a planet orbiting a star or binary star with breathable atmosphere
G = a gas giant orbiting a star or binary star
D = a dwarf star orbiting a star or binary star
p = a planet or planetoid orbiting a dwarf star and sometimes a planetoid orbiting a gas giant
g = a gas giant orbiting a dwarf star
the listing can sometimes be quite long then and possibly overlap the field for it.
moons are generally not listed except for the ones that have a breathable atmosphere and are inhabited.
planets and suns are listed hierachical, that means the main star or binary star and it's planets first then second star or binary star or dwarf star and it's planets and so on.
you will have to open it with the MS internet explorer Firefox won't open it
even ie will argue that it contains "unsafe" scripted data, just click ignore.
and of course you will need ms access else the database can't be opened by the browser.
but because i spent so many hours (days, weeks, months in fact) to list that all up i found it worthy that someone might use it
if you start a carreer as a imperial and have the "wormhole bug" activated, it will be extremely handy and you will reach any target in "no time", only assasinations can't be completed this way, due to whatever when arriving in a system using the wormhole the "client" will never arrive
but it's the only way to explore the full depht of FE2's galaxy, and you can reach any point by using the wormhole (that didn't means you find all in the database, else i would be still collecting data for the next ten years i guess)
some data can vary, since i switched once from my personal coordinate system to the system used in the wormhole routes list you can find on frontierverse, but usually all is in the "frontierverse system" listed and i use it as you might have recognized also for pioneers coordinates since it's the more common known one.
frontierverse's coordinates start at center of each sector so that the grid marks 0.5 sectors
my personal coordianates system starts at "real" 0 which is in the lower left corner of the sector, this is the coordinate system used in FE2's code and works for sector and the whole galaxy and the grid marks then 0 (or 1 for top right).
the main reason was for this, a quicker reading of the systems exact position by watching the adresses hex data with Gamewizard32 a very handy cheat program. which allowed me not only to read out the data of a selected system, i could also do something like buffet2's wormhole replacement cheat by entering the ships position at the right adress, only 1t of fuel and a supershort jump was needed then to arrive. or maybe simply place the crosseye over a system of my choice.
if you like to know how that works lookout for my FE2 modding pack
there should be a full explanation to that, based on and together with theunis old frontier objects document.
the explanation there is ment for save game editing, but can be used as well to understand FE2's coordinates system in general. adresses i can't reply here because they change on every computer depending on what is running on the actual machine in the background and GW32 can't find the right adress if the "position" of the running program has changed in ram, that's sad i know but offens. maybe i check them once in tiny hexer since when you open a task with this, the adresses start for each task at 0x0.
i once evaluated the center of the galaxy, but it's not confirmed that it's truely the center, because that is a hard thing to find out, since the coordinates starts at sol (0,0) and the whole galaxy is not centered at mid of lower left, upper right maximum, you will find a system near to that called DAWADA it should be in the database to.
of course you can add own routes or infos when you open the database in access
but do that carefully,
open frontier_jumpdata.mdb in access
check the tables tab (there is a lot of other "junk" in the database that is not used, some other is important, since i'm to lazy to figure out what is important and what not, i left it all as it was)
open system data to alter allready listed or enter new systems info
make shure you classified the system either as target or jump system this is important to grant the system is shown right as a intermediate system or as start/target point. its the first column after the ID for the entry and has only a checkmark option, checked entrys are target systems, unchecked are intermediate "jump systems"
this is not so important for the database itself, but for you, since the intermediate systems are sectioned from target systems in the jumpdata table, i chose this to have a quicker access to them when assigning a new route.
open jumpdata to assign the route between the systems (you will have then a pulldown selector for that)
make backup copies in the database before entering anything, i'm by myself corrupted the database often, rightclick therefore on the table and select save as...
some numbers,
553 systems in the system database at all,
528 jump routes between them
ok, enough theoretical stuff
FRONTIER_WORMHOLE_DATABASE.zip
here's what i posted on SSC
it's in a condition that it should work on any system MS Access is installed on
i said should, it works again on my new machine after some start problems.
it was setup under ME, but runs now on XP to, so i guess that it will work on any computer access is installed.
if not, then tell me please,
it will look like this:
the good thing about the html form is you can't edit the data by accident.
the bad thing it's a bit complicated to find the right route and you have to check both, actual and target system to get a jump route, because it didn't looks recursively for it.
most data you see about a system is common.
only 2 are to explain maybe,
max radius, means the ~maximum extension of a system in AU and gives you a idea how far from the main star your entry point will be, but not the exact distance to it.
the planetary info field will tell you roughly what you will find there, if i have explored the (unexplored) system allready or if it's known allready.
the system i used is,
S = a star
SS (no space between) = a binary star
P = a planet orbiting a star or binary star
A = a planet orbiting a star or binary star with breathable atmosphere
G = a gas giant orbiting a star or binary star
D = a dwarf star orbiting a star or binary star
p = a planet or planetoid orbiting a dwarf star and sometimes a planetoid orbiting a gas giant
g = a gas giant orbiting a dwarf star
the listing can sometimes be quite long then and possibly overlap the field for it.
moons are generally not listed except for the ones that have a breathable atmosphere and are inhabited.
planets and suns are listed hierachical, that means the main star or binary star and it's planets first then second star or binary star or dwarf star and it's planets and so on.
you will have to open it with the MS internet explorer Firefox won't open it
even ie will argue that it contains "unsafe" scripted data, just click ignore.
and of course you will need ms access else the database can't be opened by the browser.
but because i spent so many hours (days, weeks, months in fact) to list that all up i found it worthy that someone might use it
if you start a carreer as a imperial and have the "wormhole bug" activated, it will be extremely handy and you will reach any target in "no time", only assasinations can't be completed this way, due to whatever when arriving in a system using the wormhole the "client" will never arrive
but it's the only way to explore the full depht of FE2's galaxy, and you can reach any point by using the wormhole (that didn't means you find all in the database, else i would be still collecting data for the next ten years i guess)
some data can vary, since i switched once from my personal coordinate system to the system used in the wormhole routes list you can find on frontierverse, but usually all is in the "frontierverse system" listed and i use it as you might have recognized also for pioneers coordinates since it's the more common known one.
frontierverse's coordinates start at center of each sector so that the grid marks 0.5 sectors
my personal coordianates system starts at "real" 0 which is in the lower left corner of the sector, this is the coordinate system used in FE2's code and works for sector and the whole galaxy and the grid marks then 0 (or 1 for top right).
the main reason was for this, a quicker reading of the systems exact position by watching the adresses hex data with Gamewizard32 a very handy cheat program. which allowed me not only to read out the data of a selected system, i could also do something like buffet2's wormhole replacement cheat by entering the ships position at the right adress, only 1t of fuel and a supershort jump was needed then to arrive. or maybe simply place the crosseye over a system of my choice.
if you like to know how that works lookout for my FE2 modding pack
there should be a full explanation to that, based on and together with theunis old frontier objects document.
the explanation there is ment for save game editing, but can be used as well to understand FE2's coordinates system in general. adresses i can't reply here because they change on every computer depending on what is running on the actual machine in the background and GW32 can't find the right adress if the "position" of the running program has changed in ram, that's sad i know but offens. maybe i check them once in tiny hexer since when you open a task with this, the adresses start for each task at 0x0.
i once evaluated the center of the galaxy, but it's not confirmed that it's truely the center, because that is a hard thing to find out, since the coordinates starts at sol (0,0) and the whole galaxy is not centered at mid of lower left, upper right maximum, you will find a system near to that called DAWADA it should be in the database to.
of course you can add own routes or infos when you open the database in access
but do that carefully,
open frontier_jumpdata.mdb in access
check the tables tab (there is a lot of other "junk" in the database that is not used, some other is important, since i'm to lazy to figure out what is important and what not, i left it all as it was)
open system data to alter allready listed or enter new systems info
make shure you classified the system either as target or jump system this is important to grant the system is shown right as a intermediate system or as start/target point. its the first column after the ID for the entry and has only a checkmark option, checked entrys are target systems, unchecked are intermediate "jump systems"
this is not so important for the database itself, but for you, since the intermediate systems are sectioned from target systems in the jumpdata table, i chose this to have a quicker access to them when assigning a new route.
open jumpdata to assign the route between the systems (you will have then a pulldown selector for that)
make backup copies in the database before entering anything, i'm by myself corrupted the database often, rightclick therefore on the table and select save as...
some numbers,
553 systems in the system database at all,
528 jump routes between them
ok, enough theoretical stuff
FRONTIER_WORMHOLE_DATABASE.zip