"); 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'] ; $reg_var = @$_GET['r'] ; $reg_var_01 = $reg_var; if ($reg_var == '' || $reg_var == '0') { $reg_var = ("0"); $reg_search = " and reg like '$reg_var%'"; } else if ($reg_var == 'All') { $reg_var = ("%"); $reg_search = " and reg like '$reg_var%'"; } else { $reg_search = " and reg like '$reg_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_query = (" ORDER BY type ASC"); } else if ($sort_var == 'type_z_a') { $sort_query = (" ORDER BY type DESC"); } else if ($sort_var == 'code_number_low_hi') { $sort_query = (" ORDER BY code_number ASC"); } else if ($sort_var == 'code_number_hi_low') { $sort_query = (" ORDER BY code_number DESC"); } else if ($sort_var == 'reg_high_low') { $sort_query = (" ORDER BY reg DESC"); } else if ($sort_var == 'reg_low_high' || $sort_var == '') { $sort_query = (" ORDER BY reg ASC"); } $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_02.php"); $pager = new pager; $pager->sql = "SELECT reg, TYPE, clean_type, code_number, COUNT(*) AS count FROM $pictures_table WHERE display_picture='yes' and TYPE <> '-' and TYPE <> ' ' and TYPE <> '' AND TYPE <> 'Unknown' and reg <> '-' and reg <> ' ' and reg <> '' AND reg <> 'Unknown' $reg_search GROUP BY reg $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(); ?> , 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 Aircraft Registrations on WorldAirPics.com. Registrations are listed alphabetically / numerically. The list can be sorted by Aircraft Registration, Code Number, Aircraft Name or Picture Count. = '250') { echo (" "); //} ?> = '250') { echo (" "); //} ?> Reg Beginning With: &r=0">0'; } else { echo '0'; } ?> &r=1">1'; } else { echo '1'; } ?> &r=2">2'; } else { echo '2'; } ?> &r=3">3'; } else { echo '3'; } ?> &r=4">4'; } else { echo '4'; } ?> &r=5">5'; } else { echo '5'; } ?> &r=6">6'; } else { echo '6'; } ?> &r=7">7'; } else { echo '7'; } ?> &r=8">8'; } else { echo '8'; } ?> &r=9">9'; } else { echo '9'; } ?> &r=A">A'; } else { echo 'A'; } ?> &r=B">B'; } else { echo 'B'; } ?> &r=C">C'; } else { echo 'C'; } ?> &r=D">D'; } else { echo 'D'; } ?> &r=E">E'; } else { echo 'E'; } ?> &r=F">F'; } else { echo 'F'; } ?> &r=G">G'; } else { echo 'G'; } ?> &r=H">H'; } else { echo 'H'; } ?> &r=I">I'; } else { echo 'I'; } ?> &r=J">J'; } else { echo 'J'; } ?> &r=K">K'; } else { echo 'K'; } ?> &r=L">L'; } else { echo 'L'; } ?> &r=M">M'; } else { echo 'M'; } ?> &r=N">N'; } else { echo 'N'; } ?> &r=O">O'; } else { echo 'O'; } ?> &r=P">P'; } else { echo 'P'; } ?> &r=Q">Q'; } else { echo 'Q'; } ?> &r=R">R'; } else { echo 'R'; } ?> &r=S">S'; } else { echo 'S'; } ?> &r=T">T'; } else { echo 'T'; } ?> &r=U">U'; } else { echo 'U'; } ?> &r=V">V'; } else { echo 'V'; } ?> &r=W">W'; } else { echo 'W'; } ?> &r=X">X'; } else { echo 'X'; } ?> &r=Y">Y'; } else { echo 'Y'; } ?> &r=Z">Z'; } else { echo 'Z'; } ?> &r=All">All'; } else { echo 'All'; } ?>     Complete list of aircraft registrations"; } else { echo "Aircraft registration beginning with \"$reg_var\""; } ?>   "); echo $nav_links; echo ("     "); } else { echo (" "); } ?> There are no aircraft beginning with $type_var_01 in this list.   "); if ($sort_var == 'reg_low_high' || $sort_var == '') { echo "Registration"; } else if ($sort_var == 'reg_high_low') { echo "Registration"; } else { echo "Registration"; } echo(" "); if ($sort_var == 'code_number_low_hi') { echo "Code Number"; } else if ($sort_var == 'code_number_hi_low') { echo "Code Number"; } else { echo "Code Number"; } echo(" "); if ($sort_var == 'type_a_z') { 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"; ?>