[CPABC_APPOINTMENT_CALENDAR calendar="17"]
get_results("SELECT * FROM wp_cpabc_appointment_calendars_data WHERE datatime >= {ts '".$timestamp."'} AND appointment_calendar_id = '8' ORDER BY datatime ASC LIMIT 12");
$gefundene_mannschaften = $wpdb->num_rows;
echo "
";
if( $gefundene_mannschaften >0)
{
foreach($mannschaftsinfos as $mannschaft)
{
$infos = $wpdb->get_results("SELECT * FROM wp_cpabc_appointments WHERE id = '".$mannschaft->reference."'");
foreach($infos as $mann)
{
switch($mann->calendar)
{
case ("1"):
$raum = "Aula NU112";
break;
case ("2"):
$raum = "Elternsprechzimmer NU102";
break;
case ("3"):
$raum = "Computerraum N201";
break;
case ("4"):
$raum = "Computerraum X09";
break;
case ("5"):
$raum = "Medienwagen M1";
break;
case ("6"):
$raum = "Medienwagen M2";
break;
case ("7"):
$raum = "Medienwagen M3";
break;
case ("8"):
$raum = "Medienwagen M4 (KVG)";
break;
case ("9"):
$raum = "Beamer B1";
break;
case ("10"):
$raum = "Beamer B2";
break;
case ("11"):
$raum = "Videoraum";
break;
case ("12"):
$raum = "Klausurraum X07";
break;
}
echo "
Name: ".$mann->name; echo "
Raum: ".$raum; echo "
Datum / Zeit: ".$mann->booked_time; echo "
"; } } } else echo "
";
?> Name: ".$mann->name; echo "
Raum: ".$raum; echo "
Datum / Zeit: ".$mann->booked_time; echo "
"; } } } else echo "