include_once("common.inc.php");
$strFileName = "cotagessea_rent.php";
$lngCottageType = 2;
$CountryId = getParam('CountryId');
$CottCityId = getParam('CottCityId');
if (!empty($CountryId) && is_numeric($CountryId)) {
if (!empty($CottCityId) && is_numeric($CottCityId)) {
$strTitle = "Недвижимость " . $arrCitySecondName["$CottCityId"] . ", аренда недвижимости " . $arrCountrySecondName["$CountryId"];
$strTit2 = "Аренда недвижимости " . $arrCitySecondName["$CottCityId"];
$strTit3 = "Недвижимость " . $arrCitySecondName["$CottCityId"] . ", аренда недвижимости " . $arrCitySecondName["$CottCityId"];
$strKeywords = $strTitle . " " . $arrCityName["$CottCityId"] . " " . $arrCountryName["$CountryId"];
$strDescription = "Агентство недвижимости 'Аренда в Европе'";
}
else {
$strTitle = "Недвижимость " . $arrCountrySecondName["$CountryId"] . ", аренда недвижимости " . $arrCountrySecondName["$CountryId"];
$strTit2 = "Недвижимость " . $arrCountrySecondName["$CountryId"] . ", аренда недвижимости " . $arrCountrySecondName["$CountryId"];
$strTit3 = "Недвижимость " . $arrCountrySecondName["$CountryId"];
$strKeywords = $strTitle;
$strDescription = $strTitle . " | Агентство недвижимости 'Аренда в Европе'";
}
}
else
{
$strTitle = "Аренда недвижимости";
$strTit2 = "Аренда жилья";
$strTit3 = "Недвижимость";
$strKeywords = "недвижимость жилье аренда";
$strDescription = "Агентство недвижимости 'Аренда в Европе'";
}
//$strKeywords = $strTitle . " " . $arrCityName["$CottCityId"] . " " . $arrCountryName["$CountryId"];
//$strDescription = $strTitle . " | Агентство недвижимости 'Аренда в Европе'";
//$strAlt = $strTitle;
include_once("./header.inc.php");
?>
|
 |
|
// Pagination
$lngRecordsPerPage = 8;
$lngPagesLimit = 11;
$strWhere = " where tblcity.id='1' and tblcity.id=tblagency.CityId and tblagency.id=tblcottagerent.AgencyId and tblcottagerent.boolCottageStatus='1' and tblcottagerent.lngCottageType='" . $lngCottageType . "'";
if (!empty($CountryId) && is_numeric($CountryId)) {
$strWhere = $strWhere . " and tblcottagerent.CountryId = '" . $CountryId . "' ";
}
if (!empty($CottCityId) && is_numeric($CottCityId)) {
$strWhere = $strWhere . " and tblcottagerent.LocationId = '" . $CottCityId . "' ";
}
$sql = "select count(tblcottagerent.id) as count_id from tblcottagerent, tblagency, tblcity $strWhere ";
$paginationInfo = getPaginationCatalog ($sql, $strFileName, $lngRecordsPerPage, $lngPagesLimit, array("CountryId" => $CountryId, "CottCityId" => $CottCityId ) );
//! Pagination
$sql = "select tblcottagerent.* from tblcottagerent, tblagency, tblcity $strWhere order by tblcottagerent.curCottagePrice asc limit $paginationInfo[lngStartLimit], $lngRecordsPerPage ";
$result = query($sql);
if ( '' != $CountryId ) { ?>Страны : Все страны | | Все города
}
else {
$boolContinue = 1;
echo '';
while ($boolContinue)
{
echo "";
for ($j = 1; $j <= 4; $j++)
{
list($ingCountries, $NameCountries) = each($arrTableCountry);
echo '';
}
echo '
';
}
echo '
';
}
if (!empty($CountryId) && is_numeric($CountryId)) {
if ( count($arrCity["$CountryId"]) > 0 && $CountryId != "1" )
{
$boolContinue = 1;
?>
while ($boolContinue)
{
?>
for ($j = 1; $j <= 4; $j++)
{
list($ingCity, $arrNameCities ) = each($arrTableCity["$CountryId"]);
?>
}
?>
}
?>
}
}
?>
if ("1 " != $paginationInfo["strPagination"]) { ?>
}
require_once 'Mobile_Detect.php';
$detect = new Mobile_Detect;
if($detect->isMobile() && !$detect->isTablet()) {
$i = 1;
while($row = fetch_array($result)) {
?>
include ("./table.inc.nedv.php");?> |
}
} else {
?>
$c = 0;
while($row = fetch_array($result)) {
?>
include ("./table.inc.nedv.php");?> |
|
$c++;
if($c%2 == 0) echo '
';
}
?>
}
?>
if ("1 " != $paginationInfo["strPagination"]) { ?>
}
// информация о стране
/*
if (!empty($CountryId) && "" == getParam('lngPage')) {
$strTableName = "tblinfocountry";
//$strWhere = "where lngNewsType IN (" . join(",", array_keys($arrNewsType)) . ") and dteNewsAdd < NOW() ";
$strWhere = "where CountryId ='" . $CountryId . "' and boolArticleStatus = '1' ";
$sql = "select * from $strTableName $strWhere order by dteArticleAdd desc limit 5";
$resultInfo = query ($sql);
if ( mysql_num_rows($resultInfo) > 0 ) { ?>
Информация о недвижимости : |
 |
while ($rowInfo = mysql_fetch_assoc ( $resultInfo) ) {
$shortContent = nl2br($rowInfo['strArticleShortContent']);
?>
} ?>
|
}
} */
if ("" != $arrcontent1["$CountryId"][0] && "" == $arrQueryInfo['lngPage']) {
//$strShortContent = nl2br($arrcontent2["$CountryId"]["$TypeId"]);
echo $arrcontent1["$CountryId"][0] . "
";
}
include_once("./footer.inc.php");
?>