query ( $l_sql ) or die ( "Unble to read image count." ); $l_row = $l_result -> fetch_array(MYSQLI_ASSOC); $l_image_count = $l_row [ 'image_count' ]; $l_sql = "select count(*) aircraft_count " . "from user_aircraft ua, user u " . "where ua.status=1 " . "and u.id = ua.user_id " . "and u.status=1"; $l_result = $l_connection -> query ( $l_sql ) or die ( "Unble to read aircraft count." ); $l_row = $l_result -> fetch_array(MYSQLI_ASSOC); $l_aircraft_count = $l_row [ 'aircraft_count' ]; $l_sql = "select id " . "from user_aircraft_images " . "where status = 1 " . "ORDER BY RAND() LIMIT 4"; $l_result = $l_connection -> query ( $l_sql ) or die ( "Unble to read image count." ); $l_row = $l_result -> fetch_array(MYSQLI_ASSOC); $l_random_image_id = $l_row [ 'id' ]; ?>

Welcome to the 0 ) { echo ( ", " . $_SESSION [ 'g_firstname' ] ); } } ?>!

Virtual Aerodrome is coming out of the closet! For the past 5 years this site has been running out of a closet in my condo, but the time has come to move it to a true data-center. Please excuse us for any problems. Hopefully it'll go smoothly." ); ?>

query ( $l_sql ) or die ( "Unble to read user login count." ); $l_row = $l_result -> fetch_array(MYSQLI_ASSOC); $l_login_count = $l_row [ 'logincount' ]; } if ( $l_login_count == 0 ) { ?>

First time user please read this :

Welcome to your first time on VirtualAerodrome.com! The first thing you should do is tell the system which aircraft you have in your collection so it knows which aircraft you have pictures for. If you don't do this, you won't be able to upload any images. Click here to tell the system which aircraft you have; don't forget to click 'Save' once you've selected your aircraft.

query ( $l_sql ) or die ( "Unble to read random images." ); $l_row = $l_result -> fetch_array(MYSQLI_ASSOC); $l_random_image_id = $l_row [ 'id' ]; while ( $l_row = $l_result -> fetch_array(MYSQLI_ASSOC) ) { $l_random_image_id = $l_row [ 'id' ]; echo ( "" ); } ?>

Random Images

" . "

query ( $l_sql ) or die ( "Unble to read latest additions." ); $l_counter = 0; while ( $l_row = $l_result -> fetch_array(MYSQLI_ASSOC) ) { $l_aircraft_model = $l_row [ 'name' ]; $l_aircraft_id = $l_row [ 'aircraft_id' ]; $l_manufacturer_name = $l_row [ 'manufacturer_name' ]; $l_username = $l_row [ 'user_name' ]; $l_user_id = $l_row [ 'user_id' ]; $l_date_added = $l_row [ 'date_added' ]; $l_image_id = $l_row [ 'id' ]; $l_image_category = $l_row [ 'image_category' ]; $l_image_comment = $l_row [ 'comment' ]; $l_image_view_count = $l_row [ 'view_count' ]; $l_image_comment = clickable_link ( $l_image_comment ); if ( $l_counter == 0 ) { $l_bgcolor = "dialog1"; $l_counter = 1; } else { $l_bgcolor = "dialog2"; $l_counter = 0; } echo ( "\r" ); echo ( "\r" ); echo ( "\r" ); echo ( "\r" ); echo ( "\r" ); echo ( "\r\r" ); } ?>

Recent Additions
Hangar	Aircraft	Category	Date	Preview
$l_username	$l_manufacturer_name $l_aircraft_model	$l_image_category	$l_date_added View Build Thread	\r" ); echo ( "
Image views : $l_image_view_count
$l_image_comment
[ Next > ]