require("header.php"); ?>
require("database.php"); ?>
require("media.php"); ?>
$id = intval($_GET["id"]); ?>
$lang = 1;
$fallbacklang = 1;
$list = 1;
$q = "
select dn.name, case when ff.value is not null then ff.value else a.value end,
a.id, d.type, l.sortorder
from lists l natural join fields a
join defnames dn using (name_id)
natural join defs d
left outer join fields ff on (ff.name_id=a.name_id and ff.id=a.id and ff.lang=$lang)
where a.id = $id and l.list_id=$list and (a.lang=$fallbacklang or a.lang is null) order by l.sortorder";
$res = mysql_query($q);
$cnt=1;
$programcount=0;
$programviewcount=0;
$librettoviewcount=0;
$programview='';
$librettoview='';
while($row = mysql_fetch_row($res)) {
$cnt++;
//$name = htmlspecialchars($row[0]);
$name = stripslashes($row[0]);
//$name = $row[0];
$value = $row[1];
//if ($row[3] == 1) { $value = htmlspecialchars($value); }
if ($row[3] == 1) { $value = $value; }
$id = $row[2];
?>
if (isset($_SESSION['user'])) {
?>
} ?>
require("footer.php"); ?>