<?php
//echo "<pre>";
//print_r($_REQUEST);
//print_r($_SERVER);
//session_start();
//echo "</pre>";
include_once "config.php";
include_once "lib/common.lib.php";
require_once "lib/main.php";
require_once "lib/dbmysql.class.php";
require_once 'lib/awt_tpl.class.php';

$template_file = 'main-rss.tpl.html';
$error_message = '';
$content_type = '';
$where_house="";
$default_category = 'commercial-property-for-rent';
$category = array();
$not_found = 0;
    
$tpl = new AwtTpl();
$db = new DbMySQL(DB_HOST, DB_NAME, DB_USER, DB_PWD);
$db->connect();

$sql = "SELECT h.ID,url_path,path1,status_type,`type`,`status`,address,city,state,zip,last_update,created_date 
FROM realty h  WHERE h.created_date>CURDATE()-INTERVAL 1 DAY AND h.url_path IS NOT NULL AND path1 IS NOT NULL ORDER BY last_update DESC LIMIT 100";

$houses = $db->select($sql);
if(!$houses){
        $sql = "SELECT h.ID,url_path,path1,status_type,`type`,`status`,address,city,state,zip,last_update,created_date 
        FROM realty h  WHERE DATE(h.created_date)=DATE(h.last_update) AND h.url_path IS NOT NULL AND path1 IS NOT NULL ORDER BY last_update DESC LIMIT 100";
        $houses = $db->select($sql);
}

$tpl->assign("houses",    $houses);
$tpl->display($template_file);
?>