Mostly Harmless

File Release Notes and Changelog

Release Name: Mostly Harmless 0.1.1

Notes:
Mostly Harmless Celestia SQL database patch v0.1.1

Tutorial :

Here is a quick tutorial of how to use the SQL console once Mostly Harmless is running. 

Press Ctrl+Enter to bring up the mySQL console. In this mode you can type any SQL statement.

Here is a simple statement, type the following:
	SELECT pi();
Note that you must have the semicolon on the end to execute the SQL statement.
If a statement is long it can be split up with the enter key.

Press Ctrl+Enter to go back to the SQL console.

Ctrl+A  This brings up the first part of a statement that will Mark/Unmark (toggle) the selected stars. 

You should see the following:
mysql> SELECT hip FROM star 

Complete the statement like so and press enter.
mysql> SELECT hip FROM star WHERE spectralClass='M' AND distFromSol<10;
The selected stars will be marked with little green squares.
Star marking can take some time so there is a limit to how many can be marked.
This limit is specified in celestia.cfg and can be changed if desired.

Bring up the console again and press [Ctrl+Z].
This brings up the last statement which is useful for fixing an error or unmarking stars.
Press enter to unmark the stars.

At startup MH only displays the 100,000 stars that come with celestia. 
If you have generated the database using one of Pascal Hartmann's larger stars.dat file then
you can display all of the stars by doing the following.

Bring up the console and press [Ctrl+S]. This enters the first part of a statement
that will select which stars are displayed by celestia.
To display all the stars simply complete the statement with a ; and press enter.
This query will take a little while so be patient. 

To go back to the default database:
	[Ctrl+Enter]
	[Ctrl+S]
Then type
	WHERE hip < 1000000;
	[Enter]

In the console Ctrl+Q,W,E,R,T,Y,U,I  will bring up some pre-set statements to play with. 

The console also has windows copy and paste capability.
Ctrl+X,C,V

In summary
Ctrl+Enter		Bring up the console.
Ctrl+Z 			last statement
Ctrl+A			mark/unmark stars
Ctrl+S			select stars
Ctrl+Q,W,E,R,T,Y,U,I  	preset statements.
Ctrl+X			Cut to clipboard
Ctrl+C			Copy to clipboard
Ctrl+V			Paste from clipboard


SQL is very powerful and im sure that people will be able to come up with some very interesting statements.
If your interested in learning more about SQL have a read of chapter 4 of the MySQL reference manual.
http://www.mysql.com

Lastly. I have replaced the WWWinfo for a star with data from the database. Right click on a star and click Info to bring up all the info in a star's row.


Please post feedback to the mostly harmless forum.
http://mostlyharmless.sourceforge.net/mhforum

Or to the relavent Celestia forum thread.

Changelog :
http://mostlyharmless.sourceforge.net/mhforum/viewtopic.php?p=82#82

Credits : 
http://mostlyharmless.sourceforge.net/mhforum/viewtopic.php?t=32

Enjoy. 


http://mostlyharmless.sourceforge.net





Changes: