7){ //Zeigt gegen Ende des Jahres das Neue mit an $headertext .= '

'; $headertext .= ($current_year == $display_year ? 'Saison '.$current_year.''; $headertext .= ($next_year == $display_year ? 'Saison '.$next_year.''; $headertext .= "

"; //List of months $start = ($display_year == $current_year ? $current_month : 1); $delimiter = ($display_year == $current_year ? 13 : 5); //Falls statt dem aktuellen das nächste Jahr angezeigt wird, sieht man die ersten Monate davon for ($i=$start; $i<$delimiter; $i++) { $monatsname = germanize_date(date("F", mktime(0, 0, 0, $i, 1, $current_year))); $submenu .= ($i == $display_month ? ''.$monatsname.' '; } } else { //List of months $start = $current_month; $delimiter = ($current_month < 9 ? $current_month+6 : 13); //Zeigt höchstens die nächsten 6 Monate an for ($i=$current_month; $i<$delimiter; $i++) { $monatsname = germanize_date(date("F", mktime(0, 0, 0, $i, 1, $current_year))); $submenu .= ($i == $display_month ? ''.$monatsname.' '; } } // ----------------CONTENT------------------------- //---------------------EINZELNEN EVENT ANZEIGEN------------------------------------------- if (isset( $_GET['id'] ) || isset( $_GET['eventid'] ) ){ if (isset( $_GET['id'] )){$termin_id = mysql_real_escape_string( $_GET['id'] );} if (isset( $_GET['eventid'] )){$event_id = mysql_real_escape_string( $_GET['eventid'] );} $content .= ' '; // Query the mysql database $query = ( $termin_id ? "SELECT * FROM `mike_event_termine`, `mike_events` WHERE `mike_event_termine`.`event_id` = `mike_events`.`id` AND `mike_event_termine`.`termin_id` = $termin_id" : "SELECT * FROM `mike_event_termine`, `mike_events` WHERE `mike_event_termine`.`event_id` = `mike_events`.`id` AND `event_id` = $event_id" ); $result = mysql_query($query); //$content .= $query; while ($row = mysql_fetch_object($result)) { $pagetitle = "$row->name"; $event_datetime = strtotime($row->datetime); $date = date('d.', $event_datetime); $month = date('n', $event_datetime); $image = $row->image; $content .= ''; $content .= '

'.$date.'

'.$row->name.'

'; $content .= ($row->einlass!="" ? 'Einlass: '.$row->einlass.' / ' : ''); $content .= "Beginn: $row->beginn / "; $content .= (($row->preis > 0) ? $row->preis.'€' : 'Eintritt: frei'); $content .= (($row->frei != "on") && ($row->preis == 0) ? 'e Spende' : ''); $content .=($row->ermaessigt !="" ? '/'.$row->ermaessigt.'€' : ''); $content .= '

'.nl2br($row->description).'

'; $content .= ($row->zusatzbemerkung!="" ? '

'.$row->zusatzbemerkung.'

' : ''); $content .= ($row->link!="" ? '

'.$row->link.'

' : ''); // Termine auflisten $query2 = "SELECT * FROM mike_event_termine where `event_id` = $row->id ORDER BY `datetime`"; $result2 = mysql_query($query2); $number2 = mysql_numrows($result2); $content .= ($number2 > 0 ? '

Termine

' : ''); while ($termine = mysql_fetch_object($result2)) { $event_datetime = strtotime($termine->datetime); $weekday = germanize_date(date('l', $event_datetime)); $date = germanize_date(date('d.m.Y', $event_datetime)); $time = date('G:i', $event_datetime); $content .= ""; } $content .= ($number2 > 0 ? '

$weekday

$date

- $time Uhr

' : ''); } $content .= '

'. ( $image !="" ? '

' : '').'

'; } else { //---------------------ALLE EVENTS ANZEIGEN------------------------------------------- // Query the mysql database $query = "SELECT * FROM `mike_event_termine`, `mike_events` WHERE `mike_event_termine`.`event_id` = `mike_events`.`id` AND (datetime BETWEEN '".$display_year."-". $display_month."-01 00:00:00' AND '".$display_year."-".$display_month."-31 23:59:59') ORDER BY datetime "; $result = mysql_query($query); // Determine the number of available ids $number = mysql_numrows($result); $content .= ( $number==0 ? "Noch keine Events für diesen Monat geplant." : '' ) ; while ($row = mysql_fetch_object($result)) { $event_datetime = strtotime($row->datetime); $weekday = germanize_date(date('D', $event_datetime)); $date = date('d.', $event_datetime); //m für Monat $preis = ($row->preis !="" ? $row->preis.'€' : 'Eintritt frei'); $preis .= ($row->ermaessigt !="" ? '/'.$row->ermaessigt.'€' : ''); //$content .= ''; $content .= '"; } $content .= ( $number==0 ? "" : '

'.$weekday.'	'.$date.'	- '; $content .= '
'.$date.'	'.$row->name." "; $content .= ($row->einlass!="" ? 'Einlass: '.$row->einlass.' / ' : ''); $content .= "Beginn: $row->beginn / "; $content .= (($row->preis > 0) ? $row->preis.'€' : 'Eintritt: frei'); $content .= (($row->frei != "on") && ($row->preis == 0) ? 'e Spende' : ''); $content .=($row->ermaessigt !="" ? '/'.$row->ermaessigt.'€' : ''); $content .="

' ) ; } echo makehtml( $pagetitle, $headertext, $submenu, $content); ?>