set_filenames(array('tpl' => $tpl));
$template->assign_var('html_head',$html_head);
$template->assign_var('head',$head);
$template->assign_var('menu',$menu);
$template->assign_var('foot',$foot);
if ( !$isDevelop or $_SESSION['IsAuthorized'] )
{
####################################################
$filter = '20130319';
if ( isset($_REQUEST['filter']) ){
$filter= mysql_real_escape_string( $_REQUEST['filter'] );
}
$sql = 'SELECT '
.'TIME_FORMAT(timetable.sighting,"'.LangText('%H:%i','%h:%i %p').'") AS probe,'
.'TIME_FORMAT(timetable.begin,"'.LangText('%H:%i','%h:%i %p').'") AS begin,'
.'TIME_FORMAT(timetable.end,"'.LangText('%H:%i','%h:%i %p').'") AS end,'
.'timetable.event_id,'
.LangText('events.de','events.en').' AS event,'
.LangText('locations.de','locations.en').' AS location,'
.'events.location_id AS range,'
.'DATE_FORMAT(timetable.datum,"%Y%m%d") AS date,'
.'TIME_FORMAT(timetable.begin,"%H%i") AS start,'
.'count(*) as cnt'
.' FROM timetable'
.' INNER JOIN events ON timetable.event_id = events.id'
.' INNER JOIN locations ON events.location_id = locations.id'
.' LEFT JOIN listen on timetable.datum = listen.datum and timetable.begin = listen.zeit'
.' WHERE timetable.datum = "'.$filter.'"'
.' GROUP BY timetable.begin, events.id'
.' ORDER BY locations.sort, timetable.begin, timetable.end, timetable.sort';
$db->query($sql);
while ($row = $db->fetch_array()){
$probe = $row['probe'];
$begin = $row['begin'];
$end = $row['end'];
$event_id = $row['event_id'];
$event = $row['event'];
$location = $row['location'];
$range = $row['range'];
$date = $row['date'];
$start = $row['start'];
$cnt = $row['cnt'];
if ( ($cnt > 0) ){
switch ( substr($event_id,-1,1) ){
case "T": break;
case "F": break;
case "S": break;
default:
if ( substr($event_id,0,4) == '2.30' )
$event = '' .$event. '';
else
$event = '' .$event. '';
break;
}
}
$template->assign_block_vars('startlist', array(
'probe' => $probe,
'begin' => $begin,
'end' => $end,
'event' => $event,
'location' => $location
));
}
$sql = 'SELECT date_format("'.$filter.'","'.LangText('%d.%m.%Y','%Y-%m-%d').'") as date';
$db->query($sql);
$row = $db->fetch_array();
$date = $row['date'];
#setlocale( LC_TIME, LangText('de_DE','en_GB') );
#$date = strftime('%A %x', mktime(0,0,0,substr($filter,-4,2), substr($filter,-2,2), substr($filter,0,4)) );
$template->assign_vars(array(
'title' => LangText('Zeitplan','Timetable'),
'date' => $date,
'th_probe' => LangText('Probe','Sighting'),
'th_begin' => LangText('Start','Begin'),
'th_end' => LangText('Ende','End'),
'th_event' => LangText('Disziplin','Event'),
'th_range' => LangText('Halle','Range')
));
}
####################################################
### Footer laden ###
$template->pparse('tpl');
?>