require ("admin/db.inc") ; require ("admin/edit.inc") ; require ("fotod.inc") ; //require ("admin/main.inc") ; $id = $_GET['id'] ; $kataloog = $_GET['kataloog'] ; $link = connect ("localhost", "www", "Zeiss1911") ; select_db ("fotod", $link) ; if ($id != "") { $query = "select * from fotod where id=$id" ; $res = query ($query, $link) ; $row = fetch_row ($res) ; $nr = $row[0] ; $pealkiri = $row[1] ; $kommentaar = $row[2] ; $autor = $row[3] ; if ($kataloog == "") $kataloog = $row[4] ; $failinimi = $row[5] ; $fn_laiendita = strtok ($row[5], ".") ; $laiend = "." . strtok (".") ; $formaat = $row[6] ; $formaat_t = $row[7] ; $formaat_b = $row[8] ; $formaat_f = $row[9] ; $lisatud = $row[10] ; if ($formaat) { $width = strtok ($formaat, "x") ; $height = strtok ("x") ; if ($laiend == ".mov") $height = (string) ((int) $height + 16) ; $dim = sprintf (" width=\"%s\" height=\"%s\"", $width, $height) ; } $query = "select jrk from koopiad where foto_id=$id and kataloog_id=$kataloog" ; $res = query ($query, $link) ; $row = fetch_row ($res) ; $jrk = $row[0] ; $query = "select foto_id from koopiad where jrk>$jrk and " ."kataloog_id=$kataloog order by jrk" ; $res = query ($query, $link) ; $row = fetch_row ($res) ; if ($row) $jargmine = "%s" ; else $jargmine = "%s" ; $query = "select foto_id from koopiad where jrk<$jrk and " ."kataloog_id=$kataloog order by jrk desc" ; $res = query ($query, $link) ; $row = fetch_row ($res) ; if ($row) $eelmine = "%s" ; else $eelmine = "%s" ; $query = "select * from kataloogid where id=$kataloog" ; $res = query ($query, $link) ; $row = fetch_row ($res) ; $katalooginimi = $row[3] ; $url = $row[5] ; $up_url = $row[7] ; $up_title = $row[8] ; $col_bgcolor = "#000000" ; $col_text = "#ffffff" ; $col_link = "#ffff00" ; $col_vlink = "#ffa0a0" ; $keel = KataloogiKeel ($kataloog, $link) ; $script = "\n" ; $title = YlemKataloogid ($kataloog, $link, FALSE, FALSE) ; printf ("\n
\n"
."
|
"
." %s \n\n", $width, $kommentaar) ; if ($laiend == ".mov") { printf ("%s %s \n\n |
%s
\n\n", $str15[$keel]) ; } else printf ("%s %s
\n\n\n\n", $str11[$keel], $autor) ; // Külastajate kommentaarid $query = "select id,foto_id,nimi,email,kommentaar," ."date_format(lisatud,'%d.%m.%Y %H:%i') from kommentaarid " ."where foto_id=$id" ; $res = query ($query, $link) ; $row = fetch_row ($res) ; if ($row) { if ($width == "") $width = "600" ; echo ("\n") ;
printf (" "
."%s - %s",
$row[5], $row[2]) ;
if ($row[3] != "")
printf (" - %s",
$row[3], $row[3]) ;
echo (" |
[ " . $eelmine . " | " .
$ylem . " | " . $jargmine . " ]",
$str4[$keel], $str5[$keel]) ;
if ($up_url)
printf ("
\n[ %s ]",
$up_url, $up_title) ;
echo ("