Galaxy Legion Forum
http://galaxylegion.com/forum/

Enchanced Search/Filter for Planets
http://galaxylegion.com/forum/viewtopic.php?f=6&t=968
Page 1 of 1

Author:  QCubed [ Wed Jul 07, 2010 2:12 pm ]
Post subject:  Enchanced Search/Filter for Planets

Dan,

Could you enhance the search filter on the planets screen to have the ability to show the abundance of all planets which have a resource type? Either via a check-box or an additional search field for resources heading in the planet list please?

I work with SQL and assume you do too, so I imagine this might best be described using SQL Psudo-Code

Basically

Select Name, Size, Resource, Resource Availability

Where Resource = Research (Or Artifact, Or Mining, obviously)
AND Resource Availability > 0


I imagine you are doing some sort of Join to show this Data so the query would be a bit more complex, but I don't think it woudl be too hard, however on the web programming side of things I'm sure it could take a while, I'm not a Web Developer. ^^

Heh, however I think this would be a really useful feature for all members.

I think the easiest way (if you're entertaining me this far into my post) to implement this would be to use a simple check-box and radio buttons at the top of the resources column

CheckBox = Only Show Best Resource <---- Checked By Default on page visit
Radio Buttons = Mining, Artifact, Research <---- Greyed out or hidden and no effect unless Checkbox is unchecked.

I'm sure I'm not the only person who likes to reconfigure their planets to achieve goals..

Author:  webguydan [ Wed Jul 07, 2010 3:23 pm ]
Post subject:  Re: Enchanced Search/Filter for Planets

The search filter already takes into account many different things. Type in 'massive research', for instance, and it will filter all the research planets that are massive.

Author:  QCubed [ Thu Jul 08, 2010 4:59 am ]
Post subject:  Re: Enchanced Search/Filter for Planets

yes, I already do this,, however here is my problem, I have no way of looking through my planets using that filter to see what resources they provide at what availability except the resource with the highest availability.

I want to be able to see EVERY planet with Research, regardless of whether it is the best, second best or third best resource.

That is what my Suggestion is interested in.

I do very much like the filter but I'm looking to just make it a little more useful to someone liek myself who does not have many research planets, and woudl rather build more research on a planet that produces another resource for the time being, however I don't want to click through every planet in my list to try to make a spreadsheet to try to figure out which plants besides the obvious ones have research and at what availability.

Author:  Barracuda [ Thu Jul 08, 2010 9:44 am ]
Post subject:  Re: Enchanced Search/Filter for Planets

Quote bottom:
To the point: Instead of BEST resource, QCubed wants Best changed to user selected resource. So have a radio button to show only:
Mining Artifact OR Research resource stat.

QCubed wrote:
yes, I already do this,, however here is my problem, I have no way of looking through my planets using that filter to see what resources they provide at what availability except the resource with the highest availability.

I want to be able to see EVERY planet with Research, regardless of whether it is the best, second best or third best resource.

That is what my Suggestion is interested in.

I do very much like the filter but I'm looking to just make it a little more useful to someone liek myself who does not have many research planets, and woudl rather build more research on a planet that produces another resource for the time being, however I don't want to click through every planet in my list to try to make a spreadsheet to try to figure out which plants besides the obvious ones have research and at what availability.

Author:  QCubed [ Thu Jul 08, 2010 6:43 pm ]
Post subject:  Re: Enchanced Search/Filter for Planets

Barracuda wrote:
Quote bottom:
To the point: Instead of BEST resource, QCubed wants Best changed to user selected resource. So have a radio button to show only:
Mining Artifact OR Research resource stat.


Quote for Truth! Thank you for saying that a bit more succinctly. ^^

~Q

Author:  ODragon [ Wed Jul 21, 2010 1:56 pm ]
Post subject:  Re: Enchanced Search/Filter for Planets

I just posted (and deleted after finding this):

Quote:
I would love to see something like check boxes next to some of the boxes so we can filter multiple ways.

Size (Check Box Choices): Any, Tiny, Small, Average, Large, etc
Planet Status (Radial Choices): Unoccupied, Enemy Planet, Your Planet, Legion Planet,
Mining (Check Box Choices): Insert values
Research (Check Box Choices): Insert values
Artifact (Check Box Choices): Insert values
Recently Scanned? (Check Box)
Submit button to filter

IE: Unoccupied, Recently Scanned, Large or better (then you can sort by best resource)

Author:  ODragon [ Wed Jul 21, 2010 1:58 pm ]
Post subject:  Re: Enchanced Search/Filter for Planets

webguydan wrote:
The search filter already takes into account many different things. Type in 'massive research', for instance, and it will filter all the research planets that are massive.

Cool, then "Filter Planet by Name" is probably bad text for this. I thought it was just for finding a planet by name.

Author:  ODragon [ Wed Jul 21, 2010 2:07 pm ]
Post subject:  Best Resource Sort

When a planet has two or three resources that are the same (ie, abundant research and abundant artifacts), I am only seeing the abundant artifact. Is there something that can be done so that we don't have to look at every planet to make sure there aren't equal?

One idea I had was break up the best resource column into 3 columns, one for each resource, then have a number between 0 and however many choices there are. Hovering over the column could say what the numbers designate to save space. We could sort this way. Maybe even include a secondary sort so we can find the best research planet with the best mining or artifact production.

0 = No resource
1 = Extremely Sparse
2 = Very Sparse
3 = Sparse
4 = Average
5 = Abundant
etc

Author:  zophah [ Wed Jul 21, 2010 7:09 pm ]
Post subject:  Re: Enchanced Search/Filter for Planets

under this same system, you could order planets based on total score.

Author:  QCubed [ Wed Jul 21, 2010 8:56 pm ]
Post subject:  Re: Best Resource Sort

ODragon wrote:
When a planet has two or three resources that are the same (ie, abundant research and abundant artifacts), I am only seeing the abundant artifact. Is there something that can be done so that we don't have to look at every planet to make sure there aren't equal?

One idea I had was break up the best resource column into 3 columns, one for each resource, then have a number between 0 and however many choices there are. Hovering over the column could say what the numbers designate to save space. We could sort this way. Maybe even include a secondary sort so we can find the best research planet with the best mining or artifact production.

0 = No resource
1 = Extremely Sparse
2 = Very Sparse
3 = Sparse
4 = Average
5 = Abundant
etc



Yes that would be great, I just assumed Dan didn't wan to change the 'look' of the page.

He already embeds this info for sorting (you can find it if you copy the list of planets and paste it in a text file)

Values run as follows:

0 = None
1 = eSparse
2 = vSparse
3 = Sparse
4 = Averge
5 = Abundant
6 = vAbundant
7 = eAbundant
8 = Rich
9 = vRich
10 = eRich
11 = Ultra Rich
12 = Mega Rich
13 = (Some say) 1x Mega Rich
14 = 2x Mega Rich
I have not seen beyond here so I cannot say for certain but I assume it continues at 1x or 2x points per level..

either 15,16,17,18 = 3x,4x,5x,6x or 16,18,20,22 = 3x,4x,5x,6x

Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/