= ".$whichPublishedOn." AND photo_captured_on > ".$whichCapturedOn." "; $queryRel .= "ORDER BY photo_published_on ASC, photo_captured_on ASC "; } } $queryRel .= "LIMIT 1) "; $queryRel .= "UNION ALL "; $queryRel .= "(SELECT 'next' as photo_rel, col_slug, alb_slug, photo_title, photo_slug, photo_location, photo_captured_on, photo_published_on "; $queryRel .= "FROM tk_collections_albums "; $queryRel .= "INNER JOIN tk_albums_photos ON albpho_album_id = colalb_alb_id "; $queryRel .= "INNER JOIN tk_collections ON colalb_col_id = col_id "; $queryRel .= "INNER JOIN tk_albums ON colalb_alb_id = alb_id "; $queryRel .= "INNER JOIN tk_photo ON albpho_photo_id = photo_id "; $queryRel .= "WHERE col_slug = '".$whichColSlug."' AND alb_slug = '".$whichAlbSlug."' "; $queryRel .= "AND photo_status = 'P' "; $queryRel .= "AND photo_id != ".$whichId." "; // -- Hack for title sorting ... if ($whichSorting == "photo_title") { $queryRel .= "AND photo_published_on >= ".$whichPublishedOn." "; $queryRel .= "ORDER BY ".$whichSorting." ".$whichSortOrder." "; } else { if ( $whichSortOrder == "ASC" ) { $queryRel .= "AND photo_published_on >= ".$whichPublishedOn." AND photo_captured_on > ".$whichCapturedOn." "; $queryRel .= "ORDER BY photo_published_on ASC, photo_captured_on ASC "; } else { $queryRel .= "AND photo_published_on <= ".$whichPublishedOn." AND photo_captured_on < ".$whichCapturedOn." "; $queryRel .= "ORDER BY photo_published_on DESC, photo_captured_on DESC "; } } $queryRel .= "LIMIT 1)"; if ( $mysql_result = mysqli_query($DBLink, $queryRel) ) { while ( $row = mysqli_fetch_assoc($mysql_result) ) { switch ( $row["photo_rel"] ) { case "prev": $metaRelPrev = STP_FULL_URL.$row["col_slug"]."/".$row["alb_slug"]."/".$row["photo_slug"]."/"; $prev_rel = "prev"; $prev_url = $metaRelPrev; $prev_photo_title = $row["photo_title"]; $prev_photo_location = $row["photo_location"]; $prev_photo_captured_on = $row["photo_captured_on"]; $prev_photo_published_on = $row["photo_published_on"]; break; case "next": $metaRelNext = STP_FULL_URL.$row["col_slug"]."/".$row["alb_slug"]."/".$row["photo_slug"]."/"; $next_rel = "next"; $next_url = $metaRelNext; $next_photo_title = $row["photo_title"]; $next_photo_location = $row["photo_location"]; $next_photo_captured_on = $row["photo_captured_on"]; $next_photo_published_on = $row["photo_published_on"]; break; } } } // -- FB meta tags... $metaFile = STP_URL_CACHE_PHOTOS.preg_replace ("/.(jpe?g|png)/i", "_w_".STP_SOCIAL_IMG_SIZE.".$1", $whichFilename); $metaOGImage = "\n"; $metaOGImageWidth = "\n"; $metaOGImageHeight = "\n"; $metaPublishedOn = $whichPublishedOn; $metaModifiedOn = $whichModifiedOn; // -- Twitter meta tags... $metaTwitterImage = "\n"; // -- Pinterest image path... $metaFile = STP_URL_CACHE_PHOTOS.preg_replace ("/.(jpe?g|png)/i", "_w_800.$1", $whichFilename); $pathPinterestImage = $metaFile; } else { $error404 = true; } } else { $error404 = true; } if ($error404 == true ) { header($_SERVER["SERVER_PROTOCOL"].' 404 Not Found'); include("err404.php"); exit; } // -- Fancy logo... fancyLogo(); ?> " /> " /> " />

Photographie ...

" /> " /> " /> " />
0 AND $photo_height > 0 ) { echo "\n"; } ?> <? echo $whichPhotoAlt; ?>" data-ratio="" />

le -

" /> " /> " /> " /> " /> " />

à voir Aussi dans '">':