include("cfg/standard.php"); ?>
Komm flieg mit // The trip begins here
// Prepared variables $tripID = $_GET["tripID"]; $dayID = $_GET["dayID"]; $start = $_GET['start']; $showID = $_GET["showID"]; $endID = $_GET["endID"]; $selectDay = "select da.fID as dayID, date_format(da.fDate, '%d.%m.%Y') as dayDate, re.fID as reportID, re.fTitle as DayTitle, re.fPreface as DayPreface, re.fText as Text, re.frLanguageID as languageID, re.fStatusID as statusID, dare.frTripID, dare.frDayID, dare.frReportID, la.fID, re.fTypeID from kfmDay da inner join kfmDayReport dare on dare.frDayID = da.fID inner join kfmReport re on re.fID = dare.frReportID left outer join kfmFoto fo on fo.fID = dare.frFotoID inner join comLanguage la on la.fID = re.frLanguageID where re.frLanguageID = 1 and re.fStatusID = ".$statusID." and dare.frDayID = ".$dayID." group by re.fID"; $dayData = @mysql_query($selectDay,$dbh); $dayDate = @mysql_result($dayData, 0, 1); $reportID = @mysql_result($dayData, 0, 2); $dayTitle = @mysql_result($dayData, 0, 3); $typeID = @mysql_result($dayData, 0, 12); // //// ANZAHL DER FOTOS PRO SEITE // $pp = "1"; // //// DEFINIEREN, WELCHE FOTOS ANGEZEIGT WERDEN // if ($showID == "") { $ShowStart = "1"; $ShowEnd = $ShowStart + $pp - "1"; } else { $ShowStart = $showID; $ShowEnd = $ShowStart + $pp - "1"; } $sql_select_album = "select fID, fFilename, frDayID from kfmFoto where frDayID = ".$dayID." order by fFilename"; $album_data = @mysql_query($sql_select_album,$dbh); $album_para = @mysql_query($sql_select_album,$dbh); $i = 0; while ($album = @mysql_fetch_array($album_data)): $i++; if (($i >= $ShowStart) && ($i <= $ShowEnd)) { $Pic = $album["fFilename"]; $fotoID = $album ["fID"]; // Select Foto Details $selectFotoDetails = "select fo.fID, fo.fFilename, co.fID, co.fTitle, co.fComment, co.frLanguageID, co.fStatusID, foda.frFotoID, foda.frCommentID from kfmFoto fo inner join kfmFotoData foda on foda.frFotoID = fo.fID inner join kfmFotoComment co on co.fID = foda.frCommentID where fo.fID = ".$fotoID." and co.frLanguageID = 1 group by fo.fID"; $fotoDetailsData = @mysql_query($selectFotoDetails, $dbh); $FotoTitleGe = @mysql_result($fotoDetailsData, 0, 3); $FotoCommentGe = @mysql_result($fotoDetailsData, 0, 4); } endwhile; ?>
Startseite
|
Tagesübersicht
if ($typeID == 0): ?>|
Zum Bericht
endif; ?>
if ($ShowEnd - $pp >= "1"): ?>
Erstes Foto
|
Zurück
| endif; ?> if (($ShowEnd < $i) && ($endID != "0")): ?>
Weiter
|