<?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 url_path,path,`status`,use_type,address,city,state,last_update,created_date FROM realty h INNER JOIN content_category c ON h.ID=c.houses_id WHERE h.created_date>CURDATE()-INTERVAL 1 DAY AND h.url_path IS NOT NULL ORDER BY last_update DESC";
$houses = $db->select($sql);
if(!$houses){
	$sql = "SELECT url_path,path,`status`,use_type,address,city,state,last_update,created_date FROM realty h INNER JOIN content_category c ON h.ID=c.houses_id WHERE date(h.created_date)=date(h.last_update) AND h.url_path IS NOT NULL ORDER BY last_update DESC LIMIT 100";
	$houses = $db->select($sql);
}

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