<?
$obj = $_GET['obj'];

if (empty($obj)){
header("Location: property_list.php");
}
$dbhost="5.35.241.205";
$dbuser="wordpress_l";
$dbpass="zU6#92uaEK";
$dbadi="wordpress_w";

	$baglan= mysql_connect ($dbhost, $dbuser, $dbpass);
	if (! $baglan) die ("mysql error");
	mysql_select_db ($dbadi, $baglan) or die ("DB error");	
	mysql_query("SET NAMES utf8");
	mysql_query("SET CHARACTER SET utf8");
	mysql_query("SET COLLATION_CONNECTION = 'utf8_general_ci'");	

	
	$sorgu_nl = mysql_query("select * from M1U4dxQdaH_posts where ID='".$obj."'");

		while ($ceknl=mysql_fetch_array($sorgu_nl)) {				
			if ($ceknl['post_status']!=='publish'){continue;}
			$id = $ceknl['ID'];
			$title = $ceknl['post_title'];
			$guid = $ceknl['guid'];
			$desc = $ceknl['post_content'];
			
			
				$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
					while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
						if ($cekmeta['meta_key']=='property_price') {
						$price=doubleval($cekmeta['meta_value']);}						
						
            $listings_currency = '€';
            $price_decimals = '0';
            $price_thousands_separator = ',';
            $price_decimal_point_separator = '.';
						
						
						if ($cekmeta['meta_key']=='property_label_before') {
						$pricepre=$cekmeta['meta_value'];}

					}

				$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
					while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
						if ($cekmeta['meta_key']=='property_size') {
						$size=$cekmeta['meta_value'];}
					}

				$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
					while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
						if ($cekmeta['meta_key']=='property_rooms') {
						$rooms=$cekmeta['meta_value'];}
					}		
					
				$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
					while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
						if ($cekmeta['meta_key']=='property_bedrooms') {
						$bedrooms=$cekmeta['meta_value'];}
					}							

				$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
					while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
						if ($cekmeta['meta_key']=='property_bathrooms') {
						$bathrooms=$cekmeta['meta_value'];}
					}	

				$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
					while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
						if ($cekmeta['meta_key']=='mls') {
						$ref=$cekmeta['meta_value'];}
					}			
					
				$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
					while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
						if ($cekmeta['meta_key']=='property_label_before') {
						$pricepre=$cekmeta['meta_value'];}
						
						
					}					
				

				$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
					while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
						if ($cekmeta['meta_key']=='property_city') {
						$map=$cekmeta['meta_value'];}
						
						if ($cekmeta['meta_key']=='property_latitude') {
						$maplat=$cekmeta['meta_value'];}
						
						if ($cekmeta['meta_key']=='property_longitude') {
						$maplong=$cekmeta['meta_value'];}
					}		

				$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
					while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
						if ($cekmeta['meta_key']=='image_to_attach') {
						$imagethumbid=$cekmeta['meta_value'];
							$sorgu_thumb= mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$imagethumbid."'");
							while ($cekthumb=mysql_fetch_array($sorgu_thumb)) {
								if ($cekthumb['meta_key']=='_wp_attached_file') {
								$imgthumb=$cekthumb['meta_value'];}
							}
							
						}
					}

				$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
					while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
						if ($cekmeta['meta_key']=='image_to_attach') {
						$images=$cekmeta['meta_value'];}
					}							
					
					
		}	
		
		$price=number_format($price,"0",".",".")." &#8364;";
		
		
?>
<!DOCTYPE html>
<html lang="en">

<head>
	<!-- Define Charset -->
	<meta charset="utf-8"/>

	<!-- Page Title -->
	<title><?echo $title;?></title>

	<!-- Responsive Metatag -->
	<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
	  
	<!-- <meta http-equiv="X-UA-Compatible" content="IE=9" />-->
	
	<!-- CSS -->
	<link rel="stylesheet" href="css/vendors/bootstrap.min.css">

	<!-- Font icons -->
	<link rel="stylesheet" href="css/vendors/fontello.css" >
	<!--[if IE 7]>
	<link rel="stylesheet" href="css/fontello-ie7.css" ><![endif]-->
	
	<!-- Owl Carousel -->
	<link rel="stylesheet" href="css/vendors/owl.carousel.css" >
	
	<link rel="stylesheet" href="css/vendors/slider.css" >

	<!-- Custom CSS -->
	<link rel="stylesheet" href="css/styles.css" />
	<link href="css/fotorama.css" rel="stylesheet /">	
	<!-- Custom Media-Queties -->
	<link rel="stylesheet" href="css/media-queries.css" />
	<link rel="stylesheet" href="/sforms/css/smart-forms.css" type="text/css" />
	<link rel="stylesheet" href="/sforms/css/font-awesome.min.css" type="text/css" />
	<?include "favicon.php"?>
	
	<!-- HTML5 shim, for IE6-8 support of HTML5 elements -->
	<!--[if lt IE 9]>
		<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>        
	<![endif]-->

	<!-- Media queries -->
	<!--[if lt IE 9]>
		<script src="http://css3-mediaqueries-js.googlecode.com/svn/trunk/css3-mediaqueries.js"></script>
	<![endif]-->
	
</head>
<body>
<!-- begin Header -->
<? include "header.php" ?>
<!-- end Header -->
<br>

<!-- begin Content -->
<section>
	
<div class="container">
	<div class="row">

<?include "left-menu.php"?>	
	
		<div class="col-md-9">
			<div class="boxes single-property">
			
				<div class="row">
				
				<div class="col-md-12">
				<div class="onsale alt"><span><?echo $ref;?></span><?echo $price;?></div>
					<div class="boxes-title">
						<p style="font-weight:700;"><?echo $title;?></p>
						
					</div>
					<br>


					<!-- Nav tabs -->


					<!-- Tab panes -->
				
						
<div class="fotorama box-white" data-nav="thumbs" data-width="%100" data-maxwidth="2000" data-ratio="16/9" data-minheight="500" data-maxheight="500" data-allowfullscreen="true" data-thumbmargin="3"  data-fit="cover">
		<?

				$sorgu_meta = mysql_query("select * from M1U4dxQdaH_postmeta where post_id = '".$id."' order by meta_id");
					while ($cekmeta=mysql_fetch_array($sorgu_meta)) {
						if ($cekmeta['meta_key']=='image_to_attach') {
							
							$imagethumbid=$cekmeta['meta_value'];
							
							//echo "nevarla:".$imagethumbid;
							
							$myArray = explode(',', $imagethumbid);
							//echo "myarray".$myArray;
							//print_r ($myArray);
							
							
					foreach($myArray as $myitem) {		
						$sorgu_thumb= mysql_query("select * from M1U4dxQdaH_posts where ID = '".$myitem."'");
							while ($cekthumb=mysql_fetch_array($sorgu_thumb)) {
								$imgthumb=$cekthumb['guid'];
								echo '<a href="'.$imgthumb.'" title="" name="" id=""><img src="'.$imgthumb.'" alt="" width="180" height="110"/></a>';}
					}
					}};
					?>
	

</div>


					<p class="share" style="width:100%;float:right;">
					<div class="addthis_sharing_toolbox"></div>
					</p>


				<div class="col-md-12">
				<h5>DETAILS</h5>
				<hr>
				</div>
				<div class="col-md-3">
					
					<ul class="details">
						<li><i class="icon-check"></i> Wohnfläche: <?echo $size;?> m²</li>
					</ul>
				</div>

				<div class="col-md-3">
					<ul class="details">
						<li><i class="icon-check"></i> Zimmer: <?echo $rooms;?></li>
					</ul>
				</div>

				<div class="col-md-3">
					<ul class="details">
						<li><i class="icon-check"></i> Schlafzimmer: <?echo $bedrooms;?></li>
					</ul>
				</div>

				<div class="col-md-3">
					<ul class="details">
						<li><i class="icon-check"></i> Badezimmer: <?echo $bathrooms;?></li>
					</ul>
				</div>	
				

				<div class="col-md-12" style="margin-top:-10px;">
				<hr>
				<div>

				<div class="col-md-12" >
				
				<h5>BESCHREIBUNG</h5>
				<hr>
					<p><?echo strip_tags($desc,'<div><span><p><iframe><embed>[embed]');?>
					<hr>
					
				</div>
				
				</div>
				
					
				<div class="row">
				<div class="col-md-12">
					<div class="boxes-title">
						<span><i class="icon-location"></i></span>
						<h5>KARTE</h5>
					</div>
					
				<?
					$map=explode(";",$map);
					?>

				<iframe width="100%" height="400" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.com/maps?q=<?echo $maplat;?>,<?echo $maplong;?>&hl=en&ie=UTF8&&z=12&output=embed">
				</iframe>
				<div class="onsale alt pull-right"><span><?echo $ref;?></span><?echo $price;?></div>
				</div>
				</div>

<hr>

				<div class="row">
				<div class="col-md-12">

	<div class="smart-wrap">
    	<div class="smart-forms smart-container wrap-2">
        
        	<div class="form-header header-primary">
            	<h4><i class="fa fa-envelope"></i> KONTAKT - <?echo $ref;?></h4>
            </div><!-- end .form-header section -->
            
            <form method="post" action="/sforms/php/smartprocess.php" id="smart-form">
            
            	<div class="form-body">
                

                	<div class="frm-row">

                        <div class="section colm colm6">
                        <label for="guestname" class="field prepend-icon">
                            <input type="text" name="guestname" id="guestname" class="gui-input" placeholder="Name">
                            <label class="field-icon"><i class="fa fa-user"></i></label>  
                        </label>
                        </div><!-- end section -->					
					
                        <div class="section colm colm6">
                            <label for="guestemail" class="field prepend-icon">
                                <input type="email" name="guestemail" id="guestemail" class="gui-input" placeholder="E-Mail">
                                <label class="field-icon"><i class="fa fa-envelope"></i></label>  
                            </label>
                        </div><!-- end section -->
                        
                        <div class="section colm colm6">
                            <label for="guestelephone" class="field prepend-icon">
                                <input type="tel" name="guestelephone" id="guestelephone" class="gui-input" placeholder="Phone">
                                <label class="field-icon"><i class="fa fa-phone-square"></i></label>  
                            </label>
                        </div><!-- end section -->

                        <div class="section colm colm6">
                            <label for="guestfax" class="field prepend-icon">
                                <input type="text" name="guestfax" id="guestfax" class="gui-input" placeholder="Fax">
                                <label class="field-icon"><i class="fa fa-phone-square"></i></label>  
                            </label>
                        </div><!-- end section -->						
						
                    </div><!-- end .frm-row section --> 
                    
                        
                	<div class="section">
                    	<label for="comment" class="field prepend-icon">
                        	<textarea class="gui-textarea" id="comment" name="comment" placeholder="Message"></textarea>
                            <label class="field-icon"><i class="fa fa-comments"></i></label>
   
                        </label>
                    </div><!-- end section -->
					
    
                	<div class="section">

                    </div><!-- end section --> 
					
                    
                	<div class="section">
                        <div class="smart-widget sm-left sml-120">
                            <label for="securitycode" class="field">
                                <input type="text" name="securitycode" id="securitycode" class="gui-input sfcode" placeholder="Security code">
                            </label>
                            <label for="securitycode" class="button captcode">
                            	<img src="/sforms/php/captcha.php" id="captcha" alt="Captcha"/>
                                <span class="refresh-captcha"><i class="fa fa-refresh"></i></span>
                            </label>
                        </div><!-- end .smart-widget section --> 
                    </div><!-- end section -->
                    
                   <div class="result"></div><!-- end .result  section -->                                         
                 

                <div class="form-footer">
					<input type="hidden" name="objektid" value="<?echo $ref;?>">
					<input type="hidden" name="objekttitle" value="<?echo $title;?>">
					<input type="hidden" name="objektprice" value="<?echo $price;?>">
					
					<a href="javascript:history.go(-1)"><span class="button  button-left pull-left" style="float:right;width:200px;">  Go Back  </span></a>
                	<button type="submit" class="button btn-primary" style="float:right;width:200px;">  SEND  </button>
                </div><!-- end .form-footer section -->
            </form>

				</div>
				
				</div>
			</div>
		</div>
	</div>
</div>

</section>
<!-- end Content -->
<div class="sponsors" style="height:50px;">

</div>

<!-- Footer -->
<?include "footer2.php"?>
<!-- end Footer --> 


<!-- ******************************************************************** -->
<!-- ************************* Javascript Files ************************* -->
<!-- jQuery -->
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>window.jQuery || document.write("<script src=\"js/vendors/jquery-1.9.1.min.js\"")</script>

<!-- Respond.js media queries for IE8 -->
<script src="js/vendors/respond.min.js"></script>

<!-- Bootstrap-->
<script src="js/vendors/bootstrap.min.js" ></script>

<!-- Retina.js -->
<script src="js/vendors/retina.js" ></script>

<!-- Placeholder.js -->
<!--[if lte IE 9]> <script src="js/vendors/placeholder.js" ></script> <script>Placeholder.init();</script> <![endif]-->

<!-- Owl Carousel -->
<script src="js/vendors/owl.carousel.min.js" ></script>

<!-- Range Slider -->
<script src="js/vendors/bootstrap-slider.js" ></script>


<script src="js/vendors/jquery/jquery.galleriffic.js" ></script>
  

<!-- Custom -->
<script src="js/fotorama.js"></script>		
<script src="js/script.js"  ></script>

	<script type="text/javascript" src="/sforms/js/jquery.form.min.js"></script>
	<script type="text/javascript" src="/sforms/js/jquery.validate.min.js"></script>
	<script type="text/javascript">
	<!--
	var $j = jQuery.noConflict();
	$j(function() {
			   
				/* @reload captcha
				------------------------------------------- */			   
				function reloadCaptcha(){
					$j("#captcha").attr("src","/sforms/php/captcha.php?r=" + Math.random());
				}
				
				$j('.captcode').click(function(e){
					e.preventDefault();
					reloadCaptcha();
				});				   
			   

				/* @ validation and submition
				---------------------------------- */				
				$j( "#smart-form" ).validate({
											
						errorClass: "state-error",
						validClass: "state-success",
						errorElement: "em",
						onkeyup: false,
						onclick: false,						
						rules: {
								guestname: {
										required: true,
										minlength: 2
								},		
								guestemail: {
										required: true,
										email: true
								},
								guestfax: {
										required: false,
								},								
								comment:{
										required:true,
										minlength: 5
								},
								securitycode:{
										required:true
								}								
						},
						messages:{
								guestname: {
										required: 'Please fill in your name.',
										minlength: 'Please fill in your name.'
								},				
								guestemail: {
										required: 'Please fill in your email address.',
										email: 'Please fill in your email address.'
								},
								comment: {
										required: 'Please enter your message',
										minlength: 'Please enter your message'
								},
								securitycode:{
										required: 'Enter security code here before submitting the form (case sensitive)'
								}								
						},
						highlight: function(element, errorClass, validClass) {
								$j(element).closest('.field').addClass(errorClass).removeClass(validClass);
						},
						unhighlight: function(element, errorClass, validClass) {
								$j(element).closest('.field').removeClass(errorClass).addClass(validClass);
						},
						errorPlacement: function(error, element) {
						   if (element.is(":radio") || element.is(":checkbox")) {
									element.closest('.option-group').after(error);
						   } else {
									error.insertAfter(element.parent());
						   }
						},				
						submitHandler:function(form) {
							$j(form).ajaxSubmit({
									target:'.result',			   
									beforeSubmit:function(){ 
											$j('.form-footer').addClass('progress');
									},
									error:function(){
											$j('.form-footer').removeClass('progress');
									},
									 success:function(){
											$j('.form-footer').removeClass('progress');
											$j('.alert-success').show().delay(10000).fadeOut();
											$j('.field').removeClass("state-error, state-success");
											if( $j('.alert-error').length == 0){
												$j('#smart-form').resetForm();
												reloadCaptcha();
											}
									 }
							  });
						}
						
				});		
		
	});				
    
	//-->
	</script>	

<!-- *********************** End Javascript Files *********************** -->
<!-- ******************************************************************** -->


</body>
</html>