| \n") ;
echo (" \n") ;
AlamKataloogid ($id, $link) ;
echo (" \n") ;
//echo (" | \n\n\n") ;
$query = "select f.id,f.failinimi,f.formaat_t,f.pealkiri "
."from fotod=f,koopiad=k where k.kataloog_id=$id and "
."f.id=k.foto_id and k.jrk>0 order by k.jrk" ;
$res = query ($query, $link) ;
$row = fetch_row ($res) ;
//echo ("\n") ;
//echo ("\n") ;
//echo ("\n") ;
//echo ("
\n") ;
echo ("\n") ;
while ($row)
{
$failinimi = $row[1] ;
$formaat_t = $row[2] ;
$pealkiri = $row[3] ;
$fn = strtok ($failinimi, ".") ;
$fn .= "_t." ;
$laiend = strtok (".") ;
if ($laiend == "mov")
$fn .= "jpg" ; // mov-i thumb peab olema jpg-formaadis
else
$fn .= $laiend ;
if ($formaat_t)
{
$width = strtok ($formaat_t, "x") ;
$height = strtok ("x") ;
$dim = sprintf (" width=\"%s\" height=\"%s\"", $width, $height) ;
}
printf (""
."![\"%s\"](\"%s%s\"%s) \n",
$row[0], $id, $url, $fn, $dim, $pealkiri) ;
$row = fetch_row ($res) ;
}
echo (" \n") ;
//echo ("
\n") ;
//echo (" | \n \n\n\n") ;
// Uued kommentaarid
$query = "select f.id,f.pealkiri,k.nimi,"
."date_format(k.lisatud,'%d.%m.%Y %H:%i') "
."from fotod=f,kommentaarid=k,koopiad=ko "
."where ko.kataloog_id=$id and ko.foto_id=k.foto_id and "
."f.id=ko.foto_id order by k.lisatud desc limit 10" ;
$res = query ($query, $link) ;
$row = fetch_row ($res) ;
if ($row)
{
$width = "600" ;
printf ("%s:\n ", $str1[$keel]) ;
while ($row)
{
//echo ("\n") ;
printf ("- %s - %s - "
."%s",
$row[3], $row[2], $row[0], $id, $row[1]) ;
//echo ("
| \n") ;
$row = fetch_row ($res) ;
}
echo (" \n\n\n") ;
}
// Link fotosaidist välja
if ($up_url != "")
printf ("[ %s ] \n",
$up_url, $up_title) ;
}
else
{
echo ("Viga: kataloogi ID puudub!\n\n") ;
}
PrintFooter () ;
echo ("\n\n") ;
?>
|