<?
function equisg($xx1,$yy1)
{
if  ($xx1 > 206 || $yy1 > 114)
    { 
		 if ($xx1 > $yy1) 
		  {
			$chicopor1 = $yy1*114;
			$division1 = $chicopor1/$xx1;
			$yy1= $division1;
			$xx1= 206;
		   }		
		 else
		   {  $chicopor1 = $xx1*206;
			$division1 = $chicopor1/$yy1;
			$xx1= $division1;
			$yy1= 114;		
			}
	 }
 else    
	 { $yy1= $yy1;
		   $xx1= $xx1;
     }	
	 return $xx1;
}  
function yesg($xx1,$yy1)
{
if  ($xx1 > 206 || $yy1 > 114)
    { 
		 if ($xx1 > $yy1) 
		  {
			$chicopor1 = $yy1*114;
			$division1 = $chicopor1/$xx1;
			$yy1= $division1;
			$xx1= 206;
		   }		
		 else
		   {  $chicopor1 = $xx1*206;
			$division1 = $chicopor1/$yy1;
			$xx1= $division1;
			$yy1= 114;		
			}
	 }
 else    
	 { $yy1= $yy1;
		   $xx1= $xx1;
     }	
	 return $yy1;
}

  function conectar() 
{ 
	$base_de_datos = "villas";
	$db_usuario = "villas"; 
	$db_password = "680107"; 
	
	//$base_de_datos = "villas";
	//$db_usuario = "root"; 
	//$db_password = ""; 
	 
	
	//if (!($link = mysql_connect("localhost", $db_usuario, $db_password))) 
	if (!($link = mysql_connect("localhost", $db_usuario, $db_password))) 
	{ 
		echo "Error conectando a la base de datos."; 
		exit(); 
	} 
	if (!mysql_select_db($base_de_datos, $link)) 
	{ 
		echo "Error seleccionando la base de datos."; 
		exit(); 
	} 
	return $link; 
}

 function obtenervilla ($vreg)
{
    $sql = "SELECT * FROM villa WHERE top_villa = '1'  LIMIT ".$vreg.", 1";
	$resultados = mysql_query($sql);
    $corri=mysql_fetch_array($resultados);	
	
	$clave= $corri["id_villa"];
	$nombre= $corri["nombre"];
	
	mysql_free_result($resultados);
}


$db = conectar();
$numero = rand(50,100);
$nombre = "";

$sqlte = "SELECT * FROM villa WHERE top_villa = '1'  ";
$resultadoi= mysql_query($sqlte);
$total_registros = mysql_num_rows($resultadoi);
//echo $total_registros;
$numero1 = rand(0,$total_registros - 1);
$hayvt= "1";
if ($total_registros >= "3" )
{   
	 do {
		 $numero2 = rand(0,$total_registros - 1);
		 if ($numero2 <> $numero1) {
			 
			 break;
			 }
		 else
		 {	 
		   $numero2 = rand(0,$total_registros - 1);
			
		 }
	 } while (0);
	
	$numero3 = rand(0,$total_registros - 1);
	 do {
		 
		 if ($numero3 <> $numero1  && $numero3 <> $numero2 ) {
			 break;
			 }
		 else
		 {	 
		   $numero3 = rand(0,$total_registros - 1);
			
		 }
	 } while (0);
	
	
	// primera villa
		$sql = "SELECT * FROM villa WHERE top_villa = '1'  LIMIT ".$numero1.", 1";
		$resultados = mysql_query($sql);
		$corri=mysql_fetch_array($resultados);	
		
		$nombre1= $corri["nombre"];
		$tarifaxn1= $corri["tarifaxn"];
		$tarifae1= $corri["tarifae"];
		$id1= $corri["id"];
		
		if (trim($corri["imagen1"]) <> ".")
		 { $imagen1 = "fotos/".$corri["imagen1"]; 
		   $h = $corri["iw1"]; 
		   $w = $corri["ih1"];
		 }
		   else  
		 {  
		   $imagen1="images/sinfoto.gif";
		   $w= "154";
		   $h= "212";		   
		 }
		
		 $h1= yesg($w,$h);
		 $w1= equisg($w,$h);
																		
		
		$sql = "SELECT * FROM villa WHERE top_villa = '1'  LIMIT ".$numero2.", 1";
		$resultados = mysql_query($sql);
		$corri=mysql_fetch_array($resultados);	
		
		$nombre2= $corri["nombre"];
		$tarifaxn2= $corri["tarifaxn"];
		$tarifae2= $corri["tarifae"];
		$id2= $corri["id"];
		
		if (trim($corri["imagen1"]) <> ".")
		 { $imagen2 = "fotos/".$corri["imagen1"]; 
		   $h = $corri["iw1"]; 
		   $w = $corri["ih1"];
		 }
		   else  
		 {  
		   $imagen2="images/sinfoto.gif";
		   $w= "154";
		   $h= "212";		   
		 }
		
		 $h2= yesg($w,$h);
		 $w2= equisg($w,$h);
		
		
		$sql = "SELECT * FROM villa WHERE top_villa = '1'  LIMIT ".$numero3.", 1";
		$resultados = mysql_query($sql);
		$corri=mysql_fetch_array($resultados);	
		
		$nombre3= $corri["nombre"];
		$tarifaxn3= $corri["tarifaxn"];
		$tarifae3= $corri["tarifae"];
		$id3= $corri["id"];
		
		if (trim($corri["imagen1"]) <> ".")
		 { $imagen3 = "fotos/".$corri["imagen1"]; 
		   $h = $corri["iw1"]; 
		   $w = $corri["ih1"];
		 }
		   else  
		 {  
		   $imagen3="images/sinfoto.gif";
		   $w= "154";
		   $h= "212";		   
		 }
		
		 $h3= yesg($w,$h);
		 $w3= equisg($w,$h);
		
		
		mysql_free_result($resultados);

}
else
{
   $hayvt= "0";
}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Acapulco Villas Pacific</title>
<script src="js/prototype.js" type="text/javascript"></script>
<script src="js/scriptaculous.js" type="text/javascript"></script>
<script src="js/controlPagina.js" type="text/javascript"></script>
<script src="js/escribirflash.js" type="text/javascript"></script>
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<link href="css/estilos.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.ar1 {	font-family: Arial;
	color: #333;
	font-size: 12px;
}
.ar1 {	color: #20A7C4;
	text-align: justify;
	font-family: Arial;
}
.ar1txt21 {	font-family: Arial;
	font-size: 12px;
}
.ar1txt21 {	text-align: justify;
}
.style19 {color: #666666}
.style21 {
	color: #666666;
	font-weight: bold;
}
-->
</style>
<script type="text/javascript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body onload="MM_preloadImages('images/bt_promoup.jpg','images/bt_skype2.jpg','images/bt_facebook3.jpg','images/bt_twiter02.jpg','images/bt_villas02.jpg','images/btn_condos02.jpg','images/bt_search02.jpg')">
<script language="JavaScript" type="text/javascript">
<!--
function valida() {
  if (document.fmain.destino.value == "0" )
	{
    alert ("Select value for destination" );
  }
  else
  {
   
   if (document.fmain.vista.value == "0" )
	{
	   alert ("Select value for location" );
    }
	else
   {
    
	document.fmain.action="resultados.php"
	document.fmain.submit();
	
    }
  };
  		
}

</script>
<form id="fmain" name="fmain" action="validaalta.php" method="get">
<table width="700" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center"><a href="index.php"><img src="images/bt_home.jpg" width="127" height="45" border="0" /></a><a href="aboutus.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image24','','images/bt_about02.jpg',1)"><img src="images/bt_about.jpg" name="Image24" width="224" height="45" border="0" id="Image24" /></a><a href="ourvillas.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image21','','images/bt_villas02.jpg',1)"><img src="images/bt_villas.jpg" name="Image21" width="187" height="45" border="0" id="Image21" /></a><a href="ourcondos.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image22','','images/bt_condos02.jpg',1)"><img src="images/bt_condos.jpg" name="Image22" width="199" height="45" border="0" id="Image22" /></a><a href="contactus.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image26','','images/bt_contacus2.jpg',1)"><img src="images/bt_contacus.jpg" name="Image26" width="211" height="45" border="0" id="Image26" /></a></div></td>
</tr>
<tr>
<td><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><script>escribirFlash("swf/intro.swf", "647", "200","top");</script></td>
<td><img src="images/bt_acapulcovillas.jpg" /></td>
</tr>
</table></td>
</tr>
<tr>
<td><img src="images/bt_lineasnaranja.jpg" width="955" height="13" /></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top" bgcolor="#FFFFFF"><div id="colIzquierda">
<div id="buscador">
<fieldset>
<label for="Destinations">Destinations:</label>
<label>
<select name="destino" id="destino">
<option value="0">--Select --</option>
<option value="1">Acapulco</option>
<option value="2">Ixtapa</option>
<option value="3">Zihuatanejo</option>
<option value="4">Cancún</option>
<option value="5">Playa del carmen</option>
<option value="6">Puerto vallarta</option>
</select>
<input type="hidden" name="pagina" value="1" />
</label>
<label for="Location">View:</label>
<label>
<select name="vista" id="vista">
<option value="0">--Select --</option>
<option value="1">Beach Front</option>
<option value="2">Ocean View</option>
</select>
</label>
<div class="radioBtn">
<input name="tipo" type="radio" id="tipo1" value="1" checked="checked" />
Villa</div>
<div class="radioBtn">
<input type="radio" name="tipo" id="tipo2" value="2" />
Condo</div>
<div class="radioBtn">
<input type="radio" name="tipoc" id="tipo3" value="1" />
Luxury</div>
<div class="radioBtn">
<input type="radio" name="tipoc" id="tipo4" value="2" checked="checked" />
Standard</div>
<div id="tit"></div>
<div class="etiqueta">Bedrooms</div>
<div class="selectForm">
<select name="recamaras" id="recamaras">
<option value="0">--Any--</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
</select>
</div>
<div class="etiqueta">Occupancy</div>
<div class="selectForm">
<select name="banos" id="banos">
<option value="0">--Any--</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
</select>
</div>
<div id="search"><img src="images/bt_search01.jpg" alt name="Image23" width="58" height="15" border="0" id="searchImage" onclick="valida();" onmouseover="MM_swapImage('Image23','','images/bt_search02.jpg',1)" onmouseout="MM_swapImgRestore()" /></div>
</fieldset>
</div>
<div id="bannersIzq"><table width="212" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><a href="./promos.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image12','','images/bt_promoup.jpg',1)"><img src="images/bt_promocs.jpg" name="Image12" width="212" height="204" border="0" id="Image12" /></a></td>
</tr>
<tr>
<td width="223" height="102"><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image4','','images/bt_skype2.jpg',1)"><img src="images/bt_skype.jpg" name="Image4" width="212" height="102" border="0" id="Image4" /></a></td>
</tr>
<tr>
<td height="113" background="images/fondo_facebook.jpg"><table width="120" border="0" align="center" cellpadding="0" cellspacing="5">
<tr>
<td><div align="center"><a href="https://www.facebook.com/pages/Acapulco-Villas-Pacific/157879614247822" target="_blank" onmouseover="MM_swapImage('Image5','','images/bt_facebook3.jpg',1)" onmouseout="MM_swapImgRestore()"><img src="images/bt_facebook1.jpg" name="Image5" width="89" height="32" border="0" id="Image5" /></a></div>
<div align="center"></div></td>
</tr>
<tr>
<td><div align="center"><a href="https://twitter.com/#!/VillasPacific" target="_blank" onmouseover="MM_swapImage('Image6','','images/bt_twiter02.jpg',1)" onmouseout="MM_swapImgRestore()"><img src="images/bt_twiter.jpg" name="Image6" width="115" height="21" border="0" id="Image6" /></a></div></td>
</tr>
</table></td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
</table></div>
</div>
</td>
<td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" background="images/fondocondos.jpg">
<tr>
<td><img src="images/tit_ourcondos.jpg" width="726" height="61" /></td>
</tr>
<tr>
<td align="center"><blockquote>
<blockquote>
<p class="ar1txt21"><span class="ar1"><br/>
</span></p>
<p class="style17"><span class="style19"><em><strong>&ldquo;The Luxury Villa and Condo Rentals Expert&rdquo;</strong></em></span> <br/>
<br/>
<br/>
</p>
<table width="100" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><a href="http://acapulcovillaspacific.com/resultados.php?destino=0&amp;pagina=1&amp;vista=0&amp;tipo=2&amp;tipoc=&amp;recamaras=0&amp;banos=0" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image14','','images/btn_condos02.jpg',1)"><img src="images/btn_condos01.jpg" name="Image14" width="156" height="38" border="0" id="Image14" /></a></td>
</tr>
</table>
<p class="ar1txt21">&nbsp;</p>
<p class="ar1txt21">&nbsp;</p>
<p class="ar1txt21">&nbsp;</p>
<p class="ar1txt21">&nbsp;</p>
<p class="ar1txt21">&nbsp;</p>
<p class="ar1txt21">&nbsp;</p>
<p class="ar1txt21">&nbsp;</p>
<p class="ar1txt21">&nbsp;</p>
<p class="ar1txt21">&nbsp;</p>
<p class="ar1txt21"><strong><br/>
</strong> </p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<blockquote>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</blockquote>
</blockquote>
</blockquote></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2"><div id="contactoFooter">
<div align="center"><span class="style11">Tel:+52 (11) 55 1500 9100 Ext. 1100 | Cell Phone: +52 (11) 55 4803 2796&nbsp; <br/>
&nbsp; Copyright &copy; 2010 Acapulco Villas Pacific. All Rights Reserved.</span></div>
</div></td>
</tr>
</table></td>
</tr>
</table>
</form>
</body>
</html>