<% include("../cmsbk/dk_config.php"); if ($left) $left = (int)$left; else $left = 0; $q = "SELECT count(*) FROM kunst WHERE destination = 2"; $res = mysql_query($q); $row = mysql_fetch_row($res); $max=$row[0]; $q = "SELECT * FROM kunst WHERE destination = 2 ORDER BY display_order"; $res = mysql_query($q); $row = mysql_fetch_row($res); for ($x = 0; $x < $left; $x++) $row = mysql_fetch_row($res); // START OBJECT CODE // $obj_left = $left; $q1 = "SELECT count(*) FROM kunst WHERE destination = 4"; $res1 = mysql_query($q1); $row1 = mysql_fetch_row($res1); $obj_max=$row1[0]; if ($obj_max > $left) { $q2 = "SELECT * FROM kunst WHERE destination = 4 ORDER BY display_order"; $res2 = mysql_query($q2); $obj_row = mysql_fetch_row($res2); for ($x = 0; $x < $obj_left; $x++) $obj_row = mysql_fetch_row($res2); if ($obj_max - $obj_left < 5) $obj_right = $obj_max - $obj_left; else $obj_right = 5; } // END OBJECT CODE // if ($max - $left < 5) $right = $max - $left; else $right = 5; %> SBK Digitale Kunstuitleen \n"); } else { $back = $left - 5; printf("
\"\"\n",$back); } printf("\n"); } else { $left += 5; printf("
>', LEFT);\" onmouseout=\"nd();\">
\n",$left); } %>
<% $q = "select count(*) from kunst where destination = 1"; $zres = mysql_query($q); $zrow = mysql_fetch_row($zres); $zmax = $zrow[0]; $zmax = ((int)($zmax / 5)) -1; $zmaxz = $zmax+1; $zmax = 5 * $zmax; if (($left == 0) || (($left - 5) < 0)) { printf("
\"\"
\n"); printf("\n"); printf("\n"); printf("\n"); for ($x = 0; $x < $right; $x++) { $titel = addslashes($row[3]); if($row[1]) $art_res = "Kunstwerk is gereserveerd"; printf("\n"); $art_res = ""; $row = mysql_fetch_row($res); } for ($x = $right; $x < 5; $x++) { printf(""); } printf("\n"); printf("
\n"); printf("$row[2]
$titel
\[$row[7]\] $art_res', CENTER, OFFSETY, 30, WRAP);window.status='\[%s\] %s';return true\"",$row[7],$row[0]); $img = gfn("k$row[0]"); printf(" onmouseout=\"nd();window.status=''\">\"\"
"); if($row[1]) { printf(""); } printf("
\n\n"); if ($q2 != "") { printf("\n"); printf("\n"); $b=0; for ($x = 0; $x < $obj_right; $x++) { if ($b % 2) { $td = "\n"); $obj_res = ""; $obj_row = mysql_fetch_row($res2); } printf("


\n"; } else { $td = "
\n"; } $b++; $titel = addslashes($obj_row[3]); if($obj_row[1]) $obj_res = "Object is gereserveerd"; printf("$td $obj_row[2]
$titel
\[$obj_row[7]\] $obj_res', CENTER, OFFSETY, 30, WRAP);window.status='\[%s\] %s';return true\"",$obj_row[7],$obj_row[0]); $img = gfn("k$obj_row[0]"); printf(" onmouseout=\"nd();window.status=''\">\"\"
"); if($obj_row[1]) { printf("
"); } printf("
\n"); } %>
<% if ($max - $left <= 5) { $left += 5; printf("
<% $prev = $left -10; echo "
 Home 

\"  "; if ($left > 5) { echo "\" "; } else { echo " "; } echo "Uitleenzalen  "; for ($x = 0; $x < ($max / 5); $x++) { $xl = $x * 5; $xz = $x + 1; if ($left == ($xl + 5)){ echo "$xz"; } else { echo "$xz"; } if ($x < ($max/5 -1)) echo " "; } if ($left < ($max -1)) { echo " \""; } else { echo " "; } echo "  \"

"; %>