// // ------------------------------------------------------------------------- // // Original Author: Nobse, Bama // Author Website : http://www.e-xoops.de, http://service.bama-webdesign.de // License Type : GPL: See /manual/LICENSES/GPL.txt // ------------------------------------------------------------------------- // include("header.php"); include(XOOPS_ROOT_PATH."/header.php"); mysql_connect("localhost", "","") or die ("Keine Verbindung moeglich"); mysql_select_db("exoops106a") or die ("Die Datenbank existiert nicht"); $abfrage = "SELECT * FROM ".$db->prefix("ecal_location"); $ergebnis = mysql_query($abfrage); OpenTable(); include ("include/nav.php"); //hier bitte die schleife durchlaufen lassen while ($result=mysql_fetch_array($ergebnis)){ $result3 = "SELECT imgurl FROM ".$db->prefix("ecal_cat")." WHERE cid=".$result['cid']; $ergebnis1 = mysql_query($result3); $result2 = mysql_fetch_array($ergebnis1); $imgurl = substr($result2['imgurl'],0,4); if ($imgurl == "http") { $imgurl = ""; }else{ if(@is_file("cache/logos/".$result2['imgurl'])){ $imgurl = ""; }else{ $imgurl = " "; } } echo ""; echo "

"._CAL_LOCATIONTERMIN. " ".$result['location']."

"; echo ""; echo ""; echo ""; if ($xoopsUser) { if ($xoopsUser->isAdmin($xoopsModule->mid()) ) { echo ""; } } echo "

".$imgurl."	".$result['beschreibung'].""; echo " "; echo ""; echo ""; echo ""; echo ""; echo ""; echo " "._CAL_ADRESSE." ".$result['plz']." ".$result['ort']." "._CAL_STRASSE." ".$result['strasse']." "._CAL_TEL." ".$result['tel']." "._CAL_EMAIL." ".$result['email']." Fotos: "._URL." ".$result['url']." "; echo "

"; } //while-ende CloseTable(); include(XOOPS_ROOT_PATH."/footer.php"); ?>