Last updated: 2011-03-16

Project IDs
-----------

3	Capsule Lab
4	I-Tech Library
5	Minister`s Office
6	Upgrade System
7	Destroy System
8	I-Tech Facility
9	Recon Center
10	Sabotage Center
11	System Defense I
12	System Defense II
13	System Defense III
14	System Defense IV
15	System Defense V
16	Minister`s Training
17	Banjoran Temple
18	Orion Temple
19	Century Temple
20	Space Program I
21	Space Program II
22	Space Program III
23	Space Program IV
24	Space Program V
25	Titan Project
26	Urania Project
27	UnReverse Engineer
28	Excavator (Small)
29	Excavator (Large)
30	Shipyard: Neutral
31	Shipyard: Kalzul
32	Shipyard: D.Marauder
33	DNA Restructure I
34	Carnival : Commercial
35	Carnival : Agriculture
36	Carnival : Industry
37	Force Vassal
38	Plunder Planet
39	System Restructure
40	Lost System I
41	Lost System II
42	Minister Bootcamp
43	Terraform
44	Cede Planets
45	Deep Space Radar
46	Ore Extractor
47	Destroy Temple
48	Planet Restructure
53	DNA Restructure II
54	Caymans Account
55	Caymans Vault
56	Caymans TimeBank
57	Minister`s Large Office
58	Minister`s Customize
59	Kalzul Upgrade System
60	Carnival : Raw Material
61	Food extractor
62	Goods extractor
63	Sabotage Center II
64	Artifact Formula
65	Market QuickBuy
66	Infra Boost
67	Empire Cloak
68	Empire Stimulus
69	Timewarp
70	Timewarp Node
71	Terraform 2 (Disabled)
72	Terraform 2
200	Overmind : Hektar Part
201	Overmind : Loktar Part
202	Overmind (Complete)
203	Overmind (End)


Research IDs
------------
1	Small Terran hull
2	Medium Terran hull
3	Large Terran hull
8	Composite Class Ships
13	Strafez Engineering
24	Cyril Class Ships
33	Adv. Scout 
34	Photon Class Ships
37	Crystal Lenses
43	Class 3 Marauder Hull
44	Class 5 Marauder Hull
45	Class 6 Marauder Hull
53	Aspha Corvette
54	Aspha Frigate
56	Aspha Destroyer
57	Aspha Cruiser
59	Aspha Battleship
60	Aspha Dreadnought
63	Aspha Ranger
65	Heavy Starbase
66	G Class Ship
67	Fighter Class
68	Corvette Class
69	Frigate Class
70	Destroyer Class
71	Cruiser Class
72	Weapons Platform
74	Advanced Scouts
82	F Class Ships
87	G Class Juggernaught
89	D Class ships
92	K Class Destroyer
93	K Class Cruiser
94	Capsule Lab
104	Mega Projects
105	Space Program I
106	Upgrade System
107	Destroy System
108	I-Tech Libary
109	I-Tech Lab
110	Spying Capability
111	Spy Recon
112	Spy Sabotage
113	System Defense I
114	System Defense II
115	System Defense III
116	System Defense IV
117	System Defense V
118	Space Program II
119	Space Program III
120	Space Program IV
121	Space Program V
122	Ministers Office
123	Ministers Training Facility
124	Century Temple
125	White Tablet
126	Black Tablet
127	Red Tablet
128	Green Tablet
129	Blue Tablet
130	Titan Project
131	Urania Project
132	UnReverse
253	Special




Arfifact Ids
------------
1	Terran Metal
2	Red Crystal
3	White Crystal
4	Rutile
5	Composite
6	Strafez Organism
7	Organic Base
8	Assimilated Base
9	Planetary Core
10	Energy Pod
11	Small Time Capsule
12	Big Time Capsule
13	White Orb
14	Black Orb
15	Blue Orb
16	Green Orb
17	Orange Orb
18	Yellow Orb
19	Purple Orb
20	Gray Orb
21	Brown Orb
22	Moccasin Orb
23	Golden Orb
24	Turquoise Orb
25	Aqua Orb
26	Pink Orb
27	Plum Orb
28	Cuarto Mapa
29	Bronze Dinero
30	Silver Dinero
31	Gold Dinero
32	Platinum Dinero
33	Amber Dinero  
34	Garnet Dinero
35	Topaz Dinero
36	Opal Dinero
37	Amethyst Dinero
38	Minor Suerte
39	Major Suerte
40	Minor Requerido
41	Minor Gente
42	Minor Alimento
43	Minor Cosecha
44	Minor Tierra
45	Traicione
46	Minor Gordo
47	Minor Barrera
48	Historia
49	Minor Afortunado
50	Major Afortunado
51	Minor Estructura
52	Major Alimento
53	Major Cosecha
54	Major Tierra
55	Persiana
56	Major Gordo
57	Major Barrera
58	Regalo
59	Major Producto
60	Major Dinero
61	Grand Estructura
62	Grand Alimenter
63	Grand Cosecha
64	Grand Gente
65	Grand Tierra
66	Grand Requerido
67	Grand Barrera
68	Grand Producto
69	Grand Alimento
70	Grand Dinero



Ship Ids
--------
[[ select id,name,isnull((select '('+name+')' from race where race.id=ship_type.race),'') from ship_type order by id asc ]]
1	t.Ryu-jin	(Terran)
2	s.Viator	(Terran)
3	t.Maru	(Terran)
4	t.Sentouki	(Terran)
5	t.Garuda 	(Terran)
6	t.Kalieum	(Terran)
7	Light fighter-drone	
8	Light Corvette	
9	Light Frigate	
10	Small Strafez Fodder	
11	Large Strafez Fodder	
12	Small Strafez Runner	
13	Large Strafez Runner	
14	t.Empereur	(Terran)
15	c.Aries	
16	c.Gemini	
17	c.Taurus	
18	c.Cancer	
19	s.Viator II	(Terran)
20	p.Apollo	(Terran)
21	p.Odin	(Terran)
22	p.Thor	(Terran)
24	t.Nirvana	(Terran)
25	t.Chimaera	(Terran)
26	e.Eel	(Marauder)
27	e.Ray	(Marauder)
28	e.Piranha	(Marauder)
29	e.Barracuda	(Marauder)
30	e.Shark	(Marauder)
31	e.Pyth	(Marauder)
32	M.Lyth	(Aspha Miners)
33	M.Hal	(Aspha Miners)
34	M.Alium	(Aspha Miners)
35	M.Illite	(Aspha Miners)
36	M.Epidote	(Aspha Miners)
37	M.Chlor	(Aspha Miners)
38	M.Flysch	(Aspha Miners)
39	A.Aragonite	(Aspha Miners)
40	M.Lakko	(Aspha Miners)
41	A.Kryo	(Aspha Miners)
42	s.Seeker	(Aspha Miners)
43	s.Ranger	(Aspha Miners)
44	G.Livid	(Aspha Miners)
53	G.Livid (r)	(Aspha Miners)
54	g.Agate	(Guardian)
55	g.Amethyst	(Guardian)
56	g.Quartz	(Guardian)
57	L.Garnet	(Guardian)
58	g.Corundum	(Guardian)
59	L. Emerald	(Guardian)
60	g.Fluorite	(Guardian)
61	L.Topaz	(Guardian)
62	g.Diamond	(Guardian)
63	s.Lapiz	(Guardian)
64	s.Opal	(Guardian)
65	d.Hammerhead	(Marauder)
66	d.Bullhead	(Marauder)
67	d.Angel	(Marauder)
70	G.Lictor	(Aspha Miners)
71	t.Hercules	(Terran)
72	Strafez Queen	
73	f.Axe	
74	f.Sword	
75	f.Spear	
76	d.Pike	(Marauder)
77	K.Hun-Li	(Kal-Zul)
78	K.Hun-Xe 	(Kal-Zul)
79	k.Hun-Li	(Guardian)
80	k.Hun-Xe	(Guardian)
82	L.Tourmaline	(Guardian)
83	L.Ruby	(Guardian)
84	v.Borrelly	(Viral 106)
85	v.Chiron	(Viral 106)
86	s.Kohoutek	(Viral 106)
87	h.Pinnace	(Collective)
88	r.Sloop	(Collective)
89	h.Galleon	(Collective)
90	r.Schooner	(Collective)
91	h.Barkentine	(Collective)
92	K.Yang-Li	(Kal-Zul)
93	K.Yang-Xe	(Kal-Zul)
94	K.Wai-Li	(Kal-Zul)
95	K.Wai-Xe	(Kal-Zul)
96	K.Wei-Li	(Kal-Zul)
97	K.Wei-Xe	(Kal-Zul)
102	A.Hoko	(Aspha Miners)
104	h.Brigantine	(Collective)
105	r.Snow	(Collective)
106	h.ManOwar	(Collective)
107	e.Corral	(Marauder)
108	d.Fallen	(Marauder)
109	D.Angel	(Dark Marauder)
110	D.ArchAngel	(Dark Marauder)
111	D.Principalities	(Dark Marauder)
112	D.Dominions	(Dark Marauder)
113	m.Amber	(Metos)
114	m.Melanoph	(Metos)
115	m.Mellite	(Metos)
116	m.Oxammite	(Metos)
117	m.Wheatleyite 	(Metos)
118	m.Whewellite	(Metos)
119	d.Dominions	(Marauder)
120	r.Monitor	(Collective)
121	Ice.Hale	(Unknown)
122	HyperSpace Wall	(Unknown)
123 	HyperSpace Longboat	(Unknown)



System Ids
--------
[[ select id,name,'( Lvl '+lvl+' )' from planet_type ]]
0	Sol	( Lvl 1 )
1	Sol	( Lvl 2 )
2	Sol	( Lvl 3 )
3	Sol	( Lvl 4 )
4	Sol	( Lvl 5 )
5	Sol	( Lvl 6 )
6	Sol	( Lvl 7 )
7	Sol	( Lvl 8 )
8	Sol	( Lvl 9 )
9	Sol	( Lvl X )
10	Eden 	( Lvl 1 )
11	Eden	( Lvl 2 )
12	Eden	( Lvl 3 )
13	Eden	( Lvl 4 )
14	Eden	( Lvl 5 )
15	Eden	( Lvl 6 )
16	Eden	( Lvl 7 )
17	Eden	( Lvl 8 )
18	Eden	( Lvl 9 )
19	Eden	( Lvl X )
20	Farm	( Lvl 1 )
21	Farm	( Lvl 2 )
22	Farm	( Lvl 3 )
23	Farm	( Lvl 4 )
24	Farm	( Lvl 5 )
25	Farm	( Lvl 6 )
26	Farm	( Lvl 7 )
27	Farm	( Lvl 8 )
28	Farm	( Lvl 9 )
29	Farm	( Lvl X )
30	Rich	( Lvl 1 )
31	Rich	( Lvl 2 )
32	Rich	( Lvl 3 )
33	Rich	( Lvl 4 )
34	Rich	( Lvl 5 )
35	Rich	( Lvl 6 )
36	Rich	( Lvl 7 )
37	Rich	( Lvl 8 )
38	Rich	( Lvl 9 )
39	Rich	( Lvl X )
40	Capital	( Lvl 1 )
41	Capital	( Lvl 2 )
42	Capital	( Lvl 3 )
43	Capital	( Lvl 4 )
44	Capital	( Lvl 5 )
45	Capital	( Lvl 6 )
46	Capital	( Lvl 7 )
47	Capital	( Lvl 8 )
48	Capital	( Lvl 9 )
49	Capital	( Lvl X )
50	Heavy	( Lvl 1 )
51	Heavy	( Lvl 2 )
52	Heavy	( Lvl 3 )
53	Heavy	( Lvl 4 )
54	Heavy	( Lvl 5 )
55	Heavy	( Lvl 6 )
56	Heavy	( Lvl 7 )
57	Heavy	( Lvl 8 )
58	Heavy	( Lvl 9 )
59	Heavy	( Lvl X )
60	Dark	( Lvl 1 )
61	Dark	( Lvl 2 )
62	Dark	( Lvl 3 )
63	Dark	( Lvl 4 )
64	Dark	( Lvl 5 )
65	Dark	( Lvl 6 )
66	Dark	( Lvl 7 )
67	Dark	( Lvl 8 )
68	Dark	( Lvl 9 )
69	Dark	( Lvl 10 )
70	Dark	( Lvl 11 )
71	Dark	( Lvl 12 )
72	Dark	( Lvl 13 )
73	Dark	( Lvl 14 )
74	Dark	( Lvl 15 )
75	Dark	( Lvl 16 )
76	Dark	( Lvl 17 )
77	Dark	( Lvl 18 )
78	Dark	( Lvl 19 )
79	Dark	( Lvl XX )
80	Orion	( Lvl S )
100	Urania	( Lvl 1 )
101	Urania	( Lvl 2 )
102	Urania	( Lvl 3 )
103	Urania	( Lvl 4 )
104	Urania	( Lvl 5 )
105	Urania	( Lvl 6 )
106	Urania	( Lvl 7 )
107	Urania	( Lvl 8 )
108	Urania	( Lvl 9 )
109	Urania	( Lvl 10 )
110	Urania	( Lvl 11 )
111	Urania	( Lvl 12 )
112	Urania	( Lvl 13 )
113	Urania	( Lvl 14 )
114	Urania	( Lvl 15 )
115	Urania	( Lvl 16 )
116	Urania	( Lvl 17 )
117	Urania	( Lvl 18 )
118	Urania	( Lvl 19 )
119	Urania	( Lvl 20 )
120	Urania	( Lvl 21 )
121	Urania	( Lvl 22 )
122	Urania	( Lvl 23 )
123	Urania	( Lvl 24 )
124	Urania	( Lvl 25 )
125	Urania	( Lvl 26 )
126	Urania	( Lvl 27 )
127	Urania	( Lvl 28 )
128	Urania	( Lvl 29 )
129	Urania	( Lvl 30 )
130	Urania	( Lvl 31 )
131	Urania	( Lvl 32 )
132	Urania	( Lvl 33 )
133	Urania	( Lvl 34 )
134	Urania	( Lvl 35 )
135	Urania	( Lvl 36 )
136	Urania	( Lvl 37 )
137	Urania	( Lvl 38 )
138	Urania	( Lvl 39 )
139	Urania	( Lvl 40 )
140	Urania	( Lvl 41 )
141	Urania	( Lvl 42 )
142	Urania	( Lvl 43 )
143	Urania	( Lvl 44 )
144	Urania	( Lvl 45 )
145	Urania	( Lvl 46 )
146	Urania	( Lvl 47 )
147	Urania	( Lvl 48 )
148	Urania	( Lvl 49 )
149	Urania	( Lvl 50 )
150	Urania	( Lvl 51 )
151	Urania	( Lvl 52 )
152	Urania	( Lvl 53 )
153 Urania	( Lvl 54 )
154	Urania	( Lvl 55 )
155	Urania	( Lvl 56 )
156	Urania	( Lvl 57 )
157	Urania	( Lvl 58 )
158	Urania	( Lvl 59 )
159	Urania	( Lvl XX )
200	Titan	( Lvl 1 )
201	Titan	( Lvl 2 )
202	Titan	( Lvl 3 )
203	Titan	( Lvl 4 )
204	Titan	( Lvl 5 )
205	Titan	( Lvl 6 )
206	Titan	( Lvl 7 )
207	Titan	( Lvl 8 )
208	Titan	( Lvl 9 )
209	Titan	( Lvl 10 )
210	Titan	( Lvl 11 )
211	Titan	( Lvl 12 )
212	Titan	( Lvl 13 )
213 Titan	( Lvl 14 )
214	Titan	( Lvl 15 )
215	Titan	( Lvl 16 )
216	Titan	( Lvl 17 )
217	Titan	( Lvl 18 )
218 Titan	( Lvl 19 )
219	Titan	( Lvl 20 )
220	Titan	( Lvl 21 )
221	Titan	( Lvl 22 )
222	Titan	( Lvl 23 )
223	Titan	( Lvl 24 )
224	Titan	( Lvl 25 )
225	Titan	( Lvl 26 )
226	Titan	( Lvl 27 )
227	Titan	( Lvl 28 )
228	Titan	( Lvl 29 )
229	Titan	( Lvl 30 )
230	Titan	( Lvl 31 )
231	Titan	( Lvl 32 )
232	Titan	( Lvl 33 )
233	Titan	( Lvl 34 )
234	Titan	( Lvl 35 )
235	Titan	( Lvl 36 )
236	Titan	( Lvl 37 )
237	Titan	( Lvl 38 )
238	Titan	( Lvl 39 )
239	Titan	( Lvl XX )
123	Parthenon	( Lvl 4 )
132	Parthenon	( Lvl 13 )
133	Parthenon	( Lvl 14 )
134	Parthenon	( Lvl 15 )
136	Parthenon	( Lvl 17 )
138	Parthenon	( Lvl 19 )
139	Parthenon	( Lvl 20 )
142	Parthenon	( Lvl 23 )
145	Parthenon	( Lvl 26 )
146	Parthenon	( Lvl 27 )
147	Parthenon	( Lvl 28 )
149	Parthenon	( Lvl X )
400	Acheron	( Lvl 1 )
401	Acheron	( Lvl 2 )
402	Acheron	( Lvl 3 )
403	Acheron	( Lvl 4 )
404	Acheron	( Lvl 5 )
405	Acheron	( Lvl 6 )
406	Acheron	( Lvl 7 )
407	Acheron	( Lvl 8 )
408	Acheron	( Lvl 9 )
409	Acheron	( Lvl 10 )
410	Acheron	( Lvl 11 )
411	Acheron	( Lvl 12 )
412	Acheron	( Lvl 13 )
413	Acheron	( Lvl 14 )
414	Acheron	( Lvl 15 )
415	Acheron	( Lvl 16 )
416	Acheron	( Lvl 17 )
417	Acheron	( Lvl 18 )
418	Acheron	( Lvl 19 )
419	Acheron	( Lvl 20 )
420	Acheron	( Lvl 21 )
421	Acheron	( Lvl 22 )
422	Acheron	( Lvl 23 )
423	Acheron	( Lvl 24 )
424	Acheron	( Lvl 25 )
425	Acheron	( Lvl 26 )
426	Acheron	( Lvl 27 )
427	Acheron	( Lvl 28 )
428	Acheron	( Lvl 29 )
429	Acheron	( Lvl 30 )
430	Acheron	( Lvl 31 )
431	Acheron	( Lvl 32 )
432	Acheron	( Lvl 33 )
433	Acheron	( Lvl 34 )
434	Acheron	( Lvl 35 )
435	Acheron	( Lvl 36 )
436	Acheron	( Lvl 37 )
437	Acheron	( Lvl 38 )
438	Acheron	( Lvl 39 )
439	Acheron	( Lvl 40 )
440	Acheron	( Lvl 41 )
441	Acheron	( Lvl 42 )
442	Acheron	( Lvl 43 )
443	Acheron	( Lvl 44 )
444	Acheron	( Lvl 45 )
445	Acheron	( Lvl 46 )
446	Acheron	( Lvl 47 )
447	Acheron	( Lvl 48 )
448	Acheron	( Lvl 49 )
449	Acheron	( Lvl 50 )
450	Acheron	( Lvl 51 )
451	Acheron	( Lvl 52 )
452	Acheron	( Lvl 53 )
453	Acheron	( Lvl 54 )
454	Acheron	( Lvl 55 )
455	Acheron	( Lvl 56 )
456	Acheron	( Lvl 57 )
457	Acheron	( Lvl 58 )
458	Acheron	( Lvl 59 )
459	Acheron	( Lvl XX )
900	k. Rims	( Lvl S )
903	d. Rims	( Lvl S )
906	m. Rims	( Lvl S )
907	m. Base	( Lvl S )
20	Farm	( Lvl 1 )
21	Farm	( Lvl 2 )
22	Farm	( Lvl 3 )
23	Farm	( Lvl 4 )
24	Farm	( Lvl 5 )
25	Farm	( Lvl 6 )
26	Farm	( Lvl 7 )
27	Farm	( Lvl 8 )
28	Farm	( Lvl 9 )
29	Farm	( Lvl X )
30	Rich	( Lvl 1 )
31	Rich	( Lvl 2 )
32	Rich	( Lvl 3 )
33	Rich	( Lvl 4 )
34	Rich	( Lvl 5 )
35	Rich	( Lvl 6 )
36	Rich	( Lvl 7 )
37	Rich	( Lvl 8 )
38	Rich	( Lvl 9 )
39	Rich	( Lvl X )
40	Capital	( Lvl 1 )
41	Capital	( Lvl 2 )
42	Capital	( Lvl 3 )
43	Capital	( Lvl 4 )
44	Capital	( Lvl 5 )
45	Capital	( Lvl 6 )
46	Capital	( Lvl 7 )
47	Capital	( Lvl 8 )
48	Capital	( Lvl 9 )
49	Capital	( Lvl X )
50	Heavy	( Lvl 1 )
51	Heavy	( Lvl 2 )
52	Heavy	( Lvl 3 )
53	Heavy	( Lvl 4 )
54	Heavy	( Lvl 5 )
55	Heavy	( Lvl 6 )
56	Heavy	( Lvl 7 )
57	Heavy	( Lvl 8 )
58	Heavy	( Lvl 9 )
59	Heavy	( Lvl X )
60	Dark	( Lvl 1 )
61	Dark	( Lvl 2 )
62	Dark	( Lvl 3 )
63	Dark	( Lvl 4 )
64	Dark	( Lvl 5 )
65	Dark	( Lvl 6 )
66	Dark	( Lvl 7 )
67	Dark	( Lvl 8 )
68	Dark	( Lvl 9 )
69	Dark	( Lvl 10 )
70	Dark	( Lvl 11 )
71	Dark	( Lvl 12 )
72	Dark	( Lvl 13 )
73	Dark	( Lvl 14 )
74	Dark	( Lvl 15 )
75	Dark	( Lvl 16 )
76	Dark	( Lvl 17 )
77	Dark	( Lvl 18 )
78	Dark	( Lvl 19 )
79	Dark	( Lvl XX )
902	k. Home	( Lvl S )
905	d. Home	( Lvl S )
908	m. Home	( Lvl S )
909	x. Dead	( Lvl S )
911	x. White	( Lvl S )
901	k. Base	( Lvl S )
904	d. Base	( Lvl S )
910	x. Far	( Lvl S )
912	x. Black	( Lvl S )