}
}
+ $dayname['<iso-event-date_0>'] = '<name-event-date_0>';
+ $dayname['<iso-event-date_1>'] = '<name-event-date_1>';
+ $dayname['<iso-event-date_2>'] = '<name-event-date_2>';
+ $dayname['<iso-event-date_3>'] = '<name-event-date_3>';
+
+ $roomname['<room-1-internal>']="<room-1>";
+ $roomname['<room-2-internal>']="<room-2>";
+ $roomname['<room-3-internal>']="<room-3>";
+
+ $query = sprintf ("SELECT workshop.oid,title,name,date_time,room FROM workshop,person "
+ ."WHERE person = id AND workshop.project = '%s' ORDER BY date_time,room",
+ $project);
+
+ $sth = pg_exec ($dbh, $query) or die("Datenbank-Abfrage!");
+
+ if (pg_NumRows ($sth) > 0) {
+ printf ("<strong>Workshops</strong> (%d):<br>", pg_NumRows ($sth));
+ for ($nr=0; $nr < pg_NumRows ($sth); $nr++) {
+ $row = pg_fetch_array ($sth, $nr);
+
+ $date = explode (" ", $row['date_time']);
+ $time = explode (":", $date[1]);
+ $time = sprintf ("%02d:%02d", $time[0], $time[1]);
+
+ printf (" %s: <a href=\"../workshops/edit.php3?oid=%d\">%s</a> (%s, %s, %s)<br>",
+ $row['name'],
+ $row['oid'],
+ $row['title'],
+ $dayname[$date[0]],
+ $time,
+ $roomname[$row['room']]);
+ }
+ }
+
# Supplies ----------------------------------------
$query = sprintf ("SELECT supplies.amount,supplylist.name,supplylist.height,supplylist.width,supplylist.depth,supplylist.id"
.",supplylist.price FROM supplylist,supplies "