when i click on my alliance Freakin Awesome Alliance this comes up under and right above the alliance bases:
Alliance Information
Name Freakin' Awesome Alliance
Founded By Lux Carriers
Founded On 12 May, 1994
Membership Type Restricted Membership
Maximum Alliance Flights 25
Recent Votes
Proposed By Vote Type
MaidenAir Entry Petition View Results
American Airlines Entry Petition View Results
View All Votes
Alliance Bases
Alliance Base Current Alliance Flights
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/airlinemogul.com/httpdocs/airlinemogul/view_alliance.php on line 207
SELECT `ap`.`airport_code` , `ap`.`airport_name` , ( SELECT count( `route_id` ) FROM `zworld12_route` AS `r` WHERE `alliance_rt` = 6 AND `r`.`from_id` = `ap`.`airport_id` AND NOT EXISTS ( SELECT 1 FROM `zworld12_airline_gates` AS `a` WHERE `a`.`user_id` = `r`.`user_id` AND `a`.`airport_id` = `r`.`from_id` AND ( `is_hub` =1 OR `is_base` =1 OR `is_focus` >0 ) ) ) AS `present` FROM `zworld12_airport` AS `ap` WHERE `airport_id` IN (SELECT `airport_id` FROM `zworld12_airline_gates` AS `ag` WHERE `alliance` =6 AND ( `is_hub` =1 OR `is_base` =1 OR `is_focus` >0 )) ORDER BY `ap`.`airport_name` ASC
thanks lux carriers
