Detailed Airport Information Page

Have a look at the new airport information page which you can view by clicking on any airport identifier in the game. I gave it a new table design, and added a map of all routes out of that city.

Bit by bit, we're improving.

Looking good

I'd like to integrate that map into more and more of the site. It really brings out the visualization of an airline's success or failure and adds a lot to the game.

Sigh... I guess now we'll get to see how long it takes for that to be copied as well.

Looking good

Yep. Looks nice.

What a great revision. The map of routes of of the city is outstanding!

Sigh... I guess now we'll get to see how long it takes for that to be copied as well.

Spy's are out looking at the good work Miller

I'd like to integrate that map into more and more of the site. It really brings out the visualization of an airline's success or failure and adds a lot to the game.

Sigh... I guess now we'll get to see how long it takes for that to be copied as well.

Part of the evolution process i guess. But no doubt, if they gotta copy AE, really makes u wonder if they actually think for themselves then :puzzled:

Sigh... I guess now we'll get to see how long it takes for that to be copied as well.

Imitation is the most sincere form of flattery

Yeah I know that doesn't really help

Nice job on the city pages, anyway we can get the routes from the city clickable so we can see the route page?

Update: Now that there are more airlines in I can see what's going on, I guess it's just not displaying correctly in firefox

Why does it sometimes have cities listed twice? Like on there it has LAX 65 times and LAX under it with 49 more. Is one to and one from? If so, it would be easier to have just destinations served FROM the airport, as opposed to both.

It's because some cities are listed as origins, and some are listed as destinations. I was unable to group them together based on the calculations being completed at the database level.

I'd like to integrate that map into more and more of the site. It really brings out the visualization of an airline's success or failure and adds a lot to the game.

Sigh... I guess now we'll get to see how long it takes for that to be copied as well.

Miller, the only intellectual property behind this are your calculations. No?

And even that is difficult to define as intellectual property, which is difficult to define at all. I left a post on one of the other threads that talks about it. Can't remember where, though.

It's because some cities are listed as origins, and some are listed as destinations. I was unable to group them together based on the calculations being completed at the database level.

SELECT (SELECT sum( *frequency col*) OR count(*some col*) FROM *route table* WHERE (*route_arrive == airport id))+(SELECT sum(*frequency col*) OR count(*some col*) FROM *route table* WHERE (*route_dep == airport_id)) AS `totcount`, `airport name`, `airport code...`, `etc`. FROM *airport table* WHERE EXISTS (SELECT 1 FROM *route table* WHERE *route_arrive* = $city OR *route_depart* = $city) ORDER BY `totcount` DESC, *secondary orderby; airport name?*, *tertiary orderby you get the drift*

(whoops. here. let me improve this rough query a moment. there. that should pull every city that flies into or out of $city, along with total frequency or total count of those routes (in+out))

should combine the two, while making it one query with the airport name, etc., and yes you can orderby an alias... you just can't do anything sooner by the alias it seems because mysql is dumb like that.