0 ) { $l_base_url = $l_base_url . "&p_image_category=$p_image_category"; } if ( $p_aircraft_id > 0 ) { $l_base_url = $l_base_url . "&p_aircraft_id=$p_aircraft_id"; } if ( $p_user_id > 0 ) { $l_base_url = $l_base_url . "&p_user_id=$p_user_id"; } return $l_base_url; } function get_base_url_category ( $a_category ) { global $p_user_id; global $p_aircraft_id; global $p_image_size; $l_base_url = "image_browser.html?p_image_category=$a_category"; if ( $p_aircraft_id > 0 ) { $l_base_url = $l_base_url . "&p_aircraft_id=$p_aircraft_id"; } if ( $p_user_id > 0 ) { $l_base_url = $l_base_url . "&p_user_id=$p_user_id"; } if ( $p_image_size > 0 ) { $l_base_url = $l_base_url . "&p_image_size=$p_image_size"; } return $l_base_url; } function display_browse_bar () { global $l_result; global $l_base_url; global $l_images_per_page; global $l_result_count; global $l_recent_start; $l_start_page = 1; $l_total_pages = floor ( $l_result_count / $l_images_per_page ) + 1; $l_current_page = floor ( $l_recent_start / $l_images_per_page ) + 1; if ( $l_result_count > 0 ) { ?> Page ( in total) : 1 ) { printf ( "  <<  " ); } $l_pages = $l_total_pages; if ( $l_pages > ( $l_start_page + 10 ) ) { $l_pages = $l_start_page + 10; } for ( $l_temp = $l_start_page; $l_temp <= $l_pages; $l_temp += 1 ) { $l_offset = ( $l_temp - 1 ) * $l_images_per_page; $l_marker1 = ' '; $l_marker2 = ' '; if ( $l_offset == $l_recent_start ) { $l_marker1 = '['; $l_marker2 = ']'; } printf ( " %s %d %s ", $l_offset, $l_marker1, $l_temp, $l_marker2 ); } if ( $l_temp < ( $l_result_count / $l_images_per_page ) ) { printf ( "  >>  ", $l_result_count - $l_images_per_page ); } ?> 0 ) { $l_temp = $l_recent_start - $l_images_per_page; if ( $l_temp < 0 ) $l_temp = 0; printf ( "[ < Prev ] ", $l_temp ); } $l_pages = floor ( $l_result_count / $l_images_per_page ); $l_temp = $l_recent_start + $l_images_per_page; if ( $l_temp <= ( $l_pages * $l_images_per_page ) ) { printf ( "[ Next > ] ", $l_temp ); } ?> fetch_array(MYSQLI_ASSOC) ) ) { $l_aircraft_id = $l_row [ 'aircraft_id' ]; $l_aircraft_model = $l_row [ 'name' ]; $l_manufacturer_name = $l_row [ 'manufacturer_name' ]; $l_user_id = $l_row [ 'user_id' ]; $l_username = $l_row [ 'user_name' ]; $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 ( "" ); //echo ( "" ); echo ( "" ); echo ( "" ); echo ( "" ); echo ( "" ); echo ( "\n" ); $l_column_count = $l_column_count + 1; } ?>
Hangar Aircraft Category Date Preview
$l_username
$l_username$l_manufacturer_name $l_aircraft_model$l_image_category$l_date_added" ); echo ( "
Views : $l_image_view_count
$l_image_comment

Browse Images

0 ) { $p_search_params = "and i.image_category_id = $p_image_category "; $l_base_url = $l_base_url . "&p_image_category=$p_image_category"; } if ( $p_aircraft_id > 0 ) { $p_search_params = $p_search_params . " and a.id = $p_aircraft_id "; $l_base_url = $l_base_url . "&p_aircraft_id=$p_aircraft_id"; } if ( $p_user_id > 0 ) { $p_search_params = $p_search_params . " and u.id = $p_user_id "; $l_base_url = $l_base_url . "&p_user_id=$p_user_id"; } if ( $p_image_size > 0 ) { $l_base_url = $l_base_url . "&p_image_size=$p_image_size"; } $l_sql = "select i.id, a.id aircraft_id, a.name name, u.id user_id, u.username user_name, " . " DATE_FORMAT(i.date_added, '$c_app_format_datetime' ) date_added, " . " ic.name image_category, i.comment, m.name manufacturer_name, i.view_count ". "from user_aircraft_images i, user_aircraft ua, aircraft a, " . " user u, image_category ic, manufacturer m " . "where ua.id = i.user_aircraft_id " . "and a.id = ua.aircraft_id " . "and u.id = ua.user_id " . "and m.id = a.manufacturer_id " . "and ic.id = i.image_category_id " . "$p_search_params" . "and i.status = 1 " . "order by i.date_added desc "; $l_result = $l_connection -> query ( $l_sql ) or die ( "Unble to read latest additions." ); $l_result_count = $l_result -> num_rows; if (( $l_result_count > 0 ) && ( $l_recent_start < $l_result_count)) { $l_result -> data_seek ( $l_recent_start ); } ?>
Image Browser ( Small / Large ) Show : All | Parked | Flying | Build | Aerial | Reference