<div id="accordion" style="background: #<?php echo $color3 ?>">
	
    <!--HOME -->
    
    <h1><a href="#"><?php echo $company1 ?></a></h1>
	<div>
<?php $photopath="home/"; ?>
<?php include 'inphoto.php';?>
<div class="main">	
		    <?php
			$sql = "SELECT * FROM profil ORDER BY priority";
			$result = mysql_query($sql);
			while ($myrow=mysql_fetch_array($result)) {
			$name=$myrow['name'];
			$name_en=$myrow['name_en'];
			$name_de=$myrow['name_de'];
			$name_fr=$myrow['name_fr'];
            $name_it=$myrow['name_it'];
            $name_es=$myrow['name_es'];
            $name_ru=$myrow['name_ru'];
            $name_zh=$myrow['name_zh'];
			$text=$myrow['text'];
			$text_en=$myrow['text_en'];
			$text_de=$myrow['text_de'];
			$text_fr=$myrow['text_fr'];
            $text_it=$myrow['text_it'];
            $text_es=$myrow['text_es'];
            $text_ru=$myrow['text_ru'];
            $text_zh=$myrow['text_zh']; 
			?>
<?php include 'lang.php';?>  
            
      <?php if ($name!='') { ?>
      <div class="titles"><?php echo $name ?></div>
      <?php } ?>
      <?php echo $text ?>
      <?php } ?>
	</div>
    </div>
    
    <!--END HOME -->
    
    <!--LOCATION -->
  
   <?php if ($location1!='' AND $map!='') { ?>
    
	<h1><a href="#"><?php echo $pagelocation ?></a></h1>
	<div>
<?php $photopath="location/"; ?>
<div style="width:100%; height:400px;"><?php echo $map ?></div>
<div class="main">	
	<?php echo $location1 ?>
	</div>	
	</div>
    
  <?php } ?>
 <!--END LOCATION -->
 
 <!--ACCOMMODATION -->
 
 <?php 
			$sql20 = "SELECT * FROM rooms WHERE publish='yes' AND publisha='yes'";
			$result20 = mysql_query($sql20);
			$nu_row20 = mysql_num_rows($result20);
?>
        <?php 
	if  ($nu_row20>0) {
	?>
 <?php include 'accommodation.php';?>
  <?php }?>
  
 <!--END ACCOMMODATION -->
  
  <!--FACILITIES --> 
   
   <?php 
			$sql21 = "SELECT * FROM facilities WHERE publish='yes'";
			$result21 = mysql_query($sql21);
			$nu_row21 = mysql_num_rows($result21);
?>
        <?php 
	if  ($nu_row21>0) {
	?>
	<h1><a href="#"><?php echo $pagefacilities ?></a></h1>
	<div>
<?php $photopath="facilities/"; ?>
<?php include 'inphoto.php';?>
<div class="main">	
		    <?php
			$sql = "SELECT * FROM facilities WHERE publish='yes' ORDER BY priority";
			$result = mysql_query($sql);
	while ($myrow=mysql_fetch_array($result)) {
			$name=$myrow['name'];
			$name_en=$myrow['name_en'];
			$name_de=$myrow['name_de'];
			$name_fr=$myrow['name_fr'];
            $name_it=$myrow['name_it'];
            $name_es=$myrow['name_es'];
            $name_ru=$myrow['name_ru'];
            $name_zh=$myrow['name_zh'];
			$description=$myrow['description'];
			$description_en=$myrow['description_en'];
			$description_de=$myrow['description_de'];
			$description_fr=$myrow['description_fr'];
            $description_it=$myrow['description_it'];
            $description_es=$myrow['description_es'];
            $description_ru=$myrow['description_ru'];
            $description_zh=$myrow['description_zh']; 
			?>
 <?php include 'lang.php';?> 
 
              <div class="titles"><?php echo $name ?></div>
              <?php echo $description ?>
            <?php }?>
	</div>	
	</div>
   <?php }?>
    
    <!--END FACILITIES -->
    
    <!--INFO -->
    
            <?php 
			$sql30 = "SELECT * FROM infocategories WHERE level='1' AND publish='yes' ORDER BY priority";
			$result30 = mysql_query($sql30);
			while ($myrow=mysql_fetch_array($result30)) {
			$catid=$myrow['id'];
			$pid=$myrow['id'];
			$category=$myrow['category'];
			$category_en=$myrow['category_en'];
			$category_de=$myrow['category_de'];
			$category_fr=$myrow['category_fr'];
            $category_it=$myrow['category_it'];
            $category_es=$myrow['category_es'];
            $category_ru=$myrow['category_ru'];
            $category_zh=$myrow['category_zh']; 
			?>
<?php include 'lang.php';?> 
            
	<h1><a href="#"> <?php echo $category ?></a></h1>
	<div>
    <?php $photopath="info/"; ?>
<?php include 'inphoto.php';?>
<div class="main">	
 
  <?php
			$sql = "SELECT * FROM info WHERE category_id='$catid' AND publish='yes' ORDER BY priority";
			$result = mysql_query($sql);
	while ($myrow=mysql_fetch_array($result)) {
			$id=$myrow['id'];
			$category_id=$myrow['category_id'];
			$name=$myrow['name'];
			$name_en=$myrow['name_en'];
			$name_de=$myrow['name_de'];
			$name_fr=$myrow['name_fr'];
            $name_it=$myrow['name_it'];
            $name_es=$myrow['name_es'];
            $name_ru=$myrow['name_ru'];
            $name_zh=$myrow['name_zh'];
			$description=$myrow['description'];
			$description_en=$myrow['description_en'];
			$description_de=$myrow['description_de'];
			$description_fr=$myrow['description_fr'];
            $description_it=$myrow['description_it'];
            $description_es=$myrow['description_es'];
            $description_ru=$myrow['description_ru'];
            $description_zh=$myrow['description_zh'];
			$file=$myrow['file'];
			?>
<?php include 'lang.php';?> 
            
      <div class="titles"><?php echo $name ?></div>
             <div><?php echo $description ?></div>
               <?php if ($file!='') { ?>
      <div style="padding-top: 2px; padding-bottom: 2px"> <a href="/images/info/files/<?php echo $id ?><?php echo $file ?>" class="links" target="_blank">Download Brochure</a> </div>
              <?php } ?>
              
                <?php
			$sql4 = "SELECT * FROM photos WHERE info_id='$id' ORDER BY priority";
			$result4 = mysql_query($sql4);
			while ($myrow=mysql_fetch_array($result4)) {
			$photoid=$myrow['id'];
			$photo=$myrow['name_en'];
?>
<?php if ($photo=='') { 
$photo=$company1;
}?>
   <?php include 'photo.php';?>
 <?php } ?>
  <div style="clear:both"></div>
  
 <?php } ?> 
 
             <?php 
			$sql31 = "SELECT * FROM infocategories WHERE parent='$catid' AND publish='yes' ORDER BY priority";
			$result31 = mysql_query($sql31);
			$nu_row31 = mysql_num_rows($result31);
			while ($myrow=mysql_fetch_array($result31)) {
			$catid1=$myrow['id'];
			$category1=$myrow['category'];
			$category1_en=$myrow['category_en'];
			$category1_de=$myrow['category_de'];
			$category1_fr=$myrow['category_fr'];
            $category1_it=$myrow['category_it'];
            $category1_es=$myrow['category_es'];
            $category1_ru=$myrow['category_ru'];
			$category1_zh=$myrow['category_zh'];  
			?>
<?php include 'lang.php';?> 
            
         <?php 
	if  ($nu_row31>0) {
	?>    
     <div class="titles"><?php echo $category1 ?></div>       
               
            <?php
			$sql = "SELECT * FROM info WHERE category_id='$catid1' AND publish='yes' ORDER BY priority";
			$result = mysql_query($sql);
	while ($myrow=mysql_fetch_array($result)) {
			$id=$myrow['id'];
			$category_id=$myrow['category_id'];
			$name=$myrow['name'];
			$name_en=$myrow['name_en'];
			$name_de=$myrow['name_de'];
			$name_fr=$myrow['name_fr'];
            $name_it=$myrow['name_it'];
            $name_es=$myrow['name_es'];
            $name_ru=$myrow['name_ru'];
            $name_zh=$myrow['name_zh'];
			$description=$myrow['description'];
			$description_en=$myrow['description_en'];
			$description_de=$myrow['description_de'];
			$description_fr=$myrow['description_fr'];
            $description_it=$myrow['description_it'];
            $description_es=$myrow['description_es'];
            $description_ru=$myrow['description_ru'];
            $description_zh=$myrow['description_zh'];
			$file=$myrow['file'];
			?>
 <?php include 'lang.php';?> 
            
      <div><strong><?php echo $name ?></strong></div>
             <div><?php echo $description ?></div>
               <?php if ($file!='') { ?>
      <div style="padding-top: 2px; padding-bottom: 2px"> <a href="/images/info/files/<?php echo $id ?><?php echo $file ?>" class="links" target="_blank">Download Brochure</a> </div>
              <?php } ?>
 
  <?php
			$sql4 = "SELECT * FROM photos WHERE info_id='$id' ORDER BY priority";
			$result4 = mysql_query($sql4);
			while ($myrow=mysql_fetch_array($result4)) {
			$photoid=$myrow['id'];
			$photo=$myrow['name_en'];
?>
<?php if ($photo=='') { 
$photo=$company1;
}?>
   <?php include 'photo.php';?>
 <?php } ?>
  <div style="clear:both"></div>
               
 <?php } ?> 
 <hr>
  <?php } ?> 
  <?php } ?> 
 </div>
</div>
 <?php } ?>   
 
 <!--END INFO -->
 
 <!--PHOTOS -->
 
   <?php 
			$sql22 = "SELECT * FROM photos WHERE room_id='0' AND info_id='0'";
			$result22 = mysql_query($sql22);
			$nu_row22 = mysql_num_rows($result22);
?>
        <?php 
	if  ($nu_row22>0) {
	?> 
 <h1><a href="#"><?php echo $pagephotos ?></a></h1>
	<div>
<div class="main">	

 <?php
			$sql = "SELECT * FROM photos WHERE room_id='0' AND info_id='0' ORDER BY priority";
			$result = mysql_query($sql);
			while ($myrow=mysql_fetch_array($result)) {
			$photoid=$myrow['id'];
			$photo=$myrow['name_en'];
?>
 <?php if ($photo=='') { 
$photo=$company;
}?>
   <?php include 'photo.php';?>
<?php } ?>
<div style="clear:both"></div>              
	</div>	
	</div>
<?php } ?>
    
    <!--END PHOTOS -->
    
    <!--RATES -->
    
                <?php 
			$sql = "SELECT * FROM terms WHERE publish='yes'";
			$result = mysql_query($sql);
			$nu_rowt = mysql_num_rows($result);
?>
                <?php 
			$sql1 = "SELECT * FROM seasons";
			$result1 = mysql_query($sql1);
			$nu_row1 = mysql_num_rows($result1);
?>
            <?php 
			$sql2 = "SELECT * FROM rooms WHERE publish='yes' AND publishb='yes'";
			$result2 = mysql_query($sql2);
			$nu_row2 = mysql_num_rows($result2);
?>
            <?php $nrow=$nu_row1*$nu_row2; ?>
            
            <?php 
			$sql3 = "SELECT * FROM prices";
			$result3 = mysql_query($sql3);
			$nu_row3 = mysql_num_rows($result3);
?>
            <?php 
	if  ($nu_row3>0 OR $nu_rowt>0) {
	?>
    
<h1><a href="#"><?php echo $pagerates ?></a></h1>
	<div>
<div class="main">	
<?php include 'rates.php';?> 
	</div>	
	</div>  
    
    <?php } ?>
    
    <!--END RATES -->
    
    <!--SPECIALS -->
    
<?php 
			$sql23 = "SELECT * FROM specials WHERE publish='yes'";
			$result23 = mysql_query($sql23);
			$nu_row23 = mysql_num_rows($result23);
?>
        <?php 
	if  ($nu_row23>0) {
	?>
        
  <h1><a href="#"><?php echo $pagespecials ?></a></h1>
	<div>
<div class="main">	
		    <?php
			$sql = "SELECT * FROM specials WHERE publish='yes' ORDER BY priority";
			$result = mysql_query($sql);
	while ($myrow=mysql_fetch_array($result)) {
			$name=$myrow['name'];
			$name_en=$myrow['name_en'];
			$name_de=$myrow['name_de'];
			$name_fr=$myrow['name_fr'];
            $name_it=$myrow['name_it'];
            $name_es=$myrow['name_es'];
            $name_ru=$myrow['name_ru'];
            $name_zh=$myrow['name_zh'];
			$description=$myrow['description'];
			$description_en=$myrow['description_en'];
			$description_de=$myrow['description_de'];
			$description_fr=$myrow['description_fr'];
            $description_it=$myrow['description_it'];
            $description_es=$myrow['description_es'];
            $description_ru=$myrow['description_ru'];
            $description_zh=$myrow['description_zh']; 
			?>
<?php include 'lang.php';?> 
            
              <div class="titles"><?php echo $name ?></div>
              <?php echo $description ?>
            <?php }?>
	</div>	
	</div>
            
        <?php } ?>    
    
    <!--END SPECIALS -->
    
        <!--LINKS -->
    
<?php 
			$sql24 = "SELECT * FROM links WHERE publish='yes' AND priority<100";
			$result24 = mysql_query($sql24);
			$nu_row24 = mysql_num_rows($result24);
?>
        <?php 
	if  ($nu_row24>0) {
	?>
        
  <h1><a href="#">Links</a></h1>
	<div>
<div class="main">	
		    <?php
			$sql = "SELECT * FROM links WHERE publish='yes' AND priority<100 ORDER BY priority";
			$result = mysql_query($sql);
	while ($myrow=mysql_fetch_array($result)) {
			$name=$myrow['name'];
			$name_en=$myrow['name_en'];
			$name_de=$myrow['name_de'];
			$name_fr=$myrow['name_fr'];
            $name_it=$myrow['name_it'];
            $name_es=$myrow['name_es'];
            $name_ru=$myrow['name_ru'];
            $name_zh=$myrow['name_zh'];
			$url=$myrow['url'];
			?>
 <?php include 'lang.php';?> 
            
              <div><a href="<?php echo $url ?>" class="links" target="_blank"><?php echo $name ?></a> </div>
            <?php }?>
	</div>	
	</div>
            
        <?php } ?>    
    
    <!--END LINKS -->
    
    <!--REVIEWS -->
     <?php if  ($guestbook1=='1') { ?>
     <?php include 'reviews.php';?>
     <?php } ?>
   
   <!--CONTACT --> 
<?php include 'contact.php';?>
   
   <!--RESERVATION -->
  <?php if ($accommodation1=='1') { ?> 
<?php include 'reservation.php';?>
 <?php } ?>   
</div>