\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
0) { $photo_time = " - " . $photo_hour . ":" . $photo_minute; } // Add view $current_time = $row_photo["time2"]; $views = $row_photo["views"] + 1; $sql_photo2 = "UPDATE photo SET views='$views',time='$current_time' WHERE pht_id = $pht_id"; $result_photo2 = mysql_query($sql_photo2); $file_size_kb = $row_photo["size"] / 1024; $file_size_kb = round($file_size_kb, 2); $pht_id = $row_photo["pht_id"]; $series_id = $row_photo["pht_srs_id"]; $sql_series = "SELECT *, UNIX_TIMESTAMP(time) as time FROM photo_series WHERE pht_srs_id = $series_id"; $result_series = mysql_query($sql_series); $row_series = mysql_fetch_array($result_series); $regio_id = $row_photo["pht_rg_id"]; $sql_region = "SELECT * FROM photo_region WHERE pht_rg_id = $regio_id"; $result_region = mysql_query($sql_region); $row_region = mysql_fetch_array($result_region); $cmr_tp_id = $row_photo["cmr_tp_id"]; $sql_camtype = "SELECT * FROM camera_type WHERE cmr_tp_id = $cmr_tp_id"; $result_camtype = mysql_query($sql_camtype); $row_camtype = mysql_fetch_array($result_camtype); $lns_tp_id = $row_photo["lns_tp_id"]; $sql_lens = "SELECT * FROM lens_type WHERE lns_tp_id = $lns_tp_id"; $result_lens = mysql_query($sql_lens); $row_lens = mysql_fetch_array($result_lens); // Get Tags $sql_tags = "SELECT * FROM photo_photo_tag ppt, photo_tag pt WHERE ppt.pht_id = $pht_id AND ppt.pht_tg_id = pt.pht_tg_id"; $result_tags = mysql_query($sql_tags); $row_tags = mysql_fetch_array($result_tags); do { $photo_tags .= "" . $row_tags["tag"] . ", "; } while ($row_tags = mysql_fetch_array($result_tags)); $photo_tags = substr($photo_tags, 0, -2); $serie_month = strftime("%m", $row_series["time"]); $serie_day = strftime("%d", $row_series["time"]); $serie_year = strftime("%Y", $row_series["time"]); // Find map if ($row_region["map"] == 1) { $map = "region_neth.php"; $map_name = "Netherlands"; } elseif ($row_region["map"] == 2) { $map = "region_world.php"; $map_name = "World"; } echo "Transparent
\n"; echo "" . $row_photo["title"] . "
\n"; if ($row_photo["comment"] != "") { echo "
" . $row_photo["comment"] . "
\n"; } echo "Transparent
\n"; echo "" . $row_photo["title"] . "
\n"; echo "Transparent
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } else { echo "None\n"; echo "\n"; echo "\n"; echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
 Title: " . $row_photo["title"] . " 
 Serie: "; if (strlen($row_series["pht_srs_id"]) >0) { echo "" . $serie_year . "-" . $serie_month . "-" . $serie_day . " - " . $row_series["serie"] . "\n"; echo " > View all photos of this serie
 
 Region: " . $row_region["region"] . " > View all photos in this region
\n"; echo " > View this region on map
 Map: " . $map_name . " > View all locations on this map
 Tags: " . $photo_tags . "
 Used lens: " . $row_lens["lens"] . " > View more photos with this lens
 Used camera: " . $row_camtype["camera"] . " 
 ISO: " . $row_photo["iso"] . " 
 Aperture: " . $row_photo["aperture"] . " 
 Exposure: " . $row_photo["exposure"] . " 
 Focal length: " . $row_photo["focal_length"] . " 
 File size: " . $file_size_kb . " KB 
 Dimensions: " . $row_photo["width"] . " wide - " . $row_photo["height"] . " high  
 Shot on: " . $photo_day . " " . $photo_month . " " . $photo_year . $photo_time . " 
 Views: " . $row_photo["views"] . " > View 50 most visited photos
\n"; if (strlen($row_photo["gps_latitude"]) > 0) { $gps_latitude = stripslashes($row_photo["gps_latitude"]); $gps_latitude = str_replace("", "", $gps_latitude); $gps_latitude = str_replace("'", "", $gps_latitude); $gps_latitude = str_replace("\"", "", $gps_latitude); $gps_latitude_array = explode(" ", $gps_latitude); $gps_longitude = stripslashes($row_photo["gps_longitude"]); $gps_longitude = str_replace("", "", $gps_longitude); $gps_longitude = str_replace("'", "", $gps_longitude); $gps_longitude = str_replace("\"", "", $gps_longitude); $gps_longitude_array = explode(" ", $gps_longitude); $gps_altitude = stripslashes($row_photo["gps_altitude"]); // echo "

\n"; echo "\n"; echo "
\n"; echo " > View most visited photos on Google map\n"; echo "

\n"; } } echo "
\n"; echo "Transparent
\n"; echo "
\n"; echo "Transparent
\n"; echo "
\n"; if (isset($pht_rg_id)) { $sql_photo2 = "SELECT *, UNIX_TIMESTAMP(time) as time FROM photo WHERE pht_rg_id = $pht_rg_id ORDER BY time DESC"; $result_photo2 = mysql_query($sql_photo2); if ($row_photo2 = mysql_fetch_array($result_photo2)) { $sql_region = "SELECT * FROM photo_region WHERE pht_rg_id = $pht_rg_id"; $result_region = mysql_query($sql_region); $row_region = mysql_fetch_array($result_region); echo "from region " . $row_region["region"] . " (click for more info)
\n"; echo "Transparent
\n"; echo "\n"; echo "\n"; $i = 0; $aantal_kolommen = 5; do { $pht_id = $row_photo2["pht_id"]; $sql_thumbnail = "SELECT * FROM photo_thumbnail WHERE pht_id = $pht_id"; $result_thumbnail = mysql_query($sql_thumbnail); $row_thumbnail = mysql_fetch_array($result_thumbnail); echo "\n"; $i++; // Sluit eventueel rij af if ($i%$aantal_kolommen == 0 && $i>0) { echo "\n"; echo "\n"; } } while ($row_photo2 = mysql_fetch_array($result_photo2)); } } elseif (isset($pht_srs_id)) { $sql_photo3 = "SELECT *, UNIX_TIMESTAMP(time) as time FROM photo WHERE pht_srs_id = $pht_srs_id ORDER BY time DESC"; $result_photo3 = mysql_query($sql_photo3); if ($row_photo3 = mysql_fetch_array($result_photo3)) { $sql_serie = "SELECT * FROM photo_series WHERE pht_srs_id = $pht_srs_id"; $result_serie = mysql_query($sql_serie); $row_serie = mysql_fetch_array($result_serie); echo "from serie " . $row_serie["serie"] . "
\n"; echo "Transparent
\n"; echo "
\n"; $photo_number = $i + 1; echo "" . $photo_number . ". (" . $row_photo2["views"] . " views)
"; echo "" . $row_photo2["title"] . "

\n"; echo "
\n"; echo "\n"; $i = 0; $aantal_kolommen = 5; do { $pht_id = $row_photo3["pht_id"]; $sql_thumbnail = "SELECT * FROM photo_thumbnail WHERE pht_id = $pht_id"; $result_thumbnail = mysql_query($sql_thumbnail); $row_thumbnail = mysql_fetch_array($result_thumbnail); echo "\n"; $i++; // Sluit eventueel rij af if ($i%$aantal_kolommen == 0 && $i>0) { echo "\n"; echo "\n"; echo "\n"; echo "\n"; } } while ($row_photo3 = mysql_fetch_array($result_photo3)); echo "\n"; echo "
\n"; $photo_number = $i + 1; echo "" . $photo_number . ". (" . $row_photo3["views"] . " views)
"; echo "" . $row_photo3["title"] . "
\n"; echo "
\n"; echo "Transparent
\n"; echo "
\n"; } } elseif (isset($pht_bstf_wrld_id)) { echo showBestof(); } elseif (isset($pht_bstf_id)) { echo showBestof(); } elseif ($action == "lastphotos") { echo showLastphotos(); } elseif ($action == "mostvisited") { echo showMostvisited(); } else { } ?>