//$result1 = mysql_query( "SELECT * FROM $table2 WHERE ($kriterium) LIMIT $div, $N");
@($num1 = mysql_num_rows($result1));
echo "\n<div class='page'>";
if ($num0 == '') {
$num0 = '0';
}
switch ($mod) {
case 'edit':
echo "<p id='kopf'>pic2base :: Datensatz-Bearbeitung <span class='klein'>(" . $num0 . " Treffer" . $anzeigebereich . ")</span></p>";
break;
case 'exif':
echo "<p id='kopf'>pic2base :: Datensatz-Recherche <span class='klein'>(eingestellte Bewertung: " . $bewert . ", " . $num0 . " Treffer" . $anzeigebereich . ")</span></p>";
break;
}
echo "\t\n\t<div class='navi' style='clear:right;'>\n\t\t<div class='menucontainer'>";
createNavi2_2($c_username, $mod);
echo "</div>\n\t</div>\n\t\n\t<div class='content'>";
if ($num0 == '0') {
echo "\n\t<p style='margin:100px 0px; text-align:center'>\n\t<TABLE border = '0' class='liste1' align = 'center'>\n\t<TR class='liste1'>\n\t<TD class='normal' align='center'><font color=red>Ihre Suchanfrage ergab 0 Treffer!</font>\n\t</TD>\n\t</TR>\n\t</TABLE>\n\t</p>\n\t<p style='margin:100px 0px; text-align:center'></p>\n\t</div>";
} else {
echo "\n\t<p style='margin:0px 0px; text-align:center'>\n\t<TABLE border = '0' class='liste1' align = 'center'>";
$fs_hoehe = 90;
$bgcolor = '#DDDDDD';
for ($i1 = 0; $i1 < $num1; $i1++) {
$pic_id = mysql_result($result1, $i1, 'pic_id');
$FileNameOri = mysql_result($result1, $i1, 'FileNameOri');
$FileName = mysql_result($result1, $i1, 'FileName');
$FileNameHQ = mysql_result($result1, $i1, 'FileNameHQ');
$FileNameV = mysql_result($result1, $i1, 'FileNameV');
$FileSize = mysql_result($result1, $i1, 'FileSize');
$Width = mysql_result($result1, $i1, 'Width');
$coll_id = $_GET['coll_id'];
}
include '../../share/global_config.php';
include $sr . '/bin/share/db_connect1.php';
include $sr . '/bin/share/functions/main_functions.php';
include $sr . '/bin/css/initial_layout_settings.php';
$max_size = 200;
//max. Ausdehnung des Vorschaubildbereichs in px
$result1 = mysql_query("SELECT {$table25}.pic_id, {$table25}.coll_id, {$table24}.coll_id, {$table24}.coll_name, {$table2}.pic_id, {$table2}.FileNameHQ \nFROM {$table2}, {$table25}, {$table24} \nWHERE {$table25}.coll_id = '{$coll_id}'\nAND {$table24}.coll_id = {$table25}.coll_id\nAND {$table25}.pic_id = {$table2}.pic_id\n ORDER BY position");
$num1 = mysql_num_rows($result1);
$coll_name = mysql_result($result1, $i1, 'coll_name');
if (strlen($coll_name) > 65) {
$coll_name = substr($coll_name, 0, 65) . "...";
}
echo "\n<DIV Class='klein'>\n\t<div id='page'>\n\t\n\t\t<div id='head'>\n\t\t\tpic2base :: Ansicht der Kollektion \"" . $coll_name . "\"\n\t\t</div>\n\t\t\n\t\t<div id='navi'>\n\t\t\t<div class='menucontainer'>";
createNavi2_2($uid);
echo "\n\t\t\t</div>\n\t\t</div>\n\t\t\n\t\t<div id='content' style='background-color:darkgrey;'>\n\t\t\n\t\t\t<fieldset style='background-color:none; margin-top:10px;'>\n\t\t\t<legend style='color:blue; font-weight:bold;'>Ansicht der ausgewählten Kollektion</legend>\n\t\t\t<div id='scrollbox3' style='overflow-y:scroll;'>";
for ($i1 = 0; $i1 < $num1; $i1++) {
$pic_id = mysql_result($result1, $i1, 'pic_id');
$FileNameHQ = mysql_result($result1, $i1, 'FileNameHQ');
$pic_size = getimagesize($sr . "/images/vorschau/hq-preview/{$FileNameHQ}");
$pic_breite = $pic_size[0];
$pic_hoehe = $pic_size[1];
//echo $pic_breite;
if ($pic_breite > $pic_hoehe) {
$oberer_abstand = ($max_size - 176 / $pic_breite * $pic_hoehe) / 2;
echo "<div style='width:" . $max_size . "px; height:" . $max_size . "px; background-color:#333333; float:left; margin:2px; text-align:center; border-radius:10px;'>\t\t\t\t\t\n\t\t\t\t\t\t<img src='../../../images/vorschau/hq-preview/{$FileNameHQ}' style='width:176px; margin-top:" . $oberer_abstand . "px; border-radius:5px;' />\n\t\t\t\t\t\t</div>";
} else {
$oberer_abstand = ($max_size - 176) / 2;
echo "<div style='width:" . $max_size . "px; height:" . $max_size . "px; background-color:#333333; float:left; margin:2px; text-align:center; border-radius:10px;'>\t\t\t\t\t\n\t\t\t\t\t\t<img src='../../../images/vorschau/hq-preview/{$FileNameHQ}' style='height:176px; margin-top:" . $oberer_abstand . "px; border-radius:5px;' />\n\t\t\t\t\t\t</div>";
}
