include("include/escape.php");?>
include("include/all.php");?>
include("include/lang.php");?>
$k = GetKey();
$ID = toGet($_GET['ID'], $_POST['ID']);
$miSend = toGet($_GET['miSend'], $_POST['miSend']);
$AddList = toGet($_GET['AddList'], $_POST['AddList']);
$Action = toGet($_GET['Action'], $_POST['Action']);
$ip = getenv(REMOTE_ADDR);
mysql_query("insert into t_visitors (PageType, IP, EstateID) values('Estate', '".$ip."', '".$ID."')");
if ($miSend != '') {
switch($Action) {
case 'AddList' :
if (!isset($_COOKIE['AddList'])) {
if (IsHave("Select * from t_add_list where EstateID='".$ID."' and CookieID='".session_id()."'") == 0) {
$sql = "insert into t_add_list (EstateID, CookieID, ADate) values ('".$ID."', '".session_id()."', '".date("Y-m-d H:i:s")."')";
mysql_query($sql);
setcookie("AddList", session_id(), time()+360000000);
header("Location: advert_detail.php?ID=".$ID."");
}
} else {
if (IsHave("Select * from t_add_list where EstateID='".$ID."' and CookieID='".$_COOKIE['AddList']."'") == 0) {
$sql = "insert into t_add_list (EstateID, CookieID, ADate) values ('".$ID."', '".$_COOKIE['AddList']."', '".date("Y-m-d H:i:s")."')";
mysql_query($sql);
}
}
break;
}
}
?>
$sql = "select * from t_advert where ID='".$ID."'";
$qrPageInfo = mysql_query($sql);
$rsPageInfo = mysql_fetch_array($qrPageInfo);
?>
include("top.php");?>
include("left.php");?>
$sql = "select *,
(select t_properties.Name from t_advert, t_properties where t_advert.CityID=t_properties.ID and t_advert.ID='".$ID."') as estate_city,
(select t_properties.Name from t_advert, t_properties where t_advert.TownShipID=t_properties.ID and t_advert.ID='".$ID."') as estate_township,
(select t_properties.Name from t_advert, t_properties where t_advert.EstateStatus=t_properties.ItemID and t_properties.PageType='EstateStatus' and t_properties.PageLang='".$_SESSION['Lang']."' and t_advert.ID='".$ID."') as estate_status,
(select t_properties.Name from t_advert, t_properties where t_advert.EstateType=t_properties.ItemID and t_properties.PageType='EstateType' and t_properties.PageLang='".$_SESSION['Lang']."' and t_advert.ID='".$ID."') as estate_type,
(select t_properties.Name from t_advert, t_properties where t_advert.WarmingSystem=t_properties.ItemID and t_properties.PageType='WarmingSystem' and t_properties.PageLang='".$_SESSION['Lang']."' and t_advert.ID='".$ID."') as estate_warming_system,
(select t_properties.Name from t_advert, t_properties where t_advert.Ground=t_properties.ItemID and t_properties.PageType='Ground' and t_properties.PageLang='".$_SESSION['Lang']."' and t_advert.ID='".$ID."') as estate_ground,
(select t_properties.Name from t_advert, t_properties where t_advert.RoomType=t_properties.ItemID and t_properties.PageType='RoomType' and t_properties.PageLang='".$_SESSION['Lang']."' and t_advert.ID='".$ID."') as estate_room_type,
(select t_properties.Name from t_advert, t_properties where t_advert.FlatItem=t_properties.ItemID and t_properties.PageType='FlatItem' and t_properties.PageLang='".$_SESSION['Lang']."' and t_advert.ID='".$ID."') as estate_flat_item,
(select t_properties.Name from t_advert, t_properties where t_advert.CurrentFlat=t_properties.ItemID and t_properties.PageType='CurrentFlat' and t_properties.PageLang='".$_SESSION['Lang']."' and t_advert.ID='".$ID."') as estate_current_flat,
(select t_advert_images.Images from t_advert, t_advert_images where t_advert.ID=t_advert_images.ParentID and t_advert.ID='".$ID."' order by Seq asc LIMIT 0,1) as estate_images
from t_advert where ID='".$ID."'
";
$qrAdProperty = mysql_query($sql);
$rsProperty = mysql_fetch_array($qrAdProperty);
?>