"); include("includes_01/header_04_no_menu.php"); echo ("

The WorldAirPics.com server appears to be down, please refresh this page or try again later. WorldAirPics.com apologises for this interruption.

"); include("includes_01/footer_01.php"); echo (""); // bah, modify the "Not Found" error for your needs. exit(); } if (!(@mysql_select_db($db_name))) // If can't connect to database, error and exit(). { echo(" "); include("includes_01/header_04_no_menu.php"); echo ("

The WorldAirPics.com server appears to be down, please refresh this page or try again later. WorldAirPics.com apologises for this interruption.

"); include("includes_01/footer_01.php"); echo (""); // bah, modify the "Not Found" error for your needs. exit(); } if ($turn_website_on != 'yes') // Check if website is turned on or off, error and exit(). { echo(" "); include("includes_01/header_04_no_menu.php"); echo ("

The $website_name_01 has been turned off for maintenance, please try again later. $website_name_01 apologises for this interruption.

"); include("includes_01/footer_01.php"); echo (""); // bah, modify the "Not Found" error for your needs. exit(); } //**********Referrer********** $ref = @$_SERVER['HTTP_REFERER']; $ip = @$_SERVER['REMOTE_ADDR']; $useragent = @$_SERVER['HTTP_USER_AGENT']; $requested_page = "$PHP_SELF?q=$var&u=$var2&sort=$sort_var"; //**********Last Page Visited********** // Function to generate random string function randomstring($chars) { srand((double) microtime() * 1000000); $allowchars = '0123456789'; while(++$n < ($chars+1)) $freturn .= $allowchars[rand(0, strlen($allowchars)-1)]; return $freturn; } $random = randomstring("5"); $current_time = time(); $trimmed_time = substr($current_time, 5); $random_id = "$trimmed_time$random"; //$question_mark = "?"; //$string = $_SERVER['QUERY_STRING']; //$page_name = "$page_name$question_mark$string"; $query_redirect = "insert into airpics_logging_redirect (redirect_url, unique_id, timestamp) VALUES ('$page_name', '$random_id', NOW())"; //echo "$current_time
"; //echo "$page_name
"; //echo "$trimmed_time
"; //echo "$random_id"; $result_redirect = mysql_query($query_redirect); if (!isset($result_redirect)) { echo ("Error in query.
Please go back and try again."); //exit(); } //**********Start Referer Link Script********** if ($ref != '') { //Browser Check if (preg_match('|MSIE ([0-9].[0-9]{1,2})|',$useragent,$matched)) { $browser_version=$matched[1]; $browser = 'Internet Explorer'; } elseif (preg_match('|Netscape ([0-9].[0-9]{1,2})|',$useragent,$matched)) { $browser_version=$matched[1]; $browser = 'Netscape'; } elseif (preg_match( '|Opera ([0-9].[0-9]{1,2})|',$useragent,$matched)) { $browser_version=$matched[1]; $browser = 'Opera'; } elseif(preg_match('|Firefox/([0-9\.]+)|',$useragent,$matched)) { $browser_version=$matched[1]; $browser = 'Firefox'; } elseif(preg_match('|Safari/([0-9\.]+)|',$useragent,$matched)) { $browser_version=$matched[1]; $browser = 'Safari'; } else { // browser not recognized! //$browser_version = 0; $browser= 'Other Browser'; } //OS Check //$useragent = $_SERVER['HTTP_USER_AGENT']; if (strstr($useragent,'Win')) { $os='Windows'; } else if (strstr($useragent,'Mac')) { $os='Macintosh'; } else if (strstr($useragent,'Linux')) { $os='Linux'; } else if (strstr($useragent,'Unix')) { $os='Unix'; } else { $os='Other'; } $referrer_query = "insert into airpics_search_page_stats (requested_page, referring_url, browser, ip_address, operating_system, time) VALUES ('$requested_page', '$ref', '$browser $browser_version', '$ip', '$os', NOW())"; $referrer_result = mysql_query($referrer_query); if (!isset($referrer_result)) { echo ("Error in query.
Please go back and try again."); //exit(); } } //**********End Referer Link Script********** //**********Sort Script********** $sort_var = @$_GET['sort'] ; $type_var = @$_GET['t'] ; //$type_var_01 = $type_var; if ($type_var == '' || $type_var == 'A') { $type_var = ("A"); $type_var_01 = ("A"); $type_search = " and type like '$type_var%'"; } else if ($type_var == 'All' || $type_var == '%') { $type_var = ("%"); $type_var_01 = ("All"); $type_search = " and type like '$type_var%'"; } else { $type_var_01 = ("$type_var"); $type_search = " and type like '$type_var%'"; } if ($sort_var == 'pics_low_high') { $sort_query = (" ORDER BY count ASC"); } else if ($sort_var == 'pics_high_low') { $sort_query = (" ORDER BY count DESC"); } else if ($sort_var == 'type_a_z' || $sort_var == '') { $sort_query = (" ORDER BY type ASC"); } else if ($sort_var == 'type_z_a') { $sort_query = (" ORDER BY type DESC"); } $limit = @$_GET['limit'] ; if ($limit == '') { $limit = 250; // Default results per-page. } else { $limit = $limit; // Default results per-page. } if (!($page)) { $page = 0;} // Default page value. // Pager Script. include("pagination/pager_class_01.php"); $pager = new pager; $pager->sql = "SELECT TYPE, clean_type, COUNT(*) AS count FROM $pictures_table WHERE display_picture='yes' and TYPE <> '-' and TYPE <> ' ' and TYPE <> '' AND TYPE <> 'Unknown' AND category = 'general' and subtype <> 'Glider' and picture_category <> 'Glider' and subtype2 <> 'Glider' and picture_category <> 'Balloon' and subtype2 <> 'Balloon' and picture_category <> 'Airship' and subtype2 <> 'Airship' $type_search GROUP BY type $sort_query"; $result = $pager->get_page_result(); // result set $numrows = $pager->get_page_num_rows(); // number of records in result set $nav_links = $pager->navigation(" ", "currentStyle"); // the navigation links (define a CSS class selector for the current link) $nav_info = $pager->page_info("to"); // information about the number of records on page ("to" is the text between the number) $simple_nav_links = $pager->back_forward_link(false); // the navigation with only the back and forward links, use true to use images $total_recs = $pager->get_total_rows(); // the total number of records $page_info = $pager->page_info(); $curr_pages = $pager->navigation(); //echo $numrows; ?> , airliners, aviation photography, airshows, air show, air force, propliners, photos"> Aviation Photography Website, pictures and photos of ">

You are not logged in. Please Login or Register

Full list of all General Aviation Pictures on WorldAirPics.com except for Gliders, Balloons & Airships. Aircraft are listed alphabetically by the Manufacturer's name. The list can be sorted by Aircraft Name or Picture Count. = '250') { echo (" "); //} ?> = '250') { echo (" "); //} ?> Type Beginning With: &t=A">A'; } else { echo 'A'; } ?> &t=B">B'; } else { echo 'B'; } ?> &t=C">C'; } else { echo 'C'; } ?> &t=D">D'; } else { echo 'D'; } ?> &t=E">E'; } else { echo 'E'; } ?> &t=F">F'; } else { echo 'F'; } ?> &t=G">G'; } else { echo 'G'; } ?> &t=H">H'; } else { echo 'H'; } ?> &t=I">I'; } else { echo 'I'; } ?> &t=J">J'; } else { echo 'J'; } ?> &t=K">K'; } else { echo 'K'; } ?> &t=L">L'; } else { echo 'L'; } ?> &t=M">M'; } else { echo 'M'; } ?> &t=N">N'; } else { echo 'N'; } ?> &t=O">O'; } else { echo 'O'; } ?> &t=P">P'; } else { echo 'P'; } ?> &t=Q">Q'; } else { echo 'Q'; } ?> &t=R">R'; } else { echo 'R'; } ?> &t=S">S'; } else { echo 'S'; } ?> &t=T">T'; } else { echo 'T'; } ?> &t=U">U'; } else { echo 'U'; } ?> &t=V">V'; } else { echo 'V'; } ?> &t=W">W'; } else { echo 'W'; } ?> &t=X">X'; } else { echo 'X'; } ?> &t=Y">Y'; } else { echo 'Y'; } ?> &t=Z">Z'; } else { echo 'Z'; } ?> &t=All">All'; } else { echo 'All'; } ?>     Complete list of aircraft types"; } else { echo "Aircraft type beginning with \"$type_var_01\""; } ?>   "); echo $nav_links; echo ("     "); } else { echo (" "); } ?> There are no aircraft beginning with $type_var_01 in this list.   "); if ($sort_var == 'type_a_z' || $sort_var == '') { echo "Aircraft Type"; } else if ($sort_var == 'type_z_a') { echo "Aircraft Type"; } else { echo "Aircraft Type"; } echo(" "); if ($sort_var == 'pics_high_low') { echo "Picture Count"; } else if ($sort_var == 'pics_low_high') { echo "Picture Count"; } else { echo "Picture Count"; } echo("   "); echo $nav_links; echo ("

This page was created in ".$totaltime." seconds"; ?>