	<?php
require("_header.php");
?>
         <a name="start"></a>
         <ul class="slider fullscreen" id="start">
<?php
$i=0;
$sql = "SELECT * FROM ".$dbprefix."page WHERE parent=42 AND visible=1 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
        $i++;
        echo "\t\t<li";
        if ($i==1) echo " class=\"active\"";
        echo ">\r\n";
        $sql2 = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=".$row["id"]." ORDER BY pos";
        $mysql2->query($sql2);
        while ($row2 = $mysql2->fetchRow()) {
                  if ($row2["content_type"] == "image") {
                           $sql3 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row2["content_id"];
                           $mysql3->query($sql3);
                           while($row3 = $mysql3->fetchRow()) {
                                  $img = $row3["image"];
                                  $s = getimagesize("images/".$img);
                                  $alt = $row3["alt"];
                                  echo "\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                           }
                  } else {
                          $sql3 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row2["content_id"];
                          $mysql3->query($sql3);
                          $txt = str_replace("\r\n","<br />",$mysql3->fetchRow(0));
                          echo "\t\t\t<div>".$txt."</div>\r\n";
                  }
        }
        echo "\t\t</li>\r\n";
}
if ($i>1) {
?>
                 <li class="controls">
                         <ul class="dots" style="width:<?php echo ($i*29)-10; ?>px; margin-left:-<?php echo (($i*29)-10)/2; ?>px;">
                                 <li class="first active"><a href="javascript:;"></a></li>
<?php
for ($j=2;$j<=$i;$j++) echo "\t\t\t\t<li><a href=\"javascript:;\"></a></li>\r\n";
?>
                         </ul>
                 </li>
<?php } ?>
         </ul>

         <a name="unternehmen"></a>
         <div class="slider" id="unternehmen">
<?php
$sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=45 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         if ($row["content_type"] == "image") {
                  $sql2 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  while($row2 = $mysql2->fetchRow()) {
                         $img = $row2["image"];
                         $s = getimagesize("images/".$img);
                         $alt = $row2["alt"];
                         echo "\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                  }
         } else {
                 $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                 $mysql2->query($sql2);
                 $txt = str_replace("\r\n","<br />",$mysql2->fetchRow(0));
                 echo "\t\t<div>".$txt."</div>\r\n";
         }
}
?>
         </div>
         <div class="content_outer">
                  <a href="#kontaktformular" class="kontakt">Kontakt aufnehmen</a>
                  <div class="content_inner">
<?php
$sql = "SELECT * FROM ".$dbprefix."page WHERE id=1";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         echo "\t\t\t<h1>".$row["nav_name"]."</h1>\r\n";
         echo "\t\t\t<h2>".$row["meta_title"]."</h2>\r\n";
}
$sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=1 ORDER BY pos";
$mysql->query($sql);
$t=0; $i=0;
while ($row = $mysql->fetchRow()) {
         if ($row["content_type"] == "image") {
                  $i++;
                  $sql2 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  while($row2 = $mysql2->fetchRow()) {
                         $img = $row2["image"];
                         $s = getimagesize("images/".$img);
                         $alt = $row2["alt"];
                         echo "\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                  }
         } else {
                  $t++;
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  $txt = str_replace("\r\n","<br />",str_replace("\r\n\r\n","</p><p>",$mysql2->fetchRow(0)));
                  echo "\t\t\t<p>".$txt."</p><br /><br />\r\n";
         }
}
?>
                  </div>
         </div>

         <a name="wir"></a>
         <ul class="slider" id="wir">
<?php
$i=0;
$sql = "SELECT * FROM ".$dbprefix."page WHERE parent=46 AND visible=1 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
        $i++;
        echo "\t\t<li";
        if ($i==1) echo " class=\"active\"";
        echo ">\r\n";
        $sql2 = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=".$row["id"]." ORDER BY pos";
        $mysql2->query($sql2);
        while ($row2 = $mysql2->fetchRow()) {
                  if ($row2["content_type"] == "image") {
                           $sql3 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row2["content_id"];
                           $mysql3->query($sql3);
                           while($row3 = $mysql3->fetchRow()) {
                                  $img = $row3["image"];
                                  $s = getimagesize("images/".$img);
                                  $alt = $row3["alt"];
                                  echo "\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                           }
                  } else {
                          $sql3 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row2["content_id"];
                          $mysql3->query($sql3);
                          $txt = str_replace("\r\n","<br />",$mysql3->fetchRow(0));
                          echo "\t\t\t<div>".$txt."</div>\r\n";
                  }
        }
        echo "\t\t</li>\r\n";
}
if ($i>1) {
?>
                 <li class="controls">
                         <ul class="dots" style="width:<?php echo ($i*29)-10; ?>px; margin-left:-<?php echo (($i*29)-10)/2; ?>px;">
                                 <li class="first active"><a href="javascript:;"></a></li>
<?php
for ($j=2;$j<=$i;$j++) echo "\t\t\t\t<li><a href=\"javascript:;\"></a></li>\r\n";
?>
                         </ul>
                 </li>
<?php } ?>
         </ul>
         <div class="content_outer">
                  <a href="#kontaktformular" class="kontakt">Kontakt aufnehmen</a>
                  <div class="content_inner">
<?php
$sql = "SELECT * FROM ".$dbprefix."page WHERE id=2";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         echo "\t\t\t<h1>".$row["nav_name"]."</h1>\r\n";
         echo "\t\t\t<h2>".$row["meta_title"]."</h2>\r\n";
}
$sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=2 ORDER BY pos";
$mysql->query($sql);
$t=0; $i=0;
while ($row = $mysql->fetchRow()) {
         if ($row["content_type"] == "image") {
                  $i++;
                  $sql2 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  while($row2 = $mysql2->fetchRow()) {
                         $img = $row2["image"];
                         $s = getimagesize("images/".$img);
                         $alt = $row2["alt"];
                         echo "\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                  }
         } else {
                  $t++;
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  $txt = str_replace("\r\n","<br />",str_replace("\r\n\r\n","</p><p>",$mysql2->fetchRow(0)));
                  echo "\t\t\t<p>".$txt."</p>\r\n";
         }
}
?>
                           <br /><br />

<?php
$sql = "SELECT * FROM ".$dbprefix."page WHERE id=9";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         echo "\t\t\t<h2>".$row["nav_name"]."</h2>\r\n\t\t\t<ul id=\"mix\">\r\n";
}
$sql = "SELECT * FROM ".$dbprefix."page WHERE parent=9 AND visible=1 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
        echo "\t\t\t\t<li>\r\n\t\t\t\t\t<h3>".$row["nav_name"]."</h3>\r\n";
        $sql2 = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=".$row["id"]." ORDER BY pos";
        $mysql2->query($sql2);
        while ($row2 = $mysql2->fetchRow()) {
                 if ($row2["content_type"] == "text") {
                          $sql3 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row2["content_id"];
                          $mysql3->query($sql3);
                          $txt = str_replace("\r\n","<br />",$mysql3->fetchRow(0));
                          echo "\t\t\t\t\t".$txt."\r\n";
                 }
        }
        echo "\t\t\t\t</li>\r\n";
}
?>
                           </ul><br /><br /><br />

                           <!-- <h1>Das sagen unsere Kunden:</h1>
                           <h2 class="zitat">&bdquo;Hier steht dann ein Zitat eines Kunden &uuml;ber die sehr gute Zusammenarbeit mit Mitarbeitern von conuno und der hervorragenden Performance in allen Bereichen der angebotenen Leistungen.&rdquo;</h2><br /><br /> -->

                           <ul id="mitarbeiter">
<?php
$i = floor(rand(100,900)/100);
if ($i==1) $sql = "SELECT * FROM ".$dbprefix."page WHERE parent=13 AND visible=1 ORDER BY pos LIMIT 0,3";
elseif ($i==2) $sql = "SELECT * FROM ".$dbprefix."page WHERE parent=13 AND visible=1 ORDER BY pos LIMIT 3,3";
elseif ($i==3) $sql = "SELECT * FROM ".$dbprefix."page WHERE parent=13 AND visible=1 ORDER BY pos LIMIT 6,3";
elseif ($i==4) $sql = "SELECT * FROM ".$dbprefix."page WHERE parent=13 AND visible=1 ORDER BY pos LIMIT 9,3";
elseif ($i==5) $sql = "SELECT * FROM ".$dbprefix."page WHERE parent=13 AND visible=1 ORDER BY pos LIMIT 12,3";
elseif ($i==6) $sql = "SELECT * FROM ".$dbprefix."page WHERE parent=13 AND visible=1 ORDER BY pos LIMIT 15,3";
elseif ($i==7) $sql = "SELECT * FROM ".$dbprefix."page WHERE parent=13 AND visible=1 ORDER BY pos LIMIT 18,3";
elseif ($i==8) $sql = "SELECT * FROM ".$dbprefix."page WHERE parent=13 AND visible=1 ORDER BY pos LIMIT 21,3";
else $sql = "SELECT * FROM ".$dbprefix."page WHERE parent=13 AND visible=1 ORDER BY pos LIMIT 19,3";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
        echo "\t\t\t\t<li>\r\n\t\t\t\t\t<div class=\"name\">".$row["nav_name"]."</div>\r\n";
        $sql2 = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=".$row["id"]." ORDER BY pos";
        $mysql2->query($sql2);
        while ($row2 = $mysql2->fetchRow()) {
                  if ($row2["content_type"] == "image") {
                           $sql3 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row2["content_id"];
                           $mysql3->query($sql3);
                           while($row3 = $mysql3->fetchRow()) {
                                  $img = $row3["image"];
                                  $s = getimagesize("images/".$img);
                                  $alt = $row3["alt"];
                                  echo "\t\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"132\" height=\"132\" />\r\n";
//                                  echo "\t\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                           }
                  } else {
                          $sql3 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row2["content_id"];
                          $mysql3->query($sql3);
                          $txt = $mysql3->fetchRow(0);
                          echo "\t\t\t\t<div class=\"details\">\r\n\t\t\t\t\t".$txt."\r\n\t\t\t\t</div>\r\n";
                  }
        }
        echo "\t\t\t\t</li>\r\n";
}
?>
                           </ul><br style="clear:left;" />

<?php
$sql = "SELECT * FROM ".$dbprefix."page WHERE id=23";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         echo "\t\t\t<h1>".$row["nav_name"]."</h1>\r\n";
}
$sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=23 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         if ($row["content_type"] == "text") {
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  $txt = str_replace("\r\n","<br />",$mysql2->fetchRow(0));
                  echo "\t\t\t<p>".$txt."</p>\r\n";
         }
}
?>
                  </div>
         </div>

         <a name="leistung"></a>
         <ul class="slider" id="leistung">
<?php
$i=0;
$sql = "SELECT * FROM ".$dbprefix."page WHERE parent=50 AND visible=1 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
        $i++;
        echo "\t\t<li";
        if ($i==1) echo " class=\"active\"";
        echo ">\r\n";
        $sql2 = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=".$row["id"]." ORDER BY pos";
        $mysql2->query($sql2);
        while ($row2 = $mysql2->fetchRow()) {
                  if ($row2["content_type"] == "image") {
                           $sql3 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row2["content_id"];
                           $mysql3->query($sql3);
                           while($row3 = $mysql3->fetchRow()) {
                                  $img = $row3["image"];
                                  $s = getimagesize("images/".$img);
                                  $alt = $row3["alt"];
                                  echo "\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                           }
                  } else {
                          $sql3 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row2["content_id"];
                          $mysql3->query($sql3);
                          $txt = str_replace("\r\n","<br />",$mysql3->fetchRow(0));
                          echo "\t\t\t<div>".$txt."</div>\r\n";
                  }
        }
        echo "\t\t</li>\r\n";
}
if ($i>1) {
?>
                 <li class="controls">
                         <ul class="dots" style="width:<?php echo ($i*29)-10; ?>px; margin-left:-<?php echo (($i*29)-10)/2; ?>px;">
                                 <li class="first active"><a href="javascript:;"></a></li>
<?php
for ($j=2;$j<=$i;$j++) echo "\t\t\t\t<li><a href=\"javascript:;\"></a></li>\r\n";
?>
                         </ul>
                 </li>
<?php } ?>
         </ul>
         <div class="content_outer">
                  <a href="#kontaktformular" class="kontakt">Kontakt aufnehmen</a>
                  <div class="content_inner">
<?php
$sql = "SELECT * FROM ".$dbprefix."page WHERE id=3";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         echo "\t\t\t<h1>".$row["nav_name"]."</h1>\r\n";
         echo "\t\t\t<h2>".$row["meta_title"]."</h2>\r\n";
}
$sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=3 ORDER BY pos";
$mysql->query($sql);
$t=0; $i=0;
while ($row = $mysql->fetchRow()) {
         if ($row["content_type"] == "image") {
                  $i++;
                  $sql2 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  while($row2 = $mysql2->fetchRow()) {
                         $img = $row2["image"];
                         $s = getimagesize("images/".$img);
                         $alt = $row2["alt"];
                         echo "\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                  }
         } else {
                  $t++;
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  $txt = str_replace("\r\n","<br />",str_replace("\r\n\r\n","</p><p>",$mysql2->fetchRow(0)));
                  echo "\t\t\t<p>".$txt."</p>\r\n";
         }
}
?>
                         <div id="overlay"></div>
                         <ul id="leistungen_detail">
                                 <li></li>
<?php
$leistungen = array();
$i=0;
$sql = "SELECT * FROM ".$dbprefix."page WHERE parent=3 AND visible=1 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
        $i++;
        $leistungen[$i] = $row["nav_name"];
        echo "\t\t\t\t<li><a href=\"javascript:;\" class=\"close\">X</a><h3>".$leistungen[$i]."</h3><p><b>".$row["meta_title"]."</b><br />";
        $sql2 = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=".$row["id"]." ORDER BY pos";
        $mysql2->query($sql2);
        while ($row2 = $mysql2->fetchRow()) {
                  if ($row2["content_type"] == "text") {
                          $sql3 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row2["content_id"];
                          $mysql3->query($sql3);
                          echo $mysql3->fetchRow(0);
                  }
        }
        echo "</p></li>\r\n";
        if ($i==8) echo "\t\t\t\t<li></li>\r\n\t\t\t\t<li></li>\r\n";
}
?>
                         </ul>
                         <ul id="leistungen">
                                 <li class="logo first" role="presentation"><img src="img/conuno.png" alt="conuno" width="236" height="35" /></li>
<?php
$i=0;
foreach ($leistungen as $l) {
        $i++;
        echo "\t\t\t\t<li";
        if ($i==1 || $i==5 || $i==9) echo " class=\"first\"";
        echo "><a href=\"index.php#leistung$i\">".$l."</a></li>\r\n";
        if ($i==8) {
?>
                                 <li class="logo first" role="presentation"><br /><img src="img/conuno-m.png" alt="conuno m" width="249" height="21"></li>
                                 <li class="dn" role="presentation"></li>
<?php
        }
}
?>
                         </ul>
                  </div>
         </div>

    <a name="jobs"></a>
            <div class="slider" id="jobs">
<?php
$sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=54 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         if ($row["content_type"] == "image") {
                  $sql2 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  while($row2 = $mysql2->fetchRow()) {
                         $img = $row2["image"];
                         $s = getimagesize("images/".$img);
                         $alt = $row2["alt"];
                         echo "\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                  }
         } else {
                 $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                 $mysql2->query($sql2);
                 $txt = str_replace("\r\n","<br />",$mysql2->fetchRow(0));
                 echo "\t\t<div>".$txt."</div>\r\n";
         }
}
?>
             </div>
     <div class="content_outer">
             <a href="#kontaktformular" class="kontakt">Kontakt aufnehmen</a>
             <div class="content_inner">
<?php
$sql = "SELECT * FROM ".$dbprefix."page WHERE id=4";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         echo "\t\t\t<h1>".$row["nav_name"]."</h1>\r\n";
         echo "\t\t\t<h2>".$row["meta_title"]."</h2>\r\n";
}
$sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=4 ORDER BY pos";
$mysql->query($sql);
$t=0; $i=0;
while ($row = $mysql->fetchRow()) {
         if ($row["content_type"] == "image") {
                  $i++;
                  $sql2 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  while($row2 = $mysql2->fetchRow()) {
                         $img = $row2["image"];
                         $s = getimagesize("images/".$img);
                         $alt = $row2["alt"];
                         echo "\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                  }
         } else {
                  $t++;
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  $txt = str_replace("\r\n","<br />",str_replace("\r\n\r\n","</p><p>",$mysql2->fetchRow(0)));
                  echo "\t\t\t<p>".$txt."</p>\r\n";
         }
}
?>
            <ul id="stellen">
<?php
$sql = "SELECT * FROM ".$dbprefix."page WHERE parent=4 AND visible=1 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
        echo "\t\t\t\t<li>\r\n\t\t\t\t\t<div class=\"job\">\r\n\t\t\t\t\t\t".$row["nav_name"]."\r\n\t\t\t\t\t</div>\r\n\t\t\t\t\t<div class=\"details\">\r\n";
        $sql2 = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=".$row["id"]." ORDER BY pos";
        $mysql2->query($sql2);
        while ($row2 = $mysql2->fetchRow()) {
                  if ($row2["content_type"] == "text") {
                          $sql3 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row2["content_id"];
                          $mysql3->query($sql3);
                          echo $mysql3->fetchRow(0);
                  }
        }
        echo "\r\n\t\t\t\t\t</div>\r\n\r\n\t\t\t\t</li>";
}
?>
            </ul>
        </div>
     </div>

    <a name="bewerbung"></a>
            <div class="slider" id="bewerbung">
<?php
$sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=55 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         if ($row["content_type"] == "image") {
                  $sql2 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  while($row2 = $mysql2->fetchRow()) {
                         $img = $row2["image"];
                         $s = getimagesize("images/".$img);
                         $alt = $row2["alt"];
                         echo "\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                  }
         } else {
                 $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                 $mysql2->query($sql2);
                 $txt = str_replace("\r\n","<br />",$mysql2->fetchRow(0));
                 echo "\t\t<div>".$txt."</div>\r\n";
         }
}
?>
         </div>
     <a name="bewerbungsformular" id="bewerbungsformular"></a>
     <div class="content_outer">
             <div class="content_inner content_form">

<?php

$from_address = "info@conuno.de";
//$to_address = "info@conuno.de";
$sql = "SELECT text FROM ".$dbprefix."text WHERE id=162";
$mysql->query($sql);
$a = $mysql->fetchRow(0);
$to_addresses = explode("\r\n",$a);

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;
require 'Exception.php';
require 'PHPMailer.php';
require 'SMTP.php';

$error = false;
$issent = false;

$anrede = "";
$name = "";
$strasse = "";
$stadt = "";
$telefon = "";
$mail = "";
$anmerkungen = "";
$nachricht = "";
$datenschutz = 0;

if (isset($_POST["bewerbung"])) {
         $issent = true;
         $anrede = addcslashes(strip_tags($_POST["anrede"]), "%_");
         if ($anrede == "Anrede/Titel") $anrede = "";
         $name = addcslashes(strip_tags($_POST["name"]), "%_");
         if ($name == "Name, Vorname") $name = "";
         $strasse = addcslashes(strip_tags($_POST["strasse"]), "%_");
         if ($strasse == "Strasse, Hausnummer") $strasse = "";
         $stadt = addcslashes(strip_tags($_POST["stadt"]), "%_");
         if ($stadt == "Postleitzahl, Stadt") $stadt = "";
         $telefon = addcslashes(strip_tags($_POST["telefon"]), "%_");
         if ($telefon == "Telefon") $telefon = "";
         $mail = addcslashes(strip_tags($_POST["mail"]), "%_");
         if ($mail == "E-Mail") $mail = "";
         $anmerkungen = addcslashes(strip_tags($_POST["anmerkungen"]), "%_");
         if ($anmerkungen == "Anmerkungen") $anmerkungen = "";
         $nachricht = addcslashes(strip_tags($_POST["nachricht"]), "%_");
         if ($nachricht == "Ihr Text") $nachricht = "";
         $filenames = addcslashes(strip_tags($_POST["filenames"]), "%_");
         if (isset($_POST["datenschutz"])) $datenschutz = 1; else $datenschutz = 0;
         $error = false;
         if ($anrede=="" || $name=="" || $datenschutz == 0 || $nachricht=="" || $mail=="" || !stristr($mail,"@") || !stristr($mail,".")) {
                 $error = true;
         } else {

                 include_once $_SERVER['DOCUMENT_ROOT'] . '/lib/securimage/securimage.php';
                 $securimage = new Securimage();

                 if ($securimage->check($_POST['captcha_code']) == false) {
                         $error = true;
                 }
         }
         if ($error == false) {

                 $m =    "Anrede/Titel       : ".$anrede."\r\n".
                         "Name, Vorname      : ".$name."\r\n".
                         "Strasse, Hausnummer: ".$strasse."\r\n".
                         "Postleitzahl, Stadt: ".$stadt."\r\n".
                         "Telefon            : ".$telefon."\r\n".
                         "E-Mail             : ".$mail."\r\n".
                         "Anmerkungen        : ".$anmerkungen."\r\n".
                         "Ihr Text           :\r\n".$nachricht."\r\n";

                         $absender = $mail;

                 $files = explode("|",$filenames);

                  $mail = new PHPMailer(false);                              // Passing `true` enables exceptions
                      //Server settings
                      $mail->SMTPDebug = 0;                                 // Enable verbose debug output
                      $mail->isSMTP();                                      // Set mailer to use SMTP
                      $mail->Host = 'localhost';               // Specify main and backup SMTP servers
                      $mail->SMTPAuth = false;                               // Enable SMTP authentication
                      //$mail->Username = '';                         // SMTP username
                      //$mail->Password = '';                 // SMTP password
                      //$mail->SMTPSecure = 'tls';                            // Enable TLS encryption, `ssl` also accepted
                         $mail->SMTPSecure = false;
                         $mail->SMTPAutoTLS = false;
                      $mail->Port = 25;                                    // TCP port to connect to

                      //Recipients
                      $mail->setFrom($from_address);
                      //$mail->addAddress($to_address);     // Add a recipient
                      foreach ($to_addresses as $to) {
                         $mail->addAddress($to);     // Add a recipient
                      }
                      $mail->addAddress($absender);     // Add a recipient

                      //Attachments
                      foreach ($files as $file) if ($file != "") $mail->addAttachment("uploads/".$file);         // Add attachments

                      //Content
                      $mail->isHTML(false);                                  // Set email format to HTML
                      $mail->Subject = 'conuno Bewerbungsformular';
                      $mail->Body    = $m;

                      $mail->send();
         }
}

if ($issent == true && $error == false) {
         $sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=37 AND content_type='text' ORDER BY pos LIMIT 1,1";
         $mysql->query($sql);
         while ($row = $mysql->fetchRow()) {
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  echo $mysql2->fetchRow(0);
         }
} else {
         $sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=37 AND content_type='text' ORDER BY pos LIMIT 1";
         $mysql->query($sql);
         while ($row = $mysql->fetchRow()) {
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  echo $mysql2->fetchRow(0);
         }
?>
<form action="index.php#bewerbung" method="post" enctype="multipart/form-data">
         <input type="hidden" name="bewerbung" value="1" />
         <input type="text" class="text<?php if ($error == true && $anrede=="") echo " red"; ?>" name="anrede" id="anrede" value="<?php if ($anrede=="") echo "Anrede/Titel"; else echo $anrede; ?>" />
         <input type="text" class="text<?php if ($error == true && $name=="") echo " red"; ?>" name="name" id="name" value="<?php if ($name=="") echo "Name, Vorname"; else echo $name; ?>" />
         <input type="text" class="text" name="strasse" id="strasse" value="<?php if ($strasse=="") echo "Strasse, Hausnummer"; else echo $strasse; ?>" />
         <input type="text" class="text" name="stadt" id="stadt" value="<?php if ($stadt=="") echo "Postleitzahl, Stadt"; else echo $stadt; ?>" />
         <input type="text" class="text" name="telefon" id="telefon" value="<?php if ($telefon=="") echo "Telefon"; else echo $telefon; ?>" />
         <input type="text" class="text<?php if ($error == true && $mail=="") echo " red"; ?>" name="mail" id="mail" value="<?php if ($mail=="") echo "E-Mail"; else echo $mail; ?>" />
         <input type="text" class="text" name="anmerkungen" id="anmerkungen" value="<?php if ($anmerkungen=="") echo "Anmerkungen"; else echo $anmerkungen; ?>" />
         <textarea name="nachricht" id="nachricht" cols="30" rows="10" <?php if ($error == true && $nachricht=="") echo " class=\"red\""; ?>><?php if ($nachricht=="") echo "Ihr Text"; else echo $nachricht; ?></textarea>
         <input type="hidden" name="filenames" id="filenames" value="" />
         <input type="file" name="files[]" id="filer_input" multiple />
         <input type="checkbox" name="datenschutz" id="datenschutz" value="1"<?php if(isset($datenschutz) && $datenschutz==1) echo " checked"; ?> /> <label for="datenschutz" <?php if ($error == true && $datenschutz==0) echo " class=\"red\""; ?>><?php
         $sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=37 AND content_type='text' ORDER BY pos LIMIT 2,1";
         $mysql->query($sql);
         while ($row = $mysql->fetchRow()) {
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  echo $mysql2->fetchRow(0);
         }
?></label><br style="clear:left;" /><br />
         <img id="captcha" src="lib/securimage/securimage_show.php" alt="CAPTCHA Image" /> &nbsp; <a href="#" onclick="document.getElementById('captcha').src = 'lib/securimage/securimage_show.php?' + Math.random(); return false">neues Captcha laden</a><br /><br />
         <input type="text" name="captcha_code" maxlength="6" class="text<?php if ($error == true) echo " red"; ?>" id="captcha_code" value="Captcha" />
         <input type="submit" class="submit" value="Senden" />
</form>
<?php } ?>

        </div>
     </div>

     <a name="blog"></a>
     <ul class="slider" id="blog">
<?php
$i=0;
$sql = "SELECT * FROM ".$dbprefix."page WHERE parent=56 AND visible=1 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
        $i++;
        echo "\t\t<li";
        if ($i==1) echo " class=\"active\"";
        echo ">\r\n";
        $sql2 = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=".$row["id"]." ORDER BY pos";
        $mysql2->query($sql2);
        while ($row2 = $mysql2->fetchRow()) {
                  if ($row2["content_type"] == "image") {
                           $sql3 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row2["content_id"];
                           $mysql3->query($sql3);
                           while($row3 = $mysql3->fetchRow()) {
                                  $img = $row3["image"];
                                  $s = getimagesize("images/".$img);
                                  $alt = $row3["alt"];
                                  echo "\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                           }
                  } else {
                          $sql3 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row2["content_id"];
                          $mysql3->query($sql3);
                          $txt = str_replace("\r\n","<br />",$mysql3->fetchRow(0));
                          echo "\t\t\t<div>".$txt."</div>\r\n";
                  }
        }
        echo "\t\t</li>\r\n";
}
if ($i>1) {
?>
                 <li class="controls">
                         <ul class="dots" style="width:<?php echo ($i*29)-10; ?>px; margin-left:-<?php echo (($i*29)-10)/2; ?>px;">
                                 <li class="first active"><a href="javascript:;"></a></li>
<?php
for ($j=2;$j<=$i;$j++) echo "\t\t\t\t<li><a href=\"javascript:;\"></a></li>\r\n";
?>
                         </ul>
                 </li>
<?php } ?>
         </ul>
         <div class="content_outer">
              <a href="#kontaktformular" class="kontakt">Kontakt aufnehmen</a>
         <div class="content_inner">
<?php
$sql = "SELECT * FROM ".$dbprefix."page WHERE id=5";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         echo "\t\t\t<h1>".$row["nav_name"]."</h1>\r\n";
}
$sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=5 ORDER BY pos";
$mysql->query($sql);
$t=0; $i=0;
while ($row = $mysql->fetchRow()) {
         if ($row["content_type"] == "image") {
                  $i++;
                  $sql2 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  while($row2 = $mysql2->fetchRow()) {
                         $img = $row2["image"];
                         $s = getimagesize("images/".$img);
                         $alt = $row2["alt"];
                         echo "\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                  }
         } else {
                  $t++;
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  $txt = str_replace("\r\n","<br />",str_replace("\r\n\r\n","</p><p>",$mysql2->fetchRow(0)));
                  echo "\t\t\t<p>".$txt."</p>\r\n";
         }
}
?>
            <ul id="neuigkeiten">
<?php
$sql = "SELECT * FROM ".$dbprefix."page WHERE parent=5 AND visible=1 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
        echo "\t\t\t\t<li>\r\n\t\t\t\t\t<div class=\"date\">\r\n\t\t\t\t\t\t<h2>".$row["meta_title"]."</h2>\r\n\t\t\t\t\t</div>\r\n\t\t\t\t\t<div class=\"details\">\r\n\t\t\t\t\t<h3>".$row["nav_name"]."</h3>";
        $sql2 = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=".$row["id"]." ORDER BY pos";
        $mysql2->query($sql2);
        while ($row2 = $mysql2->fetchRow()) {
                  if ($row2["content_type"] == "image") {
                           $sql3 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row2["content_id"];
                           $mysql3->query($sql3);
                           while($row3 = $mysql3->fetchRow()) {
                                  $img = $row3["image"];
                                  $s = getimagesize("images/".$img);
                                  $alt = $row3["alt"];
                                  echo "\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                           }
                  } else {
                          $sql3 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row2["content_id"];
                          $mysql3->query($sql3);
                          $txt = str_replace("\r\n","<br />",str_replace("\r\n\r\n","</p><p>",$mysql3->fetchRow(0)));
                          echo "\t\t\t<p>".$txt."</p>\r\n";
                  }
        }
        echo "\r\n\t\t\t\t\t</div>\r\n\r\n\t\t\t\t</li>";
}
?>
        </div>

        <a name="kontakt"></a>
                <div class="slider" id="kontakt">
<?php
$sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=57 ORDER BY pos";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         if ($row["content_type"] == "image") {
                  $sql2 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  while($row2 = $mysql2->fetchRow()) {
                         $img = $row2["image"];
                         $s = getimagesize("images/".$img);
                         $alt = $row2["alt"];
                         echo "\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                  }
         } else {
                 $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                 $mysql2->query($sql2);
                 $txt = str_replace("\r\n","<br />",$mysql2->fetchRow(0));
                 echo "\t\t<div>".$txt."</div>\r\n";
         }
}
?>
                </div>
         <a name="kontaktformular" id="kontaktformular"></a>
         <div class="content_outer">
                 <div class="content_inner content_form">

<?php

$k_error = false;
$k_issent = false;

$k_anrede = "";
$k_name = "";
$k_mail = "";
$k_nachricht = "";
$k_datenschutz = 0;

$sql = "SELECT text FROM ".$dbprefix."text WHERE id=163";
$mysql->query($sql);
$a2 = $mysql->fetchRow(0);
$to_addresses2 = explode("\r\n",$a2);


if (isset($_POST["kontakt"])) {
         $k_issent = true;
         $k_anrede = addcslashes(strip_tags($_POST["k_anrede"]), "%_");
         if ($k_anrede == "Anrede/Titel") $k_anrede = "";
         $k_name = addcslashes(strip_tags($_POST["k_name"]), "%_");
         if ($k_name == "Name, Vorname") $k_name = "";
         $k_mail = addcslashes(strip_tags($_POST["k_mail"]), "%_");
         if ($k_mail == "E-Mail") $k_mail = "";
         $k_nachricht = addcslashes(strip_tags($_POST["k_nachricht"]), "%_");
         if ($k_nachricht == "Ihr Text") $k_nachricht = "";
         if (isset($_POST["k_datenschutz"])) $k_datenschutz = 1; else $k_datenschutz = 0;
         $k_error = false;
         if ($k_anrede=="" || $k_name=="" || $k_mail=="" || !stristr($k_mail,"@") || !stristr($k_mail,".") || $k_nachricht=="" || $k_datenschutz == 0) {
                 $k_error = true;
         } else {

                 include_once $_SERVER['DOCUMENT_ROOT'] . '/lib/securimage/securimage.php';
                 $k_securimage = new Securimage();

                 if ($k_securimage->check($_POST['k_captcha_code']) == false) {
                         $k_error = true;
                 }
         }
         if ($k_error == false) {

                 $m =    "Anrede/Titel : ".$k_anrede."\r\n".
                         "Name, Vorname: ".$k_name."\r\n".
                         "E-Mail       : ".$k_mail."\r\n".
                         "Ihr Text     :\r\n".$k_nachricht."\r\n";


                  $mail = new PHPMailer(false);                              // Passing `true` enables exceptions
                      //Server settings
                      $mail->SMTPDebug = 0;                                 // Enable verbose debug output
                      $mail->isSMTP();                                      // Set mailer to use SMTP
                      $mail->Host = 'localhost';               // Specify main and backup SMTP servers
                      $mail->SMTPAuth = false;                               // Enable SMTP authentication
                      //$mail->Username = '';                         // SMTP username
                      //$mail->Password = '';                 // SMTP password
                      //$mail->SMTPSecure = 'tls';                            // Enable TLS encryption, `ssl` also accepted
                         $mail->SMTPSecure = false;
                         $mail->SMTPAutoTLS = false;
                      $mail->Port = 25;                                    // TCP port to connect to

                      //Recipients
                      $mail->setFrom($from_address);
                      //$mail->addAddress($to_address);     // Add a recipient
                      foreach ($to_addresses2 as $to2) {
                         $mail->addAddress($to2);     // Add a recipient
                      }
                      $mail->addAddress($k_mail);     // Add a recipient

                      //Content
                      $mail->isHTML(false);                                  // Set email format to HTML
                      $mail->Subject = 'conuno Kontaktformular';
                      $mail->Body    = $m;

                      $mail->send();

         }
}

if ($k_issent == true && $k_error == false) {
         $sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=6 AND content_type='text' ORDER BY pos LIMIT 1,1";
         $mysql->query($sql);
         while ($row = $mysql->fetchRow()) {
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  $txt = str_replace("\r\n","<br />",str_replace("\r\n\r\n","</p><p>",$mysql2->fetchRow(0)));
                  echo "\t\t\t<p>".$txt."</p>\r\n";
         }
} else {
         $sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=6 AND content_type='text' ORDER BY pos LIMIT 1";
         $mysql->query($sql);
         while ($row = $mysql->fetchRow()) {
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  $txt = str_replace("\r\n","<br />",str_replace("\r\n\r\n","</p><p>",$mysql2->fetchRow(0)));
                  echo "\t\t\t<p>".$txt."</p>\r\n";
         }
?>
<form action="index.php#kontaktformular" method="post">
         <input type="hidden" name="kontakt" value="1" />
         <input type="text" class="text<?php if ($k_error == true && $k_anrede=="") echo " red"; ?>" name="k_anrede" id="k_anrede" value="<?php if ($k_anrede=="") echo "Anrede/Titel"; else echo $k_anrede; ?>" />
         <input type="text" class="text<?php if ($k_error == true && $k_name=="") echo " red"; ?>" name="k_name" id="k_name" value="<?php if ($k_name=="") echo "Name, Vorname"; else echo $k_name; ?>" />
         <input type="text" class="text<?php if ($k_error == true && $k_mail=="") echo " red"; ?>" name="k_mail" id="k_mail" value="<?php if ($k_mail=="") echo "E-Mail"; else echo $k_mail; ?>" />
         <textarea name="k_nachricht" id="k_nachricht" cols="30" rows="10" <?php if ($k_error == true && $k_nachricht=="") echo " class=\"red\""; ?>><?php if ($k_nachricht=="") echo "Ihr Text"; else echo $k_nachricht; ?></textarea>
         <input type="checkbox" name="k_datenschutz" id="k_datenschutz" value="1"<?php if(isset($k_datenschutz) && $k_datenschutz==1) echo " checked"; ?> /> <label for="k_datenschutz" <?php if ($k_error == true && $k_datenschutz==0) echo " class=\"red\""; ?>> <?php
         $sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=6 AND content_type='text' ORDER BY pos LIMIT 2,1";
         $mysql->query($sql);
         while ($row = $mysql->fetchRow()) {
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  echo $mysql2->fetchRow(0);
         }
?></label><br style="clear:left;" /><br />
         <img id="k_captcha" src="lib/securimage/securimage_show.php" alt="CAPTCHA Image" /> &nbsp; <a href="#" onclick="document.getElementById('k_captcha').src = 'lib/securimage/securimage_show.php?' + Math.random(); return false">neues Captcha laden</a><br /><br />
         <input type="text" name="k_captcha_code" maxlength="6" class="text<?php if ($k_error == true) echo " red"; ?>" id="k_captcha_code" value="Captcha" />
         <input type="submit" class="submit" value="Senden" />
</form>
<?php } ?>
                 </div>
            </div>

<a name="impressum"></a>
 <div class="content_outer"><div class="content_inner" id="impressum">
<?php
$sql = "SELECT * FROM ".$dbprefix."page WHERE id=7";
$mysql->query($sql);
while ($row = $mysql->fetchRow()) {
         echo "\t\t\t<h1>".$row["nav_name"]."</h1>\r\n";
         echo "\t\t\t<h2>".$row["meta_title"]."</h2>\r\n";
}
$sql = "SELECT * FROM ".$dbprefix."page_content WHERE page_id=7 ORDER BY pos";
$mysql->query($sql);
$t=0; $i=0;
while ($row = $mysql->fetchRow()) {
         if ($row["content_type"] == "image") {
                  $i++;
                  $sql2 = "SELECT * FROM ".$dbprefix."image WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  while($row2 = $mysql2->fetchRow()) {
                         $img = $row2["image"];
                         $s = getimagesize("images/".$img);
                         $alt = $row2["alt"];
                         echo "\t\t\t<img src=\"images/$img\" alt=\"$alt\" width=\"".$s[0]."\" height=\"".$s[1]."\" />\r\n";
                  }
         } else {
                  $t++;
                  $sql2 = "SELECT text FROM ".$dbprefix."text WHERE id=".$row["content_id"];
                  $mysql2->query($sql2);
                  $txt = str_replace("\r\n","<br />",str_replace("\r\n\r\n","</p><p>",$mysql2->fetchRow(0)));
                  echo "\t\t\t<p>".$txt."</p><br /><br />\r\n";
         }
}
?>
 </div></div>
<center><img id="imp" src="img/erecht24-siegel-impressum-blau.png" alt="Impressum mit eRecht24 erstellt" width="120" height="156" />
<img id="imp" src="img/erecht24-siegel-datenschutzerklaerung-blau.png" alt="Impressum mit eRecht24 erstellt" width="120" height="156" />
<img id="imp" src="img/erecht24-siegel-disclaimer-blau.png" alt="Impressum mit eRecht24 erstellt" width="120" height="156" /></center>
<?php
require("_footer.php");
?>