blog:20170910_sub_sectors
Differences
This shows you the differences between two versions of the page.
Last revisionBoth sides next revision | |||
blog:20170910_sub_sectors [2017/09/10 16:13] – created sam | blog:20170910_sub_sectors [2017/09/10 16:20] – sam | ||
---|---|---|---|
Line 10: | Line 10: | ||
Since there' | Since there' | ||
+ | The next step is a choice between drawing a map of the star system, or starting to write some proper planet generators. In the meantime, here's some of what's in the database for the map shown (' | ||
+ | < | ||
+ | mysql> select * from planets where name like ' | ||
+ | +--------+-----------+-----------------+-----------+---------+----------+--------+--------------+ | ||
+ | | id | system_id | name | parent_id | is_moon | distance | radius | type | | ||
+ | +--------+-----------+-----------------+-----------+---------+----------+--------+--------------+ | ||
+ | | 145754 | 145752 | Oyysa Alpha I | ||
+ | | 145755 | 145752 | Oyysa Alpha II | 145753 | 0 | 177 | 16 | AsteroidBelt | | ||
+ | | 145756 | 145752 | Oyysa Alpha III | 145753 | 0 | 220 | 29000 | SubJovian | ||
+ | +--------+-----------+-----------------+-----------+---------+----------+--------+--------------+ | ||
+ | 3 rows in set (0.00 sec) | ||
+ | |||
+ | mysql> select * from sss; | ||
+ | +----------+---------------+---+----+------------+------+ | ||
+ | | sector | ||
+ | +----------+---------------+---+----+------------+------+ | ||
+ | | Sector 1 | Imu | 1 | 2 | VII | T8 | | ||
+ | | Sector 1 | Edytre | ||
+ | | Sector 1 | Tupi Minor | 1 | 5 | VII | T5 | | ||
+ | | Sector 1 | Ghuquistanu | ||
+ | | Sector 1 | Uman | 1 | 7 | VI | M9 | | ||
+ | | Sector 1 | Ghahir Minor | 1 | 8 | VII | T9 | | ||
+ | | Sector 1 | Sticanume | ||
+ | | Sector 1 | Thikytsa | ||
+ | | Sector 1 | Epsilon Acylo | 2 | 5 | VII | L1 | | ||
+ | | Sector 1 | Otu | 2 | 6 | D | D8 | | ||
+ | | Sector 1 | Otu | 2 | 6 | VII | T6 | | ||
+ | | Sector 1 | Unu Yepy | 2 | 9 | VI | L4 | | ||
+ | | Sector 1 | Ghotod Prime | 2 | 10 | D | D5 | | ||
+ | | Sector 1 | Alpha Adud | 3 | 1 | VII | L6 | | ||
+ | | Sector 1 | Irehi | 3 | 3 | VI | L4 | | ||
+ | | Sector 1 | Naditi | ||
+ | | Sector 1 | Naditi | ||
+ | | Sector 1 | Beta Hotonu | ||
+ | | Sector 1 | Beta Hotonu | ||
+ | | Sector 1 | Oye | 4 | 1 | VII | L0 | | ||
+ | | Sector 1 | Anardu | ||
+ | | Sector 1 | Hyxuktat | ||
+ | | Sector 1 | Fity Ybew | 4 | 7 | VII | L2 | | ||
+ | | Sector 1 | Ane | 4 | 8 | VI | M7 | | ||
+ | | Sector 1 | Dahu | 4 | 9 | VI | M2 | | ||
+ | | Sector 1 | Little Eteh | 5 | 1 | VI | M3 | | ||
+ | | Sector 1 | Tayensa | ||
+ | | Sector 1 | Iquatu | ||
+ | | Sector 1 | Oyysa | 5 | 8 | VII | T5 | | ||
+ | | Sector 1 | Oyysa | 5 | 8 | D | D6 | | ||
+ | | Sector 1 | Shaxifih | ||
+ | | Sector 1 | Noweh | 6 | 3 | VI | L2 | | ||
+ | | Sector 1 | Ebuvo | 6 | 6 | VI | M0 | | ||
+ | | Sector 1 | Sanabi | ||
+ | | Sector 1 | Pheref Mege | 6 | 9 | VII | T5 | | ||
+ | | Sector 1 | Satiqugo | ||
+ | | Sector 1 | Ibe Seya | 7 | 2 | V | F0 | | ||
+ | | Sector 1 | Ahohu | 7 | 3 | II | M7 | | ||
+ | | Sector 1 | Ihodok | ||
+ | | Sector 1 | Ridefteri | ||
+ | | Sector 1 | Epsilon Yda | 7 | 10 | VII | L0 | | ||
+ | | Sector 1 | Ghotohihyyi | ||
+ | | Sector 1 | Shenana | ||
+ | | Sector 1 | Hahutuno | ||
+ | | Sector 1 | Wenahlu | ||
+ | | Sector 1 | Wenahlu | ||
+ | | Sector 1 | Odopayot | ||
+ | | Sector 1 | Nefuxdami | ||
+ | +----------+---------------+---+----+------------+------+ | ||
+ | 48 rows in set (0.00 sec) | ||
+ | </ |
blog/20170910_sub_sectors.txt · Last modified: 2017/09/10 16:21 by sam