/*--------------- Verbindung mit der Datenbank hertstellen ------------------------------------------*/ function connect_database(){ $dbserver = "localhost"; $dbname = "usr_web1265_1"; //LifeDB //$dbname = "usr_web1265_2"; //TestDB $dbuser = "web1265"; $dbpwd = "nokov0"; //$dbname = "web1265"; //$dbuser = "root"; //$dbpwd = ""; $connection = mysql_connect($dbserver, $dbuser, $dbpwd)or die("Keine Verbindung möglich!"); mysql_select_db($dbname, $connection)or die("Auswahl der Datenbank fehlgeschlagen"); } /*-------------- PHP Dateien laden --------------------------------------------------------------------*/ function get_cms_link ($mod) { $itemresult = fetch_data("SELECT * FROM t_cms_mod WHERE mod_id ='$mod'"); if ($itemname = mysql_fetch_array($itemresult, MYSQL_ASSOC)){ if (strlen($itemname["mod_file"])>0) { return $itemname["mod_file"]; } else { return "index.php?mod=$mod"; } } } function get_site_link ($mod) { $itemresult = fetch_data("SELECT * FROM t_site_mod WHERE mod_id ='$mod'"); if ($itemname = mysql_fetch_array($itemresult, MYSQL_ASSOC)){ if (strlen($itemname["mod_file"])>0) { return $itemname["mod_file"]; } else { return "home.php?mod=$mod"; } } } function checkFile($file){ if(file_exists($file)){ return true; } else{ return false; } } function makeThumb($path, $thumbpath, $name){ $Grafikdatei = $path.$name; $Bilddaten = getimagesize($Grafikdatei); $OriginalBreite = $Bilddaten[0]; $OriginalHoehe = $Bilddaten[1]; $ThumbnailBreite = 200; if($OriginalBreite < $ThumbnailBreite) { $ThumbnailBreite=$OriginalBreite; } $Skalierungsfaktor = $OriginalBreite/$ThumbnailBreite; $ThumbnailHoehe = intval($OriginalHoehe/$Skalierungsfaktor); if($Bilddaten[2] == 1) { $Originalgrafik = ImageCreateFromGIF($Grafikdatei); $Thumbnailgrafik = ImageCreateTrueColor($ThumbnailBreite, $ThumbnailHoehe); ImageCopyResized($Thumbnailgrafik, $Originalgrafik, 0, 0, 0, 0, $ThumbnailBreite, $ThumbnailHoehe, $OriginalBreite, $OriginalHoehe); ImageGIF($Thumbnailgrafik,$thumbpath."thumb_".$name); } elseif($Bilddaten[2] == 2) { $Originalgrafik = ImageCreateFromJPEG($Grafikdatei); $Thumbnailgrafik = ImageCreateTrueColor($ThumbnailBreite, $ThumbnailHoehe); ImageCopyResized($Thumbnailgrafik, $Originalgrafik, 0, 0, 0, 0, $ThumbnailBreite, $ThumbnailHoehe, $OriginalBreite, $OriginalHoehe); ImageJPEG($Thumbnailgrafik, $thumbpath."thumb_".$name); } elseif($Bilddaten[2] == 3) { $Originalgrafik = ImageCreateFromPNG($Grafikdatei); $Thumbnailgrafik = ImageCreateTrueColor($ThumbnailBreite, $ThumbnailHoehe); ImageCopyResized($Thumbnailgrafik, $Originalgrafik, 0, 0, 0, 0, $ThumbnailBreite, $ThumbnailHoehe, $OriginalBreite, $OriginalHoehe); ImagePNG($Thumbnailgrafik, $thumbpath."thumb_".$name); } } ?> /*----------- SELECT STATEMENT --------------------------------*/ function fetch_data($stmt){ $result = mysql_query($stmt) or die(" FEHLER: Beim ausführen des SELECT Statements: ".$stmt); return $result; } /*---------- INSERT STATEMENT -------------------------------*/ function insert_data($stmt){ mysql_query($stmt) or die (" FEHLER: Beim ausführen des INSERT Statements: ".$stmt); } /*---------- UPDATE STATEMENT -------------------------------*/ function update_data($stmt){ mysql_query($stmt) or die (" FEHLER: Beim ausführen des UPDATE Statements: ".$stmt); } ?> $boxtablepref = ""; function print_navigation($logo, $mod){ /*-------------- Boxen laden -----------------------------------*/ $upperposition = 5; $lowerposition = 5; $divclass = ""; $color = ""; $navpoint = $navresult = fetch_data("SELECT * FROM t_site_navigation WHERE visible=1 ORDER BY position "); while($line = mysql_fetch_array($navresult, MYSQL_ASSOC)){ $outerwidth = $line["width"]; $innerwidth = $line["width"]-2; if($line["mod_id"] == $mod){ $divclass = 'navigationcontent'; $color = "color:#444A69"; $navpoint = $line["navigation_name"]."\n"; } else{ $divclass = 'navigationcontent'; $color = "color:#000000"; $navpoint = "".$line["navigation_name"]."\n"; } if($line["position"] < 4){ echo "
\n"; $upperposition = $upperposition + $line["width"] -1; } else{ echo "\n"; $lowerposition = $lowerposition + $line["width"] -1; } } echo "\n"; echo "\n"; } ?> include ("list.php"); include ("gallery.php"); include ("text.php"); function print_content($mod, $modtyp){ if($modtyp != 'katalog_list'){ /*-------------- Boxen laden -----------------------------------*/ $modresult = fetch_data("SELECT * FROM t_site_mod WHERE mod_id='$mod'"); $line = mysql_fetch_array($modresult, MYSQL_ASSOC); $picresult = fetch_data("SELECT * FROM t_site_mod_pic WHERE mod_id='$mod' AND gal_item != 1"); $pic = mysql_fetch_array($picresult, MYSQL_ASSOC); echo "
";
echo "";
echo "