| Main Menu | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
"; echo 'A'; echo ' B'; echo ' C'; echo ' D'; echo ' E'; echo ' F'; echo ' G'; echo ' H'; echo ' I'; echo ' J'; echo ' K'; echo ' L'; echo ' M'; echo ' N'; echo ' O'; echo ' P'; echo ' Q'; echo ' R'; echo ' S'; echo ' T'; echo ' U'; echo ' V'; echo ' W'; echo ' X'; echo ' Y'; echo ' Z'; echo ' 0..9'; echo ' andere'; echo "
"; echo ""; // $addlink = sefRelToAbs("index.php?option=com_contentbands&detail=1&id=$id"); // echo $addlink; if (isset($choice)) { echo "
"; if ($choice=="0"){ $anfrage ="SELECT jos_gigcal_bands. * FROM jos_gigcal_bands LEFT JOIN content_festivals ON jos_gigcal_bands.bandname = content_festivals.name WHERE content_festivals.name IS NULL AND (jos_gigcal_bands.bandname LIKE '1%' OR jos_gigcal_bands.bandname LIKE '2%' OR jos_gigcal_bands.bandname LIKE '3%' OR jos_gigcal_bands.bandname LIKE '4%' OR jos_gigcal_bands.bandname LIKE '5%' OR jos_gigcal_bands.bandname LIKE '6%' OR jos_gigcal_bands.bandname LIKE '7%' OR jos_gigcal_bands.bandname LIKE '8%' OR jos_gigcal_bands.bandname LIKE '9%' OR jos_gigcal_bands.bandname LIKE '0%') AND jos_gigcal_bands.bandname NOT LIKE '21%' and jos_gigcal_bands.published='1' ORDER BY `bandname`"; $anfrage ="SELECT * FROM content_seo_bands WHERE (bandname LIKE '1%' OR bandname LIKE '2%' OR bandname LIKE '3%' OR bandname LIKE '4%' OR bandname LIKE '5%' OR bandname LIKE '6%' OR bandname LIKE '7%' OR bandname LIKE '8%' OR bandname LIKE '9%' OR bandname LIKE '0%') AND bandname NOT LIKE '21%' ORDER BY `bandname`"; } elseif ($choice=="1") $anfrage = "select * from content_seo_bands where bandname LIKE '%$name%' order by bandname"; elseif ($choice=="2") $anfrage = "select * from content_seo_bands where bandname LIKE '(%' or bandname LIKE '[%' or bandname LIKE '!%'or bandname LIKE '.%' or bandname LIKE ':%' order by bandname"; elseif ($choice=="U") $anfrage ="SELECT * FROM content_seo_bands WHERE bandname LIKE '$choice%' or bandname like '%mutter%' ORDER BY `bandname`"; else $anfrage ="SELECT * FROM content_seo_bands WHERE bandname LIKE '$choice%' ORDER BY `bandname`"; $result=mysql_db_query("labellos",$anfrage); while ($row=mysql_fetch_array($result)) { $id=$row["gigcal_bands_id"]; $name=$row["bandname"]; echo "
$row[1]"; } } } if (isset($detail)) { if ($test!=1) { $anfrage = "select bandname_seo from content_seo_bands where id=$id"; $result=mysql_db_query("labellos",$anfrage); $row=mysql_fetch_row($result); $site=$row[0].".labellos.de"; header("HTTP/1.1 301 Moved Permanently"); header("location: http://$site"); } $anfrage = "select * from jos_gigcal_bands where gigcal_bands_id=$id"; $result=mysql_db_query("labellos",$anfrage); $row=mysql_fetch_row($result); $id=$row[0]; $name=$row[5]; $bandname=$name; $decription=$row[2]; $website= $row[6]; $decription=$row[12]; $website2= $row[13]; $mainframe->SetPageTitle( $name ); if (strlen($decription)>200) { $des=$name.":".trim(substr(strip_tags($decription),0,205)); $des=str_replace(" ","",$des); $des_lows=explode(" ",$des); $i=0; foreach ($des_lows as $des) { if (strlen($des)>1) { $des=str_replace("ö","oe",$des); $des=str_replace("ü","ue",$des); $des=str_replace("ä","ae",$des); $des=str_replace("Ö","Oe",$des); $des=str_replace("Ü","Ue",$des); $des=str_replace("Ä","Ae",$des); $des=str_replace(""","",$des); if($i==0) $des_low=$des." "; else $des_low.=$des." "; } $i++; } $key=trim(strip_tags($decription)); $key=str_replace(" ","",$key); $keyss=explode(" ",$key); foreach ($keyss as $keys) { if (ucfirst($keys)==($keys)) { if (strlen($keys)>6) { $tt=str_replace(",","",$keys); $tt=str_replace("\"","",$tt); $tt=str_replace(")","",$tt); $tt=str_replace("(","",$tt); $tt=str_replace("ö","oe",$tt); $tt=str_replace("ü","ue",$tt); $tt=str_replace("ä","ae",$tt); $tt=str_replace("Ö","Oe",$tt); $tt=str_replace("Ü","Ue",$tt); $tt=str_replace("Ä","Ae",$tt); $tt=str_replace(""","",$tt); $meta[]=$tt; } } } for ($i=0;$i<10;$i++) { $t=rand(0,count($meta)); if ($i==0) $meta_key=$meta[$t].","; else { if (strlen($meta[$t])>0) $meta_key.=$meta[$t].","; else $i--; } } $meta_key=substr($meta_key,0,-1); } else { $des_low="LabelLos.de - Hier findet ihr die Biographie, Konzertdates und Festivaltermine der Band $name"; $meta_key="LabelLos,$name,Band,Konzerte,Biographie,Festivals,Bandinfos,Gothic,Rock"; } $mainframe->prependMetaTag("keywords", $meta_key); $mainframe->prependMetaTag("description",$des_low); $contents= "
$name
"; $bandname_link=str_replace("%","%25",$name); $bandname_link=str_replace(" ","%20",$bandname_link); $bandname_link=str_replace("&","%26",$bandname_link); $contents.="| $website $website2 | ";
$contents.= "[Livedates von $name] "; $contents.= "[Zu meinen Lieblingsbands hinzufügen] "; $contents.= "[Zur Fanpage]"; $contents.=" |
".$decription."
";
$contents.="Konzerte | Festivals | ";
$contents.="|||||
";
$time=time()-86400;
$band_id=$id;
$anfrage = "select * from jos_gigcal_gigs a, jos_gigcal_bands b, jos_gigcal_venues c where a.gigdate>$time and a.gigcal_bands_id=$band_id and a.gigcal_bands_id =b.gigcal_bands_id and a.gigcal_venues_id=c.gigcal_venues_id order by a.gigdate ";
$result=mysql_db_query("labellos",$anfrage);
if (mysql_num_rows($result)>0)
{
$contents.="
| ";
$contents.="";
$anfrage2 = "select * from content_festivals a, content_festival_id b where a.date_to>$time and b.band_id=$band_id and a.id=b.festival_id order by a.date_from";
$result2=mysql_db_query("labellos",$anfrage2);
if (mysql_num_rows($result2)>0)
{
$contents.="
|
"; echo $contents; } ?>