Pilot Archive

---

Raja_Asenn wrote:

---

Zedzuada wrote: Cool. How about posting it in a similar format to that of original posts? It would be interesting to compare the database version with the one you referred to in your previous post. Zeddd

---

Larry Wall, author of the venerable and beloved scripting language Perl, is quoted as saying "Three great virtues of programming are laziness, impatience, and hubris." So, to answer your question, I'm gonna go with doors number 1 and 3.

However if comparison is all you've got in mind, you can always just click here and flip back and forth with good old alt+tab

---

I wasn't asking for anything particularly complex.

SELECT component_class_type, component_class_name
FROM component_class_table
ORDER BY 1, 2;

The output from that would be quite sufficient for a quick comparison.


Zeddd

I must have misunderstood what you were asking for. Pseudocode was a good idea.



Is this what you had in mind?

---

Raja_Asenn wrote:
I must have misunderstood what you were asking for. Pseudocode was a good idea.

Is this what you had in mind?

---

Awesome, that's exactly what I had in mind. Thank you for pulling that data. In return, I have a couple of corrections for you.

Since I had my booster data to hand, I did a quick comparison against your dump and came across a couple of areas. Since no-one has entered them, there are 2 lvl 9 boosters missing from the list, Sienar Fleet Systems "Ultra-Thrust" Elite Booster and SubPro Mark IV "Accelatron" Boosters. There is also an apparently bogus lvl 4 entry presumably caused by a typo: Republic Sienar System Ion Booster (note the lack of a final 's' in "System").

Hopefully in the next few days I'll find some time to do further comparisons between your table, the lists here and the canonical source. I'll pm you with any more corrections I come across.


Zeddd

---

Zedzuada wrote:

Awesome, that's exactly what I had in mind. Thank you for pulling that data. In return, I have a couple of corrections for you....

Hopefully in the next few days I'll find some time to do further comparisons between your table, the lists here and the canonical source. I'll pm you with any more corrections I come across.


Zeddd

---

Thanks! I'll knock out those fixes tonight.

All i can say is "FAQ it"

---

Raja_Asenn wrote:

---

Zedzuada wrote:

there are 2 lvl 9 boosters missing from the list ... SubPro Mark IV "Accelatron" Boosters.

Zeddd

---

I held off on entering this one pending further investigation. We already have a booster by that name in the system under RE level 7. Twenty entries have been submitted against that class, so it seems likely to be accurate.

I got the other one put in, and rectified the L4 problem.

---

This appears to be due to a typo in the game data itself. There appear to be two classes with the same name, an L7 and an L9 booster. Presumably one of them should be a Mark V.


Zeddd

---

Zedzuada wrote:

This appears to be due to a typo in the game data itself. There appear to be two classes with the same name, an L7 and an L9 booster. Presumably one of them should be a Mark V.


Zeddd

---

a-ha

Nice catch! Class added.