Termine

='“.$today[‚year‘].“.“.$today[‚mon‘].“.“.$today[‚mday‘].“‚ AND inquiry<>1 AND private=0 order by date,starttime „);
while($rec=mysql_fetch_array($datessql)){
$fromdate=$rec[‚date‘];
if(substr($fromdate,8,2)!=’10‘){ $fday=str_replace(‚0′,“,substr($fromdate,8,2));}else{$fday=’10‘;}
if(substr($fromdate,5,2)!=’10‘){ $fmonth=str_replace(‚0′,“,substr($fromdate,5,2));}else{$fmonth=’10‘;}
$todate=$rec[‚todate‘];
if(substr($todate,8,2)!=’10‘){ $tday=str_replace(‚0′,“,substr($todate,8,2));}else{ $tday=’10‘;}
if(substr($todate,5,2)!=’10‘){ $tmonth=str_replace(‚0′,“,substr($todate,5,2));}else{ $tmonth=’10‘;}
if($now<=date("U",mktime(0,0,0,$fmonth,$fday,substr($fromdate,0,4))) || $now<=date("U",mktime(0,0,0,$tmonth,$tday,substr($todate,0,4))) || $rec['ever']==1){ if (check_mobi($_SERVER['HTTP_USER_AGENT'])) { echo "
„;
if($rec[‚wp‘]==“){
echo „„;
}else{
echo „
„;
}
echo „

„;
$fromdate=$rec[‚date‘];
$todate=$rec[‚todate‘];
$fday=substr($fromdate,8,2);
$fmonth=substr($fromdate,5,2);
$tday=substr($todate,8,2);
$tmonth=substr($todate,5,2);
if(substr($fromdate,8,2)!=’10‘){ $fday=str_replace(‚0′,“,substr($fromdate,8,2));}else{$fday=’10‘;}
if(substr($fromdate,5,2)!=’10‘){ $fmonth=str_replace(‚0′,“,substr($fromdate,5,2));}else{$fmonth=’10‘;}
if(substr($todate,8,2)!=’10‘){ $tday=str_replace(‚0′,“,substr($todate,8,2));}else{ $tday=’10‘;}
if(substr($todate,5,2)!=’10‘){ $tmonth=str_replace(‚0′,“,substr($todate,5,2));}else{ $tmonth=’10‘;}
$daterec=$rec[‚date‘];
$fromdate=substr($daterec,8,2).“.“.substr($daterec,5,2).“.“.substr($daterec,2,2);
$weekday=date(„w“,mktime(0,0,0,substr($daterec,5,2),substr($daterec,8,2),substr($daterec,2,2)));
echo „

„.$days[$weekday].“, $fromdate, „.$rec[’starttime‘].“ Uhr

„;
$aquery=mysql_query(„SELECT * FROM artists WHERE id='“.$rec[‚artist‘].“‚“);
$arec=mysql_fetch_array($aquery);
echo „

„;
echo „

„;
$line_a=$rec[‚line_a‘];
$line_b=$rec[’name‘];
$line_c=$rec[‚line_c‘];
echo „

„.$line_a.“, „.$line_c.“ | „.$line_b.“

„;
echo „

„;
echo „

„;
echo „
„;
echo „

„;
}else{
echo „

„;
$daterec=$rec[‚date‘];
$fromdate=substr($daterec,8,2).“.“.substr($daterec,5,2).“.“.substr($daterec,2,2);
$weekday=date(„w“,mktime(0,0,0,substr($daterec,5,2),substr($daterec,8,2),substr($daterec,2,2)));
$time=$rec[’starttime‘];
//if($rec[‚highl‘]==1){ $bgcolor=’#FFCC00′;}else{$bgcolor=’#FFFF00′;}
echo „

„;
echo „$days[$weekday], „;
echo $fromdate.“ – „.$time.“  „;
if(substr($rec[‚todate‘],0,10)!=’0000-00-00′){
echo „,  bis“;
$daterec=$rec[‚todate‘];
$todate=substr($daterec,8,2).“.“.substr($daterec,5,2).“.“.substr($daterec,2,2);
echo „
$todate“;
}
echo „
„;
//echo „

„;
echo „

„;
$aquery=mysql_query(„SELECT * FROM artists WHERE id='“.$rec[‚artist‘].“‚“);
$arec=mysql_fetch_array($aquery);
if($rec[‚wp‘]==“){
echo „„;
}else{
echo „
„;
}
echo „„;
echo „
„;
echo „

„;
echo „

„;
echo „

„;
echo „„;
if(substr($rec[‚line_a‘],0,3)==’www‘){$line_a=’Link: ‚.$rec[‚line_a‘].‘‚;}else{$line_a=$rec[‚line_a‘];}
if(substr($rec[’name‘],0,3)==’www‘){$line_b=’Link: ‚.$rec[’name‘].‘‚;}else{$line_b=$rec[’name‘];}
if(substr($rec[‚line_c‘],0,3)==’www‘){$line_c=’Link: ‚.$rec[‚line_c‘].‘‚;}else{$line_c=$rec[‚line_c‘];}
if($rec[‚wp‘]==“){
echo „„;
}else{
echo „
„;
}
echo $line_a.“
„;
echo „, „.$line_c.“
„;
echo „
„;
if($rec[‚wp‘]==“){
echo „„;
}else{
echo „
„;
}
echo $line_b.“

„;
$acount=0;
if($rec[‚artist‘]>0){
$aquery=mysql_query(„Select * from artists where id='“.$rec[‚artist‘].“‚ AND hide=0″);
$arec=mysql_fetch_array($aquery);
echo „Mit: „.$arec[’name‘].“„;
$acount++;
}
if($rec[‚artist1‘]>0){
$aquery=mysql_query(„Select * from artists where id='“.$rec[‚artist1‘].“‚ AND hide=0″);
if($acount>0 && mysql_num_rows($aquery)>0){ echo “ | „; }else{ if($acount==0 && mysql_num_rows($aquery)==0) {echo „Mit: „;} }
$arec=mysql_fetch_array($aquery);
echo „„.$arec[’name‘].“„;
$acount++;
}
if($rec[‚artist2‘]>0){
$aquery=mysql_query(„Select * from artists where id='“.$rec[‚artist2‘].“‚ AND hide=0″);
if($acount>0 && mysql_num_rows($aquery)>0){ echo “ | „; }else{ if($acount==0 && mysql_num_rows($aquery)==0) {echo „Mit: „; }}
$arec=mysql_fetch_array($aquery);
echo „„.$arec[’name‘].“„;
$acount++;
}
if($rec[‚artist2‘]>0){
$aquery=mysql_query(„Select * from artists where id='“.$rec[‚artist3‘].“‚ AND hide=0″);
if($acount>0 && mysql_num_rows($aquery)>0){ echo “ | „; }else{ if($acount==0 && mysql_num_rows($aquery)==0) {echo „Mit: „;} }
$arec=mysql_fetch_array($aquery);
echo „„.$arec[’name‘].“„;
$acount++;
echo „

„;
}
if($rec[‚details‘]!=“){
echo „

„;
if($rec[‚wp‘]==“){
echo „„;
}else{
echo „
„;
}
echo „Mehr Infos…
„;
echo „

„;
}
echo „

„;
echo „

„;
// echo „

 

„;
}
}
}
}else{
echo „Zurück

„;
$datessql=mysql_query(„Select * from dates where id='“.mysql_real_escape_string($_GET[‚id‘]).“‚ „);
$rec=mysql_fetch_array($datessql);
$fromdate=$rec[‚date‘];
if(substr($fromdate,8,2)!=’10‘){ $fday=str_replace(‚0′,“,substr($fromdate,8,2));}else{$fday=’10‘;}
if(substr($fromdate,5,2)!=’10‘){ $fmonth=str_replace(‚0′,“,substr($fromdate,5,2));}else{$fmonth=’10‘;}
$todate=$rec[‚todate‘];
if(substr($todate,8,2)!=’10‘){ $tday=str_replace(‚0′,“,substr($todate,8,2));}else{ $tday=’10‘;}
if(substr($todate,5,2)!=’10‘){ $tmonth=str_replace(‚0′,“,substr($todate,5,2));}else{ $tmonth=’10‘;}
echo „

„;
$daterec=$rec[‚date‘];
$fromdate=substr($daterec,8,2).“.“.substr($daterec,5,2).“.“.substr($daterec,2,2);
$weekday=date(„w“,mktime(0,0,0,substr($daterec,5,2),substr($daterec,8,2),substr($daterec,2,2)));
$time=$rec[’starttime‘];
echo „

„;
echo „$days[$weekday]
„;
echo $fromdate.“ – „.$time.“  „;
if(substr($rec[‚todate‘],0,10)!=’0000-00-00′){
echo „
  bis“;
$daterec=$rec[‚todate‘];
$todate=substr($daterec,8,2).“.“.substr($daterec,5,2).“.“.substr($daterec,2,2);
echo „
$todate“;
}
echo „
„;
$aquery=mysql_query(„SELECT * FROM artists WHERE id='“.$rec[‚artist‘].“‚“);
$arec=mysql_fetch_array($aquery);
echo „„;
echo „

„;
echo „

„;
echo „„;
if(substr($rec[‚line_a‘],0,3)==’www‘){$line_a=’Link: ‚.$rec[‚line_a‘].‘‚;}else{$line_a=$rec[‚line_a‘];}
if(substr($rec[’name‘],0,3)==’www‘){$line_b=’Link: ‚.$rec[’name‘].‘‚;}else{$line_b=$rec[’name‘];}
if(substr($rec[‚line_c‘],0,3)==’www‘){$line_c=’Link: ‚.$rec[‚line_c‘].‘‚;}else{$line_c=$rec[‚line_c‘];}
echo „„.$line_a.“„;
echo „, „.$line_c.“
„;
echo „
„.$line_b.“

„;
$acount=0;
if($rec[‚artist‘]>0){
$aquery=mysql_query(„Select * from artists where id='“.$rec[‚artist‘].“‚ AND hide=0″);
$arec=mysql_fetch_array($aquery);
echo „Mit: „.$arec[’name‘].“„;
$acount++;
}
if($rec[‚artist1‘]>0){
$aquery=mysql_query(„Select * from artists where id='“.$rec[‚artist1‘].“‚ AND hide=0″);
if($acount>0 && mysql_num_rows($aquery)>0){ echo “ | „; }else{ if($acount==0 && mysql_num_rows($aquery)==0) {echo „Mit: „; }}
$arec=mysql_fetch_array($aquery);
echo „„.$arec[’name‘].“„;
$acount++;
}
if($rec[‚artist2‘]>0){
$aquery=mysql_query(„Select * from artists where id='“.$rec[‚artist2‘].“‚ AND hide=0″);
if($acount>0 && mysql_num_rows($aquery)>0){ echo “ | „; }else{ if($acount==0 && mysql_num_rows($aquery)==0) {echo „Mit: „; }}
$arec=mysql_fetch_array($aquery);
echo „„.$arec[’name‘].“„;
$acount++;
}
if($rec[‚artist2‘]>0){
$aquery=mysql_query(„Select * from artists where id='“.$rec[‚artist3‘].“‚ AND hide=0″);
if($acount>0 && mysql_num_rows($aquery)>0){ echo “ | „; }else{if($acount==0 && mysql_num_rows($aquery)==0) { echo „Mit: „;} }
$arec=mysql_fetch_array($aquery);
echo „„.$arec[’name‘].“„;
$acount++;
echo „

„;
}
?>

„;
echo „

„;
if($rec[‚details‘]!=“){
echo „

„;
echo „„.nl2br(utf8_encode($rec[‚details‘])).“

„;
}
if(file_exists(‚dates/‘.$rec[‚id‘].‘.jpg‘)){ echo „

„; }
}
?>