$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 : Foto #%s\n%s\n" ."\n" ."\n" ."\n\n" ."\n\n", $title, $nr, $script, $col_bgcolor, $col_text, $col_link, $col_vlink) ; $ylem = YlemKataloogid ($kataloog, $link, TRUE, TRUE) ; printf ("

%s

\n\n", $ylem) ; printf ("

%s

\n\n", $pealkiri) ; echo ("

" ."\n" ."" ."

" ."

") ; if ($laiend == ".mov") { printf ("

\n\n", $dim, $url, $failinimi, $url, $failinimi, $dim) ; } else printf ("

", $url, $failinimi, $dim) ; echo ("

\n" ."

\n\n") ; if ($width == "") // pildi laius on määramata $width = "600" ; printf ("

" ."

\n\n", $width, $kommentaar) ; if ($laiend == ".mov") { printf ("

%s %s

\n\n

\n\n", $str14[$keel], $autor) ; printf ("

\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 ("

") ; printf ("\n", $width) ; printf ("\n", $str2[$keel]) ; while ($row) { echo ("\n") ; $row = fetch_row ($res) ; } echo ("

%s
\n") ; printf (" " ."%s - %s", $row[5], $row[2]) ; if ($row[3] != "") printf (" - %s", $row[3], $row[3]) ; echo (" \n") ; printf ("%s \n", $row[4]) ; echo ("

\n\n") ; } if (KommentaaridLubatud ($kataloog, $link)) printf ("

\n\n", $id, $kataloog, $str3[$keel]) ; $kataloogilink = "%s" ; printf ("

[ " . $eelmine . " | " . $ylem . " | " . $jargmine . " ]", $str4[$keel], $str5[$keel]) ; if ($up_url) printf ("
\n[ %s ]", $up_url, $up_title) ; echo ("

\n\n") ; } else { echo ("

Viga: foto ID puudub!

\n\n") ; } PrintFooter () ; echo ("\n\n") ; ?>