include("inc/standard.php");
$ComboID = $_GET["ComboID"];
//
// Album freischalten
if ($_POST["input_statusid"] == "Album freischalten")
{
$sql_update = "update smAlbum set ";
$sql_update .= "fPublic = 1 ";
$sql_update .= "where fID = ".$AlbumID;
@mysql_query($sql_update, $dbh);
}
?>
if (($PageID < "2") && ($ComboID == "")): ?>
|
|
else: ?>
while ($albumcomboheader = @mysql_fetch_array($albumcomboheader_data)):
$sql_select_startdate = "select fID, date_format(fDate, '%d-%m-%Y') as Date, frComboID
from smAlbum
where frComboID LIKE '%".$albumcomboheader["fComboDef"]."%'
order by fDate asc";
$startdate_data = @mysql_query($sql_select_startdate,$dbh);
$startdate = @mysql_result($startdate_data, 0, 1);
$sql_select_enddate = "select fID, date_format(fDate, '%d-%m-%Y') as Date, frComboID
from smAlbum
where frComboID LIKE '%".$albumcomboheader["fComboDef"]."%'
order by fDate desc";
$enddate_data = @mysql_query($sql_select_enddate,$dbh);
$enddate = @mysql_result($enddate_data, 0, 1);
$sql_select_albumcounter = "select count(fID) as Albummm, frComboID
from smAlbum
where frComboID LIKE '%".$albumcomboheader["fComboDef"]."%'
group by fID";
$albumcounter_data = @mysql_query($sql_select_albumcounter,$dbh);
$ctr;
while ($albumcounter = @mysql_fetch_array($albumcounter_data))
{
$ctr++;
$albcounter = $ctr;
}
$AlbumcomboID = $albumcomboheader["fComboDef"]
?>
|
|
$sql_select_randomalbum = "select fID, frComboID
from smAlbum
where frComboID LIKE '%".$albumcomboheader["fComboDef"]."%'
order by rand()
limit 1";
$randomalbum_data = @mysql_query($sql_select_randomalbum,$dbh);
while ($randomalbum = @mysql_fetch_array($randomalbum_data))
{
$sql_select_randompic = "select alf.fID, alf.fFilename, al.fPublic
from smAlbumFoto alf
inner join smAlbum al on al.fID = alf.frAlbumID
where alf.frAlbumID = ".$randomalbum["fID"]."
order by rand()";
$randompic_data = @mysql_query($sql_select_randompic,$dbh);
$randompicnr = @mysql_result($randompic_data, 0, 0);
$randompic = @mysql_result($randompic_data, 0, 1);
$RandomAlbumID = $randomalbum["fID"];
}
$startfirst = strpos($randompic, "_") + 1;
$start = strpos($randompic, "_", $startfirst) +1;
$end = strpos($randompic, ".jpg", $start);
$ShowID = ceil(substr($randompic, $start, $end-$start));
if ($ShowID == "0")
{
$start = strpos($randompic, "_") + 1;
$end = strpos($randompic, ".jpg", $start);
$ShowID = ceil(substr($randompic, $start, $end-$start));
}
?>
width="475" else: ?>width="745" endif; ?> border="0"> |
if ($albumcomboheader["ComboTeaser"] != ""): ?>
|
endif; ?>
|
endwhile; ?>
endif; ?>
if ($SearchID != ""): ?>
|
|
endif; ?>
if ($i == "")
{
$i = $SearchNrResult - $CountComboResult;
}
?>
if ($LimitID < $i): ?>
 |