Termine unserer Künstler

='".$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){ 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 ""; 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 "

"; } } ?>