");
printf("");
printf("");
printf("");
printf("");
//printf("%s",prt($txt));
$from = "FROM stuk WHERE tonen = 1";
$sql = "SELECT jaar $from group by jaar order by jaar desc";
$lst = mysql_query($sql);
$rws = mysql_num_rows($lst);
//printf(" $sql -> $rws ");
for ($j=0; $j<$rws; $j=$j+1)
{
$s_ja2 = mysql_result($lst,$j,"jaar");
$s_ja1 = $s_ja2-1;
//printf(" Seizoen $s_ja1 - $s_ja2");
printf(" Seizoen $s_ja1 - $s_ja2");
$from = "FROM stuk WHERE tonen = 1";
$sqls = "SELECT id, naam, type, genre $from AND jaar = $s_ja2 ORDER BY nr";
$lsts = mysql_query($sqls);
$rwss = mysql_num_rows($lsts);
printf(" ");
for ($i=0; $i<$rwss; $i=$i+1)
{
$t_id = mysql_result($lsts,$i,"id");
$t_nm = mysql_result($lsts,$i,"naam");
$t_ty = mysql_result($lsts,$i,"type");
$t_ge = mysql_result($lsts,$i,"genre");
if($t_ty==4) $tx_ty = "Bonte";
else $tx_ty = dom_wa(75,$t_ty,0);
$tx_ge = dom_wa(14,$t_ge,0);
$url = "p_voorstelling.php?ses=$ses&tst=$tst&pag=8&key=$t_id";
$tx_nm = "$t_nm";
$foto = 0;
if($tst>=0) {
if(instr(".$t_id.",".46.50.53.54.57.59.66.70.82.86.87.88.89.90.91.92.93.94.95.96.97.98.99.100.101.102.103.104.106.")>0) {
if($tst>=0) { $foto = 1;
//$tx_nm = sprintf("$tx_nm - Foto's",$t_id * -1);
$tx_nm = "$tx_nm | ";
//$tx_nm = sprintf("$tx_nm - |  | ",$t_id * -1);
$tx_nm = sprintf("$tx_nm - |  | ",$t_id * -1);
//$tx_nm = sprintf("$tx_nmFoto's | ",$t_id * -1);
$tx_nm = "$tx_nm ";
}
} else {
$sqla = "SELECT * FROM album a WHERE type = 1 AND type_id = $t_id AND tonen = 1
AND ( SELECT COUNT(*) FROM docs WHERE tonen = 1 AND soort = 1 AND type = 1 AND type_id = a.id ) > 0
ORDER BY nr";
$lsta = mysql_query($sqla);
$rwsa = mysql_num_rows($lsta);
$foto = $rwsa;
if($rws>0) {
for ($f=0; $f<$rwsa; $f=$f+1)
{
$t_id = mysql_result($lsta,$f,"id");
$t_nr = mysql_result($lsta,$f,"nr");
$t_ti = mysql_result($lsta,$f,"titel");
$tx_nm = "$tx_nm | ";
$lnkfa = " ";
$lnkft = sprintf("%s",$t_ti);
if($rwsa==1) {
//$lnkfa = " ";
$tx_nm = sprintf("$tx_nm - | $lnkfa | ");
$tx_nm = "$tx_nm ";
}
if($rwsa>1) {
if($t_ti=="") $t_ti = "Album $t_nr";
if($f==0) {
//$lnkfa = " ";
//$tx_nm = sprintf("$tx_nm$t_ti | ",$t_id);
$tx_nm = sprintf("$tx_nm - | $lnkfa | ");
$tx_nm = sprintf("$tx_nm$lnkft | ");
} else {
//$lnkfa = " ";
//$tx_nm = sprintf("$tx_nm$t_ti | ",$t_id);
$tx_nm = sprintf("$tx_nm | | $lnkfa | ");
$tx_nm = sprintf("$tx_nm$lnkft | ");
if($f+1==$rwsa) $tx_nm = "$tx_nm ";
}
}
}
}
}
}
$fid = 1; $func = "Regie";
$sqlr = "SELECT b.voornaam vnm, b.naam anm FROM functie a, person b WHERE a.pers_id = b.id AND func_id = $fid AND stuk_id = $t_id ORDER BY 1, 2";
$lstr = mysql_query($sqlr);
$rwsr = mysql_num_rows($lstr);
$temp = "";
//if($rwsr>1) $func = sprintf("%ss",$func);
if($rwsr>0) {
for ($r=0; $r<$rwsr; $r=$r+1)
{
$t_vnm = mysql_result($lstr,$r,"vnm");
$t_anm = mysql_result($lstr,$r,"anm");
if($r==0) $temp = "$t_vnm $t_anm";
else $temp = "$temp, $t_vnm $t_anm";
}
$tx_reg = " $func | : | $temp | ";
} else $tx_reg = " $spa | ";
$fid = 2; $func = "Auteur";
$sqlr = "SELECT b.voornaam vnm, b.naam anm FROM functie a, person b WHERE a.pers_id = b.id AND func_id = $fid AND stuk_id = $t_id ORDER BY 1, 2";
$lstr = mysql_query($sqlr);
$rwsr = mysql_num_rows($lstr);
$temp = "";
if($rwsr>1) $func = sprintf("%ss",$func);
if($rwsr>0) {
for ($r=0; $r<$rwsr; $r=$r+1)
{
$t_vnm = mysql_result($lstr,$r,"vnm");
$t_anm = mysql_result($lstr,$r,"anm");
if($r==0) $temp = "$t_vnm $t_anm";
else $temp = "$temp, $t_vnm $t_anm";
}
$tx_aut = " $func | : | $temp | ";
} else $tx_aut = " $spa | ";
if($foto>0) {
printf(" | ");
printf(" | | ");
} else {
printf(" - | ");
printf("$tx_ty | : | ");
}
printf("$tx_nm | ");
//printf("$t_ge | ");
printf(" ");
/*
printf(" $spa | ");
printf("Genre$br1 | : | $tx_ge | ");
printf("$tx_reg $tx_aut");
//printf("Auteur | : | $t_ge | ");
printf(" ");
*/
}
printf(" | ");
printf("
");
}
printf("");
printf(" |
");
printf("