<?
function showKalender($verbandliste,$von_t,$von_m,$von_y,$bis_t,$bis_m,$bis_y,$id,$start) {
$monataktuel = date("m",time());
$anzahl_pro_zeile = 13; // Anzahl pages im PAGIN Menü
$display=10; // Anzeigen pro 1 Seite
$akt_zeilen_cont = 0;
if ( $verbandliste != "" && $von_t != "" && $von_m != "" && $von_y != "" && $bis_t != "" && $bis_m != "" && $bis_y != "" ) {
$query="SELECT * FROM menu WHERE id=".$id;
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$title=$row['text'];
echo "<tr><td><span class='headlines'>".$title."<br><br></span></td></tr>";
if ( $verbandliste == 1) {
$query="SELECT * FROM kalender WHERE
menu_id=".$id."
AND
LPAD( SUBSTRING_INDEX( beginn, '.', 1 ) , 2, '0' ) >= $von_t
AND
LPAD( SUBSTRING_INDEX( beginn, '.', 1 ) , 2, '0' ) <= $bis_t
AND
LPAD( SUBSTRING_INDEX( SUBSTRING_INDEX( beginn, '.', 2 ) , '.', -1 ) , 2, '0' ) >= $von_m
AND
LPAD( SUBSTRING_INDEX( SUBSTRING_INDEX( beginn, '.', 2 ) , '.', -1 ) , 2, '0' ) <= $bis_m
AND
SUBSTRING_INDEX( beginn, '.', -1 ) >= $von_y
AND
SUBSTRING_INDEX( beginn, '.', -1 ) <= $bis_y
ORDER BY SUBSTRING_INDEX( beginn, '.', -1 ) , LPAD( SUBSTRING_INDEX( SUBSTRING_INDEX( beginn, '.', 2 ) , '.', -1 ) , 2, '0' ) , LPAD( SUBSTRING_INDEX( beginn, '.', 1 ) , 2, '0' )";
} else {
$query="SELECT * FROM kalender
WHERE
menu_id=".$id."
AND
LPAD( SUBSTRING_INDEX( beginn, '.', 1 ) , 2, '0' ) >= $von_t
AND
LPAD( SUBSTRING_INDEX( SUBSTRING_INDEX( beginn, '.', 2 ) , '.', -1 ) , 2, '0' ) >= $von_m
AND
SUBSTRING_INDEX( beginn, '.', -1 ) >= $von_y
AND
LPAD( SUBSTRING_INDEX( beginn, '.', 1 ) , 2, '0' ) <= $bis_t
AND
LPAD( SUBSTRING_INDEX( SUBSTRING_INDEX( beginn, '.', 2 ) , '.', -1 ) , 2, '0' ) <= $bis_m
AND
SUBSTRING_INDEX( beginn, '.', -1 ) <= $bis_y
AND
beschreibung5 LIKE '%".$verbandliste."%'
ORDER BY SUBSTRING_INDEX( beginn, '.', -1 ) , LPAD( SUBSTRING_INDEX( SUBSTRING_INDEX( beginn, '.', 2 ) , '.', -1 ) , 2, '0' ) , LPAD( SUBSTRING_INDEX( beginn, '.', 1 ) , 2, '0' )";
}
$result=mysql_query($query);
}
|