"; $mailMsgText = ""; for($i=0; $i".$_POST[$postKeys[$i]].""; $mailMsgText .= $postKeys[$i].":\t\t".$_POST[$postKeys[$i]]."\t\t\t"; $colCount++; if($colCount >= $maxCols){ $mailMsgHtml .= ""; $mailMsgText .= "\n"; $colCount = 0; } } } if($colCount){ for($i=0; $i<$colCount; $i++){ $mailMsgHtml .= "  "; } $mailMsgHtml .= ""; } $mailMsgHtml .= ""; $subject = "Kontaktformular procedes.de"; //$mailSent = mail($recipientEmail, $subject, $mailMsgText, "From: $email\nReply-To: $email\nError-To: support@apartmedia.de\nX-Mailer: apartmedia GmbH Bremen"); include("../mailHandling/sendMail.php"); }else{ $mailSent = false; } } //end defining mail function if($_GET["mainID"]){ settype($_GET["mainID"], "integer"); $sql = " SELECT * FROM `content` WHERE `main_nr`='{$_GET["mainID"]}' "; $sqlQuickBar = " SELECT * FROM `quickLinkBar` WHERE `main_nr`='{$_GET["mainID"]}' "; //change logo by mainID if($_GET["subID"]){ settype($_GET["subID"], "integer"); $sql .= " AND `sub_nr`='{$_GET["subID"]}'"; $sqlQuickBar .= " AND `sub_nr`='{$_GET["subID"]}'"; $jpg_logo = "logo_grau.jpg"; }else{ $sql .= "ORDER BY `sub_nr` ASC"; $sqlQuickBar .= " AND `sub_nr`='0'"; $jpg_logo = "logo_orange.jpg"; } $sqlQuickBar .= " ORDER BY `sort_key` ASC, `nr` ASC"; }else{ $sql = " SELECT `content`.* FROM `content` LEFT JOIN `mainmenu` ON (`content`.`main_nr`=`mainmenu`.`nr`) LEFT JOIN `submenu` ON (`content`.`sub_nr`=`submenu`.`nr`) ORDER BY `mainmenu`.`sort_key` ASC, `mainmenu`.`nr` ASC, `submenu`.`sort_key` ASC, `submenu`.`nr` ASC LIMIT 0,1 "; //grab first entries from quickLinkBar $sqlMinID = " SELECT MIN(`main_nr`) AS `minMainID`, MIN(`sub_nr`) AS `minSubID` FROM `quickLinkBar` ORDER BY `sort_key` ASC, `nr` ASC "; $resultMinID = get_data($sqlMinID); //end grabbing first entries from quickLinkBar $quickBarNotEmpty = mysql_num_rows($resultMinID); if($quickBarNotEmpty){ $dataMinID = mysql_fetch_array($resultMinID); $sqlQuickBar = " SELECT * FROM `quickLinkBar` WHERE `main_nr`='{$dataMinID["minMainID"]}' AND `sub_nr`='{$dataMinID["minSubID"]}' ORDER BY `sort_key` ASC, `nr` ASC "; } } //start grabbing content from db $result = get_data($sql); if(mysql_num_rows($result)){ $data = mysql_fetch_assoc($result); //start defining image vars $picTopLeft = ( empty($data["picSummary"]) || $data["picSummary"] == $emptyImage) ? processImage($data["picTopLeft"]) : processImage(false); $picTopMiddle = ( empty($data["picSummary"]) || $data["picSummary"] == $emptyImage) ? processImage($data["picTopMiddle"]) : processImage(false); $picRight = ( empty($data["picSummary"]) || $data["picSummary"] == $emptyImage) ? processImage($data["picRight"]) : processImage(false); $picBottomLeft = ( empty($data["picSummary"]) || $data["picSummary"] == $emptyImage) ? processImage($data["picBottomLeft$language"]) : processImage(false); $picTitle = ( empty($data["picSummary"]) || $data["picSummary"] == $emptyImage) ? processImage($data["picTitle$language"]) : processImage(false); $picSummary = (!empty($data["picSummary"]) && $data["picSummary"] != $emptyImage) ? processImage($data["picSummary"]) : processImage(false); //end defining image vars }else{ //if no content results have been found //start defining empty image vars $picTopLeft = processImage(false); $picTopMiddle = processImage(false); $picRight = processImage(false); $picBottomLeft = processImage(false); $picTitle = processImage(false); $picSummary = processImage(false); //end defining image vars } //end grabbing content from db //start grabbing QuickBar content from db $outputQuickBar = $outputQuickBarLay = ""; $resultQuickBar = get_data($sqlQuickBar); $numQuickBarEntries = mysql_num_rows($resultQuickBar); //define quickBar style class string $quickBarClass = (!empty($_GET["subID"])) ? "quickBar_sub" : "quickBar"; if($numQuickBarEntries){ while($dataQuickBar = mysql_fetch_array($resultQuickBar)){ $outputQuickBar .= " "; //start printing quickLink $outputQuickBar .= " "; //start implementing quickLink image if($dataQuickBar["quickPicSmall"] && $dataQuickBar["quickPicSmall"] != $emptyImage){ $quickPicSmall = processImage($dataQuickBar["quickPicSmall"]); $outputQuickBar .= " "; } //end implementing quickLink image $outputQuickBar .= "
{$dataQuickBar["quickLink$language"]}
"; //end printing quickLink $outputQuickBar .= " "; $outputQuickBarLay .= " "; } } //end grabbing QuickBar content from db //send SQL command for menu $sqlMenu = " SELECT `mainmenu`.`nr` AS `mainID`, `mainmenu`.`name$language` AS `mainName`, `submenu`.`nr` AS `subID`, `submenu`.`name$language` AS `subName` FROM `mainmenu` LEFT JOIN `submenu` ON (`mainmenu`.`nr`=`submenu`.`main_nr`) ORDER BY `mainmenu`.`sort_key` ASC, `mainmenu`.`nr` ASC, `submenu`.`sort_key` ASC, `submenu`.`nr` ASC "; $resultMenu = get_data($sqlMenu); $numMenuItems = mysql_num_rows($resultMenu); $isPrintedID = false; $subLayLeftPos = $menuSpacer; $outputSub = ""; $outputMain = " "; $counter = 0; while($dataMenu = mysql_fetch_array($resultMenu)){ $counter++; if(!$isPrintedID || $isPrintedID != $dataMenu["mainID"]){ //start closing submenu layer string $outputSub .= ($isPrintedID && $dataMenu["subID"] && !empty($outputSub)) ? "
" : ""; //end closing submenu layer string $mainLink = (isset($language)) ? "{$_SERVER["PHP_SELF"]}?mainID={$dataMenu["mainID"]}&language=$language" : "{$_SERVER["PHP_SELF"]}?mainID={$dataMenu["mainID"]}"; $outputMain .= ""; $outputMain .= ""; $outputMain .= htmlentities(trim($dataMenu["mainName"])); $outputMain .= ""; $outputMain .= ""; //start add cell spacer if($counter != $numMenuItems){ $outputMain .= "
"; } //end add cell spacer //start begin submenu layer string if($dataMenu["subID"]){ $outputSub .= "\n" : ""; //end closing submenu layer string $outputMain .= ""; ?> <? echo "$page_title | {$data["title_tag$language"]}"; ?>
alt="">
alt=""> alt=""> alt="">  
alt="">