Main Menu
Home
News
Banddatenbank
Rezensionen
Konzertsuche
Festivals
Musikdownloads
Galerie
FAQ
Impressum
Festivals"; $time = time(); if (!isset($history)) $anfrage = "select * from content_festivals where date_to>$time order by date_from;"; else $anfrage = "select * from content_festivals where date_to<$time order by date_from;"; $result=mysql_db_query("labellos",$anfrage); echo "

Hier findet ihr die wichtigsten Festivals des Jahres mit einem überwiegend \"schwarzen\" Line-Up.

"; echo "

"; while ($row=mysql_fetch_array($result)) { $id=$row["id"]; $name=$row["name"]; $date_from = $row["date_from"]; $date_to = $row["date_to"]; $ort=$row["city"]; $state=$row["state"]; $date = date("d.m.Y", $date_from); echo ""; $anfrage3="SELECT festival_name_seo from content_seo_festivals where festival_name=\"$name\""; $result3=mysql_db_query("labellos",$anfrage3); $line=mysql_fetch_row($result3); $link="http://".$line[0].".labellos.de"; echo ""; echo ""; echo ""; } echo "
$date -"; $date = date("d.m.Y", $date_to); echo " $date$name$ort ($state)
"; if (!isset($history)) echo "

Vergangene Festivals"; else echo "

Aktuelle Festivals"; } else { echo "

"; $anfrage = "select * from content_festivals where id=$id"; $result=mysql_db_query("labellos",$anfrage); $row=mysql_fetch_row($result); $name=$row[1]; $city=$row[2]; $plz=$row[3]; $state=$row[4]; $description=$row[5]; $date_from=$row[6]; $date_to=$row[7]; $link=$row[8]; $saleslink=$row[9]; $date_from= date("d.m.Y", $date_from); $date_to= date("d.m.Y", $date_to); $flyer=$row[12]; $mainframe->SetPageTitle( $name ); $desc="Hier findet Ihr alle Informationen zum ".$name." vom ".$date_from ." bis ". $date_to." in ".$city.",".$plz." ".$state; $mainframe->prependMetaTag("description",$desc); $keywords=str_replace(" ",",",$name).","; $festival=$name; echo "

$name

"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
$date_from - $date_to
$city, $plz $state
$description
$link
[Zum Merkzettel hinzufügen]
"; echo "

Künstler:

"; $anfrage="select more_bands from content_festivals where id=$id"; $result=mysql_db_query("labellos",$anfrage); $row=mysql_fetch_row($result); $bands=explode(";",$row[0]); $band_array=array(); foreach ($bands as $band) { array_push($band_array,$band); } $anfrage = "select b.gigcal_bands_id,b.bandname from content_festival_id a, jos_gigcal_bands b where a.festival_id=$id and b.gigcal_bands_id=a.band_id order by b.bandname"; $result=mysql_db_query("labellos",$anfrage); while ($row=mysql_fetch_array($result)) { $id= $row[0]; $name = $row[1]; array_push($band_array,$name); } natcasesort($band_array); $no_db=false; foreach ($band_array as $name) { if ($name=="") { } else { $anfrage= "select * from content_seo_bands where bandname=\"$name\""; $result2 = mysql_query($anfrage); if (mysql_num_rows($result2)>0) { $row2=mysql_fetch_row($result2); $bandlink="http://".$row2[2].".labellos.de"; echo "$name
"; } else { $no_db=true; echo "".$name."
"; } } } echo "

"; if (strlen($flyer)>0) { echo "$festival"; } echo "
"; if ($no_db==true) { echo "

Grau eingefärbte Bands/Künstler sind nicht in der LabelLos.de-Datenbank

"; } for ($i=0;$i<10;$i++) { $num=rand(0,count($band_array)); $keywords.=$band_array[$num].","; } $keywords = substr($keywords, 0, -1); $mainframe->prependMetaTag("keywords", $keywords ); } ?>